Hello Faustin,
Il 28/11/18 16:10, Faustin Lammler ha scritto:
@Marco, I can't see where you activated the plugin in the conf you
provided?
May I ask you both to give me the result of:
$ sudo grep -r server_audit.so /etc/
The result was empty. Probably once the plugin is enabled from mysql
prompt it gets loaded afterwards (to that may refer the documentation
you reported where it says "the audit plugin has been
loaded at least once before").
Once I added the line "plugin_load=server_audit=server_audit.so" in the
configuration (before other server audit variables) I got this error
when restarting mysql:
2018-11-28 16:12:24 140583061729728 [ERROR] Plugin 'server_audit'
already installed
Before no errors were reported and the plugin was working normally. So I
issued this from mysql prompt:
UNINSTALL PLUGIN server_audit;
and now the error is gone when restarting the server with audit plugin
loaded in configuration files.
I think that when enabling the plugin from mysql prompt it should be
either disabled when restarting the server or not give an error when
upgrading the package.
I've searched my mysql history for the command that may have enabled the
plugin and the only one I found is this one (or maybe it was not stored
in history):
SET GLOBAL server_audit_events='CONNECT,TABLE';
This document for example gives the third alternative to enable the
audit plugin from the mysql client:
https://mariadb.com/resources/blog/activating-auditing-for-mariadb-and-mysql-in-5-minutes/
Thank you and best regards,
Marco
