Hello,
This is my first post so if I leave some stuff out or have made any
mistakes in posting "protocol" please let me know....
I'm currently encountering a TYPE C failure when trying to use
DBD-Informix and I suspect I know what the problem is but have been
unable to verify that it is so... I don't believe it is actually a
DBD-Informix problem but rather a result of the environment I've built
it in..... I have seen Jonathan answer similar questions but
unfortunately haven't been able to gleem the answer from those
posts....If someone could confirm my suspicions for me or perhaps point
me in the right direction it would be most appreciated....
A few caveats though...
1.) I do not have root access on the box I am building Informix-DBD
on...
2.) I have been forced to use a "prebuilt" version of perl... this is
for various reasons but namely the firm I work for offers a Perl API for
it's application which contains perl modules that act as wrappers to one
of those ummmm...yeah... nice java based "pub/sub message bus"
technologies which my firms app resides upon... The pub/sub stuff is
compiled with cc and we do not have the source for it therefore my perl
distro is built with solaris "cc" (see #4)
3.) I do not have admin privledges to the databases...(The box I am
building DBD-Informix on is a clients production server... It is for
Cisco Wan Manager... that uses informix as it underlying database....)
Therefore I have not created a "stores" database.... But can access the
server Cisco Wan Manager databases just fine using dbaccess......
4.) My pre-built version of perl has been compiled with solaris "cc"....
5.) The box that I am building DBD-Informix on does not have cc.... so I
am using GNU gcc to build DBD-Informix....
------------------------------------------------------------------------
--
DBI and DBD both build fine and make install without any problems.... I
have changes "stores7" to an actual database on my informix server that
I can access using "dbaccess"....when I execute the following perl
script I get the error message listed below....
#!/opt/OpenRiver/Solaris2/contrib/perl/bin/perl
#
# DBD::Informix Example 1 - fetchall_arrayref
#
# @(#)$Id: x01fetchall.pl,v 61.1 1998/10/27 19:14:59 jleffler Exp $
#
# Jonathan Leffler ([EMAIL PROTECTED])
use DBI;
$dbh = DBI->connect("DBI:Informix:stratacom");
$sth = $dbh->prepare(q%SELECT * from node%);
$sth->execute(106);
$ref = $sth->fetchall_arrayref();
for $row (@$ref)
{
print "Name: $$row[0] $$row[1], Phone: $$row[2]\n";
}
$dbh->disconnect;
install_driver(Informix) failed: Can't load
'/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-s
olaris/auto/DBD/Informix/Informix.so' for module DBD::Informix: ld.so.1:
perl: fatal: relocation error: file
/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/au
to/DBD/Informix/Informix.so: symbol
SQLSTATE: referenced symbol not found at
/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solari
s/DynaLoader.pm line 169, <IN> chunk 140.
------------------------------------------------------------------------
------
DynaLoader complains about not being able to load the Informix.so
module.... It also errors out when looking for SQLSTATE in the symbol
table when it can't open it....
Just to make sure I checked Informix.so and SQLSTATE is defined.....
nm Informix.so
[588] | 0| 0|NOTY |GLOB |0 |UNDEF |SQLSTATE
I think the problem is that perl is built with "cc" and the informix.so
shared object has been created with "gcc"... and perhaps there is some
discrepancy between what dynaloader expects the symbol table to look
like... assuming it was built with cc rather than gcc.......
Any Help in this matter would be greatly appreciated....
Best Regs,
Ray Jenkins
Technical Architect
Riversoft Inc.
678-852-8873
www.riversoft.com
Output requested from bug.reports......
------------------------------------------------------------------------
------
SECTION 1:
esql -V :
INFORMIX-ESQL Version 9.30.UC1
Software Serial Number AAC#J859236
perl -V :
Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
Platform:
osname=solaris, osvers=2.6, archname=sun4-solaris
uname='sunos chang 5.6 generic_105181-10 sun4u sparc sunw,ultra-5_10
'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef useperlio=undef d_sfio=undef
Compiler:
cc='cc', optimize='-O', gccversion=
cppflags=''
ccflags =''
stdchar='unsigned char', d_stdstdio=define, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
alignbytes=8, usemymalloc=y, prototype=define
Linker and Libraries:
ld='cc', ldflags =''
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc -lcrypt
libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-KPIC', lddlflags='-G'
Characteristics of this binary (from libperl):
Built under solaris
Compiled at Sep 1 2000 14:43:53
%ENV:
PERL="/opt/OpenRiver/Solaris2/contrib/perl"
PERLLIB="/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-sol
aris:/opt/OpenRiver/Solaris2/con
trib/perl/lib/site_perl/sun4-solaris"
@INC:
/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris
/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/sun4-solaris
/opt/OpenRiver/Solaris2/contrib/perl/lib/5.00503/sun4-solaris
/opt/OpenRiver/Solaris2/contrib/perl/lib/5.00503
/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris
/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005
dbacess -V:
DB-Access Version 9.20.UC3
Software Serial Number AAC#J859235
------------------------------------------------------------------------
-------------------------------
SECTION 2:
env | sort :
DBD_INFORMIX_DATABASE=stratacom
DBD_INFORMIX_PASSWORD=xxxxxxxx
DBD_INFORMIX_USERNAME=xxxxxxxx
DBI_DBNAME=stratacom
EDITOR=vi
HISTSIZE=10000
HOME=/users/riversoft
INFORMIXDIR=/usr/users/informix
INFORMIXSERVER=totlccwm1
LD_LIBRARY_PATH=/usr/users/informix/lib/esql:/usr/users/informix/lib:/op
t/OpenRiver/Solaris2/contrib/perl/li
b/site_perl/5.005/sun4-solaris/auto/DBD/Informix:.
LOGNAME=riversoft
MAIL=/var/mail/riversoft
O=/local/OpenRiver/Solaris2
ORV_DOMAIN=NMS
ORV_HOME=/local/OpenRiver/Solaris2
PATH=/usr/users/informix:/usr/users/informix/bin:/opt/OpenRiver/Solaris2
/contrib/perl/bin:/usr/bin:/usr/ucb:
/etc:/usr/sbin:/usr/ucb:/etc:/opt/SUNWspro/bin:/usr/local/bin:/usr/openw
in/bin:/usr/dt/bin:/usr/opt/SUNWmd/s
bin:/usr/ccs/bin:/usr/platform/sun4u/sbin/:/opt/NSCPcom:/usr/atria/bin:/
usr/bin/nsr:/usr/sbin/nsr:/opt/SUNWv
xva/bin:/usr/local/etc:/opt/Omnibus/bin:/opt/perl/bin:/opt/perl/lib:/usr
/local/bin:/usr/local/netscape:/loca
l/OpenRiver/Solaris2/bin:/local/OpenRiver/Solaris2/plug-ins:/local/OpenR
iver/Solaris2/scripts:/opt/rv/bin:/o
pt/perl/bin:/opt/perl/lib:/opt/perl/man:/local/OpenRiver/Solaris2/contri
b:/usr/local/bin/:/local/OpenRiver/S
olaris2/apache/bin:/var/opt/oracle/app/oracle/product/8.0.5/bin
PERL=/opt/OpenRiver/Solaris2/contrib/perl
PERLLIB=/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-so
laris/DBD:/opt/OpenRiver/Solaris2/co
ntrib/perl/lib/site_perl/5.005/sun4-solaris/Bundle/DBD:/opt/OpenRiver/So
laris2/contrib/perl/lib/site_perl/5.
005/sun4-solaris/auto/DBD/Informix:/opt/OpenRiver/Solaris2/contrib/perl/
lib/perl5/5.00503/sun4-solaris:/opt/
OpenRiver/Solaris2/contrib/perl/lib/site_perl/sun4-solaris
PS1=$UNAME@$PWD>
PWD=/users/riversoft/DBD-Informix-0.95
RV=/opt/rv
SHELL=/bin/ksh
SSH_CLIENT=207.225.133.50 3413 22
SSH_TTY=/dev/pts/9
TERM=xterm
TZ=US/Central
UNAME=totlccwm1
USER=riversoft
_=/usr/bin/env
------------------------------------------------------------------------
----------------------------------
SECTION 3:
Error Message:
install_driver(Informix) failed: Can't load
'/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-s
olaris/auto/DBD/Informix/Informix.so' for module DBD::Informix: ld.so.1:
perl: fatal: relocation error: file
/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/au
to/DBD/Informix/Informix.so: symbol
SQLSTATE: referenced symbol not found at
/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solari
s/DynaLoader.pm line 169, <IN> chunk 140.
nm
/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/au
to/DBD/Informix/Informix.so | gre
p SQL
[588] | 0| 0|NOTY |GLOB |0 |UNDEF |SQLSTATE
------------------------------------------------------------------------
-----
SECTION 4:
more Makefile.PL.out
Configuring DBD::Informix version 0.95...
You are using DBI version 1.20 and Perl version 5.00503
Remember to actually read the README file!
Perl: perl5.00503 sun4-solaris dl_dlopen.xs
System: sunos chang 5.6 generic_105181-10 sun4u sparc sunw,ultra-5_10
Compiler: cc -O
Using INFORMIX-ESQL Version 9.30.UC1 from /usr/users/informix
Beware: DBD::Informix is not yet aware of all the new IUS data types.
Assert macro will be disabled!
Testing whether your Informix test environment will work...
ESQLTEST Program Running:
@(#)$Id: esqltest.ec,v 95.2 1999/12/30 23:08:49 jleffler Exp $
$DBI_DBNAME set to 'stratacom'.
$DBD_INFORMIX_DATABASE set to 'stratacom'.
$DBD_INFORMIX_DATABASE2 unset - defaulting to 'stratacom'.
$DBD_INFORMIX_USERNAME is set to 'svplus'.
$DBD_INFORMIX_USERNAME2 is unset.
$DBD_INFORMIX_PASSWORD is unset.
$DBD_INFORMIX_PASSWORD2 is unset.
Testing connection to stratacom
!!! DBD_INFORMIX_USERNAME & DBD_INFORMIX_PASSWORD are ignored
unless both variables are set.
CONNECT - no user info (connection_1)
Testing concurrent connection to stratacom
CONNECT - no user info (connection_2)
Your Informix environment is (probably) OK
Checking if your kit is complete...
Looks good
Using DBI 1.20 installed in
/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/au
to/DBI
Writing Makefile for DBD::Informix
------------------------------------------------------------------------
------
SECTION 5:
more make.stdout
mkdir blib
mkdir blib/lib
mkdir blib/lib/DBD
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/DBD
mkdir blib/arch/auto/DBD/Informix
mkdir blib/lib/auto
mkdir blib/lib/auto/DBD
mkdir blib/lib/auto/DBD/Informix
mkdir blib/man3
cp Informix.pm blib/lib/DBD/Informix.pm
cp lib/Bundle/DBD/Informix.pm blib/lib/Bundle/DBD/Informix.pm
/opt/OpenRiver/Solaris2/contrib/perl/bin/perl -p -e
"s/~DRIVER~/Informix/g" < /opt/OpenRiver/Solaris2/contri
b/perl/lib/site_perl/5.005/sun4-solaris/auto/DBI/Driver.xst >
Informix.xsi
/opt/OpenRiver/Solaris2/contrib/perl/bin/perl
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-
solaris -I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503
/opt/OpenRiver/Solaris2/contrib/perl/lib/pe
rl5/5.00503/ExtUtils/xsubpp -typemap
/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/ExtUtils/typema
p Informix.xs >xstmp.c && mv xstmp.c Informix.c
gcc -c -I/usr/users/informix/incl/esql
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris
/auto/DBI
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/
auto/DBI -O -DVERSION
=\"0.95\" -DXS_VERSION=\"0.95\" -fPIC
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris
/CORE -DESQLC_VERSION=930 -DNDEBUG Informix.c
INFORMIXC="/opt/OpenRiver/Solaris2/contrib/perl/bin/perl esqlcc"
ESQLCC="gcc" esql -c -shared -I/usr/users/i
nformix/incl/esql
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris/au
to/DBI -I/opt/Open
River/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/auto/DBI
-O -DVERSION=\"0.95\" -DXS_VERS
ION=\"0.95\" -fPIC
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris/CO
RE -DESQLC_VERSIO
N=930 -DNDEBUG dbdimp.ec
rm -f dbdimp.c
INFORMIXC="/opt/OpenRiver/Solaris2/contrib/perl/bin/perl esqlcc"
ESQLCC="gcc" esql -c -shared -I/usr/users/i
nformix/incl/esql
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris/au
to/DBI -I/opt/Open
River/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/auto/DBI
-O -DVERSION=\"0.95\" -DXS_VERS
ION=\"0.95\" -fPIC
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris/CO
RE -DESQLC_VERSIO
N=930 -DNDEBUG dbdattr.ec
rm -f dbdattr.c
gcc -c -I/usr/users/informix/incl/esql
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris
/auto/DBI
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/
auto/DBI -O -DVERSION
=\"0.95\" -DXS_VERSION=\"0.95\" -fPIC/CORE -DESQLC_VERSION=930 -DNDEBUG
sqltoken.c
INFORMIXC="/opt/OpenRiver/Solaris2/contrib/perl/bin/perl esqlcc"
ESQLCC="gcc" esql -c -shared -I/usr/users/i
nformix/incl/esql
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris/au
to/DBI -I/opt/Open
River/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/auto/DBI
-O -DVERSION=\"0.95\" -DXS_VERS
ION=\"0.95\" -fPIC
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris/CO
RE -DESQLC_VERSIO
N=930 -DNDEBUG sqltype.ec
rm -f sqltype.c
INFORMIXC="/opt/OpenRiver/Solaris2/contrib/perl/bin/perl esqlcc"
ESQLCC="gcc" esql -c -shared -I/usr/users/i
nformix/incl/esql
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris/au
to/DBI -I/opt/Open
River/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/auto/DBI
-O -DVERSION=\"0.95\" -DXS_VERS
ION=\"0.95\" -fPIC
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris/CO
RE -DESQLC_VERSIO
N=930 -DNDEBUG ixblob.ec
rm -f ixblob.c
gcc -c -I/usr/users/informix/incl/esql
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris
/auto/DBI
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/
auto/DBI -O -DVERSION
=\"0.95\" -DXS_VERSION=\"0.95\" -fPIC
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris
/CORE -DESQLC_VERSION=930 -DNDEBUG decsci.c
gcc -c -I/usr/users/informix/incl/esql
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris
/auto/DBI
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/
auto/DBI -O -DVERSION
=\"0.95\" -DXS_VERSION=\"0.95\" -fPIC
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris
/CORE -DESQLC_VERSION=930 -DNDEBUG odbctype.c
gcc -c -I/usr/users/informix/incl/esql
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris
/auto/DBI
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/
auto/DBI -O -DVERSION
=\"0.95\" -DXS_VERSION=\"0.95\" -fPIC
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris
/CORE -DESQLC_VERSION=930 -DNDEBUG link.c
INFORMIXC="/opt/OpenRiver/Solaris2/contrib/perl/bin/perl esqlcc"
ESQLCC="gcc" esql -c -shared -I/usr/users/i
nformix/incl/esql
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris/au
to/DBI
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/
auto/DBI -O -DVERSION=\"0.95\" -DXS_VERS
ION=\"0.95\" -fPIC
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris/CO
RE -DESQLC_VERSIO
N=930 -DNDEBUG esqlcver.ec
rm -f esqlcver.c
INFORMIXC="/opt/OpenRiver/Solaris2/contrib/perl/bin/perl esqlcc"
ESQLCC="gcc" esql -c -shared -I/usr/users/i
nformix/incl/esql
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris/au
to/DBI -I/opt/Open
River/Solaris2/contrib/perl/lib/site_perl/5.005/sun4-solaris/auto/DBI
-O -DVERSION=\"0.95\" -DXS_VERS
ION=\"0.95\" -fPIC
-I/opt/OpenRiver/Solaris2/contrib/perl/lib/perl5/5.00503/sun4-solaris/CO
RE -DESQLC_VERSIO
N=930 -DNDEBUG esqlc_v6.ec
rm -f esqlc_v6.c
Running Mkbootstrap for DBD::Informix ()
chmod 644 Informix.bs
LD_RUN_PATH="" gcc -o blib/arch/auto/DBD/Informix/Informix.so -G
Informix.o dbdimp.o dbdattr.o sqltoken.o s
qltype.o ixblob.o decsci.o odbctype.o link.o esqlcver.o esqlc_v6.o
-R/usr/users/informix/lib -R/usr/users/in
formix/lib/esql
chmod 755 blib/arch/auto/DBD/Informix/Informix.so
cp Informix.bs blib/arch/auto/DBD/Informix/Informix.bs
chmod 644 blib/arch/auto/DBD/Informix/Informix.bs
Manifying blib/man3/Bundle::DBD::Informix.3
Manifying blib/man3/DBD::Informix.3