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 51C54D1B535 for ; Thu, 13 Nov 2003 13:36:28 +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 30376-07 for ; Thu, 13 Nov 2003 09:35:59 -0400 (AST) Received: from arktis.luxadmin.org (arktis.luxadmin.org [195.206.105.1]) by svr1.postgresql.org (Postfix) with ESMTP id F2351D1B522 for ; Thu, 13 Nov 2003 09:35:55 -0400 (AST) Received: from samara.atlantis.local (luxadmin.org [195.206.105.1]) by arktis.luxadmin.org (Postfix) with SMTP id 01656160634; Thu, 13 Nov 2003 14:35:58 +0100 (CET) Date: Wed, 12 Nov 2003 11:26:03 +0100 From: Daniel Struck (by way of Daniel Struck ) To: Bruno Wolff III Cc: Robert Treat , pgsql-php@postgresql.org Message-Id: <20031112112603.1eb5d786.struck.d@retrovirology.lu> 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> 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 Resent-Date: Thu, 13 Nov 2003 14:35:45 +0100 Resent-From: Daniel Struck Subject: Re: client authentication towards postgresql in php? Resent-Message-Id: <20031113143545.2fd5bc53.struck.d@retrovirology.lu> Resent-To: Bruno Wolff III , Robert Treat , pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/39 X-Sequence-Number: 2432 On Tue, 11 Nov 2003 12:47:52 -0600 Bruno Wolff III 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 nor= mally 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 Mozil= la browser supporting the HTTP Negotiate authentication method. Main motiva= tion 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 Ke= rberos password will no longer be transfered to the web server. More inform= ation 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 kerber= os, 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. --=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