[AuthPG] can not authenticate with mod_auth_pg
Brought to you by:
minskim
|
From: <new...@gm...> - 2002-01-02 12:55:11
|
Happy new year to everybody!
I want to set up a web server, which is connected to a database. The content
of the db should only be available for authorized users.
My configuration is:
Suse Linux 7.2
Apache 1.3.20
mod_auth_pg 1.3
PostgreSQL 7.1.3
I created the .htaccess file and made the corresponding adjustments in the
httpd.conf:
Content of .htaccess:
AuthName "Customer Support Database"
AuthType Basic
AuthPGHost localhost
AuthPGPort 5432
AuthPGUser postgres
AuthPGPassword postgres
AuthPGDatabase customers
AuthPGUserTable user_authentication
AuthPGUserNameField auth_user
AuthPGPasswordField auth_pwd
AuthPGQuery "select auth_pwd from user_authentication where auth_user =
'%s';"
<LIMIT GET POST>
require valid-user
</LIMIT>
Entry in httpd.conf:
<Directory /path_to_mydir>
AllowOverride AuthConfig
</Directory>
Everything works well without these modifications. But if I place the
.htaccess file into the directory of my web project I can find following entry in
Apaches error_log:
[Sat Dec 29 19:44:55 2001] [error] (2)No such file or directory: access to
/test/index.html filed for MY_IP, reason: user andreas: password mismatch
I can see the login window but I can't authenticate with the user
information stored in my database.
If I send the following sql query manually (psql) to PostgreSQL it responds
with the correct pwd:
select auth_pwd from user_authentication where auth_user='andreas';
(should be the same query like the one from mod_auth_pg)
It would be great if somebody could point me in the right direction.
Thank you in advance.
Andreas
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net
|