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 <cneme...@gmail.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.jo...@enterprisedb.com> wrote: > >> Hi Richard >> >> On Sun, Jul 1, 2018 at 9:13 PM, Richard Greenwood <richard >> .greenw...@gmail.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*
