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

Improving audit api

Details

    • 5.5.48-0, 10.0.24, 10.2.0-6, 10.2.0-7, 5.5.50, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4

    Description

      A lot of desired features of the audit plugin are stalled as the current API doesn't provide necessary capabilities.
      The list of desired ones:

      • plugin data can be stored in the server table.
      • information about user's role
      • information about the tables/databases involved with the query
      • possible parser result of the query
      • export JSON functions
      • access to the information about the connection
        encryption used
        authentication method
        connection type
        connector used

      I don't think there is any reason to extend the structures that are sent to the auditing
      fucntions. The way to go is creating server functions that can be linken in the plugin - irectly or via the 'service'-s.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-5983 Auditing plugin v2.0

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-7389 Request: log warnings into SQL_ERROR_LOG

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-5212 Role support for Audit Plugin API

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-10299 Make server_audit plugin support roles

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-12494 Include or exclude host names from auditing

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-14713 MariaDB Audit Plugin audits SET GLOBAL

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19442 server_audit plugin doesn't consider proxy users in server_audit_excl_users/server_audit_incl_users

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19443 server_audit plugin doesn't log proxy users

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-19458 server_audit plugin should log when the server starts up and when the server shuts down

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-5216 5.5.34 merge

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Task - A task that needs to be done. MDEV-5652 5.5.36 merge

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            holyfoot Alexey Botchkov added a comment -

            Patch proposal:
            http://lists.askmonty.org/pipermail/commits/2016-February/009025.html

            holyfoot Alexey Botchkov added a comment - Patch proposal: http://lists.askmonty.org/pipermail/commits/2016-February/009025.html
            holyfoot Alexey Botchkov added a comment -

            http://lists.askmonty.org/pipermail/commits/2018-December/013177.html

            I didn't include method implementations in this patch - to focus on the interface.

            holyfoot Alexey Botchkov added a comment - http://lists.askmonty.org/pipermail/commits/2018-December/013177.html I didn't include method implementations in this patch - to focus on the interface.
            holyfoot Alexey Botchkov added a comment -

            http://lists.askmonty.org/pipermail/commits/2018-December/013197.html

            holyfoot Alexey Botchkov added a comment - http://lists.askmonty.org/pipermail/commits/2018-December/013197.html
            holyfoot Alexey Botchkov added a comment -

            http://lists.askmonty.org/pipermail/commits/2019-January/013298.html

            holyfoot Alexey Botchkov added a comment - http://lists.askmonty.org/pipermail/commits/2019-January/013298.html

            People

              ralf.gebhardt Ralf Gebhardt
              serg Sergei Golubchik
              Votes:
              0 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.