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