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

Audit: DISCONNECT event does not contain user/server

        Details

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

          Description

          CONNECT events have user name and server host among other values. DISCONNECT only has connection ID: 

          20130705 17:32:36,ubuntu12-04,test,localhost,7,CONNECT
20130705 17:32:36,ubuntu12-04,test[test] @ localhost [127.0.0.1],,7,QUERY,show databases
20130705 17:32:36,ubuntu12-04,test[test] @ localhost [127.0.0.1],,7,QUERY,show tables
20130705 17:32:37,ubuntu12-04,test[test] @ localhost [127.0.0.1],,7,QUERY,select @@version_comment limit 1
20130705 17:32:43,ubuntu12-04,,,7,DISCONNECT

          While technically the missing info can be restored by finding the corresponding CONNECT event (by connection ID) and taking user/server from there, it is definitely inconvenient, so it would be good to fix it if possible.

          bzr version-info

          revision-id: holyfoot@askmonty.org-20130704123621-gb3jvhyxdax6gpm9
date: 2013-07-04 17:36:21 +0500
build-date: 2013-07-05 17:37:41 +0400
revno: 3825
branch-nick: 5.5-noga-hf

            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

                  Hide
                  Permalink
                  holyfoot Alexey Botchkov added a comment -

                  MYSQL_AUDIT_NOTIFY_CONNECTION_DISCONNECT fixed so the event has this data.

                  Show
                  holyfoot Alexey Botchkov added a comment - MYSQL_AUDIT_NOTIFY_CONNECTION_DISCONNECT fixed so the event has this data.

                    People

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

                      Dates

                      • Created:
                        Updated:
                        Resolved: