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.