Hi Everyone,
Must be something simple I’m missing here.
My audit log is in the old xml format. It is working and my server is using the percona audit plugin.
I put a line in the my.cnf file (I’m 100% sure that it’s the file being used)
audit_log_format = JSON
It doesnt give an error when I restart but it doesnt apply the json format to the log file.
Doing a show variables shows that the old format is still being used. what am I missing here?
root@localhost (none)> show variables like ‘audit%’;
±----------------------------±--------------+
| Variable_name | Value |
±----------------------------±--------------+
| audit_log_buffer_size | 1048576 |
| audit_log_exclude_accounts | |
| audit_log_exclude_commands | |
| audit_log_exclude_databases | |
| audit_log_file | audit.log |
| audit_log_flush | OFF |
| audit_log_format | OLD |
| audit_log_handler | FILE |
| audit_log_include_accounts | |
| audit_log_include_commands | |
| audit_log_include_databases | |
| audit_log_policy | ALL |
| audit_log_rotate_on_size | 0 |
| audit_log_rotations | 0 |
| audit_log_strategy | ASYNCHRONOUS |
| audit_log_syslog_facility | LOG_USER |
| audit_log_syslog_ident | percona-audit |
| audit_log_syslog_priority | LOG_INFO |
±----------------------------±--------------+