Debian Codegraph @

mysql-test/suite/rpl/r/rpl_ssl1.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);
7 connection slave;
8 stop slave;
9 include/wait_for_slave_to_stop.inc
10 change master to master_user='replssl',master_password='',master_ssl=0;
11 start slave;
12 connection master;
13 insert into t1 values (1);
14 connection slave;
15 select * from t1;
16 t
17 include/wait_for_slave_io_error.inc [errno=1045]
18 include/stop_slave_sql.inc
19 change master to
20 master_ssl=1,
21 master_ssl_ca ='MYSQL_TEST_DIR/std_data/cacert.pem',
22 master_ssl_cert='MYSQL_TEST_DIR/std_data/client-cert.pem',
23 master_ssl_key='MYSQL_TEST_DIR/std_data/client-key.pem';
24 start slave;
25 include/wait_for_slave_to_start.inc
26 connection master;
27 connection slave;
28 select * from t1;
29 t
30 1
31 Master_SSL_Allowed = 'Yes'
32 Master_SSL_CA_Path = ''
33 Master_SSL_CA_File = 'MYSQL_TEST_DIR/std_data/cacert.pem'
34 Master_SSL_Cert = 'MYSQL_TEST_DIR/std_data/client-cert.pem'
35 Master_SSL_Key = 'MYSQL_TEST_DIR/std_data/client-key.pem'
36 include/check_slave_is_running.inc
37 stop slave;
38 include/wait_for_slave_to_stop.inc
39 change master to master_user='root',master_password='', master_ssl=0;
40 start slave;
41 include/wait_for_slave_to_start.inc
42 connection master;
43 drop user replssl@localhost;
44 drop table t1;
45 connection slave;
46 Master_SSL_Allowed = 'No'
47 Master_SSL_CA_Path = ''
48 Master_SSL_CA_File = 'MYSQL_TEST_DIR/std_data/cacert.pem'
49 Master_SSL_Cert = 'MYSQL_TEST_DIR/std_data/client-cert.pem'
50 Master_SSL_Key = 'MYSQL_TEST_DIR/std_data/client-key.pem'
51 include/check_slave_is_running.inc
52 connection slave;
53 stop slave;
54 include/wait_for_slave_to_stop.inc
55 change master to
56 master_host="localhost",
57 master_ssl=1 ,
58 master_ssl_ca ='MYSQL_TEST_DIR/std_data/cacert.pem',
59 master_ssl_cert='MYSQL_TEST_DIR/std_data/client-cert.pem',
60 master_ssl_key='MYSQL_TEST_DIR/std_data/client-key.pem',
61 master_ssl_verify_server_cert=1;
62 start slave;
63 include/wait_for_slave_to_start.inc
64 connection master;
65 create table t1 (t int);
66 insert into t1 values (1);
67 connection slave;
68 select * from t1;
69 t
70 1
71 Master_SSL_Allowed = 'Yes'
72 Master_SSL_CA_Path = ''
73 Master_SSL_CA_File = 'MYSQL_TEST_DIR/std_data/cacert.pem'
74 Master_SSL_Cert = 'MYSQL_TEST_DIR/std_data/client-cert.pem'
75 Master_SSL_Key = 'MYSQL_TEST_DIR/std_data/client-key.pem'
76 include/check_slave_is_running.inc
77 connection master;
78 create user [email protected] identified by "sslrepl";
79 grant replication slave on *.* to [email protected] require ssl;
80 connection slave;
81 stop slave;
82 include/wait_for_slave_to_stop.inc
83 change master to
84 master_host="127.0.0.1",
85 master_user='replssl',
86 master_password="sslrepl",
87 master_ssl=1,
88 master_ssl_verify_server_cert=1,
89 master_ssl_ca ='',
90 master_ssl_cert='',
91 master_ssl_key='';
92 start slave;
93 include/wait_for_slave_to_start.inc
94 show tables;
95 Tables_in_test
96 t1
97 connection master;
98 drop table t1;
99 connection slave;
100 show tables;
101 Tables_in_test
102 include/stop_slave.inc
103 CHANGE MASTER TO
104 master_host="127.0.0.1",
105 master_user='root',
106 master_password='',
107 master_ssl_ca ='',
108 master_ssl_cert='',
109 master_ssl_key='',
110 master_ssl_verify_server_cert=0,
111 master_ssl=1;
112 connection master;
113 drop user [email protected];
114 connection slave;
115 drop user [email protected];
116 include/rpl_end.inc