Re: Authentication Question - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Authentication Question
Date
Msg-id 20031028202939.GA14260@wolff.to
Whole thread Raw
In response to Authentication Question  ("Epps, Aaron M." <Epps.Aaron@mayo.edu>)
List pgsql-admin
On Tue, Oct 28, 2003 at 14:12:31 -0600,
  "Epps, Aaron M." <Epps.Aaron@mayo.edu> wrote:
>     I've got an authentication questions.  I've just setup pg_hba.conf to use "local    all    all    trust" for
testingpurposes, but when the application I'm using tries to connect to the PostgreSQL Db (Using PHP) I get the
followingerror. 
>
> " Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user
"webuser". in /var/www/html/issue-tracker/includes/classes/dbi.class.php on line 98 " 
>
> To me, it looks like PostgreSQL is still trying to authenticate, even though it should be trusting all local socket
connections. BTW, the web server and PostgreSQL server are on the same machine, so it's a local connection, not host.
DoI need to modify anything in pg_ident.conf?  I'd appreciate any help you can offer.  Thx. 

The authentication tests are done in order, with the first one that applies
being used. So if there is a rule for doing ident authentication for that
database and user before the trust rule, then the trust rule won't get used.

pgsql-admin by date:

Previous
From: Gaetano Mendola
Date:
Subject: transaction read only "per" user
Next
From: Tom Lane
Date:
Subject: Re: Authentication Question