Re: pgAdmin Unable to connect to server via SSH Tunnel (nothing in logs)
db server is an Ubuntu 18.04 VM, running on my same machine (Win7) as pgAdmin4, but with an assigned IP address (bridged adapter)
One thing to note, I did verify that pgAdmin would connect if I disabled UFW and didn't use SSH Tunnel.
Yes I have no issues connecting via SSH with Putty. And no issues connecting with DataGrip (screenshots below)
On Wed, Sep 5, 2018 at 12:21 AM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi DavidCan you please provide the following information:
- Your database server and pgAdmin4 running on same machine?
- Provide screenshot of connection and SSH Tunnel tab of the server dialog.
- Will you be able to connect using SSH command from command prompt with same credentials
On Mon, Sep 3, 2018 at 4:37 AM, David A <dangelsaurus@gmail.com> wrote:Using pgAdmin to connect to postgres via SSH Tunnel is giving me the following error.Unable to connect to server:server closed the connection unexpectedlyThis probably means the server terminated abnormallybefore or while processing the request.The only thing in the postgres server log is...2018-09-02 21:56:14.433 UTC [2613] [unknown]@[unknown] LOG: incomplete startup packetAnd the pgadmin4.log2018-09-02 17:19:42,934: INFO pgadmin: Failed to connect to the database server(#2) for connection (DB:postgres) with error message as below:server closed the connection unexpectedlyThis probably means the server terminated abnormallybefore or while processing the request.I have no issues connecting via SSH Tunnel using Datagrip, and I'm using the same credentials\settings in pgAdmin ad DG...I'm at a loss of what to do next to continue troubleshooting, as nothing useful is in the logs.Ubuntu 18.04 running PGSQL 10 on VirtualBoxpgAdmin 4 (3.2) running on Windows 7--Akshay JoshiSr. Software ArchitectPhone: +91 20-3058-9517
Mobile: +91 976-788-8246
Вложения
В списке pgadmin-support по дате отправления: