From owner-freebsd-questions@FreeBSD.ORG Tue Apr 6 21:31:15 2004 Return-Path: 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 109E916A4CF for ; Tue, 6 Apr 2004 21:31:15 -0700 (PDT) Received: from relay01.roc.ny.frontiernet.net (relay01.roc.ny.frontiernet.net [66.133.131.34]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8523E43D2D for ; Tue, 6 Apr 2004 21:31:14 -0700 (PDT) (envelope-from drew@mykitchentable.net) Received: (qmail 26469 invoked from network); 7 Apr 2004 04:30:56 -0000 Received: from 67-51-124-168.dsl1.elk.ca.frontiernet.net (HELO blacklamb.mykitchentable.net) ([67.51.124.168]) (envelope-sender )SMTP for ; 7 Apr 2004 04:30:56 -0000 Received: from mykitchentable.net (bigdaddy.mykitchentable.net [192.168.1.3]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by blacklamb.mykitchentable.net (Postfix) with ESMTP id 8A2C13BF39C; Tue, 6 Apr 2004 21:30:55 -0700 (PDT) Message-ID: <407383F7.6080304@mykitchentable.net> Date: Tue, 06 Apr 2004 21:30:47 -0700 From: Drew Tomlinson User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Brent Wiese References: <20040407004028.LWYD4805.fed1rmmtao02.cox.net@SAMBA> In-Reply-To: <20040407004028.LWYD4805.fed1rmmtao02.cox.net@SAMBA> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 07 Apr 2004 04:31:15 -0000 Brent Wiese told a big fish story including the following on 04/06/2004 5:40 PM: >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. > > I wasn't using mysql but had similar problems setting up SASL with Postfix. After lots of searching, I finally found the answer and posted it to the list. You can find my post here: http://lists.freebsd.org/pipermail/freebsd-security/2003-July/000517.html Maybe this will help you as my errors were similar. Good Luck, Drew