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.
