From owner-freebsd-questions@FreeBSD.ORG Fri Aug 5 11:35:09 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7744C16A41F for ; Fri, 5 Aug 2005 11:35:09 +0000 (GMT) (envelope-from corwin@amber.aeternal.net) Received: from amber.aeternal.net (amber.in.markiza.sk [62.168.76.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6D67243D49 for ; Fri, 5 Aug 2005 11:35:08 +0000 (GMT) (envelope-from corwin@amber.aeternal.net) Received: from localhost (localhost.aeternal.net [127.0.0.1]) by amber.aeternal.net (Postfix) with ESMTP id 5DF5EB823 for ; Fri, 5 Aug 2005 13:39:20 +0200 (CEST) Received: from amber.aeternal.net ([127.0.0.1]) by localhost (amber.aeternal.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19367-03 for ; Fri, 5 Aug 2005 13:39:17 +0200 (CEST) Received: from amber.aeternal.net (localhost.aeternal.net [127.0.0.1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by amber.aeternal.net (Postfix) with ESMTP id 5BF8BB821 for ; Fri, 5 Aug 2005 13:39:17 +0200 (CEST) Received: (from corwin@localhost) by amber.aeternal.net (8.13.3/8.13.1/Submit) id j75BdHso019719 for freebsd-questions@freebsd.org; Fri, 5 Aug 2005 13:39:17 +0200 (CEST) (envelope-from corwin) Date: Fri, 5 Aug 2005 13:39:16 +0200 From: martin hudec To: freebsd-questions@freebsd.org Message-ID: <20050805113916.GD8328@amber.aeternal.net> References: <00c101c599a3$1ccaf830$0301a8c0@danielle> <20050805104545.GA9730@state-of-mind.de> <00f901c599ad$982cec40$0301a8c0@danielle> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="fOHHtNG4YXGJ0yqR" Content-Disposition: inline In-Reply-To: <00f901c599ad$982cec40$0301a8c0@danielle> X-Copyright: (C) 2005 Martin Hudec X-Operating-System: FreeBSD amber.aeternal.net 5.4-STABLE i386 X-PGP-Key: http://www.aeternal.net/corwin_aeternal.asc User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at aeternal.net Subject: Re: Problems with SASL2 and postfix on freebsd X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: martin hudec List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 05 Aug 2005 11:35:09 -0000 --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--