X-Original-To: pgsql-php@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9A0AB474E44 for ; Sat, 1 Mar 2003 05:16:41 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 70557-04 for ; Sat, 1 Mar 2003 05:16:37 -0500 (EST) Received: from mail4.wannafind.dk (mail4.wannafind.dk [80.196.101.186]) by postgresql.org (Postfix) with ESMTP id 176D1474E42 for ; Sat, 1 Mar 2003 05:16:37 -0500 (EST) Received: from [80.196.137.226] by mail4.wannafind.dk with SmartMax MailMax for pgsql-php@postgresql.org at Sat, 01 Mar 2003 11:16:38 +0100 Message-ID: <1046513798.6989@mail4.wannafind.dk> From: "Kelvin Varst" To: "Postgresql PHP" Subject: MD5 and passwords Date: Sat, 1 Mar 2003 11:17:18 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/1 X-Sequence-Number: 1913 Hi, I have build a website where users need to identity themselfs using basic auth. I have then installed auth_pgsql_mod on my Apache 2.0 server (Redhat 8.0), and that works fine. I would like to store the passwords in the database in MD5 encrypted form, and that works fine to, if I write the md5 encrypted string in the database manually. When I use the md5sum to translate plain text to md5 on the command line on my Linuxbox, and place that in the database, it works fine. Now I want users to be able to write plain written text on the webpage, and then the page translates that into a md5 string and from there store the md5 string in the database. But it is not the same encryption, I get two different encrypted strings if I use the md5() function. Why? Kelvin :-)