MySQL Plugin failed to install due to “undefined symbol”

auditmariadbMySQL

For several years now I have used the MariaDB Audit Plugin on my MySQL databases.

I am now looking to start Upgrading my databases to MySQL 8, and so have just tried installing it onto MySQL 8.0.19, but am getting the following error:

Error Code: 1126. Can't open shared library '/usr/lib/mysql/plugin/server_audit.so' (errno: 2 /usr/lib/mysql/plugin/server_audit.so: undefined symbol: fn_format)

I tried downloading the latest version (audit 1.4.7 from the MariaDB 10.4.7 binaries) but it made no difference.
Downloading older versions of the plugin also made no difference.

Is this likely to be a MySQL problem or a Mariadb problem? And is there a way to get round this. Most of my databases are installed on Debian 9 or 10 servers.

Best Answer

It's not really an answer, but I found a workaround, which is to use the Percona Audit Plugin instead (which I used to use anyway, but stopped working when I moved from 5.5 to to 5.7, but strangely now works again with 8.0). In my case I already have the support code and infrastructure to switch back to this so it's not a big task.