[MDEV-7443] Server audit: If both QUERY_DML and QUERY_DDL are set, nothing is logged Created: 2015-01-12  Updated: 2015-01-15  Resolved: 2015-01-15

Status: Closed
Project: MariaDB Server
Component/s: Plugin - Audit
Affects Version/s: N/A
Fix Version/s: 5.5.42

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: audit


 Description   

Only QUERY_DML - OK

 
MariaDB [test]> set global server_audit_events='QUERY_DML';
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [test]> select 1;
 
+---+
 
| 1 |
 
+---+
 
| 1 |
 
+---+
 
1 row in set (0.00 sec)
 
 
 
MariaDB [test]> # logged
 
 
 
MariaDB [test]> create table if not exists tt as select 1;
 
Query OK, 0 rows affected, 1 warning (0.00 sec)
 
 
 
MariaDB [test]> # not logged

Only QUERY_DDL - OK

 
MariaDB [test]> set global server_audit_events='QUERY_DDL';
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [test]> select 2;
 
+---+
 
| 2 |
 
+---+
 
| 2 |
 
+---+
 
1 row in set (0.00 sec)
 
 
 
MariaDB [test]> # not logged
 
 
 
MariaDB [test]> create table if not exists tt as select 2;
 
Query OK, 0 rows affected, 1 warning (0.00 sec)
 
 
 
MariaDB [test]> # logged

QUERY_DML and QUERY_DDL together - nothing is logged

 
MariaDB [test]> set global server_audit_events='QUERY_DDL,QUERY_DML';
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [test]> select 3;
 
+---+
 
| 3 |
 
+---+
 
| 3 |
 
+---+
 
1 row in set (0.00 sec)
 
 
 
MariaDB [test]> # not logged
 
 
 
MariaDB [test]> create table if not exists tt as select 3;
 
Query OK, 0 rows affected, 1 warning (0.00 sec)
 
 
 
MariaDB [test]> # not logged



 Comments   
Comment by Elena Stepanova [ 2015-01-15 ]

Re-opening since it hasn't become much better after the fix. Now if both QUERY_DML and QUERY_DDL are set, only DML events are logged:

MariaDB [test]> set global server_audit_events='QUERY_DDL,QUERY_DML';
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [test]> select 1;
 
+---+
 
| 1 |
 
+---+
 
| 1 |
 
+---+
 
1 row in set (0.00 sec)
 
 
 
MariaDB [test]> create table t1 (i int);
 
Query OK, 0 rows affected (0.19 sec)
 
 
 
MariaDB [test]> select 2;
 
+---+
 
| 2 |
 
+---+
 
| 2 |
 
+---+
 
1 row in set (0.00 sec)
 

20150115 02:56:46,wheezy-64,root,localhost,1,12,QUERY,test,'select 1',0
 
20150115 02:56:58,wheezy-64,root,localhost,1,14,QUERY,test,'select 2',0
 

MariaDB [test]> set global server_audit_events='QUERY_DML,QUERY_DDL';
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [test]> select 3;
 
+---+
 
| 3 |
 
+---+
 
| 3 |
 
+---+
 
1 row in set (0.00 sec)
 
 
 
MariaDB [test]> create table t2 (i int);
 
Query OK, 0 rows affected (0.21 sec)
 
 
 
MariaDB [test]> select 4;
 
+---+
 
| 4 |
 
+---+
 
| 4 |
 
+---+
 
1 row in set (0.00 sec)
 

20150115 02:57:14,wheezy-64,root,localhost,1,16,QUERY,test,'select 3',0
 
20150115 02:57:30,wheezy-64,root,localhost,1,18,QUERY,test,'select 4',0

Generated at Thu Feb 08 07:19:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.