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.

[image: image.png]

[image: image.png]

Yes I have no issues connecting via SSH with Putty. And no issues
connecting with DataGrip (screenshots below)

[image: image.png]

[image: image.png]

On Wed, Sep 5, 2018 at 12:21 AM Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
wrote:

> 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(at)gmail(dot)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](at)[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-9517Mobile: +91 976-788-8246*
>