The Ultimate Guide to High Availability with MariaDB

Comments - Authentication Plugin - PAM

8 years, 1 month ago Sanjay Kumar Raghavendra
Re: PAM Authentication Plugin

I am attempting to install PAM plugin for MySQL 5.7 Community server however when I invoke the command INSTALL SONAME 'auth_pam', 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

The auth_pam.so was already copied to plugin_dir location. I even tried adding the variable plugin_load to mysqld section in my.cnf. However when I do show plugin, I don't see this plugin getting listed.

Do I need to do anything additional besides the above step?

 
8 years, 1 month ago Sergei Golubchik
Re: PAM Authentication Plugin

INSTALL SONAME is MariaDB feature, in MySQL you should use INSTALL PLUGIN.

PAM plugin might not work even if you will use the correct statement. Try to compile it for 5.7. And even that might not help.

 
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.