Audit_log_filter.file parameter - Cannot change default location

MySQL & MariaDB
1

(Note: Using Percona MySQL 8.4.6-6 on RHEL 9)

When using the new audit log filter component by default the my.cnf file contains the following configuration:

audit_log_filter.file=audit_filter.log

With the older audit plugin it was possible to change the location and file name of the log file, for example:

audit_log_file=/var/log/percona/audit.json

I can change the file name but if I also change the file location and restart mysql none of the audit parameters are loaded and the audit log file is not created.

Is this a known issue or is it no longer possible to change the location of the audit file this way?

2

This is working for me as expected. Did you verify that the correct user and group have the needed privileges to write to the location you have chosen? See below how mine it setup.

Here is whats in my my.cnf:

audit_log_filter.file=/var/lib/auditlog/audit.log

Here are user and group permissions.

-rw-r----- 1 mysql mysql 2563 Oct 13 07:54 audit.log
3

That was the issue, thank you.

By the way your two articles on the audit log filter component are very helpful!

1 Like