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>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: secure ODBC connection
Date: 2001-09-13 23:00:28
Message-ID: HHEBIKEIGDLFABEKDCCKAEIBCIAA.mfrank@bigpond.net.au (view raw or flat)
Thread:
Lists: pgsql-odbc
Simple way of doing this with almost anything, is to use SSH
- Install SSH on the DB machine
- Install an SSH client on Windows (lots of GUI versions, but there is a
command line one that comes with Cywin.)
- Using the SSH client, log onto the db machine, and forward the db port to
a port on localhost.
	Using ssh.exe from cygwin like this:
	=============DOS PROMPT==============
	C:\>ssh -L 80:192.168.0.254:80 -l root -T 192.168.0.254
	root(at)192(dot)168(dot)0(dot)254's password:
	stdin: is not a tty
	exit
	'dumb': unknown terminal type.
	Waiting for forwarded connections to terminate...
	The following connections are open:
	  #0 listen port 80 for 192.168.0.254 port 80, connect from 127.0.0.1 port
	1987
	(t4 r1 i1/0 o16/0 fd 4/4)
	=============END PROMPT==============
The above example forwards port 80 to localhost port 80, and specifies that
no actual terminal session be started on the server you've logged onto
(forward port only)

- Setup you programs on the windows machine to connect to localhost via ODBC
settings.

Regards,
Mathew
ps - I use Win2k, and have not found an SSH client by default

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Mister ics
> Sent: Thursday, 13 September 2001 1:39 PM
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] secure ODBC connection
>
>
> Hi,
>
> <<Sorry for partially O.T. >>
>
> is there a way to tunnel a win'98 ODBC connection into a ssh connection ?
> Tunnelling a TCP/IP connection in a ssh stream is a good and
> simple way to
> obtain acceptable levels of security in client-server applications.
> Unfortunately i've not found a way to do it on Win'95-98 boxes.
> I heared ssh tunnelling is supported at o.s.-level in win2000.


In response to

pgsql-odbc by date

Next:From: heroDate: 2001-09-14 04:27:29
Subject: pgAdmin II /odbc connect errors
Previous:From: Mister icsDate: 2001-09-13 22:37:26
Subject: Re: secure ODBC connection

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