[NTLUG:Discuss] cyrus-sasl and mysql

[joseph beasley]

Ok I figured it out using pam_mysql.  Here are my configs.

/etc/imapd.conf

configdirectory: /var/imap
partition-default: /var/spool/imap
admins: root cyrus jbeasley
sasl_pwcheck_method:  saslauthd
tls_key_file: /etc/httpd/apache.key
tls_cert_file: /etc/httpd/apache.crt
allowanonymouslogin: no
allowplaintext: yes
servername: server.somesuch.com
unixhierarchysep: yes

/etc/rc.d/init.d/saslauthd    *** must be running to authenticate.

MECH=pam         *** this is the only setting I changed. ****

/etc/pam.d/imap   *** copy this file to pop3,pop3s,imaps if needed.

 auth sufficient pam_mysql.so user=mail passwd=*password*
host=localhost db=mail table=accountuser usercolumn=username
passwdcolumn=password crypt=1

 account required pam_mysql.so user=mail passwd=*password*
host=localhost db=mail table=accountuser usercolumn=username
passwdcolumn=password  crypt=1


***Note ***
If crypt is set to 1, passwords must be stored in mysql using
"encrypt('password')".

If crypt is set to 2, passwords must be stored in mysql using "password('password')".

=====
Joe Beasley
CNE, CCNP, MCSE, CCNA, AEIOU....
PGP/GPG key --  http://home.attbi.com/~joe.beasley/joebeasley.txt
AOL Messenger            joebeasley3rd
Yahoo Messenger          joe_beasley
MSN Messenger            joebeasley3rd
ICQ                      13164242


__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com