List:General Discussion« Previous MessageNext Message »
From:Paul Nowosielski Date:November 1 2010 8:02pm
Subject:Verify replication slave is using SSL
View as plain text  
Dear All,

I just want to verify my rep slave is using ssl.

When I run this  command mysql> \s
 I get:

mysql> \s
--------------
mysql  Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 
5.1

Connection id:          5
Current database:
Current user:           root@localhost
SSL:                    Cipher in use is DHE-RSA-AES256-SHA
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.77-log Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 9 min 48 sec


And I can see the Cipher.

But when I run a show slave status I don't see a cipher key:


mysql> show slave status\G
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: my.sql.host
                Master_User: replicate
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: mysql-bin.000036
        Read_Master_Log_Pos: 186677
             Relay_Log_File: slave-relay.000074
              Relay_Log_Pos: 186814
      Relay_Master_Log_File: mysql-bin.000036
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB: sugarcrm
        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: 186677
            Relay_Log_Space: 186814
            Until_Condition: None
             Until_Log_File: 
              Until_Log_Pos: 0
         Master_SSL_Allowed: Yes
         Master_SSL_CA_File: /etc/mysql/ssl/ca-cert.pem
         Master_SSL_CA_Path: /etc/mysql/ssl/
            Master_SSL_Cert: /etc/mysql/ssl/client-cert.pem
          Master_SSL_Cipher: 
             Master_SSL_Key: /etc/mysql/ssl/client-key.pem
      Seconds_Behind_Master: 0
1 row in set (0.00 sec)



Can any tell me if SSL is functioning or not please?

Thank you,

Paul


Thread
Verify replication slave is using SSLPaul Nowosielski1 Nov