Problem with SSL connection
Hi,
I'm trying to make connections ssl.
I followed the MySQL guide and I've configured the server
then I created a normal user, without the REQUIRE SSL.
I list the steps that I made:
on the server MySQL (10.43.249.17) I created the user:
GRANT ALL PRIVILEGES ON *.* TO 'pippo'@'%' IDENTIFIED BY '*****';
then, on the same server:
mysql --ssl-ca=/root/openssl/cacert.pem -u pippo -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1872
Server version: 5.0.45 Source distribution
on the another server :
mysql --ssl-ca=/root/openssl/cacert.pem -u pippo -h 10.43.249.17 -p
Enter password:
ERROR 2026 (HY000): SSL connection error
mysql --ssl-ca=/root/openssl/cacert.pem --ssl-cert=/root/openssl/client-cert.pem --ssl-key=/root/openssl/client-key.pem -u pippo -h 10.43.249.17 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1884
Server version: 5.0.45 Source distribution
Why ??
The guide says that even from another host, on a normal user,
you can use the only option:
--ssl-ca
but it is not, I am forced to certify the client.
Something wrong?
Thanks.
Subject
Views
Written By
Posted
Problem with SSL connection
4595
April 14, 2009 02:37AM
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.