Re: [SQL] Apache authentication & PostgreSQL

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