pgadmin tunnel problem
От | Dave |
---|---|
Тема | pgadmin tunnel problem |
Дата | |
Msg-id | 41E5B079.3000701@gmail.com обсуждение исходный текст |
Список | pgadmin-support |
Hi, I have a couple of postgresql servers running and they work great with putty and ssh tunneling combined with pgadmin. I have one problem server though and I am looking for help. My public IP is firewalled, and I port forward port 5432. My server IP at 192.168.100.18 works fine with code residing on the server itself, 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 local public IP and 77.77.77.77 is my public IP for the firewall and hence the server. Usually I setup my putty connection to tunnel a port like 35432 to the public IP of the postgresql server, say 77.77.77.77:5432 And 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 have installed a server.crt and server.key file in the pgsql/data directory and the server seems to work fine with ssl_enabled in the postgresql.conf file, and tcp enabled. What might be causing pgAdmin these connection problems... I am not sure if the firewall is the culprit or if I screwed up something with SSL... Any insight most appreciated... Dave
В списке pgadmin-support по дате отправления: