Re: BUG #1176: PHP connection

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: thoyyib <thoyyib(at)rediffmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1176: PHP connection
Date: 2004-06-22 11:37:18
Message-ID: 1087904238.25635.638.camel@linda
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-novice

On Tue, 2004-06-22 at 10:29, PostgreSQL Bugs List wrote:
...
> Description: PHP connection
>
> Details:
>
> The error report is :
> FATEL: IDENT authentication failed for user "postgres"
> I am a new user. pls help me....

You must ensure that the authentication options are set correctly in
$PGDATA/pg_hba.conf. This file is described in chapter 19 of the manual
(Client Authentication).

Presumably PHP is running from a webserver. In that case, you cannot
use "ident sameuser" authentication to give access to any user but the
one under whose identity the webserver itself is running. If you want
to have different users connecting through the webserver, you will have
to use some kind of password authentication instead.

--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"Therefore being justified by faith, we have peace with
God through our Lord Jesus Christ." Romans 5:1

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Huxton 2004-06-22 12:10:25 Re: BUG #1176: PHP connection
Previous Message PostgreSQL Bugs List 2004-06-22 09:29:29 BUG #1176: PHP connection

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Huxton 2004-06-22 12:10:25 Re: BUG #1176: PHP connection
Previous Message PostgreSQL Bugs List 2004-06-22 09:29:29 BUG #1176: PHP connection