X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 29122D1B515 for ; Tue, 11 Nov 2003 13:55:23 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 40133-07 for ; Tue, 11 Nov 2003 09:54:55 -0400 (AST) Received: from neuron.admin.healthnet.lu (drill.healthnet.lu [158.64.36.2]) by svr1.postgresql.org (Postfix) with ESMTP id B4B0CD1B508 for ; Tue, 11 Nov 2003 09:54:50 -0400 (AST) Received: from control.dmz.chl.lu ([10.11.1.10]) by neuron.admin.healthnet.lu (8.9.3/8.8.8) with SMTP id OAA22672; Tue, 11 Nov 2003 14:54:39 +0100 (MET) Received: from 172.20.1.146 by control.dmz.chl.lu (InterScan E-Mail VirusWall NT); Tue, 11 Nov 2003 14:50:45 +0100 Received: from samara.atlantis.local by woodstock.inf.chl.lu (8.8.8/1.1.22.3/16Mar00-0417PM) id OAA0000029618; Tue, 11 Nov 2003 14:54:38 +0100 (MET) Date: Tue, 11 Nov 2003 14:54:25 +0100 From: Daniel Struck To: Robert Treat Cc: pgsql-php@postgresql.org Subject: Re: client authentication towards postgresql in php? Message-Id: <20031111145425.716dbf1a.struck.d@retrovirology.lu> In-Reply-To: <1068557456.10942.14684.camel@camel> References: <20031109165228.45503144.struck.d@retrovirology.lu> <1068557456.10942.14684.camel@camel> X-Mailer: Sylpheed version 0.9.6claws (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/32 X-Sequence-Number: 2425 > If your actually creating a user inside the database for each user, > authentication is handled inside the database and passwords are held > inside the database. When your php login script fires off, save the > user name/ password into a session and then use that info to build your > pg_connect strings.=20 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. Daniel --=20 Retrovirology Laboratory Luxembourg Centre Hospitalier de Luxembourg 4, rue E. Barbl=E9 L-1210 Luxembourg phone: +352-44116105 fax: +352-44116113 web: http://www.retrovirology.lu e-mail: struck.d@retrovirology.lu