A colleague of mine is having an issue re-installing the DBD-Informix
module on his Solaris 7 server. I do not have access to the server,
so I have to pass on as much information as I can in hope that
somebody has seen something similar.

The server runs Informix 7.31UC6 on Solaris 7. CSDK 2.60UC1 is
installed as well.

Previously, he says they had DBD-Informix version 1.00TC1 installed
with Perl 5.005. He upgraded Perl to 5.87 and wanted to reinstall
the DBI/DBD modules, but ran into some compile issues. GCC version 3
is installed (unfortunately, I do not have the subversion in my notes).

I walked him through setting up the correct environment variables,
including INFORMIXDIR, INFORMIXSERVER, PATH, and LD_LIBRARY_PATH. He
is able to compile and run the esqlbasic test program without errors:

> artemis# ./esqlbasic
> $DBI_DBNAME unset - defaulting to 'stores'.
> $DBD_INFORMIX_DATABASE unset - defaulting to 'stores'.
> Testing connection to stores
> Your Informix environment is (probably) OK


However, when he attempts to run the Makefile.PL script, he ends with
an error:

>
> artemis# perl rmautoinst.pl Makefile.PL | perl -
>
> Configuring IBM Informix Database Driver for Perl DBI Version 2005.01
> (2005-03-14) (aka DBD::Informix)
> You are using DBI version 1.48 and Perl version 5.008007
> Remember to actually read the README file!
>
> Perl: perl v5.008007 sun4-solaris dl_dlopen.xs
> System: sunos artemis 5.7 generic_106541-40 sun4u sparc
> sunw,ultra-enterprise
> Using INFORMIXDIR=/local/artemis/apps/informix and ESQL/C compiler
> esql
> Using INFORMIX-ESQL Version 9.50.UC1 from /local/artemis/apps/informix
>
> Please upgrade to a more recent version of ClientSDK.
> DBD::Informix will probably work, but that is not guaranteed.
>
> 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
> esqlvrsn.h written OK
> esqlinfo.h written OK
>
> Testing whether your Informix test environment will work...
> ccflag = <<-fno-strict-aliasing>>
> ccflag = <<-pipe>>
> ccflag = <<-I/usr/local/include>>
> ccflag = <<-D_LARGEFILE_SOURCE>>
> ccflag = <<-D_FILE_OFFSET_BITS=64>>
> cppflag = <<-DESQLC_VERSION=950>>
> cppflag = <<-DNDEBUG>>
> cppflag = <<-DUSE_REAL_MALLOC>>
> +ec+ <<esql>>
> +ec+ <<-c>>
> +ec+ <<-fno-strict-aliasing>>
> +ec+ <<-pipe>>
> +ec+ <<-I/usr/local/include>>
> +ec+ <<-D_LARGEFILE_SOURCE>>
> +ec+ <<-D_FILE_OFFSET_BITS=64>>
> +ec+ <<-DESQLC_VERSION=950>>
> +ec+ <<-DNDEBUG>>
> +ec+ <<-DUSE_REAL_MALLOC>>
> +ec+ <<esqltest.ec>>
> + setenv INFORMIXC = /usr/local/bin/perl esqlcc
> + setenv ESQLCC = gcc
> + <<esql -c -fno-strict-aliasing -pipe -I/usr/local/include
> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DESQLC_VERSION=950 -
> DNDEBUG
> -DUSE_REAL_MALLOC esqltest.ec>>
> Failed to compile esqltest.ec to esqltest.o
> artemis#
>
> artemis# env
> CC=gcc
> CFDIR=/usr/lib/mail
> DBD_INFORMIX_DEBUG_ESQLTEST=poop
> EDITOR=vi
> HOME=/root
> HZ=
> INFORMIXC=gcc
> INFORMIXDIR=/local/artemis/apps/informix
> INFORMIXSERVER=iproda
> INFORMIXSQLHOSTS=/local/artemis/apps/informix/etc/sqlhosts
> LD_LIBRARY_PATH=/local/artemis/apps/informix/lib:/local/artemis/
> apps/informix/lib/esql
> LOGNAME=root
> MANPATH=/usr/dt/man:/usr/man:/usr/openwin/share/man:/opt/VRTSvmsa/
> man:/opt/VRTSvxvm/man:/opt/hpnpl/man:/usr/local/man
> ONCONFIG=onconfig.iproda
> PATH=/usr/bin:/usr/sbin:/usr/ucb:/usr/local/bin:/usr/X/bin:/usr/
> openwin/bin:/opt/VRTSvmsa/bin:/opt/hpnpl:/etc:/root/util:/usr/ucb:/
> usr/ccs/bin:/local/artemis/apps/informix/bin
> PS1=artemis#
> SHELL=/sbin/sh
> TERM=xterm
> TZ=US/Central
> artemis#


I have installed DBD-Informix on Solaris 7 many times myself, and
never had this type of problem previously. I suspect his environment
is misconfigured in some manner but I don't see it. Any tips or
recommendations are welcomed!


Thanks in advance,
Brad
sending to informix-list