[DB-SIG] pep 249

[John Lhotak]

Carsten,
Thanks for the help.  The problem is solved.  It was the different 
libraries messing everything up.  The libraries it kept trying to look 
at were old and did not have the symbols needed.  Seems to be working 
fine now that it is looking at the correct ones.
thanks again,
john

Carsten Haese wrote:
> On Wed, 2007-11-07 at 12:10 -0700, John Lhotak wrote: 
>   
>> 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)
>> [...]
>>     
>
> This may be the source of your problem. Your $INFORMIXDIR
> is /opt/informix, yet your dynamic linker finds the Informix libraries
> in /usr/local/informix. Unless /opt/informix is a symlink
> to /usr/local/informix, you have two versions of ESQL/C on your system.
> One lives in /opt/informix, and it has sqli_describe_input_stmt, the
> other is in /usr/local/informix, and it doesn't have
> sqli_describe_input_stmt. You compiled with the former, and you're
> trying to run with the latter.
>
> If /opt/informix and /usr/local/informix are in fact two different
> locations, correct your dynamic linker configuration ($LD_LIBRARY_PATH
> or /etc/ld.so.conf or /etc/ld.so.conf.d) to make sure that it loads
> libraries from /opt/informix instead of /usr/local/informix.
>
>   
>> "esql -V"  returns:
>>
>>     IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.UC1 
>>     Software Serial Number RDS#N000000
>>     
>
> That version should have sqli_describe_input_stmt.
>
>   
>> The grep command Jeff wrote about -
>> "grep -i -r sqli_describe_input_stmt /usr/lib/*" returns:
>> [...]
>>     Binary file /usr/lib/libifsql.so matches
>> [...]
>>     
>
> This is a red herring because you should be looking
> at /usr/local/informix/lib, since that's the library being pulled in by
> the dynamic linker according to ldd. What does "grep
> sqli_describe_input_stmt /usr/local/informix/lib/esql/libifsql.so" show?
>
> Hope this helps,
>
>