pam_mysql 0.7RC1

April 12th, 2006

I needed the latest version of pam_mysql for a project I’m working on, and ended up making a couple of RPMs that don’t appear to exist elsewhere.

Fedora Core 5

The CentOS 4 version has MD5 disabled… there is a problem with cyrus-sasl-devel package which provides the md5 headers.

CentOS 4

Sample configuration:

/etc/pam.d/system-auth

auth        sufficient    pam_mysql.so config_file=/etc/pam_mysql.conf

/etc/pam_mysql.conf

users.host=localhost;
users.database=mydb;
users.db_user=localhost;
users.db_passwd=localhost;
users.table=usertable;
users.user_column=username;
users.password_column=password;
users.password_crypt=plain;
users.disconnect_every_operation=true;
verbose=0;
log.enabled=1;
log.table=logins;
log.message_column=message;
log.pid_column=pid;
log.user_column=username;
log.host_column=machineip;
log.time_column=logintime;