Hey,
I've set up mod_auth_pgsql several times successfully, but for some reason I
keep getting a "password mismatch" error on my latest install when I try to
log in to my protected site.
I'm running postgresql 7.2.2, apache 1.3.26 on FreeBSD 4.6.2. The version of
mod_auth_pgsql I built into apache is 0.9.12.
This is what my schema and current data look like:
CREATE TABLE users (
username CHAR(25) PRIMARY KEY,
password CHAR(25) NOT NULL
);
INSERT INTO users (username, password) VALUES ('ssmith', 'abc');
Here is what the my .htaccess file looks like:
AuthName "test"
AuthType basic
Auth_PG_host localhost
Auth_PG_port 5432
Auth_PG_database apache
Auth_PG_user <????>
Auth_PG_pwd <????>
Auth_PG_pwd_table users
Auth_PG_uid_field username
Auth_PG_pwd_field password
Auth_PG_encrypted off
Auth_PG_log_table apache_log
Auth_PG_log_uname_field username
Auth_PG_log_date_field time
Auth_PG_log_uri_field uri
Auth_PG_log_addrs_field address
Auth_PG_log_pwd_field password
<LIMIT GET POST>
require valid-user
</LIMIT>
This is what shows up in apache's error log:
[Fri Sep 13 11:39:57 2002] [error] access to /test failed for xxx.xxx.xxx.xxx,
reason: PG user ssmith: password mismatch
I've tried to debug the problem for quite a long time and can't think of
anything I'm doing wrong. Any help/advice anyone can provide would be much
appreciated.
Thanks,
Joey