From owner-freebsd-questions@FreeBSD.ORG Sun Nov 28 17:38:48 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 6102416A4CE for ; Sun, 28 Nov 2004 17:38:48 +0000 (GMT) Received: from mail.revolutionsp.com (ganymede.revolutionsp.com [64.246.0.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1D94243D1D for ; Sun, 28 Nov 2004 17:38:48 +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 E7CEC15D43 for ; Sun, 28 Nov 2004 08:34:40 -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 08:34:40 -0600 (CST) Message-ID: <56240.81.84.175.77.1101652480.squirrel@81.84.175.77> In-Reply-To: References: <56179.81.84.175.77.1101645978.squirrel@81.84.175.77> Date: Sun, 28 Nov 2004 08:34:40 -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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 28 Nov 2004 17:38:48 -0000 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 ? >> >> Could anyone make this setup work? The patch for 2.1.19 applies cleanly >> to >> the ports tree and I can build sasl, but it ignores the settings on >> smtpd.conf (mainly password_format: crypt). >> >> I can auth @ SMTP using the encrypted password I find at the database, >> but >> no luck using the plaintext password (which cyrus-sasl should then crypt >> and check vs the database). -- Meaning the patch is having no effect, it >> is only checking the password feeded vs the database... >> >> Is there any way to have SMTP auth working with MySQL / crypt-stored >> passwords using postfix+cyrus-sasl2 ? >> > > > ---- 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' > ------------------------------------- > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" >