Обсуждение: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64

Platform

Windows 7 sp1 x64 + windows update

Steps to repro

1.      Install 1.4 from here
https://www.postgresql.org/ftp/pgadmin/pgadmin4/v1.4/windows/
2.      Click on Start menu pgAdmin shortcut
3.      Hangs on splash screen.
4.      Uninstall
5.      Install 1.3 from here
https://www.postgresql.org/ftp/pgadmin/pgadmin4/v1.3/windows/
6.      Click on Start menu pgAdmin shortcut
7.      It works.
8.      The try installing 1.4 on top of 1.3
9.      Click on Start menu pgAdmin shortcut
10.     Hangs on splash screen again
11.     Uninstall 1.4 and install 1.3 again
12.     It works again.

Seems I am stuck at 1.3.

I did look at that.

the log was 0 bytes when running  1.4

It didn’t seem to get as far as the first log entry just hanging on splash screen.

 

I also used process monitor to see if it was hitting a permissions issue.

I also have 3 versions of visual studio installed so that may complicate the environment.

I am installing as administrator for use by non admin user.

 

Sorry I know the above is not much to go on.

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 08 May 2017 14:12
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64

 

 

 

On Mon, May 8, 2017 at 1:54 PM, Mike Surcouf <mikes@surcouf.co.uk> wrote:

Platform

Windows 7 sp1 x64 + windows update

Steps to repro

1.      Install 1.4 from here
https://www.postgresql.org/ftp/pgadmin/pgadmin4/v1.4/windows/
2.      Click on Start menu pgAdmin shortcut
3.      Hangs on splash screen.
4.      Uninstall
5.      Install 1.3 from here
https://www.postgresql.org/ftp/pgadmin/pgadmin4/v1.3/windows/
6.      Click on Start menu pgAdmin shortcut
7.      It works.
8.      The try installing 1.4 on top of 1.3
9.      Click on Start menu pgAdmin shortcut
10.     Hangs on splash screen again
11.     Uninstall 1.4 and install 1.3 again
12.     It works again.

Seems I am stuck at 1.3.

 

 Odd - it works for me on the same platform. Is there a log file left in %APPDATA%\pgAdmin (and if so, can you send it)? You may need to remove the 1.3 log first.

 

--

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

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

Ø  Can you send the output please? Might give a hint as to how far it's getting.

 

 

Here is the PML file process monitor log from sysinternals.  I could sen csv but it would be very hard to read.

Its large so I google drived it I hope that is not against mailing list policy.

 

https://drive.google.com/file/d/0B2LyR0P94T3FTlFFelhabV9EdFk/view?usp=sharing

 

Ø  Does it run from the admin account you installed it under?

 

No it runs as a separate user.  This does work for 1.4 though.

I also tried running everything under administrator and that prodced same results.

 

Ø  Also, long shot but is there anything in the event logs?

 

As suspected nothing there

IPv4 oNly I am behind a proxy for browsing  and also have machine wide httpproxy set using

netsh winhttp import proxy source=ie

No direct access to Internet.

What is the port and ip of the ping?

Is pgadmin server component listening on IPv6 as well or only IPv4.  Windows will always return IPv6 look back address for localhost if both are available apparently.

Disabling proxy in IE  does fix this.

However I cant do this as I lose internet access.

Adding localhost or 127..0.0.1 to bypass lsit doesn’t work either.

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 09 May 2017 21:06
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64

 

 

 

On Tue, May 9, 2017 at 9:02 PM, Mike Surcouf <mikes@surcouf.co.uk> wrote:

IPv4 oNly I am behind a proxy for browsing  and also have machine wide httpproxy set using

 

netsh winhttp import proxy source=ie

 

No direct access to Internet.

 

What is the port and ip of the ping?

 

Hmm, OK. It connects to "localhost", but the port number is random for both security reasons and to support multiple users on the same machine.

 

If you disable the proxy server temporarily, does that fix it? 

 

--

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

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

I cant find any combination of exceptions that works

I have wireshark but it doesn’t show anything that uses loopback interface L