From owner-freebsd-questions@FreeBSD.ORG  Tue Mar  9 13:55:03 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 0359616A4CE
	for <questions@freebsd.org>; Tue,  9 Mar 2004 13:55:03 -0800 (PST)
Received: from spock.ste-land.com (spock.ste-land.com [64.32.179.40])
	by mx1.FreeBSD.org (Postfix) with ESMTP id D21B543D2D
	for <questions@freebsd.org>; Tue,  9 Mar 2004 13:55:02 -0800 (PST)
	(envelope-from ste@ste-land.com)
Received: from ste-land.com (bgp377940bgs.plnfld01.nj.comcast.net
	[68.36.5.198])
	by spock.ste-land.com (Postfix) with ESMTP id 1C9672D24C
	for <questions@freebsd.org>; Tue,  9 Mar 2004 16:55:02 -0500 (EST)
Message-ID: <404E3D35.1090303@ste-land.com>
Date: Tue, 09 Mar 2004 16:55:01 -0500
From: "Shaun T. Erickson" <ste@ste-land.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.4b) Gecko/20030507
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: questions@freebsd.org
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Subject: pam question
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: Tue, 09 Mar 2004 21:55:03 -0000

I have pam configured so that when my virtual email users (well, the 
*users* aren't virtual, hehe) send email, they have to use smtpauth. I 
created a file in /etc/pam.d, called smtp. It has in it:

auth required pam_mysql.so user=postfix passwd=apassword host=localhost 
db=postfix table=mailbox usercolumn=username passwdcolumn=password 
crypt=1 sqllog=0
account sufficient pam_mysql.so user=postfix passwd=apassword 
host=localhost db=postfix table=mailbox usercolumn=username 
passwdcolumn=password crypt=1 sqllog=0

Everything works fine ... almost.

Remote users, in the system's local domain, also have to auth in order 
to relay. But their password is being looked up in my mysql database, 
instead of in the password file.

How can I modify pam's smtp file to allow for both conditions?

	-ste