From owner-freebsd-questions@FreeBSD.ORG  Sun Nov 28 16:25:23 2004
Return-Path: <owner-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 716A916A4CE
	for <freebsd-questions@freebsd.org>;
	Sun, 28 Nov 2004 16:25:23 +0000 (GMT)
Received: from mailhost.reuver.org (fia1-7.dsl.hccnet.nl [62.251.7.1])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 113ED43D4C
	for <freebsd-questions@freebsd.org>;
	Sun, 28 Nov 2004 16:25:23 +0000 (GMT)
	(envelope-from marcel@de.reuver.org)
Received: from localhost (localhost.reuver.local [127.0.0.1])
	by mailhost.reuver.local (Postfix) with ESMTP id E01395193
	for <freebsd-questions@freebsd.org>;
	Sun, 28 Nov 2004 17:25:21 +0100 (CET)
Received: from mailhost.reuver.org ([127.0.0.1])
 by localhost (mailhost.reuver.local [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 27422-05 for <freebsd-questions@freebsd.org>;
 Sun, 28 Nov 2004 17:25:19 +0100 (CET)
Received: from pc10 (pc10.reuver.local [10.0.0.150])
	by mailhost.reuver.local (Postfix) with SMTP id 91F195087
	for <freebsd-questions@freebsd.org>;
	Sun, 28 Nov 2004 17:25:19 +0100 (CET)
From: "Marcel de Reuver" <marcel@de.reuver.org>
To: <freebsd-questions@freebsd.org>
Date: Sun, 28 Nov 2004 17:25:20 +0100
Message-ID: <FPEKLENMBNKLANOHPBCCIEOBDKAA.marcel@de.reuver.org>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0)
In-Reply-To: <56179.81.84.175.77.1101645978.squirrel@81.84.175.77>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Importance: Normal
X-Virus-Scanned: by amavisd-new at reuver.org
Subject: RE: Cyrus-SASL2-2.1.20 & MySQL crypt'ed passwords
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 28 Nov 2004 16:25:23 -0000

>
> Could anyone make this setup work? The patch for 2.1.19 applies cleanly to
> the ports tree and I can build sasl, but it ignores the settings on
> smtpd.conf (mainly password_format: crypt).
>
> I can auth @ SMTP using the encrypted password I find at the database, but
> no luck using the plaintext password (which cyrus-sasl should then crypt
> and check vs the database). -- Meaning the patch is having no effect, it
> is only checking the password feeded vs the database...
>
> Is there any way to have SMTP auth working with MySQL / crypt-stored
> passwords using postfix+cyrus-sasl2 ?
>


---- smtpd.conf --------------------
pwcheck_method: auxprop
mech_list: PLAIN LOGIN
auxprop_plugin: sql
srp_mda: md5
password_format: crypt
sql_engine: mysql
sql_hostnames: localhost
sql_database: postfix
sql_user: XXXXXXXXX
sql_passwd: XXXXXXXXX
sql_verbose: yes
sql_select: SELECT password FROM mailbox WHERE username = '%u@%r'
-------------------------------------