[MDEV-4762] Audit: QUERY event contains an empty field and does not contain default schema Created: 2013-07-05  Updated: 2013-08-27  Resolved: 2013-08-27

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

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

Issue Links:
Relates
relates to MDEV-4472 Auditing Plugin Closed

 Description   

The QUERY event has a position between IP address and connection ID, which seems to be always empty.
At the same time, it does not log the default schema where the query was executed, while I think it should be expected for events of this type.

The test already exists in server_audit.test and the result is recorded as described above:

set global server_audit_incl_ddl_users='odin, dva, tri';
create table t1 (id int);
...
TIME,HOSTNAME,root[root] @ localhost [],,1,QUERY,set global server_audit_incl_ddl_users='odin, dva, tri'
TIME,HOSTNAME,root[root] @ localhost [],,1,QUERY,create table t1 (id int)



 Comments   
Comment by Alexey Botchkov [ 2013-07-05 ]

Well the client's host supposed to be on that place accordingly to the spec. But i don't know at the moment where to get it as the auditing event doesn't have that field. So right, it's always empty.

Comment by Elena Stepanova [ 2013-07-05 ]

And what about the default schema?

Comment by Alexey Botchkov [ 2013-08-20 ]

FIxed as the record format has been changed, particularly the database name was added.

Generated at Thu Feb 08 06:58:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.