Multiple client connecting to master MySQL over SSL
- by Bastien974
I successfully configured a MySQL replication over SSL between 2 servers accross the internet.
Now I want a second server in the same location as the replication slave, to open a connection to the master db over ssl.
I used the same command found here http://dev.mysql.com/doc/refman/5.1/en/secure-create-certs.html to generate a new set of client-cert.pem and client-key.pem with the same master db ca-cert/key.pem and I also used a different Common Name.
When I try to initiate a connection between this new server and the master db, it fails :
mysql -hmasterdb -utestssl -p
--ssl-ca=/var/lib/mysql/newcerts/ca-cert.pem
--ssl-cert=/var/lib/mysql/newcerts/client-cert.pem
--ssl-key=/var/lib/mysql/newcerts/client-key.pem
ERROR 2026 (HY000): SSL connection
error
It's working without SSL.
