DBD::Informix

Hi,

I am trying to install DBD::Informix on Solaris 11.3 that has Informix14.10 database installed. It can build Makefile but than make just hangs.

root@plum:~# env |sort
_=/usr/bin/env
A__z="*SHLVL
DBD_INFORMIX_NO_RESOURCE=yes
DBD_INFORMIX_USERNAME=sysadmin
DISPLAY=localhost:10.0
EDITOR=vi
HOME=/root
INFORMIXDIR=/usr/informix14.10_32
INFORMIXSERVER=inf141dev
LANG=en_US.UTF-8
LC_ALL=
LC_COLLATE=
LC_CTYPE=
LC_MESSAGES=
LC_MONETARY=
LC_NUMERIC=
LC_TIME=
LD_LIBRARY_PATH=/usr/informix14.10_32/lib:/usr/informix14.10_32/lib/esql:
LOGNAME=root
MAIL=/var/mail/root
OLDPWD=/root/.cpan/build
PAGER=/usr/bin/less -ins
PATH=/usr/informix14.10_32/bin:/opt/developerstudio12.6/bin:/usr/bin:/usr/sbin:/usr/informix14.10/bin
PWD=/root
SHELL=/usr/bin/bash
SHLVL=3
SSH_TTY=/dev/pts/11
TERM=xterm
TZ=localtime
USER=root
XAUTHORITY=/tmp/ssh-xauth-zc0GId/xauthfile

root@plum:/tmp# esql -V
IBM Informix CSDK Version 4.10, IBM Informix-ESQL Version 4.10.UC15
Software Serial Number AAA#B000000

root@plum:/tmp# dbaccess -V
DB-Access Version 14.10.FC9DE

root@plum:/tmp# perl -V
Summary of my perl5 (revision 5 version 12 subversion 5) configuration:

  Platform:
    osname=solaris, osvers=2.11, archname=sun4-solaris-64int
    uname='sunos localhost 5.11 sun4v sparc sun4v'
    config_args='-Dprefix=/usr/perl5/5.12 -Dprivlib=/usr/perl5/5.12/lib -Dsitelib=/usr/perl5/site_perl/5.12 -Dvendorprefix=/usr/perl5/5.12 -Dvendorlib=/usr/perl5/vendor_perl/5.12 -Dlibperl=libperl.so -Duseshrplib -Dusedtrace -Duse64bitint -Dcc=cc -Doptimize=-xO3       -Dcf_email=perl@solaris-userland.java.net<mailto:-Dcf_email=perl@solaris-userland.java.net> -Dcf_by=perl-bugs -Dmyhostname=localhost -Dmksymlinks -Dusesitecustomize -O -de'
    hint=recommended, useposix=true, d_sigaction=define
    useithreads=undef, usemultiplicity=undef
    useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
    use64bitint=define, use64bitall=undef, uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-I/usr/gnu/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPERL_USE_SAFE_PUTENV',
    optimize='-xO3 ',
    cppflags='-I/usr/gnu/include'
    ccversion='Sun C 5.10 SunOS_sparc Patch 141861-07 2010/12/09', gccversion='', gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=87654321
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
    ivtype='long long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -L/usr/lib -L/usr/ccs/lib   -L/lib -L/usr/gnu/lib '
    libpth=/usr/lib /usr/ccs/lib   /lib /usr/gnu/lib
    libs=-lsocket -lnsl -lgdbm -ldb -ldl -lm -lc
    perllibs=-lsocket -lnsl -ldl -lm -lc
    libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
    gnulibc_version=''
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='  -R /usr/perl5/5.12/lib/sun4-solaris-64int/CORE'
    cccdlflags='-KPIC', lddlflags='-G -L/usr/lib -L/usr/ccs/lib   -L/lib -L/usr/gnu/lib'

Characteristics of this binary (from libperl):
  Compile-time options: PERL_DONT_CREATE_GVSV PERL_MALLOC_WRAP
                        PERL_USE_SAFE_PUTENV USE_64_BIT_INT USE_LARGE_FILES
                        USE_PERLIO USE_PERL_ATOF USE_SITECUSTOMIZE
  Locally applied patches:
        7111771 Problem with utility/perl
        7125218 Problem with utility/perl
        7030196 Problem with utility/perl
        15820486 Problem with utility/perl
        15880426 Problem with utility/perl
        16417744 Problem with utility/perl
        16427786 Problem with utility/perl
  Built under solaris
  Compiled at Jun  6 2017 16:21:59
  @INC:
    /usr/perl5/site_perl/5.12/sun4-solaris-64int
    /usr/perl5/site_perl/5.12
    /usr/perl5/vendor_perl/5.12/sun4-solaris-64int
    /usr/perl5/vendor_perl/5.12
    /usr/perl5/5.12/lib/sun4-solaris-64int
    /usr/perl5/5.12/lib

root@plum:~# perl -MCPAN -e shell
...
Terminal does not support AddHistory.
To fix that, maybe try>  install Term::ReadLine::Perl
cpan shell -- CPAN exploration and modules installation (v2.36)
Enter 'h' for help.

cpan[1]> install DBD::Informix
Reading '/root/.cpan/Metadata'
  Database was generated on Fri, 23 Jun 2023 18:17:01 GMT
Running install for module 'DBD::Informix'
Checksum for /root/.cpan/sources/authors/id/J/JO/JOHNL/DBD-Informix-2018.1031.tar.gz ok
Scanning cache /root/.cpan/build for sizes
............................................................................DONE
'YAML' not installed, will not store persistent state
Configuring J/JO/JOHNL/DBD-Informix-2018.1031.tar.gz with Makefile.PL
*** ExtUtils::AutoInstall version 0.63
*** Checking for dependencies...
[Core Features]
- DBI         ...loaded. (1.643 >= 1.607)
[High Resolution Timing]
- Time::HiRes ...loaded. (1.9764)
[POD Format Testing]
- Test::Pod   ...missing.
==> Auto-install the 1 optional module(s) from CPAN? [Y/n] y
*** Dependencies will be installed the next time you type 'make'.
*** ExtUtils::AutoInstall configuration finished.

Configuring Informix Database Driver for Perl DBI Version 2018.1031 (2018-10-31) (aka DBD::Informix)
        You are using DBI version 1.643 and Perl version 5.012005
Remember to actually read the README file!

Perl:     /usr/perl5/5.12/bin/perl v5.012005 sun4-solaris-64int dl_dlopen.xs
System:   sunos localhost 5.11 sun4v sparc sun4v
*** Ideally, you should upgrade to Perl version 5.026002 or later.

Using INFORMIXDIR=/usr/informix14.10_32 and ESQL/C compiler esql
Using IBM Informix CSDK Version 4.10, IBM Informix-ESQL Version 4.10.UC15 from /usr/informix14.10_32
Beware: DBD::Informix is not yet fully aware of all the Informix 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 2015.1 2014/07/28 07:16:36 jleffler Exp $
        $INFORMIXDIR is set to '/usr/informix14.10_32'.
        $INFORMIXSERVER is set to 'inf141dev'.
        $DBI_DBNAME unset - defaulting to 'stores'.
        $DBD_INFORMIX_DATABASE unset - defaulting to 'stores'.
        $DBD_INFORMIX_DATABASE2 unset - defaulting to 'stores'.
        $DBD_INFORMIX_USERNAME is set to 'sysadmin'.
        $DBD_INFORMIX_USERNAME2 is unset - defaulting to 'sysadmin'.
        $DBD_INFORMIX_PASSWORD is unset.
        $DBD_INFORMIX_PASSWORD2 is unset.
Testing connection to stores
!!!     DBD_INFORMIX_USERNAME & DBD_INFORMIX_PASSWORD are ignored
                unless both variables are set.
        1: CONNECT TO 'stores' - no user info
Not testing resource privileges because DBD_INFORMIX_NO_RESOURCE=yes
!!!     DBD_INFORMIX_USERNAME2 & DBD_INFORMIX_PASSWORD2 are ignored
                unless both variables are set.
Testing concurrent connection to stores
        1: CONNECT TO 'stores' - no user info
Your Informix environment is (probably) OK

Determining which Informix libraries etc to use...
... We are going to use the Informix library list:
*   /usr/informix14.10_32/lib/esql/checkapi.o -lifsql -lifasf -lifgen
*   -lifos -lifgls -lifglx -lnsl -lsocket -lm -ldl


Checking if your kit is complete...
Looks good
Using DBI 1.643 (for perl 5.012005 on sun4-solaris-64int) installed in /usr/perl5/site_perl/5.12/sun4-solaris-64int/auto/DBI/
Generating a Unix-style Makefile
Writing Makefile for DBD::Informix
Writing MYMETA.yml and MYMETA.json
  JOHNL/DBD-Informix-2018.1031.tar.gz
  /usr/perl5/5.12/bin/perl Makefile.PL -- OK
Running make for J/JO/JOHNL/DBD-Informix-2018.1031.tar.gz
"/usr/perl5/5.12/bin/perl" Makefile.PL --config=make_args,--hello --installdeps=Test::Pod,0
*** ExtUtils::AutoInstall version 0.63
*** Checking for dependencies...
[Core Features]
- DBI         ...loaded. (1.643 >= 1.607)
[High Resolution Timing]
- Time::HiRes ...loaded. (1.9764)
[POD Format Testing]
- Test::Pod   ...missing.
==> Auto-install the 1 optional module(s) from CPAN? [y]
*** Dependencies will be installed the next time you type 'make'.
*** ExtUtils::AutoInstall configuration finished.

Configuring Informix Database Driver for Perl DBI Version 2018.1031 (2018-10-31) (aka DBD::Informix)
        You are using DBI version 1.643 and Perl version 5.012005
Remember to actually read the README file!

Perl:     /usr/perl5/5.12/bin/perl v5.012005 sun4-solaris-64int dl_dlopen.xs
System:   sunos localhost 5.11 sun4v sparc sun4v
*** Ideally, you should upgrade to Perl version 5.026002 or later.

Using INFORMIXDIR=/usr/informix14.10_32 and ESQL/C compiler esql
Using IBM Informix CSDK Version 4.10, IBM Informix-ESQL Version 4.10.UC15 from /usr/informix14.10_32
Beware: DBD::Informix is not yet fully aware of all the Informix 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 2015.1 2014/07/28 07:16:36 jleffler Exp $
        $INFORMIXDIR is set to '/usr/informix14.10_32'.
        $INFORMIXSERVER is set to 'inf141dev'.
        $DBI_DBNAME unset - defaulting to 'stores'.
        $DBD_INFORMIX_DATABASE unset - defaulting to 'stores'.
        $DBD_INFORMIX_DATABASE2 unset - defaulting to 'stores'.
        $DBD_INFORMIX_USERNAME is set to 'sysadmin'.
        $DBD_INFORMIX_USERNAME2 is unset - defaulting to 'sysadmin'.
        $DBD_INFORMIX_PASSWORD is unset.
        $DBD_INFORMIX_PASSWORD2 is unset.
Testing connection to stores
!!!     DBD_INFORMIX_USERNAME & DBD_INFORMIX_PASSWORD are ignored
                unless both variables are set.
        1: CONNECT TO 'stores' - no user info
Not testing resource privileges because DBD_INFORMIX_NO_RESOURCE=yes
!!!     DBD_INFORMIX_USERNAME2 & DBD_INFORMIX_PASSWORD2 are ignored
                unless both variables are set.
Testing concurrent connection to stores
        1: CONNECT TO 'stores' - no user info
Your Informix environment is (probably) OK

Determining which Informix libraries etc to use...
... We are going to use the Informix library list:
*   /usr/informix14.10_32/lib/esql/checkapi.o -lifsql -lifasf -lifgen
*   -lifos -lifgls -lifglx -lnsl -lsocket -lm -ldl



  JOHNL/DBD-Informix-2018.1031.tar.gz
  /usr/bin/make -- NOT OK
Caught SIGINT, trying to continue
Got another SIGINTTerminal does not support GetHistory.
Lockfile removed.

The db line from sqlhosts file.

root@plum:~# grep $INFORMIXSERVER $INFORMIXDIR/etc/sqlhosts
inf141dev ontlitcp  plum        inf141dev

Hopefully someone can help.

Regards,
Ajay

• DBD::Informix by Ajay Sishodia via dbi-users