Return-Path: Delivered-To: apmail-apr-dev-archive@www.apache.org Received: (qmail 10762 invoked from network); 7 May 2006 08:07:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 7 May 2006 08:07:00 -0000 Received: (qmail 84302 invoked by uid 500); 7 May 2006 08:06:59 -0000 Delivered-To: apmail-apr-dev-archive@apr.apache.org Received: (qmail 84249 invoked by uid 500); 7 May 2006 08:06:58 -0000 Mailing-List: contact dev-help@apr.apache.org; run by ezmlm Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Id: Delivered-To: mailing list dev@apr.apache.org Received: (qmail 84238 invoked by uid 99); 7 May 2006 08:06:58 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 07 May 2006 01:06:58 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of lists@nabble.com designates 72.21.53.35 as permitted sender) Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 07 May 2006 01:06:57 -0700 Received: from localhost ([127.0.0.1] helo=talk.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1FceHj-00041O-SG for dev@apr.apache.org; Sun, 07 May 2006 01:06:36 -0700 Message-ID: <4267381.post@talk.nabble.com> Date: Sun, 7 May 2006 01:06:35 -0700 (PDT) From: koszi To: dev@apr.apache.org Subject: Re: apr_dbd_mysql.c In-Reply-To: <4259375.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-Sender: koszi@mail.tvnet.hu X-Nabble-From: koszi References: <001101c65ffb$0aead530$6500a8c0@escoffice.com> <7edfeeef0604171137w375fc189i665c0d77f4cd07e0@mail.gmail.com> <4172297.post@talk.nabble.com> <4199439.post@talk.nabble.com> <4211898.post@talk.nabble.com> <1146686523.2011.115.camel@coyote.rexursive.com> <4224583.post@talk.nabble.com> <4238357.post@talk.nabble.com> <20060505090349.j94edfrz5kwwwo08@www.rexursive.com> <200605050049.01436.nick@webthing.com> <4248235.post@talk.nabble.com> <4258485.post@talk.nabble.com> <4259375.post@talk.nabble.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N OK just for the record for people googling around for this stuff mod_authn_dbd apr_dbd_mysql apache 2.2.0 MySQL 5.0.20 apr 1.2.7 apr-util 1.2.7 Mysql's encrypt does the. trick. It's either 1. you use "select encrypt(passwordfield) from..." in AuthDBDUserPWQuery directive, if you store passwords in plain text (perhaps not a good idea) 2 or use "select password from ...'" , in that case you need to store passwords in encrypted format like 'insert into usertable encrypt('secret')',..." BR Peter. -- View this message in context: http://www.nabble.com/apr_dbd_mysql.c-t1451411.html#a4267381 Sent from the APR Dev (Apache Portable Runtime) forum at Nabble.com.