From: Bruno Wolff III <bruno@wolff.to>
To: scott.marlowe <scott.marlowe@ihs.com>
Cc: dash@melchior.rogue-penguin.com
Cc: pgsql-php@postgresql.org
Subject: Re: Authentication Failure with pg_pconnect
Date: Tue, 19 Aug 2003 11:03:42 -0500
Message-ID: <20030819160342.GE18374@wolff.to> (raw)
In-Reply-To: <Pine.LNX.4.33.0308190944370.9190-100000@css120.ihs.com>
References: <34595.24.169.200.199.1061227831.squirrel@rogue-penguin.com>
<Pine.LNX.4.33.0308190944370.9190-100000@css120.ihs.com>
On Tue, Aug 19, 2003 at 09:50:33 -0600,
"scott.marlowe" <scott.marlowe@ihs.com> wrote:
>
> Note that the username of the client (in this case, likely either httpd or
> nobody) is what postgresql inspects. your connection string doesn't
> matter since postgresql is now looking for a user account by the name of
> whatever user your web server runs under.
This isn't exactly true. The id given in the connection string is
the one that is to be used for the postgres connection. The username of
the client is checked to see if it is an allowed system user for the
postgres user. It is common to force them to match, but other options
are possible.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: bruno@wolff.to, scott.marlowe@ihs.com, dash@melchior.rogue-penguin.com
Subject: Re: Authentication Failure with pg_pconnect
In-Reply-To: <20030819160342.GE18374@wolff.to>
References: <34595.24.169.200.199.1061227831.squirrel@rogue-penguin.com> <Pine.LNX.4.33.0308190944370.9190-100000@css120.ihs.com> <20030819160342.GE18374@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox