Debian Codegraph @

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

raw
1 #
2 # Validate that Group Replication SSL mode works properly with TLS v1.3 when
3 # a valid configuration is set at server runtime.
4 #
5 # Steps:
6 # 0. Configure members to use encryption and save defaults.
7 # 1. 3 members group with OpenSSL 1.1.1
8 # Verify that it is possible to join a node which has TLS version 1.3
9 # and lower versions to a group which doesn't have this version.
10 # No --tls-ciphersuites
11 # server1: --tls-version='TLSv1.2'
12 # server2: --tls-version='TLSv1.2'
13 # server3: --tls-version='TLSv1.2,TLSv1.3'
14 # Outcome: group will work.
15 # 2. 2 members group with OpenSSL 1.1.1
16 # Verify that it is possible to start group replication when :
17 # * TLS version is 1.3
18 # * A TLS ciphersuite compatible with this version is enabled
19 # --tls-version='TLSv1.3'
20 # --tls-ciphersuites='TLS_AES_128_CCM_SHA256' (disabled by default)
21 # Outcome: group will work.
22 # 3. 3 members group with OpenSSL 1.1.1
23 # Verify that it is possible to start group replication when:
24 # * TLS version is 1.3
25 # * Intersection of the allowed TLS chipersuites is non empty and valid.
26 # --tls-version='TLSv1.3'
27 # server1: --tls-ciphersuites='TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384'
28 # server2: --tls-ciphersuites='TLS_AES_256_GCM_SHA384:TLS_AES_128_CCM_SHA256'
29 # server3: --tls-ciphersuites='TLS_AES_128_CCM_8_SHA256: TLS_AES_256_GCM_SHA384'
30 # Outcome: group will work.
31 # 4. 3 members group with OpenSSL 1.1.1
32 # Verify that is is possible to join a node to a group when:
33 # * List of TLS version of the group includes v1.3 and lower versions
34 # * TLS chipersuites of the node is compatible with the group,
35 # therefore TLS v1.3 is supported
36 # * SLL cipher of the node is incompatible with the group, therefore
37 # TLS versions lower than 1.3 are not supported
38 # --tls-version='TLSv1.2,TLSv1.3'
39 # server1: --tls-ciphersuites='TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384'
40 # server1: --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384'
41 # server2: --tls-ciphersuites='TLS_AES_256_GCM_SHA384:TLS_AES_128_CCM_SHA256'
42 # server2: --ssl-cipher='DHE-RSA-AES256-GCM-SHA384'
43 # server3: --tls-ciphersuites='TLS_AES_256_GCM_SHA384'
44 # server3: --ssl-cipher='DHE-RSA-AES128-GCM-SHA256'
45 # Outcome: group will work.
46 # 5. Clean up.
47 #
48
49
50 --source include/big_test.inc
51 --source include/have_tlsv13.inc
52 --source include/have_group_replication_plugin.inc
53 --let $rpl_server_count= 3
54 --source include/force_restart.inc
55 --let $rpl_skip_group_replication_start= 1
56 --source include/group_replication.inc
57
58
59 --echo
60 --echo ############################################################
61 --echo # 0. Configure members to use encryption and save defaults.
62 --let $rpl_connection_name= server1
63 --source include/rpl_connection.inc
64 SET @tls_version_save= @@GLOBAL.tls_version;
65 SET @tls_ciphersuites_save= @@GLOBAL.tls_ciphersuites;
66 SET @ssl_cipher_save= @@GLOBAL.ssl_cipher;
67 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
68 SET @group_replication_recovery_tls_version_save= @@GLOBAL.group_replication_recovery_tls_version;
69 SET @group_replication_recovery_tls_ciphersuites_save= @@GLOBAL.group_replication_recovery_tls_ciphersuites;
70
71 SET @@GLOBAL.group_replication_ssl_mode= REQUIRED;
72
73 --let $rpl_connection_name= server2
74 --source include/rpl_connection.inc
75 SET @tls_version_save= @@GLOBAL.tls_version;
76 SET @tls_ciphersuites_save= @@GLOBAL.tls_ciphersuites;
77 SET @ssl_cipher_save= @@GLOBAL.ssl_cipher;
78 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
79 SET @group_replication_recovery_tls_version_save= @@GLOBAL.group_replication_recovery_tls_version;
80 SET @group_replication_recovery_tls_ciphersuites_save= @@GLOBAL.group_replication_recovery_tls_ciphersuites;
81
82 SET @@GLOBAL.group_replication_ssl_mode= REQUIRED;
83
84
85 SET SESSION sql_log_bin= 0;
86 call mtr.add_suppression("\\[GCS\\] Error connecting to all peers. Member join failed. Local port:*");
87 call mtr.add_suppression("\\[GCS\\] The member was unable to join the group.*");
88 call mtr.add_suppression("Timeout on wait for view after joining group");
89 call mtr.add_suppression("Error connecting to the local group communication engine instance");
90 SET SESSION sql_log_bin= 1;
91
92 --let $rpl_connection_name= server3
93 --source include/rpl_connection.inc
94 SET @tls_version_save= @@GLOBAL.tls_version;
95 SET @tls_ciphersuites_save= @@GLOBAL.tls_ciphersuites;
96 SET @ssl_cipher_save= @@GLOBAL.ssl_cipher;
97 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
98 SET @group_replication_recovery_tls_version_save= @@GLOBAL.group_replication_recovery_tls_version;
99 SET @group_replication_recovery_tls_ciphersuites_save= @@GLOBAL.group_replication_recovery_tls_ciphersuites;
100
101 SET @@GLOBAL.group_replication_ssl_mode= REQUIRED;
102
103 SET SESSION sql_log_bin= 0;
104 call mtr.add_suppression("\\[GCS\\] Error connecting to all peers. Member join failed. Local port:*");
105 call mtr.add_suppression("\\[GCS\\] The member was unable to join the group.*");
106 call mtr.add_suppression("Timeout on wait for view after joining group");
107 call mtr.add_suppression("Error connecting to the local group communication engine instance");
108 SET SESSION sql_log_bin= 1;
109
110
111 --echo
112 --echo ############################################################
113 --echo # 1. 3 members group with OpenSSL 1.1.1
114 --echo # Verify that it is possible to join a node which has TLS version 1.3
115 --echo # and lower versions to a group which doesn't have this version.
116 --echo # No --tls-ciphersuites
117 --echo # server1: --tls-version='TLSv1.2'
118 --echo # server2: --tls-version='TLSv1.2'
119 --echo # server3: --tls-version='TLSv1.2,TLSv1.3'
120 --echo # Outcome: group will work.
121
122
123 --let $rpl_connection_name= server1
124 --source include/rpl_connection.inc
125
126 SET @@GLOBAL.tls_version= 'TLSv1.2';
127 ALTER INSTANCE RELOAD TLS;
128 --source include/start_and_bootstrap_group_replication.inc
129
130 --let $rpl_connection_name= server2
131 --source include/rpl_connection.inc
132
133 SET @@GLOBAL.tls_version= 'TLSv1.2';
134 ALTER INSTANCE RELOAD TLS;
135 --source include/start_group_replication.inc
136
137 --let $rpl_connection_name= server3
138 --source include/rpl_connection.inc
139
140 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
141 ALTER INSTANCE RELOAD TLS;
142 --source include/start_group_replication.inc
143
144 --let $group_replication_number_of_members= 3
145 --source include/gr_wait_for_number_of_members.inc
146
147 --let $rpl_connection_name= server1
148 --source include/rpl_connection.inc
149 --source include/stop_group_replication.inc
150
151 --let $rpl_connection_name= server2
152 --source include/rpl_connection.inc
153 --source include/stop_group_replication.inc
154
155 --let $rpl_connection_name= server3
156 --source include/rpl_connection.inc
157 --source include/stop_group_replication.inc
158
159
160 --echo
161 --echo ############################################################
162 --echo # 2. 2 members group with OpenSSL 1.1.1
163 --echo # Verify that it is possible to start group replication when :
164 --echo # * TLS version is 1.3
165 --echo # * A TLS ciphersuite compatible with this version is enabled
166 --echo # --tls-version='TLSv1.3'
167 --echo # --tls-ciphersuites='TLS_AES_128_CCM_SHA256' (disabled by default)
168 --echo # Outcome: group will work.
169
170
171 --let $rpl_connection_name= server1
172 --source include/rpl_connection.inc
173
174 SET @@GLOBAL.tls_version= 'TLSv1.3';
175 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_128_CCM_SHA256';
176
177 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
178 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= 'TLS_AES_128_CCM_SHA256';
179
180 ALTER INSTANCE RELOAD TLS;
181 --source include/start_and_bootstrap_group_replication.inc
182
183 --let $rpl_connection_name= server2
184 --source include/rpl_connection.inc
185
186 SET @@GLOBAL.tls_version= 'TLSv1.3';
187 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_128_CCM_SHA256';
188
189 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
190 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= 'TLS_AES_128_CCM_SHA256';
191
192 ALTER INSTANCE RELOAD TLS;
193 --source include/start_group_replication.inc
194
195 --let $group_replication_number_of_members= 2
196 --source include/gr_wait_for_number_of_members.inc
197
198 --let $rpl_connection_name= server1
199 --source include/rpl_connection.inc
200 --source include/stop_group_replication.inc
201
202 --let $rpl_connection_name= server2
203 --source include/rpl_connection.inc
204 --source include/stop_group_replication.inc
205
206
207 --echo
208 --echo ############################################################
209 --echo # 3. 3 members group with OpenSSL 1.1.1
210 --echo # Verify that it is possible to start group replication when:
211 --echo # * TLS version is 1.3
212 --echo # * Intersection of the allowed TLS chipersuites is non empty and valid.
213 --echo # --tls-version='TLSv1.3'
214 --echo # server1: --tls-ciphersuites='TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384'
215 --echo # server2: --tls-ciphersuites='TLS_AES_256_GCM_SHA384:TLS_AES_128_CCM_SHA256'
216 --echo # server3: --tls-ciphersuites='TLS_AES_128_CCM_8_SHA256: TLS_AES_256_GCM_SHA384'
217 --echo # Outcome: group will work.
218
219
220 --let $rpl_connection_name= server1
221 --source include/rpl_connection.inc
222
223 SET @@GLOBAL.tls_version= 'TLSv1.3';
224 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384';
225
226 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
227 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= 'TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384';
228
229 ALTER INSTANCE RELOAD TLS;
230 --source include/start_and_bootstrap_group_replication.inc
231
232 --let $rpl_connection_name= server2
233 --source include/rpl_connection.inc
234
235 SET @@GLOBAL.tls_version= 'TLSv1.3';
236 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_256_GCM_SHA384:TLS_AES_128_CCM_SHA256';
237
238 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
239 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= 'TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384';
240
241 ALTER INSTANCE RELOAD TLS;
242 --source include/start_group_replication.inc
243
244 --let $rpl_connection_name= server3
245 --source include/rpl_connection.inc
246
247 SET @@GLOBAL.tls_version= 'TLSv1.3';
248 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_128_CCM_8_SHA256: TLS_AES_256_GCM_SHA384';
249
250 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
251 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= 'TLS_AES_128_CCM_8_SHA256: TLS_AES_256_GCM_SHA384';
252
253 ALTER INSTANCE RELOAD TLS;
254 --source include/start_group_replication.inc
255
256 --let $group_replication_number_of_members= 3
257 --source include/gr_wait_for_number_of_members.inc
258
259 --let $rpl_connection_name= server1
260 --source include/rpl_connection.inc
261 --source include/stop_group_replication.inc
262
263 --let $rpl_connection_name= server2
264 --source include/rpl_connection.inc
265 --source include/stop_group_replication.inc
266
267 --let $rpl_connection_name= server3
268 --source include/rpl_connection.inc
269 --source include/stop_group_replication.inc
270
271
272 --echo
273 --echo ############################################################
274 --echo # 4. 3 members group with OpenSSL 1.1.1
275 --echo # Verify that is is possible to join a node to a group when:
276 --echo # * List of TLS version of the group includes v1.3 and lower versions
277 --echo # * TLS chipersuites of the node is compatible with the group,
278 --echo # therefore TLS v1.3 is supported
279 --echo # * SLL cipher of the node is incompatible with the group, therefore
280 --echo # TLS versions lower than 1.3 are not supported
281 --echo # --tls-version='TLSv1.2,TLSv1.3'
282 --echo # server1: --tls-ciphersuites='TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384'
283 --echo # server1: --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384'
284 --echo # server2: --tls-ciphersuites='TLS_AES_256_GCM_SHA384:TLS_AES_128_CCM_SHA256'
285 --echo # server2: --ssl-cipher='DHE-RSA-AES256-GCM-SHA384'
286 --echo # server3: --tls-ciphersuites='TLS_AES_256_GCM_SHA384'
287 --echo # server3: --ssl-cipher='DHE-RSA-AES128-GCM-SHA256'
288 --echo # Outcome: group will work.
289
290 --let $rpl_connection_name= server1
291 --source include/rpl_connection.inc
292
293 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
294 SET @@GLOBAL.ssl_cipher= 'ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384';
295 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384';
296 ALTER INSTANCE RELOAD TLS;
297 --source include/start_and_bootstrap_group_replication.inc
298
299 --let $rpl_connection_name= server2
300 --source include/rpl_connection.inc
301
302 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
303 SET @@GLOBAL.ssl_cipher= 'DHE-RSA-AES256-GCM-SHA384';
304 SET @@GLOBAL.tls_ciphersuites ='TLS_AES_256_GCM_SHA384:TLS_AES_128_CCM_SHA256';
305 ALTER INSTANCE RELOAD TLS;
306 --source include/start_group_replication.inc
307
308 --let $rpl_connection_name= server3
309 --source include/rpl_connection.inc
310
311 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
312 SET @@GLOBAL.ssl_cipher = 'DHE-RSA-AES128-GCM-SHA256';
313 SET @@GLOBAL.tls_ciphersuites = 'TLS_AES_256_GCM_SHA384';
314 ALTER INSTANCE RELOAD TLS;
315 --source include/start_group_replication.inc
316
317 --let $group_replication_number_of_members= 3
318 --source include/gr_wait_for_number_of_members.inc
319
320 --let $rpl_connection_name= server1
321 --source include/rpl_connection.inc
322 --source include/stop_group_replication.inc
323
324 --let $rpl_connection_name= server2
325 --source include/rpl_connection.inc
326 --source include/stop_group_replication.inc
327
328 --let $rpl_connection_name= server3
329 --source include/rpl_connection.inc
330 --source include/stop_group_replication.inc
331
332
333 --echo
334 --echo ############################################################
335 --echo # 5. Clean up.
336
337 --let $rpl_connection_name= server1
338 --source include/rpl_connection.inc
339 SET @@GLOBAL.group_replication_ssl_mode= @group_replication_ssl_mode_save;
340 SET @@GLOBAL.tls_version= @tls_version_save;
341 SET @@GLOBAL.tls_ciphersuites= @tls_ciphersuites_save;
342 SET @@GLOBAL.ssl_cipher = @ssl_cipher_save;
343 SET @@GLOBAL.group_replication_recovery_tls_version= @group_replication_recovery_tls_version_save;
344 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= @group_replication_recovery_tls_ciphersuites_save;
345
346 ALTER INSTANCE RELOAD TLS;
347
348 --let $rpl_connection_name= server2
349 --source include/rpl_connection.inc
350 SET @@GLOBAL.group_replication_ssl_mode= @group_replication_ssl_mode_save;
351 SET @@GLOBAL.tls_version= @tls_version_save;
352 SET @@GLOBAL.tls_ciphersuites= @tls_ciphersuites_save;
353 SET @@GLOBAL.ssl_cipher = @ssl_cipher_save;
354 SET @@GLOBAL.group_replication_recovery_tls_version= @group_replication_recovery_tls_version_save;
355 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= @group_replication_recovery_tls_ciphersuites_save;
356 ALTER INSTANCE RELOAD TLS;
357
358 --let $rpl_connection_name= server3
359 --source include/rpl_connection.inc
360 SET @@GLOBAL.group_replication_ssl_mode= @group_replication_ssl_mode_save;
361 SET @@GLOBAL.tls_version= @tls_version_save;
362 SET @@GLOBAL.tls_ciphersuites = @tls_ciphersuites_save;
363 SET @@GLOBAL.ssl_cipher = @ssl_cipher_save;
364 SET @@GLOBAL.group_replication_recovery_tls_version= @group_replication_recovery_tls_version_save;
365 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= @group_replication_recovery_tls_ciphersuites_save;
366 ALTER INSTANCE RELOAD TLS;
367
368 --source include/group_replication_end.inc