Thanks for all the replies, John.
I tried to use your patch of 10general.t, it did skip the first two
tests so no more complaints about the wrong return values from exit.
But the test 20 and 21 still failed, the errors seem to be Oracle
doesn't have the Procedural option installed (http://ora-00900.ora-
code.com/). I'm not sure what that means.
The output of the test of new patch of 10general.t is as the
following:
# perl -Mblib t/10general.t
Name "main::Config" used only once: possible typo at t/10general.t
line 28.
1..33
ok 1 # skip not unix-like
ok 2 # skip not unix-like
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18 - tmp0=.
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001
ok 19 -
tmp1=999999999990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
ok 20 - eval error: ``DBD::Oracle::db do failed: ORA-00900: invalid
SQL statement (DBD ERROR: OCIStmtExecute) [for Statement "some invalid
sql statement"] at t/10general.t line 82.
# '' expected 'do failed:'
ok 21 - warn error: ``DBD::Oracle::db do failed: ORA-00900: invalid
SQL statement (DBD ERROR: OCIStmtExecute) [for Statement "some invalid
sql statement"] at t/10general.t line 82.
# '' expected 'do failed:'
ok 22
not ok 23
# Failed test in t/10general.t at line 88.
not ok 24
# Failed test in t/10general.t at line 89.
# got: undef
# expected: '900'
ok 25
ok 26
ok 27
ok 28
ORA_OCI = 10 (10.2.0.1)
ok 29
ok 30
ok 31
ok 32
ok 33
# Looks like you failed 2 tests of 33.
On Jun 14, 6:49 am, [EMAIL PROTECTED] (John Scoles) wrote:
> Try this patch on 10general.t and see what comes up.
>
> It should skip the test.
>
> I do not have access to a solaris box so it is going to be a hit or miss
> sort of thing.
>
> Cheers
>
> use DBD::Oracle qw(ORA_OCI);
> unshift @INC ,'t';
> require 'nchar_test_lib.pl';
>
> $| = 1;
>
> plan tests => 33;
>
> my $dsn = oracle_test_dsn();
> my $dbuser = $ENV{ORACLE_USERID} || 'scott/tiger';
> ++my $dbh = DBI->connect($dsn, $dbuser, '');
>
> unless($dbh) {
> BAILOUT("Unable to connect to Oracle ($DBI::errstr)\nTests skiped.\n");
> exit 0;
>
> }
>
> my($sth, $p1, $p2, $tmp);
> SKIP: {
> skip "not unix-like", 2 unless $Config{d_semctl};
> ++ skip "solaris with OCI>9.x", 2 unless ($^O eq "solaris") and
> (scalar(ORA_OCI) ge 10);
>
> # basic check that we can fork subprocesses and wait for the status
> # after having connected to Oracle
>
> is system("exit 1;"), 1<<8, 'system exit 1 should return 256';
> is system("exit 0;"), 0, 'system exit 0 should return 0';
>
>
>
> }
> ----- Original Message -----
> From: "John Scoles" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, June 14, 2007 6:38 AM
> Subject: Re: DBD::Oracle installation - make test failed - ORA-28000: accout
>
> locked
>
> > seems this is a bug in the code when dealing with Solaris. So I would just
> > ignore it for now
>
> > here is a link to it
>
> >http://www.nntp.perl.org/group/perl.dbi.dev/2006/01/msg4401.html
>
> > I will see if I can patch DBD.Oracle and then forward it on.
>
> > ----- Original Message -----
> > From: <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, June 13, 2007 2:41 PM
> > Subject: Re: DBD::Oracle installation - make test failed - ORA-28000:
> > accout locked
>
> >> Thanks, Philip. I was eventually aware of that while I was reading the
> >> README. I then set the ORACLE_USERID to a valid Oracle account, and a
> >> 'make realclean' before I start the whole installation over. Most of
> >> the tests went OK but I still got two (and only two) other tests
> >> failed:
>
> >> # make test
> >> PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
> >> "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> >> t/
> >> 01base................ok
> >> t/10general.............NOK
> >> 1
> >> # Failed test 'system exit 1 should return 256'
> >> # in t/10general.t at line 31.
> >> # got: '-1'
> >> # expected: '256'
> >> t/10general.............NOK
> >> 2
> >> # Failed test 'system exit 0 should return 0'
> >> # in t/10general.t at line 32.
> >> # got: '-1'
> >> # expected: '0'
> >> t/10general.............ok 13/33# Looks like you failed 2 tests of
> >> 33.
> >> t/
> >> 10general.............dubious
> >> Test returned status 2 (wstat 512, 0x200)
> >> DIED. FAILED tests 1-2
> >> Failed 2/33 tests, 93.94% okay
> >> ......
> >> ......
> >> Failed Test Stat Wstat Total Fail Failed List of Failed
> >> -------------------------------------------------------------------------------
> >> t/10general.t 2 512 33 2 6.06% 1-2
> >> 4 tests and 122 subtests skipped.
> >> Failed 1/20 test scripts, 95.00% okay. 2/1925 subtests failed, 99.90%
> >> okay.
> >> make: *** [test_dynamic] Error 29
>
> >> And the output of 'perl Makefile.PL', 'make', and 'perl -V' as
> >> suggested in the README:
> >> ###################
> >> # perl Makefile.PL
> >> Using DBI 1.56 (for perl 5.008008 on sun4-solaris) installed in /usr/
> >> local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/
>
> >> Configuring DBD::Oracle for perl 5.008008 on solaris (sun4-solaris)
>
> >> Remember to actually *READ* the README file! Especially if you have
> >> any problems.
>
> >> Using Oracle in /u01/oracle/product/10.2.0
> >> DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
> >> Oracle version 10.2.0.1 (10.2)
> >> Found /u01/oracle/product/10.2.0/rdbms/demo/demo_rdbms.mk
> >> Using /u01/oracle/product/10.2.0/rdbms/demo/demo_rdbms.mk
> >> Your LD_LIBRARY_PATH env var is set to ':/usr/lib:/usr/openwin/lib:/
> >> opt/hpnp/lib:/usr/local/sir40:/u01/oracle/product/10.2.0/lib32'
> >> Reading /u01/oracle/product/10.2.0/rdbms/demo/demo_rdbms.mk
> >> Reading /u01/oracle/product/10.2.0/rdbms/lib/env_rdbms.mk
>
> >> Attempting to discover Oracle OCI build rules
> >> gcc -c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c
> >> by executing: [make -f /u01/oracle/product/10.2.0/rdbms/demo/
> >> demo_rdbms.mk build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh'
> >> CC=true OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
> >> Oracle oci build command:
> >> [true -xarch=v9 -L/u01/oracle/product/10.2.0/lib/ -L/u01/
> >> oracle/product/10.2.0/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -
> >> lclntsh `cat /u01/oracle/product/10.2.0/lib/sysliblist` -R/u01/
> >> oracle/product/10.2.0/lib -laio -lposix4 -lkstat -lm -lthread -
> >> lpthread]
>
> >> Found header files in /u01/oracle/product/10.2.0/rdbms/public.
>
> >> Checking for functioning wait.ph
>
> >> System: perl5.008008 sunos 5.9 generic sun4u sparc sunw,ultra-5_10
> >> solaris
> >> Compiler: gcc -O -fno-strict-aliasing -pipe -Wdeclaration-after-
> >> statement -I/usr/local/include -D_LARGEFILE_SOURCE -
> >> D_FILE_OFFSET_BITS=64
> >> Linker: /usr/local/bin/ld
> >> Sysliblist: -lkstat -lnsl -lsocket -lgen -ldl -lsched
> >> Oracle makefiles would have used these definitions but we override
> >> them:
> >> CC: cc
> >> CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
> >> $(SHARED_CFLAG) $(USRFLAGS)
> >> [$(GFLAG) -xO3 $(CDEBUG) -Xa $(PROFILE) -xstrconst -dalign -
> >> xF $(XS) $(MR) -xildoff -errtags=yes -v -xarch=v9 -xchip=ultra3 -W2,-
> >> AKNR_S -Wd,-xsafe=unboundsym -Wc,-Qiselect-funcalign=32 -xcode=abs44 -
> >> Wc,-Qgsched-trace_late=1 -Wc,-Qgsched-T5 -xalias_level=weak -
> >> D_REENTRANT -DSS_64BIT_SERVER -DBIT64 -DMACHINE64 -K PIC -I/u01/oracle/
> >> product/10.2.0/rdbms/demo -I/u01/oracle/product/10.2.0/rdbms/public -I/
> >> u01/oracle/product/10.2.0/plsql/public -I/u01/oracle/product/10.2.0/
> >> network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD -
> >> D_REENTRANT $(LPFLAGS) $(USRFLAGS)]
> >> LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
> >> [-o $@ -L/u01/oracle/product/10.2.0/rdbms/lib/ -L$
> >> (LIBHOME)]
> >> Linking with OTHERLDFLAGS = -xarch=v9 -L/u01/oracle/product/10.2.0/
> >> lib/ -L/u01/oracle/product/10.2.0/rdbms/lib/ -lclntsh `cat /u01/
> >> oracle/product/10.2.0/lib/sysliblist` -R/u01/oracle/product/10.2.0/lib
> >> -laio -lposix4 -lkstat -lm -lthread -lpthread [from 'build' rule]
>
> >> WARNING: If you have problems you may need to rebuild perl with
> >> threading enabled.
> >> Checking if your kit is complete...
> >> Looks good
> >> LD_RUN_PATH=/u01/oracle/product/10.2.0/lib32:/u01/oracle/product/
> >> 10.2.0/rdbms/lib32
> >> Using DBD::Oracle 1.19.
> >> Using DBD::Oracle 1.19.
> >> Using DBI 1.56 (for perl 5.008008 on sun4-solaris) installed in /usr/
> >> local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/
> >> Writing Makefile for DBD::Oracle
>
> >> *** If you have problems...
> >> read all the log printed above, and the README and
> >> README.help.txt files.
> >> (Of course, you have read README by now anyway, haven't you?)
>
> >> #################################
> >> # make
> >> cp Oracle.pm blib/lib/DBD/Oracle.pm
> >> cp mkta.pl blib/lib/DBD/mkta.pl
> >> cp oraperl.ph blib/lib/oraperl.ph
> >> cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
> >> cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
> >> cp Oraperl.pm blib/lib/Oraperl.pm
> >> cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
> >> cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
> >> cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
> >> /usr/local/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/local/lib/perl5/
> >> site_perl/5.8.8/sun4-solaris/auto/DBI/Driver.xst > Oracle.xsi
> >> /usr/local/bin/perl /usr/local/lib/perl5/5.8.8/ExtUtils/xsubpp -
> >> typemap /usr/local/lib/perl5/5.8.8/ExtUtils/typemap -typemap typemap
> >> Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
> >> gcc -c -I/u01/oracle/product/10.2.0/rdbms/public -I/u01/oracle/
> >> product/10.2.0/rdbms/demo -I/u01/oracle/product/10.2.0/rdbms/public -I/
> >> u01/oracle/product/10.2.0/plsql/public -I/u01/oracle/product/10.2.0/
> >> network/public -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/
> >> auto/DBI -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/
> >> usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -
> >> DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/local/lib/
> >> perl5/5.8.8/sun4-solaris/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -
> >> DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" Oracle.c
> >> gcc -c -I/u01/oracle/product/10.2.0/rdbms/public -I/u01/oracle/
> >> product/10.2.0/rdbms/demo -I/u01/oracle/product/10.2.0/rdbms/public -I/
> >> u01/oracle/product/10.2.0/plsql/public -I/u01/oracle/product/10.2.0/
> >> network/public -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/
> >> auto/DBI -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/
> >> usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -
> >> DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/local/lib/
> >> perl5/5.8.8/sun4-solaris/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -
> >> DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" dbdimp.c
> >> gcc -c -I/u01/oracle/product/10.2.0/rdbms/public -I/u01/oracle/
> >> product/10.2.0/rdbms/demo -I/u01/oracle/product/10.2.0/rdbms/public -I/
> >> u01/oracle/product/10.2.0/plsql/public -I/u01/oracle/product/10.2.0/
> >> network/public -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/
> >> auto/DBI -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/
> >> usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -
> >> DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/local/lib/
> >> perl5/5.8.8/sun4-solaris/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -
> >> DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" oci8.c
> >> Running Mkbootstrap for DBD::Oracle ()
> >> chmod 644 Oracle.bs
> >> rm -f blib/arch/auto/DBD/Oracle/Oracle.so
> >> LD_RUN_PATH="/u01/oracle/product/10.2.0/lib32:/u01/oracle/product/
> >> 10.2.0/rdbms/lib32" gcc -G -L/usr/local/lib Oracle.o dbdimp.o oci8.o -
> >> xarch=v9 -L/u01/oracle/product/10.2.0/lib/ -L/u01/oracle/product/
> >> 10.2.0/rdbms/lib/
>
> ...
>
> read more »- Hide quoted text -
>
> - Show quoted text -
