problems using mod_auth_pgsql

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&#8217;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

Browse pgsql-general by date

  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