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?

Yes.

Can I use it with Percona Server?

Yes.

Is it Free and Open Source Software?

Yes.

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:

[client]
plugin_dir='/usr/lib/mysql/plugin'
© Copyright 2012, Percona Inc.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.2.2.
This documentation is developed in Launchpad as part of the Percona PAM authentication plugin For MySQL source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>