[unixODBC-support] SSH tunnels with PostgreSQL

Nick Gorham nick.gorham at easysoft.com
Mon Jul 11 18:24:54 BST 2005

Chris Jewell wrote:

> Hi,
> 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
> Then:
> 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.
> Regards,
> Chris

The Postgres driver in builds after 2.2.10 should support md5 (though I 
haven't tried it myself), what unixODBC build are you using?


More information about the unixODBC-support mailing list