MySQL Forums
Forum List  »  Perl

Re: DBI/ssl help - can't get it to work at all, help!
Posted by: extramail
Date: August 31, 2006 02:53PM

This thread was good to find and it seems there has been some success getting it all to work. Although it seems it was a linux client. We are trying to connect from a windows perl client running mysql v5.0.24, perl v5.8.8, DBI v1.5, DBD-mysql v3.0002 and either win2k or xp.

Everything indicates the server is set up right. In the mysql client the '\s' command returns:
mysql Ver 14.12 Distrib 5.0.24, for Win32 (ia32)
Connection id: 29
Current database:
Current user: joel@localhost
SSL: Cipher in use is DHE-RSA-AES256-SHA
Using delimiter: ;
Server version: 5.0.24-community-nt
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 3 hours 4 min 40 sec

My perl script works fine before requiring SSL so user access is all set up fine. After requiring SSL via a GRANT command my perl client returns:

DBI connect('database=test;host=localhost;
mysql_ssl=1;
mysql_ssl_client_key=c:/openssl/certs/client-key.pem;
mysql_ssl_client_cert=c:/openssl/certs/client-cert.pem;
mysql_ssl_ca_file=c:/openssl/certs/cacert.pem','joel',...) failed: Access de
nied for user 'joel'@'localhost' (using password: YES) at C:\temp\perl\ssl.pl line 4
Access denied for user 'joel'@'localhost' (using password: YES) at C:\temp\perl\ssl.pl line 4.

Everything is on the same machine at this point. It almost seems hard to believe that there isn't a lot of secure connections going on out there somewhere. Does anyone have any troubleshooting tips? Any debugging or tracing that can be turned on?

Tx

Options: ReplyQuote


Subject
Written By
Posted
March 23, 2006 08:16PM
March 24, 2006 11:15AM
May 28, 2006 01:34AM
June 07, 2006 01:06AM
June 28, 2006 04:15PM
July 01, 2006 09:54AM
Re: DBI/ssl help - can't get it to work at all, help!
August 31, 2006 02:53PM


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.