RE: MySQL Secure Connection(e.g. SSL) Question
Ah I did not know that. Excellent. Still does not get round the issue that MySQL in most default binary distributions does not include SSL. Which I think is a shame, but then again is probably a lib issue. Thanks for that. Greg -Original Message- From: Eamon Daly [mailto:[EMAIL PROTECTED] Sent: 25 August 2004 19:28 To: [EMAIL PROTECTED] Subject: Re: MySQL Secure Connection(e.g. SSL) Question FYI, DBD::MySQL does support SSL. See http://search.cpan.org/~rudy/DBD-mysql-2.9004/lib/DBD/mysql.pm and search for mysql_ssl. You'll need to provide mysql_ssl_client_key mysql_ssl_client_cert mysql_ssl_ca_file as part of the DSN on the perl side, and set ssl-ca, ssl-key, and ssl-cert on the server. There's more on the subject at mysql.com: http://dev.mysql.com/doc/mysql/en/Secure_requirements.html Eamon Daly - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 11:12 AM Subject: RE: MySQL Secure Connection(e.g. SSL) Question I need to connect to a remote MySQL database from a PC using SSL. I would prefer to connect using perl DBD. Does anyone have a suggestion how I can accomplish this task or an alternative solution? What about stunnel or ssh tunnels and then use DBD::mysql on top. ISTR that DBD::mysql cannot use SSL'ed mysql client connections and your remote server would have to be complied to support it. Greg Thank You -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Secure Connection(e.g. SSL) Question
Something else I have done in the past was to use Cygwin to create an SSH session with the remote computer and use the remote computer's MySQL client/tools. If you are used to working in a Terminal Server session (I think they now call it Remote Desktop Connectivity) it will feel very familiar. I also fiddled around with Cygwin long enough and hard enough (translate: I spent lots of time reading groups and docs and experimenting) to enable me to create local X windows so that I could run a full GUI shell (GNOME or KDE, I can't remember) remotely. Please don't ask me how I got it all set up as I only did it once and it was a long while ago. I know it's possible because I did it and it worked well for my situation. FWIW, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Paul Maine [EMAIL PROTECTED] wrote on 08/24/2004 12:03:19 PM: I need to connect to a remote MySQL database from a PC using SSL. I would prefer to connect using perl DBD. Does anyone have a suggestion how I can accomplish this task or an alternative solution? Thank You -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Secure Connection(e.g. SSL) Question
Something else to check out is Stunnel. It creates SSL tunnels between hosts without requiring logins (basically port redirection). Also, MySQL has built in SSL now, so you might want to look at that. j- k- On Wednesday 25 August 2004 08:10 am, [EMAIL PROTECTED] said something like: Something else I have done in the past was to use Cygwin to create an SSH session with the remote computer and use the remote computer's MySQL client/tools. If you are used to working in a Terminal Server session (I think they now call it Remote Desktop Connectivity) it will feel very familiar. I also fiddled around with Cygwin long enough and hard enough (translate: I spent lots of time reading groups and docs and experimenting) to enable me to create local X windows so that I could run a full GUI shell (GNOME or KDE, I can't remember) remotely. Please don't ask me how I got it all set up as I only did it once and it was a long while ago. I know it's possible because I did it and it worked well for my situation. FWIW, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Paul Maine [EMAIL PROTECTED] wrote on 08/24/2004 12:03:19 PM: I need to connect to a remote MySQL database from a PC using SSL. I would prefer to connect using perl DBD. Does anyone have a suggestion how I can accomplish this task or an alternative solution? Thank You -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Secure Connection(e.g. SSL) Question
FYI, DBD::MySQL does support SSL. See http://search.cpan.org/~rudy/DBD-mysql-2.9004/lib/DBD/mysql.pm and search for mysql_ssl. You'll need to provide mysql_ssl_client_key mysql_ssl_client_cert mysql_ssl_ca_file as part of the DSN on the perl side, and set ssl-ca, ssl-key, and ssl-cert on the server. There's more on the subject at mysql.com: http://dev.mysql.com/doc/mysql/en/Secure_requirements.html Eamon Daly - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 11:12 AM Subject: RE: MySQL Secure Connection(e.g. SSL) Question I need to connect to a remote MySQL database from a PC using SSL. I would prefer to connect using perl DBD. Does anyone have a suggestion how I can accomplish this task or an alternative solution? What about stunnel or ssh tunnels and then use DBD::mysql on top. ISTR that DBD::mysql cannot use SSL'ed mysql client connections and your remote server would have to be complied to support it. Greg Thank You -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Secure Connection(e.g. SSL) Question
This all strikes me as somewhat odd, since there is a --ssl flag which one can use to build DBD::mysql with SSL support. Unfortunately, I've never personally figured out how to actually utilize it, but maybe others are more knowledgeable... Issac - Original Message - From: Joshua J. Kugler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 8:25 PM Subject: Re: MySQL Secure Connection(e.g. SSL) Question Something else to check out is Stunnel. It creates SSL tunnels between hosts without requiring logins (basically port redirection). Also, MySQL has built in SSL now, so you might want to look at that. j- k- On Wednesday 25 August 2004 08:10 am, [EMAIL PROTECTED] said something like: Something else I have done in the past was to use Cygwin to create an SSH session with the remote computer and use the remote computer's MySQL client/tools. If you are used to working in a Terminal Server session (I think they now call it Remote Desktop Connectivity) it will feel very familiar. I also fiddled around with Cygwin long enough and hard enough (translate: I spent lots of time reading groups and docs and experimenting) to enable me to create local X windows so that I could run a full GUI shell (GNOME or KDE, I can't remember) remotely. Please don't ask me how I got it all set up as I only did it once and it was a long while ago. I know it's possible because I did it and it worked well for my situation. FWIW, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Paul Maine [EMAIL PROTECTED] wrote on 08/24/2004 12:03:19 PM: I need to connect to a remote MySQL database from a PC using SSL. I would prefer to connect using perl DBD. Does anyone have a suggestion how I can accomplish this task or an alternative solution? Thank You -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Secure Connection(e.g. SSL) Question
I need to connect to a remote MySQL database from a PC using SSL. I would prefer to connect using perl DBD. Does anyone have a suggestion how I can accomplish this task or an alternative solution? What about stunnel or ssh tunnels and then use DBD::mysql on top. ISTR that DBD::mysql cannot use SSL'ed mysql client connections and your remote server would have to be complied to support it. Greg Thank You -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
