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
Subject
Written By
Posted
Re: DBI/ssl help - can't get it to work at all, help!
August 31, 2006 02:53PM
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.