Frequently Asked Questions¶
Is there a Windows version?¶
No, Windows does not support PAM, so there will not be a Windows version.
Can I use it with MySQL?¶
Can I use it with Percona Server?¶
Is it Free and Open Source Software?¶
Can I use the PAM plugin to authenticate against /etc/shadow?¶
Yes, you need to add the mysql user to the shadow group. Because PAM libraries, such as ‘pam_unix.so’, need to access /etc/shadow.
For example this is how you can do it in Ubuntu:
root@lucid64:/var/lib/mysql# getent group shadow shadow:x:42:mysql root@lucid64:/var/lib/mysql# ls -alhs /etc/shadow 4.0K -rw-r----- 1 root shadow 912 Dec 21 10:39 /etc/shadow
After you restart mysqld for changes to take effect, pam_unix authentication will work.
The other option is to run mysqld as root. This should be used for testing only or as a last resort method.
I’m getting the: “ERROR 2059 (HY000): Authentication plugin ‘auth_pam’ cannot be loaded”¶
This means that the default client plugin-dir setting doesn’t work or it isn’t set up properly. You’ll need to add the location of the plugin folder to your client configuration:
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.