pgAdmin Firewall, SSH problem - Mailing list pgadmin-support
From | Dave Lazar |
---|---|
Subject | pgAdmin Firewall, SSH problem |
Date | |
Msg-id | [email protected] Whole thread Raw |
List | pgadmin-support |
Hi, I have a couple of postgresql servers running and they work great. I develop with pgAdmin using SSH and pageant, putty and tunneling. I have one problem server though and I am looking for help. One server is firewalled, and I configured the firewall (Smoothwall) to port forward port 5432. My postgresql server private IP at 192.168.100.18 works fine connecting via localhost. My pg_hba.conf contains the following setup: local all all md5 host all all 127.0.0.1 255.255.255.255 md5 host all all 192.168.100.18 255.255.255.255 md5 host all all 66.66.66.66 255.255.255.255 md5 host all all 77.77.77.77 255.255.255.255 md5 Where 66.66.66.66 is my development machine public IP and 77.77.77.77 is my firewall public IP and hence the route to the postgresql program. I setup my putty connection tunnel on my development machine to forward 35432 to the public IP of the postgresql server, 77.77.77.77:5432, which is my firewall, which should port forward packets to the IP of postgresql. In pgadmin I connect to localhost on port 35432 and all is well, when I do not have a firewall in the chain... In my case with the firewall, even with port forwarding setup for port 5432, pgAdmin times out after 5 minutes or so complaining about SSL handshake not working... I am not using SSL, although I do have that option with server.crt and server.key files available. What might be causing pgAdmin these connection problems... I am not sure if the firewall is the culprit or if I screwed up. All my other boxes w/o firewalls work fine this way.... Any insight most appreciated... Dave
pgadmin-support by date: