Re: ident client authentication - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: ident client authentication
Date
Msg-id 20051108132115.GA1646@wolff.to
Whole thread Raw
In response to ident client authentication  (Paul Hide <paul.hide@gmail.com>)
Responses Re: ident client authentication
List pgsql-general
On Tue, Nov 08, 2005 at 10:02:14 +0000,
  Paul Hide <paul.hide@gmail.com> wrote:
> I have a problem with ident client authentication.
> My server is debian sarge, pg version is 7.4.7, apache 2.0.54, mod_python
> 2.3. A python script is placed on the server and runs under mod_python in
> apache.
>
> I make a request from firefox on a win 2k box to this server.
> If I have
> local all jim trust
> in my pg_hba.conf file, all is well, my python script runs and delivers the
> expected output.
>
> However, if i have
> local all jim ident sameuser
> I get FATAL: IDENT authentication failed for user jim, via mod-python debug
> and in postgres log.
>
> jim is both a unix user (linux) and a postgres user.
>
> Is this what would be expected?

Does the web server run as user jim? That seems unusual. You may need to set
up an ident map that allows user 'apache' (or whatever applies on your machine)
to connect as postgres user 'jim'.

> How can I make ident authentication work?
>
> Any help would be appreciated, including where this message should be posted
> if this list is inappropriate.
>
> Paul Hide

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: Perl::DBI and interval syntax
Next
From: Michael Glaesemann
Date:
Subject: Re: database export problem