DBI and DBD:mysql with SSL

DBI and DBD:mysql with SSL

am 11.04.2010 21:40:15 von fzarabozo

Hello All,

First things first. I'm using the following:


ActivePerl 5.010 build 1007 (on Windows Server 2003)
DBI 1.609
DBD::mysql 4.011 (installed through ppm)
MySQL 5.1 Community Edition
SSL certificates from GoDaddy


I need to be able to create conections from our web server to an external
MySQL database over SSL. I'm having a lot of trouble trying to test things
out and I've found a lot of comments (very old ones) saying that you need to
recompile MySQL and also DBD::mysql in order to enable SSL functionality. I
think I've setup SSL in MySQL properly and with valid certificates. However,
things are not working and I don't get any informative error messages about
it. MySQL starts fine and shows variables like SSL as enables and with the
certificates in place, but the connections with SSL are not succesful, or I
get connected with no SSL at all.

I want to take this into little steps in order to resolve it properly. So, I
want to first be sure whether Perl (DBD::mysql) is prepared for this or not.
If anyone has information about it, please let me know.

*** Also, does anyone have a MySQL server running with SSL enabled (verified
working) and with a public IP address? If so, I would REALLY appreciate it
if you can give me a test account for a few days, with access to a test DB
only, so I can just verify my test script is working. This test account
should be granted with REQUIRE SSL so I can be sure it's connecting with SSL
only.


Any help regarding this will be highly valuated.


Thanks in advance,

Francisco Zarabozo


_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs