Re: Cant browse servers after update to pgadmin 1.6 (server version)

On Wed, Jul 19, 2017 at 6:10 PM, Murtuza Zabuawala <
murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:

> Okay, I think this is a bug with 1.6.
>
> Found similar issue: https://redmine.postgresql.org/issues/2563
>
>
So, as per this RM information, you can change the WSGIScriptAlias from
*/pgadmin4* to */* to fix this issue.

>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> On Wed, Jul 19, 2017 at 6:03 PM, Mike Surcouf <mikes(at)surcouf(dot)co(dot)uk> wrote:
>
>> Still the same
>>
>>
>>
>> Tested in IE 11 and CHrome
>>
>>
>>
>> Am I picking up a early webpack preview from the repo?
>>
>>
>>
>> All I did was a yum update
>>
>>
>>
>> It seems there paths for require are not correct (missing a level pgadm4)
>>
>>
>>
>>
>>
>>
>>
>> *From:* Murtuza Zabuawala [mailto:murtuza(dot)zabuawala(at)enterprisedb(dot)com]
>> *Sent:* 19 July 2017 13:27
>> *To:* Mike Surcouf
>> *Cc:* pgadmin-support(at)postgresql(dot)org
>> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
>> version)
>>
>>
>>
>> Can you clear the browser cache with hard reset and try again?
>>
>>
>>
>> [image: Inline image 1]
>>
>>
>>
>> --
>>
>> Regards,
>>
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>>
>> On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf <mikes(at)surcouf(dot)co(dot)uk>
>> wrote:
>>
>> wcDocker.min.js:42 exported wcDocker
>>
>> jquery-1.11.2.min.js:4 GET http://aesdata01/preferences/get_all 404 (Not
>> Found)
>>
>> send @ jquery-1.11.2.min.js:4
>>
>> ajax @ jquery-1.11.2.min.js:4
>>
>> cache_preferences @ browser.js:953
>>
>> init @ browser.js:357
>>
>> (anonymous) @ (index):280
>>
>> execCb @ require.min.js:29
>>
>> check @ require.min.js:18
>>
>> (anonymous) @ require.min.js:23
>>
>> (anonymous) @ require.min.js:8
>>
>> (anonymous) @ require.min.js:23
>>
>> v @ require.min.js:7
>>
>> emit @ require.min.js:23
>>
>> check @ require.min.js:19
>>
>> (anonymous) @ require.min.js:23
>>
>> (anonymous) @ require.min.js:8
>>
>> (anonymous) @ require.min.js:23
>>
>> v @ require.min.js:7
>>
>> emit @ require.min.js:23
>>
>> check @ require.min.js:19
>>
>> (anonymous) @ require.min.js:23
>>
>> (anonymous) @ require.min.js:8
>>
>> (anonymous) @ require.min.js:23
>>
>> v @ require.min.js:7
>>
>> emit @ require.min.js:23
>>
>> check @ require.min.js:19
>>
>> (anonymous) @ require.min.js:23
>>
>> (anonymous) @ require.min.js:8
>>
>> (anonymous) @ require.min.js:23
>>
>> v @ require.min.js:7
>>
>> emit @ require.min.js:23
>>
>> check @ require.min.js:19
>>
>> enable @ require.min.js:23
>>
>> init @ require.min.js:17
>>
>> E @ require.min.js:14
>>
>> completeLoad @ require.min.js:28
>>
>> onScriptLoad @ require.min.js:29
>>
>> jquery-1.11.2.min.js:4 GET http://aesdata01/browser/nodes/ 404 (Not
>> Found)
>>
>> send @ jquery-1.11.2.min.js:4
>>
>> ajax @ jquery-1.11.2.min.js:4
>>
>> (anonymous) @ jquery.aciTree.min.js:17
>>
>> k @ jquery.aciTree.min.js:17
>>
>> (anonymous) @ jquery.aciTree.min.js:17
>>
>> jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not
>> Found)
>>
>> send @ jquery-1.11.2.min.js:4
>>
>> ajax @ jquery-1.11.2.min.js:4
>>
>> save_current_layout @ browser.js:342
>>
>> (anonymous) @ browser.js:403
>>
>> __trigger @ wcDocker.min.js:34
>>
>> __moveEnd @ wcDocker.min.js:34
>>
>> jquery-1.11.2.min.js:4 POST http://aesdata01/settings/store 404 (Not
>> Found)
>>
>> send @ jquery-1.11.2.min.js:4
>>
>> ajax @ jquery-1.11.2.min.js:4
>>
>> save_current_layout @ browser.js:342
>>
>> (anonymous) @ browser.js:403
>>
>> __trigger @ wcDocker.min.js:34
>>
>> __moveEnd @ wcDocker.min.js:34
>>
>>
>>
>> *From:* Murtuza Zabuawala [mailto:murtuza(dot)zabuawala(at)enterprisedb(dot)com]
>> *Sent:* 19 July 2017 13:14
>> *To:* Mike Surcouf
>> *Cc:* pgadmin-support(at)postgresql(dot)org
>> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
>> version)
>>
>>
>>
>> Can you please open browser developer tool
>> <https://developer.chrome.com/devtools> and check the Console tab if
>> there is any error on console when you load the page?
>>
>>
>>
>>
>>
>>
>>
>> --
>>
>> Regards,
>>
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>>
>> On Wed, Jul 19, 2017 at 5:40 PM, Mike Surcouf <mikes(at)surcouf(dot)co(dot)uk>
>> wrote:
>>
>> BTW I disabled upgrade check
>>
>>
>>
>> UPGRADE_CHECK_ENABLED = False
>>
>>
>>
>> in config.py
>>
>>
>>
>> The
>>
>>
>>
>> URLError: <urlopen error [Errno 101] Network is unreachable>
>>
>> error is now gone but I still have no nodes in my browser pane and the
>> add a server link doesn’t work
>>
>>
>>
>> Thanks
>>
>>
>>
>> Mike
>>
>>
>>
>>
>>
>> *From:* Murtuza Zabuawala [mailto:murtuza(dot)zabuawala(at)enterprisedb(dot)com]
>> *Sent:* 19 July 2017 13:03
>> *To:* Mike Surcouf
>> *Cc:* pgadmin-support(at)postgresql(dot)org
>> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
>> version)
>>
>>
>>
>> Are you running pgAdmin4 on Apache or any other server?
>>
>> (If so then can you try restarting your apache or respective web server
>> service as well)
>>
>>
>>
>>
>>
>> On Wed, Jul 19, 2017 at 5:25 PM, Mike Surcouf <mikes(at)surcouf(dot)co(dot)uk>
>> wrote:
>>
>> Same thing.
>>
>>
>>
>> In the end I deleted everything in
>>
>>
>>
>> /var/pgadmin/.pgadmin
>>
>>
>>
>> then ran
>>
>>
>>
>> su -s /bin/sh -c 'python /usr/lib/python2.7/site-packag
>> es/pgadmin4-web/setup.py' pgadmin
>>
>>
>>
>> Still no nodes in the browser pane
>>
>>
>>
>> *From:* Murtuza Zabuawala [mailto:murtuza(dot)zabuawala(at)enterprisedb(dot)com]
>> *Sent:* 19 July 2017 12:45
>> *To:* Mike Surcouf
>> *Cc:* pgadmin-support(at)postgresql(dot)org
>> *Subject:* Re: Cant browse servers after update to pgadmin 1.6 (server
>> version)
>>
>>
>>
>> Hi,
>>
>>
>>
>> It looks like you pgAdmin4 configuration file got corrupted.
>>
>> Can you rename your pgAdmin4 configuration file and try to start pgAdmin4
>> again?
>>
>>
>>
>> mv ~/.pgadmin/pgadmin4.db ~/.pgadmin/pgadmin4.db_old
>>
>>
>>
>>
>>
>> --
>>
>> Regards,
>>
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>>
>> On Wed, Jul 19, 2017 at 5:08 PM, Mike Surcouf <mikes(at)surcouf(dot)co(dot)uk>
>> wrote:
>>
>> package pgadmin4-v1-web.noarch 1.6-2.rhel7
>> After update of the above package from 1.5 I now see no nodes in the
>> browser column soI cant do anything.
>>
>> sample of my error log
>>
>> [Wed Jul 19 12:31:13.159426 2017] [:error] [pid 1428] URLError: <urlopen
>> error [Errno 101] Network is unreachable>
>> [Wed Jul 19 12:31:15.904561 2017] [:error] [pid 1428] 2017-07-19
>> 12:31:15,904: ERROR\tpgadmin:\tException when checking for update
>> [Wed Jul 19 12:31:15.904576 2017] [:error] [pid 1428] Traceback (most
>> recent call last):
>> [Wed Jul 19 12:31:15.904579 2017] [:error] [pid 1428] File
>> "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/browser/__init__.py",
>> line 482, in index
>> [Wed Jul 19 12:31:15.904582 2017] [:error] [pid 1428] response =
>> urlreq.urlopen(url, data, 5)
>> [Wed Jul 19 12:31:15.904584 2017] [:error] [pid 1428] File
>> "/usr/lib64/python2.7/urllib2.py", line 154, in urlopen
>> [Wed Jul 19 12:31:15.904587 2017] [:error] [pid 1428] return
>> opener.open(url, data, timeout)
>> [Wed Jul 19 12:31:15.904589 2017] [:error] [pid 1428] File
>> "/usr/lib64/python2.7/urllib2.py", line 431, in open
>> [Wed Jul 19 12:31:15.904591 2017] [:error] [pid 1428] response =
>> self._open(req, data)
>> [Wed Jul 19 12:31:15.904594 2017] [:error] [pid 1428] File
>> "/usr/lib64/python2.7/urllib2.py", line 449, in _open
>> [Wed Jul 19 12:31:15.904596 2017] [:error] [pid 1428] '_open', req)
>> [Wed Jul 19 12:31:15.904599 2017] [:error] [pid 1428] File
>> "/usr/lib64/python2.7/urllib2.py", line 409, in _call_chain
>> [Wed Jul 19 12:31:15.904617 2017] [:error] [pid 1428] result =
>> func(*args)
>> [Wed Jul 19 12:31:15.904620 2017] [:error] [pid 1428] File
>> "/usr/lib64/python2.7/urllib2.py", line 1258, in https_open
>> [Wed Jul 19 12:31:15.904622 2017] [:error] [pid 1428]
>> context=self._context, check_hostname=self._check_hostname)
>> [Wed Jul 19 12:31:15.904625 2017] [:error] [pid 1428] File
>> "/usr/lib64/python2.7/urllib2.py", line 1214, in do_open
>> [Wed Jul 19 12:31:15.904627 2017] [:error] [pid 1428] raise
>> URLError(err)
>> [Wed Jul 19 12:31:15.904629 2017] [:error] [pid 1428] URLError: <urlopen
>> error [Errno 101] Network is unreachable>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>