Re: Connect error - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Connect error
Date
Msg-id 20040112160453.GD21007@wolff.to
Whole thread Raw
In response to Re: Connect error  (Bill Moseley <moseley@hank.org>)
Responses Re: Connect error  (Bill Moseley <moseley@hank.org>)
Re: Connect error  (Russell Shaw <rjshaw@iprimus.com.au>)
List pgsql-novice
On Mon, Jan 12, 2004 at 07:42:41 -0800,
  Bill Moseley <moseley@hank.org> wrote:
>
> I don't know php, but is it (or Apache) running as user russell?  If
> not, then you can't authorize by IDENT.

It is possible to authenticate using ident using a map that says the
webserver account is allowed to use the db account "russell". The web server
must either be on the same machine uisng domain sockets for connecting
(which looks to be the case here) or be running an ident server.

If you do this you are implicitly trusting the web server account, which
might not be a good idea in some circumstances. You might want to create
a separate db account for the web server with miminal privileges needed
for its task.


pgsql-novice by date:

Previous
From: Bill Moseley
Date:
Subject: Re: Connect error
Next
From: Sai Hertz And Control Systems
Date:
Subject: Re: Connect error