Thread: [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. Thanks Mike
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.
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
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
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
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
Thanks
Mike
From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 09 May 2017 08:55
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 4:19 PM, Mike Surcouf <mikes@surcouf.co.uk> wrote:
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.
Urgh.
I also used process monitor to see if it was hitting a permissions issue.
Can you send the output please? Might give a hint as to how far it's getting.
I also have 3 versions of visual studio installed so that may complicate the environment.
I also have multiple versions installed, so I don't expect that to be an issue.
I am installing as administrator for use by non admin user.
Does it run from the admin account you installed it under?
Also, long shot but is there anything in the event logs?
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
--
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
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
hello there. I have the same issue : Windows 7 64 This is a new computer (i'm new in my company) so this is my first install of pgadmin on this machine. The pgadmin4.log file is also empty for me. The splash screen is displayed, then pgadmin CPU usage fall to 0, its cpu counter do not move. same problem if launched as admin On this machine i have installed : VS 2017 community edition Visual code i am behind a proxy that often blocks any uncommon port... no problem with pgadmin 3 1.22 + some other common stuffs. -- View this message in context: http://www.postgresql-archive.org/pgAdmin-1-4-on-Windows-7-x64-tp5960347p5960574.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
On Tue, May 9, 2017 at 12:03 PM, Mike Surcouf <mikes@surcouf.co.uk> wrote:Ø 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
OK, this doesn't show much (thanks though). I suspect where it's getting stuck is a check the client makes to ensure the server thread is running and serving requests. Essentially it has a "ping" REST API that the runtime will keep calling until it gets a response. Once it does, it'll hide the splash screen and display the main window. There was a bug in this check which I fixed in 1.4 if memory serves.So, I wonder if there's something in your network setup that's preventing it from responding as expected. What is in your hosts file? Do you have IPv4 enabled? What about other protocols?Thanks.--Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
IPv4 oNly I am behind a proxy for browsing and also have machine wide httpproxy set usingnetsh winhttp import proxy source=ieNo direct access to Internet.What is the port and ip of the ping?
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Regards
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 usingnetsh winhttp import proxy source=ieNo 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
Regards
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 usingnetsh winhttp import proxy source=ieNo 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
On Tue, May 9, 2017 at 9:02 PM, Mike Surcouf <[hidden email]> wrote:IPv4 oNly I am behind a proxy for browsing and also have machine wide httpproxy set usingnetsh winhttp import proxy source=ieNo 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 CompanyIf you reply to this email, your message will be added to the discussion below:http://www.postgresql-archive.org/pgAdmin-1-4-on-Windows-7- x64-tp5960347p5960614.html
View this message in context: Re: pgAdmin 1.4 on Windows 7 x64
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
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.
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
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
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
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
Note you have to square bracket ipv6
tried
[::1]
[[::1:]
[::1];127.0.0.1
127.0.0.1
From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 10 May 2017 09:33
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64
On Wed, May 10, 2017 at 9:32 AM, Mike Surcouf <mikes@surcouf.co.uk> wrote:
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.
Interesting. What about adding ::1 to bypass?
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
--
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
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
I have wireshark but it doesn’t show anything that uses loopback interface L
From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 11 May 2017 08:17
To: Mike Surcouf
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] pgAdmin 1.4 on Windows 7 x64
On Wed, May 10, 2017 at 10:14 AM, Mike Surcouf <mikes@surcouf.co.uk> wrote:
I cant find any combination of exceptions that works
:-(
Any chance you can install Wireshark and see if that gives any clues about what is happening?
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
I have wireshark but it doesn’t show anything that uses loopback interface L
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company