Re: pgAdmin 4 v1.6 Released!

[Narrowing the addressee list]

Hi

On Tue, Jul 18, 2017 at 11:14 PM, Pawel Hadam <hadzio@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 <dpage@pgadmin.org> wrote:

On Fri, Jul 14, 2017 at 1:58 PM, Pawel Hadam <hadzio@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