Has anyone had any luck using the audit_log_filter plugin / component from Percona?
I have installed Percona Server for MySQL 8.0 (8.0.41-32) and Percona Server for MySQL 8.4 (8.4.3-3) and followed the instructions to install it.
I'm using Debian 12 (bookworm) if that makes any difference.
e.g.
1) run the script
audit_log_filter_linux_install.sql to create the two tables and install the plugin / component.
2) set up logging using:
SELECT audit_log_filter_set_filter('log_all', '{"filter": {"log": true}}');
SELECT audit_log_filter_set_user('%', 'log_all');
This should enable logging of all events for all users.
I then run a series of queries, that include create schema / create table / insert / update / delete / drop etc.
I've tried it with different users
I've tried it on workbench and from the cmdline
And yet the only thing that ever appears in the log is:
Audit
0_2025-03-13T11:47:51
2025-03-13T11:47:51
1
which is generated when the server restarts.
Am I missing something, or does it simply not work?
Asked by IGGt
(2276 rep)
Mar 13, 2025, 02:07 PM