From: Paul Nowosielski
Date: November 1 2010 8:02pm
Subject: Verify replication slave is using SSL
List-Archive: http://lists.mysql.com/mysql/223488
Message-Id: <789422.69580.qm@web30406.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Dear All,=0A=0AI just want to verify my rep slave is using ssl.=0A=0AWhen I=
 run this  command mysql> \s=0A I get:=0A=0Amysql> \s=0A--------------=0Amy=
sql  Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline=
 =0A5.1=0A=0AConnection id:          5=0ACurrent database:=0ACurrent user: =
          root@localhost=0ASSL:                    Cipher in use is DHE-RSA=
-AES256-SHA=0ACurrent pager:          stdout=0AUsing outfile:          ''=
=0AUsing delimiter:        ;=0AServer version:         5.0.77-log Source di=
stribution=0AProtocol version:       10=0AConnection:             Localhost=
 via UNIX socket=0AServer characterset:    latin1=0ADb     characterset:   =
 latin1=0AClient characterset:    latin1=0AConn.  characterset:    latin1=
=0AUNIX socket:            /var/lib/mysql/mysql.sock=0AUptime:             =
    9 min 48 sec=0A=0A=0AAnd I can see the Cipher.=0A=0ABut when I run a sh=
ow slave status I don't see a cipher key:=0A=0A=0Amysql> show slave status\=
G=0A*************************** 1. row ***************************=0A      =
       Slave_IO_State: Waiting for master to send event=0A                M=
aster_Host: my.sql.host=0A                Master_User: replicate=0A        =
        Master_Port: 3306=0A              Connect_Retry: 60=0A            M=
aster_Log_File: mysql-bin.000036=0A        Read_Master_Log_Pos: 186677=0A  =
           Relay_Log_File: slave-relay.000074=0A              Relay_Log_Pos=
: 186814=0A      Relay_Master_Log_File: mysql-bin.000036=0A           Slave=
_IO_Running: Yes=0A          Slave_SQL_Running: Yes=0A            Replicate=
_Do_DB: sugarcrm=0A        Replicate_Ignore_DB: =0A         Replicate_Do_Ta=
ble: =0A     Replicate_Ignore_Table: =0A    Replicate_Wild_Do_Table: =0ARep=
licate_Wild_Ignore_Table: =0A                 Last_Errno: 0=0A             =
    Last_Error: =0A               Skip_Counter: 0=0A        Exec_Master_Log=
_Pos: 186677=0A            Relay_Log_Space: 186814=0A            Until_Cond=
ition: None=0A             Until_Log_File: =0A              Until_Log_Pos: =
0=0A         Master_SSL_Allowed: Yes=0A         Master_SSL_CA_File: /etc/my=
sql/ssl/ca-cert.pem=0A         Master_SSL_CA_Path: /etc/mysql/ssl/=0A      =
      Master_SSL_Cert: /etc/mysql/ssl/client-cert.pem=0A          Master_SS=
L_Cipher: =0A             Master_SSL_Key: /etc/mysql/ssl/client-key.pem=0A =
     Seconds_Behind_Master: 0=0A1 row in set (0.00 sec)=0A=0A=0A=0ACan any =
tell me if SSL is functioning or not please?=0A=0AThank you,=0A=0APaul=0A=
=0A