Thanks, Jonathan. I did install it and everything seems to be working fine. Also, one of our developers ran the *.t files outside of the TestHarness.pm module and everything ran smoothly. Thanks for all your help!
-----Original Message----- From: Jonathan Leffler [mailto:jleffler@;us.ibm.com] Sent: Tuesday, November 05, 2002 9:54 AM To: Jonathan Leffler Cc: '[EMAIL PROTECTED]'; Gelbolingo, Arlene - MLG Subject: Re: DBD::Informix Install Problem on HP-UX 11.00 & INFORMIX-ESQL Version 9.51.HC3 Dear Arlene, I've confirmed to my own satisfaction that the problem occurs when DBDATE is set to a non-default value such as "Y4MD-" when the server is booted, and no value is set for DBDATE in the client environment. This is a legitimate setup (though not one I particularly recommend), so I need to fix my test code so that it works OK even in this scenario. Your build of DBD::Informix is OK - install and use it. -- Jonathan Leffler ([EMAIL PROTECTED]) STSM, Informix Database Engineering, IBM Data Management Solutions 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" |---------+----------------------------> | | Jonathan Leffler | | | <jleffler@earthli| | | nk.net> | | | | | | 11/04/2002 09:03 | | | PM | | | | |---------+----------------------------> >--------------------------------------------------------------------------- ------------------------------------------------------------------| | | | To: "Gelbolingo, Arlene - MLG" <[EMAIL PROTECTED]> | | cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, Jonathan Leffler/Menlo Park/IBM@IBMUS | | Subject: Re: DBD::Informix Install Problem on HP-UX 11.00 & INFORMIX-ESQL Version 9.51.HC3 | | | | | >--------------------------------------------------------------------------- ------------------------------------------------------------------| Gelbolingo, Arlene - MLG wrote: > I ran into some problems while installing DBI on our new system. At first > it was a class A failure but after I changed esql's COPTS variable to "", I > was able to create a Makefile and run "make" and "make test". Some tests > failed though during the "make test" run. I followed the steps on creating > a bug report, please see attached file. > > <<bugreport.zip>> Thanks, > > Arlene Gelbolingo > System Administrator > Menlo Worldwide > (p) 503.450.8691 > (c) 503.860.5423 > (f) 503.450.8664 Dear Arlene, Thanks for using the bugreport tool. I'm slightly surprised that you chose to run t/t75blob.t (which is skipped) rather than t/t65updcur.t (which failed); it makes it more difficult to diagnose the problem. However, the vast majority of the code is working, and I'd be willing to guess that the problem is actually a test error due to some particular property of your environment rather than a major problem in DBD::Informix. If the trouble had been in the main code, the failures would have been much more spectacular. t/t65updcur.........DBD::Informix::db do failed: SQL: -1218: String to date conversion error at blib/lib/DBD/Informix/TestHarness.pm line 219. !! Terminating Test !! dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 3-13 Failed 11/13 tests, 15.38% okay t/t72blob...........ok t/t73blob...........ok t/t74blob...........ok t/t75blob...........skipped test on this platform The error message implies that the code that tried to determine the correct format for dates failed. Since your environment includes no locale indicating variables (specifically, none of DBDATE, CLIENT_LOCALE, SERVER_LOCALE, LANG, LC_ALL, LC_TIME). I'm a little puzzled. I wonder - could your database server have been started by someone with DBDATE set to a non-default value (not MDY4/)? That may be tricky to determine unless you run a stored procedure which uses the SYSTEM statement to record the environment in a temporary file: CREATE PROCEDURE server_environment() SYSTEM "env >/tmp/env.out"; END PROCEDURE; EXECUTE PROCEDURE server_environment(); I have had similar errors reported once before, several years ago, and I either never got to the bottom of the issue or have forgotten what the resolution was. Maybe I need to be a bit more down to earth about determining the correct date format, doing something like: SELECT MDY(10, 20, 1930) FROM "informix".systables WHERE tabid = 1; and analysing the string that is returned -- which is unambiguous. Anyway, I would have very few qualms about installing DBD::Informix, though I certainly don't like that you've run into the problem. Please note the one FAQ on DBD::Informix at http://xmlproj.com/cgi/fom.cgi -- Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED]) #include <disclaimer.h> Guardian of DBD::Informix 1.00.PC2 -- http://dbi.perl.org/
