PAM ListMySQL Module joins the functionality of both pam_mysql and pam_listfile. PAM ListMySQL Module is used to search a list of tokens (pam_listfile) using a MySQL database as a source (pam_mysql).
The module options are listed below with default in ()s:
The user with access to open the connection to MySQL
and has permission to read the table with the passwords.
Password for the MySQL user.
Machine that is running the MySQL server.
Name of database that contains the table with the user/password
Name of table that you want to use for the user/password checking.
This can be a series of tables with full JOIN-style syntax if you
want more complex control. For example:
[table=Host LEFT JOIN HostUser ON HostUser.host_id=Host.id
LEFT JOIN User ON HostUser.user_id=User.id]
Name of column that has the field describint the type identified by
Used to specify additional criteria for the query. Not that you probably
need to use libpam's extended option format. For example:
[where=Host.name="web" AND User.active=1]
Type of data to be searched for, can be one of:
Action to take if found in table, if the item is NOT found in the table,
then the opposite action is requested (can be allow or deny)
Set the path of the configuration file, see the configuration example in
order to learn the syntax
· MySQL server
What's New in This Release:
· MySQL options may now go in a configuration file, in order to protect them with file permissions.
· Small bugfixes.
· Updated documentation.