Date: Fri, 30 Jul 2004 12:01:15 +0200 From: Martin Hudec <corwin@aeternal.net> To: freebsd-questions@freebsd.org Subject: postfix, saslauthd, pam_mysql - wrong username is being send Message-ID: <20040730100115.GD20690@pleiades.aeternal.net>
next in thread | raw e-mail | index | archive | help
--xB0nW4MQa6jZONgY Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hello, I have postfix set up using saslauthd to authenticate against mysql database with pam_mysql. Usernames are stored in database like "user@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@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=3Dpostfix passwd=3D****** db=3Dpostfi= x table=3Dmailbox usercolumn=3Dusername passwdcolumn=3Dpassword crypt=3D1 smtp auth required pam_mysql.so user=3Dpostfix passwd=3D****** db=3Dpostfix= table=3Dmailbox usercolumn=3Dusername passwdcolumn=3Dpassword crypt=3D1 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=20 Jul 30 11:46:40 amber saslauthd[57854]: pam_mysql: select returned more tha= n one result Jul 30 11:46:40 amber saslauthd[57854]: do_auth : auth failure: [us= er=3Dtaker] [service=3Dsmtp] [realm=3Daeternal.net] [mech=3Dpam] [reason=3D= 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 fa= ilure: 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= =2E0.39] In mysql.log: 040730 11:46:40 240 Connect postfix@localhost on postfix 240 Init DB postfix 240 Query SELECT password FROM mailbox WHERE user= name=3D'taker' 240 Quit Thank you, Martin --=20 Martin Hudec | corwin at aeternal.net | corwin at web.markiza.sk http://www.aeternal.net | cell +421 907 303 393 --xB0nW4MQa6jZONgY Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQFBChxrZYEZIv+rgggRApJQAKCUgzJfq0fPjXYumUGQ71yfKdXYTgCfXybZ w/JWbjuJcsg9AofXcaIfUHw= =Z58B -----END PGP SIGNATURE----- --xB0nW4MQa6jZONgY--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040730100115.GD20690>