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

audit plugin - record full query / document line length / make buffer configurable

Details

    Description

      Hey,

      the audit plugin "should" record every part of the query. the current implementation is using a static buffer to shorten the query part. since an audit is used to detect problems or hacking attempts, the audit plugin is unusable. the current size of the buffer is 768 and should be dynamic by default or atleast configurable.
      especially on hacking attacks the last part (where clause) is modified but this part is not part of the audit line. in addition this should be added to the documentation.

      https://github.com/MariaDB/server/blob/10.1/plugin/server_audit/server_audit.c#L1018

      Attachments

        Activity

          holyfoot,

          I remember it being discussed back in days and declared to be by design, but I cannot find any traces of it in JIRA, so maybe I'm wrong. Could you please clarify?

          elenst Elena Stepanova added a comment - holyfoot , I remember it being discussed back in days and declared to be by design, but I cannot find any traces of it in JIRA, so maybe I'm wrong. Could you please clarify?

          Any progress on that issue? Would be cool to know if there will be a change on future releases.

          h0nIg Hans-Joachim Kliemeck added a comment - Any progress on that issue? Would be cool to know if there will be a change on future releases.

          Fixing patch: http://lists.askmonty.org/pipermail/commits/2015-March/007689.html
          The server_audit_query_log_limit variable added to control the length of the log record.

          holyfoot Alexey Botchkov added a comment - Fixing patch: http://lists.askmonty.org/pipermail/commits/2015-March/007689.html The server_audit_query_log_limit variable added to control the length of the log record.

          People

            holyfoot Alexey Botchkov
            h0nIg Hans-Joachim Kliemeck
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.