Ok. I'm still working on trying get postfix to auth from a mysql database. (postfix->sasl->pam->mysql) 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. Maybe I'm going about this all wrong. Is there an easier way to have postfix auth multiple domains/users against a mysql database? [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: '[EMAIL PROTECTED]' (Using password: NO) 040205 8:50:55 2 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) 040205 8:51:33 3 Connect Access denied for user: '[EMAIL PROTECTED]' (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 -- [EMAIL PROTECTED] mailing list
