Debian Codegraph @

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

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