Debian Codegraph @

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

raw
1 #
2 # Validate that Group Replication ssl mode works properly with TLSv1.3.
3 #
4 # Steps:
5 # 0. Configure members to use encryption and save defaults.
6 # 1. 2 members group with OpenSSL 1.1.1
7 # No --tls-ciphersuites
8 # No --tls-version
9 # Outcome: group will work.
10 # 2. 2 members group with OpenSSL 1.1.1
11 # No --tls-ciphersuites
12 # server1: --tls-version='TLSv1.2,TLSv1.3'
13 # server2: --tls-version='TLSv1.2'
14 # Outcome: group will work.
15 # 3. 2 members group with OpenSSL 1.1.1
16 # No --tls-ciphersuites
17 # server1: --tls-version='TLSv1.3'
18 # server2: --tls-version='TLSv1.2'
19 # Outcome: group will not work.
20 # 4. 2 members group with OpenSSL 1.1.1
21 # No --tls-ciphersuites
22 # server1: --tls-version='TLSv1.3'
23 # server2: --tls-version='TLSv1.3'
24 # Outcome: group will work.
25 # 5. 2 members group with OpenSSL 1.1.1
26 # --tls-ciphersuites='TLS_AES_256_GCM_SHA384'
27 # server1: --tls-version='TLSv1.2,TLSv1.3'
28 # server2: --tls-version='TLSv1.2,TLSv1.3'
29 # Outcome: group will work.
30 # 6. 2 members group with OpenSSL 1.1.1
31 # --tls-ciphersuites= '', which will disable all ciphers.
32 # No --tls-version
33 # Outcome: group will not work.
34 # 7. Clean up.
35 #
36 --source include/big_test.inc
37 --source include/have_tlsv13.inc
38 --source include/have_group_replication_plugin.inc
39 --source include/force_restart.inc
40 --let $rpl_skip_group_replication_start= 1
41 --source include/group_replication.inc
42
43
44 #check which stack are we using
45 --let $have_mysql_stack= `SELECT @@group_replication_communication_stack LIKE 'MySQL'`
46
47 --echo
48 --echo ############################################################
49 --echo # 0. Configure members to use encryption and save defaults.
50 --let $rpl_connection_name= server1
51 --source include/rpl_connection.inc
52 SET @tls_version_save= @@GLOBAL.tls_version;
53 SET @tls_ciphersuites_save= @@GLOBAL.tls_ciphersuites;
54 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
55
56 if($have_mysql_stack) {
57 SET @tls_version_recovery_save= @@GLOBAL.group_replication_recovery_tls_version;
58 SET @tls_ciphersuites_recovery_save= @@GLOBAL.group_replication_recovery_tls_ciphersuites;
59 }
60
61 SET @@GLOBAL.group_replication_ssl_mode= REQUIRED;
62
63 --let $rpl_connection_name= server2
64 --source include/rpl_connection.inc
65 SET @tls_version_save= @@GLOBAL.tls_version;
66 SET @tls_ciphersuites_save= @@GLOBAL.tls_ciphersuites;
67 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
68 SET @@GLOBAL.group_replication_ssl_mode= REQUIRED;
69
70 if($have_mysql_stack) {
71 SET @tls_version_recovery_save= @@GLOBAL.group_replication_recovery_tls_version;
72 SET @tls_ciphersuites_recovery_save= @@GLOBAL.group_replication_recovery_tls_ciphersuites;
73 }
74
75 SET SESSION sql_log_bin= 0;
76 call mtr.add_suppression("\\[GCS\\] Error connecting to all peers. Member join failed. Local port:*");
77 call mtr.add_suppression("\\[GCS\\] The member was unable to join the group.*");
78 call mtr.add_suppression("Timeout on wait for view after joining group");
79 SET SESSION sql_log_bin= 1;
80
81
82 --echo
83 --echo ############################################################
84 --echo # 1. 2 members group with OpenSSL 1.1.1
85 --echo # No --tls-ciphersuites
86 --echo # No --tls-version
87 --echo # Outcome: group will work.
88 --let $rpl_connection_name= server1
89 --source include/rpl_connection.inc
90 --source include/start_and_bootstrap_group_replication.inc
91
92 --let $rpl_connection_name= server2
93 --source include/rpl_connection.inc
94 --source include/start_group_replication.inc
95
96 --let $group_replication_number_of_members= 2
97 --source include/gr_wait_for_number_of_members.inc
98
99 --let $rpl_connection_name= server1
100 --source include/rpl_connection.inc
101 --source include/stop_group_replication.inc
102
103 --let $rpl_connection_name= server2
104 --source include/rpl_connection.inc
105 --source include/stop_group_replication.inc
106
107
108 --echo
109 --echo ############################################################
110 --echo # 2. 2 members group with OpenSSL 1.1.1
111 --echo # No --tls-ciphersuites
112 --echo # server1: --tls-version='TLSv1.2,TLSv1.3'
113 --echo # server2: --tls-version='TLSv1.2'
114 --echo # Outcome: group will work.
115 --let $rpl_connection_name= server1
116 --source include/rpl_connection.inc
117
118 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
119 if($have_mysql_stack) {
120 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.2,TLSv1.3';
121 }
122 ALTER INSTANCE RELOAD TLS;
123 --source include/start_and_bootstrap_group_replication.inc
124
125 --let $rpl_connection_name= server2
126 --source include/rpl_connection.inc
127
128 SET @@GLOBAL.tls_version= 'TLSv1.2';
129 if($have_mysql_stack) {
130 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.2';
131 }
132 ALTER INSTANCE RELOAD TLS;
133 --source include/start_group_replication.inc
134
135 --let $group_replication_number_of_members= 2
136 --source include/gr_wait_for_number_of_members.inc
137
138 --let $rpl_connection_name= server1
139 --source include/rpl_connection.inc
140 --source include/stop_group_replication.inc
141
142 --let $rpl_connection_name= server2
143 --source include/rpl_connection.inc
144 --source include/stop_group_replication.inc
145
146
147 --echo
148 --echo ############################################################
149 --echo # 3. 2 members group with OpenSSL 1.1.1
150 --echo # No --tls-ciphersuites
151 --echo # server1: --tls-version='TLSv1.3'
152 --echo # server2: --tls-version='TLSv1.2'
153 --echo # Outcome: group will not work.
154 --let $rpl_connection_name= server1
155 --source include/rpl_connection.inc
156
157 SET @@GLOBAL.tls_version= 'TLSv1.3';
158 if($have_mysql_stack) {
159 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
160 }
161 ALTER INSTANCE RELOAD TLS;
162 --source include/start_and_bootstrap_group_replication.inc
163
164 --let $rpl_connection_name= server2
165 --source include/rpl_connection.inc
166
167 SET @@GLOBAL.tls_version= 'TLSv1.2';
168 if($have_mysql_stack) {
169 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.2';
170 }
171 ALTER INSTANCE RELOAD TLS;
172
173 --error ER_GROUP_REPLICATION_CONFIGURATION
174 START GROUP_REPLICATION;
175
176 --let $rpl_connection_name= server1
177 --source include/rpl_connection.inc
178 --source include/stop_group_replication.inc
179
180
181 --echo
182 --echo ############################################################
183 --echo # 4. 2 members group with OpenSSL 1.1.1
184 --echo # No --tls-ciphersuites
185 --echo # server1: --tls-version='TLSv1.3'
186 --echo # server2: --tls-version='TLSv1.3'
187 --echo # Outcome: group will work.
188 --let $rpl_connection_name= server1
189 --source include/rpl_connection.inc
190
191 SET @@GLOBAL.tls_version= 'TLSv1.3';
192 if($have_mysql_stack) {
193 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
194 }
195 ALTER INSTANCE RELOAD TLS;
196 --source include/start_and_bootstrap_group_replication.inc
197
198 --let $rpl_connection_name= server2
199 --source include/rpl_connection.inc
200
201 SET @@GLOBAL.tls_version= 'TLSv1.3';
202 if($have_mysql_stack) {
203 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
204 }
205 ALTER INSTANCE RELOAD TLS;
206 --source include/start_group_replication.inc
207
208 --let $group_replication_number_of_members= 2
209 --source include/gr_wait_for_number_of_members.inc
210
211 --let $rpl_connection_name= server1
212 --source include/rpl_connection.inc
213 --source include/stop_group_replication.inc
214
215 --let $rpl_connection_name= server2
216 --source include/rpl_connection.inc
217 --source include/stop_group_replication.inc
218
219
220 --echo
221 --echo ############################################################
222 --echo # 5. 2 members group with OpenSSL 1.1.1
223 --echo # --tls-ciphersuites='TLS_AES_256_GCM_SHA384'
224 --echo # server1: --tls-version='TLSv1.2,TLSv1.3'
225 --echo # server2: --tls-version='TLSv1.2,TLSv1.3'
226 --echo # Outcome: group will work.
227 --let $rpl_connection_name= server1
228 --source include/rpl_connection.inc
229
230 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
231 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_256_GCM_SHA384';
232 if($have_mysql_stack) {
233 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.2,TLSv1.3';
234 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= 'TLS_AES_256_GCM_SHA384';
235 }
236 ALTER INSTANCE RELOAD TLS;
237 --source include/start_and_bootstrap_group_replication.inc
238
239 --let $rpl_connection_name= server2
240 --source include/rpl_connection.inc
241
242 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
243 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_256_GCM_SHA384';
244 if($have_mysql_stack) {
245 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.2,TLSv1.3';
246 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= 'TLS_AES_256_GCM_SHA384';
247 }
248 ALTER INSTANCE RELOAD TLS;
249 --source include/start_group_replication.inc
250
251 --let $group_replication_number_of_members= 2
252 --source include/gr_wait_for_number_of_members.inc
253
254 --let $rpl_connection_name= server1
255 --source include/rpl_connection.inc
256 --source include/stop_group_replication.inc
257
258 --let $rpl_connection_name= server2
259 --source include/rpl_connection.inc
260 --source include/stop_group_replication.inc
261
262
263 --echo
264 --echo ############################################################
265 --echo # 6. 2 members group with OpenSSL 1.1.1
266 --echo # --tls-ciphersuites= '', which will disable all ciphers.
267 --echo # No --tls-version
268 --echo # Outcome: group will not work.
269 --let $rpl_connection_name= server1
270 --source include/rpl_connection.inc
271 --source include/gr_set_bootstrap_group.inc
272
273 SET @@GLOBAL.tls_ciphersuites= '';
274 if($have_mysql_stack) {
275 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= '';
276 }
277 ALTER INSTANCE RELOAD TLS;
278
279 --error ER_GROUP_REPLICATION_CONFIGURATION
280 START GROUP_REPLICATION;
281
282 --source include/gr_clear_bootstrap_group.inc
283
284 if(!$have_mysql_stack) {
285 --let $grep_file= $MYSQLTEST_VARDIR/tmp/gr_ssl_tls13.1.err
286 --let $grep_pattern= Error connecting using SSL
287 --let $grep_output= boolean
288 --source include/grep_pattern.inc
289 }
290
291 --echo
292 --echo ############################################################
293 --echo # 7. Clean up.
294 --let $rpl_connection_name= server1
295 --source include/rpl_connection.inc
296 SET @@GLOBAL.group_replication_ssl_mode= @group_replication_ssl_mode_save;
297 SET @@GLOBAL.tls_version= @tls_version_save;
298 SET @@GLOBAL.tls_ciphersuites= @tls_ciphersuites_save;
299 if($have_mysql_stack) {
300 SET @@GLOBAL.group_replication_recovery_tls_version= @tls_version_recovery_save;
301 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= @tls_ciphersuites_recovery_save;
302 }
303 ALTER INSTANCE RELOAD TLS;
304
305 --let $rpl_connection_name= server2
306 --source include/rpl_connection.inc
307 SET @@GLOBAL.group_replication_ssl_mode= @group_replication_ssl_mode_save;
308 SET @@GLOBAL.tls_version= @tls_version_save;
309 SET @@GLOBAL.tls_ciphersuites= @tls_ciphersuites_save;
310 if($have_mysql_stack) {
311 SET @@GLOBAL.group_replication_recovery_tls_version= @tls_version_recovery_save;
312 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= @tls_ciphersuites_recovery_save;
313 }
314 ALTER INSTANCE RELOAD TLS;
315
316 --source include/group_replication_end.inc