I’m trying to enable SSL on v5.1.50 client/server. As a first step, I have followed the instructions found at
http://dev.mysql.com/doc/refman/5.0/en/secure-using-ssl.html. I have also generated the certs by following the instructions provided at
http://dev.mysql.com/doc/refman/5.0/en/secure-create-certs.html. The server and client certs use different CNs.
I have the necessary ssl parameters to my.cnf, and show variables like '%ssl%' provides the following:
+---------------+-------------------------------------+
| Variable_name | Value |
+---------------+-------------------------------------+
| have_openssl | YES |
| have_ssl | YES |
| ssl_ca | /opt/mysql/newcerts/ca-cert.pem |
| ssl_capath | |
| ssl_cert | /opt/mysql/newcerts/server-cert.pem |
| ssl_cipher | |
| ssl_key | /opt/mysql/newcerts/server-key.pem |
But when I try to connect from the client I get:
ERROR 2026 (HY000): SSL connection error
Thanks in advance.