Thread: BUG #1176: PHP connection

BUG #1176: PHP connection

From
"PostgreSQL Bugs List"
Date:
The following bug has been logged online:

Bug reference:      1176
Logged by:          thoyyib

Email address:      thoyyib@rediffmail.com

PostgreSQL version: 7.4

Operating system:   linux

Description:        PHP connection

Details:

The error report is :
FATEL: IDENT authentication failed for user "postgres"
I am a new user. pls help me....

Re: BUG #1176: PHP connection

From
Oliver Elphick
Date:
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@lfix.co.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

Re: BUG #1176: PHP connection

From
Richard Huxton
Date:
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 should update the access permissions in you pg_hba.conf file.
Details are in the manuals.

I recommend you subscribe to the novice mailing list (details at
http://www.postgresql.org/lists.html) - lots of good help there.

HTH
--
   Richard Huxton
   Archonet Ltd

Re: BUG #1176: PHP connection

From
Bruno Wolff III
Date:
On Tue, Jun 22, 2004 at 06:29:29 -0300,
  PostgreSQL Bugs List <pgsql-bugs@postgresql.org> wrote:
>
> The following bug has been logged online:

This isn't really a bug; you should have posted you question to pgsql-novice.
(Followups set to there and to you.)

>
> Bug reference:      1176
> Logged by:          thoyyib
>
> Email address:      thoyyib@rediffmail.com
>
> PostgreSQL version: 7.4
>
> Operating system:   linux
>
> Description:        PHP connection
>
> Details:
>
> The error report is :
> FATEL: IDENT authentication failed for user "postgres"
> I am a new user. pls help me....

The simplest solution is probably to su to root and then su to postgres
and then do whatever you were trying to do.

>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings