Re: pgAdmin4 ssh tunnel configuration

I have same issue now. Here is screenshot:
[image: image.png]

and log snippet:

pgadmin.utils.exception.SSHTunnelConnectionLost: Connection to the SSH
Tunnel for host '10.0.7.172' has been lost. Reconnect to the database server
2018-07-02 12:31:29,689: ERROR pgadmin: Connection to the SSH
Tunnel for host '10.0.7.172' has been lost. Reconnect to the database server
Traceback (most recent call last):
File "C:\Program Files (x86)\pgAdmin
4\v3\web\pgadmin\browser\server_groups\servers\__init__.py", line 805, in
create
server_types=ServerType.types()
File "C:\Program Files (x86)\pgAdmin
4\v3\web\pgadmin\utils\driver\psycopg2\connection.py", line 237, in connect
manager.check_ssh_tunnel_alive()
File "C:\Program Files (x86)\pgAdmin
4\v3\web\pgadmin\utils\driver\psycopg2\server_manager.py", line 430, in
check_ssh_tunnel_alive
raise SSHTunnelConnectionLost(self.tunnel_host)
pgadmin.utils.exception.SSHTunnelConnectionLost: Connection to the SSH
Tunnel for host '10.0.7.172' has been lost. Reconnect to the database server
2018-07-03 12:18:38,773: ERROR pgadmin: Connection to the SSH
Tunnel for host '10.0.7.172' has been lost. Reconnect to the database server
Traceback (most recent call last):
File "C:\Program Files (x86)\pgAdmin
4\v3\web\pgadmin\browser\server_groups\servers\__init__.py", line 805, in
create
server_types=ServerType.types()
File "C:\Program Files (x86)\pgAdmin
4\v3\web\pgadmin\utils\driver\psycopg2\connection.py", line 237, in connect
manager.check_ssh_tunnel_alive()
File "C:\Program Files (x86)\pgAdmin
4\v3\web\pgadmin\utils\driver\psycopg2\server_manager.py", line 430, in
check_ssh_tunnel_alive
raise SSHTunnelConnectionLost(self.tunnel_host)
pgadmin.utils.exception.SSHTunnelConnectionLost: Connection to the SSH
Tunnel for host '10.0.7.172' has been lost. Reconnect to the database server

--cnemelka

On Mon, Jul 2, 2018 at 12:44 AM Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
wrote:

> Hi Richard
>
> On Sun, Jul 1, 2018 at 9:13 PM, Richard Greenwood <richard
> (dot)greenwood(at)gmail(dot)com> wrote:
>
>> I can't get the ssh tunnel configuration that I use with pgAdmin3 to work
>> with 4. After I enter the
>> parameters and click "Save" I immediately get a dialog box that says:
>>
>> Connection to the SSH Tunnel for host 'my-postgres-server' has been lost.
>> Reconnect to the database server.
>>
>>
>> I'm using identity file authentication. In pgAdmin3 it wants both the
>> private and public key files. In pgAdmin4 only the private file is
>> specified. Otherwise everything is the same.
>>
>> The error is instantaneous and the server is 1000 miles away, so it's not
>> even waiting for a tunnel to get opened or a database connection to be
>> attempted.
>>
>
>
> - You are creating the ssh tunnel using same machine or there is some
> another machine in between?
> - If it's another machine, have you append the public key to the
> "authorized_keys" file?
> - Can you please provide logs and screenshot of the server dialog with
> ssh tunnel settings (if possible). To enable logging, ref:
> https://www.pgadmin.org/faq/#8
>
>
>> Any suggestions?
>> Thanks
>> --
>> Richard W. Greenwood, PLS
>> www.greenwoodmap.com
>>
>
>
>
> --
> *Akshay Joshi*
>
> *Sr. Software Architect *
>
>
>
> *Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
>