Debian Codegraph @

mysql-test/suite/auth_sec/t/wl15800_ciphers_tlsv12.test

raw
1 --source include/not_tlsv13.inc
2 --source include/check_openssl_version.inc
3
4 # Save the initial number of concurrent sessions
5 --source include/count_sessions.inc
6
7 --echo #=======================================================================
8 --echo
9 --echo # Setup
10 --echo
11 --connection default
12 CREATE USER arthurdent@localhost;
13 GRANT SERVICE_CONNECTION_ADMIN ON *.* TO arthurdent@localhost;
14 CREATE DATABASE cipher_data;
15 CREATE TABLE cipher_data.acceptable(ciphers JSON);
16 CREATE TABLE cipher_data.deprecated(ciphers JSON);
17 CREATE TABLE cipher_data.blocked(ciphers JSON);
18
19 --let $CIPHER_DB = cipher_data
20 --let $USER = arthurdent
21 --let $OPENSSL_102 = 1
22
23 --echo
24 --echo #=======================================================================
25 --echo
26 --echo # Cert type: RSA | TLS version: 1.2
27 --echo
28
29 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
30 --eval SET @@global.ssl_ca='$MYSQL_TEST_DIR/std_data/cacert.pem'
31 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
32 --eval SET @@global.ssl_cert='$MYSQL_TEST_DIR/std_data/server-cert.pem'
33 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
34 --eval SET @@global.ssl_key='$MYSQL_TEST_DIR/std_data/server-key.pem'
35 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_main;
36 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
37 --eval SET @@global.admin_ssl_ca='$MYSQL_TEST_DIR/std_data/cacert.pem'
38 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
39 --eval SET @@global.admin_ssl_cert='$MYSQL_TEST_DIR/std_data/server-cert.pem'
40 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
41 --eval SET @@global.admin_ssl_key='$MYSQL_TEST_DIR/std_data/server-key.pem'
42 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
43
44 INSERT INTO cipher_data.acceptable VALUES ('["ECDHE-RSA-AES128-GCM-SHA256",
45 "ECDHE-RSA-AES256-GCM-SHA384",
46 "DHE-RSA-AES128-GCM-SHA256",
47 "DHE-RSA-AES256-GCM-SHA384"]');
48 INSERT INTO cipher_data.deprecated VALUES ('["ECDHE-RSA-AES128-SHA256",
49 "ECDHE-RSA-AES256-SHA384",
50 "DHE-RSA-AES256-SHA256",
51 "DHE-RSA-AES128-SHA256",
52 "DHE-RSA-AES128-SHA",
53 "DHE-RSA-AES256-SHA",
54 "DHE-RSA-CAMELLIA256-SHA",
55 "DHE-RSA-CAMELLIA128-SHA",
56 "AES128-GCM-SHA256",
57 "AES256-GCM-SHA384",
58 "AES128-SHA256",
59 "AES256-SHA256",
60 "AES128-SHA",
61 "AES256-SHA",
62 "CAMELLIA256-SHA",
63 "CAMELLIA128-SHA"]');
64 INSERT INTO cipher_data.blocked VALUES ('["AECDH-NULL-SHA",
65 "ECDHE-RSA-NULL-SHA",
66 "ECDHE-ECDSA-NULL-SHA",
67 "GOST94-NULL-GOST94",
68 "GOST2001-GOST89-GOST89",
69 "ECDH-RSA-NULL-SHA",
70 "ECDH-ECDSA-NULL-SHA",
71 "NULL-SHA256",
72 "NULL-SHA",
73 "NULL-MD5",
74 "AECDH-AES256-SHA",
75 "ADH-AES256-GCM-SHA384",
76 "ADH-AES256-SHA256",
77 "ADH-AES256-SHA",
78 "ADH-CAMELLIA256-SHA256",
79 "ADH-CAMELLIA256-SHA",
80 "AECDH-AES128-SHA",
81 "ADH-AES128-GCM-SHA256",
82 "ADH-AES128-SHA256",
83 "ADH-AES128-SHA",
84 "ADH-CAMELLIA128-SHA256",
85 "AADH-CAMELLIA128-SHA",
86 "AECDH-RC4-SHA",
87 "ADH-RC4-MD5",
88 "AECDH-DES-CBC3-SHA",
89 "ADH-DES-CBC3-SHA",
90 "ADH-DES-CBC-SHA",
91 "EXP-RC4-MD5",
92 "EXP-RC2-CBC-MD5",
93 "EXP-DES-CBC-SHA",
94 "EXP-DH-DSS-DES-CBC-SHA",
95 "EXP-DH-RSA-DES-CBC-SHA",
96 "EXP-EDH-DSS-DES-CBC-SHA",
97 "EXP-EDH-RSA-DES-CBC-SHA",
98 "EXP-ADH-RC4-MD5",
99 "EXP-ADH-DES-CBC-SHA",
100 "EXP-KRB5-DES-CBC-SHA",
101 "EXP-KRB5-RC2-CBC-SHA",
102 "EXP-KRB5-RC4-SHA",
103 "EXP-KRB5-DES-CBC-MD5",
104 "EXP-KRB5-RC2-CBC-MD5",
105 "EXP-KRB5-RC4-MD5",
106 "EXP-RC4-MD5",
107 "EXP-RC2-CBC-MD5",
108 "TLS_RSA_EXPORT_WITH_DES40_CBC_SHA",
109 "EXP-EDH-DSS-DES-CBC-SHA",
110 "EXP-EDH-RSA-DES-CBC-SHA",
111 "EXP-ADH-RC4-MD5",
112 "EXP-ADH-DES-CBC-SHA",
113 "EXP1024-DES-CBC-SHA",
114 "EXP1024-RC4-SHA",
115 "EXP1024-RC4-MD5",
116 "EXP1024-RC2-CBC-MD5",
117 "EXP1024-DHE-DSS-DES-CBC-SHA",
118 "EXP1024-DHE-DSS-RC4-SHA",
119 "EXP-RC4-MD5",
120 "EXP-RC2-CBC-MD5",
121 "EXP-RC2-MD5",
122 "EDH-RSA-DES-CBC-SHA",
123 "EDH-DSS-DES-CBC-SHA",
124 "ADH-DES-CBC-SHA",
125 "DES-CBC-SHA",
126 "ADH-RC4-MD5",
127 "RC4-MD5",
128 "NULL-MD5",
129 "ECDHE-RSA-RC4-SHA",
130 "ECDHE-ECDSA-RC4-SHA",
131 "AECDH-RC4-SHA",
132 "ECDH-RSA-RC4-SHA",
133 "ECDH-ECDSA-RC4-SHA",
134 "RC4-SHA",
135 "AECDH-NULL-SHA",
136 "ECDH-RSA-NULL-SHA",
137 "ECDH-ECDSA-NULL-SHA",
138 "PSK-AES256-CBC-SHA",
139 "PSK-AES128-CBC-SHA",
140 "PSK-3DES-EDE-CBC-SHA",
141 "PSK-RC4-SHA",
142 "EXP-RC2-CBC-MD5",
143 "EXP-KRB5-RC2-CBC-SHA",
144 "EXP1024-RC2-CBC-MD5",
145 "RC2-CBC-MD5",
146 "EXP-RC2-CBC-MD5",
147 "DH-DSS-DES-CBC3-SHA",
148 "DH-RSA-DES-CBC3-SHA",
149 "EDH-DSS-DES-CBC3-SHA",
150 "EDH-RSA-DES-CBC3-SHA",
151 "ECDH-RSA-DES-CBC3-SHA",
152 "ECDH-ECDSA-DES-CBC3-SHA",
153 "ECDHE-RSA-DES-CBC3-SHA",
154 "ECDHE-ECDSA-DES-CBC3-SHA",
155 "DES-CBC3-SHA"]');
156 --let $TLS_VERSION = TLSv1.2
157 --source suite/auth_sec/include/wl15800_cipher_test.inc
158
159 --echo
160 --echo #=======================================================================
161 --echo
162 --echo # Cert type: ECDSA | TLS Version: 1.2
163 --echo
164
165 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
166 --eval SET @@global.ssl_ca='$MYSQL_TEST_DIR/std_data/ecdsa_certs/cacert.pem'
167 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
168 --eval SET @@global.ssl_cert='$MYSQL_TEST_DIR/std_data/ecdsa_certs/server-cert.pem'
169 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
170 --eval SET @@global.ssl_key='$MYSQL_TEST_DIR/std_data/ecdsa_certs/server-key.pem'
171 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_main;
172 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
173 --eval SET @@global.admin_ssl_ca='$MYSQL_TEST_DIR/std_data/ecdsa_certs/cacert.pem'
174 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
175 --eval SET @@global.admin_ssl_cert='$MYSQL_TEST_DIR/std_data/ecdsa_certs/server-cert.pem'
176 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
177 --eval SET @@global.admin_ssl_key='$MYSQL_TEST_DIR/std_data/ecdsa_certs/server-key.pem'
178 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
179
180 TRUNCATE TABLE cipher_data.acceptable;
181 TRUNCATE TABLE cipher_data.deprecated;
182 TRUNCATE TABLE cipher_data.blocked;
183 INSERT INTO cipher_data.acceptable VALUES ('["ECDHE-ECDSA-AES128-GCM-SHA256",
184 "ECDHE-ECDSA-AES256-GCM-SHA384"]');
185 INSERT INTO cipher_data.deprecated VALUES ('["ECDHE-ECDSA-AES128-SHA256",
186 "ECDHE-ECDSA-AES256-SHA384",
187 "ECDHE-ECDSA-AES128-SHA",
188 "ECDHE-ECDSA-AES256-SHA",
189 "ECDH-ECDSA-AES128-SHA256",
190 "ECDH-ECDSA-AES256-SHA384",
191 "ECDH-ECDSA-AES128-SHA",
192 "ECDH-ECDSA-AES256-SHA",
193 "ECDH-ECDSA-AES128-GCM-SHA256",
194 "ECDH-ECDSA-AES256-GCM-SHA384"]');
195 INSERT INTO cipher_data.blocked VALUES ('["AECDH-NULL-SHA",
196 "ECDHE-RSA-NULL-SHA",
197 "ECDHE-ECDSA-NULL-SHA",
198 "GOST94-NULL-GOST94",
199 "GOST2001-GOST89-GOST89",
200 "ECDH-RSA-NULL-SHA",
201 "ECDH-ECDSA-NULL-SHA",
202 "NULL-SHA256",
203 "NULL-SHA",
204 "NULL-MD5",
205 "AECDH-AES256-SHA",
206 "ADH-AES256-GCM-SHA384",
207 "ADH-AES256-SHA256",
208 "ADH-AES256-SHA",
209 "ADH-CAMELLIA256-SHA256",
210 "ADH-CAMELLIA256-SHA",
211 "AECDH-AES128-SHA",
212 "ADH-AES128-GCM-SHA256",
213 "ADH-AES128-SHA256",
214 "ADH-AES128-SHA",
215 "ADH-CAMELLIA128-SHA256",
216 "AADH-CAMELLIA128-SHA",
217 "AECDH-RC4-SHA",
218 "ADH-RC4-MD5",
219 "AECDH-DES-CBC3-SHA",
220 "ADH-DES-CBC3-SHA",
221 "ADH-DES-CBC-SHA",
222 "EXP-RC4-MD5",
223 "EXP-RC2-CBC-MD5",
224 "EXP-DES-CBC-SHA",
225 "EXP-DH-DSS-DES-CBC-SHA",
226 "EXP-DH-RSA-DES-CBC-SHA",
227 "EXP-EDH-DSS-DES-CBC-SHA",
228 "EXP-EDH-RSA-DES-CBC-SHA",
229 "EXP-ADH-RC4-MD5",
230 "EXP-ADH-DES-CBC-SHA",
231 "EXP-KRB5-DES-CBC-SHA",
232 "EXP-KRB5-RC2-CBC-SHA",
233 "EXP-KRB5-RC4-SHA",
234 "EXP-KRB5-DES-CBC-MD5",
235 "EXP-KRB5-RC2-CBC-MD5",
236 "EXP-KRB5-RC4-MD5",
237 "EXP-RC4-MD5",
238 "EXP-RC2-CBC-MD5",
239 "TLS_RSA_EXPORT_WITH_DES40_CBC_SHA",
240 "EXP-EDH-DSS-DES-CBC-SHA",
241 "EXP-EDH-RSA-DES-CBC-SHA",
242 "EXP-ADH-RC4-MD5",
243 "EXP-ADH-DES-CBC-SHA",
244 "EXP1024-DES-CBC-SHA",
245 "EXP1024-RC4-SHA",
246 "EXP1024-RC4-MD5",
247 "EXP1024-RC2-CBC-MD5",
248 "EXP1024-DHE-DSS-DES-CBC-SHA",
249 "EXP1024-DHE-DSS-RC4-SHA",
250 "EXP-RC4-MD5",
251 "EXP-RC2-CBC-MD5",
252 "EXP-RC2-MD5",
253 "EDH-RSA-DES-CBC-SHA",
254 "EDH-DSS-DES-CBC-SHA",
255 "ADH-DES-CBC-SHA",
256 "DES-CBC-SHA",
257 "ADH-RC4-MD5",
258 "RC4-MD5",
259 "NULL-MD5",
260 "ECDHE-RSA-RC4-SHA",
261 "ECDHE-ECDSA-RC4-SHA",
262 "AECDH-RC4-SHA",
263 "ECDH-RSA-RC4-SHA",
264 "ECDH-ECDSA-RC4-SHA",
265 "RC4-SHA",
266 "AECDH-NULL-SHA",
267 "ECDH-RSA-NULL-SHA",
268 "ECDH-ECDSA-NULL-SHA",
269 "PSK-AES256-CBC-SHA",
270 "PSK-AES128-CBC-SHA",
271 "PSK-3DES-EDE-CBC-SHA",
272 "PSK-RC4-SHA",
273 "EXP-RC2-CBC-MD5",
274 "EXP-KRB5-RC2-CBC-SHA",
275 "EXP1024-RC2-CBC-MD5",
276 "RC2-CBC-MD5",
277 "EXP-RC2-CBC-MD5",
278 "DH-DSS-DES-CBC3-SHA",
279 "DH-RSA-DES-CBC3-SHA",
280 "EDH-DSS-DES-CBC3-SHA",
281 "EDH-RSA-DES-CBC3-SHA",
282 "ECDH-RSA-DES-CBC3-SHA",
283 "ECDH-ECDSA-DES-CBC3-SHA",
284 "ECDHE-RSA-DES-CBC3-SHA",
285 "ECDHE-ECDSA-DES-CBC3-SHA",
286 "DES-CBC3-SHA"]');
287 --let $TLS_VERSION = TLSv1.2
288 --source suite/auth_sec/include/wl15800_cipher_test.inc
289
290 --echo
291 --echo #=======================================================================
292 --echo
293 --echo # Cert type: ECDSA | TLS Version: 1.2
294 --echo
295
296 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
297 --eval SET @@global.ssl_ca='$MYSQL_TEST_DIR/std_data/ecdh_rsa_certs/cacert.pem'
298 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
299 --eval SET @@global.ssl_cert='$MYSQL_TEST_DIR/std_data/ecdh_rsa_certs/server-cert.pem'
300 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
301 --eval SET @@global.ssl_key='$MYSQL_TEST_DIR/std_data/ecdh_rsa_certs/server-key.pem'
302 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_main;
303 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
304 --eval SET @@global.admin_ssl_ca='$MYSQL_TEST_DIR/std_data/ecdh_rsa_certs/cacert.pem'
305 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
306 --eval SET @@global.admin_ssl_cert='$MYSQL_TEST_DIR/std_data/ecdh_rsa_certs/server-cert.pem'
307 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
308 --eval SET @@global.admin_ssl_key='$MYSQL_TEST_DIR/std_data/ecdh_rsa_certs/server-key.pem'
309 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
310
311 TRUNCATE TABLE cipher_data.acceptable;
312 TRUNCATE TABLE cipher_data.deprecated;
313 TRUNCATE TABLE cipher_data.blocked;
314 INSERT INTO cipher_data.deprecated VALUES ('["ECDH-RSA-AES128-SHA256",
315 "ECDH-RSA-AES256-SHA384",
316 "ECDH-RSA-AES128-SHA",
317 "ECDH-RSA-AES256-SHA",
318 "ECDH-RSA-AES128-GCM-SHA256",
319 "ECDH-RSA-AES256-GCM-SHA384"]');
320 INSERT INTO cipher_data.blocked VALUES ('["AECDH-NULL-SHA",
321 "ECDHE-RSA-NULL-SHA",
322 "ECDHE-ECDSA-NULL-SHA",
323 "GOST94-NULL-GOST94",
324 "GOST2001-GOST89-GOST89",
325 "ECDH-RSA-NULL-SHA",
326 "ECDH-ECDSA-NULL-SHA",
327 "NULL-SHA256",
328 "NULL-SHA",
329 "NULL-MD5",
330 "AECDH-AES256-SHA",
331 "ADH-AES256-GCM-SHA384",
332 "ADH-AES256-SHA256",
333 "ADH-AES256-SHA",
334 "ADH-CAMELLIA256-SHA256",
335 "ADH-CAMELLIA256-SHA",
336 "AECDH-AES128-SHA",
337 "ADH-AES128-GCM-SHA256",
338 "ADH-AES128-SHA256",
339 "ADH-AES128-SHA",
340 "ADH-CAMELLIA128-SHA256",
341 "AADH-CAMELLIA128-SHA",
342 "AECDH-RC4-SHA",
343 "ADH-RC4-MD5",
344 "AECDH-DES-CBC3-SHA",
345 "ADH-DES-CBC3-SHA",
346 "ADH-DES-CBC-SHA",
347 "EXP-RC4-MD5",
348 "EXP-RC2-CBC-MD5",
349 "EXP-DES-CBC-SHA",
350 "EXP-DH-DSS-DES-CBC-SHA",
351 "EXP-DH-RSA-DES-CBC-SHA",
352 "EXP-EDH-DSS-DES-CBC-SHA",
353 "EXP-EDH-RSA-DES-CBC-SHA",
354 "EXP-ADH-RC4-MD5",
355 "EXP-ADH-DES-CBC-SHA",
356 "EXP-KRB5-DES-CBC-SHA",
357 "EXP-KRB5-RC2-CBC-SHA",
358 "EXP-KRB5-RC4-SHA",
359 "EXP-KRB5-DES-CBC-MD5",
360 "EXP-KRB5-RC2-CBC-MD5",
361 "EXP-KRB5-RC4-MD5",
362 "EXP-RC4-MD5",
363 "EXP-RC2-CBC-MD5",
364 "TLS_RSA_EXPORT_WITH_DES40_CBC_SHA",
365 "EXP-EDH-DSS-DES-CBC-SHA",
366 "EXP-EDH-RSA-DES-CBC-SHA",
367 "EXP-ADH-RC4-MD5",
368 "EXP-ADH-DES-CBC-SHA",
369 "EXP1024-DES-CBC-SHA",
370 "EXP1024-RC4-SHA",
371 "EXP1024-RC4-MD5",
372 "EXP1024-RC2-CBC-MD5",
373 "EXP1024-DHE-DSS-DES-CBC-SHA",
374 "EXP1024-DHE-DSS-RC4-SHA",
375 "EXP-RC4-MD5",
376 "EXP-RC2-CBC-MD5",
377 "EXP-RC2-MD5",
378 "EDH-RSA-DES-CBC-SHA",
379 "EDH-DSS-DES-CBC-SHA",
380 "ADH-DES-CBC-SHA",
381 "DES-CBC-SHA",
382 "ADH-RC4-MD5",
383 "RC4-MD5",
384 "NULL-MD5",
385 "ECDHE-RSA-RC4-SHA",
386 "ECDHE-ECDSA-RC4-SHA",
387 "AECDH-RC4-SHA",
388 "ECDH-RSA-RC4-SHA",
389 "ECDH-ECDSA-RC4-SHA",
390 "RC4-SHA",
391 "AECDH-NULL-SHA",
392 "ECDH-RSA-NULL-SHA",
393 "ECDH-ECDSA-NULL-SHA",
394 "PSK-AES256-CBC-SHA",
395 "PSK-AES128-CBC-SHA",
396 "PSK-3DES-EDE-CBC-SHA",
397 "PSK-RC4-SHA",
398 "EXP-RC2-CBC-MD5",
399 "EXP-KRB5-RC2-CBC-SHA",
400 "EXP1024-RC2-CBC-MD5",
401 "RC2-CBC-MD5",
402 "EXP-RC2-CBC-MD5",
403 "DH-DSS-DES-CBC3-SHA",
404 "DH-RSA-DES-CBC3-SHA",
405 "EDH-DSS-DES-CBC3-SHA",
406 "EDH-RSA-DES-CBC3-SHA",
407 "ECDH-RSA-DES-CBC3-SHA",
408 "ECDH-ECDSA-DES-CBC3-SHA",
409 "ECDHE-RSA-DES-CBC3-SHA",
410 "ECDHE-ECDSA-DES-CBC3-SHA",
411 "DES-CBC3-SHA"]');
412 --let $TLS_VERSION = TLSv1.2
413 --source suite/auth_sec/include/wl15800_cipher_test.inc
414
415 --echo
416 --echo #=======================================================================
417 --echo
418 --echo # Cleanup
419 --echo
420
421 DROP DATABASE cipher_data;
422 DROP USER arthurdent@localhost;
423
424 --echo
425 --echo #=======================================================================
426 # Wait till we reached the initial number of concurrent sessions
427 --source include/wait_until_count_sessions.inc
428
429 # Clean slate
430 --source include/force_restart.inc