Hello, I have postfix set up using saslauthd to authenticate against mysql database with pam_mysql. Usernames are stored in database like "[EMAIL PROTECTED]" (username with @ and domain is used because I have multiple domains virtualhosted there). But I am unable to authenticate because I am not getting whole username sent. I am getting just "username", not whole "[EMAIL PROTECTED]). Can anyone help and tell me how to get whole username to select from database please?
In pam.conf:
smtpd auth required pam_mysql.so user=postfix passwd=****** db=postfix table=mailbox
usercolumn=username passwdcolumn=password crypt=1
smtp auth required pam_mysql.so user=postfix passwd=****** db=postfix table=mailbox
usercolumn=username passwdcolumn=password crypt=1
In smtpd.conf:
pwcheck_method: saslauthd
mech_list: plain login
In auth.log:
Jul 30 11:46:02 amber postfix/smtpd[58005]: sql_select option missing
Jul 30 11:46:02 amber postfix/smtpd[58005]: auxpropfunc error no mechanism available
Jul 30 11:46:40 amber saslauthd[57854]: pam_mysql: select returned more than one result
Jul 30 11:46:40 amber saslauthd[57854]: do_auth : auth failure: [user=taker]
[service=smtp] [realm=aeternal.net] [mech=pam] [reason=PAM auth error]
NOTE: sql_select option missing and auxpropfunc error are there maybe
because I miss some things in smtpd.conf. Correct?
In maillog:
Jul 30 11:46:40 amber postfix/smtpd[58005]: connect from unknown[192.168.0.39]
Jul 30 11:46:40 amber postfix/smtpd[58005]: setting up TLS connection from
unknown[192.168.0.39]
Jul 30 11:46:40 amber postfix/smtpd[58005]: TLS connection established from
unknown[192.168.0.39]: TLSv1 with cipher RC4-MD5 (128/128 bits)
Jul 30 11:46:40 amber postfix/smtpd[58005]: warning: SASL authentication failure:
Password verification failed
Jul 30 11:46:40 amber postfix/smtpd[58005]: warning: unknown[192.168.0.39]: SASL PLAIN
authentication failed
Jul 30 11:46:40 amber postfix/smtpd[58005]: lost connection after AUTH from
unknown[192.168.0.39]
Jul 30 11:46:40 amber postfix/smtpd[58005]: disconnect from unknown[192.168.0.39]
In mysql.log:
040730 11:46:40 240 Connect [EMAIL PROTECTED] on postfix
240 Init DB postfix
240 Query SELECT password FROM mailbox WHERE username='taker'
240 Quit
Thank you,
Martin
--
Martin Hudec | corwin at aeternal.net
| corwin at web.markiza.sk
http://www.aeternal.net | cell +421 907 303 393
pgpMF1ZvZkvks.pgp
Description: PGP signature
