From owner-freebsd-questions@FreeBSD.ORG  Tue Apr  6 17:42: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 4635D16A4CF
	for <freebsd-questions@freebsd.org>;
	Tue,  6 Apr 2004 17:42:23 -0700 (PDT)
Received: from fed1rmmtao02.cox.net (fed1rmmtao02.cox.net [68.230.241.37])
	by mx1.FreeBSD.org (Postfix) with ESMTP id A318643D3F
	for <freebsd-questions@freebsd.org>;
	Tue,  6 Apr 2004 17:42:22 -0700 (PDT)
	(envelope-from brently@bjwcs.com)
Received: from SAMBA ([68.231.19.60]) by fed1rmmtao02.cox.net
          (InterMail vM.6.01.03.01 201-2131-111-101-20040311) with ESMTP
          id <20040407004028.LWYD4805.fed1rmmtao02.cox.net@SAMBA>
          for <freebsd-questions@freebsd.org>;
          Tue, 6 Apr 2004 20:40:28 -0400
From: "Brent Wiese" <brently@bjwcs.com>
To: <freebsd-questions@freebsd.org>
Date: Tue, 6 Apr 2004 17:40:20 -0700
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Thread-Index: AcQcOLSKUx2VXa/HSO6VCcdyIF0K0g==
Message-Id: <20040407004028.LWYD4805.fed1rmmtao02.cox.net@SAMBA>
Subject: 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 00:42:23 -0000

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: mysql login plain crammd6 digestmd5
mysql_user: postfix-user
mysql_passwd: thepassword
mysql_database: postfix
mysql_statement: SELECT password FROM mailbox WHERE username = '%u'
mysql_verbose: yes

(I also tried "sasl_" in front of all the lines).

When I try to use SMTP Auth from Outlook Express, I get this in the logs:

Apr  6 20:35:01 server01 postfix/smtpd[22279]: warning: SASL authentication
failure: no user in db
Apr  6 20:35:01 server01 postfix/smtpd[22279]: warning: SASL authentication
failure: no secret in database
Apr  6 20:35:01 server01 postfix/smtpd[22279]: warning:
swing.bjwcs.com[208.185.25.11]: SASL NTLM authentication failed

I'm using cyrus-sasl-2.1.18 and postfix 2.0.19.

I also tried compiling w/ the patch listed in that tutorial link above, but
it breaks. I read somewhere that mysql stuff changed in cyrus-sasl-2.1.17.

Any help? I think I'm really close... I'm just so frustrated at this point,
I'm probably no longer thinking clearly.

Thanks!
Brent