Edit File: rpl_ssl1.result
include/master-slave.inc [connection master] grant replication slave on *.* to replssl@localhost require ssl; create table t1 (t int); stop slave; include/wait_for_slave_to_stop.inc change master to master_user='replssl',master_password=''; start slave; insert into t1 values (1); select * from t1; t stop slave; include/wait_for_slave_to_stop.inc 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'; start slave; include/wait_for_slave_to_start.inc select * from t1; t 1 Master_SSL_Allowed = 'Yes' Master_SSL_CA_Path = '' Master_SSL_CA_File = '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' include/check_slave_is_running.inc stop slave; include/wait_for_slave_to_stop.inc change master to master_user='root',master_password='', master_ssl=0; start slave; include/wait_for_slave_to_start.inc drop user replssl@localhost; drop table t1; Master_SSL_Allowed = 'No' Master_SSL_CA_Path = '' Master_SSL_CA_File = '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' include/check_slave_is_running.inc stop slave; include/wait_for_slave_to_stop.inc change master to master_host="localhost", 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', master_ssl_verify_server_cert=1; start slave; include/wait_for_slave_to_start.inc create table t1 (t int); insert into t1 values (1); on slave select * from t1; t 1 Master_SSL_Allowed = 'Yes' Master_SSL_CA_Path = '' Master_SSL_CA_File = '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' include/check_slave_is_running.inc drop table t1; include/stop_slave.inc CHANGE MASTER TO master_host="127.0.0.1", master_ssl_ca ='', master_ssl_cert='', master_ssl_key='', master_ssl_verify_server_cert=0, master_ssl=0; include/rpl_end.inc
Back to File Manager