Audit plugin is loggin everything, despite the configuration parameters - Source

Revision: 128610
User: Teresa Noviello
Date: 2023-08-08 11:37

My goal is to configure audit plugin with MariaDB with the forwarding of the auditing log entries to Syslog. This so far works. Unfortunately, I also want to limit the auditing log entries to just the queries which produced an error.  I achieved the target of having only the queries logged setting the audit configuration variable 'server_audit_events' to 'QUERY'. This works, since now I can see in Syslog only the queries done in MySQL client, while the "CONNECT" and "DISCONNECT" actions are hidden. Unfortunately, I can see in Syslog ALL the queries, not only the queries which produced errors. Setting the audit configuration variable 'server_audit_syslog_priority' to 'LOG_WARNING' or 'LOG_ERR' didn't change the situation. 
My MariaDB version is '10.0.22'. The plugin configuration variables are shown below (*) Any help is welcomed.

Cheers, Teresa

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Audit plugin is loggin everything, despite the configuration parameters - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB