Re: [SQL] Apache authentication & PostgreSQL - Mailing list pgsql-sql

From Remigiusz Sokolowski
Subject Re: [SQL] Apache authentication & PostgreSQL
Date
Msg-id Pine.GS4.4.02A.9906110809450.26200-100000@netra.gdansk.sprint.pl
Whole thread Raw
In response to Apache authentication & PostgreSQL  (Fomichev Michael <fomichev@null.ru>)
List 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 phpRem

-------------------------------------------------------------------*------------
Remigiusz Sokolowski      e-mail: rems@gdansk.sprint.pl           * *        
-----------------------------------------------------------------*****----------



pgsql-sql by date:

Previous
From: Fomichev Michael
Date:
Subject: Apache authentication & PostgreSQL
Next
From: Volker Hess
Date:
Subject: RE: [SQL] Apache authentication & PostgreSQL