Debian Codegraph @

mysql-test/suite/plugins/r/thread_pool_server_audit.result

raw
1 install plugin server_audit soname 'server_audit';
2 show variables like 'server_audit%';
3 Variable_name Value
4 server_audit_events
5 server_audit_excl_users
6 server_audit_file_path server_audit.log
7 server_audit_file_rotate_now OFF
8 server_audit_file_rotate_size 1000000
9 server_audit_file_rotations 9
10 server_audit_incl_users
11 server_audit_logging OFF
12 server_audit_mode 0
13 server_audit_output_type file
14 server_audit_query_log_limit 1024
15 server_audit_syslog_facility LOG_USER
16 server_audit_syslog_ident mysql-server_auditing
17 server_audit_syslog_info
18 server_audit_syslog_priority LOG_INFO
19 set global server_audit_file_path=null;
20 set global server_audit_incl_users=null;
21 set global server_audit_file_path='server_audit.log';
22 set global server_audit_output_type=file;
23 set global server_audit_logging=on;
24 connect con1,localhost,root,,mysql;
25 connection default;
26 disconnect con1;
27 connect(localhost,no_such_user,,mysql,MASTER_PORT,MASTER_SOCKET);
28 connect con1,localhost,no_such_user,,mysql;
29 ERROR 28000: Access denied for user 'no_such_user'@'localhost' (using password: NO)
30 connection default;
31 set global server_audit_incl_users='odin, dva, tri';
32 create table t1 (id int);
33 set global server_audit_incl_users='odin, root, dva, tri';
34 create table t2 (id int);
35 set global server_audit_excl_users='odin, dva, tri';
36 Warnings:
37 Warning 1 User 'odin' is in the server_audit_incl_users, so wasn't added.
38 Warning 1 User 'dva' is in the server_audit_incl_users, so wasn't added.
39 Warning 1 User 'tri' is in the server_audit_incl_users, so wasn't added.
40 insert into t1 values (1), (2);
41 select * from t1;
42 id
43 1
44 2
45 set global server_audit_incl_users='odin, root, dva, tri';
46 insert into t2 values (1), (2);
47 select * from t2;
48 id
49 1
50 2
51 alter table t1 rename renamed_t1;
52 set global server_audit_events='connect,query';
53 select 1,
54 2,
55 # comment
56 3;
57 1 2 3
58 1 2 3
59 insert into t2 values (1), (2);
60 select * from t2;
61 id
62 1
63 2
64 1
65 2
66 select * from t_doesnt_exist;
67 ERROR 42S02: Table 'test.t_doesnt_exist' doesn't exist
68 syntax_error_query;
69 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'syntax_error_query' at line 1
70 drop table renamed_t1, t2;
71 show variables like 'server_audit%';
72 Variable_name Value
73 server_audit_events CONNECT,QUERY
74 server_audit_excl_users
75 server_audit_file_path server_audit.log
76 server_audit_file_rotate_now OFF
77 server_audit_file_rotate_size 1000000
78 server_audit_file_rotations 9
79 server_audit_incl_users odin, root, dva, tri
80 server_audit_logging ON
81 server_audit_mode 0
82 server_audit_output_type file
83 server_audit_query_log_limit 1024
84 server_audit_syslog_facility LOG_USER
85 server_audit_syslog_ident mysql-server_auditing
86 server_audit_syslog_info
87 server_audit_syslog_priority LOG_INFO
88 set global server_audit_mode=1;
89 set global server_audit_events='';
90 create database sa_db;
91 connect con1,localhost,root,,test;
92 connection con1;
93 create table t1 (id2 int);
94 insert into t1 values (1), (2);
95 select * from t1;
96 id2
97 1
98 2
99 drop table t1;
100 use sa_db;
101 create table sa_t1(id int);
102 insert into sa_t1 values (1), (2);
103 drop table sa_t1;
104 drop database sa_db;
105 connection default;
106 disconnect con1;
107 create database sa_db;
108 use sa_db;
109 CREATE USER u1 IDENTIFIED BY 'pwd-123';
110 GRANT ALL ON sa_db TO u2 IDENTIFIED BY "pwd-321";
111 SET PASSWORD FOR u1 = PASSWORD('pwd 098');
112 CREATE USER u3 IDENTIFIED BY '';
113 drop user u1, u2, u3;
114 set global server_audit_events='query_ddl';
115 create table t1(id int);
116 insert into t1 values (1), (2);
117 select * from t1;
118 id
119 1
120 2
121 select 2;
122 2
123 2
124 (select 2);
125 2
126 2
127 /*! select 2*/;
128 2
129 2
130 /*comment*/ select 2;
131 2
132 2
133 drop table t1;
134 set global server_audit_events='query_ddl,query_dml';
135 create table t1(id int);
136 insert into t1 values (1), (2);
137 select * from t1;
138 id
139 1
140 2
141 select 2;
142 2
143 2
144 drop table t1;
145 set global server_audit_events='query_dml';
146 create table t1(id int);
147 insert into t1 values (1), (2);
148 select * from t1;
149 id
150 1
151 2
152 select 2;
153 2
154 2
155 (select 2);
156 2
157 2
158 /*! select 2*/;
159 2
160 2
161 /*comment*/ select 2;
162 2
163 2
164 drop table t1;
165 set global server_audit_events='query_dcl';
166 create table t1(id int);
167 insert into t1 values (1), (2);
168 select * from t1;
169 id
170 1
171 2
172 CREATE USER u1 IDENTIFIED BY 'pwd-123';
173 GRANT ALL ON sa_db TO u2 IDENTIFIED BY "pwd-321";
174 SET PASSWORD
175 # comment
176 FOR u1 = PASSWORD('pwd 098');
177 SET PASSWORD FOR u1=<secret>;
178 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<secret>' at line 1
179 CREATE USER u3 IDENTIFIED BY '';
180 drop user u1, u2, u3;
181 select 2;
182 2
183 2
184 (select 2);
185 2
186 2
187 /*! select 2*/;
188 2
189 2
190 /*comment*/ select 2;
191 2
192 2
193 drop table t1;
194 set global server_audit_events='';
195 set global server_audit_query_log_limit= 15;
196 select (1), (2), (3), (4);
197 1 2 3 4
198 1 2 3 4
199 select 'A', 'B', 'C', 'D';
200 A B C D
201 A B C D
202 set global server_audit_query_log_limit= 1024;
203 drop database sa_db;
204 set global server_audit_file_path='.';
205 show status like 'server_audit_current_log';
206 Variable_name Value
207 Server_audit_current_log HOME_DIR/server_audit.log
208 set global server_audit_file_path='';
209 show status like 'server_audit_current_log';
210 Variable_name Value
211 Server_audit_current_log server_audit.log
212 set global server_audit_file_path=' ';
213 show status like 'server_audit_current_log';
214 Variable_name Value
215 Server_audit_current_log server_audit.log
216 set global server_audit_file_path='nonexisting_dir/';
217 Warnings:
218 Warning 1 SERVER AUDIT plugin can't create file 'nonexisting_dir/'.
219 show status like 'server_audit_current_log';
220 Variable_name Value
221 Server_audit_current_log server_audit.log
222 show variables like 'server_audit%';
223 Variable_name Value
224 server_audit_events
225 server_audit_excl_users
226 server_audit_file_path
227 server_audit_file_rotate_now OFF
228 server_audit_file_rotate_size 1000000
229 server_audit_file_rotations 9
230 server_audit_incl_users odin, root, dva, tri
231 server_audit_logging ON
232 server_audit_mode 1
233 server_audit_output_type file
234 server_audit_query_log_limit 1024
235 server_audit_syslog_facility LOG_USER
236 server_audit_syslog_ident mysql-server_auditing
237 server_audit_syslog_info
238 server_audit_syslog_priority LOG_INFO
239 uninstall plugin server_audit;
240 Warnings:
241 Warning 1620 Plugin is busy and will be uninstalled on shutdown
242 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_logging=on',0
243 TIME,HOSTNAME,root,localhost,ID,0,CONNECT,mysql,,0
244 TIME,HOSTNAME,root,localhost,ID,0,DISCONNECT,mysql,,0
245 TIME,HOSTNAME,no_such_user,localhost,ID,0,FAILED_CONNECT,,,ID
246 TIME,HOSTNAME,no_such_user,localhost,ID,0,DISCONNECT,,,0
247 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_incl_users=\'odin, dva, tri\'',0
248 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_incl_users=\'odin, root, dva, tri\'',0
249 TIME,HOSTNAME,root,localhost,ID,ID,CREATE,test,t2,
250 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'create table t2 (id int)',0
251 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_excl_users=\'odin, dva, tri\'',0
252 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'SHOW WARNINGS',0
253 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,test,t1,
254 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,table_stats,
255 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,column_stats,
256 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,index_stats,
257 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'insert into t1 values (1), (2)',0
258 TIME,HOSTNAME,root,localhost,ID,ID,READ,test,t1,
259 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'select * from t1',0
260 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_incl_users=\'odin, root, dva, tri\'',0
261 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,test,t2,
262 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,table_stats,
263 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,column_stats,
264 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,index_stats,
265 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'insert into t2 values (1), (2)',0
266 TIME,HOSTNAME,root,localhost,ID,ID,READ,test,t2,
267 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'select * from t2',0
268 TIME,HOSTNAME,root,localhost,ID,ID,ALTER,test,t1,
269 TIME,HOSTNAME,root,localhost,ID,ID,RENAME,test,t1|test.renamed_t1,
270 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,table_stats,
271 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,column_stats,
272 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,index_stats,
273 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'alter table t1 rename renamed_t1',0
274 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_events=\'connect,query\'',0
275 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'select 1,\n2,\n# comment\n3',0
276 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'insert into t2 values (1), (2)',0
277 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'select * from t2',0
278 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'select * from t_doesnt_exist',ID
279 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'syntax_error_query',ID
280 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'drop table renamed_t1, t2',0
281 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'show variables like \'server_audit%\'',0
282 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_mode=1',0
283 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_events=\'\'',0
284 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'create database sa_db',0
285 TIME,HOSTNAME,root,localhost,ID,0,CONNECT,test,,0
286 TIME,HOSTNAME,root,localhost,ID,ID,CREATE,test,t1,
287 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'create table t1 (id2 int)',0
288 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,test,t1,
289 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,table_stats,
290 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,column_stats,
291 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,index_stats,
292 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'insert into t1 values (1), (2)',0
293 TIME,HOSTNAME,root,localhost,ID,ID,READ,test,t1,
294 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'select * from t1',0
295 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,table_stats,
296 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,column_stats,
297 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,index_stats,
298 TIME,HOSTNAME,root,localhost,ID,ID,DROP,test,t1,
299 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'drop table t1',0
300 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'use sa_db',0
301 TIME,HOSTNAME,root,localhost,ID,ID,CREATE,sa_db,sa_t1,
302 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'create table sa_t1(id int)',0
303 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,sa_db,sa_t1,
304 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,table_stats,
305 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,column_stats,
306 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,index_stats,
307 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'insert into sa_t1 values (1), (2)',0
308 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,table_stats,
309 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,column_stats,
310 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,index_stats,
311 TIME,HOSTNAME,root,localhost,ID,ID,DROP,sa_db,sa_t1,
312 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop table sa_t1',0
313 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,proc,
314 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proc,
315 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,event,
316 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop database sa_db',0
317 TIME,HOSTNAME,root,localhost,ID,0,DISCONNECT,,,0
318 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'create database sa_db',0
319 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'use sa_db',0
320 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
321 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
322 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,columns_priv,
323 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,procs_priv,
324 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
325 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,roles_mapping,
326 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
327 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CREATE USER u1 IDENTIFIED BY *****',0
328 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
329 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
330 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'GRANT ALL ON sa_db TO u2 IDENTIFIED BY *****',0
331 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
332 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'SET PASSWORD FOR u1 = PASSWORD(*****)',0
333 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
334 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
335 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,columns_priv,
336 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,procs_priv,
337 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
338 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,roles_mapping,
339 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
340 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CREATE USER u3 IDENTIFIED BY *****',0
341 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,db,
342 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,tables_priv,
343 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,columns_priv,
344 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,procs_priv,
345 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proxies_priv,
346 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,roles_mapping,
347 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,global_priv,
348 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop user u1, u2, u3',0
349 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'create table t1(id int)',0
350 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop table t1',0
351 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'create table t1(id int)',0
352 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'insert into t1 values (1), (2)',0
353 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select * from t1',0
354 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select 2',0
355 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop table t1',0
356 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'insert into t1 values (1), (2)',0
357 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select * from t1',0
358 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select 2',0
359 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'(select 2)',0
360 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'/*! select 2*/',0
361 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'/*comment*/ select 2',0
362 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CREATE USER u1 IDENTIFIED BY *****',0
363 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'GRANT ALL ON sa_db TO u2 IDENTIFIED BY *****',0
364 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'CREATE USER u3 IDENTIFIED BY *****',0
365 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop user u1, u2, u3',0
366 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_events=\'\'',0
367 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global serv',0
368 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select (1), (2)',0
369 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'select \'A\', ',0
370 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_query_log_limit= 1024',0
371 TIME,HOSTNAME,root,localhost,ID,ID,READ,mysql,proc,
372 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,proc,
373 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,event,
374 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'drop database sa_db',0
375 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'.\'',0
376 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'.\'',0
377 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'show status like \'server_audit_current_log\'',0
378 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'\'',0
379 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'\'',0
380 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'show status like \'server_audit_current_log\'',0
381 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\' \'',0
382 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\' \'',0
383 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'show status like \'server_audit_current_log\'',0
384 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'nonexisting_dir/\'',0
385 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'nonexisting_dir/\'',0
386 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'SHOW WARNINGS',0
387 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'show status like \'server_audit_current_log\'',0
388 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'show variables like \'server_audit%\'',0
389 TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,plugin,
390 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'uninstall plugin server_audit',0