RE: :Sybase 'make test' failures
> From: Frank Wu [mailto:[EMAIL PROTECTED] > Now it's fixed with freetds 0.61rc. Bummer. The half-life of my internal documentation keeps getting shorter. perl -pi -e 's/cs_ctx_global/cs_ctx_alloc/g' dbdimp.c [1] ... [1] Per this newsgroup post: -jhannah 1/22/03 --- From: Michael Peppler ([EMAIL PROTECTED]) Subject: Re: help: linux perl5.6.1+freetds0.53+DBI1.21 +DBD::Sybase0.95 installation errors Newsgroups: perl.dbi.users Date: 2002-11-07 10:48:10 PST 1. Edit DBD::Sybase's dbdimp.c, and change cs_ctx_global() to cs_ctx_alloc(). --- Thanks for the memories Michael! Grin, Jay Hannah Application Development Manager Omni Hotels Reservation Center Tel: (402) 952-6573 Mobile: (402) 578-3976 Email: [EMAIL PROTECTED] In an ideal world, one of the luxuries of a luxury hotel would be an easier way to earn airline miles. > -Original Message- > From: Frank Wu [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 25, 2003 7:05 PM > To: 'Karyn Ulriksen'; 'Gordon Ross'; [EMAIL PROTECTED] > Subject: RE: :Sybase 'make test' failures > > > I had the same problem with Sybase 0.95/freetds 0.60 (or less) before, and > Michael Peppler sent me solutions: > > Two solutions: > > 1. Edit DBD::Sybase's dbdimp.c, and change cs_ctx_global() to cs_ctx_alloc(). > > 2. Get the latest CVS snapshot of FreeTDS. > > Now it's fixed with freetds 0.61rc. > > > Frank > > > -Original Message- > From: Karyn Ulriksen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 26, 2003 10:50 AM > To: Karyn Ulriksen; 'Gordon Ross'; [EMAIL PROTECTED] > Subject: DBD::Sybase 'make test' failures > > > > Here's the 'make test' failures, I'm seeing when running 'make test' on the > DBD::Sybase 0.95. Don't see them in 0.94. Maybe our faithful CPAN > contributor can make heads or tails of it. Note the repeated references to > the undefined "cs_ctx_global. This issues does not come up in 0.94. This > same failure occurs with Perl 5.6.0, 5.6.1, and 5.8.0. -snip!-
Strange security problem...
I was messing around at home with a test web server (Windows 2000 Professional, Apache and ActivePerl (all the latest versions of each)) which resides in my office and I typed in the url of a perl script. I purposely mistyped the url with 'cgi-bin' rather than what it actually is, 'CGI-BIN' just to see what would happen. I ended up getting the entire *code* of the perl script in my web browser (latest version of Safari on Mac OS X 10.2.3)! This worries me because my code contains passwords to our database. Is it a well known problem to capitalize the CGI-BIN directory? Should I make it lower case and change my Apache config file as well as any paths to it in my perl scripts? Or is it just a permissions problem? If I re-type the url using upper case CGI-BIN, it works as expected. I'm relatively new to Perl and Apache so forgive me if this is a well know faux pas. I was just wondering if others are aware of this issue. Regards, Cory Rau
Re: Cannot make DBI on perl 5.8.0
Built with 5.8.0 (thread-multi) for me. The message looks like a compiler bug. You could try DBI 1.34 which is winging it way to CPAN, announcement to follow... Tim. On Fri, Feb 28, 2003 at 02:25:06PM -0600, Bobby Garza wrote: > Tim, > > Here is my error message: > > ---snip--- > [EMAIL PROTECTED] DBI-1.33]# make > gcc -c -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing > -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 > -march=i386 -mcpu=i686 -DVERSION=\"1.33\" -DXS_VERSION=\"1.33\" -fpic > "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" -Wall > -Wno-comment DBI.c > -bash: [EMAIL PROTECTED]: command not found > DBI.xs: In function `dbi_profile': > DBI.xs:1981: internal error: Floating point exception > Please submit a full bug report, > with preprocessed source if appropriate. > See http://bugzilla.redhat.com/bugzilla/> for instructions. > make: *** [DBI.o] Error 1 > ---snip--- > > Here is my perl version info: > > ---snip--- > [EMAIL PROTECTED] DBI-1.33]# perl -V > Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration: > Platform: > osname=linux, osvers=2.4.18-11smp, archname=i386-linux-thread-multi > uname='linux daffy.perf.redhat.com 2.4.18-11smp #1 smp thu aug 15 > 06:41:59 edt 2002 i686 i686 i386 gnulinux ' > config_args='-des -Doptimize=-O2 -march=i386 -mcpu=i686 > -Dmyhostname=localhost [EMAIL PROTECTED] -Dcc=gcc -Dcf_by=Red > Hat, Inc. -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux > -Dvendorprefix=/usr -Dsiteprefix=/usr -Duseshrplib -Dusethreads > -Duseithreads -Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db > -Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio > -Dinstallusrbinperl -Ubincompat5005 -Uversiononly -Dpager=/usr/bin/less > -isr' > hint=recommended, useposix=true, d_sigaction=define > usethreads=define use5005threads=undef useithreads=define > usemultiplicity=define > useperlio=define d_sfio=undef uselargefiles=define usesocks=undef > use64bitint=undef use64bitall=undef uselongdouble=undef > usemymalloc=n, bincompat5005=undef > Compiler: > cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing > -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm', > optimize='-O2 -march=i386 -mcpu=i686', > cppflags='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing > -I/usr/include/gdbm' > ccversion='', gccversion='3.2 20020822 (Red Hat Linux Rawhide > 3.2-5)', gccosandvers='' > intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234 > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 > ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', > lseeksize=8 > alignbytes=4, prototype=define > Linker and Libraries: > ld='gcc', ldflags =' -L/usr/local/lib' > libpth=/usr/local/lib /lib /usr/lib > libs=-lnsl -lgdbm -ldb -ldl -lm -lpthread -lc -lcrypt -lutil > perllibs=-lnsl -ldl -lm -lpthread -lc -lcrypt -lutil > libc=/lib/libc-2.2.92.so, so=so, useshrplib=true, libperl=libperl.so > gnulibc_version='2.2.92' > Dynamic Linking: > dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic > -Wl,-rpath,/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE' > cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib' > > > Characteristics of this binary (from libperl): > Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES > PERL_IMPLICIT_CONTEXT > Built under linux > Compiled at Sep 1 2002 23:56:49 > @INC: > /usr/lib/perl5/5.8.0/i386-linux-thread-multi > /usr/lib/perl5/5.8.0 > /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi > /usr/lib/perl5/site_perl/5.8.0 > /usr/lib/perl5/site_perl > /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi > /usr/lib/perl5/vendor_perl/5.8.0 > /usr/lib/perl5/vendor_perl > > ---snip--- > > > I'm sure I've done something dumb but I haven't spent too much time > debugging yet... > > Much thanks in advance... > > Bobby Garza >
Recall: Cannot make DBI on perl 5.8.0
Bobby Garza would like to recall the message, "Cannot make DBI on perl 5.8.0".
Re: DBD:Oracle Connection Problem
Your connection string does notappear to be DBI friendly. You might want
to try something like this:
$ENV{"ORACLE_HOME"}="/path/to/your/oracle/home";
$dbh=DBI->connect("DBI:Oracle:host=oraclehost.yourdomain.com;sid=database","username","password");
that connect string works for under activestate's 5.6.1 for win 32 and
my 5.6.1 under linux. you also may want to check out Mr. Bunce's ORA
book _Programming the Perl DBI_ http://www.oreilly.com/catalog/perldbi/
hope that helps
On Thu, 2003-02-27 at 20:55, Ian Jones wrote:
> I have perl installed under Windows 2000.
>
> The following command works under SQLPLUS:
>
> SQL> connect user/psswrd@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
> (PROTOCOL = TCP)(HOST = srvr.domain.com)(PORT = 1521)))(CONNECT_DATA =
> (SERVICE_NAME = db1dev.domain.com)))
> Connected.
> SQL>
>
> However, connections attempted via DBD::Oracle yield "ORA-12538 (DBD
> ERROR: OCIServerAttach)". I'm running this from a cgi on a local
> installation of Apache.
>
> I do set my oracle home, and the cgi runs otherwise.
>
> $ENV{'ORACLE_HOME'} = "C:\oracle\ora81";
> $dbh = DBI->connect('dbi:Oracle:', q{user/psswrd@(DESCRIPTION =
> (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = srvr.domain.com)(PORT
> = 1521)))(CONNECT_DATA = (SERVICE_NAME = db1dev.domain.com))}, "");
> --rest trimmed
--
David Crown, MCSE, MCP+I, CCNA
Office of Information Technology
State of Delaware,
Department of Natural Resources and Environmental Control
[EMAIL PROTECTED]
Voice: (302)739-4409 Fax: (302)739-6242
www.dnrec.state.de.us/
Cannot make DBI on perl 5.8.0
Tim, Here is my error message: ---snip--- [EMAIL PROTECTED] DBI-1.33]# make gcc -c -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -march=i386 -mcpu=i686 -DVERSION=\"1.33\" -DXS_VERSION=\"1.33\" -fpic "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" -Wall -Wno-comment DBI.c -bash: [EMAIL PROTECTED]: command not found DBI.xs: In function `dbi_profile': DBI.xs:1981: internal error: Floating point exception Please submit a full bug report, with preprocessed source if appropriate. See http://bugzilla.redhat.com/bugzilla/> for instructions. make: *** [DBI.o] Error 1 ---snip--- Here is my perl version info: ---snip--- [EMAIL PROTECTED] DBI-1.33]# perl -V Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration: Platform: osname=linux, osvers=2.4.18-11smp, archname=i386-linux-thread-multi uname='linux daffy.perf.redhat.com 2.4.18-11smp #1 smp thu aug 15 06:41:59 edt 2002 i686 i686 i386 gnulinux ' config_args='-des -Doptimize=-O2 -march=i386 -mcpu=i686 -Dmyhostname=localhost [EMAIL PROTECTED] -Dcc=gcc -Dcf_by=Red Hat, Inc. -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux -Dvendorprefix=/usr -Dsiteprefix=/usr -Duseshrplib -Dusethreads -Duseithreads -Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db -Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio -Dinstallusrbinperl -Ubincompat5005 -Uversiononly -Dpager=/usr/bin/less -isr' hint=recommended, useposix=true, d_sigaction=define usethreads=define use5005threads=undef useithreads=define usemultiplicity=define useperlio=define d_sfio=undef uselargefiles=define usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm', optimize='-O2 -march=i386 -mcpu=i686', cppflags='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -I/usr/include/gdbm' ccversion='', gccversion='3.2 20020822 (Red Hat Linux Rawhide 3.2-5)', gccosandvers='' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=4, prototype=define Linker and Libraries: ld='gcc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib libs=-lnsl -lgdbm -ldb -ldl -lm -lpthread -lc -lcrypt -lutil perllibs=-lnsl -ldl -lm -lpthread -lc -lcrypt -lutil libc=/lib/libc-2.2.92.so, so=so, useshrplib=true, libperl=libperl.so gnulibc_version='2.2.92' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic -Wl,-rpath,/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE' cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES PERL_IMPLICIT_CONTEXT Built under linux Compiled at Sep 1 2002 23:56:49 @INC: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl ---snip--- I'm sure I've done something dumb but I haven't spent too much time debugging yet... Much thanks in advance... Bobby Garza
PAUSE Indexer report T/TI/TIMB/DBI-1.34.tar.gz
The following report has been written by the PAUSE namespace indexer. Please contact [EMAIL PROTECTED] if there are any open questions. Id: mldistwatch 244 2003-02-25 17:33:36Z k CPAN ID: TIMB Distribution file: T/TI/TIMB/DBI-1.34.tar.gz Number of files: 55 *.pm files: 22 README: DBI-1.34/README Timestamp of file: Fri Feb 28 17:53:35 2003 UTC Time of this run: Fri Feb 28 18:11:09 2003 UTC The following packages have been found in the distro: DBI::Format::Raw version: 11.4 in file: DBI-1.34/lib/DBI/Format.pm status: Not indexed because permissions missing. Visit PAUSE and click "View Permissions" to find the legitimate maintainer(s). DBI::Format version: 11.4 in file: DBI-1.34/lib/DBI/Format.pm status: Not indexed because DBI-Shell-11.91/lib/DBI/Format.pm in T/TL/TLOWERY/DBI-Shell-11.91.tar.gz has a higher version number (11.91) Bundle::DBI version: 11.03 in file: DBI-1.34/lib/Bundle/DBI.pm status: indexed DBD::ExampleP version: 11.09 in file: DBI-1.34/lib/DBD/ExampleP.pm status: indexed DBD::ExampleP::db version: 11.09 in file: DBI-1.34/lib/DBD/ExampleP.pm status: indexed DBD::ExampleP::dr version: 11.09 in file: DBI-1.34/lib/DBD/ExampleP.pm status: indexed DBD::ExampleP::st version: 11.09 in file: DBI-1.34/lib/DBD/ExampleP.pm status: indexed DBD::NullP version: 11.03 in file: DBI-1.34/lib/DBD/NullP.pm status: indexed DBD::NullP::db version: 11.03 in file: DBI-1.34/lib/DBD/NullP.pm status: indexed DBD::NullP::dr version: 11.03 in file: DBI-1.34/lib/DBD/NullP.pm status: indexed DBD::NullP::st version: 11.03 in file: DBI-1.34/lib/DBD/NullP.pm status: indexed DBD::Proxy version: 0.2004 in file: DBI-1.34/lib/DBD/Proxy.pm status: indexed DBD::Proxy::db version: 0.2004 in file: DBI-1.34/lib/DBD/Proxy.pm status: indexed DBD::Proxy::dr version: 0.2004 in file: DBI-1.34/lib/DBD/Proxy.pm status: indexed DBD::Proxy::st version: 0.2004 in file: DBI-1.34/lib/DBD/Proxy.pm status: indexed DBD::Sponge version: 11.07 in file: DBI-1.34/lib/DBD/Sponge.pm status: indexed DBD::Sponge::db version: 11.07 in file: DBI-1.34/lib/DBD/Sponge.pm status: indexed DBD::Sponge::dr version: 11.07 in file: DBI-1.34/lib/DBD/Sponge.pm status: indexed DBD::Sponge::st version: 11.07 in file: DBI-1.34/lib/DBD/Sponge.pm status: indexed DBI version: 1.34 in file: DBI-1.34/DBI.pm status: indexed DBI::Const::GetInfo::ANSI version: 1.03 in file: DBI-1.34/lib/DBI/Const/GetInfo/ANSI.pm status: indexed DBI::Const::GetInfo::ODBC version: 1.03 in file: DBI-1.34/lib/DBI/Const/GetInfo/ODBC.pm status: indexed DBI::Const::GetInfoReturn version: 1.04 in file: DBI-1.34/lib/DBI/Const/GetInfoReturn.pm status: indexed DBI::Const::GetInfoType version: 1.05 in file: DBI-1.34/lib/DBI/Const/GetInfoType.pm status: indexed DBI::DBD version: 11.13 in file: DBI-1.34/lib/DBI/DBD.pm status: indexed DBI::DBD::Metadata version: 1.01 in file: DBI-1.34/lib/DBI/DBD/Metadata.pm status: indexed DBI::FAQ version: 0.38 in file: DBI-1.34/lib/DBI/FAQ.pm status: indexed DBI::Format::Base version: 11.4 in file: DBI-1.34/lib/DBI/Format.pm status: indexed DBI::Format::Box version: 11.4 in file: DBI-1.34/lib/DBI/Format.pm status: indexed DBI::Format::HTML version: 11.4 in file: DBI-1.34/lib/DBI/Format.pm status: indexed DBI::Format::Neat version: 11.4 in file: DBI-1.34/lib/DBI/Format.pm status: indexed DBI::Format::String version: 11.4 in file: DBI-1.34/lib/DBI/Format.pm status: indexed DBI::Profile version: 1.06 in file: DBI-1.34/lib/DBI/Profile.pm status: indexed DBI::ProfileData version: 1.0 in file: DBI-1.34/lib/DBI/ProfileData.pm status: indexed DBI::ProfileDumper version: 1.0 in file: DBI-1.34/lib/DBI/ProfileDumper.pm status: indexed DBI::ProfileDumper::Apache version: 1.0 in file: DBI-1.34/lib/DBI/ProfileDumper/Apache.pm status: indexed DBI::ProxyServer version: 0.3005 in file: DBI-1.34/lib/DBI/ProxyServer.pm status: indexed DBI::ProxyServer::db version: 0.3005 in file: DBI-1.34/lib/DBI/ProxyServer.pm status: indexed DBI::ProxyServer::dr version: 0.3005 in file: DBI-1.34/lib/DBI/ProxyServer.pm status: indexed DBI::ProxyServer::st version: 0.3005 in file: DBI-1.34/lib/DBI/ProxyServer.pm status: indexed __END__
CPAN Upload: T/TI/TIMB/DBI-1.34.tar.gz
The uploaded file DBI-1.34.tar.gz has entered CPAN as file: $CPAN/authors/id/T/TI/TIMB/DBI-1.34.tar.gz size: 290116 bytes md5: f0056760bea3d5697c21d64358617895 No action is required on your part Request entered by: TIMB (Tim Bunce) Request entered on: Fri, 28 Feb 2003 17:52:10 GMT Request completed: Fri, 28 Feb 2003 17:53:35 GMT Virtually Yours, paused, v242
Re: setting rollback segments with Oracle
On Fri, Feb 28, 2003 at 12:19:41PM -0500, Steve Sapovits wrote:
>
> Setting rollback segments doesn't seem to work for me. No
> errors but the segment being set is not being used. I'm
> doing this:
>
> my $x = $dbh->do('SET TRANSACTION USE ROLLBACK SEGMENT BIG_ONE');
> die "Failed to set rollback: $!\n" if (!defined($x));
Do you have AutoCommit turned off? Otherwise you're setting the rollback
segment for a transaction which ends as soon as the statement is done
executing.
Ronald
setting rollback segments with Oracle
Setting rollback segments doesn't seem to work for me. No
errors but the segment being set is not being used. I'm
doing this:
my $x = $dbh->do('SET TRANSACTION USE ROLLBACK SEGMENT BIG_ONE');
die "Failed to set rollback: $!\n" if (!defined($x));
This is a box that needs some upgrades (e.g., a newer DBI)
but I was hoping to just get this working as is ...
My environment:
Solaris 2.7
Oracle1.8.6.0.0
Perl 5.6.1
DBI 1.30
DBD::Oracle 1.12
Steve Sapovits
GSI Commerce, Inc. http://www.gsicommerce.com
Email: [EMAIL PROTECTED]
Re: Trying to build a new perl with DBI statically linked to it
Fix your perl. Reconfigure and rebuild it so it does support dynamic loading (Otherwise you're just heading into a whole world of pain and frustration.) Tim. On Fri, Feb 28, 2003 at 02:53:35PM -, Chris Bucchere wrote: > Hi Frans, > > When I wrote and ran the simple script with only "use DBI" in > it, I got the same error: > > Can't load module DBI, dynamic loading not available in this perl. > (You may need to build a new perl executable which either supports > dynamic loading or has the DBI module statically linked into it.) > at /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 256 > BEGIN failed--compilation aborted at > /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 256. > Compilation failed in require at test.pl line 1. > BEGIN failed--compilation aborted at test.pl line 1. > > You wrote: > > > if you want to build something staticly you have to use a different > > 'make' command after having run 'perl Makefile.PL'. > > Do you know exactly what make command I need to use. I've given up on > dynamic loading -- sorry! > > BTW, I'm using Solaris with MySQL. > > Thanks! > > Chris Bucchere > Bucchere Development Group > [EMAIL PROTECTED] > 415.516.3941 > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, February 28, 2003 2:45 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: Trying to build a new perl with DBI statically linked to it > > Hmm, > > I would first try to check if perl itself does load DBI at all. > > i.e. a small script with only 'use DBI;' in it. > > I'm not too trusting of the install/check script there telling you perl > can't load dynamic. For starters, I would think MakeMaker would tell you > that when trying to install DBI/DBD dynamicly. > > Building 'staticly' means you really include the DBI/DBD modules INTO > your > perl binary. Makes for difficult upgrades and other troubles, you really > should try to get dynamic to work, spend some time on it if nessecary. > > I never use CPAN-Shell (company network) but if you want to build > something > staticly you have to use a different 'make' command after having run > 'perl > Makefile.PL'. I think you can force CPAN-Shell to re-install a module, > that > would include testing which would be nice to confirm if perl itself > works > with DBI at least. (you need to specify a username/password for most DBD > tests) > > What OS and database are you using ? > > --- > Frans Postma, (050-58) 81 852 > ATOS Origin, Unix Support > "If at first you don't succeed, skydiving isn't for you" > > > > > > -Oorspronkelijk bericht- > > Van: Chris Bucchere [mailto:[EMAIL PROTECTED] > > Verzonden: vrijdag 28 februari 2003 15:32 > > Aan: [EMAIL PROTECTED] > > CC: [EMAIL PROTECTED] > > Onderwerp: RE: Trying to build a new perl with DBI statically > > linked to > > it > > > > > > Hi Frans, > > > > I've done this using CPAN's automatic installation. Check this > > out: > > > > %> perl -MCPAN -e'install "DBD::mysql"' > > CPAN: Storable loaded ok > > Going to read /.cpan/Metadata > > Database was generated on Thu, 27 Feb 2003 16:40:43 GMT > > DBD::mysql is up to date. > > > > %>perl -MCPAN -e'install "DBI"' > > CPAN: Storable loaded ok > > Going to read /.cpan/Metadata > > Database was generated on Thu, 27 Feb 2003 16:40:43 GMT > > DBI is up to date. > > > > I think there's more to it than just installing because I'm > > still getting this error message: > > > > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > > checksetup.pl: Can't load module DBI, dynamic loading not available in > > this perl. > > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > > checksetup.pl: (You may need to build a new perl executable which > > either supports > > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > > checksetup.pl: dynamic loading or has the DBI module > > statically linked > > into it.) > > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > > checksetup.pl: at > > /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 256 > > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > > checksetup.pl: BEGIN failed--compilation aborted at > > /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 256. > > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > > checksetup.pl: Compilation failed in require at globals.pl line 76. > > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > > checksetup.pl: BEGIN failed--compilation aborted at > > globals.pl line 76. > > [Fri Feb 28 14:27:08 2003] checksetup.pl: Compilation failed > > in require > > at checksetup.pl line 617. > > > > Keep in mind that I've already tried compiling perl with dynamic > > loading and Bugzilla did not recognize the DBD::mysql or DBI > >
FAIL DBI-1.33 sun4-solaris 2.6
This distribution has been tested as part of the cpan-testers
effort to test as many new uploads to CPAN as possible. See
http://testers.cpan.org/
Please cc any replies to [EMAIL PROTECTED] to keep other
test volunteers informed and to prevent any duplicate effort.
--
This is an error report generated automatically by CPANPLUS,
version 0.042.
Below is the error stack during 'make test':
PERL_DL_NONLAZY=1 /usr/local/perl/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01basics.ok
t/02dbidrv.ok
t/03hleak..ok
t/04mods...ok
t/05thrclone...skipped
all skipped: this perl 5.006001 not configured to support iThreads
t/06attrs..ok
t/07kids...ok
t/08keeperrok
t/10examp..ok
t/15array..ok
t/20meta...ok
t/30subclass...ok
t/40profileok
t/41prof_dump..ok
t/42prof_data..ok
t/60preparse...ok
t/70shell..Can't locate object method "init" via package
"DBI::Shell::FindSqlFile" (perhaps you forgot to load "DBI::Shell::FindSqlFile"?) at
/usr/local/perl/CPANPLUS-5.6.1/5.6.1/build/DBI-1.33/blib/lib/DBI/Shell.pm line 141.
dubious
Test returned status 255 (wstat 65280, 0xff00)
Prototype mismatch: sub Test::Harness::_LARGEFILE_SOURCE vs () at (eval 4) line 1.
DIED. FAILED test 3
Failed 1/3 tests, 66.67% okay
t/80proxy..skipped
all skipped: modules required for proxy are probably not installed
t/zz_01basics_pp... Using DBI::PurePerl (DBI_PUREPERL=2)
ok
t/zz_02dbidrv_pp...ok
t/zz_03hleak_ppok
t/zz_04mods_pp.ok
t/zz_05thrclone_pp.skipped
all skipped: this perl 5.006001 not configured to support iThreads
t/zz_06attrs_ppok
t/zz_07kids_pp.skipped
all skipped: $h->{Kids} attribute not supported for DBI::PurePerl
t/zz_08keeperr_pp..ok
t/zz_10examp_pp Taint mode switching tests skipped
Taint attribute tests skipped
ok
t/zz_15array_ppok
t/zz_20meta_pp.ok
t/zz_30subclass_pp.ok
t/zz_40profile_pp..skipped
all skipped: profiling not supported for DBI::PurePerl
t/zz_41prof_dump_ppskipped
all skipped: profiling not supported for DBI::PurePerl
t/zz_42prof_data_ppskipped
all skipped: profiling not supported for DBI::PurePerl
t/zz_60preparse_pp.skipped
all skipped: preparse not supported for DBI::PurePerl
t/zz_70shell_ppCan't locate object method "init" via package
"DBI::Shell::FindSqlFile" (perhaps you forgot to load "DBI::Shell::FindSqlFile"?) at
/usr/local/perl/CPANPLUS-5.6.1/5.6.1/build/DBI-1.33/blib/lib/DBI/Shell.pm line 141.
...caught at t/zz_70shell_pp.t line 3.
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED test 3
Failed 1/3 tests, 66.67% okay
t/zz_80proxy_ppCan't locate object method "init" via package
"DBI::Shell::FindSqlFile" (perhaps you forgot to load "DBI::Shell::FindSqlFile"?) at
/usr/local/perl/CPANPLUS-5.6.1/5.6.1/build/DBI-1.33/blib/lib/DBI/Shell.pm line 141.
...caught ...propagated at t/zz_70shell_pp.t line 4.
skipped
all skipped: modules required for proxy are probably not installed
Failed Test Stat Wstat Total Fail Failed List of Failed
--
t/70shell.t255 65280 31 33.33% 3
t/zz_70shell_pp.t 255 65280 31 33.33% 3
9 tests skipped.
Failed 2/36 test scripts, 94.44% okay. 2/1140 subtests failed, 99.82% okay.
gnumake: *** [test_dynamic] Error 11
Additional comments:
--
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=solaris, osvers=2.6, archname=sun4-solaris
uname='sunos marceau 5.6 generic sun4u sparc sunw,ultra-1 '
config_args=''
hint=previous, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=undef usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
Compiler:
cc='cc', ccflags ='-I/usr/local/gnu/include -I/usr/local/gnu/BerkeleyDB/include',
optimize='-O',
cppflags='-I/usr/local/gnu/include -I/usr/local/gnu/BerkeleyDB/include'
ccversion='', gccversion='', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=4
alignbytes=8, usemymalloc=y, prototype=define
Linker and Libraries:
ld='cc', ldflags ='-L/usr/local/gnu/lib -L/usr/local/gnu/BerkeleyDB/lib'
libpth=/lib /usr/lib /usr/ccs/lib /usr/local/gnu/lib /usr/local/gnu/BerkeleyDB/lib
libs=-lsocket -lnsl
RE: Trying to build a new perl with DBI statically linked to it
Hmm, I would first try to check if perl itself does load DBI at all. i.e. a small script with only 'use DBI;' in it. I'm not too trusting of the install/check script there telling you perl can't load dynamic. For starters, I would think MakeMaker would tell you that when trying to install DBI/DBD dynamicly. Building 'staticly' means you really include the DBI/DBD modules INTO your perl binary. Makes for difficult upgrades and other troubles, you really should try to get dynamic to work, spend some time on it if nessecary. I never use CPAN-Shell (company network) but if you want to build something staticly you have to use a different 'make' command after having run 'perl Makefile.PL'. I think you can force CPAN-Shell to re-install a module, that would include testing which would be nice to confirm if perl itself works with DBI at least. (you need to specify a username/password for most DBD tests) What OS and database are you using ? --- Frans Postma, (050-58) 81 852 ATOS Origin, Unix Support "If at first you don't succeed, skydiving isn't for you" > -Oorspronkelijk bericht- > Van: Chris Bucchere [mailto:[EMAIL PROTECTED] > Verzonden: vrijdag 28 februari 2003 15:32 > Aan: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED] > Onderwerp: RE: Trying to build a new perl with DBI statically > linked to > it > > > Hi Frans, > > I've done this using CPAN's automatic installation. Check this > out: > > %> perl -MCPAN -e'install "DBD::mysql"' > CPAN: Storable loaded ok > Going to read /.cpan/Metadata > Database was generated on Thu, 27 Feb 2003 16:40:43 GMT > DBD::mysql is up to date. > > %>perl -MCPAN -e'install "DBI"' > CPAN: Storable loaded ok > Going to read /.cpan/Metadata > Database was generated on Thu, 27 Feb 2003 16:40:43 GMT > DBI is up to date. > > I think there's more to it than just installing because I'm > still getting this error message: > > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: Can't load module DBI, dynamic loading not available in > this perl. > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: (You may need to build a new perl executable which > either supports > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: dynamic loading or has the DBI module > statically linked > into it.) > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: at > /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 256 > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: BEGIN failed--compilation aborted at > /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 256. > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: Compilation failed in require at globals.pl line 76. > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: BEGIN failed--compilation aborted at > globals.pl line 76. > [Fri Feb 28 14:27:08 2003] checksetup.pl: Compilation failed > in require > at checksetup.pl line 617. > > Keep in mind that I've already tried compiling perl with dynamic > loading and Bugzilla did not recognize the DBD::mysql or DBI > modules. So > now I'm trying to build perl with static links to these two modules. > That's where I'm stuck. > > Thanks! > > Chris Bucchere > Bucchere Development Group > [EMAIL PROTECTED] > 415.516.3941 > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Friday, February 28, 2003 2:24 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: Trying to build a new perl with DBI statically > linked to it > > Download DBI-1.32 and and DBD module which links to the database you > want to > use (e.g. oracle, mysql or such) and compile/install both. > (DBI first). > > If you don't have a database setup yet you need some more documents > first, > since bugzilla requires one. > > --- > Frans Postma, (050-58) 81 852 > ATOS Origin, Unix Support > "If at first you don't succeed, skydiving isn't for you" > > > > -Oorspronkelijk bericht- > > Van: Chris Bucchere [mailto:[EMAIL PROTECTED] > > Verzonden: vrijdag 28 februari 2003 15:19 > > Aan: [EMAIL PROTECTED] > > Onderwerp: Trying to build a new perl with DBI statically > linked to it > > > > > > Hi Folks, > > > > > > > > I've encountered an error when configuring some > open-source > > software (Bugzilla) that has asked me to "build a new perl > executable > > which either supports dynamic loading or has the DBI module > statically > > linked into it." I don't know how to do this and I can't find any > > documentation to help me out. Can you point me in the right > direction? > > > > > > > > Thanks! > > > > > > > > Chris Bucchere > > > > Bucchere Development Group > > > > [EMAIL PROTEC
RE: Trying to build a new perl with DBI statically linked to it
Hi Frans, When I wrote and ran the simple script with only "use DBI" in it, I got the same error: Can't load module DBI, dynamic loading not available in this perl. (You may need to build a new perl executable which either supports dynamic loading or has the DBI module statically linked into it.) at /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 256 BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 256. Compilation failed in require at test.pl line 1. BEGIN failed--compilation aborted at test.pl line 1. You wrote: > if you want to build something staticly you have to use a different > 'make' command after having run 'perl Makefile.PL'. Do you know exactly what make command I need to use. I've given up on dynamic loading -- sorry! BTW, I'm using Solaris with MySQL. Thanks! Chris Bucchere Bucchere Development Group [EMAIL PROTECTED] 415.516.3941 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 2:45 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Trying to build a new perl with DBI statically linked to it Hmm, I would first try to check if perl itself does load DBI at all. i.e. a small script with only 'use DBI;' in it. I'm not too trusting of the install/check script there telling you perl can't load dynamic. For starters, I would think MakeMaker would tell you that when trying to install DBI/DBD dynamicly. Building 'staticly' means you really include the DBI/DBD modules INTO your perl binary. Makes for difficult upgrades and other troubles, you really should try to get dynamic to work, spend some time on it if nessecary. I never use CPAN-Shell (company network) but if you want to build something staticly you have to use a different 'make' command after having run 'perl Makefile.PL'. I think you can force CPAN-Shell to re-install a module, that would include testing which would be nice to confirm if perl itself works with DBI at least. (you need to specify a username/password for most DBD tests) What OS and database are you using ? --- Frans Postma, (050-58) 81 852 ATOS Origin, Unix Support "If at first you don't succeed, skydiving isn't for you" > -Oorspronkelijk bericht- > Van: Chris Bucchere [mailto:[EMAIL PROTECTED] > Verzonden: vrijdag 28 februari 2003 15:32 > Aan: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED] > Onderwerp: RE: Trying to build a new perl with DBI statically > linked to > it > > > Hi Frans, > > I've done this using CPAN's automatic installation. Check this > out: > > %> perl -MCPAN -e'install "DBD::mysql"' > CPAN: Storable loaded ok > Going to read /.cpan/Metadata > Database was generated on Thu, 27 Feb 2003 16:40:43 GMT > DBD::mysql is up to date. > > %>perl -MCPAN -e'install "DBI"' > CPAN: Storable loaded ok > Going to read /.cpan/Metadata > Database was generated on Thu, 27 Feb 2003 16:40:43 GMT > DBI is up to date. > > I think there's more to it than just installing because I'm > still getting this error message: > > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: Can't load module DBI, dynamic loading not available in > this perl. > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: (You may need to build a new perl executable which > either supports > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: dynamic loading or has the DBI module > statically linked > into it.) > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: at > /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 256 > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: BEGIN failed--compilation aborted at > /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 256. > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: Compilation failed in require at globals.pl line 76. > [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] > checksetup.pl: BEGIN failed--compilation aborted at > globals.pl line 76. > [Fri Feb 28 14:27:08 2003] checksetup.pl: Compilation failed > in require > at checksetup.pl line 617. > > Keep in mind that I've already tried compiling perl with dynamic > loading and Bugzilla did not recognize the DBD::mysql or DBI > modules. So > now I'm trying to build perl with static links to these two modules. > That's where I'm stuck. > > Thanks! > > Chris Bucchere > Bucchere Development Group > [EMAIL PROTECTED] > 415.516.3941 > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Friday, February 28, 2003 2:24 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: Trying to build a new perl with DBI statically > linked to it > > Download DBI-1.32 and
RE: Errors installing DBI on SuSE Linux 7.2
Just install the Time::HiRes module and then try DBI again. ---Frans Postma, (050-58) 81 852ATOS Origin, Unix Support "If at first you don't succeed, skydiving isn't for you" -Oorspronkelijk bericht-Van: Andreas Koch [mailto:[EMAIL PROTECTED]Verzonden: vrijdag 28 februari 2003 15:14Aan: [EMAIL PROTECTED]Onderwerp: RE: Errors installing DBI on SuSE Linux 7.2 Hello Tim,thank you for your fast response. I probably use the DBI-1.33i have no idea what to do, to fix the problem. I attached all my outputfiles and hope that they can help.Is there a reason not to use the ActivePerl or better are therealternative perl dist. available? Thank you for help.Have a nice weekend.Andreas >First, this is the wrong mailing list. Use mailto:[EMAIL PROTECTED] >Second, the Time/HiRes.pm error means you're probably >installing 1.32 and not 1.33. If you're *sure* that's not >the case please repost with more details to mailto:[EMAIL PROTECTED] >Thanks. >Tim. >On Thu, Feb 27, 2003 at 04:47:01PM -, Andreas wrote: > Hello, > > i tried to install DBI on a machine running Suse Linux 7.2. > > Machine : Suse Linux 7.2 > DB-Client: Oracle 8.1.7 > DBI : DBI-1.33 > Perl : ActivePerl 5.6 > > Sorry if this sounds stupid, but i'm a perl/dbi newbi :) > > DBI Installation > - > > The first i have to do is to execute the Perl Makefile, > during the creation he adds extra DBI::PurePerl Tests > after that i have to use make. During the make process > some warning will display : > > e.g. : DBI.xs: 973: warning: unused variable 'Perlnotused' > + 5 similar warnings > > Then the make process is completed. > > Then i tried to test it: > > t/40profile failed with a timeout. after Time/HiRes.pm cannot be found. > and round about 20 times my perl path will be displayed, then the > statement ends at line 104 with failed BEGIN > > the next message is: > t/40profile.dubios > DIED. Failed Test 1 - 56 > > > The test is completed with 1/36 failures, 56/1140 subtests failed. 95,09% > OK. > make: [test dynamic] Error 29 > > Can anyone help? I doesn't know what to do, to solve the problem? >
RE: Errors installing DBI on SuSE Linux 7.2
Hello Tim,thank you for your fast response. I probably use the DBI-1.33i have no idea what to do, to fix the problem. I attached all my outputfiles and hope that they can help.Is there a reason not to use the ActivePerl or better are therealternative perl dist. available? Thank you for help.Have a nice weekend.Andreas >First, this is the wrong mailing list. Use mailto:[EMAIL PROTECTED]
>Second, the Time/HiRes.pm error means you're probably
>installing 1.32 and not 1.33. If you're *sure* that's not
>the case please repost with more details to mailto:[EMAIL PROTECTED]
>Thanks.
>Tim.
>On Thu, Feb 27, 2003 at 04:47:01PM -, Andreas wrote:
> Hello,
>
> i tried to install DBI on a machine running Suse Linux 7.2.
>
> Machine : Suse Linux 7.2
> DB-Client: Oracle 8.1.7
> DBI : DBI-1.33
> Perl : ActivePerl 5.6
>
> Sorry if this sounds stupid, but i'm a perl/dbi newbi :)
>
> DBI Installation
> -
>
> The first i have to do is to execute the Perl Makefile,
> during the creation he adds extra DBI::PurePerl Tests
> after that i have to use make. During the make process
> some warning will display :
>
> e.g. : DBI.xs: 973: warning: unused variable 'Perlnotused'
> + 5 similar warnings
>
> Then the make process is completed.
>
> Then i tried to test it:
>
> t/40profile failed with a timeout. after Time/HiRes.pm cannot be found.
> and round about 20 times my perl path will be displayed, then the
> statement ends at line 104 with failed BEGIN
>
> the next message is:
> t/40profile.dubios
> DIED. Failed Test 1 - 56
>
>
> The test is completed with 1/36 failures, 56/1140 subtests failed. 95,09%
> OK.
> make: [test dynamic] Error 29
>
> Can anyone help? I doesn't know what to do, to solve the problem?
>
PERL_DL_NONLAZY=1 /usr/local/ActivePerl-5.6/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/ActivePerl-5.6/lib/5.6.1/i686-linux-thread-multi
-I/usr/local/ActivePerl-5.6/lib/5.6.1 -e 'use Test::Harness qw(&runtests $verbose);
$verbose=0; runtests @ARGV;' t/*.t
t/01basics..ok
t/02dbidrv..ok
t/03hleak...ok
t/04modsok
t/05thrcloneskipped: this perl 5.006001 not configured to support iThreads
t/06attrs...ok
t/07kidsok
t/08keeperr.ok
t/10examp...ok
t/15array...ok
t/20metaok
t/30subclassok
t/40profile.dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-56
Failed 56/56 tests, 0.00% okay
t/41prof_dump...ok
t/42prof_data...ok
t/60preparseok
t/70shell...ok
t/80proxy...skipped: modules required for proxy are probably not installed
t/zz_01basics_ppok
t/zz_02dbidrv_ppok
t/zz_03hleak_pp.ok
t/zz_04mods_pp..ok
t/zz_05thrclone_pp..skipped: this perl 5.006001 not configured to support iThreads
t/zz_06attrs_pp.ok
t/zz_07kids_pp..skipped: $h->{Kids} attribute not supported for DBI::PurePerl
t/zz_08keeperr_pp...ok
t/zz_10examp_pp.ok
t/zz_15array_pp.ok
t/zz_20meta_pp..ok
t/zz_30subclass_pp..ok
t/zz_40profile_pp...skipped: profiling not supported for DBI::PurePerl
t/zz_41prof_dump_pp.skipped: profiling not supported for DBI::PurePerl
t/zz_42prof_data_pp.skipped: profiling not supported for DBI::PurePerl
t/zz_60preparse_pp..skipped: preparse not supported for DBI::PurePerl
t/zz_70shell_pp.ok
t/zz_80proxy_pp.skipped: modules required for proxy are probably not installed
Failed Test Status Wstat Total Fail Failed List of Failed
t/40profile.t 2 51256 56 100.00% 1-56
9 tests skipped.
*** You are using a perl configured with threading enabled.
*** You should be aware that using multiple threads is
*** not recommended for production environments.
*** Note:
The optional PlRPC-modules (RPC::PlServer etc) are not installed.
If you want to use the DBD::Proxy driver and DBI::ProxyServer
modules, then you'll need to install the RPC::PlServer, RPC::PlClient,
Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you.
You can install them any time after installing the DBI.
You do *not* need these modules for typical DBI usage.
Optional modules are available from any CPAN mirror, in particular
http://www.perl.com/CPAN/modules/by-module
http://www.perl.org/CPAN/modules/by-module
ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module
Creating extra DBI::PurePerl test: t/zz_01basics_pp.t
Creating extra DBI::PurePerl test: t/zz_02dbidrv_pp.t
Creating extra DBI::PurePerl test: t/zz_03hleak_pp.t
Creating extra DBI::PurePerl test: t/zz_04mods_pp.t
Creating extra DBI::PurePerl test: t/zz_05thrclone_pp.t
Creating extra DBI::PurePerl test: t/zz_06attrs_pp.t
Creating extra DBI::PurePerl test: t/zz_07kids_pp.t
Creating extra DBI::PurePerl test: t/zz_08keeperr_pp.t
Creating extra DBI::PurePerl test: t/zz_10examp_pp.t
Creating extra DBI::
RE: Trying to build a new perl with DBI statically linked to it
Hi Frans, I've done this using CPAN's automatic installation. Check this out: %> perl -MCPAN -e'install "DBD::mysql"' CPAN: Storable loaded ok Going to read /.cpan/Metadata Database was generated on Thu, 27 Feb 2003 16:40:43 GMT DBD::mysql is up to date. %>perl -MCPAN -e'install "DBI"' CPAN: Storable loaded ok Going to read /.cpan/Metadata Database was generated on Thu, 27 Feb 2003 16:40:43 GMT DBI is up to date. I think there's more to it than just installing because I'm still getting this error message: [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] checksetup.pl: Can't load module DBI, dynamic loading not available in this perl. [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] checksetup.pl: (You may need to build a new perl executable which either supports [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] checksetup.pl: dynamic loading or has the DBI module statically linked into it.) [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] checksetup.pl: at /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 256 [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] checksetup.pl: BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm line 256. [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] checksetup.pl: Compilation failed in require at globals.pl line 76. [Fri Feb 28 14:27:08 2003] checksetup.pl: [Fri Feb 28 14:27:08 2003] checksetup.pl: BEGIN failed--compilation aborted at globals.pl line 76. [Fri Feb 28 14:27:08 2003] checksetup.pl: Compilation failed in require at checksetup.pl line 617. Keep in mind that I've already tried compiling perl with dynamic loading and Bugzilla did not recognize the DBD::mysql or DBI modules. So now I'm trying to build perl with static links to these two modules. That's where I'm stuck. Thanks! Chris Bucchere Bucchere Development Group [EMAIL PROTECTED] 415.516.3941 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 2:24 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Trying to build a new perl with DBI statically linked to it Download DBI-1.32 and and DBD module which links to the database you want to use (e.g. oracle, mysql or such) and compile/install both. (DBI first). If you don't have a database setup yet you need some more documents first, since bugzilla requires one. --- Frans Postma, (050-58) 81 852 ATOS Origin, Unix Support "If at first you don't succeed, skydiving isn't for you" > -Oorspronkelijk bericht- > Van: Chris Bucchere [mailto:[EMAIL PROTECTED] > Verzonden: vrijdag 28 februari 2003 15:19 > Aan: [EMAIL PROTECTED] > Onderwerp: Trying to build a new perl with DBI statically linked to it > > > Hi Folks, > > > > I've encountered an error when configuring some open-source > software (Bugzilla) that has asked me to "build a new perl executable > which either supports dynamic loading or has the DBI module statically > linked into it." I don't know how to do this and I can't find any > documentation to help me out. Can you point me in the right direction? > > > > Thanks! > > > > Chris Bucchere > > Bucchere Development Group > > [EMAIL PROTECTED] > > 415.516.3941 > > > >
RE: Problem with "update" statement
My question has been answered:
$dbh = DBI->connect($data_source, $username, $password, 'Sybase')
is deprecated, I should be using:
$dbh = DBI->connect($data_source, $username, $password)
> -Original Message-
> From: Russell Kroboth [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 27, 2003 12:14 PM
> To: [EMAIL PROTECTED]
> Subject: Problem with "update" statement
>
>
> I am having a problem using the UPDATE statement in a Perl
> program, this
> program does not update the field as expected:
>
> #!/usr/bin/perl
> use DBI;
> require "DBconnect.cgi";
> $dbh = DBI->connect($data_source, $username, $password,
> 'Sybase') || die
> &DBerror;
> $dbh->do("use Partners") || die &DBerror;
> $sql="UPDATE deals SET accountno = 'somethingelse' WHERE
> hotdealnum=15";
> $rows=$dbh->do($sql) || die &DBerror;
> print "$rows affected\n";
> exit;
>
> result: "-1 rows affected"
>
>
> However if I use a different query it works. For example, the
> following
> script works fine, so I know that the SQL commands are being
> passed and
> executed by the script:
>
> #!/usr/bin/perl
> use DBI;
> require "DBconnect.cgi";
> $dbh = DBI->connect($data_source, $username, $password,
> 'Sybase') || die
> &DBerror;
> $dbh->do("use Partners") || die &DBerror;
> $sql="SELECT accountno FROM deals WHERE hotdealnum = 15";
> $sth=$dbh->prepare($sql) || die &DBerror;
> $sth->execute() || die &DBerror;
> $hashref=$sth->fetchrow_hashref();
> print "Value is ".$hashref->{'accountno'}."\n";
> $sth->finish();
> exit;
>
> result: works as expected, can verify looking at actual value using
> enterprise manager.
>
>
> I tried the same query (UPDATE CVB_hotdeals SET accountno =
> 'somethingelse'
> WHERE hotdealnum=15) and it worked fine.
>
> I also tried the query using isql to make sure my Freetds
> driver seemed to
> be working, and the query worked.
>
> I am using unixodbc , freeTDS, DBD:Sybase
>
> Any feedback would be appreciated! Thanks!
>
> -Rusty
>
>
RE: Trying to build a new perl with DBI statically linked to it
use DBI; perldoc -m DBI or search.cpan.org If 'use DBI;' is not what they're talking about ask them exactly what they mean by 'statically linked' > > Hi Folks, > > > > I've encountered an error when configuring some > open-source software (Bugzilla) that has asked me to "build a > new perl executable which either supports dynamic loading or > has the DBI module statically linked into it." I don't know > how to do this and I can't find any documentation to help me > out. Can you point me in the right direction? > > > > Thanks! > > > > Chris Bucchere > > Bucchere Development Group > > [EMAIL PROTECTED] > > 415.516.3941 > > > >
RE: Trying to build a new perl with DBI statically linked to it
Download DBI-1.32 and and DBD module which links to the database you want to use (e.g. oracle, mysql or such) and compile/install both. (DBI first). If you don't have a database setup yet you need some more documents first, since bugzilla requires one. --- Frans Postma, (050-58) 81 852 ATOS Origin, Unix Support "If at first you don't succeed, skydiving isn't for you" > -Oorspronkelijk bericht- > Van: Chris Bucchere [mailto:[EMAIL PROTECTED] > Verzonden: vrijdag 28 februari 2003 15:19 > Aan: [EMAIL PROTECTED] > Onderwerp: Trying to build a new perl with DBI statically linked to it > > > Hi Folks, > > > > I've encountered an error when configuring some open-source > software (Bugzilla) that has asked me to "build a new perl executable > which either supports dynamic loading or has the DBI module statically > linked into it." I don't know how to do this and I can't find any > documentation to help me out. Can you point me in the right direction? > > > > Thanks! > > > > Chris Bucchere > > Bucchere Development Group > > [EMAIL PROTECTED] > > 415.516.3941 > > > >
Trying to build a new perl with DBI statically linked to it
Hi Folks, I've encountered an error when configuring some open-source software (Bugzilla) that has asked me to "build a new perl executable which either supports dynamic loading or has the DBI module statically linked into it." I don't know how to do this and I can't find any documentation to help me out. Can you point me in the right direction? Thanks! Chris Bucchere Bucchere Development Group [EMAIL PROTECTED] 415.516.3941
Re: DBD-Oracle-1.12 under cygwin with Oracle 8.1.5.0.0?
Zelena, A few months back Steve Baldwin was trying to do the same thing. He posted the final result of his effort which I have attached to this email as dbdo_cyg.txt Like Steve said Hope this helps... "Zelena Endre" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > I try to compile DBD-Orcacle-1.12 under cygwin, (installed on Windows NT), > but... > > I made libic.a, and put it into /usr/local/lib/ dir, I installed Oracle > client products (Pro*C/C++, OCI version 8.1.5.0.0), but I can't compile > it... > > Could anybody help me? > > Thanks a lot, and sorry for my poor english, > > Endre > > - screen capture start: - > [EMAIL PROTECTED] ~/src/DBD-Oracle-1.12 > $ export ORACLE_HOME="/cygdrive/e/Oracle815/" > > [EMAIL PROTECTED] ~/src/DBD-Oracle-1.12 > $ perl Makefile.PL > Using DBI 1.32 installed in > /usr/lib/perl5/site_perl/5.8.0/cygwin-multi-64int/au > to/DBI > Duplicate specification "S=s" for option "s" > > Configuring DBD::Oracle ... > > >>> Remember to actually *READ* the README file! > Especially if you have any problems. > > Using Oracle in /cygdrive/e/Oracle815/ > Found header files in rdbms/include. > Found OCI directory > Using OCI directory 'OCI' > Using liboci.a (did you build it?) > > System: perl5.008 cygwin_nt-5.0 kmbestst 1.3.12(0.5432) 2002-07-06 02:16 > i686 un > known > Compiler: gcc -O2 -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing > Linker: /usr/bin/ld > Sysliblist: > > > Warning: If you have problems you may need to rebuild perl > with -Uusemymalloc. > > Checking if your kit is complete... > Looks good > Use of uninitialized value in concatenation (.) or string at Makefile.PL > line 11 > 29. > LD_RUN_PATH=/usr/local/lib > Using DBD::Oracle 1.12. > Using DBD::Oracle 1.12. > Using DBI 1.32 installed in > /usr/lib/perl5/site_perl/5.8.0/cygwin-multi-64int/au > to/DBI > Writing Makefile for DBD::Oracle > > *** If you have problems... > read all the log printed above, and the README and README.help files. > (Of course, you have read README by now anyway, haven't you?) > > > [EMAIL PROTECTED] ~/src/DBD-Oracle-1.12 > $ make > cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h > cp Oracle.pm blib/lib/DBD/Oracle.pm > cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h > cp oraperl.ph blib/lib/oraperl.ph > cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h > cp Oraperl.pm blib/lib/Oraperl.pm > cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm > /usr/bin/perl.exe -p -e "s/~DRIVER~/Oracle/g" < > /usr/lib/perl5/site_perl/5.8.0/c > ygwin-multi-64int/auto/DBI/Driver.xst > Oracle.xsi > /usr/bin/perl.exe /usr/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap > /usr/lib/perl5/ > 5.8.0/ExtUtils/typemap Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c > gcc -c -I/cygdrive/e/Oracle815//OCI/include -I/cygdrive/e/Oracle815//rdbms/ > demo > -I/usr/lib/perl5/site_perl/5.8.0/cygwin-multi-64int/auto/DBI -DPERL_USE_S AF > E_PU > TENV -fno-strict-aliasing -DUSEIMPORTLIB -O2 -DVERSION=\"1.12\" -DXS_VERSI > ON=\ > "1.12\" "-I/usr/lib/perl5/5.8.0/cygwin-multi-64int/CORE" Oracle.c > In file included from Oracle.h:20, > from Oracle.xs:1: > dbdimp.h:43:22: oratypes.h: No such file or directory > dbdimp.h:44:20: ocidfn.h: No such file or directory > dbdimp.h:57:21: ociapr.h: No such file or directory > In file included from Oracle.h:20, > from Oracle.xs:1: > dbdimp.h:97: parse error before "Lda_Def" > dbdimp.h:97: warning: no semicolon at end of struct or union > dbdimp.h:98: warning: data definition has no type or storage class > dbdimp.h:99: parse error before "hdabuf" > dbdimp.h:99: warning: data definition has no type or storage class > dbdimp.h:100: parse error before '*' token > dbdimp.h:100: warning: data definition has no type or storage class > dbdimp.h:105: parse error before '}' token > dbdimp.h:126: parse error before "Cda_Def" > dbdimp.h:126: warning: no semicolon at end of struct or union > dbdimp.h:127: warning: data definition has no type or storage class > dbdimp.h:153: parse error before '}' token > dbdimp.h:159: parse error before "ub2" > dbdimp.h:159: warning: no semicolon at end of struct or union > dbdimp.h:160: warning: data definition has no type or storage class > dbdimp.h:161: parse error before '*' token > dbdimp.h:161: warning: data definition has no type or storage class > dbdimp.h:162: parse error before '*' token > dbdimp.h:162: warning: data definition has no type or storage class > dbdimp.h:163: parse error before '*' token > dbdimp.h:163: warning: data definition has no type or storage class > dbdimp.h:164: parse error before '}' token > dbdimp.h:185: parse error before "sb4" > dbdimp.h:185: warning: no semicolon at end of struct or union > dbdimp.h:186: warning: data definition has no type or storage class > dbdimp.h:187: parse error before "prec" > dbdimp.h:187: warning: data definition has no type or storage class > dbdimp.h:188: parse error before "scale" > dbdimp.h:188: warning: data defi
RE: FAIL DBI-1.33 MSWin32-x86-multi-thread 4.0
> Failed Test Stat Wstat Total Fail Failed List of Failed > -- > - > t\40profile.t 561 1.79% 23 > t\42prof_data.t 181 5.56% 6 > t\70shell.t255 65280 31 33.33% 3 > t\zz_70shell_pp.t 255 65280 31 33.33% 3 > 9 tests skipped. > Failed 4/36 test scripts, 88.89% okay. 4/1140 subtests > failed, 99.65% okay. NMAKE : fatal error U1077: > 'C:\Perl\bin\perl.exe' : return code '0xff' Stop. Much snipped: With the exception of the DBI::Shell errors which have been previously discussed, this is the same set of issues you and I have discussed and I will send a version to you today. Jeff
RE: DBI-1.33 & DBD::Oracle 1.12
> > > On Thu, Feb 27, 2003 at 05:01:56PM -0500, Jeff Urlwin wrote: > > Tim, > > > > I hate to say this, but, DBD::Oracle (here) doesn't work with DBI > > 1.33... Dbd_discon_all needs to be defined. > > Thanks. What's the exact error message? I had the same problem with DBD::ODBC, BTW. I have to put out a 1.05 to be compatible with 1.33... I'm sure you've already fixed it internally, but I guess that adds a bit more incentive to release a newer DBD::Oracle. t\base...Driver has not implemented the disconnect_all method. at C:/Perl58/site/lib/DBI.pm line 600 END failed--call queue aborted. This is for all the tests, BTW. Regards, Jeff
Re: FAIL DBI-1.33 MSWin32-x86-multi-thread 4.0
Thanks. Known problem (due to windows time having less resolution). Will be fixed in the next release (in a day or so). Tim. On Fri, Feb 28, 2003 at 12:10:09AM -0800, DH wrote: > This distribution has been tested as part of the cpan-testers > effort to test as many new uploads to CPAN as possible. See > http://testers.cpan.org/ > > Please cc any replies to [EMAIL PROTECTED] to keep other > test volunteers informed and to prevent any duplicate effort. > > -- > > E:\new\DBI-1.33>perl Makefile.PL > > *** You are using a perl configured with threading enabled. > *** You should be aware that using multiple threads is > *** not recommended for production environments. > > *** Note: > The optional PlRPC-modules (RPC::PlServer etc) are not installed. > If you want to use the DBD::Proxy driver and DBI::ProxyServer > modules, then you'll need to install the RPC::PlServer, RPC::PlClient, > Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you. > You can install them any time after installing the DBI. > You do *not* need these modules for typical DBI usage. > > Optional modules are available from any CPAN mirror, in particular > http://www.perl.com/CPAN/modules/by-module > http://www.perl.org/CPAN/modules/by-module > ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module > > Creating extra DBI::PurePerl test: t/zz_01basics_pp.t > Creating extra DBI::PurePerl test: t/zz_02dbidrv_pp.t > Creating extra DBI::PurePerl test: t/zz_03hleak_pp.t > Creating extra DBI::PurePerl test: t/zz_04mods_pp.t > Creating extra DBI::PurePerl test: t/zz_05thrclone_pp.t > Creating extra DBI::PurePerl test: t/zz_06attrs_pp.t > Creating extra DBI::PurePerl test: t/zz_07kids_pp.t > Creating extra DBI::PurePerl test: t/zz_08keeperr_pp.t > Creating extra DBI::PurePerl test: t/zz_10examp_pp.t > Creating extra DBI::PurePerl test: t/zz_15array_pp.t > Creating extra DBI::PurePerl test: t/zz_20meta_pp.t > Creating extra DBI::PurePerl test: t/zz_30subclass_pp.t > Creating extra DBI::PurePerl test: t/zz_40profile_pp.t > Creating extra DBI::PurePerl test: t/zz_41prof_dump_pp.t > Creating extra DBI::PurePerl test: t/zz_42prof_data_pp.t > Creating extra DBI::PurePerl test: t/zz_60preparse_pp.t > Creating extra DBI::PurePerl test: t/zz_70shell_pp.t > Creating extra DBI::PurePerl test: t/zz_80proxy_pp.t > Checking if your kit is complete... > Looks good > Writing Makefile for DBI > > Remember to actually *read* the README file! > Use 'make' to build the software (dmake or nmake on Windows). > Then 'make test' to execute self tests. > Then 'make install' to install the DBI and then delete this working > directory before unpacking and building any DBD::* drivers. > > Windows users need to use the correct make command. > That may be nmake or dmake depending on which Perl you are using. > If using the Win32 ActiveState build then it is recommended that you > use the ppm utility to fetch and install a prebuilt DBI instead. > > E:\new\DBI-1.33>nmake test TEST_VERBOSE=1 > > Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 > Copyright (C) Microsoft Corp 1988-1998. All rights reserved. > > C:\Perl\bin\perl.exe -MExtUtils::Command -e mkpath blib\lib\DBI > C:\Perl\bin\perl.exe -MExtUtils::Command -e rm_f blib\lib\DBI\Changes.pm > C:\Perl\bin\perl.exe -MExtUtils::Command -e cp Changes > blib\lib\DBI\Changes.pm > cp Driver_xst.h blib\arch\auto\DBI\Driver_xst.h > cp lib/DBI/ProfileDumper.pm blib\lib\DBI/ProfileDumper.pm > cp DBIXS.h blib\arch\auto\DBI\DBIXS.h > cp lib/DBI/DBD/Metadata.pm blib\lib\DBI/DBD/Metadata.pm > cp lib/DBD/NullP.pm blib\lib\DBD/NullP.pm > cp dbipport.h blib\arch\auto\DBI\dbipport.h > cp lib/DBI/Format.pm blib\lib\DBI/Format.pm > cp lib/DBI/Const/GetInfoReturn.pm blib\lib\DBI/Const/GetInfoReturn.pm > cp dbd_xsh.h blib\arch\auto\DBI\dbd_xsh.h > cp lib/DBI/Const/GetInfo/ANSI.pm blib\lib\DBI/Const/GetInfo/ANSI.pm > cp lib/DBI/Profile.pm blib\lib\DBI/Profile.pm > cp lib/DBI/PurePerl.pm blib\lib\DBI/PurePerl.pm > cp lib/DBI/Shell.pm blib\lib\DBI/Shell.pm > cp lib/DBI/FAQ.pm blib\lib\DBI/FAQ.pm > cp DBI.pm blib\lib\DBI.pm > cp lib/DBD/ExampleP.pm blib\lib\DBD/ExampleP.pm > cp lib/Bundle/DBI.pm blib\lib\Bundle/DBI.pm > cp lib/Win32/DBIODBC.pm blib\lib\Win32/DBIODBC.pm > cp lib/DBI/W32ODBC.pm blib\lib\DBI/W32ODBC.pm > cp lib/DBI/DBD.pm blib\lib\DBI/DBD.pm > cp lib/DBI/ProfileData.pm blib\lib\DBI/ProfileData.pm > cp lib/DBI/Const/GetInfoType.pm blib\lib\DBI/Const/GetInfoType.pm > cp lib/DBI/ProxyServer.pm blib\lib\DBI/ProxyServer.pm > cp lib/DBD/Proxy.pm blib\lib\DBD/Proxy.pm > cp dbi_sql.h blib\arch\auto\DBI\dbi_sql.h > cp lib/DBI/ProfileDumper/Apache.pm blib\lib\DBI/ProfileDumper/Apache.pm > cp Driver.xst blib\arch\auto\DBI\Driver.xst > cp lib/DBI/Const/GetInfo/ODBC.pm blib\lib\DBI/Const/GetInfo/ODBC.pm > cp lib/DBD/Sponge.pm blib\lib\DBD/Sponge.pm > C:\Perl\bin\perl.exe -p -e "s/~DRIVER~/Perl/g" < >
Re: perl dbi sybase error handling question
"G S" <[EMAIL PROTECTED]> wrote:
> $retCode = $sth->execute() ||
> printf("# Trouble with dbh->execute():" .
> "dbh->err= '%s'" .
> "dbh->errstr= '%s'",
> $dbh->err,
> $dbh->errstr
> );
This is probably a precedence error.
It is interpreted as
$retCode = ($sth->execute() || printf( ... ) );
If you want to store the return value of $sth->execute() into $retcode,
use parenthese or use 'or' instead of '||' .
Hans
--
Hans Ranke [EMAIL PROTECTED]
Lehrstuhl fuer Institute for
Entwurfsautomatisierung Electronic Design Automation
Technische Universitaet Muenchen, Germany
Phone +49 89 289 23660 Fax +49 89 289 63666
FAIL DBI-1.33 MSWin32-x86-multi-thread 4.0
This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ Please cc any replies to [EMAIL PROTECTED] to keep other test volunteers informed and to prevent any duplicate effort. -- E:\new\DBI-1.33>perl Makefile.PL *** You are using a perl configured with threading enabled. *** You should be aware that using multiple threads is *** not recommended for production environments. *** Note: The optional PlRPC-modules (RPC::PlServer etc) are not installed. If you want to use the DBD::Proxy driver and DBI::ProxyServer modules, then you'll need to install the RPC::PlServer, RPC::PlClient, Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you. You can install them any time after installing the DBI. You do *not* need these modules for typical DBI usage. Optional modules are available from any CPAN mirror, in particular http://www.perl.com/CPAN/modules/by-module http://www.perl.org/CPAN/modules/by-module ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module Creating extra DBI::PurePerl test: t/zz_01basics_pp.t Creating extra DBI::PurePerl test: t/zz_02dbidrv_pp.t Creating extra DBI::PurePerl test: t/zz_03hleak_pp.t Creating extra DBI::PurePerl test: t/zz_04mods_pp.t Creating extra DBI::PurePerl test: t/zz_05thrclone_pp.t Creating extra DBI::PurePerl test: t/zz_06attrs_pp.t Creating extra DBI::PurePerl test: t/zz_07kids_pp.t Creating extra DBI::PurePerl test: t/zz_08keeperr_pp.t Creating extra DBI::PurePerl test: t/zz_10examp_pp.t Creating extra DBI::PurePerl test: t/zz_15array_pp.t Creating extra DBI::PurePerl test: t/zz_20meta_pp.t Creating extra DBI::PurePerl test: t/zz_30subclass_pp.t Creating extra DBI::PurePerl test: t/zz_40profile_pp.t Creating extra DBI::PurePerl test: t/zz_41prof_dump_pp.t Creating extra DBI::PurePerl test: t/zz_42prof_data_pp.t Creating extra DBI::PurePerl test: t/zz_60preparse_pp.t Creating extra DBI::PurePerl test: t/zz_70shell_pp.t Creating extra DBI::PurePerl test: t/zz_80proxy_pp.t Checking if your kit is complete... Looks good Writing Makefile for DBI Remember to actually *read* the README file! Use 'make' to build the software (dmake or nmake on Windows). Then 'make test' to execute self tests. Then 'make install' to install the DBI and then delete this working directory before unpacking and building any DBD::* drivers. Windows users need to use the correct make command. That may be nmake or dmake depending on which Perl you are using. If using the Win32 ActiveState build then it is recommended that you use the ppm utility to fetch and install a prebuilt DBI instead. E:\new\DBI-1.33>nmake test TEST_VERBOSE=1 Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. C:\Perl\bin\perl.exe -MExtUtils::Command -e mkpath blib\lib\DBI C:\Perl\bin\perl.exe -MExtUtils::Command -e rm_f blib\lib\DBI\Changes.pm C:\Perl\bin\perl.exe -MExtUtils::Command -e cp Changes blib\lib\DBI\Changes.pm cp Driver_xst.h blib\arch\auto\DBI\Driver_xst.h cp lib/DBI/ProfileDumper.pm blib\lib\DBI/ProfileDumper.pm cp DBIXS.h blib\arch\auto\DBI\DBIXS.h cp lib/DBI/DBD/Metadata.pm blib\lib\DBI/DBD/Metadata.pm cp lib/DBD/NullP.pm blib\lib\DBD/NullP.pm cp dbipport.h blib\arch\auto\DBI\dbipport.h cp lib/DBI/Format.pm blib\lib\DBI/Format.pm cp lib/DBI/Const/GetInfoReturn.pm blib\lib\DBI/Const/GetInfoReturn.pm cp dbd_xsh.h blib\arch\auto\DBI\dbd_xsh.h cp lib/DBI/Const/GetInfo/ANSI.pm blib\lib\DBI/Const/GetInfo/ANSI.pm cp lib/DBI/Profile.pm blib\lib\DBI/Profile.pm cp lib/DBI/PurePerl.pm blib\lib\DBI/PurePerl.pm cp lib/DBI/Shell.pm blib\lib\DBI/Shell.pm cp lib/DBI/FAQ.pm blib\lib\DBI/FAQ.pm cp DBI.pm blib\lib\DBI.pm cp lib/DBD/ExampleP.pm blib\lib\DBD/ExampleP.pm cp lib/Bundle/DBI.pm blib\lib\Bundle/DBI.pm cp lib/Win32/DBIODBC.pm blib\lib\Win32/DBIODBC.pm cp lib/DBI/W32ODBC.pm blib\lib\DBI/W32ODBC.pm cp lib/DBI/DBD.pm blib\lib\DBI/DBD.pm cp lib/DBI/ProfileData.pm blib\lib\DBI/ProfileData.pm cp lib/DBI/Const/GetInfoType.pm blib\lib\DBI/Const/GetInfoType.pm cp lib/DBI/ProxyServer.pm blib\lib\DBI/ProxyServer.pm cp lib/DBD/Proxy.pm blib\lib\DBD/Proxy.pm cp dbi_sql.h blib\arch\auto\DBI\dbi_sql.h cp lib/DBI/ProfileDumper/Apache.pm blib\lib\DBI/ProfileDumper/Apache.pm cp Driver.xst blib\arch\auto\DBI\Driver.xst cp lib/DBI/Const/GetInfo/ODBC.pm blib\lib\DBI/Const/GetInfo/ODBC.pm cp lib/DBD/Sponge.pm blib\lib\DBD/Sponge.pm C:\Perl\bin\perl.exe -p -e "s/~DRIVER~/Perl/g" < blib\arch\auto\DBI/Driver.xst > Perl.xsi C:\Perl\bin\perl.exe C:\Perl\lib\ExtUtils/xsubpp -typemap C:\Perl\lib\ExtUtils\typemap Perl.xs > Perl.xsc && C:\Perl\bin\perl.exe -MExtUtils::Command -e mv Perl.xsc Perl.c cl -c-nologo -O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DPER L_MSVCRT_READFI
DBD::Oracle::st not returning error retrieving CLOB's
When I $sth->fetch* a CLOB the following is sent to STDERR DBD::Oracle::st fetch failed: ERROR fetching field 2 of 1. LOB value truncated from 10347 to 80. DBI attribute LongReadLen too small and/or LongTruncOk not set at ./dumpdb.pl line 211. The problem is I can't get the error in my code. Somewhere in the depths of DBD::Oracle the error is getting lost. perl 5.00503 DBI 1.32 DBD::Oracle 1.12 Sun Solaris 5.7 Robert Stagg This email message and any attached files may contain information that is confidential and subject of legal privilege intended only for use by the individual or entity to whom they are addressed. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient be advised that you have received this message in error and that any use, copying, circulation, forwarding, printing or publication of this message or attached files is strictly forbidden, as is the disclosure of the information contained therein. If you have received this message in error, please notify the sender immediately and delete it from your Inbox.
perl dbi sybase error handling question
I don't understand something. I am executing a sybase stored procedure.
While testing, I am forcing various error conditions. In a couple cases I
am puzzled about the outcome.
Here is the execute statement. I was getting results I did not understand,
so I decided to capture $retCode and take a look at it. I also repeated the
printf statement so I could see err and errstr even when the error handler
was not executed.
# Execute query and handle error condition. Capture $retCode for later
examination.
$retCode = $sth->execute() ||
printf("# Trouble with dbh->execute():" .
"dbh->err= '%s'" .
"dbh->errstr= '%s'",
$dbh->err,
$dbh->errstr
);
# Examine $retCode, err, and errstr
print "after execute retCode is: $retCode ";
printf("dbh->execute():" .
"dbh->err= '%s'" .
"dbh->errstr= '%s'",
$dbh->err,
$dbh->errstr
);
scenario 1 --
Here is the output from successful execution. You can see that the error
handler part is not executed. $retCode is -1.
after execute retCode is: -1
dbh->execute():
dbh->err= ''
dbh->errstr= ''
scenario 2 --
Here I deliberately passed an incorrect data type as a parameter to the
stored procedure. As you can see, there was an error, but it was not caught
by the error handling code (after the "||"). It seems strange to me that
retCode is -1.
after execute retCode is: -1
dbh->execute():
dbh->err= '257'
dbh->errstr= 'Server message number=257 severity=16 state=1 line=0
server=SCATS1P_SQL procedure=sc_deal_update text=Implicit conversion from
datatype 'VARCHAR' to 'SMALLINT' is not allowed. Use the CONVERT function to
run this query.'
scenario 3 --
Here I deliberately changed the stored procedure name to an incorrect one.
This time the error handling code (after the "||") is executed. Oddly,
$retCode is 1. I would think that the error handler would get executed only
if $retCode is 0 or empty. What's going on here?
# Trouble with dbh->execute():
dbh->err= '2812'
dbh->errstr= 'Server message number=2812 severity=16 state=5 line=22
server=SCATS1P_SQL text=Stored procedure 's_deal_update' not found. Specify
owner.objectname or use sp_help to check whether the object exists (sp_help
may produce lots of output). '
after execute retCode is: 1
dbh->execute():
dbh->err= '2812'
dbh->errstr= 'Server message number=2812 severity=16 state=5 line=22
server=SCATS1P_SQL text=Stored procedure 's_deal_update' not found. Specify
owner.objectname or use sp_help to check whether the object exists (sp_help
may produce lots of output). '
Thanks!
_
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
Re: DBI-1.33 & DBD::Oracle 1.12
On Thu, Feb 27, 2003 at 05:01:56PM -0500, Jeff Urlwin wrote: > Tim, > > I hate to say this, but, DBD::Oracle (here) doesn't work with DBI 1.33... > Dbd_discon_all needs to be defined. Thanks. What's the exact error message? Tim.
Re: bind_param "success" when it should fail
On Thu, Feb 27, 2003 at 04:01:40PM -0500, Roels, Steven wrote:
>
> Tim,
>
> Did the following get fixed in 1.33? I didn't see it in the release
> notes, but its such a minor thing I wouldn't really expect to have seen
> it there.
It's a DBD::Oracle issue, not DBI.
Tim.
> >> Specifically, I had accidentally given bind_param an array reference
> >> rather than a scalar. I would expect (and this was the case with an
> >> earlier version of the DBI), to get an exception. Instead, although DBI
> >> seems to still consider it a mistake (you get the warning message about
> >> "Can't bind array reference..."), bind_param itself "succeeds" (returns
> >> true with raiseerror off, or does not throw an exception with raiseerror
> >> on).
> >>
> >> Thanks in advance,
> >>
> >> -Steve
> >>
> >> #!/usr/bin/perl -W
> >>
> >> use strict;
> >>
> >> use DBI;
> >>
> >> my $dbh = DBI->connect( "dbi:Oracle:#","##","",
> >> {AutoCommit => 0,RaiseError => 1,PrintError => 0,LongReadLen =>
> >> 500,LongTruncOk => 0});
> >>
> >> my $sql = "SELECT blah blah blah where mykey = ?";
> >>
> >> my $sth = $dbh->prepare($sql);
> >>
> >> $sth->bind_param(1,[1,2,3,4]);
> >>
> >> print "possible err: ",$sth->errstr(),"\n";
> >>
> >> print "I guess bind param went OK...\n";
> >>
> >> $sth->execute();
> >>
> >> $sth->finish();
> >>
> >> $dbh->disconnect();
Re: DBI 1.33 fail on Windows, ActiveState Perl 804 (5.8.0)
On Thu, Feb 27, 2003 at 12:52:24PM -0500, Jeff Urlwin wrote:
> Too many questions :)
:)
> > What's your operating system? (and perl -V output?)
> > And, out of interest, what's the spec of your machine?
> > (cpu/memory etc)
>
> Windows XP service pack 1.
> Pentium 4 (mobile), 2.2 Ghz
> 1 GB RAM
>
> > What does this say:
> > $ perl -MDBI=dbi_time -e '$a=dbi_time; 1 while (dbi_time eq
> > $a); $a=dbi_time;++$c while (dbi_time eq $a); warn
> > "$a\n$c\n".dbi_time' 1046365974.8218 1
> > 1046365974.82187
>
> I changed it to a separate script since I'm under windows and the
> command shell is a pain, but I don't think I changed semantics on it:
>
> use DBI qw(dbi_time);
> my $a=dbi_time;
> 1 while (dbi_time == $a);
> $a=dbi_time;
> ++$c while (dbi_time == $a);
> warn "$a\n$c\n".dbi_time;
>
> With eq
>
> 1046367427.69059
> 1058
> 1046367427.7006
>
> > The 1 in the middle line is often missing, meaning that
> > dbi_time produces a different value faster than the loop
> > loops. If I change the "eq"'s to "==" then I can't even get a
> > 1 to appear.
> >
>
> With ==
>
> 1046367479.27631
> 5547
> 1046367479.28632 at t.pl line 7.
Seems the problem is that Windows has a lower 'hi res' time resolution.
My machine only gets round the loop once between 'ticks' of the time
but your can do thousands of loops.
[...later...] Ah, I could have saved us the bother if I'd looked
at the code...
static double
dbi_time() {
# ifdef HAS_GETTIMEOFDAY
struct timeval when;
gettimeofday(&when, (struct timezone *) 0);
return when.tv_sec + (when.tv_usec / 100.0);
# else /* per-second is almost useless */
# ifdef _WIN32 /* use _ftime() on Win32 (MS Visual C++ 6.0) */
struct _timeb when;
_ftime( &when );
return when.time + (when.millitm / 1000.0);
# else
return time(NULL);
# endif
# endif
}
So windows _ftime only has millisecond resolution (whereas unix
gettimeofday has nanosecond resolution, at least in theory).
Okay, I'll add the loops to the tests and document the lower resolution on
Windows.
Could you do some experimentation for me to determine the smallest
numer of loops that avoid the problem on your system? I'll then use
some multiple of that as a safety margin. (Just email me direct and
include a copy of your edited test files. Thanks.)
Tim.
