release/src/router/mysql/mysql-test/suite/rpl/r/rpl_ssl1.result

   1 include/master-slave.inc
   2 [connection master]
   3 grant replication slave on *.* to replssl@localhost require ssl;
   4 create table t1 (t int);
   5 stop slave;
   6 change master to master_user='replssl',master_password='';
   7 start slave;
   8 insert into t1 values (1);
   9 select * from t1;
  10 t
  11 stop slave;
  12 change master to master_ssl=1 , master_ssl_ca ='MYSQL_TEST_DIR/std_data/cacert.pem', master_ssl_cert='MYSQL_TEST_DIR/std_data/client-cert.pem', master_ssl_key='MYSQL_TEST_DIR/std_data/client-key.pem';
  13 start slave;
  14 select * from t1;
  15 t
  16 1
  17 Master_SSL_Allowed = 'Yes'
  18 Master_SSL_CA_Path = ''
  19 Master_SSL_CA_File = 'MYSQL_TEST_DIR/std_data/cacert.pem'
  20 Master_SSL_Cert = 'MYSQL_TEST_DIR/std_data/client-cert.pem'
  21 Master_SSL_Key = 'MYSQL_TEST_DIR/std_data/client-key.pem'
  22 include/check_slave_is_running.inc
  23 stop slave;
  24 change master to master_user='root',master_password='', master_ssl=0;
  25 start slave;
  26 drop user replssl@localhost;
  27 drop table t1;
  28 Master_SSL_Allowed = 'No'
  29 Master_SSL_CA_Path = ''
  30 Master_SSL_CA_File = 'MYSQL_TEST_DIR/std_data/cacert.pem'
  31 Master_SSL_Cert = 'MYSQL_TEST_DIR/std_data/client-cert.pem'
  32 Master_SSL_Key = 'MYSQL_TEST_DIR/std_data/client-key.pem'
  33 include/check_slave_is_running.inc
  34 stop slave;
  35 change master to
  36 master_host="localhost",
  37 master_ssl=1 ,
  38 master_ssl_ca ='MYSQL_TEST_DIR/std_data/cacert.pem',
  39 master_ssl_cert='MYSQL_TEST_DIR/std_data/client-cert.pem',
  40 master_ssl_key='MYSQL_TEST_DIR/std_data/client-key.pem',
  41 master_ssl_verify_server_cert=1;
  42 start slave;
  43 create table t1 (t int);
  44 insert into t1 values (1);
  45 on slave
  46 select * from t1;
  47 t
  48 1
  49 Master_SSL_Allowed = 'Yes'
  50 Master_SSL_CA_Path = ''
  51 Master_SSL_CA_File = 'MYSQL_TEST_DIR/std_data/cacert.pem'
  52 Master_SSL_Cert = 'MYSQL_TEST_DIR/std_data/client-cert.pem'
  53 Master_SSL_Key = 'MYSQL_TEST_DIR/std_data/client-key.pem'
  54 include/check_slave_is_running.inc
  55 drop table t1;
  56 include/stop_slave.inc
  57 CHANGE MASTER TO
  58 master_host="127.0.0.1",
  59 master_ssl_ca ='',
  60 master_ssl_cert='',
  61 master_ssl_key='',
  62 master_ssl_verify_server_cert=0,
  63 master_ssl=0;
  64 include/rpl_end.inc