DBI::Auth configuration problem

[Scott Chapman <sc...@mischko.com>]

I'm trying DBI::Auth against a Postgresql database for authentication.  It's 
not working.  My postgres debug log shows no activity as well as this error 
regarding my configuration.  I don't know how to debug this.  Anyone able to 
help?

Error Log from Apache shows:
[Tue Feb 18 16:13:53 2003] [notice] Apache/1.3.27 (Unix) Embperl/2.0b8 
mod_perl/1.27 configured -- resuming normal operations
[Tue Feb 18 16:13:53 2003] [notice] Accept mutex: sysvsem (Default: sysvsem)
[Tue Feb 18 16:14:03 2003] [error] [client 192.168.0.121] client denied by 
server configuration: /www/htdocs/tester/index.html

Steps I went through to install the web server (RedHat 7.3 install from 
source):

installed Apache::AuthDBI off CPAN.  
Recompiled mod_perl and apache:
perl Makefile.PL DO_HTTPD=1 USE_APACI=1 APACHE_PREFIX=/www PERL_AUTHEN=1 
PERL_AUTHZ=1 PERL_CLEANUP=1 PERL_STACKED_HANDLERS=1
make/make install worked great.  Web server works. I can access Posgresql just 
fine using Perl DBI.

The .htaccess file in /www/htdocs/tester:
AuthType Basic
AuthName DBI
require user scott

Here's the relevant entries in my httpd.conf file:
<Directory />
    Options FollowSymLinks
    AllowOverride None
</Directory>
<Directory "/www/htdocs">
    Options Indexes FollowSymLinks MultiViews
    AllowOverride All
    Order allow,deny
    Deny from all
</Directory>
PerlModule Embperl
PerlSetEnv EMBPERL_SESSION_HANDLER_CLASS no
PerlSetEnv EMBPERL_DEBUG 10477
PerlSetEnv EMBPERL_DEBUG 0x7fffffff
PerlSetEnv EMBPERL_VIRTLOG /embperl/log
PerlSetEnv EMBPERL_OPTIONS 8208
  # optRawInput = 16
  # optAllFormData = 8192
PerlModule Embperl::Object
PerlModule Apache::DBI
# PerlModule MD5

<Location /embperl/log>
  SetHandler perl-script
  PerlHandler HTML::Embperl
  Options ExecCGI
</Location>

<Files *.epl>
        PerlSetEnv EMBPERL_APPNAME my_embperl_app
        PerlSetEnv EMBPERL_OBJECT_BASE base.epl
        PerlSetEnv EMBPERL_ESCMODE 0
#       PerlSetEnv EMBPERL_FILESMATCH "\.htm.?|\.epl$"
        PerlSetEnv EMBPERL_FILESMATCH "\.epl$"
        SetHandler perl-script
        PerlHandler Embperl::Object
#       PerlHandler HTML::Embperl
        Options ExecCGI
</Files>

AddType text/html .epl
<Directory /www/cgi-bin/webcal>
AllowOverride AuthConfig
Options ExecCGI
</Directory>

PerlModule Apache::AuthDBI
PerlAuthzHandler  Apache::AuthDBI::authz
PerlAuthenHandler Apache::AuthDBI::authen
PerlSetVar Auth_DBI_data_source dbi:Pg:dbname=webautomation
PerlSetVar Auth_DBI_username webuser
PerlSetVar Auth_DBI_password password
PerlSetVar Auth_DBI_pwd_table users
PerlSetVar Auth_DBI_uid_field username
PerlSetVar Auth_DBI_pwd_field password
PerlSetVar Auth_DBI_grp_table groups
PerlSetVar Auth_DBI_grp_field groupname
PerlSetVar Auth_DBI_encrypted off

Thanks!
Scott