[OT] Urgent: DBI::Auth configuration problem

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

This is the last piece in my implementation.  If anyone can help with how to 
debug this or what is wrong with my configuration, I'd really appreciate it!

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

---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org