Debian Codegraph @

mysql-test/suite/x/include/connection_ssl.inc

raw
1 ## Script connection_ssl.inc
2 #
3 # Extracted test logic form 'connection_openssl.test' and changed to
4 # a parametric test.
5 #
6 # Arguments:
7 #
8 # $INCREMENT - defines if SSL status variables will be incremented
9 # $USE_SOCKET - defines if the test should use UNIX socket (must be set to
10 # MYSQLXTEST argument setting unix socket or must be empty)
11 # $USER_AUTH_PLUGIN - defines MySQL Servers account types that is going to
12 # be tested
13 # $ERROR_IF_CHANNEL_UNSECURE - defined expected error code for MYSQLXTEST
14 # default connection when test verifies X Plugin logic that
15 # handles "require_secure_transport" system variable.
16 # $NO_SSL_ACCESS_DENIED_ERROR - expected error code when connecting using
17 # SHA256_MEMORY authentication on an unsecure channel
18 #
19 # Usage:
20 #
21 # --let $INCREMENT=0|1
22 # --let $USER_AUTH_PLUGIN=mysql_native_password|sha256_password|caching_sha2_password
23 # --let $ERROR_IF_CHANNEL_UNSECURE=EXPECTED_ERROR_MESSAGE
24 # --let $NO_SSL_ACCESS_DENIED_ERROR=ER_ACCESS_DENIED_ERROR
25 # --let $USE_SOCKET=UNIX_SOCKET_CONFIGURATION
26 # --source ../include/connection_ssl.inc
27 #
28
29 --echo
30 --echo
31 --echo ## Preamble
32 --source ../include/have_performance_schema_threads.inc
33 --source include/xplugin_preamble.inc
34 --source include/xplugin_create_user.inc
35
36 SET GLOBAL mysqlx_connect_timeout = 300;
37 call mtr.add_suppression("Maximum number of authentication attempts reached");
38 call mtr.add_suppression("Access denied for user .*");
39
40 ## Test starts here
41 --write_file $MYSQL_TMP_DIR/mysqlx-enable-ssl.xpl
42 -->import connection.macro
43 -->noquery_result
44 -->recvmessage Mysqlx.Notice.Frame {type:5}
45 -->query_result
46 Mysqlx.Connection.CapabilitiesGet {
47 }
48 -->recv capabilities[0]
49
50 -->callmacro Enable_ssl_on_xprotocol_and_transmision_layer
51 -->echo # SSL Enabled
52
53 Mysqlx.Connection.CapabilitiesGet {
54 }
55 -->recv capabilities[0]
56
57 EOF
58
59 --write_file $MYSQL_TMP_DIR/mysqlx-setcapabilities-tls-invalid.xpl
60 -->echo # setting read/write tls param with possible invalid data types:
61 -->echo # V_SINT,V_UINT ,V_NULL,V_OCTETS ,V_DOUBLE,V_FLOAT,V_STRING
62 -->noquery_result
63 -->recvmessage Mysqlx.Notice.Frame {type:5}
64 -->query_result
65 Mysqlx.Connection.CapabilitiesGet {
66 }
67 -->recv capabilities[0]
68
69 -->echo # Checking CapSet TLS to bool 0
70 Mysqlx.Connection.CapabilitiesSet {
71 capabilities {
72 capabilities {
73 name: "tls"
74 value {
75 type: SCALAR
76 scalar {
77 type: V_BOOL
78 v_bool: 0
79 }
80 }
81 }
82 }
83 }
84 -->recverror ER_X_CAPABILITIES_PREPARE_FAILED
85
86 -->echo # CapSet TLS to null
87 Mysqlx.Connection.CapabilitiesSet {
88 capabilities {
89 capabilities {
90 name: "tls"
91 value {
92 type: SCALAR
93 scalar {
94 type: V_NULL
95 }
96 }
97 }
98 }
99 }
100 -->recverror ER_X_CAPABILITIES_PREPARE_FAILED
101
102 -->echo # CapSet TLS to empty octet
103 Mysqlx.Connection.CapabilitiesSet {
104 capabilities {
105 capabilities {
106 name: "tls"
107 value {
108 type: SCALAR
109 scalar {
110 type:V_OCTETS
111 }
112 }
113 }
114 }
115 }
116 -->recverror ER_X_CAPABILITIES_PREPARE_FAILED
117
118 -->echo # CapSet TLS to empty uint
119 Mysqlx.Connection.CapabilitiesSet {
120 capabilities {
121 capabilities {
122 name: "tls"
123 value {
124 type: SCALAR
125 scalar {
126 type:V_UINT
127 }
128 }
129 }
130 }
131 }
132 -->recverror ER_X_CAPABILITIES_PREPARE_FAILED
133
134 -->echo # CapSet TLS to empty sint
135 Mysqlx.Connection.CapabilitiesSet {
136 capabilities {
137 capabilities {
138 name: "tls"
139 value {
140 type: SCALAR
141 scalar {
142 type:V_SINT
143 }
144 }
145 }
146 }
147 }
148 -->recverror ER_X_CAPABILITIES_PREPARE_FAILED
149 EOF
150
151
152 --write_file $MYSQL_TMP_DIR/verify-ssl-connection-info.xpl
153 -->import assert_select.macro
154 -->import assert_status_variable.macro
155
156 callmacro Assert_select
157 column_user
158 %OPTION_CLIENT_USER%@localhost
159 SELECT USER() as column_user;
160
161 callmacro Assert_select
162 CONNECTION_TYPE
163 SSL/TLS
164 SELECT CONNECTION_TYPE FROM performance_schema.threads WHERE processlist_id = connection_id();
165
166 callmacro Assert_status_variable
167 Mysqlx_ssl_version
168 %OPTION_TLS_VERSION%;
169
170 # Use either option with which mysqlxtest was started or the default one: ECDHE-RSA-AES128-GCM-SHA256
171 -->stmtsql SELECT IF(""="%OPTION_SSL_CIPHER%","ECDHE-RSA-AES128-GCM-SHA256","%OPTION_SSL_CIPHER%") as Value;
172 -->recvtovar %EXPECTED_SSL_CIPHER% Value
173
174 callmacro Assert_status_variable
175 Mysqlx_ssl_cipher
176 %EXPECTED_SSL_CIPHER%;
177
178 callmacro Assert_status_variable
179 Mysqlx_ssl_accepts
180 %VAR_SSL_ACCEPTS%;
181
182 callmacro Assert_status_variable
183 Mysqlx_ssl_finished_accepts
184 %VAR_SSL_ACCEPTS%;
185 EOF
186
187
188 --write_file $MYSQL_TMP_DIR/verify-non-ssl-connection-info.xpl
189 -->import assert_select.macro
190 -->import assert_status_variable.macro
191
192 callmacro Assert_select
193 column_user
194 %OPTION_CLIENT_USER%@localhost
195 SELECT USER() as column_user;
196
197 callmacro Assert_select
198 is_non_ssl_con
199 1
200 SELECT CONNECTION_TYPE in ("TCP/IP", "Socket") as is_non_ssl_con FROM performance_schema.threads WHERE processlist_id = connection_id();
201
202 callmacro Assert_status_variable
203 Mysqlx_ssl_version
204 ;
205
206 callmacro Assert_status_variable
207 Mysqlx_ssl_cipher
208 ;
209
210 callmacro Assert_status_variable
211 Mysqlx_ssl_accepts
212 %VAR_SSL_ACCEPTS%;
213
214 callmacro Assert_status_variable
215 Mysqlx_ssl_finished_accepts
216 %VAR_SSL_ACCEPTS%;
217 EOF
218
219
220 # Using "connect-expired-password" Option to allow expired password.
221
222 --write_file $MYSQL_TMP_DIR/mysqlx-alter-pwd.xpl
223 -->sql
224 ALTER USER USER() IDENTIFIED BY 'alter-new-auth';
225 -->endsql
226 EOF
227
228
229 --write_file $MYSQL_TMP_DIR/mysqlx-set-pwd.xpl
230 -->sql
231 SET PASSWORD='set-new-auth';
232 -->endsql
233 EOF
234
235
236 --write_file $MYSQL_TMP_DIR/mysqlx-status.xpl
237 -->import assert_status_variable.macro
238 SHOW STATUS WHERE `Variable_name` RLIKE '^Mysqlx_ssl_(ctx_verify_(depth|mode)|server_not_(after|before)|verify_(depth|mode))$';
239
240 callmacro Assert_set_like_status_variable Mysqlx_ssl_cipher_list : ECDHE-RSA-AES128-GCM-SHA256;
241 callmacro Assert_set_like_status_variable Mysqlx_ssl_cipher_list : ECDHE-RSA-AES256-GCM-SHA384;
242 EOF
243
244 ############################################################################
245
246 eval CREATE USER user1_mysqlx@localhost
247 IDENTIFIED WITH $USER_AUTH_PLUGIN BY 'auth_string1';
248 eval CREATE USER user2_mysqlx@localhost
249 IDENTIFIED WITH $USER_AUTH_PLUGIN BY 'auth_string2'
250 PASSWORD EXPIRE;
251
252
253 eval CREATE USER user3_mysqlx@localhost
254 IDENTIFIED WITH $USER_AUTH_PLUGIN BY 'auth_string3'
255 REQUIRE CIPHER "ECDHE-RSA-AES256-GCM-SHA384" AND
256 SUBJECT "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client"
257 ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA"
258 PASSWORD EXPIRE NEVER;
259
260 eval CREATE USER user4_mysqlx@localhost REQUIRE SSL ACCOUNT LOCK;
261
262 eval CREATE USER user5_mysqlx@localhost
263 IDENTIFIED WITH $USER_AUTH_PLUGIN BY 'auth_string'
264 REQUIRE SSL;
265
266 eval CREATE USER user6_mysqlx@localhost
267 IDENTIFIED WITH $USER_AUTH_PLUGIN BY 'dwh@#ghd'
268 REQUIRE x509;
269
270
271 eval CREATE USER user7_mysqlx@localhost
272 IDENTIFIED WITH $USER_AUTH_PLUGIN BY ''
273 REQUIRE CIPHER "ECDHE-RSA-AES256-GCM-SHA384";
274
275 GRANT ALL ON *.* TO user1_mysqlx@localhost;
276 GRANT ALL ON *.* TO user2_mysqlx@localhost;
277 GRANT ALL ON *.* TO user3_mysqlx@localhost;
278 GRANT ALL ON *.* TO user4_mysqlx@localhost;
279 GRANT ALL ON *.* TO user5_mysqlx@localhost;
280 GRANT ALL ON *.* TO user6_mysqlx@localhost;
281 GRANT ALL ON *.* TO user7_mysqlx@localhost;
282
283 --let $SSL_CONNECTION_MADE=0
284 --let $CLIENT_SSL_KEY=--ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem
285 --let $CLIENT_SSL_CERT=--ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem
286 --let $CLIENT_SSL_CA= --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem
287
288 let $MYSQLXTEST=$MYSQLXTEST $USE_SOCKET;
289 let $MYSQLXTEST_VERIFY_SSL=
290 $MYSQLXTEST
291 --tls-version=TLSv1.2
292 --file=$MYSQL_TMP_DIR/verify-ssl-connection-info.xpl
293 --ssl-mode=REQUIRED
294 --quiet;
295 let $MYSQLXTEST_VERIFY_NON_SSL=
296 $MYSQLXTEST
297 --file=$MYSQL_TMP_DIR/verify-non-ssl-connection-info.xpl
298 --ssl-mode=DISABLED
299 --quiet;
300
301 --echo
302 --echo
303 --echo ## I. Verify handling of SSL with normal account ($USER_AUTH_PLUGIN)
304 --echo #
305 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
306 exec $MYSQLXTEST_VERIFY_SSL -u user1_mysqlx --password='auth_string1'
307 -v%VAR_SSL_ACCEPTS%=$SSL_CONNECTION_MADE 2>&1;
308
309
310 --echo
311 --echo
312 --echo ## II. Verify handling of SSL with super account and XProtocol message
313 --echo ## CapabilitySet (without SSL options on it)
314 --echo #
315 --echo # 1. Try to set "tls" capability with invalid data (no-ssl connection)
316 --echo # 2. Try to set "tls" capability with valid data (ssl connection)
317 --echo #
318 --echo # II.1
319 exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1
320 --no-auth
321 --file=$MYSQL_TMP_DIR/mysqlx-setcapabilities-tls-invalid.xpl 2>&1;
322
323 --echo # II.2
324 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
325 exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1
326 --no-auth --ssl-mode=REQUIRED
327 --file=$MYSQL_TMP_DIR/mysqlx-enable-ssl.xpl 2>&1;
328
329
330 --echo
331 --echo
332 --echo ## III. Verify handling of expired password with user2_mysqlx account ($USER_AUTH_PLUGIN)
333 --echo #
334 --echo # 1. When client doesn't support handling of expired password,
335 --echo # then connection must be rejected
336 --echo # 2. When client support expired password, then he must be able
337 --echo # to alter password
338 --echo # 3. Verify that after the alter password, account can be used
339 --echo # without any additional support for expired password on the client
340 --echo # 4. When client support expired password, then he must be able
341 --echo # to set the password
342 --echo # 5. Verify that after the set password, account can be used
343 --echo # without any additional support for expired password on the client
344 --echo #
345 --echo # III.1
346 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
347 exec $MYSQLXTEST_VERIFY_SSL --expect-error ER_MUST_CHANGE_PASSWORD_LOGIN -u user2_mysqlx --password='auth_string2' 2>&1;
348
349 --echo # III.2
350 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
351 exec $MYSQLXTEST -u user2_mysqlx --password='auth_string2'
352 --connect-expired-password --ssl-mode=REQUIRED
353 --file=$MYSQL_TMP_DIR/mysqlx-alter-pwd.xpl 2>&1;
354
355 --echo # III.3
356 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
357 exec $MYSQLXTEST_VERIFY_SSL -u user2_mysqlx --password='alter-new-auth'
358 -v%VAR_SSL_ACCEPTS%=$SSL_CONNECTION_MADE 2>&1;
359
360 --echo # III.4
361 ALTER USER user2_mysqlx@localhost PASSWORD EXPIRE;
362 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
363 exec $MYSQLXTEST -u user2_mysqlx --password='alter-new-auth'
364 --connect-expired-password --ssl-mode=REQUIRED
365 --file=$MYSQL_TMP_DIR/mysqlx-set-pwd.xpl 2>&1;
366
367 --echo # III.5
368 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
369 exec $MYSQLXTEST_VERIFY_SSL -u user2_mysqlx --password='set-new-auth'
370 -v%VAR_SSL_ACCEPTS%=$SSL_CONNECTION_MADE 2>&1;
371
372
373 --echo
374 --echo
375 --echo ## IV. Verify handling of account that has requires concrete cipher, signed cert
376 --echo ## ($USER_AUTH_PLUGIN)
377 --echo #
378 --echo # 1. Verify that user can connect when it has allowed cipher and matching cert
379 --echo # 2. Verify that user can't connect when it has allowed cipher and non-matching cert
380 --echo # 3. Verify that user can't connect when it doesn't use SSL
381 --echo # 4. Verify that user can't connect when it use basic SSL configuration
382 --echo # 5. Verify that user can't connect when it has allowed cipher and its without a cert
383 --echo #
384 --echo # IV.1
385 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
386 exec $MYSQLXTEST_VERIFY_SSL -u user3_mysqlx --password='auth_string3'
387 --ssl-cipher='ECDHE-RSA-AES256-GCM-SHA384' $CLIENT_SSL_KEY $CLIENT_SSL_CERT
388 -v%VAR_SSL_ACCEPTS%=$SSL_CONNECTION_MADE 2>&1;
389
390 --echo # IV.2
391 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
392 exec $MYSQLXTEST_VERIFY_SSL --expect-error ER_ACCESS_DENIED_ERROR -u user3_mysqlx --password='auth_string3'
393 --ssl-cipher='ECDHE-RSA-AES256-GCM-SHA384' --ssl-cert=$MYSQL_TEST_DIR/std_data/server-cert.pem --ssl-key=$MYSQL_TEST_DIR/std_data/server-key.pem 2>&1;
394
395 --echo # IV.3
396 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
397 exec $MYSQLXTEST_VERIFY_SSL --expect-error ER_ACCESS_DENIED_ERROR -u user3_mysqlx --password='auth_string3' 2>&1;
398
399 --echo # IV.4
400 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
401 exec $MYSQLXTEST_VERIFY_SSL --expect-error ER_ACCESS_DENIED_ERROR -u user3_mysqlx --password='auth_string3' 2>&1;
402
403 --echo # IV.5
404 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
405 exec $MYSQLXTEST_VERIFY_SSL --expect-error ER_ACCESS_DENIED_ERROR -u user3_mysqlx --password='auth_string3'
406 --ssl-cipher='ECDHE-RSA-AES256-GCM-SHA384' 2>&1;
407
408
409 --echo
410 --echo
411 --echo ## V. Verify handling of locked account ($USER_AUTH_PLUGIN)
412 --echo #
413 --echo # 1. Verify that locked account can't connect
414 --echo # 2. Unlock the account and verify that it can connect
415 --echo #
416 --echo # V.1
417 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
418 exec $MYSQLXTEST_VERIFY_SSL --expect-error ER_ACCOUNT_HAS_BEEN_LOCKED -u user4_mysqlx --password=''
419 $CLIENT_SSL_KEY $CLIENT_SSL_CERT 2>&1;
420
421 --echo # V.2
422 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
423 ALTER USER user4_mysqlx@localhost ACCOUNT UNLOCK;
424 exec $MYSQLXTEST_VERIFY_SSL -u user4_mysqlx --password=''
425 $CLIENT_SSL_KEY $CLIENT_SSL_CERT
426 -v%VAR_SSL_ACCEPTS%=$SSL_CONNECTION_MADE 2>&1;
427
428
429 --echo
430 --echo
431 --echo ## VI. Verify handling of account that was marked as SSL required ($USER_AUTH_PLUGIN)
432 --echo #
433 --echo # 1. Verify connection with basic SSL configuration
434 --echo # 2. Verify connection with SSL key & cert
435 --echo # 3. Verify connection with SSL ca
436 --echo #
437 --echo # VI.1
438 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
439 exec $MYSQLXTEST_VERIFY_SSL -u user5_mysqlx --password='auth_string'
440 -v%VAR_SSL_ACCEPTS%=$SSL_CONNECTION_MADE 2>&1;
441
442 --echo # VI.2
443 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
444 exec $MYSQLXTEST_VERIFY_SSL -u user5_mysqlx --password='auth_string'
445 $CLIENT_SSL_KEY $CLIENT_SSL_CERT
446 -v%VAR_SSL_ACCEPTS%=$SSL_CONNECTION_MADE 2>&1;
447
448 --echo # VI.3
449 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
450 exec $MYSQLXTEST_VERIFY_SSL -u user5_mysqlx --password='auth_string'
451 $CLIENT_SSL_CA
452 -v%VAR_SSL_ACCEPTS%=$SSL_CONNECTION_MADE 2>&1;
453
454
455 --echo
456 --echo
457 --echo ## VII. Verify handling of account that was marked as SSL required with signed cert
458 --echo ## ($USER_AUTH_PLUGIN)
459 --echo #
460 --echo # 1. Verify connection with signed cert
461 --echo # 2. Verify that connection is rejected when SSL is disabled
462 --echo # 3. Verify that connection is rejected when CA is set
463 --echo # 4. Verify that connection is rejected when using basic SSL configuration
464 --echo #
465 --echo # VII.1
466 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
467 exec $MYSQLXTEST_VERIFY_SSL -u user6_mysqlx --password='dwh@#ghd'
468 $CLIENT_SSL_KEY $CLIENT_SSL_CERT
469 -v%VAR_SSL_ACCEPTS%=$SSL_CONNECTION_MADE 2>&1;
470
471 --echo # VII.2
472 exec $MYSQLXTEST_VERIFY_NON_SSL --expect-error $NO_SSL_ACCESS_DENIED_ERROR -u user6_mysqlx --password='dwh@#ghd' 2>&1;
473
474 --echo # VII.3
475 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
476 exec $MYSQLXTEST_VERIFY_SSL --expect-error ER_ACCESS_DENIED_ERROR -u user6_mysqlx --password='dwh@#ghd'
477 $CLIENT_SSL_CA 2>&1;
478
479 --echo # VII.4
480 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
481 exec $MYSQLXTEST_VERIFY_SSL --expect-error ER_ACCESS_DENIED_ERROR -u user6_mysqlx --password='dwh@#ghd' 2>&1;
482
483 --echo
484 --echo
485 --echo ## VIII. Verify handling of account that was marked that requires concrete SSL cipher
486 --echo ## ($USER_AUTH_PLUGIN)
487 --echo #
488 --echo # 1. Verify connection with concrete cipher and signed cert
489 --echo # 2. Verify that connection is rejected with concrete cipher and without a cert
490 --echo # 3. Verify that connection is rejected when SSL is disabled
491 --echo # 4. Verify that connection is rejected with basic SSL configuration
492 --echo # 5. Verify that connection is rejected with wrong cipher and signed cert
493 --echo #
494 --echo # VIII.1
495 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
496 exec $MYSQLXTEST_VERIFY_SSL -u user7_mysqlx
497 --ssl-cipher="ECDHE-RSA-AES256-GCM-SHA384" $CLIENT_SSL_CA $CLIENT_SSL_KEY $CLIENT_SSL_CERT
498 -v%VAR_SSL_ACCEPTS%=$SSL_CONNECTION_MADE 2>&1;
499
500 --echo # VIII.2
501 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
502 exec $MYSQLXTEST_VERIFY_SSL --expect-error ER_ACCESS_DENIED_ERROR -u user7_mysqlx
503 --ssl-cipher="ECDHE-RSA-AES256-GCM-SHA384" 2>&1;
504
505 --echo # VIII.3
506 let $expected_error_msg= Access denied for user 'user7_mysqlx'@'localhost' \(using password: YES\) \(code 1045\);
507 exec $MYSQLXTEST_VERIFY_NON_SSL --expect-error $NO_SSL_ACCESS_DENIED_ERROR -u user7_mysqlx 2>&1;
508
509 --echo # VIII.4
510 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
511 exec $MYSQLXTEST_VERIFY_SSL --expect-error ER_ACCESS_DENIED_ERROR -u user7_mysqlx 2>&1;
512
513 --echo # VIII.5
514 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
515 exec $MYSQLXTEST_VERIFY_SSL --expect-error ER_ACCESS_DENIED_ERROR -u user7_mysqlx
516 --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256' $CLIENT_SSL_CA $CLIENT_SSL_KEY $CLIENT_SSL_CERT 2>&1;
517
518 --echo
519 --echo
520 --echo ## IX. Verify X Plugins global and session status variables ($USER_AUTH_PLUGIN)
521 --echo #
522 --echo # 1. Verify global SSL setup
523 --echo # 2. Verify session SSL setup
524 --echo #
525 --echo # IX.1
526 replace_regex /4294967295/-1/ /18446744073709551615/-1/;
527 SHOW GLOBAL STATUS WHERE `Variable_name` RLIKE '^Mysqlx_ssl_(cipher_list|ctx_verify_(depth|mode)|server_not_(after|before)|verify_(depth|mode))$';
528
529 --echo # IX.2
530 replace_regex /4294967295/-1/ /18446744073709551615/-1/;
531 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
532 exec $MYSQLXTEST -u x_root
533 --ssl-cipher="ECDHE-RSA-AES256-GCM-SHA384" $CLIENT_SSL_CA $CLIENT_SSL_KEY $CLIENT_SSL_CERT
534 --file=$MYSQL_TMP_DIR/mysqlx-status.xpl 2>&1;
535
536
537 --echo
538 --echo
539 --echo ## X. Lets confirm that Mysqlx plugin validates the connection_type vs 'require_secure_transport'
540 --echo ## system variable ($USER_AUTH_PLUGIN)
541 --echo #
542 --echo # 1. Connection without SSL (fails on TCP, it works on UNIX socket)
543 --echo # 2. Connection with SSL (always must be successful)
544 --echo #
545 --echo # X.1
546 SET GLOBAL require_secure_transport:=1;
547 exec $MYSQLXTEST_VERIFY_NON_SSL --expect-error $ERROR_IF_CHANNEL_UNSECURE -ux_root --password=''
548 -v%VAR_SSL_ACCEPTS%=$SSL_CONNECTION_MADE 2>&1;
549
550 --echo # X.2
551 expr $SSL_CONNECTION_MADE= $SSL_CONNECTION_MADE + $INCREMENT;
552 exec $MYSQLXTEST_VERIFY_SSL -ux_root --password=''
553 $CLIENT_SSL_CA $CLIENT_SSL_KEY $CLIENT_SSL_CERT
554 -v%VAR_SSL_ACCEPTS%=$SSL_CONNECTION_MADE 2>&1;
555 SET GLOBAL require_secure_transport:=0;
556
557
558 --echo
559 --echo
560 --echo ## Cleanup
561 --source ../include/xplugin_cleanup.inc
562
563 DROP USER user1_mysqlx@localhost;
564 DROP USER user2_mysqlx@localhost;
565 DROP USER user3_mysqlx@localhost;
566 DROP USER user4_mysqlx@localhost;
567 DROP USER user5_mysqlx@localhost;
568 DROP USER user6_mysqlx@localhost;
569 DROP USER user7_mysqlx@localhost;
570
571 SET GLOBAL mysqlx_connect_timeout = DEFAULT;
572