I'm using openssl to test mysql replication ssl in local network. I could login from the slave to the master using mysql command.
mysql -u repl --host=192.168.0.205 -p --ssl-ca=/etc/mysql/newcerts/ca-cert.pem
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.1.56-log Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
But when I start slave, replication fails with the following log entry.
Slave I/O thread: error connecting to master 'repl@192.168.0.205:3306': Error: 'SSL connection error' errno: 2026 retry-time: 60 retries: 86400
and
show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 192.168.0.205
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000110
Read_Master_Log_Pos: 106
Relay_Log_File: mysql-relay-bin.000003
Relay_Log_Pos: 98
Relay_Master_Log_File: mysql-bin.000110
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 106
Relay_Log_Space: 98
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: Yes
Master_SSL_CA_File: /etc/mysql/newcerts/ca-cert.pem
Master_SSL_CA_Path:
Master_SSL_Cert: /etc/mysql/newcerts/client-cert.pem
Master_SSL_Cipher:
Master_SSL_Key: /etc/mysql/newcerts/client-key.pem
Seconds_Behind_Master: NULL
1 row in set (0.00 sec)
ERROR:
No query specified
Please help to resolve this issue.
Thanks.