Thread: BUG #1176: PHP connection
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....
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
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
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