Skip Menu |

This queue is for tickets about the DBD-Informix CPAN distribution.

Report information
The Basics
Id: 34490
Status: resolved
Worked: 10 min
Priority: 0/
Queue: DBD-Informix
People
Owner: j.leffler [...] acm.org
Requestors: Allen.Sutton [...] maf.govt.nz
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Thu Mar 27 20:23:24 2008 Allen.Sutton [...] maf.govt.nz - Ticket created
Subject: Bug installing DBD::Informix on Ubuntu Hardy Heron Alpha
Date: Fri, 28 Mar 2008 13:22:13 +1300
To: <bug-DBD-Informix [...] rt.cpan.org>
From: "Allen Sutton" <Allen.Sutton [...] maf.govt.nz>
Hi I hav successfully installed the Informix Client SDK 3.00UC3 onto a VM Ware Machine running Ubuntu Hardy Heron (8.04) Alpha I then set up environment variables to access the stores DB on the database instance Got to the make stage of installation of DBD::Informix and got the following results 1. perl Makefile.PL *** ExtUtils::AutoInstall version 0.63 *** Checking for dependencies... [Core Features] - DBI ...loaded. (1.604 >= 1.38) [High Resolution Timing] - Time::HiRes ...loaded. (1.9712) [POD Format Testing] - Test::Pod ...loaded. (1.26) *** ExtUtils::AutoInstall configuration finished. Configuring IBM Informix Database Driver for Perl DBI Version 2008.0229 (2008-02-29) (aka DBD::Informix) You are using DBI version 1.604 and Perl version 5.008008 Remember to actually read the README file! Perl: /usr/bin/perl v5.008008 i486-linux-gnu-thread-multi dl_dlopen.xs System: linux palmer 2.6.15.7 #1 smp thu sep 7 19:42:20 utc 2006 i686 gnulinux *** Ideally, you should upgrade to Perl version 5.010000 or later. Using INFORMIXDIR=/opt/informix and ESQL/C compiler esql Using IBM Informix CSDK Version 3.00, IBM Informix-ESQL Version 3.00.UC3DE from /opt/informix Beware: DBD::Informix is not yet aware of all the new IUS data types. Assert macro will be disabled! lib/DBD/Informix/Defaults.pm written OK esqlinfo.h written OK Testing whether your Informix test environment will work... ESQLTEST Program Running: @(#)$Id: esqltest.ec,v 2007.3 2007/06/09 23:19:15 jleffler Exp $ $INFORMIXDIR is set to '/opt/informix'. $INFORMIXSERVER is set to 'asd2_dev'. $DBI_DBNAME unset - defaulting to 'stores'. $DBD_INFORMIX_DATABASE set to 'stores'. $DBD_INFORMIX_DATABASE2 unset - defaulting to 'stores'. $DBD_INFORMIX_USERNAME is set to 'paqis'. $DBD_INFORMIX_USERNAME2 is unset - defaulting to 'paqis'. $DBD_INFORMIX_PASSWORD is set. $DBD_INFORMIX_PASSWORD2 is unset - defaulting to $DBD_INFORMIX_PASSWORD. Testing connection to stores CONNECT TO 'stores' with user info Testing concurrent connection to stores CONNECT TO 'stores' with user info Your Informix environment is (probably) OK Checking if your kit is complete... Looks good Using DBI 1.604 (for perl 5.008008 on i486-linux-gnu-thread-multi) installed in /usr/local/lib/perl/5.8.8/auto/DBI/ Writing Makefile for DBD::Informix 2. make cp lib/DBD/Informix/Summary.pm blib/lib/DBD/Informix/Summary.pm cp lib/DBD/Informix/TechSupport.pm blib/lib/DBD/Informix/TechSupport.pm cp lib/DBD/Informix/GetInfo.pm blib/lib/DBD/Informix/GetInfo.pm cp lib/Bundle/DBD/Informix.pm blib/lib/Bundle/DBD/Informix.pm cp lib/DBD/Informix/Configure.pm blib/lib/DBD/Informix/Configure.pm cp Informix.pm blib/lib/DBD/Informix.pm cp lib/DBD/Informix/TestHarness.pm blib/lib/DBD/Informix/TestHarness.pm cp lib/DBD/Informix/TypeInfo.pm blib/lib/DBD/Informix/TypeInfo.pm cp lib/DBD/Informix/Defaults.pm blib/lib/DBD/Informix/Defaults.pm cp lib/DBD/Informix/Metadata.pm blib/lib/DBD/Informix/Metadata.pm /usr/bin/perl -p -e "s/~DRIVER~/Informix/g" /usr/local/lib/perl/5.8.8/auto/DBI/Driver.xst > Informix.xsi /usr/bin/perl /usr/share/perl/5.8/ExtUtils/xsubpp -typemap /usr/share/perl/5.8/ExtUtils/typemap Informix.xs > Informix.xsc && mv Informix.xsc Informix.c cc -c -I/opt/informix/incl/esql -I/usr/lib/perl/5.8/auto/DBI -I/usr/local/lib/perl/5.8.8/auto/DBI -I/usr/lib/perl5/auto/DBI -I/usr/local/lib/perl/5.8.8/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2008.0229\" -DXS_VERSION=\"2008.0229\" -fPIC "-I/usr/lib/perl/5.8/CORE" -DESQLC_VERSION=300 -DNDEBUG -DDO_NOT_USE_STDERR_H Informix.c INFORMIXC="/usr/bin/perl esqlcc" ESQLCC="cc" esql -c -shared -I/opt/informix/incl/esql -I/usr/lib/perl/5.8/auto/DBI -I/usr/local/lib/perl/5.8.8/auto/DBI -I/usr/lib/perl5/auto/DBI -I/usr/local/lib/perl/5.8.8/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2008.0229\" -DXS_VERSION=\"2008.0229\" -fPIC -I/usr/lib/perl/5.8/CORE -DESQLC_VERSION=300 -DNDEBUG -DDO_NOT_USE_STDERR_H dbdimp.ec In file included from esqlutil.h:61, from dbdimp.ec:44: dumpesql.h:58: error: redefinition of typedef 'ifx_loc_t' /opt/informix/incl/esql/locator.h:123: error: previous declaration of 'ifx_loc_t' was here make: *** [dbdimp.o] Error 1 Any advice on how to proceed? Information on Perl Environment below.... perl -V Summary of my perl5 (revision 5 version 8 subversion 8) configuration: Platform: osname=linux, osvers=2.6.15.7, archname=i486-linux-gnu-thread-multi uname='linux palmer 2.6.15.7 #1 smp thu sep 7 19:42:20 utc 2006 i686 gnulinux ' config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN -Dcccdlflags=-fPIC -Darchname=i486-linux-gnu -Dprefix=/usr -Dprivlib=/usr/share/perl/5.8 -Darchlib=/usr/lib/perl/5.8 -Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5 -Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local -Dsitelib=/usr/local/share/perl/5.8.8 -Dsitearch=/usr/local/lib/perl/5.8.8 -Dman1dir=/usr/share/man/man1 -Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1 -Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl -Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Ud_ualarm -Uusesfio -Uusenm -Duseshrplib -Dlibperl=libperl.so.5.8.8 -Dd_dosuid -des' 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='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64', optimize='-O2', cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include' ccversion='', gccversion='4.2.3 20071123 (prerelease) (Ubuntu 4.2.2-3ubuntu4)', 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='cc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt perllibs=-ldl -lm -lpthread -lc -lcrypt libc=/lib/libc-2.6.1.so, so=so, useshrplib=true, libperl=libperl.so.5.8.8 gnulibc_version='2.6.1' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E' cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP THREADS_HAVE_PIDS USE_ITHREADS USE_LARGE_FILES USE_PERLIO USE_REENTRANT_API Built under linux Compiled at Nov 27 2007 10:44:36 @INC: /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl . Thanks Allen Sutton ######################################################################## This email message and any attachment(s) is intended solely for the addressee(s) named above. The information it contains is confidential and may be legally privileged. Unauthorised use of the message, or the information it contains, may be unlawful. If you have received this message by mistake please call the sender immediately on 64 4 8940100 or notify us by return email and erase the original message and attachments. Thank you. The Ministry of Agriculture and Forestry accepts no responsibility for changes made to this email or to any attachments after transmission from the office. ########################################################################

Message body is not shown because it is too large.

  Thu Mar 27 20:26:39 2008 j.leffler [...] acm.org - Status changed from 'new' to 'open'
  Thu Mar 27 20:31:39 2008 j.leffler [...] acm.org - Correspondence added 10 min
RT-Send-CC: dbd.informix [...] gmail.com
This is a problem that I became aware of after releasing 2008.0229. Basically, the 3.00.xC3 CSDK has added a typedef for ifx_loc_t that was not present in 3.00.xC2, part way through a release series, thereby complicating my life enormously. I have not been tracking differences at version levels finer than 3.00 to 3.01 - someone cheated on me. The fix is to edit the code in dumpesql.h - you can simply remove the code from #ifndef IFX_LOC_T to its #endif. Or slap #if 0 / #endif around it. The next release of DBD::Informix will fix this build problem. Sorry for the trouble. -- Jonathan Leffler <jleffler@earthlink.net> <jleffler@us.ibm.com> Guardian of DBD::Informix 2008.0229 -- see http://dbi.perl.org/ "I don't suffer from insanity - I enjoy every minute of it!"
  Thu Mar 27 20:31:43 2008 j.leffler [...] acm.org - Given to JOHNL
  Thu Mar 27 20:56:35 2008 Allen.Sutton [...] maf.govt.nz - Correspondence added
Subject: RE: [rt.cpan.org #34490] Bug installing DBD::Informix on Ubuntu Hardy Heron Alpha
Date: Fri, 28 Mar 2008 13:55:44 +1300
To: <bug-DBD-Informix [...] rt.cpan.org>
From: "Allen Sutton" <Allen.Sutton [...] maf.govt.nz>
Worked a treat to get the make to work - many thanks. Looks like Informix still haven't fixed the cause of the SQL: -1820: Host variable type has been changed between fetches or puts error in test t93lvarchar (that we have been working around by re-preparing for each row that is fetched where lvarchar data is involved) Do you have any update on this? Anyway, I did a "make install" despite failing test t93lvarchar and everything looks OK. Thanks again for the very prompt response. Regards, Allen Sutton Show quoted text
-----Original Message----- From: Jonathan Leffler via RT [mailto:bug-DBD-Informix@rt.cpan.org] Sent: Friday, 28 March 2008 1:32 p.m. To: Allen Sutton Subject: [Requires Classification] [rt.cpan.org #34490] Bug installing DBD::Informix on Ubuntu Hardy Heron Alpha <URL: http://rt.cpan.org/Ticket/Display.html?id=34490 > This is a problem that I became aware of after releasing 2008.0229. Basically, the 3.00.xC3 CSDK has added a typedef for ifx_loc_t that was not present in 3.00.xC2, part way through a release series, thereby complicating my life enormously. I have not been tracking differences at version levels finer than 3.00 to 3.01 - someone cheated on me. The fix is to edit the code in dumpesql.h - you can simply remove the code from #ifndef IFX_LOC_T to its #endif. Or slap #if 0 / #endif around it. The next release of DBD::Informix will fix this build problem. Sorry for the trouble. -- Jonathan Leffler <jleffler@earthlink.net> <jleffler@us.ibm.com> Guardian of DBD::Informix 2008.0229 -- see http://dbi.perl.org/ "I don't suffer from insanity - I enjoy every minute of it!" ######################################################################## This email message and any attachment(s) is intended solely for the addressee(s) named above. The information it contains is confidential and may be legally privileged. Unauthorised use of the message, or the information it contains, may be unlawful. If you have received this message by mistake please call the sender immediately on 64 4 8940100 or notify us by return email and erase the original message and attachments. Thank you. The Ministry of Agriculture and Forestry accepts no responsibility for changes made to this email or to any attachments after transmission from the office. ########################################################################
  Thu Mar 27 21:11:57 2008 j.leffler [...] acm.org - Correspondence added
RT-Send-CC: dbd.informix [...] gmail.com
Dear Allen, I've not seen the problem with -1820 for a while now, and t93lvarchar.t has been passing on my machines without sign of trouble. Not being aware that there was still a problem in some quarters, I've not been pushing to find a fix for it (whether that needs fixing in DBD::Informix or in ESQL/C or both). However, if you're seeing the problem still (or again) with 3.00.UC3, then I need to do some research on it. (I'm not sure when, though - but...) On my Solaris 10 (SPARC - 64-bit) machine, using a 32-bit Perl 5.10.0 and CSDK 3.00.UC2, I get a clean run from t/t93lvarchar.t (sorry about the bad line breaks in the middle): Black JL: prove -v t/t93* t/t93lvarchar...... # Driver Information # Name: Informix # Version: 2008.0229 # Product: IBM Informix CSDK Version 3.00, IBM Informix-ESQL Version 3.00.UC2 # Product Version: 300 # Connect to: stores # IUS data types can be tested! 1..13 # drop table dbd_ix_t93lvarchar # Error Message: # SQL: -206: The specified table (dbd_ix_t93lvarchar) is not in the database. # ISAM: -111: ISAM error: no record found. # SQLSTATE = 42000 # drop type dbd_ix_t93distoflvc restrict # Error Message: # SQL: -9628: Type (dbd_ix_t93distoflvc) not found. # SQLSTATE = IX000 # Test: do('create distinct type dbd_ix_t93distoflvc as lvarchar'): ok 1 # Test: do(' create table dbd_ix_t93lvarchar (s serial, lvc lvarchar, lvcn lvarchar not null, dlvc d bd_ix_t93distoflvc, dlvcn dbd_ix_t93distoflvc not null)'): ok 2 # Test: do('insert into dbd_ix_t93lvarchar values (10203040, 'LVC: 123456789012345678901234567890123 4567890123456789012345678901234567890', 'LVCN: 12345678901234567890123456789012345678901234567890123 45678901234567890', 'DLVC: 1234567890123456789012345678901234567890123456789012345678901234567890', 'DLVCN: 1234567890123456789012345678901234567890123456789012345678901234567890')'): ok 3 # PREPARE: insert into dbd_ix_t93lvarchar values (?, ?, ?, ?, ?) ok 4 ok 5 # inserted nulls OK # PREPARE: select s, lvc from dbd_ix_t93lvarchar order by s # PASSED: 3 row(s) found with expected values ok 6 # PREPARE: select s, lvc, dlvc from dbd_ix_t93lvarchar order by s # PASSED: 3 row(s) found with expected values ok 7 # PREPARE: select s, lvc, dlvc, 'abc'::lvarchar as xyz from dbd_ix_t93lvarchar order by s # PASSED: 3 row(s) found with expected values ok 8 # PREPARE: select s, lvc, dlvc, 'abc'::lvarchar as xyz, lvcn from dbd_ix_t93lvarchar order by s # PASSED: 3 row(s) found with expected values ok 9 # PREPARE: select s, lvc, dlvc, 'abc'::lvarchar as xyz, lvcn, dlvcn from dbd_ix_t93lvarchar order by s # PASSED: 3 row(s) found with expected values ok 10 # PREPARE: select s, lvcn, dlvc, lvc from dbd_ix_t93lvarchar order by s # PASSED: 3 row(s) found with expected values ok 11 ok 12 ok 13 # *** Testing of DBD::Informix complete *** # *** You appear to be normal! *** ok All tests successful. Files=1, Tests=13, 0 wallclock secs ( 0.10 usr 0.03 sys + 0.42 cusr 0.09 csys = 0.64 CPU) Result: PASS Black JL: [The 'prove' program should be in the same directory as your Perl.] If you do not get a clean run like that, please report a second CPAN bug so that I can try to track down all the circumstances. Although I didn't need the all environment information to give you the workaround for this one, the next one most likely will require the lot. But thank you for following the requested bug report format - it made sure I had all the information I did neeed. -- Jonathan Leffler <jleffler@earthlink.net> <jleffler@us.ibm.com> Guardian of DBD::Informix 2008.0229 -- see http://dbi.perl.org/ "I don't suffer from insanity - I enjoy every minute of it!"
  Thu Feb 28 10:38:22 2013 j.leffler [...] acm.org - Correspondence added
RT-Send-CC: dbd.informix [...] gmail.com
This was fixed in DBD::Informix 2008.0513. -- Jonathan Leffler <jleffler@earthlink.net> <jleffler@us.ibm.com> Guardian of DBD::Informix 2013.0118 -- see http://dbi.perl.org/ "I don't suffer from insanity - I enjoy every minute of it!"
  Thu Feb 28 10:38:23 2013 j.leffler [...] acm.org - Status changed from 'open' to 'resolved'