Audit plugin API: no MYSQL_AUDIT_GENERAL_LOG notifications with general log off

Bug #1182535 reported by Sergei Glushchenko
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Percona Server moved to
Fix Released
Sergei Glushchenko
Fix Released
Sergei Glushchenko
Fix Released
Sergei Glushchenko

Bug Description

This is a reference to upstream bug

When writing audit plugins it is not possible to get notifications for general-log events without enabling the general-log.

As described here:
audit notifications only occurs for MYSQL_AUDIT_GENERAL_LOG events with the general_log enabled. It would presumably be more useful for those notifications to be generated regardless of the general_log being enabled or not.

A short discussion on this can be found here (see the 2 comments):

How to repeat:
It is documented behavior.

Suggested fix:
Perhaps as described in the linked blogpost:
Have the general_log variables have 3 values (ON, AUDIT_ONLY and OFF).

Tags: upstream

Related branches

tags: added: upstream
Revision history for this message
Alexey Kopytov (akopytov) wrote :

Hm, the comment got lost. There's no need for another general_log value. The server should just call mysql_audit_general_log() even if the general log is disabled.

Revision history for this message
Sergei Glushchenko (sergei.glushchenko) wrote :

Marking as Invalid for 5.1 as it appears that no audit plugins can be written for 5.1.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to:

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.