Debian Codegraph @

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

raw
1 --source include/have_null_audit_plugin.inc
2 --source include/no_protocol.inc
3
4 call mtr.add_suppression("Event 'MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE' cannot be aborted.");
5 call mtr.add_suppression("Event 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME' cannot be aborted.");
6 call mtr.add_suppression("Event 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP' cannot be aborted.");
7 call mtr.add_suppression("Event 'MYSQL_AUDIT_AUTHENTICATION_FLUSH' cannot be aborted.");
8
9 --replace_regex /\.dll/.so/
10 eval INSTALL PLUGIN null_audit SONAME '$AUDIT_NULL';
11
12 --echo ###################################################
13 --echo ## MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE ##
14 --echo ###################################################
15
16 CREATE USER testuser@localhost IDENTIFIED BY 'testpwd';
17 PREPARE stmt FROM 'ALTER USER testuser@localhost IDENTIFIED BY \'NewPass\'';
18
19 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
20 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
21 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
22 'MYSQL_AUDIT_GENERAL_LOG;;;'
23 'MYSQL_AUDIT_QUERY_START;sql_command_id="100";;'
24 'MYSQL_AUDIT_GENERAL_LOG;;;'
25 'MYSQL_AUDIT_QUERY_START;sql_command_id="134";;'
26 'MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE;;ABORT_RET';
27
28 EXECUTE stmt;
29 SELECT @@null_audit_event_order_check;
30
31
32 --echo ##############################################
33 --echo ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME ##
34 --echo ##############################################
35
36
37 PREPARE stmt FROM 'RENAME USER testuser@localhost TO newuser@localhost';
38
39 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
40 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
41 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
42 'MYSQL_AUDIT_GENERAL_LOG;;;'
43 'MYSQL_AUDIT_QUERY_START;sql_command_id="100";;'
44 'MYSQL_AUDIT_GENERAL_LOG;;;'
45 'MYSQL_AUDIT_QUERY_START;sql_command_id="86";;'
46 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME;;ABORT_RET';
47
48 EXECUTE stmt;
49 SELECT @@null_audit_event_order_check;
50
51
52 --echo ############################################
53 --echo ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP ##
54 --echo ############################################
55
56 PREPARE stmt FROM 'DROP USER newuser@localhost';
57
58 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
59 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
60 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
61 'MYSQL_AUDIT_GENERAL_LOG;;;'
62 'MYSQL_AUDIT_QUERY_START;sql_command_id="100";;'
63 'MYSQL_AUDIT_GENERAL_LOG;;;'
64 'MYSQL_AUDIT_QUERY_START;sql_command_id="85";;'
65 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP;;ABORT_RET';
66
67
68 EXECUTE stmt;
69 SELECT @@null_audit_event_order_check;
70
71
72 --echo ######################################
73 --echo ## MYSQL_AUDIT_AUTHENTICATION_FLUSH ##
74 --echo ######################################
75
76
77 PREPARE stmt FROM 'FLUSH PRIVILEGES';
78
79 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
80 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
81 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
82 'MYSQL_AUDIT_GENERAL_LOG;;;'
83 'MYSQL_AUDIT_QUERY_START;sql_command_id="100";;'
84 'MYSQL_AUDIT_GENERAL_LOG;;;'
85 'MYSQL_AUDIT_QUERY_START;sql_command_id="49";;'
86 'MYSQL_AUDIT_AUTHENTICATION_FLUSH;;ABORT_RET';
87
88
89 EXECUTE stmt;
90 SELECT @@null_audit_event_order_check;
91
92 DROP PREPARE stmt;
93
94 UNINSTALL PLUGIN null_audit;