Pluggable Authentication Modules PAM

February 1st, 2007

PAM is a very flexible tool for authentication. I use it with Apache for realm-based authentication via MySQL with the help of pam_mysql, and I'm trying to set it up so that there is a "WHERE" clause in the SQL statement.

It goes like this:

auth required ignore_root user=user_name passwd=pass_key db=db_name table=table_name \

usercolumn=user_column_name passwdcolumn=password_column [where=another_column_name='value'] \


Works like a charm!

Yearly Indexes: 2003 2004 2006 2007 2008 2009 2010 2011 2012 2013 2015 2019 2020