Return-Path: 
 <embperl-return-5366-apmail-perl-embperl-archive=perl.apache.org@perl.apache.org>
Delivered-To: apmail-perl-embperl-archive@perl.apache.org
Received: (qmail 29736 invoked by uid 500); 19 Feb 2003 18:50:45 -0000
Mailing-List: contact embperl-help@perl.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:embperl-help@perl.apache.org>
list-unsubscribe: <mailto:embperl-unsubscribe@perl.apache.org>
list-post: <mailto:embperl@perl.apache.org>
Delivered-To: mailing list embperl@perl.apache.org
Received: (qmail 29688 invoked from network); 19 Feb 2003 18:50:44 -0000
Content-Type: text/plain;
  charset="us-ascii"
From: Scott Chapman <scott_list@mischko.com>
Reply-To: scott_list@mischko.com
To: <embperl@perl.apache.org>
Subject: [OT] Urgent: DBI::Auth configuration problem
Date: Wed, 19 Feb 2003 10:50:48 -0800
User-Agent: KMail/1.4.3
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200302191050.48426.scott_list@mischko.com>
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

This is the last piece in my implementation.  If anyone can help with how=
 to=20
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.  I=
t's=20
not working.  My postgres debug log shows no activity as well as this err=
or=20
regarding my configuration.  I don't know how to debug this.  Anyone able=
 to=20
help?

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

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

installed Apache::AuthDBI off CPAN. =20
Recompiled mod_perl and apache:
perl Makefile.PL DO_HTTPD=3D1 USE_APACI=3D1 APACHE_PREFIX=3D/www PERL_AUT=
HEN=3D1=20
PERL_AUTHZ=3D1 PERL_CLEANUP=3D1 PERL_STACKED_HANDLERS=3D1
make/make install worked great.  Web server works. I can access Posgresql=
 just=20
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 =3D 16
  # optAllFormData =3D 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=3Dwebautomation
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