Thread: Re: PGsql qustion

Re: PGsql qustion

From
Matthew Horoschun
Date:
Majid,

On Monday, April 28, 2003, at 03:52  PM, Majid Khattak wrote:
>
> user=test, password=test (which is md5 encrypted) .. I can connect
> thorough pgadminII with user test and password test.. I have enabled
> the password_encryption=true and reload the server but unable to
> connect through php. As I have compared the same md5 encrypted
> password in the php and in the pg_shadow file both the password are
> same but I don't why I cann't connect to the database.. It gives me
> this messaage.
>
> Password authentication failed for user "test". Please help me out.. 
> Thanks in Advance.

You need to do the md5 like this for it to work in the pg_shadow table:

$md5Password = 'md5' . md5( $cleartextPassword . $username );

Hope that helps.

Cheers

Matthew.