Return-Path: Delivered-To: apmail-modperl-archive@apache.org Received: (qmail 63220 invoked by uid 500); 22 Apr 2001 14:28:18 -0000 Mailing-List: contact modperl-help@apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Delivered-To: mailing list modperl@apache.org Received: (qmail 63176 invoked from network); 22 Apr 2001 14:28:18 -0000 Message-ID: <009601c0cb38$e4a50140$1400a8c0@heiss.de> From: "Christian Heiss" To: Subject: Apache::AuthDBI Date: Sun, 22 Apr 2001 16:31:17 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0093_01C0CB49.A7C91C00" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2462.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2462.0000 X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N This is a multi-part message in MIME format. ------=_NextPart_000_0093_01C0CB49.A7C91C00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I'm using Apache::AuthDBI to verifying the users on my web site. I can connect to the the protected site, but there is a output in the = error log: -------------------------------------------------------------------------= --------------------------------------------------------------- >Use of uninitialized value at = /usr/lib/perl5/site_perl/5.005/Apache/AuthDBI.pm line 450 >Use of uninitialized value at = /usr/lib/perl5/site_perl/5.005/Apache/AuthDBI.pm line 480 >Use of uninitialized value at = /usr/lib/perl5/site_perl/5.005/Apache/AuthDBI.pm line 481 -------------------------------------------------------------------------= --------------------------------------------------------------- To crypt the the passwords I'm using something like this: -------------------------------------------------------------------------= --------------------------------------------------------------- >my $userid =3D $query->param('userid'); > my $pass =3D $query->param('pass'); > my $groupid =3D $query->param('groupid'); >my $fullname =3D $query->param('fullname'); =20 $pass =3D crypt("$pass", "$userid"); -------------------------------------------------------------------------= --------------------------------------------------------------- then I put it in the database with: -------------------------------------------------------------------------= --------------------------------------------------------------- >my $sql =3D "INSERT INTO VALUES($userid, $groupid, $pass, = ...); of course, before I'm using the quote funktion = ($dbh->quote($userid)...)... -------------------------------------------------------------------------= --------------------------------------------------------------- and my .htacces is: -------------------------------------------------------------------------= --------------------------------------------------------------- >PerlModule Apache::AuthDBI >AuthName "something else" >AuthType Basic >PerlAuthenHandler Apache::AuthDBI::authen >PerlAuthzHandler Apache::AuthDBI::authz >PerlSetVar Auth_DBI_encrypted on >PerlSetVar Auth_DBI_data_source dbi:mysql: >PerlSetVar Auth_DBI_username >PerlSetVar Auth_DBI_password >PerlSetVar Auth_DBI_pwd_table
>PerlSetVar Auth_DBI_uid_field >PerlSetVar Auth_DBI_grp_field >PerlSetVar Auth_DBI_pwd_field >require valid-user >allow from all -------------------------------------------------------------------------= --------------------------------------------------------------- Anybody knows how to stop this error output? Thanks a lot Christian Hei=DF ------=_NextPart_000_0093_01C0CB49.A7C91C00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 

I=92m using Apache::AuthDBI to = verifying the=20 users on my web site.

 

I = can connect to=20 the the=20 protected site, but there is a output in the error = log:

----------------------------------------------------------------= ------------------------------------------------------------------------<= /FONT>
>Use=20 of uninitialized value at = /usr/lib/perl5/site_perl/5.005/Apache/AuthDBI.pm line=20 450
>Use=20 of uninitialized value at = /usr/lib/perl5/site_perl/5.005/Apache/AuthDBI.pm line=20 480
>Use=20 of uninitialized value at = /usr/lib/perl5/site_perl/5.005/Apache/AuthDBI.pm line=20 481
----------------------------------------------------------------= ------------------------------------------------------------------------<= /FONT>
 
To crypt the the passwords I'm using something = like=20 this:
----------------------------------------------------------------= ------------------------------------------------------------------------<= /FONT>
>my $userid =3D = $query->param('userid');
> my=20 $pass =3D $query->param('pass');
> my $groupid =3D=20 $query->param('groupid');
>my $fullname =3D=20 $query->param('fullname');
 
 $pass =3D = crypt("$pass",=20 "$userid");
----------------------------------------------------------------= ------------------------------------------------------------------------<= /FONT>
 
then I put it in the database=20 with:
----------------------------------------------------------------= ------------------------------------------------------------------------<= /FONT>
>my $sql =3D "INSERT INTO <table=20 name> VALUES($userid, $groupid, $pass,=20 ...);
of course, before I'm using the quote funktion=20 ($dbh->quote($userid)...)...
----------------------------------------------------------------= ------------------------------------------------------------------------<= /FONT>
 
and my .htacces = is:
----------------------------------------------------------------= ------------------------------------------------------------------------<= /FONT>
>PerlModule Apache::AuthDBI
>AuthName = "something=20 else"
>AuthType Basic
>PerlAuthenHandler=20 Apache::AuthDBI::authen
>PerlAuthzHandler=20 Apache::AuthDBI::authz
>PerlSetVar Auth_DBI_encrypted = on
>PerlSetVar=20 Auth_DBI_data_source=20 dbi:mysql:<database>
>PerlSetVar Auth_DBI_username <user=20 name>
>PerlSetVar Auth_DBI_password=20 <password>
>PerlSetVar Auth_DBI_pwd_table <table=20 name>
>PerlSetVar Auth_DBI_uid_field <userid=20 field>
>PerlSetVar Auth_DBI_grp_field <groupid=20 field>
>PerlSetVar Auth_DBI_pwd_field <password=20 field>
 
>require = valid-user
 
>allow from = all
----------------------------------------------------------------= ------------------------------------------------------------------------<= /FONT>
 
 
 
Anybody knows how to stop this error=20 output?
 
Thanks a lot
 
Christian=20 Hei=DF
------=_NextPart_000_0093_01C0CB49.A7C91C00--