Re: ident client authentication

From: Bruno Wolff III <bruno(at)wolff(dot)to>
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 17:35:26
Message-ID: 20051108173526.GA6385@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Nov 08, 2005 at 17:18:32 +0000,
Paul Hide <paul(dot)hide(at)gmail(dot)com> wrote:
> Many thanks for your reply.
>
> The web server runs as what/whoever it does by default. I haven't changed
> it.
>
> I understand what you are getting at, because Richard Huxton pointed out to
> me that the script is probably running as the web server user.
>
> The script runs as 'apache' (let us say), the connect in the python program
> is by 'jim'. Then what does sameuser mean in the hba file.

That is a special mapping that says that ident should return the same string
as is used for the postgres username. Based on your description above, they
aren't going to match.

However, you can create custom ident maps that allow either apache or jim to
connect as postgres user jim.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-11-08 17:40:14 Re: Beyond the 1600 columns limit on windows
Previous Message Will Wright 2005-11-08 17:29:30 Re: Programmatic method to determine currently installed Windows PostrgreSQL version