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.
pgsql-php by date
|Next:||From: Majid Khan||Date: 2003-04-28 07:06:07|
|Subject: problem with md5|
|Previous:||From: Martin Marques||Date: 2003-04-24 13:27:06|
|Subject: Re: [PHP] phpPgAdmin call for translators|