MySQL Forums
Forum List  »  Security

Problem with SSL connection
Posted by: stefano elmopi
Date: April 14, 2009 02:37AM

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.

Options: ReplyQuote


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.