Обсуждение: [MASSMAIL]Difficulties connecting pgAdmin 4.4.15 to Postgres RDS
1. I am constrained to use pgAdmin 4.4.15. Upgrade is not an option
2. Conventional, command-line connection goes from my workstation, to PuTTY terminal on a "dmz", and from the dmz to an intermediate, client server. These values do establish a connection.
Every attempt to connect via pgAdmin results in an error unable to connect to server: Failed to create the SSH Tunnel. Error: Could not establish session to SSH gateway
3. I use all the values from the command line connection in the pgAdmin connection ... but the failure persists.
Is there some unanticipated setting in RDS that prevents this pgAdmin connection?
Regards,
--
Gus
540-454-3074
“Characteropathic individuals adopt ideologies created by doctrinaire, often schizoidal people, recast them into an active propaganda form, and disseminate it with their characteristic pathological egotism and paranoid intolerance for any philosophies which may differ from their own.” (Political Ponerology, Andrew Lobaczewski, 1984)
El mié, 10 abr 2024 a la(s) 5:04 p.m., Gus Spier (gus.spier@gmail.com) escribió:
1. I am constrained to use pgAdmin 4.4.15. Upgrade is not an option2. Conventional, command-line connection goes from my workstation, to PuTTY terminal on a "dmz", and from the dmz to an intermediate, client server. These values do establish a connection.Every attempt to connect via pgAdmin results in an error unable to connect to server: Failed to create the SSH Tunnel. Error: Could not establish session to SSH gateway3. I use all the values from the command line connection in the pgAdmin connection ... but the failure persists.
I fail to grasp your network setup. Are there multiple ssh tunnels involved? Maybe a diagram showing the networks, hosts and ip addresses (using placeholders like a.a.a.a, a.a.a.b suffices) will enable us to better understand the problem at hand.
Is there some unanticipated setting in RDS that prevents this pgAdmin connection?
No, there isn't to my knowledge.
The error you provided denotes that pgAdmin isn't being able to create the SSH tunnel to one of the intermediate hosts. It isn't even trying to reach the database.
You must be making some mistake along the connection route.
Regards,
Fernando.
Thanks. I'll check the whole set up again.
Gus
On Wed, Apr 10, 2024 at 5:03 PM Fernando Hevia <fhevia@gmail.com> wrote:
El mié, 10 abr 2024 a la(s) 5:04 p.m., Gus Spier (gus.spier@gmail.com) escribió:1. I am constrained to use pgAdmin 4.4.15. Upgrade is not an option2. Conventional, command-line connection goes from my workstation, to PuTTY terminal on a "dmz", and from the dmz to an intermediate, client server. These values do establish a connection.Every attempt to connect via pgAdmin results in an error unable to connect to server: Failed to create the SSH Tunnel. Error: Could not establish session to SSH gateway3. I use all the values from the command line connection in the pgAdmin connection ... but the failure persists.I fail to grasp your network setup. Are there multiple ssh tunnels involved? Maybe a diagram showing the networks, hosts and ip addresses (using placeholders like a.a.a.a, a.a.a.b suffices) will enable us to better understand the problem at hand.Is there some unanticipated setting in RDS that prevents this pgAdmin connection?No, there isn't to my knowledge.The error you provided denotes that pgAdmin isn't being able to create the SSH tunnel to one of the intermediate hosts. It isn't even trying to reach the database.You must be making some mistake along the connection route.Regards,Fernando.