Re: pgAdmin Unable to connect to server via SSH Tunnel (nothing in logs) - Mailing list pgadmin-support

From Akshay Joshi
Subject Re: pgAdmin Unable to connect to server via SSH Tunnel (nothing in logs)
Date
Msg-id CANxoLDdxNxbCoOp7viE0iisn+bn5VfcX5HyOh1RPndqw1MfjVw@mail.gmail.com
Whole thread Raw
In response to pgAdmin Unable to connect to server via SSH Tunnel (nothing in logs)  (David A <dangelsaurus@gmail.com>)
Responses Re: pgAdmin Unable to connect to server via SSH Tunnel (nothing inlogs)
Re: pgAdmin Unable to connect to server via SSH Tunnel (nothing in logs)
List pgadmin-support
Hi David

Can 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 unexpectedly
This probably means the server terminated abnormally
before 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 packet

And the pgadmin4.log

2018-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 unexpectedly
    This probably means the server terminated abnormally
    before 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 VirtualBox
pgAdmin 4 (3.2) running on Windows 7





--
Akshay Joshi
Sr. Software Architect


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Login form
Next
From: Herman Pool
Date:
Subject: PgAdmin, almost unreadable fonts