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

Поиск
Список
Период
Сортировка
От Mike Surcouf
Тема RE: Cant browse servers after update to pgadmin 1.6 (server version)
Дата
Msg-id 2197768425D7F5479A0FFB3FEC212F7FF5F002D0@aesmail.surcouf.local
обсуждение исходный текст
Ответ на Re: Cant browse servers after update to pgadmin 1.6 (server version)  (Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>)
Ответы Re: Cant browse servers after update to pgadmin 1.6 (server version)  (Devrim Gündüz <devrim@gunduz.org>)
Список pgadmin-support

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.

 

 

--

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?

 

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@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>

 

 

 

 

 

В списке pgadmin-support по дате отправления:

Предыдущее
От: Murtuza Zabuawala
Дата:
Сообщение: Re: Cant browse servers after update to pgadmin 1.6 (server version)
Следующее
От: Dave Page
Дата:
Сообщение: Re: uninstalling pgadmin4 version 1.0