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

Audit: Non-query API commands produce empty QUERY events

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      Non-query API function calls appear in the audit log as QUERY events with empty query text. I don't see how it can be helpful, but can easily flood the log; so we need to either make them meaningful, or to get rid of them.

      The example below produces 2 such records, with mysql_list_fields(con,(const char*) "user",NullS) and mysql_close(con).

      Test case:

      #include <my_global.h>
      		 
      #include <mysql.h>
      		 
       
      		 
       
      		 
      int main(int argc, char **argv)
      		 
      {  
        MYSQL *con = mysql_init(NULL);
      		 
       
      		 
        if (con == NULL) 
        {
      		 
            fprintf(stderr, "%s\n", mysql_error(con));
      		 
            exit(1);
      		 
        }
      		 
       
      		 
        if (mysql_real_connect(con, "127.0.0.1", "root", "", 
                "mysql", 0, NULL, 0) == NULL) 
        {
      		 
            fprintf(stderr, "%s\n", mysql_error(con));
      		 
            mysql_close(con);
      		 
            exit(1);
      		 
        }  
       
      		 
        mysql_list_fields(con,(const char*) "user",NullS);
      		 
        mysql_close(con);
      		 
       
      		 
        exit(0);
      		 
      }

      Audit log:

      20130708 00:31:40,ubuntu12-04,root,localhost,52,CONNECT
      		 
      20130708 00:31:40,ubuntu12-04,root[root] @ localhost [127.0.0.1],,52,QUERY,,0
      		 
      20130708 00:31:40,ubuntu12-04,root[root] @ localhost [127.0.0.1],,52,QUERY,,0
      		 
      20130708 00:31:40,ubuntu12-04,,,52,DISCONNECT

      bzr version-info

      revision-id: holyfoot@askmonty.org-20130705160101-ni574i35exft3wn5
      		 
      revno: 3825
      		 
      branch-nick: 5.5-noga-hf

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-4472 Auditing Plugin

          • Major - Major loss of function.
          • Closed

          Activity

            People

              holyfoot Alexey Botchkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.