Connecting to AWS RDS succeeds via terminal but fails in pgAdmin 4. Why?
0
votes
1
answer
683
views
I can establish an SSH tunnel using
ssh -L 2222::5432 ec2-user@ -i ~/.ssh/key.pem
and then connect to my RDS using psql "host=localhost port=2222 user=postgres password=
These same settings in pgAdmin 4 do not seem to work.
- Host name in connection tab = ``
- Tunnel host = ``
- Port in connection tab = 5432
- Port in SSH tunnel tab = 2222
- Username in connection tab = postgres
- Username in ssh tunnel tab = ec2-user
- Password in connection tab = ``
- And identity file in ssh tunnel tab = ~/.ssh/key.pem
After trying for a while pgAdmin 4 fails with: unable to connect to server: Failed to create the SSH Tunnel. Error: Could not establish session to SSH gateway
cat ~/.pgadmin/pgadmin4.log
Just gives me:
ERROR pgadmin: Could not establish session to SSH gateway
Traceback (most recent call last):
File "/usr/pgadmin4/web/pgadmin/utils/driver/psycopg3/server_manager.py", line 610, in create_ssh_tunnel
self.tunnel_object.start()
File "/usr/pgadmin4/venv/lib/python3.10/site-packages/sshtunnel.py", line 1331, in start
self._raise(BaseSSHTunnelForwarderError,
File "/usr/pgadmin4/venv/lib/python3.10/site-packages/sshtunnel.py", line 1174, in _raise
raise exception(reason)
sshtunnel.BaseSSHTunnelForwarderError: Could not establish session to SSH gateway
I'm really lost on how to proceed given *it works* via the terminal. So clearly not some security group issue on AWS's side. I've tried deleting ~/.pgadmin
and trying again, but same result. Any help appreciated thanx.
In case this helps:
lsb_release -a
No LSB modules are available.
Distributor ID: Pop
Description: Pop!_OS 22.04 LTS
Release: 22.04
Codename: jammy
Asked by Frikster
(103 rep)
Sep 2, 2023, 04:38 AM
Last activity: Sep 2, 2023, 10:39 AM
Last activity: Sep 2, 2023, 10:39 AM