Debian Codegraph @

mysql-test/suite/binlog_encryption/rpl_ssl.result

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