Received: from fr.flashnet.it (root@dns.fr.flashnet.it [194.247.172.132]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA27025; Fri, 11 Jun 1999 05:55:02 -0400 (EDT) (envelope-from g.tanzilli@eurolink.it) Received: from eurolink.it (giuseppe.fr.flashnet.it [194.247.172.135]) by fr.flashnet.it (8.9.3/8.9.3) with ESMTP id LAA02299; Fri, 11 Jun 1999 11:52:58 +0200 Message-ID: <3760DC7D.34C6258F@eurolink.it> Date: Fri, 11 Jun 1999 11:53:02 +0200 From: Giuseppe Tanzilli X-Mailer: Mozilla 4.51 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: Fomichev Michael CC: pgsql-sql@postgreSQL.org, pgsql-admin@postgreSQL.org Subject: Re: [ADMIN] Apache authentication & PostgreSQL References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, try to use the apache/postgresql authentication module ftp://ftp.eurolink.it/pub/linux/postgreSQL bye 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. > > @------------------+-----------------------------------------------@ > | Fomichev Mikhail | The Government of Kamchatka region. | > | Vladimirovich | The Labour and Social Development Department. | > || | > @------------------+-----------------------------------------------@ -- ----------------------------------------------------------------- Giuseppe Tanzilli Flashnet S.p.A. Telecomunicazioni mailto: g.tanzilli@flashnet.it Sede di Frosinone Eurolink S.r.l. mailto: info.frosinone@flashnet.it Tel: +39-0775-830012 http://www.flashnet.it Fax: +39-0775-201321 EUnet Business Partner http://www.eurolink.it AIIP and ANFOV associated PGP Key: finger giuseppe@king.fr.flashnet.it -------------------------------------------------------------------