Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11851

database field is empty while using audit plugin for MySQL 5.6.21 community editoin

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.0.24
    • Fix Version/s: 10.0.30
    • Component/s: Plugin - Audit
    • Labels:
    • Environment:
      MySQL Server version: 5.6.21-log MySQL Community Server (GPL)
    • Sprint:
      5.5.55, 10.0.30

      Description

      I am using server_audit.so for auditing MySQL data into audit file everything is working as expected however database field is coming as empty in the audit log. Here is the sample information

      Here is the sequence of events I fired on mySQL server
      1. connected to server
      2. executed show databases
      3. change the database context using USE command, it is not captured

      20170120 01:12:26,mariadbserver1,root,localhost,1,0,CONNECT,,,0
      20170120 01:34:24,mariadbserver1,root,localhost,1,9,QUERY,,'show databases',0
      20170120 01:34:27,mariadbserver1,root,localhost,1,10,QUERY,,'SELECT DATABASE()',0
      20170120 01:34:30,mariadbserver1,root,localhost,1,11,QUERY,,'show tables',0
      20170120 01:34:39,mariadbserver1,root,localhost,1,12,QUERY,,'delete from user where id=2',0
      20170120 01:34:45,mariadbserver1,root,localhost,1,13,QUERY,,'delete from user where id=3',0

        Attachments

          Activity

            People

            • Assignee:
              holyfoot Alexey Botchkov
              Reporter:
              calyankumar Kalyan
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: