Re: [SQL] Apache authentication & PostgreSQL

Поиск
Список
Период
Сортировка
От Remigiusz Sokolowski
Тема Re: [SQL] Apache authentication & PostgreSQL
Дата
Msg-id Pine.GS4.4.02A.9906110809450.26200-100000@netra.gdansk.sprint.pl
обсуждение исходный текст
Ответ на Apache authentication & PostgreSQL  (Fomichev Michael <fomichev@null.ru>)
Список 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 по дате отправления:

Предыдущее
От: Fomichev Michael
Дата:
Сообщение: Apache authentication & PostgreSQL
Следующее
От: Volker Hess
Дата:
Сообщение: RE: [SQL] Apache authentication & PostgreSQL