From owner-freebsd-questions@FreeBSD.ORG  Wed Apr  7 19:15:17 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 27FD016A4CF
	for <freebsd-questions@freebsd.org>;
	Wed,  7 Apr 2004 19:15:17 -0700 (PDT)
Received: from fed1rmmtao02.cox.net (fed1rmmtao02.cox.net [68.230.241.37])
	by mx1.FreeBSD.org (Postfix) with ESMTP id A783143D41
	for <freebsd-questions@freebsd.org>;
	Wed,  7 Apr 2004 19:15:16 -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 <20040408021515.FAYE8783.fed1rmmtao02.cox.net@SAMBA>
          for <freebsd-questions@freebsd.org>;
          Wed, 7 Apr 2004 22:15:15 -0400
From: "Brent Wiese" <brently@bjwcs.com>
To: <freebsd-questions@freebsd.org>
Date: Wed, 7 Apr 2004 19:15:04 -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
Thread-Index: AcQc3GjPKzDKmSfQThmSpoRFrtOCvwAMVVSg
In-Reply-To: <2278.206.114.147.90.1081368855.squirrel@mail.alpete.com>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-Id: <20040408021515.FAYE8783.fed1rmmtao02.cox.net@SAMBA>
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: Thu, 08 Apr 2004 02:15:17 -0000

> I used those instructions, although I modified some for my specific
> configuration.  the "username" field in my database is
> "user@virtualdomain.com" however. 

Yes, that is how mine is.

> I had to create a 
> plain-text password

This is what I want to avoid. I think this is what the patch listed on the
howto.net page is supposed to fix, but it doesn't apply right for me.

> Here's my working smtpd.conf:
> 
> # smtpd.conf
> pwcheck_method: auxprop
> auxprop_plugin: sql
> mech_list: plain login
> 
> sql_engine: mysql
> sql_hostnames: localhost
> sql_user: postfix-user
> sql_passwd: thepassword
> sql_database: postfix
> sql_select: select pass_plain from mailbox where username='%u@%r'

Once I cleaned up my syntax (per another post, thanks!) while comparing to
this, I'm now able to check the DB correctly (I turned on MySQL logging to
make sure), except for the whole encrypted vs plaintext thing.

If I use PAM, is that going to break courier-IMAP?

Anyone succesfully patched a recent ( => .17) cyrus-sasl2 to use encrypted
passwords in MySQL?

Thanks for all the help, I think I'm nearly there. :)

Brent