Audit_log_filter plugin not working with mysql 8.0.36

MySQL & MariaDB Percona Server for MySQL 8.0
1

I’ve been trying the new audit_log_filter plugin. Does anyone know if this should work with MySQL 8.0.36, as I can’t get it to work. I appreciate it is only in tech preview, so wondering if it only works with Percona DB at present.

I’ve installed it as per the instructions and added a filter and a user:

SELECT audit_log_filter_set_filter('log_all', '{ "filter": { "log": true } }');
SELECT audit_log_filter_set_user('%', 'log_all');

But so far, it doesn’t seem to be logging anything.

2

Hi,
For upstream MySQL, you need the enterprise version.
Here is the doc: https://dev.mysql.com/doc/refman/8.0/en/audit-log-installation.html
I’m able to get it with Percona Server for MySQL. So, not sure what steps you have taken.
Could you please elaborate on that?

3

We’re currently not a MySQL enterprise customer, and use the original Percona Audit log with our databases, hence I was wondering if the newer audit_log_filter from Percona would also work with MySQL.

I installed it as per the instructions at Install the Audit Log Filter - Percona Server for MySQL , and then populated the two tables with :

SELECT audit_log_filter_set_filter('log_all', '{ "filter": { "log": true } }');
SELECT audit_log_filter_set_user('%', 'log_all');

I can see the file has been created, but all it contains is:

<?xml version="1.0" encoding="utf-8"?>
<AUDIT>
  <AUDIT_RECORD>
    <NAME>Audit</NAME>
    <RECORD_ID>0_2024-03-19T11:49:20</RECORD_ID>
    <TIMESTAMP>2024-03-19T11:49:20</TIMESTAMP>
    <SERVER_ID>0</SERVER_ID>
  </AUDIT_RECORD>