[users@httpd] Authorization in Apache 2.2

[alan bryan]

I'm trying to set up some sort of basic authentication in Apache 2.2 authenticating against a PostgreSQL 8.1 database.

Has anyone been able to successfully get the new mod_authn_dbd to work on FreeBSD? 

I've also tried mod_auth_pgsql which compiles fine but I get the error:
"No Authn provider configured"
when I run it using the same .htaccess that works fine in Apache 2.0.

So, any ideas to fix the above issues or get some other way to get basic auth to work on 2.2?

Thanks,
Alan