Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-3867

audit_log_include_accounts variable does not take effect if placed in my.cnf config

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.6, Not 5.5, 5.7.21-20
    • Fix Version/s: 5.6.40-84.0, 5.7.22-22
    • Component/s: None
    • Labels:

      Description

      If I add audit_log_include_accounts=<any account> to my.cnf and restart MySQL, it will stop logging anything to audit log. However, if I run "set global audit_log_include_accounts='...' it will take effect.

      How to repeat (enable audit plugin first):

      1. Add audit_log_include_accounts=root@localhost to my.cnf and restart
      2. Login as root@localhost and watch audit.log - nothing goes there, try with another user - same effect, nothing being logged
      3. Run 
        mysql> set global audit_log_include_accounts = 'root@localhost';
        Query OK, 0 rows affected (0.00 sec)

      and login as root from another session. Audit.log will have entries. Everything now works as expected.
       

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                zsolt.parragi Zsolt Parragi
                Reporter:
                alexander.rubin Alexander Rubin (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day, 13 minutes
                  1d 13m