Re: SSH Server for MySQL-5.0.22 Server on WinXP-SP2

Asif Lodhi wrote:
> 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?

That's true.

> 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.

Uhh... It seems you're seriously misunderstanding the difference between
  SSH, SSL, OpenVPN and encrypted connections to MySQL.

> Any comments?

I think you have to stand back and look at your network design and come
up with a plan.

Where are these 50 clients connecting from? The LAN, their homes?
Anywhere?

If it's the LAN and you're still worried about security, there are
network cards that encrypt all traffic as it hits the wire.

You can use the built in IPsec tunneling in Windows.

OpenVPN is a good option.

Recompiling MySQL for SSL support is a completely separate option from
SSH or VPN. You'd probably have to recompile the MySQL clients (or use
a different library or whatever you're doing to connect to the server).

> --
> Thanks again for the help.
>
> Asif
>

-ME

--
List Info:      http://erdelynet.com/ssh-l/
List Archives:  http://erdelynet.com/archive/ssh-l/
To Unsubscribe: Mail mailto:ssh+unsubscribe@erdelynet.com