Re: ident client authentication

From: Richard Huxton <dev(at)archonet(dot)com>
To: Paul Hide <paul(dot)hide(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ident client authentication
Date: 2005-11-08 11:08:52
Message-ID: 43708744.6090103@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Paul Hide 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.

> 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?
> How can I make ident authentication work?

At a guess, your Python script is running as the same user as your
webserver (usually apache/www-data/nobody or similar). This is why the
"ident sameuser" isn't working.

You'll either need to log in as the webserver user, or use password
authentication.

> Any help would be appreciated, including where this message should be posted
> if this list is inappropriate.

This list is fine.

HTH

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Evandro's mailing lists (Please, don't send personal messages to this address) 2005-11-08 11:58:27 Beyond the 1600 columns limit on windows
Previous Message Michael Glaesemann 2005-11-08 10:15:50 Re: Aggregates, group, and order by