Multiple client connecting to master MySQL over SSL
Posted
by
Bastien974
on Server Fault
See other posts from Server Fault
or by Bastien974
Published on 2011-06-28T23:37:15Z
Indexed on
2011/06/29
0:23 UTC
Read the original article
Hit count: 322
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.
© Server Fault or respective owner