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.

link|improve this question
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.