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

In addition by pgadmin site is at

http://aesdata01/pgadmin4/

So an HTTP GET to

http://aesdata01/preferences/get_all

will obviously fail

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<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<mailto: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<mailto:murtuza(dot)zabuawala(at)enterprisedb(dot)com>]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-support(at)postgresql(dot)org<mailto: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<mailto: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-packages/pgadmin4-web/setup.py' pgadmin

Still no nodes in the browser pane

From: Murtuza Zabuawala [mailto:murtuza(dot)zabuawala(at)enterprisedb(dot)com<mailto:murtuza(dot)zabuawala(at)enterprisedb(dot)com>]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-support(at)postgresql(dot)org<mailto: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<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<mailto: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>