Debian Codegraph @

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

raw
1 ## Test cases for mysqlx plugin TLS versions
2
3 --source include/xplugin_create_user.inc
4
5 SET GLOBAL mysqlx_connect_timeout = 300;
6
7 eval CREATE USER user5_mysqlx@localhost
8 IDENTIFIED WITH $USER_AUTH_PLUGIN BY 'auth_string'
9 REQUIRE SSL;
10
11 GRANT ALL ON *.* TO user5_mysqlx@localhost;
12
13 ## Test starts here
14
15 --let $xtest_file= $MYSQL_TMP_DIR/connection_tls_version.tmp
16 --write_file $xtest_file
17 -->quiet
18 -->sql
19 SELECT CONNECTION_TYPE from performance_schema.threads where PROCESSLIST_ID=CONNECTION_ID();
20 SHOW VARIABLES LIKE 'tls_version';
21 SHOW STATUS LIKE 'Mysqlx_ssl_version';
22 -->endsql
23 EOF
24
25 --exec $MYSQLXTEST -ux_root --file=$xtest_file 2>&1
26
27 --let $XTESTPARAMS= -u user5_mysqlx --password='auth_string' --file=$xtest_file --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256'
28 # each of the below regexps has 2 replaces
29 # 1: for openssl 1.0
30 # 2: for openssl 1.1
31 # 3: for freebsd openssl 1.0
32 --let $ERROR1= /error:14077102:SSL routines:SSL23_GET_SERVER_HELLO:unsupported protocol/protocol version mismatch/ /error:14171102:SSL routines:tls_process_server_hello:unsupported protocol/protocol version mismatch/ /record layer version error/protocol version mismatch/ /error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol/protocol version mismatch/
33 --let $ERROR5= /error:00000000:lib\(0\):func\(0\):reason\(0\)/socket layer receive error/ /error:1409442E:SSL routines:ssl3_read_bytes:tlsv1 alert protocol version/socket layer receive error/
34
35 --exec $MYSQLXTEST $XTESTPARAMS 2>&1
36 --exec $MYSQLXTEST --tls-version=TLSv1,TLSv1.1,TLSv1.2 $XTESTPARAMS 2>&1
37 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv1,TLSv1.1 $XTESTPARAMS 2>&1
38 --exec $MYSQLXTEST --tls-version=TLSv1,TLSv1.2 $XTESTPARAMS 2>&1
39 --exec $MYSQLXTEST --tls-version=TLSv1.1,TLSv1.2 $XTESTPARAMS 2>&1
40 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv1 $XTESTPARAMS 2>&1
41 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv1.1 $XTESTPARAMS 2>&1
42
43 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv3 $XTESTPARAMS 2>&1
44
45
46 --let $restart_parameters = restart: --tls-version=TLSv1.2
47 --source ../include/restart_mysqld_and_wait_for_xplugin.inc
48
49 --exec $MYSQLXTEST $XTESTPARAMS 2>&1
50 --exec $MYSQLXTEST --tls-version=TLSv1,TLSv1.1,TLSv1.2 $XTESTPARAMS 2>&1
51 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv1,TLSv1.1 $XTESTPARAMS 2>&1
52 --exec $MYSQLXTEST --tls-version=TLSv1,TLSv1.2 $XTESTPARAMS 2>&1
53
54 --replace_regex $ERROR1
55 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv1.1,TLSv1.2 $XTESTPARAMS 2>&1
56
57 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv1 $XTESTPARAMS 2>&1
58
59 --replace_regex $ERROR1
60 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv1.1 $XTESTPARAMS 2>&1
61
62 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv3 $XTESTPARAMS 2>&1
63
64
65 --let $restart_parameters = restart: --tls-version=TLSv1.2
66 --source ../include/restart_mysqld_and_wait_for_xplugin.inc
67
68 --exec $MYSQLXTEST $XTESTPARAMS 2>&1
69 --exec $MYSQLXTEST --tls-version=TLSv1,TLSv1.1,TLSv1.2 $XTESTPARAMS 2>&1
70 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv1,TLSv1.1 $XTESTPARAMS 2>&1
71
72 --replace_regex $ERROR5
73 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv1,TLSv1.2 $XTESTPARAMS 2>&1
74 --exec $MYSQLXTEST --tls-version=TLSv1.1,TLSv1.2 $XTESTPARAMS 2>&1
75
76 --replace_regex $ERROR5
77 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv1 $XTESTPARAMS 2>&1
78
79 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv1.1 $XTESTPARAMS 2>&1
80
81 --exec $MYSQLXTEST --expect-error CR_SSL_CONNECTION_ERROR --tls-version=TLSv3 $XTESTPARAMS 2>&1
82
83
84 # Cleanup
85 --let $restart_parameters = restart:
86 --source include/restart_mysqld.inc
87
88 --source include/xplugin_drop_user.inc
89 --remove_file $xtest_file
90
91 DROP USER user5_mysqlx@localhost;
92 SET GLOBAL mysqlx_connect_timeout = DEFAULT;