Carsten, Jeff, Thank you for the responses.
Carsten here is the out put from the commands you listed.
INFORMIXDIR is set to /opt/informix when I compiled the module and when
I try to run the module
"ldd /usr/lib/python2.4/site-packages/_informixdb.so" returns:
linux-gate.so.1 => (0x004db000)
libifsql.so => /usr/local/informix/lib/esql/libifsql.so (0x00376000)
libifasf.so => /usr/local/informix/lib/libifasf.so (0x006c7000)
libifgen.so => /usr/local/informix/lib/esql/libifgen.so (0x00632000)
libifos.so => /usr/local/informix/lib/esql/libifos.so (0x007b7000)
libifgls.so => /usr/local/informix/lib/esql/libifgls.so (0x0014d000)
libc.so.6 => /lib/libc.so.6 (0x00187000)
libm.so.6 => /lib/libm.so.6 (0x00bad000)
libdl.so.2 => /lib/libdl.so.2 (0x00111000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x00967000)
libifglx.so => /usr/local/informix/lib/esql/libifglx.so (0x00c36000)
libpthread.so.0 => /lib/libpthread.so.0 (0x006a9000)
/lib/ld-linux.so.2 (0x00133000
"esql -V" returns:
IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.UC1
Software Serial Number RDS#N000000
The grep command Jeff wrote about -
"grep -i -r sqli_describe_input_stmt /usr/lib/*" returns:
grep: /usr/lib/X11: No such file or directory
grep: /usr/lib/cups/filter/foomatic-rip: No such file or directory
grep: /usr/lib/cups/backend/smb: No such file or directory
Binary file /usr/lib/db2isqls09b.so matches
Binary file /usr/lib/db2isqlt09b.so matches
grep: /usr/lib/gimp/2.0/plug-ins/xsane: No such file or directory
Binary file /usr/lib/icobsqls09b.so matches
Binary file /usr/lib/ifgisqls09b.so matches
Binary file /usr/lib/isqls09b.so matches
Binary file /usr/lib/isqlt09b.so matches
Binary file /usr/lib/libdb2ifsql.so matches
Binary file /usr/lib/libdb2ixsql.so matches
Binary file /usr/lib/libdb2thsql.so matches
Binary file /usr/lib/libdb2tsql.so matches
Binary file /usr/lib/libifcobsql.so matches
Binary file /usr/lib/libiffgisql.so matches
Binary file /usr/lib/libifsql.so matches
Binary file /usr/lib/libixcobsql.so matches
Binary file /usr/lib/libixfgisql.so matches
Binary file /usr/lib/libixsql.so matches
Binary file /usr/lib/libthsql.so matches
Binary file /usr/lib/libtsql.so matches
Binary file /usr/lib/python2.4/site-packages/_informixdb.so matches
/usr/lib/python2.4/InformixDB-2.5/ext/_informixdb.c:
sqli_describe_input_stmt(ESQLINTVERSION,
sqli_curs_locate(ESQLINTVERSION, queryNa
me, 257), &tda, 0);
Binary file
/usr/lib/python2.4/InformixDB-2.5/build/temp.linux-i686-2.4/ext/_informixdb.o
matches
Binary file
/usr/lib/python2.4/InformixDB-2.5/build/lib.linux-i686-2.4/_informixdb.so
matches
grep: /usr/lib/sendmail: No such file or directory
grep: /usr/lib/sendmail.sendmail: No such file or directory
grep: /usr/lib/vte/gnome-pty-helper: Permission denied
Thanks again for the help,
John
Carsten Haese wrote:
> On 11/6/07, John Lhotak <[EMAIL PROTECTED]> wrote:
>
> In order to troubleshoot this, I'll need to know a bit more about
your system. What output do you get from the command "ldd
/usr/lib/python2.4/site-packages/_informixdb.so"? What version does
"esql -V" report? What was $INFORMIXDIR set to when you compiled the
module? Is $INFORMIXDIR set to something different when you try to run
the module, and if so, what is it set to?
>
> Thanks,
>
> Carsten.
Jeff Rush wrote:
> One of the "quirks" of the Linux linking system is that symbols can be left
undefined after a build, to be resolved at runtime, misleading you to think
> the build was successful. Late binding is great, except when it is not. ;-)
>
> The first step in debugging these kinds of things is to check that you have
> the set of shared libraries that were linked referentially into the
> _informixdb.so module. Issue the following command at a prompt:
>
> # ldd /usr/lib/python2.4/site-packages/_informixdb.so
>
> and you will get a list of libraries it needs, along with their path or the
> text "not found". Insure all are actually being found, and install from the
> Informix database software those that are missing.
>
> Next is to search for the symbol it wants within the various link libraries,
> by doing:
>
> # grep -i -r sqli_describe_input_stmt /usr/lib/*
>
> Make note of which library contains it, remove the leading "lib" and trailing
> ".so" and add what's left to the informix build process. So library
> libwwwnews.a becomes an option to the gcc compiler/linker of "-lwwwnews".
>
> You'll also notice that the "-lwwwnews" option lacks a path. If the needed
> library is not in a standard place, add a "-L<directory>" to have it search in
> there.
>
> I hope this helps,
>
> -Jeff
>
>
_______________________________________________
DB-SIG maillist - [email protected]
http://mail.python.org/mailman/listinfo/db-sig
