Debian Codegraph @

mysql-test/suite/audit_null/t/mysqlx_abort.test

raw
1 --source include/have_null_audit_plugin.inc
2 --source include/xplugin_preamble.inc
3 --disable_ps_protocol
4 --disable_warnings
5 --enable_connect_log
6
7 --replace_regex /\.dll/.so/
8 eval INSTALL PLUGIN null_audit SONAME '$AUDIT_NULL';
9
10 CREATE USER audit_user@localhost IDENTIFIED BY 'audit_pw';
11 GRANT ALL PRIVILEGES ON *.* TO audit_user@localhost WITH GRANT OPTION;
12
13 ## Test starts here
14 --write_file $MYSQL_TMP_DIR/mysqlx-connection-setup.tmp
15 -->sql
16
17 CREATE USER user1_mysqlx@localhost
18 IDENTIFIED WITH 'mysql_native_password' BY 'auth_string1';
19
20 CREATE USER user3_mysqlx@localhost
21 IDENTIFIED WITH 'mysql_native_password' BY 'auth_string3'
22 REQUIRE CIPHER "ECDHE-RSA-AES128-GCM-SHA256" AND
23 SUBJECT "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client"
24 ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA"
25 PASSWORD EXPIRE NEVER;
26
27 CREATE USER user5_mysqlx@localhost
28 IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
29 REQUIRE SSL;
30
31 GRANT ALL ON *.* TO user1_mysqlx@localhost;
32 GRANT ALL ON *.* TO user3_mysqlx@localhost;
33 GRANT ALL ON *.* TO user5_mysqlx@localhost;
34 -->endsql
35 EOF
36
37 --exec $MYSQLXTEST --ssl-mode=REQUIRED -h localhost -u audit_user --password='audit_pw' --plain-auth --file=$MYSQL_TMP_DIR/mysqlx-connection-setup.tmp 2>&1
38
39 --write_file $MYSQL_TMP_DIR/mysqlx-connection-info.tmp
40 -->sql
41 SELECT USER();
42 -->endsql
43 EOF
44
45 SET GLOBAL null_audit_event_order_check_consume_ignore_count = 6;
46 SET GLOBAL null_audit_event_order_check = "MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE;;ABORT_RET";
47 --error 1
48 exec $MYSQLXTEST
49 --ssl-mode=REQUIRED --history-protocol false
50 -u user1_mysqlx --password='auth_string1' --plain-auth
51 --file=$MYSQL_TMP_DIR/mysqlx-connection-info.tmp 2>&1;
52
53 --error 1
54 exec $MYSQLXTEST
55 --tls-version=TLSv1.2 --ssl-mode=REQUIRED --history-protocol false
56 -u user3_mysqlx --password='auth_string3' --plain-auth
57 --ssl-cipher="ECDHE-RSA-AES128-GCM-SHA256" --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem
58 --file=$MYSQL_TMP_DIR/mysqlx-connection-info.tmp 2>&1;
59
60 --error 1
61 exec $MYSQLXTEST
62 --ssl-mode=REQUIRED --history-protocol false
63 -u user5_mysqlx --password='auth_string' --plain-auth
64 --ssl-key=$MYSQL_TEST_DIR/std_data/server-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/server-cert.pem --file=$MYSQL_TMP_DIR/mysqlx-connection-info.tmp 2>&1;
65
66 UNINSTALL PLUGIN null_audit;
67
68 # Cleanup
69 --remove_file $MYSQL_TMP_DIR/mysqlx-connection-setup.tmp
70 --remove_file $MYSQL_TMP_DIR/mysqlx-connection-info.tmp
71
72 DROP USER user1_mysqlx@localhost,user3_mysqlx@localhost,
73 user5_mysqlx@localhost,audit_user@localhost;
74
75 --echo # END OF TEST
76 --enable_warnings