Re: pgAdmin 4 v1.6 Released!

Hi Dave,

Thank you. Unfortunately I cannot find those entries:

pawelhadam(at)ogrodowa ~
$ find /cygdrive/c -type f -name "con*py" | xargs grep "APP_REVISION" 2>
/dev/null

pawelhadam(at)ogrodowa ~
$ find /cygdrive/c -type f -name "conf*py" | xargs grep "APP_VERSION_INT"
2> /dev/null

But I have found the following "config.py" files:

pawelhadam(at)ogrodowa ~
$ find /cygdrive/c -type f -name "config.py"
/cygdrive/c/cygwin64/home/pawelhadam/pythonpostgresql/PycharmProjects/intro-to-databases/venv/Lib/site-packages/setuptools/config.py
/cygdrive/c/cygwin64/lib/python2.7/distutils/command/config.py
/cygdrive/c/cygwin64/lib/python2.7/distutils/config.py
/cygdrive/c/cygwin64/lib/python2.7/logging/config.py
/cygdrive/c/cygwin64/lib/python3.4/distutils/command/config.py
/cygdrive/c/cygwin64/lib/python3.4/distutils/config.py
/cygdrive/c/cygwin64/lib/python3.4/logging/config.py
/cygdrive/c/DataStaxDDC/python/Lib/distutils/command/config.py
/cygdrive/c/DataStaxDDC/python/Lib/distutils/config.py
/cygdrive/c/DataStaxDDC/python/Lib/logging/config.py
/cygdrive/c/Program Files/JetBrains/PyCharm Community Edition
2017.1.3/helpers/coveragepy/coverage/config.py
/cygdrive/c/Program Files/JetBrains/PyCharm Community Edition
2017.1.3/helpers/pycharm/nose_helper/config.py
/cygdrive/c/Program Files/PostgreSQL/9.6/pgAdmin
4/venv/Lib/distutils/command/config.py
/cygdrive/c/Program Files/PostgreSQL/9.6/pgAdmin
4/venv/Lib/distutils/config.py
/cygdrive/c/Program Files/PostgreSQL/9.6/pgAdmin
4/venv/Lib/logging/config.py
/cygdrive/c/Program Files/PostgreSQL/9.6/pgAdmin
4/venv/Lib/site-packages/flask/config.py
/cygdrive/c/Program Files/PostgreSQL/9.6/pgAdmin
4/venv/Lib/site-packages/setuptools/config.py
/cygdrive/c/Program Files/PostgreSQL/9.6/pgAdmin
4/venv/Lib/site-packages/sqlalchemy/testing/config.py
/cygdrive/c/Program Files/PostgreSQL/9.6/pgAdmin 4/web/config.py
/cygdrive/c/Program Files (x86)/pgAdmin
4/v1/venv/Lib/distutils/command/config.py
/cygdrive/c/Program Files (x86)/pgAdmin 4/v1/venv/Lib/distutils/config.py
/cygdrive/c/Program Files (x86)/pgAdmin 4/v1/venv/Lib/logging/config.py
/cygdrive/c/Program Files (x86)/pgAdmin
4/v1/venv/Lib/site-packages/alembic/config.py
/cygdrive/c/Program Files (x86)/pgAdmin
4/v1/venv/Lib/site-packages/alembic/testing/config.py
/cygdrive/c/Program Files (x86)/pgAdmin
4/v1/venv/Lib/site-packages/flask/config.py
/cygdrive/c/Program Files (x86)/pgAdmin
4/v1/venv/Lib/site-packages/setuptools/config.py
/cygdrive/c/Program Files (x86)/pgAdmin
4/v1/venv/Lib/site-packages/sqlalchemy/testing/config.py
/cygdrive/c/Program Files (x86)/pgAdmin 4/v1/web/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK/android-ndk-r10e/prebuilt/windows/lib/python2.7/distutils/command/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK/android-ndk-r10e/prebuilt/windows/lib/python2.7/distutils/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK/android-ndk-r10e/prebuilt/windows/lib/python2.7/logging/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK/android-ndk-r11c/prebuilt/windows/lib/python2.7/distutils/command/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK/android-ndk-r11c/prebuilt/windows/lib/python2.7/distutils/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK/android-ndk-r11c/prebuilt/windows/lib/python2.7/logging/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK/android-ndk-r11c/sources/cxx-stl/llvm-libc++/libcxx/test/libcxx/android/test/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK/android-ndk-r11c/sources/cxx-stl/llvm-libc++/libcxx/test/libcxx/ndk/test/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK/android-ndk-r11c/sources/cxx-stl/llvm-libc++/libcxx/test/libcxx/test/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK/android-ndk-r11c/sources/cxx-stl/llvm-libc++abi/libcxxabi/test/libcxxabi/test/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK64/android-ndk-r10e/prebuilt/windows-x86_64/lib/python2.7/distutils/command/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK64/android-ndk-r10e/prebuilt/windows-x86_64/lib/python2.7/distutils/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK64/android-ndk-r10e/prebuilt/windows-x86_64/lib/python2.7/logging/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK64/android-ndk-r11c/prebuilt/windows-x86_64/lib/python2.7/distutils/command/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK64/android-ndk-r11c/prebuilt/windows-x86_64/lib/python2.7/distutils/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK64/android-ndk-r11c/prebuilt/windows-x86_64/lib/python2.7/logging/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK64/android-ndk-r11c/sources/cxx-stl/llvm-libc++/libcxx/test/libcxx/android/test/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK64/android-ndk-r11c/sources/cxx-stl/llvm-libc++/libcxx/test/libcxx/ndk/test/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK64/android-ndk-r11c/sources/cxx-stl/llvm-libc++/libcxx/test/libcxx/test/config.py
/cygdrive/c/ProgramData/Microsoft/AndroidNDK64/android-ndk-r11c/sources/cxx-stl/llvm-libc++abi/libcxxabi/test/libcxxabi/test/config.py
/cygdrive/c/Python27/Lib/distutils/command/config.py
/cygdrive/c/Python27/Lib/distutils/config.py
/cygdrive/c/Python27/Lib/logging/config.py
/cygdrive/c/Users/pawelhadam/.windows-build-tools/python27/Lib/distutils/command/config.py
/cygdrive/c/Users/pawelhadam/.windows-build-tools/python27/Lib/distutils/config.py
/cygdrive/c/Users/pawelhadam/.windows-build-tools/python27/Lib/logging/config.py
/cygdrive/c/Users/pawelhadam/AppData/Local/Programs/Python/Python35/Lib/distutils/command/config.py
/cygdrive/c/Users/pawelhadam/AppData/Local/Programs/Python/Python35/Lib/distutils/config.py
/cygdrive/c/Users/pawelhadam/AppData/Local/Programs/Python/Python35/Lib/logging/config.py
/cygdrive/c/Users/pawelhadam/AppData/Local/Programs/Python/Python36-32/Lib/distutils/command/config.py
/cygdrive/c/Users/pawelhadam/AppData/Local/Programs/Python/Python36-32/Lib/distutils/config.py
/cygdrive/c/Users/pawelhadam/AppData/Local/Programs/Python/Python36-32/Lib/idlelib/config.py
/cygdrive/c/Users/pawelhadam/AppData/Local/Programs/Python/Python36-32/Lib/logging/config.py
/cygdrive/c/Users/pawelhadam/AppData/Local/VirtualStore/Program Files
(x86)/pgAdmin 4/v1/web/config.py

I wonder what else I can provide to help?

Thanks and regards
Pawel

On 21 July 2017 at 21:56, Dave Page <dpage(at)pgadmin(dot)org> wrote:

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