The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Error installing AUDIT Plugin in MySQL 5.7

I downloaded mariadb-10.1.11 for Linux x86-64 and copied the auth_pam.so to plugin directory under MySQL 5.7.10 Community Server home directory. When I attempt to install the plugin I get the following error

mysql> install soname 'auth_pam'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'soname 'auth_pam'' at line 1

Then I tried the following but no luck

mysql> install plugin auth_pam_server soname 'auth_pam.so'; ERROR 1127 (HY000): Can't find symbol '_mysql_plugin_interface_version_' in library

mysql> install plugin pam soname 'auth_pam.so'; ERROR 1127 (HY000): Can't find symbol '_mysql_plugin_interface_version_' in library

Do I need to do anything additional for this to work?

Answer Answered by Guillaume Lefranc in this comment.

You seem to be confused whether you want to install the audit plugin or the PAM plugin. Instructions for installing the audit plugin are there: https://mariadb.com/kb/en/mariadb/about-the-mariadb-audit-plugin/

the PAM plugin is not compatible with MySQL 5.7, as far as I know.

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.