"William Harazim" <[EMAIL PROTECTED]> writes:
> Ahh, the password || username format of the stored password was the problem.
> Incidentally, for anyone else not having the md5() function (is that new to 7.5dev?)
> I was able to accomplish the same thing using
>'md5' || encode( digest(passwor
7;), 'hex' )
Thanks!
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 7:55 PM
To: William Harazim
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Manually authenticating users in pg_shadow
"William Harazim" <[EMAIL PROTECTED]> w
"William Harazim" <[EMAIL PROTECTED]> writes:
> Is there a way, having a user entered username and password, to select a si=
> ngle row from pg_shadow which is using md5 password encryption?
I think what you need to know is that the stored passwd field is formed
thus:
'md5' || md5(passwor
Is there a way, having a user entered username and password, to select a single row
from pg_shadow which is using md5 password encryption?
I'm currently authenticating web users (.asp page) with our own user table that uses
crypt() to store passwords. I'd like to remove our 'redundant' user tab
