Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-1369

LP #1182535: Audit plugin API: no MYSQL_AUDIT_GENERAL_LOG notifications with general log off

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Sergei Glushchenko last update 17-03-2014 07:09:29

      This is a reference to upstream bug http://bugs.mysql.com/bug.php?id=60782.

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

      As described here:
      http://dev.mysql.com/doc/refman/5.5/en/writing-audit-plugins.html
      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):
      http://karlssonondatabases.blogspot.com/2010/03/more-on-mysql-audit-plugin-interface.html

      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).

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist