You are viewing a plain text version of this content. The canonical link for it is here.
Posted to modperl@perl.apache.org by Yury Vasiliev <yu...@targuscom.com> on 2000/09/01 15:02:18 UTC
AuthDBI with Interbase
I use AuthDBI with Interbase
It works ok, but there are some strange error in log
//---------------------------------------------------------------
$Apache::DBI::VERSION = '0.87';
$DBI::VERSION = "1.14";
Interbase 6.0
//---------------------------------------------------------------
error_log:
30964 Apache::AuthDBI::authen request type = >initial main<
REQUEST:
GET /partners/ HTTP/1.1
Accept: */*
Accept-Encoding: gzip, deflate
Accept-Language: ru
Authorization: Basic YWFhOmJiYg==
Connection: Keep-Alive
Host: www.site.com
User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)
HTTP/1.1 (null)
30964 Apache::AuthDBI::authen get_basic_auth_pw: res = >0<, password sent = >bbb<
30964 Apache::AuthDBI::authen user sent = >aaa<
30964 Apache::AuthDBI::authen Config{ pwdcasesensitive } = on
30964 Apache::AuthDBI::authen Config{ pwd_whereclause } =
30964 Apache::AuthDBI::authen Config{ placeholder } = off
30964 Apache::AuthDBI::authen Config{ log_field } = LAST_LOGIN
30964 Apache::AuthDBI::authen Config{ uid_field } = USERNAME
30964 Apache::AuthDBI::authen Config{ authoritative } = on
30964 Apache::AuthDBI::authen Config{ data_source } = dbi:InterBase:database=/opt/db/test.gdb
30964 Apache::AuthDBI::authen Config{ grp_field } =
30964 Apache::AuthDBI::authen Config{ encrypted } = off
30964 Apache::AuthDBI::authen Config{ pwd_field } = USERPWD
30964 Apache::AuthDBI::authen Config{ nopasswd } = off
30964 Apache::AuthDBI::authen Config{ grp_table } =
30964 Apache::AuthDBI::authen Config{ pwd_table } = USERS
30964 Apache::AuthDBI::authen Config{ password } = masterkey
30964 Apache::AuthDBI::authen Config{ log_string } =
30964 Apache::AuthDBI::authen Config{ uidcasesensitive } = on
30964 Apache::AuthDBI::authen Config{ encryption_salt } = password
30964 Apache::AuthDBI::authen Config{ username } = sysdba
30964 Apache::AuthDBI::authen Config{ grp_whereclause } =
30964 Apache::AuthDBI::authen passwd not found in cache
30964 Apache::AuthDBI::authen statement: SELECT USERPWD FROM USERS WHERE USERNAME = 'aaa'
DBD::InterBase::st finish failed: at /usr/lib/perl5/site_perl/5.005/Apache/AuthDBI.pm line 292.
30964 Apache::AuthDBI::authen passwd = >bbb<
30964 Apache::AuthDBI::authen user aaa: password match for >bbb<
30964 Apache::AuthDBI::authen return OK
==========
30964 Apache::AuthDBI::authen request type = ><
==========
30964 Apache::AuthDBI::authen request type = >main<
//---------------------------------------------------------------
perl -V
Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
Platform:
osname=linux, osvers=2.2.5-22smp, archname=i386-linux
uname='linux porky.devel.redhat.com 2.2.5-22smp #1 smp wed jun 2 09:11:51 edt 1999 i686 unknown '
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef useperlio=undef d_sfio=undef
Compiler:
cc='cc', optimize='-O2', gccversion=egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
cppflags='-Dbool=char -DHAS_BOOL -I/usr/local/include'
ccflags ='-Dbool=char -DHAS_BOOL -I/usr/local/include'
stdchar='char', d_stdstdio=undef, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
alignbytes=4, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -ldl -lm -lc -lposix -lcrypt
libc=, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Built under linux
Compiled at Aug 30 1999 23:09:51
@INC:
/usr/lib/perl5/5.00503/i386-linux
/usr/lib/perl5/5.00503
/usr/lib/perl5/site_perl/5.005/i386-linux
/usr/lib/perl5/site_perl/5.005
.
//---------------------------------------------------------------
perl -v
This is perl, version 5.005_03 built for i386-linux
Copyright 1987-1999, Larry Wall
Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5.0 source kit.
Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'. If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.
--
Best regards
Yury Vasiliev
Head of IT Department
Targus Communications
Zubovsky bulvar, 13, bld 2, 4th floor.
Phone (+7 095) 246-8377
Fax (+7 095) 246-5605
yury.vasiliev@targuscom.com
www.targuscom.com
Re: AuthDBI with Interbase
Posted by Edwin Pratomo <ed...@computer.org>.
Gerald Richter wrote:
>
> > Other DBI extension modules
> > that I've known to work fine with DBD::InterBase are Apache::DBI,
> > DBIx::Recordset
>
> Was it necessary to add an entry in Compat.pm, or did it work out of the
> box? If you made any changes in Compat.pm, please send them to me, so I can
> include it in the next release of DBIx::Recordset
Thanks, Gerald. The default values work just fine, with one exception:
Placeholders => 3
But even without specifying this, it passes all of the make test.
Rgds,
Edwin.
Re: AuthDBI with Interbase
Posted by Gerald Richter <ri...@ecos.de>.
> Other DBI extension modules
> that I've known to work fine with DBD::InterBase are Apache::DBI,
> DBIx::Recordset
Was it necessary to add an entry in Compat.pm, or did it work out of the
box? If you made any changes in Compat.pm, please send them to me, so I can
include it in the next release of DBIx::Recordset
Thanks
Gerald
-------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: richter@ecos.de Voice: +49 6133 925151
WWW: http://www.ecos.de Fax: +49 6133 925152
-------------------------------------------------------------
Re: AuthDBI with Interbase
Posted by Edwin Pratomo <ed...@computer.org>.
Yury Vasiliev wrote:
>
> I use AuthDBI with Interbase
> It works ok, but there are some strange error in log
>
> //---------------------------------------------------------------
> $Apache::DBI::VERSION = '0.87';
> $DBI::VERSION = "1.14";
>
> Interbase 6.0
>
> //---------------------------------------------------------------
Use the latest DBD::InterBase at
http://sourceforge.net/projects/dbi-interbase/
This one is far more improved and stable than the previous one at CPAN.
Once I've revised the FAQ, I'll put it at CPAN.
I haven't tested AuthDBI with InterBase. Other DBI extension modules
that I've known to work fine with DBD::InterBase are Apache::DBI,
DBIx::Recordset, and DBIx::Tree (a small patch for DBI should be applied
first, due to a small bug in fetchall_arrayref method). Tie::DBI
_doesn't_ work. It uses LISTFIELDS command which is specific to MySQL,
and causes the InterBase parser to fail.
Rgds,
Edwin.