Skip site navigation (1) Skip section navigation (2)

Re: PGsql qustion

From: Matthew Horoschun <mhoroschun(at)canprint(dot)com(dot)au>
To: "Majid Khattak" <majid_khattak(at)hotmail(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: PGsql qustion
Date: 2003-04-28 06:13:06
Message-ID: 7A3BE197-7940-11D7-8354-000393B3A702@canprint.com.au (view raw or flat)
Thread:
Lists: pgsql-php
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.

pgsql-php by date

Next:From: Majid KhanDate: 2003-04-28 07:06:07
Subject: problem with md5
Previous:From: Martin MarquesDate: 2003-04-24 13:27:06
Subject: Re: [PHP] phpPgAdmin call for translators

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group