Getting PAM to use MySQL

[rshadow]

Ok. I'm still working on trying get postfix to auth from a mysql database. I believe that Postfix is now correctly identifing cyrus-sasl, as AUTH=PLAIN LOGIN lines appear on a EHLO of the postfix server. Now I'm a little confused about what is happening and exactly where its happening at.

Looking at my MySQL logs, I can see that an attempt to access the database is being made, however with no password. (see below). So I don't know if sasl is correctly calling PAM, or if PAM is configured wrong... or MySQL database is configured wrong.

[snip of mysql log]
sunflower1 mysql # head mysql.log
/usr/sbin/mysqld, Version: 4.0.16-log, started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
040205 8:50:47 1 Connect Access denied for user: 'mailsql@localhost' (Using password: NO)
040205 8:50:55 2 Connect Access denied for user: 'mailsql@localhost' (Using password: NO)
040205 8:51:33 3 Connect Access denied for user: 'mailsql@localhost' (Using password: NO)

here is how pam is configured. (for pop3d, imap, and smtp. all the same)
auth optional pam_mysql.so host=localhost db=mailsql user=mailsql passwd=sunfloweryoung table=users usercolumn=email passwdcolum=clear crypt=0
account required pam_mysql.so host=localhost db=mailsql user=mailsql passwd=sunfloweryoung table=users usercolumn=email passwdcolumn=clear crypt=0

[pjp]

Moved from Installing Gentoo.
_________________
Quis separabit? Quo animo?