From: | news(dot)Andreas(at)gmx(dot)net (Andreas) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | problems using mod_auth_pgsql |
Date: | 2002-01-01 14:48:09 |
Message-ID: | 30cf5082.0201010648.426ffe0a@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | pierre | 2002-01-01 16:43:47 | posgres-7.1.3 hpux-11.00 posmaster died |
Previous Message | Shamik Majumder | 2002-01-01 11:51:12 | Need help |