Re: pgAdmin 4 v1.6 Released!

Hi

On Fri, Jul 21, 2017 at 9:52 PM, Pawel Hadam <hadzio(at)gmail(dot)com> wrote:

> Hi Dave,
>
> I have only 2 versions of pgAdmin4.exe:
>
> $ find . -name "pgAdmin4.exe"
> ./Program Files/PostgreSQL/9.6/pgAdmin 4/bin/pgAdmin4.exe
> ./Program Files (x86)/pgAdmin 4/v1/runtime/pgAdmin4.exe
>
> The first one is definitely v1.3 and works well when started by running
> the exec itself.
>
> When installer started v1.6, the process was pointing to the second exec.
>
> When I start the second exec from cygwin bash it starts v1.6 - what is
> good, and a kind of a workaround and a kind of a hint, as well. So I added
> to the shortcut "Run as administrator" and now it starts v1.6 correctly. So
> the issue is solved - thank you Dave!
>

Well, that's good, but I really like to get to the bottom of things :-)

>
> But where is the v1.5 that starts from the "non-administrator" shortcut,
> that's another question...
>

You could try searching for files containing one of these lines:

APP_REVISION = 5
APP_VERSION_INT = 15001

That should (I hope) find the config.py that is setup for 1.5.

>
> Thanks and regards
> Pawel
>
>
> On 21 July 2017 at 09:27, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
>> Hi
>>
>> On Fri, Jul 21, 2017 at 7:14 AM, Pawel Hadam <hadzio(at)gmail(dot)com> wrote:
>>
>>> Hi Dave,
>>>
>>> I do have pgAdmin4 v.1.3 (not v1.5) installed with
>>> postgresql-9.6.2-3-windows-x64.exe - and it works well when started
>>> directly from its own folder.
>>>
>>> I suspect, that those two environments may disturb each other, but
>>> cannot see see how.
>>>
>>
>> No, they're designed to be completely independent. The only thing they
>> would share would be registry settings for zoom level and geometry.
>>
>>
>>>
>>> Also:
>>> 1) when v1.6 launched from the installer it works well.
>>> 2) when v1.6 launched from a shortcut it starts v1.5.
>>>
>>
>> What does the shortcut point to for the working directory? If you run it,
>> then press Alt+Shift+P, are there any settings shown?
>>
>>
>>> 3) When I check from program manager, both 1) and 2) run the same
>>> "pgAdmin 4\v1\runtime\pgAdmin4.exe" executable from v1.6 installation path.
>>>
>>> I will do some checks on another PC today.
>>>
>>> Thank you and kind regards
>>> Pawel
>>>
>>>
>>> On 21 July 2017 at 00:28, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>
>>>> You don't have the PostgreSQL installer from EDB or BigSQL on that
>>>> machine do you? They have their own separate copies of pgAdmin.
>>>>
>>>> Sent from my iPad
>>>>
>>>> On 20 Jul 2017, at 23:53, Pawel Hadam <hadzio(at)gmail(dot)com> wrote:
>>>>
>>>> Thank you Dave,
>>>>
>>>> Full clean-up (all folders and registry) and fresh installation helps
>>>> once. On the last screen I select to Launch pgAdmin4 and v1.6 starts
>>>> correctly and I can use it. I need to say it is very nice.
>>>>
>>>> 2017-07-20 23:42:17,891: INFO pgadmin: Starting pgAdmin 4 v1.6...
>>>>
>>>>
>>>> However, when I exit and launch it again, it starts again.... v1.5 in
>>>> the server mode and the log files say the same and it still cannot connect
>>>> to the server:
>>>>
>>>> 2017-07-20 23:43:56,013: INFO pgadmin: Starting pgAdmin 4 v1.5...
>>>>
>>>>
>>>> Please see attached config files from C:\Program Files (x86)\pgAdmin
>>>> 4\v1\web\
>>>> and log files from C:\Users\pawelhadam\AppData\Roaming\pgAdmin\
>>>>
>>>>
>>>> I have no idea where v1.5 is still sitting on my PC :( I must be doing
>>>> something stupid, I am afraid.
>>>>
>>>>
>>>> Thanks in advance for any more help and kind regards
>>>> Pawel
>>>>
>>>>
>>>> On 19 July 2017 at 09:12, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>>
>>>>> [Narrowing the addressee list]
>>>>>
>>>>> Hi
>>>>>
>>>>> On Tue, Jul 18, 2017 at 11:14 PM, Pawel Hadam <hadzio(at)gmail(dot)com>
>>>>> wrote:
>>>>>
>>>>>> Hi Dave,
>>>>>>
>>>>>> Thank you for this advise.
>>>>>>
>>>>>> Please find attached my files:
>>>>>>
>>>>>> 1) C:\Users\pawelhadam\AppData\Roaming\pgAdmin\pgadmin4.log
>>>>>>
>>>>>> I cannot understand why this log file says "Starting pgAdmin 4
>>>>>> v1.5..." as I have installed v1.6 from pgadmin4-1.6-x86.exe
>>>>>>
>>>>>
>>>>> That certainly screams of 'messed up installation'. It gets that
>>>>> number from config.py.
>>>>>
>>>>>
>>>>>>
>>>>>> 2) C:\Program Files (x86)\pgAdmin 4\v1\web\config_local.py
>>>>>>
>>>>>
>>>>> I'm surprised it even works with that - it looks like a direct copy of
>>>>> config.py, and if you look at the end is basically importing itself.
>>>>>
>>>>> Please uninstall pgAdmin, and ensure C:\Program Files (x86)\pgAdmin 4
>>>>> is completely removed. I would also suggest removing %APPDATA%\pgAdmin as
>>>>> well (note that will delete your config database so you'll have to re-add
>>>>> any registered servers).
>>>>>
>>>>> Then, using regedit.exe, remove the registry key:
>>>>> HKEY_CURRENT_USER\Software\pgadmin\pgadmin4
>>>>>
>>>>> Once the system is completely cleaned, try a fresh installation.
>>>>>
>>>>> Regards, Dave.
>>>>>
>>>>>
>>>>>>
>>>>>> Thank you and kind regards
>>>>>> Pawel
>>>>>>
>>>>>>
>>>>>> On 17 July 2017 at 09:36, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Fri, Jul 14, 2017 at 1:58 PM, Pawel Hadam <hadzio(at)gmail(dot)com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Thank you Dave and Khushboo for advises.
>>>>>>>>
>>>>>>>> 1) (re)moving 'pgadmin4.db' - did not help.
>>>>>>>>
>>>>>>>> 2) I have disabled teredo - did not help.
>>>>>>>>
>>>>>>>> 3) localhost is resolved to IPv6 address:
>>>>>>>>
>>>>>>>> $ ping localhost
>>>>>>>>
>>>>>>>> Pinging ogrodowa [::1] with 32 bytes of data:
>>>>>>>> Reply from ::1: time<1ms
>>>>>>>> Reply from ::1: time<1ms
>>>>>>>> Reply from ::1: time<1ms
>>>>>>>> Reply from ::1: time<1ms
>>>>>>>>
>>>>>>>> 4) I DO use IPv4 as well.
>>>>>>>>
>>>>>>>> 5) No entries for localhost in hosts file.
>>>>>>>>
>>>>>>>> 6) On which address/port the server should be listening?
>>>>>>>>
>>>>>>>> $ netstat -a | grep LISTEN | grep "127.0.0.1"
>>>>>>>> TCP 127.0.0.1:3212 ogrodowa:0 LISTENING
>>>>>>>> TCP 127.0.0.1:3213 ogrodowa:0 LISTENING
>>>>>>>> TCP 127.0.0.1:4370 ogrodowa:0 LISTENING
>>>>>>>> TCP 127.0.0.1:4371 ogrodowa:0 LISTENING
>>>>>>>> TCP 127.0.0.1:4380 ogrodowa:0 LISTENING
>>>>>>>> TCP 127.0.0.1:4381 ogrodowa:0 LISTENING
>>>>>>>> TCP 127.0.0.1:5037 ogrodowa:0 LISTENING
>>>>>>>> TCP 127.0.0.1:9990 ogrodowa:0 LISTENING
>>>>>>>> TCP 127.0.0.1:30000 ogrodowa:0 LISTENING
>>>>>>>> TCP 127.0.0.1:49674 ogrodowa:0 LISTENING
>>>>>>>>
>>>>>>>> 7) ping to 127.0.0.1 works well:
>>>>>>>>
>>>>>>>> $ ping 127.0.0.1
>>>>>>>>
>>>>>>>> Pinging 127.0.0.1 with 32 bytes of data:
>>>>>>>> Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
>>>>>>>> Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
>>>>>>>> Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
>>>>>>>> Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
>>>>>>>>
>>>>>>>>
>>>>>>>> Not sure what else I need to check...
>>>>>>>>
>>>>>>>
>>>>>>> In the web/ subdirectory of the installation, you should find a file
>>>>>>> called config.py. Please create a file called config_local.py in the same
>>>>>>> directory, containing the following lines (excluding the ==== lines) :
>>>>>>>
>>>>>>> ====
>>>>>>> from config import *
>>>>>>>
>>>>>>> # Debug mode
>>>>>>> DEBUG = True
>>>>>>>
>>>>>>> # Log
>>>>>>> CONSOLE_LOG_LEVEL = DEBUG
>>>>>>> FILE_LOG_LEVEL = DEBUG
>>>>>>> ====
>>>>>>>
>>>>>>> Then, try to start pgAdmin. That should create a more useful logfile
>>>>>>> in %APPDATA%\pgAdmin to share with us.
>>>>>>>
>>>>>>> Thanks.
>>>>>>>
>>>>>>> --
>>>>>>> Dave Page
>>>>>>> Blog: http://pgsnake.blogspot.com
>>>>>>> Twitter: @pgsnake
>>>>>>>
>>>>>>> EnterpriseDB UK: http://www.enterprisedb.com
>>>>>>> The Enterprise PostgreSQL Company
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Dave Page
>>>>> Blog: http://pgsnake.blogspot.com
>>>>> Twitter: @pgsnake
>>>>>
>>>>> EnterpriseDB UK: http://www.enterprisedb.com
>>>>> The Enterprise PostgreSQL Company
>>>>>
>>>>
>>>> <config.py>
>>>>
>>>> <pgadmin4.log>
>>>>
>>>> <config_distro.py>
>>>>
>>>> <config_local.py>
>>>>
>>>>
>>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company