Re: DBD::Informix test failure for lvarchar - bug found!
Dear Mr. Leffler, When I saw this Tuesday night, I thought... wow. Thanks so much for pursuing this bug report. I will feel more confident in using DBD::Informix, now that you have verified that this bug will not bite us in our present configuration (no lvarchar not null columns). I'm sure I speak for all DBD::Informix users: Thank you. -- Mark Abajian On Jun 12, 2007, at 11:01 PM, Jonathan Leffler wrote: Finally, after about 30 hours of hair tearing and hard work, I've isolated a pure ESQL/C version of this bug and demonstrated that it primarily afflicts 32-bit ports of Informix ESQL/C that come with CSDK 2.90 and 2.81 . It does not afflict most 64-bit ports (though 2.81.FC2 crashed with a core dump, as did 2.80.UC2), and it does not affect older ports (2.80.UC1 was OK). It did not reproduce on RHEL 4 running on Linux PPC-64 with CSDK 3.00.FC1(actually, a nightly build prior to that release). Finally, it only affects LVARCHAR NOT NULL, and only if the table is not a temporary table. Since I kept the server constant (IDS 10.00.UC5 running on Solaris 10), the problem is most likely in ESQL/C rather than IDS itself; if it is perchance in IDS, it is in the code that recognizes different versions of ESQL/C and somehow reacts differently. This bug is now idsdb00139040 in the IBM/Informix CQ database. Sadly, as yet, I do not have a workaround or fix for this -- that comes next. To say that the circumstances under which it fails are obscure is to be excessively polite. I tried to release an update to DBD::Informix, but the release process goes through the test suite, and since the test t/t93lvarchar.t was failing, it was not possible to make the release automatically, so I haven't made the update. I may decide to cheat and make the release using a 64-bit Perl and 64-bit ESQL/C, like I did with the DBD::Informix 2007.0226 (though that was released completely unaware of the issue - this one would be released despite knowing the test fails). The temptation to modify the test (eg to use a temp table instead of a permanent one) is also quite considerable. -- Jonathan Leffler <[EMAIL PROTECTED]> #include Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused."
Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked
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=. 01 ok 19 - tmp1=999000 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/ > >> 01baseok > >> 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.t2 512332 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
RE: Oracle.so
Thanks John and Mike. I was trying to run it through the cron so the required environment was not being set correctly. I have fixed that and all is working again. Thanks. Peter -Original Message- From: John Scoles [mailto:[EMAIL PROTECTED] Sent: Thursday, June 14, 2007 11:09 AM To: Loo, Peter # PHX; dbi-users@perl.org Subject: Re: Oracle.so You most likly are not pointing to the correct Oracle path. You are pointing to most-likely the 64 bit so lisb file rather than the 32 bit so libs that DBD::Oracle requires. here are some links to similar problems http://www.issociate.de/board/goto/790359/Can't_load_Oarcle.so.html http://www.nntp.perl.org/group/perl.dbi.users/2006/11/msg30509.html - Original Message - From: "Loo, Peter # PHX" <[EMAIL PROTECTED]> To: Sent: Thursday, June 14, 2007 1:53 PM Subject: Oracle.so Hi, The same program that ran successfully yesterday is failing with the following error today. Can someone please shed some light what this error means? ERROR: Connection failed to x for user x. install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.7/s un4-solaris/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: GSQL.pl: fatal: /opt/app/oracle/product/10.2/lib/libclntsh.s o.10.1: wrong ELF class: ELFCLASS64 at /usr/local/lib/perl5/5.8.7/sun4-solaris/DynaLoader.pm line 230. at (eval 14) line 3 Compilation failed in require at (eval 14) line 3. Perhaps a required shared library or dll isn't installed where expected Thanks. Peter This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message.
Re: Oracle.so
You most likly are not pointing to the correct Oracle path. You are pointing to most-likely the 64 bit so lisb file rather than the 32 bit so libs that DBD::Oracle requires. here are some links to similar problems http://www.issociate.de/board/goto/790359/Can't_load_Oarcle.so.html http://www.nntp.perl.org/group/perl.dbi.users/2006/11/msg30509.html - Original Message - From: "Loo, Peter # PHX" <[EMAIL PROTECTED]> To: Sent: Thursday, June 14, 2007 1:53 PM Subject: Oracle.so Hi, The same program that ran successfully yesterday is failing with the following error today. Can someone please shed some light what this error means? ERROR: Connection failed to x for user x. install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.7/s un4-solaris/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: GSQL.pl: fatal: /opt/app/oracle/product/10.2/lib/libclntsh.s o.10.1: wrong ELF class: ELFCLASS64 at /usr/local/lib/perl5/5.8.7/sun4-solaris/DynaLoader.pm line 230. at (eval 14) line 3 Compilation failed in require at (eval 14) line 3. Perhaps a required shared library or dll isn't installed where expected Thanks. Peter
Re: Oracle.so
Hi, Did you compile/installed with the 32bit libclntsh and now you are pointing it at the 64bit version of the library so you are getting a 64bit library warning? o.10.1: wrong ELF class: ELFCLASS64 at Did your library path or oracle_home changed? Michael On Thu, 14 Jun 2007, Loo, Peter # PHX wrote: Date: Thu, 14 Jun 2007 10:53:15 -0700 From: "Loo, Peter # PHX" <[EMAIL PROTECTED]> To: dbi-users@perl.org Subject: Oracle.so Hi, The same program that ran successfully yesterday is failing with the following error today. Can someone please shed some light what this error means? ERROR: Connection failed to x for user x. install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.7/s un4-solaris/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: GSQL.pl: fatal: /opt/app/oracle/product/10.2/lib/libclntsh.s o.10.1: wrong ELF class: ELFCLASS64 at /usr/local/lib/perl5/5.8.7/sun4-solaris/DynaLoader.pm line 230. at (eval 14) line 3 Compilation failed in require at (eval 14) line 3. Perhaps a required shared library or dll isn't installed where expected Thanks. Peter -- ---//--- "He who learns must suffer. And even in our sleep, pain that cannot forget, falls drop by drop upon the heart; and, in our own despair, against our will, comes wisdom to us by the awful grace of God." --- Aeschylus
RE: Oracle.so
Did you set SHLIB_PATH, LD_LIBRARY_PATH, and LD_RUN_PATH? -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Thursday, June 14, 2007 1:53 PM To: dbi-users@perl.org Subject: Oracle.so Hi, The same program that ran successfully yesterday is failing with the following error today. Can someone please shed some light what this error means? ERROR: Connection failed to x for user x. install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.7/s un4-solaris/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: GSQL.pl: fatal: /opt/app/oracle/product/10.2/lib/libclntsh.s o.10.1: wrong ELF class: ELFCLASS64 at /usr/local/lib/perl5/5.8.7/sun4-solaris/DynaLoader.pm line 230. at (eval 14) line 3 Compilation failed in require at (eval 14) line 3. Perhaps a required shared library or dll isn't installed where expected Thanks. Peter
Oracle.so
Hi, The same program that ran successfully yesterday is failing with the following error today. Can someone please shed some light what this error means? ERROR: Connection failed to x for user x. install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.7/s un4-solaris/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: GSQL.pl: fatal: /opt/app/oracle/product/10.2/lib/libclntsh.s o.10.1: wrong ELF class: ELFCLASS64 at /usr/local/lib/perl5/5.8.7/sun4-solaris/DynaLoader.pm line 230. at (eval 14) line 3 Compilation failed in require at (eval 14) line 3. Perhaps a required shared library or dll isn't installed where expected Thanks. Peter
Re: DBD-Oracle VARRAY not supported
Well I have had a look into it and I do not think there is anything in DBD::Oracle we have to do to make varray work as it is simple SQL and is handled at the OCI level of the SQL commnd For example the following script works without any issues. #!/usr/local/bin/perl#use DBI;use strict;use vars qw($dbh $sth $sql); $dbh = DBI->connect('dbi:Oracle:','[EMAIL PROTECTED]','xxx');$dbh->do("DROP TABLE GAS_LOG");$dbh->do("DROP TYPE GAS_LOG_VA");$dbh->do("DROP TYPE GAS_LOG_TY");$dbh->do("CREATE TYPE GAS_LOG_TY AS OBJECT (GALLONS NUMBER,FILLUP_DATE DATE,GAS_STATION VARCHAR2(255))");$dbh->do("CREATE TYPE GAS_LOG_VA AS VARRAY(100) OF GAS_LOG_TY");$dbh->do("CREATE TABLE GAS_LOG (VINNUMBER NOT NULL,GAS_LOGGAS_LOG_VA)");$dbh->do("insert into gas_log values (101010101010101, gas_log_va(gas_log_ty(32,sysdate-1,'Shell')))");$dbh->do("insert into gas_log values (222, gas_log_va(gas_log_ty(27,sysdate-1,'Texaco')))");$dbh->do("insert into gas_log values (321321321321321, gas_log_va( gas_log_ty(45,sysdate-10,'Diamond Shamrock'), gas_log_ty(31,sysdate-9,'Shell'), gas_log_ty(32,sysdate-8,'Shell'), gas_log_ty(33,sysdate-7,'Texaco'), gas_log_ty(34,sysdate-6,'Texaco'), gas_log_ty(35,sysdate-5,'Diamond Shamrock')))");$sql='select a.vin,var.* from gas_log a, table(gas_log) var';$sth=$dbh->prepare($sql);$sth->execute();my $values = $sth->fetchall_arrayref();print_time("Test 1 mid:"); foreach my $r_value (@$values ){ print $r_value->[0].",".$r_value->[1].",".$r_value->[2].",".$r_value->[3]."\n";}There may be permission isssues with the user who is connecting that took me a little while to figure out. Otherwise I think you can get all your data using plain SQL It is just a matter of syntax - Original Message - From: "Charles Pareto" <[EMAIL PROTECTED]> To: "'John Scoles'" <[EMAIL PROTECTED]> Cc: ; <[EMAIL PROTECTED]> Sent: Wednesday, June 06, 2007 12:18 PM Subject: RE: DBD-Oracle VARRAY not supported Sure, here is my example- I'm declaring a column as type varray like this: "CREATE TYPE phone as varray(20) of varchar2(30)" I then insert phone numbers into the varray like this: insert into ADDRESS values (phone('949-933-5680', '949-600-5866', '949-699-3608')) This creates a column of varray where I can store up to 20 phone numbers in that one column field. When I select this column to see my phone numbers I will see this: PHONE PHONE('949-933-5680', '949-600-5866', '949-699-3608') When I try and return this column using DBD-Oracle with the statement "select phone from address" I get the error message like below. prepare failed: ERROR OCIDefineObject call needed but not implemented yet [for Statement "select phone from address"] I read somewhere that objects aren't implemented in DBD-Oracle and this is what I'm trying to find out. Thanks, Chuck Charles Pareto Brand Protection Engineer [EMAIL PROTECTED] 408-525-5505 -Original Message- From: John Scoles [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 06, 2007 3:46 AM To: [EMAIL PROTECTED] Cc: dbi-users@perl.org Subject: Re: DBD-Oracle VARRAY not supported 'varray' haven't hear of that in years. At least not since Nested Tables came along . I aways thoght they were for PL/SQL only. I will have a look at them later this week. I am just wondering how one want to look at the data in DBI?? Can you give me a quick working example of what you want to do and an example of what you want to see in the end? cheers John Scoles - Original Message - From: "Tim Bunce" <[EMAIL PROTECTED]> To: "Charles Pareto" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; Sent: Wednesday, June 06, 2007 4:39 AM Subject: Re: DBD-Oracle VARRAY not supported On Tue, Jun 05, 2007 at 05:03:23PM -0700, Charles Pareto wrote: Hi Tim, [...] All I'm looking for is a way to select a column that is defined as type varray. Is there any way this can be accomplished using DBD-Oracle or anything else? For simple data you could use SQL statements to convert the info into a string. There are probably better ways (returning ref cursor, pipelined function etc) but I'm a little out of touch with Oracle these days. Check google and the archives. Of course, the best option would be to implement proper support for varrays. That's probably not to difficult. I'll say "patches welcome" on behalf of Pythian, who are the lead maintainers. Tim. p.s. Don't use cpanforum. Very few people read it. The dbi-users@perl.org list is the best place to get help.
Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked
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]> 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: 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/ 01baseok 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.t2 512332 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
Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked
Opps checkeing the error msg and the code seems I have already fixed that one a while back so it might be like this one http://www.nntp.perl.org/group/perl.dbi.users/2006/11/msg30463.html Same client as you so it might be a bug in Oracle client??? Cannot test directly but I will see if I can patch for 10 clients and it you could test it would be great cheers John Scoles - Original Message - From: "John Scoles" <[EMAIL PROTECTED]> To: ; <[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: 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/ 01baseok 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.t2 512332 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)]
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: 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/ 01baseok 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.t2 512332 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
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/ 01baseok 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.t2 512332 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?)