[MDEV-4761] Audit: DISCONNECT event does not contain user/server 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: Minor
Reporter: Elena Stepanova Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: server_audit

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

 Description   

CONNECT events have user name and server host among other values. DISCONNECT only has connection ID:

20130705 17:32:36,ubuntu12-04,test,localhost,7,CONNECT
20130705 17:32:36,ubuntu12-04,test[test] @ localhost [127.0.0.1],,7,QUERY,show databases
20130705 17:32:36,ubuntu12-04,test[test] @ localhost [127.0.0.1],,7,QUERY,show tables
20130705 17:32:37,ubuntu12-04,test[test] @ localhost [127.0.0.1],,7,QUERY,select @@version_comment limit 1
20130705 17:32:43,ubuntu12-04,,,7,DISCONNECT

While technically the missing info can be restored by finding the corresponding CONNECT event (by connection ID) and taking user/server from there, it is definitely inconvenient, so it would be good to fix it if possible.

bzr version-info

revision-id: holyfoot@askmonty.org-20130704123621-gb3jvhyxdax6gpm9
date: 2013-07-04 17:36:21 +0500
build-date: 2013-07-05 17:37:41 +0400
revno: 3825
branch-nick: 5.5-noga-hf



 Comments   
Comment by Alexey Botchkov [ 2013-08-21 ]

MYSQL_AUDIT_NOTIFY_CONNECTION_DISCONNECT fixed so the event has this data.

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