Re: DBI/ssl help
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?
Subject
Written By
Posted
Re: DBI/ssl help
June 28, 2006 04:15PM
November 25, 2007 01:50AM
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.