postfix, saslauthd, pam_mysql - wrong username is being send

[Martin Hudec]

Hello,

I have postfix set up using saslauthd to authenticate against
mysql database with pam_mysql. Usernames are stored in
database like "user at domain.tld" (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 "username at domain.tld). 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     postfix at localhost 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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20040730/24b03e64/attachment.bin