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

Filed under:
|
|

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

Related posts about mysql

Related posts about ssl