Re: ident client authentication

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.

Paul Hide
On 11/8/05, Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
>
> On Tue, Nov 08, 2005 at 10:02:14 +0000,
> Paul Hide <paul(dot)hide(at)gmail(dot)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
>