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

Audit: QUERY event contains an empty field and does not contain default schema

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          Description

          The QUERY event has a position between IP address and connection ID, which seems to be always empty.
          At the same time, it does not log the default schema where the query was executed, while I think it should be expected for events of this type.

          The test already exists in server_audit.test and the result is recorded as described above:

          set global server_audit_incl_ddl_users='odin, dva, tri';
create table t1 (id int);
...
TIME,HOSTNAME,root[root] @ localhost [],,1,QUERY,set global server_audit_incl_ddl_users='odin, dva, tri'
TIME,HOSTNAME,root[root] @ localhost [],,1,QUERY,create table t1 (id int)

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

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

                • Major - Major loss of function.
                • Closed

                  Activity

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

                  Well the client's host supposed to be on that place accordingly to the spec. But i don't know at the moment where to get it as the auditing event doesn't have that field. So right, it's always empty.

                  Show
                  holyfoot Alexey Botchkov added a comment - Well the client's host supposed to be on that place accordingly to the spec. But i don't know at the moment where to get it as the auditing event doesn't have that field. So right, it's always empty.
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  And what about the default schema?

                  Show
                  elenst Elena Stepanova added a comment - And what about the default schema?
                  Hide
                  Permalink
                  holyfoot Alexey Botchkov added a comment -

                  FIxed as the record format has been changed, particularly the database name was added.

                  Show
                  holyfoot Alexey Botchkov added a comment - FIxed as the record format has been changed, particularly the database name was added.

                    People

                    • Assignee:
                      holyfoot Alexey Botchkov
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: