Re: [SQL] Apache authentication & PostgreSQL

From: Remigiusz Sokolowski <rems(at)gdansk(dot)sprint(dot)pl>
To: Fomichev Michael <fomichev(at)null(dot)ru>
Cc: pgsql-sql(at)postgreSQL(dot)org, pgsql-admin(at)postgreSQL(dot)org
Subject: Re: [SQL] Apache authentication & PostgreSQL
Date: 1999-06-11 06:13:29
Message-ID: Pine.GS4.4.02A.9906110809450.26200-100000@netra.gdansk.sprint.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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.

I'm not a good guy at programming, so my advice is rather simple
-try do it using php (You need compile it as Apache module with Postgres
support) - there is then very nice way to get user password and login.
If You do it this way I can give You some tips or examples of code in php
Rem

-------------------------------------------------------------------*------------
Remigiusz Sokolowski e-mail: rems(at)gdansk(dot)sprint(dot)pl * *
-----------------------------------------------------------------*****----------

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Volker Hess 1999-06-11 07:32:07 RE: [SQL] Apache authentication & PostgreSQL
Previous Message Fomichev Michael 1999-06-11 04:02:35 Apache authentication & PostgreSQL