Debian Codegraph @

mysql-test/suite/group_replication/include/gr_ssl.inc

raw
1 ################################################################################
2 # Base test to verify the basic SSL support on Group replication recovery
3 #
4 # Test:
5 # 0. The test requires two servers: M1 and M2.
6 # 1. Setup the first member (M1) with a recovery user that requires SSL.
7 # 2. Add some data and bootstrap start a group on M1.
8 # 3. Configure joining member (M2) to use SSL options on recovery. Start GR on
9 # M2. Check the data is there.
10 # 4. Clean up.
11 ################################################################################
12
13 --source include/have_group_replication_plugin.inc
14 --let $rpl_skip_group_replication_start= 1
15 --source include/group_replication.inc
16
17 --echo #
18 --echo # Setup the first member with a recovery user that requires SSL
19 --echo #
20
21 --connection server1
22 --echo server1
23
24 # create a user for replication that requires ssl encryption
25 set session sql_log_bin=0;
26 CREATE USER 'rec_ssl_user'@'%' REQUIRE SSL;
27 GRANT replication slave ON *.* TO 'rec_ssl_user'@'%';
28 GRANT GROUP_REPLICATION_STREAM ON *.* TO 'rec_ssl_user'@'%';
29 set session sql_log_bin=1;
30
31 --let $conf_rec_ssl_mode_s1= `SELECT @@GLOBAL.group_replication_ssl_mode;`
32 --eval SET GLOBAL group_replication_ssl_mode= REQUIRED
33
34 --echo #
35 --echo # Add some data and start the member
36 --echo #
37
38 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
39 INSERT INTO t1 VALUES (1);
40
41 --source include/start_and_bootstrap_group_replication.inc
42
43 --echo #
44 --echo # Configure a joining member to use SSL options on recovery and start it
45 --echo #
46
47 --connection server2
48 --echo server2
49
50 set session sql_log_bin=0;
51 CREATE USER 'rec_ssl_user'@'%' REQUIRE SSL;
52 GRANT replication slave ON *.* TO 'rec_ssl_user'@'%';
53 GRANT GROUP_REPLICATION_STREAM ON *.* TO 'rec_ssl_user'@'%';
54 set session sql_log_bin=1;
55
56 --let $conf_rec_use_ssl= `SELECT @@GLOBAL.group_replication_recovery_use_ssl;`
57 --let $conf_rec_ssl_ca= `SELECT @@GLOBAL.group_replication_recovery_ssl_ca;`
58 --let $conf_rec_ssl_cert= `SELECT @@GLOBAL.group_replication_recovery_ssl_cert;`
59 --let $conf_rec_ssl_key= `SELECT @@GLOBAL.group_replication_recovery_ssl_key;`
60
61 --disable_warnings
62 CHANGE REPLICATION SOURCE TO SOURCE_USER="rec_ssl_user" FOR CHANNEL "group_replication_recovery";
63 --enable_warnings
64
65 --eval SET GLOBAL group_replication_recovery_use_ssl=1
66 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
67 --eval SET GLOBAL group_replication_recovery_ssl_ca= '$MYSQL_TEST_DIR/std_data/cacert.pem'
68 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
69 --eval SET GLOBAL group_replication_recovery_ssl_cert= '$MYSQL_TEST_DIR/std_data/client-cert.pem'
70 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
71 --eval SET GLOBAL group_replication_recovery_ssl_key= '$MYSQL_TEST_DIR/std_data/client-key.pem'
72
73 --let $conf_rec_ssl_mode_s2= `SELECT @@GLOBAL.group_replication_ssl_mode;`
74 --eval SET GLOBAL group_replication_ssl_mode= REQUIRED
75
76 --source include/start_group_replication.inc
77
78 --echo #
79 --echo # Check the data is there
80 --echo #
81
82 --let $assert_text= On the recovered member, the table should exist and have 1 elements;
83 --let $assert_cond= [select count(*) from t1] = 1;
84 --source include/assert.inc
85
86 --echo #
87 --echo # Clean up
88 --echo #
89
90 --disable_query_log
91 --eval SET @@GLOBAL.group_replication_recovery_use_ssl= $conf_rec_use_ssl
92 --eval SET @@GLOBAL.group_replication_recovery_ssl_ca= "$conf_rec_ssl_ca"
93 --eval SET @@GLOBAL.group_replication_recovery_ssl_cert= "$conf_rec_ssl_cert"
94 --eval SET @@GLOBAL.group_replication_recovery_ssl_key= "$conf_rec_ssl_key"
95 --eval SET GLOBAL group_replication_ssl_mode= $conf_rec_ssl_mode_s2
96 --enable_query_log
97
98 --connection server1
99 --echo server1
100
101 set session sql_log_bin=0;
102 DROP USER 'rec_ssl_user';
103 set session sql_log_bin=1;
104
105 --disable_query_log
106 --eval SET GLOBAL group_replication_ssl_mode= $conf_rec_ssl_mode_s1
107 --enable_query_log
108
109 DROP TABLE t1;
110
111 --connection server2
112 --echo server2
113
114 set session sql_log_bin=0;
115 DROP USER 'rec_ssl_user';
116 set session sql_log_bin=1;
117
118 --source include/group_replication_end.inc