Skip site navigation (1) Skip section navigation (2)

Re: secure ODBC connection

From: "Mathew Frank" <mfrank(at)bigpond(dot)net(dot)au>
To: "Mister ics" <mister_ics(at)hotmail(dot)com>, <renfro(at)tntech(dot)edu>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: secure ODBC connection
Date: 2001-09-16 10:59:00
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
Your starting it at the wrong place.  You start the connection from the
machine you are connectiong from - not the database server.  Otherwise you
are setting up a secure tunnel withing the machine, instead of accross the

Run the SSH command on the Windows client machine.


> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Mister ics
> Sent: Sunday, 16 September 2001 9:36 AM
> To: renfro(at)tntech(dot)edu
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] secure ODBC connection
> Hi Mike,
> I understand now... but i still have a problem on server side :-)
> When i start the tunnel on back-end side:
> ssh -N -L relay(at)myserver(dot)myorg(dot)com
> it starts to listen on port 3333 of the host (lo). If i try to
> connect to myserver.myorg:3333 from the outside, the connection
> is refufed
> because the tunnel does not work on the network interface's address (es.
>, but only on the lo interface.
> How can i "export" that tunnel to the outside.
> Thaks in advance,
> Regards,
> Silvio
> >Doesn't matter. The whole point of ssh tunneling is to provide crypto
> >for programs that wouldn't otherwise have it (certain pop, imap, http,
> >whatever programs).
> >
> >As Matthew Frank pointed out, make an ssh tunnel from
> >localhost:odbcport to odbchost:odpcport and point your ODBC client to
> >localhost instead of odbchost.
> >
> >To try a simpler example, I've used putty's terminal app to tunnel
> >localhost:9673 to a remote host's port 9673 (not for ODBC, but for web
> >work). Pointed my web browser at localhost:9673 and up popped the
> >remote web site. Secure as SSL, but without the cost.
> >
> _________________________________________________________________
> Scarica GRATUITAMENTE MSN Explorer all'indirizzo
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-09-17 02:47:45
Subject: Re: [ODBC] ODBC, Win2K, CygWin, and PostgreSQL
Previous:From: Mister icsDate: 2001-09-16 09:36:02
Subject: Re: secure ODBC connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group