using pam mysql auth instead of the system user auth

the authenitcatoin server we are going to use is saslauthd

congfig file is : /etc/sysconfig/saslauthd

the mechanism used for checking the file is pam

MECH=pam

since we want auith for our imap clinent we edit this file

/etc/pam.d/imap

username passwdcolumn=password crypt=1 auth sufficient pam_mysql.so user= passwd= host=localhost db=mailusers table=auth usercolumn=uname passwdcolumn=pword crypt=0

account required pam_mysql.so user= passwd= host=localhost db=mailusers table=auth usercolumn=uname passwdcolumn=pword crypt=0

we create the database

we add the tables :

CREATE TABLE `auth` ( `uname` VARCHAR( 30 ) NOT NULL , `pword` VARCHAR( 30 ) NOT NULL , `cid` INT NOT NULL , PRIMARY KEY ( `uname` ) ) ENGINE = MYISAM

restart saslauthd