Re: pgAdmin4 ssh tunnel configuration
I have same issue now. Here is screenshot:
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.joshi@enterprisedb.com> wrote:
Hi RichardOn Sun, Jul 1, 2018 at 9:13 PM, Richard Greenwood <richard.greenwood@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
--Akshay JoshiSr. Software ArchitectPhone: +91 20-3058-9517
Mobile: +91 976-788-8246
Вложения
В списке pgadmin-support по дате отправления: