MySQL Forums
Forum List  »  Perl

Re: DBI/ssl help
Posted by: Richard Schumert
Date: June 28, 2006 04:15PM

I'm running a simple perl script that connects remotely to a mysqld. Everything works fine in the case where I don't use an account that requires SSL (in this case tes2@businesstek.com)

However, when I use an account that does REQUIRE SSL, I am denied access: "failed: Access denied for user 'test'@'businesstek.com'" is the message I get from Perl DBI.

I have the following in the test script:
--------
$dsn = 'DBI:mysql:database=test;host=remote.server.net;port=3306;
mysql_ssl=1;
mysql_ssl_client_key=/test/client-key.pem;
mysql_ssl_client_cert=/test/client-cert.pem;
mysql_ssl_ca_file=/test/b2bca-cert.pem';
--------

I put the server certificate files in a directory "certs" above the mysql directory that contains the databases. I also added --ssl --ssl-ca=/var/db/certs/b2bca-cert.pem --ssl-cert=/var/db
/certs/server-cert.pem --ssl-key=/var/db/certs/server-key.pem

to the command liine arguments of the startup script.


At this point the only thing i can think of is that somehow the certificates aren't being loaded -- unfortuantely i get no message if I try to force an error by changing the command line arguments so I have no idea what's going right or wrong.

Any suggestions?

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.