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

Allow audit plugin to specify timestamp format when writing to file

Details

    Description

      If writing to a file, the audit plugin has a fixed timestamp format which does not include a timezone.
      This means that should the audit be centralised, unless the database's server is running in UTC time, one must use syslog to gain a timestamp that can include timezone information.

      It is suggested a new server audit system variable is defined, which if set, contains a string the strftime() routine applies with it's format argument.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          ralf.gebhardt Ralf Gebhardt added a comment -

          MariaDB Enterprise Audit provides this functionality using server_audit_timestamp_format

          ralf.gebhardt Ralf Gebhardt added a comment - MariaDB Enterprise Audit provides this functionality using server_audit_timestamp_format
          arujjval Arujjwal Negi added a comment - - edited

          Does this issue still needs to be resolved?

          arujjval Arujjwal Negi added a comment - - edited Does this issue still needs to be resolved?
          burn.alting Bernard Alting added a comment -

          Given the response by Ralf, it appears resolved, although finding documentation for this plugin configuration format appears challenging.

          Can a reference be offered and then close this ticket?

          burn.alting Bernard Alting added a comment - Given the response by Ralf, it appears resolved, although finding documentation for this plugin configuration format appears challenging. Can a reference be offered and then close this ticket?
          serg Sergei Golubchik added a comment -

          This is only in the MariaDB Enterprise Audit. Mentioned here: https://mariadb.com/resources/blog/new-mariadb-enterprise-server-releases-10-4-10-6-with-backported-features/ (look for server_audit_timestamp_format).

          It is not available in the MariaDB Server, which could be a reason for keeping this ticket open.

          serg Sergei Golubchik added a comment - This is only in the MariaDB Enterprise Audit . Mentioned here: https://mariadb.com/resources/blog/new-mariadb-enterprise-server-releases-10-4-10-6-with-backported-features/ (look for server_audit_timestamp_format ). It is not available in the MariaDB Server, which could be a reason for keeping this ticket open.

          People

            Unassigned Unassigned
            burn.alting Bernard Alting
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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