[users@httpd] mod_authn_dbd password matching issue

[Fred McCann <fred@xxxxxxxxxxxxxxxxxxxxx>]

I'm trying to configure mod_authn_dbd on Apache 2.2 + Postgres 8 + FreeBSD 6 stable. Here's what I've got:

#Database Management
DBDriver pgsql
DBDParams "dbname=UserDirectory user=UserDirectory password=foo"
DBDMin  1
DBDKeep 2
DBDMax  10
DBDExptime 60

#Authentication Section
<Directory /usr/local/apache2/htdocs>
    AuthType Basic
    AuthName "Intranet"
    AuthBasicProvider dbd
    Require valid-user
   
AuthDBDUserPWQuery "select password from user_permissions where
username = %s and realm = 'Intranet' and permission = 'Wiki Access'"
</Directory>

When I try to login, I get this error:

[Tue Feb 28 12:52:32 2006] [error] [client 127.0.0.1] user fmccann: authentication failure for "/": Password Mismatch

I've tried storing the password in postgres as an SHA1 hash, an MD5 hash, and plain text- none of them ever match.


I've taken a look at 

APU_DECLARE(apr_status_t) apr_password_validate(const char *passwd, 
                                                const char *hash)
 
in apr_md5.c in apr-util and it looks like it's trying to figure out how the string is hashed, but I'm not sure I get how it's doing it. In any case, I can't get the passwords to match. Is there anyone out there who has a similar set up working that could toss me a hint?

- Fred



---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See

for more info. To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx