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
