Verify replication slave is using SSL

Dear All, I just want to verify my rep slave is using ssl. When I=
run this command mysql> \s=0A I get: mysql> \s=0A--------------=0Amy=
sql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline=
=0A5.1 Connection 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 =0AAnd I can see the Cipher. But when I run a sh=
ow slave status I don't see a cipher key: =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) Can any =
tell me if SSL is functioning or not please? Thank you, Paul=0A=
=0A

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg