View Single Post
  #1  
Old 6th July 2007, 00:17
oberinspector oberinspector is offline
Junior Member
 
Join Date: Jul 2007
Posts: 3
Thanks: 0
Thanked 1 Time in 1 Post
Default Virtual Users And Domains With Postfix, Courier And MySQL (Debian Etch)

I followed the mentioned howto... i can receive pop email with thunderbird, but when i try to send an email it fails...

in mail.log:

Code:
Jul  5 22:44:11 empego postfix/smtpd[5575]: warning: SASL authentication failure: Password verification failed
Jul  5 22:44:11 empego postfix/smtpd[5575]: warning: p548AC7D5.dip.t-dialin.net[84.138.199.213]: SASL PLAIN authentication failed: authentication failure
Jul  5 22:44:12 empego postfix/smtpd[5575]: warning: p548AC7D5.dip.t-dialin.net[84.138.199.213]: SASL LOGIN authentication failed: authentication failure
in auth.log:

Code:
Jul  5 22:44:12 empego saslauthd[5568]: pam_mysql - required option "db" is not set
Jul  5 22:44:12 empego saslauthd[5568]: DEBUG: auth_pam: pam_authenticate failed: Error in service module
Jul  5 22:44:12 empego saslauthd[5568]: do_auth         : auth failure: [user=xxx@yyy.zzz] [service=smtp] [realm=yyy.zzz] [mech=pam] [reason=PAM auth error]
looks like /etc/pam.d/smtp (a symlink to /etc/pam.d/imap) is not read...
/etc/pam.d/smtp:
Code:
auth    required   pam_mysql.so user=mail_admin passwd=secret host=127.0.0.1 db=mail table=users usercolumn=email passwdcolumn=password crypt=1 verbose=1
account sufficient pam_mysql.so user=mail_admin passwd=secret host=127.0.0.1 db=mail table=users usercolumn=email passwdcolumn=password crypt=1 verbose=1
Code:
/etc/potix/sasl/smtp.conf:
pwcheck_method: saslauthd
mech_list: plain login
allow_plaintext: true
auxprop_plugin: mysql
sql_hostnames: 127.0.0.1
sql_user: mail_admin
sql_passwd: secret
sql_database: mail
sql_select: SELECT password FROM users where email = '%u'
Code:
empego:/etc# ps aux | grep saslauthd
root      5566  0.0  0.1  30308  1152 ?        Ss   22:43   0:00 /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root      5567  0.0  0.1  30308  1468 ?        S    22:43   0:00 /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root      5568  0.0  0.1  30308  1468 ?        S    22:43   0:00 /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root      5569  0.0  0.0  30308   672 ?        S    22:43   0:00 /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root      5574  0.0  0.0  30308   484 ?        S    22:43   0:00 /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5

i read some threads and tried a lot, but nothing helped... any idea what i can do!?

Last edited by oberinspector; 10th July 2007 at 11:16.
Reply With Quote
Sponsored Links