Debian Codegraph @

mysql-test/suite/rpl/t/rpl_ssl1.test

raw
1 source include/have_ssl_communication.inc;
2 source include/master-slave.inc;
3
4 # We don't test all types of ssl auth params here since it's a bit hard
5 # until problems with OpenSSL 0.9.7 are unresolved
6
7 # creating replication user for whom ssl auth is required
8 # preparing playground
9 connection master;
10 create user replssl@localhost;
11 grant replication slave on *.* to replssl@localhost require ssl;
12 create table t1 (t int);
13
14 sync_slave_with_master;
15
16 #trying to use this user without ssl
17 stop slave;
18 --source include/wait_for_slave_to_stop.inc
19 change master to master_user='replssl',master_password='',master_ssl=0;
20 start slave;
21
22 #showing that replication don't work
23 connection master;
24 insert into t1 values (1);
25 #reasonable timeout for changes to propagate to slave
26 let $wait_condition= SELECT COUNT(*) = 1 FROM t1;
27 source include/wait_condition.inc;
28 connection slave;
29 select * from t1;
30
31 #showing that replication could work with ssl params
32 --let $slave_io_errno=1045
33 --source include/wait_for_slave_io_error.inc
34 --source include/stop_slave_sql.inc
35
36 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
37 eval change master to
38 master_ssl=1,
39 master_ssl_ca ='$MYSQL_TEST_DIR/std_data/cacert.pem',
40 master_ssl_cert='$MYSQL_TEST_DIR/std_data/client-cert.pem',
41 master_ssl_key='$MYSQL_TEST_DIR/std_data/client-key.pem';
42 start slave;
43 --source include/wait_for_slave_to_start.inc
44
45 #avoiding unneeded sleeps
46 connection master;
47 sync_slave_with_master;
48
49 #checking that replication is ok
50 select * from t1;
51
52 #checking show slave status
53 let $status_items= Master_SSL_Allowed, Master_SSL_CA_Path, Master_SSL_CA_File, Master_SSL_Cert, Master_SSL_Key;
54 source include/show_slave_status.inc;
55 source include/check_slave_is_running.inc;
56
57 #checking if replication works without ssl also performing clean up
58 stop slave;
59 --source include/wait_for_slave_to_stop.inc
60 change master to master_user='root',master_password='', master_ssl=0;
61 start slave;
62 --source include/wait_for_slave_to_start.inc
63 connection master;
64 drop user replssl@localhost;
65 drop table t1;
66
67 sync_slave_with_master;
68 source include/show_slave_status.inc;
69 source include/check_slave_is_running.inc;
70 # End of 4.1 tests
71
72 # Start replication with ssl_verify_server_cert turned on
73 connection slave;
74 stop slave;
75 --source include/wait_for_slave_to_stop.inc
76 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
77 eval change master to
78 master_host="localhost",
79 master_ssl=1 ,
80 master_ssl_ca ='$MYSQL_TEST_DIR/std_data/cacert.pem',
81 master_ssl_cert='$MYSQL_TEST_DIR/std_data/client-cert.pem',
82 master_ssl_key='$MYSQL_TEST_DIR/std_data/client-key.pem',
83 master_ssl_verify_server_cert=1;
84 start slave;
85 --source include/wait_for_slave_to_start.inc
86
87 connection master;
88 create table t1 (t int);
89 insert into t1 values (1);
90
91 sync_slave_with_master;
92 select * from t1;
93
94 #checking show slave status
95 source include/show_slave_status.inc;
96 --source include/check_slave_is_running.inc
97
98 # MDEV-31855 validate with master_password
99 connection master;
100 create user [email protected] identified by "sslrepl";
101 grant replication slave on *.* to [email protected] require ssl;
102
103 connection slave;
104 stop slave;
105 --source include/wait_for_slave_to_stop.inc
106 eval change master to
107 master_host="127.0.0.1",
108 master_user='replssl',
109 master_password="sslrepl",
110 master_ssl=1,
111 master_ssl_verify_server_cert=1,
112 master_ssl_ca ='',
113 master_ssl_cert='',
114 master_ssl_key='';
115 start slave;
116 --source include/wait_for_slave_to_start.inc
117
118 show tables;
119 connection master;
120 drop table t1;
121 sync_slave_with_master;
122 show tables;
123
124 # ==== Clean up ====
125 --source include/stop_slave.inc
126 CHANGE MASTER TO
127 master_host="127.0.0.1",
128 master_user='root',
129 master_password='',
130 master_ssl_ca ='',
131 master_ssl_cert='',
132 master_ssl_key='',
133 master_ssl_verify_server_cert=0,
134 master_ssl=1;
135 connection master;
136 drop user [email protected];
137 connection slave;
138 drop user [email protected];
139
140 --let $rpl_only_running_threads= 1
141 --source include/rpl_end.inc