Обсуждение: Cant browse servers after update to pgadmin 1.6 (server version)
Вложения
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.zabuawala@
enterprisedb.com]
Sent: 19 July 2017 13:14
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)
Can you please open browser developer tool 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@surcouf.co.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.zabuawala@
enterprisedb.com]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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@surcouf.co.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.zabuawala@
enterprisedb.com]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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@surcouf.co.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>
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.zabuawala@enterprisedb.com]
Sent: 19 July 2017 13:27
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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?
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf <mikes@surcouf.co.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.zabuawala@enterprisedb.com]
Sent: 19 July 2017 13:14
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)
Can you please open browser developer tool 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@surcouf.co.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.zabuawala@enterprisedb.com]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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@surcouf.co.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.zabuawala@enterprisedb.com]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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@surcouf.co.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>
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.zabuawala@
enterprisedb.com]
Sent: 19 July 2017 13:27
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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?
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf <mikes@surcouf.co.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.zabuawala@
enterprisedb.com]
Sent: 19 July 2017 13:14
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)
Can you please open browser developer tool 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@surcouf.co.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.zabuawala@
enterprisedb.com]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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@surcouf.co.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.zabuawala@
enterprisedb.com]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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@surcouf.co.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>
Okay, I think this is a bug with 1.6.
--Regards,On Wed, Jul 19, 2017 at 6:03 PM, Mike Surcouf <mikes@surcouf.co.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.zabuawala@ente
rprisedb.com]
Sent: 19 July 2017 13:27
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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?
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf <mikes@surcouf.co.uk> wrote:
wcDocker.min.js:42 exported wcDocker
jquery-1.11.2.min.js:4 GET http://aesdata01/preferences/g
et_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/stor
e 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/stor
e 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.zabuawala@ente
rprisedb.com]
Sent: 19 July 2017 13:14
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)
Can you please open browser developer tool 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@surcouf.co.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.zabuawala@ente
rprisedb.com]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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@surcouf.co.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.zabuawala@ente
rprisedb.com]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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 ~/.pgad
min/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@surcouf.co.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/brows er/__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>
On Wed, Jul 19, 2017 at 6:10 PM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote: Okay, I think this is a bug with 1.6.So, as per this RM information, you can change the WSGIScriptAlias from /pgadmin4 to / to fix this issue.
--Regards,On Wed, Jul 19, 2017 at 6:03 PM, Mike Surcouf <mikes@surcouf.co.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.zabuawala@ente
rprisedb.com]
Sent: 19 July 2017 13:27
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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?
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf <mikes@surcouf.co.uk> wrote:
wcDocker.min.js:42 exported wcDocker
jquery-1.11.2.min.js:4 GET http://aesdata01/preferences/g
et_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/stor
e 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/stor
e 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.zabuawala@ente
rprisedb.com]
Sent: 19 July 2017 13:14
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)
Can you please open browser developer tool 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@surcouf.co.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.zabuawala@ente
rprisedb.com]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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@surcouf.co.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.zabuawala@ente
rprisedb.com]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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 ~/.pgad
min/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@surcouf.co.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/brows er/__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>
It’s all to do with paths far as I can see.
Its likely DESKTOP works because the default path is the root of the webserver.
And as that bug report states if I run the app in the root of my site I guess it will work.
It seems 1.6 is broken out the box which recommends pgadmin4 as the app path.
Presumably the code does not account for the app path in a few places.
Not sure how this wasn’t picked up though.
Is devrim@gunduz.org testing these repos by installing in the app path eg (pgadmin4) as per the docs?
From: Murtuza Zabuawala [mailto:murtuza.zabuawala@enterprisedb.com]
Sent: 19 July 2017 13:41
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)
Okay, I think this is a bug with 1.6.
Found similar issue: https://redmine.postgresql.org/issues/2563
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Wed, Jul 19, 2017 at 6:03 PM, Mike Surcouf <mikes@surcouf.co.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.zabuawala@enterprisedb.com]
Sent: 19 July 2017 13:27
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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?
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf <mikes@surcouf.co.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.zabuawala@enterprisedb.com]
Sent: 19 July 2017 13:14
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)
Can you please open browser developer tool 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@surcouf.co.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.zabuawala@enterprisedb.com]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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@surcouf.co.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.zabuawala@enterprisedb.com]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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@surcouf.co.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>
A have the same issue after update to 1.6, pgadmin is under apache web server. The console developer browser throws 404 on these resources because may site is under pgadmin directory not on the server root:
http://dev.pgpadmin/preferences/get_all
http://dev.pgpadmin/browser/nodes/
http://dev.pgpadmin/settings/store
http://dev.pgpadmin/misc/bgprocess/
http://dev.pgpadmin/settings/store
Al those folders are under ../pgadmin/web/pgadmin/(preferences, browser, settings, misc)
Is there any way to solve that?
Where is the line in the code to change that?
Regards.
De: Murtuza Zabuawala [mailto:murtuza.zabuawala@enterprisedb.com]
Enviado el: miércoles, 19 de julio de 2017 08:55 a. m.
Para: Khushboo Vashi
CC: Mike Surcouf; pgadmin-support@postgresql.org
Asunto: Re: Cant browse servers after update to pgadmin 1.6 (server version)
On Wed, Jul 19, 2017 at 6:16 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:
On Wed, Jul 19, 2017 at 6:10 PM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.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.
Yes, This is a work around.
But we also have to fix this issue at code level to honour the virtual DirectoryRoot path :)
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Wed, Jul 19, 2017 at 6:03 PM, Mike Surcouf <mikes@surcouf.co.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.zabuawala@enterprisedb.com]
Sent: 19 July 2017 13:27
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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?
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf <mikes@surcouf.co.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.zabuawala@enterprisedb.com]
Sent: 19 July 2017 13:14
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: Cant browse servers after update to pgadmin 1.6 (server version)
Can you please open browser developer tool 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@surcouf.co.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.zabuawala@enterprisedb.com]
Sent: 19 July 2017 13:03
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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@surcouf.co.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.zabuawala@enterprisedb.com]
Sent: 19 July 2017 12:45
To: Mike Surcouf
Cc: pgadmin-support@postgresql.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@surcouf.co.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>
