Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Audit log filtering by user is not working

Description

Using this configuration on PS 5.6.39:

The queries are logged even if the user is excluded:

The same configuration using 5.7.25 works fine.

 

Environment

None

Smart Checklist

Activity

Show:

Guido Iaquinti June 18, 2019 at 12:44 PM

I've created a repo for the repro so you can quickly test across PS versions https://github.com/guidoiaquinti/mysql-audit

Lalit Choudhary June 18, 2019 at 10:52 AM

Hello

Interesting, Thank you for the test. I will re-check this. 

Guido Iaquinti June 18, 2019 at 10:50 AM

If I'm not missing something I can repro on PS 5.6.44 as well with the dynamic configuration:

Install plugin + config:

Run query as test_user:

Audit still shows the entries:

Lalit Choudhary June 18, 2019 at 10:27 AM

Hi Yves, Guido

Thank you for the report and test.

I see the same issue when we set audit_log_exclude_accounts in my.cnf

 

 

One thing I notice while testing is, this issue is not reproducible when we set  audit_log_exclude_accounts dynamically.

 

Tested with Server version: 5.6.43-84.3 Percona Server (GPL)

 

 

Guido Iaquinti June 18, 2019 at 8:51 AM

I've tested 5.6.36, 5.6.37, 5.6.38, 5.6.39, 5.6.40, 5.6.41, 5.6.42, 5.6.43 and 5.6.44 and I can repro on all of them

Done

Details

Assignee

Reporter

Labels

Time tracking

3d 26m logged

Fix versions

Affects versions

Priority

Smart Checklist

Created June 17, 2019 at 6:56 PM
Updated March 6, 2024 at 12:04 PM
Resolved October 2, 2019 at 7:39 AM
Configure