problems using mod_auth_pgsql
От | news.Andreas@gmx.net (Andreas) |
---|---|
Тема | problems using mod_auth_pgsql |
Дата | |
Msg-id | 30cf5082.0201010648.426ffe0a@posting.google.com обсуждение исходный текст |
Список | pgsql-general |
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_pgsql 0.9.11 PostgreSQL 7.1.3 I created the .htaccess file and made the corresponding adjustments in the httpd.conf: Content of .htaccess: AuthName "PostgreSQL Authenticator" AuthType basic Auth_PG_host localhost Auth_PG_port 5432 Auth_PG_user postgres Auth_PG_database authdb Auth_PG_pwd_table user_authentication Auth_PG_uid_field auth_user Auth_PG_pwd_field auth_pwd <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: PG user andreas: password mismatch I can see the login window but I can’t authorize with the user information stored in my database. If I send the following sql query manually 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_pgsql) It would be great if somebody could point me in the right direction. Does anyone use the authentication with mod_auth_pgsql successfully? Thank you in advance. Salut! Andreas
В списке pgsql-general по дате отправления: