X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EE5C1D1B591 for ; Thu, 29 Apr 2004 05:15:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38361-04 for ; Thu, 29 Apr 2004 05:15:32 -0300 (ADT) Received: from smtp-out1.xs4all.nl (smtp-out1.xs4all.nl [194.109.24.11]) by svr1.postgresql.org (Postfix) with ESMTP id A328DD1CA37 for ; Thu, 29 Apr 2004 05:15:29 -0300 (ADT) Received: from localhost.localdomain (kiar.xs4all.nl [80.126.234.5]) by smtp-out1.xs4all.nl (8.12.10/8.12.10) with ESMTP id i3T8FUhw073750 for ; Thu, 29 Apr 2004 10:15:30 +0200 (CEST) Received: by localhost.localdomain (Postfix, from userid 500) id 2BF51B6EC4; Thu, 29 Apr 2004 10:15:30 +0200 (CEST) Date: Thu, 29 Apr 2004 10:15:30 +0200 From: Joolz To: pgsql-php@postgresql.org Subject: Re: MD5 in pg and php Message-ID: <20040429081530.GA8282@localhost.localdomain> Reply-To: pgsql-php@postgresql.org Mail-Followup-To: pgsql-php@postgresql.org References: <20040429070716.GA6918@localhost.localdomain> <4090BD52.9060708@lewczuk.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4090BD52.9060708@lewczuk.com> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/51 X-Sequence-Number: 2708 > [Marek Lewczuk schreef op 29-04-2004 09:31 +0100] > > Joolz wrote: > >Hi, I'm completely new to hashing, so please bear with me. > > > >I want to store passwords in a pg db, MD5 seems like a good way to > >enhance security (no more plaintext passwords over the line etc.) I > >had a look at MD5, in PHP 4.3.4 there is a function md5() which seems > >to work nicely: > > > > echo md5('apple'); > > > >returns ae6d32585ecc4d33cb8cd68a047d8434 every time. Apart from the > >PHP frontend, I also want to be able to use the same algorithm in > >native pg. I found that postgresql-contrib-7.3.4 has a function > >crypt() which I expected to work the same. However: > > > > select crypt('apple', gen_salt('md5')); > > > >gives values different from the PHP md5() function, and moreover, > >they're different each time. Can anyone please tell me what I should > >do to get the same result in native pg as in PHP? > > > >Thanks! > > > > I whould suggest to update PG to version 7.4, where there is built-in > MD5 function. Thanks, I already found some fc1 rpm's (still in development). But can anyone tell me if the 7.4 internal md5() function will do the same as the PHP md5() function? Or do a quick select md5('apple') and let me know if the result is 'ae6d32585ecc4d33cb8cd68a047d8434'? I really wouldn't like to upgrade from my current stable situation, only to find out that it didn't solve my original problem. TIA! -- 10:14-10:15 Fedora Core release 1 (Yarrow) Linux 2.4.22-1.2188.nptl