This is a copy of a previous post however it was from a year ago and there was no updates so I am also posting it due to having the exact same problem - could this have something to do with OpenSSL version 1.0.0?
The server appears to start fine no warnings and the SSL is enabled (as seen below). If I add a [client] section into my.conf it times out and if I try to connect via workbench on the same machine using SSL I get the error below.
Has anyone managed to resolve an issue like this?
********* Previous Post *********
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.