Installation

The MariaDB Audit Plugin is provided as a dynamic library: server_audit.so (server_audit.dll for Windows). The plugin must and should be located in the plugin library. The file path of the plugin library is recorded in the plugin_dir system variable. To see the value of this variable and determine thereby the file path of the plugin library, execute the following SQL statement:

SHOW GLOBAL VARIABLES LIKE 'plugin_dir';
+---------------­­­­­­­­­­­­­­­+------------------------------­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­+
| Variable_name | Value                        |
+---------------­­­­­­­­­­­­­­­+------------------------------­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­+
| plugin_dir    | /usr/local/mysql/lib/plugin/ |
+---------------­­­­­­­­­­­­­­­+------------------------------­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­+

The plugin can be loaded from the command‑line as a start‑up parameter, or it can be set in the configuration file (i.e., my.cnf or my.ini). Below is an excerpt from a configuration file, showing the relevant line to load this plugin. To use this option from the command‑line at start‑up, just add a double‑dash (e.g.,--­­plugin-­load).

[mysqld]
...
plugin-­load=server_audit=server_audit.so
...

Comments

Comments loading...