You can use plink or openSSH to vreate a tunnelling end point. All you do is setup a machine with ssh client to act as the MySQL server, by listenning on the mYSQL server port and then tunnelling that data through a single ssh session back to the real MySQL server.
If you would like details about how this can be done, let me know and I'll describe in more detail when I get back to the office. For now look at the ssh client help file and the plink help for a description of building and ssh tunnel with a local listenner port on a real network interface (non loopback address)
Armand Welsh
--------------------------
Sent from my BlackBerry Wireless Handheld
-----Original Message-----
From: ssh@erdelynet.com
To: ssh@erdelynet.com
Sent: Sun Aug 06 11:03:10 2006
Subject: Re: SSH Server for MySQL-5.0.22 Server on WinXP-SP2
Thanks, Mike and Jon.
On 8/5/06, Mike <diskcrasher@yahoo.com> wrote:
> See http://www.chinese-watercolor.com/LRP/printsrv/cygwin-sshd.html.
On 8/6/06, Jon Spriggs <jon.spriggs@gmail.com> wrote:
> You could include the plink binary from the putty website, and include
> that as part of the install, maybe even spawning a puttygen session to
> create the ssh key? On the server side, I recommend COPSSH - a google
> will find it for you.
> Asif Lodhi <itmailster@gmail.com> wrote: Hii,
> I have a MySQL-5.0.22 server running on WinXP-SP2. I would like my
> VB6 clients (on WinXP-SP2 machines) to connect to this MySQL/WinXP
> server over SSH - programmatically.
> I would also like to ask if this is a SSH2 supported software and FROM
> WHERE I can download it.
Thanks for the pointers, links & advice. However, I am concerned
that if all my VB6 clients will be using SSH to connect to MySQL
Server then, actually, each of them will be creating a separate SSH
session. That means 50 clients amount to 50 different SSH
sessions/processes on the server? I have also taken a look at the
openVPN - that's also a very good solution but my understanding is
that I'll have to re-compile MySQL from scratch if I want to use SSL.
Please correct me if I am wrong. I guess compiling from source is
NOTTTTTT a very easy process as far as Windows is concerned.
Any comments?
-- Thanks again for the help. Asif -- List Info: http://erdelynet.com/ssh-l/ List Archives: http://erdelynet.com/archive/ssh-l/ To Unsubscribe: Mail mailto:ssh+unsubscribe@erdelynet.com -- List Info: http://erdelynet.com/ssh-l/ List Archives: http://erdelynet.com/archive/ssh-l/ To Unsubscribe: Mail mailto:ssh+unsubscribe@erdelynet.comReceived on Mon Aug 7 10:26:55 2006
This archive was generated by hypermail 2.1.8 : Mon Aug 07 2006 - 10:26:56 EDT