From owner-freebsd-questions@FreeBSD.ORG  Tue Apr  6 23:48:06 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 E87B016A4CE
	for <freebsd-questions@freebsd.org>;
	Tue,  6 Apr 2004 23:48:06 -0700 (PDT)
Received: from mail.elvandar.org (cust.94.120.adsl.cistron.nl [195.64.94.120])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 48CAD43D1D
	for <freebsd-questions@freebsd.org>;
	Tue,  6 Apr 2004 23:48:06 -0700 (PDT)
	(envelope-from remko@elvandar.org)
Message-ID: <4073A341.2040006@elvandar.org>
Date: Wed, 07 Apr 2004 08:44:17 +0200
From: Remko Lodder <remko@elvandar.org>
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Brent Wiese <brently@bjwcs.com>
References: <20040407004028.LWYD4805.fed1rmmtao02.cox.net@SAMBA>
In-Reply-To: <20040407004028.LWYD4805.fed1rmmtao02.cox.net@SAMBA>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at elvandar.org
cc: freebsd-questions@freebsd.org
Subject: Re: Postfix - Sasl - mysql
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: Wed, 07 Apr 2004 06:48:07 -0000

Brent Wiese wrote:
> I (tried) following the instructions at:
> http://high5.net/howto/
> 
> I have postfix virtual users working in MySQL. I have courier imap/pop3
> working w/ virtual users. I wanted to add SMTP auth.
> 
> I added the cyrus-sasl2 port (also chose support for it in postfix port)
> "WITH_MYSQL".
> 
> No go.
> 
> I added the following lines to /usr/local/lib/sasl2/smtpd.conf (found this
> in another faq/tutorial, so it may be incorrect)
> 
> sasl_pwcheck_method: auxprop
> sasl_auxprop_plugin: sql 
   sql_engine: mysql
   mech_list: login plain crammd6 digestmd5
> sql_user: postfix-user
> sql_passwd: thepassword
> sql_database: postfix
> sql_statement: SELECT password FROM mailbox WHERE username = '%u'
> sql_verbose: yes
> 

That works for me..
-- 

Kind regards,

Remko Lodder
Elvandar.org/DSINet.org
www.mostly-harmless.nl A Dutch community for helping newcomers on the 
hackerscene