From owner-freebsd-questions@FreeBSD.ORG  Sun Nov 28 22:42:00 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 E155D16A4CE
	for <freebsd-questions@freebsd.org>;
	Sun, 28 Nov 2004 22:42:00 +0000 (GMT)
Received: from mail.revolutionsp.com (ganymede.revolutionsp.com [64.246.0.2])
	by mx1.FreeBSD.org (Postfix) with ESMTP id AADCA43D39
	for <freebsd-questions@freebsd.org>;
	Sun, 28 Nov 2004 22:42:00 +0000 (GMT)
	(envelope-from klr@6s-gaming.com)
Received: from mail.revolutionsp.com (localhost [127.0.0.1])
	by mail.revolutionsp.com (Postfix) with ESMTP id B3AF915D20
	for <freebsd-questions@freebsd.org>;
	Sun, 28 Nov 2004 13:37:39 -0600 (CST)
Received: from 81.84.175.77
        (SquirrelMail authenticated user klr@6s-gaming.com);
        by mail.revolutionsp.com with HTTP;
        Sun, 28 Nov 2004 13:37:39 -0600 (CST)
Message-ID: <56723.81.84.175.77.1101670659.squirrel@81.84.175.77>
In-Reply-To: <NFBBLGFLILLAIOCNOBICKEBNENAA.marcel@de.reuver.org>
References: <56240.81.84.175.77.1101652480.squirrel@81.84.175.77>
    <NFBBLGFLILLAIOCNOBICKEBNENAA.marcel@de.reuver.org>
Date: Sun, 28 Nov 2004 13:37:39 -0600 (CST)
From: klr@6s-gaming.com
To: freebsd-questions@freebsd.org
User-Agent: SquirrelMail/1.4.3a
X-Mailer: SquirrelMail/1.4.3a
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
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 22:42:01 -0000

It is accessing the database properly.

SASL isn't even trying to check vs an encrypted password, if I feed it (at
the SMTP auth) with the encrypted password I find at the database, it will
accept it (like if it was a plaintext-password)


>>
>> That is exactly my smtpd.conf , I don't understand why it doesn't work
>> :/
>>
>> The password_format directive was incorporated on 2.1.20 ?
>>
>>
>>
>> > ---- 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'
>> > -------------------------------------
>>
>
> In this setup Sasl expects the passwords MD5 encrypted, not standaard UNIX
> crypt. Restart MySQL with the parameter --log and see what activity is
> logged.
>
>