[users@httpd] Configuring mod_authn_dbd + Apache 2.2 + Postgres 8

[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>



As far as I can tell, Apache is hitting the database just fine. There are no errors. The problem I'm having is that the password field is sha1 encrypted. Is there some way to specify to Apache what algorithm and salt value so it can encrypt passwords before comparing them? I'm willing to change encryption mechanisms if necessary- I'd just rather not have plain text passwords. Is there a way or is this the fevered dream of a madman?

- 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