Re: pgAdmin4 ssh tunnel configuration

answers in-line. It appears that pgAdmin is not even trying to open the
tunnel.

--cnemelka

On Tue, Jul 3, 2018 at 10:57 PM Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
wrote:

> Hi Cory
>
> Can you please provide the following details:
>
> - Operating system and their version.
>
> windows 10 is where I experience the error. Haven't tried on MAC OS yet

>
> - pgAdmin4 version.
>
> [image: image.png]

>
> - Machine setup and screenshot of the server dialog of the Connection
> and SSH Tunnel tab if possible.
>
> Standard windows 10 corporate desktop is the "machine setup". I'm not
quite sure what you mean by "machine setup".

Screen shots:

[image: image.png]

[image: image.png]
[image: image.png]

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