Re: client authentication towards postgresql in php? - Mailing list pgsql-php

From Bruno Wolff III
Subject Re: client authentication towards postgresql in php?
Date
Msg-id 20031113221351.GA23638@wolff.to
Whole thread Raw
In response to Re: client authentication towards postgresql in php?  (Daniel Struck <struck.d@retrovirology.lu>(by way of Daniel Struck <struck.d@retrovirology.lu>))
List pgsql-php
On Wed, Nov 12, 2003 at 11:26:03 +0100,
  Daniel Struck <struck.d@retrovirology.lu> wrote:
> On Tue, 11 Nov 2003 12:47:52 -0600
> Bruno Wolff III <bruno@wolff.to> wrote:
>
> > If you trust the host the php/web server runs on you may be able to use
> > trust authentication. If you don't trust all of the users on that host
> > then you can use ident authentication, though if the db server and php/web
> > server aren't the same host using identd may slow things down too much.
>
> The web application, which will make the connection to the database, is normally running under the user apache, so I
don'tthink I could use the ident method? 

Sure you can. If you trust the apache user, you can use ident authentication
to allow it to connect as any of the valid users. It may be in your case
that you can't trust the apache user, but we don't know enough about your
setup to be able to tell that.

pgsql-php by date:

Previous
From: Daniel Struck (by way of Daniel Struck
Date:
Subject: Re: client authentication towards postgresql in php?
Next
From: Noel
Date:
Subject: Cancel a query when user leaves a web page