Debian Codegraph @

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

raw
1 call mtr.add_suppression("Event 'MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE' cannot be aborted.");
2 call mtr.add_suppression("Event 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME' cannot be aborted.");
3 call mtr.add_suppression("Event 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP' cannot be aborted.");
4 call mtr.add_suppression("Event 'MYSQL_AUDIT_AUTHENTICATION_FLUSH' cannot be aborted.");
5 call mtr.add_suppression("Abort MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE with my_message.");
6 call mtr.add_suppression("Abort MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME with my_message.");
7 call mtr.add_suppression("Abort MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP with my_message.");
8 call mtr.add_suppression("Abort MYSQL_AUDIT_AUTHENTICATION_FLUSH with my_message.");
9 INSTALL PLUGIN null_audit SONAME 'adt_null.so';
10 ##############################################
11 ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_CREATE ##
12 ##############################################
13 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
14 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
15 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
16 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
17 'MYSQL_AUDIT_GENERAL_LOG;;;'
18 'MYSQL_AUDIT_QUERY_START;sql_command_id="84";;'
19 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="84";;'
20 'MYSQL_AUDIT_GENERAL_RESULT;;;'
21 'MYSQL_AUDIT_GENERAL_STATUS;;;'
22 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
23 CREATE USER testuser@localhost IDENTIFIED BY 'testpwd';
24 SELECT @@null_audit_event_order_check;
25 @@null_audit_event_order_check
26 EVENT-ORDER-OK
27 ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_CREATE - END ##
28 ##################################################
29 ## MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE ##
30 ##################################################
31 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
32 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
33 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
34 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
35 'MYSQL_AUDIT_GENERAL_LOG;;;'
36 'MYSQL_AUDIT_QUERY_START;sql_command_id="134";;'
37 'MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE;;ABORT_RET';
38 ALTER USER testuser@localhost IDENTIFIED BY 'NewPass';
39 SELECT @@null_audit_event_order_check;
40 @@null_audit_event_order_check
41 EVENT-ORDER-ABORT
42 ## MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE - END ##
43 ##############################################
44 ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME ##
45 ##############################################
46 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
47 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
48 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
49 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
50 'MYSQL_AUDIT_GENERAL_LOG;;;'
51 'MYSQL_AUDIT_QUERY_START;sql_command_id="86";;'
52 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME;;ABORT_RET';
53 RENAME USER testuser@localhost TO newuser@localhost;
54 SELECT @@null_audit_event_order_check;
55 @@null_audit_event_order_check
56 EVENT-ORDER-ABORT
57 ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME - END ##
58 ############################################
59 ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP ##
60 ############################################
61 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
62 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
63 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
64 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
65 'MYSQL_AUDIT_GENERAL_LOG;;;'
66 'MYSQL_AUDIT_QUERY_START;sql_command_id="85";;'
67 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP;;ABORT_RET';
68 DROP USER newuser@localhost;
69 SELECT @@null_audit_event_order_check;
70 @@null_audit_event_order_check
71 EVENT-ORDER-ABORT
72 ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP - END ##
73 ######################################
74 ## MYSQL_AUDIT_AUTHENTICATION_FLUSH ##
75 ######################################
76 SET @@null_audit_event_order_check_exact = 1;
77 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
78 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
79 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
80 'MYSQL_AUDIT_GENERAL_LOG;;;'
81 'MYSQL_AUDIT_QUERY_START;sql_command_id="49";;'
82 'MYSQL_AUDIT_AUTHENTICATION_FLUSH;;ABORT_RET';
83 FLUSH PRIVILEGES;
84 SELECT @@null_audit_event_order_check;
85 @@null_audit_event_order_check
86 EVENT-ORDER-ABORT
87 ## MYSQL_AUDIT_AUTHENTICATION_FLUSH - END ##
88 ##################################################
89 ## MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE ##
90 ##################################################
91 CREATE USER testuser@localhost IDENTIFIED BY 'testpwd';
92 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
93 SET @@null_audit_abort_message = "Abort MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE with my_message.";
94 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
95 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
96 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
97 'MYSQL_AUDIT_GENERAL_LOG;;;'
98 'MYSQL_AUDIT_QUERY_START;sql_command_id="134";;'
99 'MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE;;ABORT_RET';
100 ALTER USER testuser@localhost IDENTIFIED BY 'NewPass';
101 SELECT @@null_audit_event_order_check;
102 @@null_audit_event_order_check
103 EVENT-ORDER-ABORT
104 ## MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE - END ##
105 ##############################################
106 ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME ##
107 ##############################################
108 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
109 SET @@null_audit_abort_message = "Abort MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME with my_message.";
110 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
111 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
112 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
113 'MYSQL_AUDIT_GENERAL_LOG;;;'
114 'MYSQL_AUDIT_QUERY_START;sql_command_id="86";;'
115 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME;;ABORT_RET';
116 RENAME USER testuser@localhost TO newuser@localhost;
117 SELECT @@null_audit_event_order_check;
118 @@null_audit_event_order_check
119 EVENT-ORDER-ABORT
120 ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME - END ##
121 ############################################
122 ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP ##
123 ############################################
124 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
125 SET @@null_audit_abort_message = "Abort MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP with my_message.";
126 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
127 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
128 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
129 'MYSQL_AUDIT_GENERAL_LOG;;;'
130 'MYSQL_AUDIT_QUERY_START;sql_command_id="85";;'
131 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP;;ABORT_RET';
132 DROP USER newuser@localhost;
133 SELECT @@null_audit_event_order_check;
134 @@null_audit_event_order_check
135 EVENT-ORDER-ABORT
136 ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP - END ##
137 ######################################
138 ## MYSQL_AUDIT_AUTHENTICATION_FLUSH ##
139 ######################################
140 SET @@null_audit_event_order_check_exact = 1;
141 SET @@null_audit_abort_message = "Abort MYSQL_AUDIT_AUTHENTICATION_FLUSH with my_message.";
142 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
143 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
144 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
145 'MYSQL_AUDIT_GENERAL_LOG;;;'
146 'MYSQL_AUDIT_QUERY_START;sql_command_id="49";;'
147 'MYSQL_AUDIT_AUTHENTICATION_FLUSH;;ABORT_RET';
148 FLUSH PRIVILEGES;
149 SELECT @@null_audit_event_order_check;
150 @@null_audit_event_order_check
151 EVENT-ORDER-ABORT
152 ## MYSQL_AUDIT_AUTHENTICATION_FLUSH - END ##
153 UNINSTALL PLUGIN null_audit;
154 Warnings:
155 Warning 1620 Plugin is busy and will be uninstalled on shutdown