Debian Codegraph @

mysql-test/suite/group_replication/t/gr_recovery_tlsv13_nondefault_ciphersuite.test

raw
1 ################################################################################
2 # Base test to verify the basic TLS 1.3 support on Group Replication.
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 TLS 1.3 with
7 # a non-default ciphersuite.
8 # 2. Add some data and bootstrap start a group on M1.
9 # 3. Configure joining member (M2) to use SSL options on recovery. Start GR on
10 # M2. Check the data is there.
11 # 4. Clean up.
12 ################################################################################
13
14 --source include/have_tlsv13.inc
15 --source include/have_group_replication_plugin.inc
16 --let $rpl_skip_group_replication_start= 1
17 --source include/group_replication.inc
18
19 --echo #
20 --echo # Setup the first member with a recovery user that requires TLS 1.3
21 --echo #
22
23 --let $rpl_connection_name= server1
24 --source include/rpl_connection.inc
25
26 # create a user for replication that requires ssl encryption
27 SET SESSION sql_log_bin=0;
28 CREATE USER 'rec_ssl_user'@'%' REQUIRE SSL;
29 GRANT replication slave ON *.* TO 'rec_ssl_user'@'%';
30 GRANT GROUP_REPLICATION_STREAM ON *.* TO 'rec_ssl_user'@'%';
31 FLUSH PRIVILEGES;
32 SET SESSION sql_log_bin=1;
33
34 SET @tls_version_saved= @@GLOBAL.tls_version;
35 SET GLOBAL tls_version='TLSv1.3';
36 SET @tls_ciphersuites_saved= @@GLOBAL.tls_ciphersuites;
37 SET GLOBAL tls_ciphersuites='TLS_CHACHA20_POLY1305_SHA256';
38 SET @group_replication_recovery_tls_ciphersuites_saved= @@GLOBAL.group_replication_recovery_tls_ciphersuites;
39 SET GLOBAL group_replication_recovery_tls_ciphersuites='TLS_CHACHA20_POLY1305_SHA256';
40
41 SET @conf_rec_ssl_mode= @@GLOBAL.group_replication_ssl_mode;
42 SET GLOBAL group_replication_ssl_mode= REQUIRED;
43
44 ALTER INSTANCE RELOAD TLS;
45
46 --echo #
47 --echo # Add some data and start the member
48 --echo #
49
50 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
51 INSERT INTO t1 VALUES (1);
52
53 --source include/start_and_bootstrap_group_replication.inc
54
55 --echo #
56 --echo # Configure a joining member to use SSL options on recovery and start it
57 --echo #
58
59 --let $rpl_connection_name= server2
60 --source include/rpl_connection.inc
61
62 SET SESSION sql_log_bin=0;
63 CREATE USER 'rec_ssl_user'@'%' REQUIRE SSL;
64 GRANT replication slave ON *.* TO 'rec_ssl_user'@'%';
65 GRANT GROUP_REPLICATION_STREAM ON *.* TO 'rec_ssl_user'@'%';
66 FLUSH PRIVILEGES;
67 SET SESSION sql_log_bin=1;
68
69 # Configure TLS on the server to allow GCS connections over TLS
70 SET @tls_version_saved= @@GLOBAL.tls_version;
71 SET GLOBAL tls_version='TLSv1.3';
72 SET @tls_ciphersuites_saved= @@GLOBAL.tls_ciphersuites;
73 SET GLOBAL tls_ciphersuites='TLS_CHACHA20_POLY1305_SHA256';
74
75 SET @conf_rec_ssl_mode= @@GLOBAL.group_replication_ssl_mode;
76 SET GLOBAL group_replication_ssl_mode= REQUIRED;
77
78 ALTER INSTANCE RELOAD TLS;
79
80 --disable_warnings
81 CHANGE REPLICATION SOURCE TO SOURCE_USER="rec_ssl_user" FOR CHANNEL "group_replication_recovery";
82 --enable_warnings
83
84 SET @group_replication_recovery_use_ssl_saved= @@GLOBAL.group_replication_recovery_use_ssl;
85 SET GLOBAL group_replication_recovery_use_ssl=1;
86 SET @group_replication_recovery_tls_ciphersuites_saved= @@GLOBAL.group_replication_recovery_tls_ciphersuites;
87 SET GLOBAL group_replication_recovery_tls_ciphersuites='TLS_CHACHA20_POLY1305_SHA256';
88
89 --source include/start_group_replication.inc
90
91 --echo #
92 --echo # Check the data is there
93 --echo #
94
95 --let $assert_text= On the recovered member, the table should exist and have 1 elements;
96 --let $assert_cond= [select count(*) from t1] = 1;
97 --source include/assert.inc
98
99 --echo #
100 --echo # Clean up
101 --echo #
102 --let $rpl_connection_name= server2
103 --source include/rpl_connection.inc
104 SET @@GLOBAL.tls_version= @tls_version_saved;
105 SET @@GLOBAL.tls_ciphersuites= @tls_ciphersuites_saved;
106 ALTER INSTANCE RELOAD TLS;
107 SET @@GLOBAL.group_replication_recovery_use_ssl= @group_replication_recovery_use_ssl_saved;
108 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= @group_replication_recovery_tls_ciphersuites_saved;
109
110 --let $rpl_connection_name= server1
111 --source include/rpl_connection.inc
112 SET @@GLOBAL.tls_version= @tls_version_saved;
113 SET @@GLOBAL.tls_ciphersuites= @tls_ciphersuites_saved;
114 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= @group_replication_recovery_tls_ciphersuites_saved;
115
116 SET @@GLOBAL.group_replication_ssl_mode= @conf_rec_ssl_mode;
117 ALTER INSTANCE RELOAD TLS;
118
119 ALTER INSTANCE RELOAD TLS;
120
121 SET SESSION sql_log_bin=0;
122 DROP USER 'rec_ssl_user';
123 SET SESSION sql_log_bin=1;
124
125 DROP TABLE t1;
126
127 --let $rpl_connection_name= server2
128 --source include/rpl_connection.inc
129
130 SET SESSION sql_log_bin=0;
131 DROP USER 'rec_ssl_user';
132 SET SESSION sql_log_bin=1;
133
134 SET @@GLOBAL.group_replication_ssl_mode= @conf_rec_ssl_mode;
135 ALTER INSTANCE RELOAD TLS;
136
137 --source include/group_replication_end.inc