From: Joolz <joolz@xs4all.nl>
To: list-postgresql-php <pgsql-php@postgresql.org>
Subject: MD5 in pg and php
Date: Thu, 29 Apr 2004 09:07:16 +0200
Message-ID: <20040429070716.GA6918@localhost.localdomain> (raw)
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!
--
08:59-09:07
Fedora Core release 1 (Yarrow) Linux 2.4.22-1.2188.nptl
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: joolz@xs4all.nl
Subject: Re: MD5 in pg and php
In-Reply-To: <20040429070716.GA6918@localhost.localdomain>
References: <20040429070716.GA6918@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox