Re: Another set of DBI docs
Tim Bunce wrote: On Wed, Aug 15, 2007 at 04:16:40PM -0700, Dean Arnold wrote: (Those who abhor javadocs should discard this message immediately...) Having greatly enjoyed playing with TiddlyWiki[1] for the new DBI FAQ, I'd *love* for someone to add a TiddlyWiki subclass to Pod::Simple::Wiki http://search.cpan.org/~jmcnamara/Pod-Simple-Wiki/ Hi, Ron Savage has added a TiddlyWiki filter to Pod::Simple::Wiki and it is now available on CPAN: http://search.cpan.org/~jmcnamara/Pod-Simple-Wiki/ I ran the main BDI documentation through the filter and loaded it into TiddlyWiki. It looks quite good. pod2wiki --style tiddlywiki DBI.pm DBI.txt John. --
Re: Test t/85gofer.t fails on m68k
Hello On 2007-08-20 Tim Bunce wrote: On Sun, Aug 19, 2007 at 07:35:28PM +0200, Christian Hammers wrote: Hello The Debian autobuilders for arm and m68k fail while trying test t/85gofer.t with the following messages: t/zvxgp_85gofer... # Failed test 'pipeone: DBI connect('transport=null;policy=pedantic;dsn=dbi:Gofer:transport=pipeone;policy=pedantic;perl=/usr/bin/perl -Mblib=/build/buildd/libdbi- perl-1.58/blib;timeout=10;dsn=dbi:DBM:dbm_type=SDBM_File;lockfile=0','',...) failed: DBD::Gofer receive_response timed-out after 10 seconds; DBI connect('transport=pipeone;policy=pedantic;perl=/usr/bin/perl -Mblib=/build/buildd/libdbi-perl-1.58/blib;timeout=10;dsn=dbi:DBM:dbm_type=SDBM_File;lockfile=0','',...) failed: DBD::Gofer receive_response timed-out after 10 seconds at /build/buildd/libdbi-perl-1.58/blib/lib/DBI/Gofer/Execute.pm line 194 at ./t/85gofer.t line 131 # ' # in ./t/85gofer.t at line 92. What could be the reason? The autobuilder usually uses some kind of chroot environment and the m68k one is certainly alsow very slow so it might hit a condition that is unusual on a normal desktop machine. Occams's razor: Could you hack the test to increase the timeout, so say 100, and try again? Did not help. But the m68k architecture is no longer officially supported by Debian, just autobuilded along with the other architectures, so it's no big deal :) bye, -christian- signature.asc Description: PGP signature
RE: perl date
I've created dbf files using DBD::XBase a few times. To get dates to insert correctly I had to have the date in MMDD format. DBD::Xbase writes dbase 4 files. If Clipper is old enough that it is using dbase 3 files the answer might be different. -Original Message- From: Samuel_Zheng [mailto:[EMAIL PROTECTED] Sent: Monday, August 27, 2007 8:45 AM To: dbi-users@perl.org Subject: perl date Hi, I am using ODBC to convert an old clipper application to a web based application and I came across something seems simple but it's not. how can I save a date from perl to a date field in dbf file? can a perl expert helps out someone who is novice in perl like me? your help would be very much appreciated! Thanks. Samuel
Oracle::DBD build issue
Hi, Building the DBD for Oracle on a Tru64 UNIX 4.0G server (alphaserver) under perl 5.8.8, I'm stuck on getting the test process working correctly. Looks like the build and compile work just fine, but the first test complains about a symbol not being found. I'm not sure what might be wrong. Any suggestions? The readme files were helpful, but have not resolved my issue. Thanks Bob Heres what I'm getting out as test results: Script started on Thu Aug 23 06:41:47 2007 # id uid=0(root) gid=1(daemon) groups=0(system),3(mem),7(terminal),9(opr),12(lp) # make test PERL_DL_NONLAZY=1 /usr/local/perl-5.8.8/bin/perl -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/01baseFailed to load Oracle extension and/or shared libraries: install_driver(Oracle) failed: Can't load '/home/robbro04/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: Unresolved symbol in /home/robbro04/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so: OCILobCreateTemporary at /usr/local/perl-5.8.8/lib/5.8.8/alpha-dec_osf/DynaLoader.pm line 230. at (eval 3) line 3 Compilation failed in require at (eval 3) line 3. Perhaps a required shared library or dll isn't installed where expected at t/01base.t line 19 The remaining tests will probably also fail with the same error. *** Please read the README and README.help.txt files for help. *** t/01baseok 1/5 t/01baseFAILED tests 4-5 Failed 2/5 tests, 60.00% okay t/10general.install_driver(Oracle) faile Bob Brown | Senior Unix Engineer | Systems Engineering Services | Robert Half International, Inc. | Pleasanton, CA | Office: 925-598-7796 | Mobile: 925-382-8753 | Fax: (925) 598-7947 | http://www.rhi.com ---BeginMessage--- Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration: Platform: osname=dec_osf, osvers=4.0, archname=alpha-dec_osf uname='osf1 hqpdx103 v4.0 1091 alpha ' config_args='-de' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef use64bitint=define use64bitall=define uselongdouble=undef Compiler: cc='cc', ccflags ='-std -fprm d -ieee -D_INTRINSICS -DLANGUAGE_C', optimize='-O4', cppflags='-std -ieee -D_INTRINSICS -DLANGUAGE_C' ccversion='V5.8-009', gccversion='', gccosandvers='' intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8 ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, usemymalloc=y, prototype=define Linker and Libraries: ld='ld', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /usr/shlib /usr/ccs/lib /usr/lib/cmplrs/cc /usr/lib /var/shlib libs=-ldbm -ldb -lm -liconv -lutil perllibs=-lm -liconv -lutil libc=/usr/shlib/libc.so, so=so, useshrplib=true, libperl=libperl.so Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' -Wl,-rpath,/usr/local/lib/perl5/5.6.1/alpha-dec_osf/CORE' cccdlflags=' ', lddlflags='-shared -expect_unresolved * -O4 -msym -std -s -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: USE_64_BIT_INT USE_64_BIT_ALL USE_LARGE_FILES Built under dec_osf Compiled at Feb 21 2002 13:21:01 @INC: /usr/local/lib/perl5/5.6.1/alpha-dec_osf /usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/alpha-dec_osf /usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl . Summary of my perl5 (revision 5 version 8 subversion 8) configuration: Platform: osname=dec_osf, osvers=4.0g, archname=alpha-dec_osf uname='osf1 hqpdx103 v4.0 1530 alpha ' config_args='' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=define d_sfio=undef uselargefiles=define usesocks=undef use64bitint=define use64bitall=define uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='cc', ccflags ='-std1 -noansi_alias -D_INTRINSICS -fprm d -ieee -I/usr/local/include -DLANGUAGE_C', optimize='-O4', cppflags='-std1 -noansi_alias -D_INTRINSICS -ieee -I/usr/local/include -DLANGUAGE_C' ccversion='V6.1-123', gccversion='', gccosandvers='' intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8 ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='ld', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /usr/shlib /usr/ccs/lib /usr/lib/cmplrs/cc /usr/lib /var/shlib libs=-ldbm -ldb -lm -lutil perllibs=-lm
Re: make test for DBI fails on Win98
On Mon, Aug 27, 2007 at 11:02:47PM +0200, Bart Lateur wrote: On Mon, 27 Aug 2007 10:17:16 +0100, Tim Bunce wrote: Try the appended patch and let me know if it works for you. Yes, after the patch all tests pass. Funny, CPAN.pm also recently introduced similar code with similar problems. Is this a conspiracy, or just thoughtlessness? :) I'm not sure ignoring Win98 can be called thoughtlessness these days. Umm, hardly worthy of a conspiracy either. :) Win98 has other typical solutions, such as: you can't open a file for output in 2 programs at the same time. Surely there must be a way to emulate flock on Win98, using an extra lock file... That way you'd only be covered for programs written in Perl, adhering to the same convention, but probably that should suffice. Just thinking out loud... Patches welcome at [EMAIL PROTECTED] ... Tim.
RE: Oracle::DBD build issue
Hi, Bob, I've met some (similar but not same) failed tests in my previous of DBD::Oracle installations. I eventually found out: 1. if it complains about libraries, the PATH environment variable of the user who is doing the installation might lack of something; 2. the Oracle account (ORACLE_USERID), say, the default 'scott/tiger', used in the testing does not have sufficient privillege to use some features in the database. Hope it helps you. Best, Alan From: Brown, Bob (HQP) [mailto:[EMAIL PROTECTED] Sent: Monday, August 27, 2007 4:25 PM To: dbi-users@perl.org Subject: Oracle::DBD build issue Hi, Building the DBD for Oracle on a Tru64 UNIX 4.0G server (alphaserver) under perl 5.8.8, I'm stuck on getting the test process working correctly. Looks like the build and compile work just fine, but the first test complains about a symbol not being found. I'm not sure what might be wrong. Any suggestions? The readme files were helpful, but have not resolved my issue. Thanks Bob Heres what I'm getting out as test results: Script started on Thu Aug 23 06:41:47 2007 # id uid=0(root) gid=1(daemon) groups=0(system),3(mem),7(terminal),9(opr),12(lp) # make test PERL_DL_NONLAZY=1 /usr/local/perl-5.8.8/bin/perl -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/01baseFailed to load Oracle extension and/or shared libraries: install_driver(Oracle) failed: Can't load '/home/robbro04/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: Unresolved symbol in /home/robbro04/DBD-Oracle-1.19/blib/arch/auto/DBD/Oracle/Oracle.so: OCILobCreateTemporary at /usr/local/perl-5.8.8/lib/5.8.8/alpha-dec_osf/DynaLoader.pm line 230. at (eval 3) line 3 Compilation failed in require at (eval 3) line 3. Perhaps a required shared library or dll isn't installed where expected at t/01base.t line 19 The remaining tests will probably also fail with the same error. *** Please read the README and README.help.txt files for help. *** t/01baseok 1/5 t/01baseFAILED tests 4-5 Failed 2/5 tests, 60.00% okay t/10general.install_driver(Oracle) faile Bob Brown | Senior Unix Engineer | Systems Engineering Services | Robert Half International, Inc. | Pleasanton, CA | Office: 925-598-7796 | Mobile: 925-382-8753 | Fax: (925) 598-7947 | http://www.rhi.com
Re: make test for DBI fails on Win98
On Mon, Aug 27, 2007 at 10:33:21AM -0700, Jeff Zucker wrote: Tim Bunce wrote: On Sun, Aug 26, 2007 at 11:41:08PM +0200, Bart Lateur wrote: t/41prof_dump.flock() unimplemented on this platform at Try the appended patch and let me know if it works for you. +my $HAS_FLOCK = do { local $@; eval { flock STDOUT, 0; 1 } }; While that's the method I use in DBD::File, there appear to be some phantom problems with it. I think that you can get a true value for that but still not be able to call flock(). So I get (rare) reports of tests hanging when flock() is called even if it is only called when $HAS_FLOCK is true. If I recall correctly, from users with NFS. With NFS and running the test in an NFS mounted filesystem, probably. NFS implementations can suffer problems with lock daemons. I'm not sure if there is a good solution. I've changed the code so the default can be overridden via an env var and callers can force use of non-use of flock. That'll do for now. Thanks Jeff. Tim.