Debian Codegraph @

mysql-test/suite/audit_null/r/mysqlx_abort.result

raw
1 INSTALL PLUGIN null_audit SONAME 'adt_null.so';
2 CREATE USER audit_user@localhost IDENTIFIED BY 'audit_pw';
3 GRANT ALL PRIVILEGES ON *.* TO audit_user@localhost WITH GRANT OPTION;
4 RUN CREATE USER user1_mysqlx@localhost
5 IDENTIFIED WITH 'mysql_native_password' BY 'auth_string1'
6
7 0 rows affected
8 RUN CREATE USER user3_mysqlx@localhost
9 IDENTIFIED WITH 'mysql_native_password' BY 'auth_string3'
10 REQUIRE CIPHER "ECDHE-RSA-AES128-GCM-SHA256" AND
11 SUBJECT "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=Client"
12 ISSUER "/C=SE/ST=Stockholm/L=Stockholm/O=Oracle/OU=MySQL/CN=CA"
13 PASSWORD EXPIRE NEVER
14
15 0 rows affected
16 RUN CREATE USER user5_mysqlx@localhost
17 IDENTIFIED WITH 'mysql_native_password' BY 'auth_string'
18 REQUIRE SSL
19
20 0 rows affected
21 RUN GRANT ALL ON *.* TO user1_mysqlx@localhost
22
23 0 rows affected
24 RUN GRANT ALL ON *.* TO user3_mysqlx@localhost
25
26 0 rows affected
27 RUN GRANT ALL ON *.* TO user5_mysqlx@localhost
28
29 0 rows affected
30 Mysqlx.Ok {
31 msg: "bye!"
32 }
33 ok
34 SET GLOBAL null_audit_event_order_check_consume_ignore_count = 6;
35 SET GLOBAL null_audit_event_order_check = "MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE;;ABORT_RET";
36 in main, line 0:ERROR: Aborted by Audit API ('MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE';1). (code 3164)
37 not ok
38 in main, line 0:ERROR: Aborted by Audit API ('MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE';1). (code 3164)
39 not ok
40 in main, line 0:ERROR: Aborted by Audit API ('MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE';1). (code 3164)
41 not ok
42 UNINSTALL PLUGIN null_audit;
43 DROP USER user1_mysqlx@localhost,user3_mysqlx@localhost,
44 user5_mysqlx@localhost,audit_user@localhost;
45 # END OF TEST