[unixODBC-support] SSH tunnels with PostgreSQL

Chris Jewell c.jewell at lancaster.ac.uk
Mon Jul 11 18:10:26 BST 2005


I'm trying to connect to a PostgreSQL database that I have running 
behind a firewall.  I'm trying to do it over an ssh tunnel, and have 
achieved this using the psql text-based clients:

ssh -L 3333:foo.bar:5432 username at foo.bar


psql -h localhost -p 3333 -d dbname

I tried the same thing with unixODBC putting the server as localhost, 
and port as 3333.  However, I get the error: [unixODBC]Could not connect 
to the server; Could not connect to remote socket.  If I then change the 
server to, I get [unixODBC]Unknown authentication type.

My authentication type is md5 and unixODBC is supposed to support this.  
There is a bug-report on the PostgreSQL ODBC driver sourceforge page 
which describes the same phenomenon, but they haven't assigned the bug.  
I'm wondering if there is a workaround.



Chris Jewell, BSc(Hons), BVSc, MRCVS
Dept of Maths and Statistics
Fylde College
Lancaster University

More information about the unixODBC-support mailing list