Re: [ADMIN] Apache authentication & PostgreSQL

From: Giuseppe Tanzilli <g(dot)tanzilli(at)eurolink(dot)it>
To: Fomichev Michael <fomichev(at)null(dot)ru>
Cc: pgsql-sql(at)postgreSQL(dot)org, pgsql-admin(at)postgreSQL(dot)org
Subject: Re: [ADMIN] Apache authentication & PostgreSQL
Date: 1999-06-11 09:53:02
Message-ID: 3760DC7D.34C6258F@eurolink.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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. |
> |<fomichev(at)null(dot)ru>| |
> @------------------+-----------------------------------------------@

--
-----------------------------------------------------------------
Giuseppe Tanzilli Flashnet S.p.A. Telecomunicazioni
mailto: g(dot)tanzilli(at)flashnet(dot)it Sede di Frosinone
Eurolink S.r.l. mailto: info(dot)frosinone(at)flashnet(dot)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(at)king(dot)fr(dot)flashnet(dot)it
-------------------------------------------------------------------

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 1999-06-11 09:58:16 Re: [ADMIN] Apache authentication & PostgreSQL
Previous Message Volker Hess 1999-06-11 07:32:07 RE: [SQL] Apache authentication & PostgreSQL