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

On Wed, Jul 19, 2017 at 6:16 PM, Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)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(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>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>