Re: pgAdmin4 ssh tunnel configuration

Hi Cory

Can you please provide the following details:

- Operating system and their version.
- pgAdmin4 version.
- Machine setup and screenshot of the server dialog of the Connection
and SSH Tunnel tab if possible.

On Tue, Jul 3, 2018 at 11:49 PM, Cory Nemelka <cnemelka(at)gmail(dot)com> wrote:

> 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 <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*
>>
>

--
*Akshay Joshi*

*Sr. Software Architect *

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