Date: Fri, 5 Aug 2005 13:39:16 +0200 From: martin hudec <corwin@aeternal.net> To: freebsd-questions@freebsd.org Subject: Re: Problems with SASL2 and postfix on freebsd Message-ID: <20050805113916.GD8328@amber.aeternal.net> In-Reply-To: <00f901c599ad$982cec40$0301a8c0@danielle> References: <00c101c599a3$1ccaf830$0301a8c0@danielle> <20050805104545.GA9730@state-of-mind.de> <00f901c599ad$982cec40$0301a8c0@danielle>
next in thread | previous in thread | raw e-mail | index | archive | help
--fOHHtNG4YXGJ0yqR Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hello, if I may ask, my problem has something common with this.. See below.. =20 On Fri, Aug 05, 2005 at 01:05:30PM +0200 or thereabouts, cell wrote: > >>Trying 127.0.0.1... > >>Connected to localhost.linux-win.org. > >>Escape character is '^]'. > >>220 gw-bsd.linux-win.org ESMTP Postfix 2.2.5 (FreeBSD) > >>ehlo example.pl > >>250-gw-bsd.linux-win.org > >>250-PIPELINING > >>250-SIZE 10000000 > >>250-VRFY > >>250-ETRN > >>250-STARTTLS > >>250 8BITMIME 220 amber.aeternal.net ESMTP Postfix ehlo aeternal.net 250-amber.aeternal.net 250-PIPELINING 250-SIZE 10240000 250-VRFY 250-ETRN 250-STARTTLS 250-AUTH LOGIN PLAIN 250-AUTH=3DLOGIN PLAIN 250 8BITMIME So far so good, I am offering LOGIN and PLAIN.. > >>In /usr/local/lib/sasl2 i have that : > >> > >>pwcheck_method: saslauthd > >>auxprop_plugin: sql > >>sql_engine: mysql > >>sql_hostnames: 127.0.0.1 > >>sql_user: maildb > >>sql_passwd: ***** > >>sql_database: maildb > >>sql_select: select clear from users where id=3D'%u@%r' I am getting following error: Aug 5 13:22:27 amber postfix/smtpd[18606]: sql_select option missing Aug 5 13:22:27 amber postfix/smtpd[18606]: auxpropfunc error no mechanism available I assume it is caused by configuration of my /usr/local/lib/sasl2/smtpd: pwcheck_method: authdaemond log_level: 3 mech_list: PLAIN LOGIN authdaemond_path:/usr/local/var/spool/authdaemon/socket Maybe I need to setup sql_* stuff like above, but.. due to security reasons I do not have any clear (plaintext form of password) in my table, but md5 hashed password. Is there any way how to put into sql_select directive that I need to use md5? Or do I have to store also plaintext form of passwords?=20 --=20 martin hudec * 421 907 303 393 * corwin@aeternal.net * http://www.aeternal.net "Nothing travels faster than the speed of light with the possible=20 exception of bad news, which obeys its own special laws." Douglas Adams, "The Hitchhiker's Guide to the Galaxy" --fOHHtNG4YXGJ0yqR Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFC80/kZYEZIv+rgggRAjDNAJsGb/pWD1Av2JWeyUn67OR/rNddBwCePp2e XLGoqZgMf6MQo6X0oD8ZLQ4= =3Kiv -----END PGP SIGNATURE----- --fOHHtNG4YXGJ0yqR--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050805113916.GD8328>