Received: from serv1.avmz.uni-siegen.de (root@serv1.avmz.uni-siegen.de [141.99.3.1]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA04504; Fri, 11 Jun 1999 03:32:33 -0400 (EDT) (envelope-from Volker.Hess@avmz.uni-siegen.de) Received: from perseus.avmz.uni-siegen.de (volker@perseus.avmz.uni-siegen.de [141.99.3.14]) by serv1.avmz.uni-siegen.de (Mailhost) with ESMTP id JAA15018; Fri, 11 Jun 1999 09:32:06 +0200 Message-ID: X-Mailer: XFMail 1.3 [p0] on Linux X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: Date: Fri, 11 Jun 1999 09:32:07 +0200 (MEST) Organization: Uni-GH Siegen. Medienzentrum Sender: volker@avmz.uni-siegen.de From: Volker Hess To: Fomichev Michael Subject: RE: [SQL] Apache authentication & PostgreSQL Cc: pgsql-admin@postgreSQL.org, pgsql-sql@postgreSQL.org On 11-Jun-99 Fomichev Michael wrote: > Hi, all ! > I'm trying to show data from the PostgreSQL database to the Web page, > using WWW-SQL. I want the users to get an access to the database from the > browsers under their own names. To achieve this I configured Apache so > that it would authenticate an user when the user enters the directory with > CGI-scripts. I'd like that the name and the password of the user having > been authenticated, will be used in CGI-script for the access to the > database. > I can get the user's name via environment variable $REMOTE_USER, wich is > set by Apache. > > Now the question: is it possible to get the password, which the user has > entered by the authentication ? > > I know one solution. But it requires hacking of Apache. > > Thanks for any suggestions. > Perhaps try to use mod_perl with Apache::AuthenDBI and Apache::Authz ?! Ciao... -- E-Mail: Volker Hess Uni-GH Siegen . Medienzentrum 57068 Siegen MZ: http://www.avmz.uni-siegen.de/ - SINFO: http:/www.uni-siegen.de/ MEDIAS: http://medias.avmz.uni-siegen.de/ - UNI-MEDIA: http://www.uni-media.de/