Hi Dave, Thank you. Unfortunately I cannot find those entries:
pawelhadam@ogrodowa ~ $ find /cygdrive/c -type f -name "con*py" | xargs grep "APP_REVISION" 2> /dev/null pawelhadam@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@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 <dp...@pgadmin.org> wrote: > Hi > > On Fri, Jul 21, 2017 at 9:52 PM, Pawel Hadam <had...@gmail.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 <dp...@pgadmin.org> wrote: >> >>> Hi >>> >>> On Fri, Jul 21, 2017 at 7:14 AM, Pawel Hadam <had...@gmail.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 <dp...@pgadmin.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 <had...@gmail.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 <dp...@pgadmin.org> wrote: >>>>> >>>>>> [Narrowing the addressee list] >>>>>> >>>>>> Hi >>>>>> >>>>>> On Tue, Jul 18, 2017 at 11:14 PM, Pawel Hadam <had...@gmail.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 <dp...@pgadmin.org> wrote: >>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Fri, Jul 14, 2017 at 1:58 PM, Pawel Hadam <had...@gmail.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 >
