From: Bruno Wolff III <bruno@wolff.to>
To: Daniel Struck <struck.d@retrovirology.lu>
Cc: Robert Treat <xzilla@users.sourceforge.net>
Cc: pgsql-php@postgresql.org
Subject: Re: client authentication towards postgresql in php?
Date: Tue, 11 Nov 2003 12:47:52 -0600
Message-ID: <20031111184752.GA11772@wolff.to> (raw)
In-Reply-To: <20031111145425.716dbf1a.struck.d@retrovirology.lu>
References: <20031109165228.45503144.struck.d@retrovirology.lu>
<1068557456.10942.14684.camel@camel>
<20031111145425.716dbf1a.struck.d@retrovirology.lu>
On Tue, Nov 11, 2003 at 14:54:25 +0100,
Daniel Struck <struck.d@retrovirology.lu> wrote:
>
> The problem is, I don't have a password available in php.
> The users are authenticated with x509 certificats and a private key, not a password. The private key is stored on a smartcard and never leaves it, the smartcard itself handles the authentication with apache.
>
> Problem now is, I want to authenticate the user with postgresql, to be able to log what the user is doing in postgresql itself.
> But I don't have a password to authenticate the user.
> Thought about using a Kerberos ticket in postgresql, but don't know how to setup this.
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.
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, struck.d@retrovirology.lu, xzilla@users.sourceforge.net
Subject: Re: client authentication towards postgresql in php?
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>
* 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