pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Daniel Struck <struck.d@retrovirology.lu>
From: (by way of Daniel Struck <struck.d@retrovirology.lu>
To: Bruno Wolff III <bruno@wolff.to>
Cc: Robert Treat <xzilla@users.sourceforge.net>
Cc: pgsql-php@postgresql.org
Subject: Re: client authentication towards postgresql in php?
Date: Wed, 12 Nov 2003 11:26:03 +0100
Message-ID: <20031112112603.1eb5d786.struck.d@retrovirology.lu> (raw)
In-Reply-To: <20031111184752.GA11772@wolff.to>
References: <20031109165228.45503144.struck.d@retrovirology.lu>
	<1068557456.10942.14684.camel@camel>
	<20031111145425.716dbf1a.struck.d@retrovirology.lu>
	<20031111184752.GA11772@wolff.to>

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't think I could use the ident method?


I have found this interesting info:

"The goal of the Negotiateauth project is to create an plugin for the Mozilla browser supporting the HTTP Negotiate authentication method. Main motivation is to add support for the Kerberos mechanism and use Kerberos tickets for user's authentication instead of their password. This way the user's Kerberos password will no longer be transfered to the web server. More information on the use of Negotiate method in Mozilla and Apache can be found at http://meta.cesnet.cz/software/heimdal/negotiate.en.html.";

So maybe I could authenticate every user at the client machines with kerberos, and pass the kerberos ticket with this method to apache, who will pass it to php, which does use it to connect to postgresql.

Would now be interesting to know if I can authenticate to a Kerberos server with a smartcard.


-- 
Retrovirology Laboratory Luxembourg
Centre Hospitalier de Luxembourg
4, rue E. Barblé
L-1210 Luxembourg

phone: +352-44116105
fax:   +352-44116113
web: http://www.retrovirology.lu
e-mail: struck.d@retrovirology.lu



view thread (9+ messages)  latest in thread

Message-ID: <20031112112603.1eb5d786.struck.d@retrovirology.lu>
Permalink:  ../20031112112603.1eb5d786.struck.d@retrovirology.lu/
Also on:    postgresql.org/message-id/20031112112603.1eb5d786.struck.d@retrovirology.lu

 · 

reply

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: struck.d@retrovirology.lu, bruno@wolff.to, xzilla@users.sourceforge.net
  Subject: Re: client authentication towards postgresql in php?
  In-Reply-To: <20031112112603.1eb5d786.struck.d@retrovirology.lu>
  References: <20031109165228.45503144.struck.d@retrovirology.lu> <1068557456.10942.14684.camel@camel> <20031111145425.716dbf1a.struck.d@retrovirology.lu> <20031111184752.GA11772@wolff.to> <20031112112603.1eb5d786.struck.d@retrovirology.lu>

* 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