pgAdmin Firewall, SSH problem

From: Dave Lazar <hunkybill(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin Firewall, SSH problem
Date: 2005-01-13 02:23:37
Message-ID: e0d71d270501121823904734d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgadmin-support by date

  From Date Subject
Next Message Benjamin Indermühle 2005-01-13 09:21:10 adding column with sequence
Previous Message Dave 2005-01-12 23:19:21 pgadmin tunnel problem