dbTalk Databases Forums  

sqlcmd compile error.

comp.databases.informix comp.databases.informix


Discuss sqlcmd compile error. in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roy Mercer
 
Posts: n/a

Default sqlcmd compile error. - 09-27-2011 , 08:01 AM






OS:
Linux version 2.6.18-238.9.1.el5
(mockbuild (AT) x86-002 (DOT) build.bos.redhat.com) (gcc version 4.1.2 20080704
(Red Hat 4.1.2-50)) #1 SMP Fri Mar 18 12:42:39 EDT 2011

Informix CSDK:
Program Name: esqlc
Build Version: 3.70.FC3
Build Number: N112
Build Host: hans
Build OS: Linux 2.6.18-128.el5
Build Date: Thu Jun 16 05:36:33 CDT 2011
GLS Version: glslib-5.00.FC4

Informix ENV:
DBDATE=Y4MD-
HOME=/home/informix
INFORMIXDIR=/az/ifxtools64
INFORMIXSQLHOSTS=/az/ifxtools64/etc/sqlhosts.dbaccess
LIBPATH=:/az/ifxtools64/lib:/az/ifxtools64/lib/esql:/az/ifxtools64/lib/
c++:/az/ifxtools64/lib/cli:/az/ifxtools64/lib/dmi:/usr/lib
PATH=/usr/local/bin:/bin:/usr/bin:/az/ifxtools64/bin
SHELL=/bin/ksh
TERM=vt100
TERMCAP=/az/ifxtools64/etc/termcap


Error from the configure command to compile sqlcmd:
checking for popen... yes
checking for vsnprintf... yes
checking for mkstemp... yes
checking for special C compiler options needed for large files... no
checking for _FILE_OFFSET_BITS value needed for large files... no
checking readline/readline.h usability... no
checking readline/readline.h presence... no
checking for readline/readline.h... no
No GNU readline header - not looking for libraries
checking for /dev/stdin, /dev/stdout, /dev/stderr... yes
checking for INFORMIXDIR... /az/ifxtools64
checking for ESQL/C compiler and version... compiler esql (version
370)
checking for 32-bit vs 64-bit ESQL/C... 64 bits
checking ESQL/C compiler works... ./esqlc-3227: error while loading
shared libraries: libifsql.so: cannot open shared object file: No such
file or directory
configure: error: failed


The file is located in $INFORMIXDIR/lib/esql and this is included in
the LIBPATH
-rw-r--r-- 2 informix informix 558090 Jun 16 05:39 /az/ifxtools64/lib/
esql/libifsql.a
-rwxr-xr-x 3 informix informix 386037 Jun 16 05:39 /az/ifxtools64/lib/
esql/libifsql.so

Any ideas?
I just ran the configure out of the box and made no changes.
I also tried with setting:
CC="gcc -m64" ./configure


Thanks

Reply With Quote
  #2  
Old   
Alexandre Marini
 
Posts: n/a

Default Re: sqlcmd compile error. - 09-27-2011 , 08:13 AM






Hello,
try to copy your LIBPATH environment variable to LD_LIBRARY_PATH env.

I think this will solve your issue.

Regards.

Em 27/09/2011 09:01, Roy Mercer escreveu:
Quote:
OS:
Linux version 2.6.18-238.9.1.el5
(mockbuild (AT) x86-002 (DOT) build.bos.redhat.com) (gcc version 4.1.2 20080704
(Red Hat 4.1.2-50)) #1 SMP Fri Mar 18 12:42:39 EDT 2011

Informix CSDK:
Program Name: esqlc
Build Version: 3.70.FC3
Build Number: N112
Build Host: hans
Build OS: Linux 2.6.18-128.el5
Build Date: Thu Jun 16 05:36:33 CDT 2011
GLS Version: glslib-5.00.FC4

Informix ENV:
DBDATE=Y4MD-
HOME=/home/informix
INFORMIXDIR=/az/ifxtools64
INFORMIXSQLHOSTS=/az/ifxtools64/etc/sqlhosts.dbaccess
LIBPATH=:/az/ifxtools64/lib:/az/ifxtools64/lib/esql:/az/ifxtools64/lib/
c++:/az/ifxtools64/lib/cli:/az/ifxtools64/lib/dmi:/usr/lib
PATH=/usr/local/bin:/bin:/usr/bin:/az/ifxtools64/bin
SHELL=/bin/ksh
TERM=vt100
TERMCAP=/az/ifxtools64/etc/termcap


Error from the configure command to compile sqlcmd:
checking for popen... yes
checking for vsnprintf... yes
checking for mkstemp... yes
checking for special C compiler options needed for large files... no
checking for _FILE_OFFSET_BITS value needed for large files... no
checking readline/readline.h usability... no
checking readline/readline.h presence... no
checking for readline/readline.h... no
No GNU readline header - not looking for libraries
checking for /dev/stdin, /dev/stdout, /dev/stderr... yes
checking for INFORMIXDIR... /az/ifxtools64
checking for ESQL/C compiler and version... compiler esql (version
370)
checking for 32-bit vs 64-bit ESQL/C... 64 bits
checking ESQL/C compiler works... ./esqlc-3227: error while loading
shared libraries: libifsql.so: cannot open shared object file: No such
file or directory
configure: error: failed


The file is located in $INFORMIXDIR/lib/esql and this is included in
the LIBPATH
-rw-r--r-- 2 informix informix 558090 Jun 16 05:39 /az/ifxtools64/lib/
esql/libifsql.a
-rwxr-xr-x 3 informix informix 386037 Jun 16 05:39 /az/ifxtools64/lib/
esql/libifsql.so

Any ideas?
I just ran the configure out of the box and made no changes.
I also tried with setting:
CC="gcc -m64" ./configure


Thanks
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list


--

Alexandre Marini

Tecnologia da Informação - DBA

SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix

<Cert-Info-Mgmt_color.jpg>

IBM Certified System Administrator - Informix Dynamic Server V10 / V11 /
V11.70

IBM Information Management Informix Technical Professional v3

Reply With Quote
  #3  
Old   
Roy Mercer
 
Posts: n/a

Default Re: sqlcmd compile error. - 09-27-2011 , 08:36 AM



On Sep 27, 8:13*am, Alexandre Marini <amar... (AT) fazenda (DOT) ms.gov.br>
wrote:
Quote:
Hello,
try to copy your LIBPATH environment variable to LD_LIBRARY_PATH env.

I think this will solve your issue.

Regards.

Em 27/09/2011 09:01, Roy Mercer escreveu:





OS:
Linux version 2.6.18-238.9.1.el5
(mockbu... (AT) x86-002 (DOT) build.bos.redhat.com) (gcc version 4.1.2 20080704
(Red Hat 4.1.2-50)) #1 SMP Fri Mar 18 12:42:39 EDT 2011

Informix CSDK:
Program Name: * esqlc
Build Version: *3.70.FC3
Build Number: * N112
Build Host: * * hans
Build OS: * * * Linux 2.6.18-128.el5
Build Date: * * Thu Jun 16 05:36:33 CDT 2011
GLS Version: * *glslib-5.00.FC4

Informix ENV:
DBDATE=Y4MD-
HOME=/home/informix
INFORMIXDIR=/az/ifxtools64
INFORMIXSQLHOSTS=/az/ifxtools64/etc/sqlhosts.dbaccess
LIBPATH=:/az/ifxtools64/lib:/az/ifxtools64/lib/esql:/az/ifxtools64/lib/
c++:/az/ifxtools64/lib/cli:/az/ifxtools64/lib/dmi:/usr/lib
PATH=/usr/local/bin:/bin:/usr/bin:/az/ifxtools64/bin
SHELL=/bin/ksh
TERM=vt100
TERMCAP=/az/ifxtools64/etc/termcap

Error from the configure command to compile sqlcmd:
checking for popen... yes
checking for vsnprintf... yes
checking for mkstemp... yes
checking for special C compiler options needed for large files... no
checking for _FILE_OFFSET_BITS value needed for large files... no
checking readline/readline.h usability... no
checking readline/readline.h presence... no
checking for readline/readline.h... no
No GNU readline header - not looking for libraries
checking for /dev/stdin, /dev/stdout, /dev/stderr... yes
checking for INFORMIXDIR... /az/ifxtools64
checking for ESQL/C compiler and version... compiler esql (version
370)
checking for 32-bit vs 64-bit ESQL/C... 64 bits
checking ESQL/C compiler works... ./esqlc-3227: error while loading
shared libraries: libifsql.so: cannot open shared object file: No such
file or directory
configure: error: failed

The file is located in $INFORMIXDIR/lib/esql and this is included in
the LIBPATH
-rw-r--r-- 2 informix informix 558090 Jun 16 05:39 /az/ifxtools64/lib/
esql/libifsql.a
-rwxr-xr-x 3 informix informix 386037 Jun 16 05:39 /az/ifxtools64/lib/
esql/libifsql.so

Any ideas?
I just ran the configure out of the box and made no changes.
I also tried with setting:
* CC="gcc -m64" ./configure

Thanks
_______________________________________________
Informix-list mailing list
Informix-l... (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

--

Alexandre Marini

Tecnologia da Informação - DBA

SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix

Cert-Info-Mgmt_color.jpg

IBM Certified System Administrator - Informix Dynamic Server V10 / V11 /
V11.70

IBM Information Management Informix Technical Professional v3- Hide quoted text -

- Show quoted text -
DUH - Thanks!

Roy

Reply With Quote
  #4  
Old   
Art Kagel
 
Posts: n/a

Default Re: sqlcmd compile error. - 09-27-2011 , 11:04 AM



Do you have the CSDK installed? Are its lib and lib/esql directories
included in the LD_LIBRARY_PATH environment variable?

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Tue, Sep 27, 2011 at 9:01 AM, Roy Mercer <roy.mercer (AT) gmail (DOT) com> wrote:

Quote:
OS:
Linux version 2.6.18-238.9.1.el5
(mockbuild (AT) x86-002 (DOT) build.bos.redhat.com) (gcc version 4.1.2 20080704
(Red Hat 4.1.2-50)) #1 SMP Fri Mar 18 12:42:39 EDT 2011

Informix CSDK:
Program Name: esqlc
Build Version: 3.70.FC3
Build Number: N112
Build Host: hans
Build OS: Linux 2.6.18-128.el5
Build Date: Thu Jun 16 05:36:33 CDT 2011
GLS Version: glslib-5.00.FC4

Informix ENV:
DBDATE=Y4MD-
HOME=/home/informix
INFORMIXDIR=/az/ifxtools64
INFORMIXSQLHOSTS=/az/ifxtools64/etc/sqlhosts.dbaccess
LIBPATH=:/az/ifxtools64/lib:/az/ifxtools64/lib/esql:/az/ifxtools64/lib/
c++:/az/ifxtools64/lib/cli:/az/ifxtools64/lib/dmi:/usr/lib
PATH=/usr/local/bin:/bin:/usr/bin:/az/ifxtools64/bin
SHELL=/bin/ksh
TERM=vt100
TERMCAP=/az/ifxtools64/etc/termcap


Error from the configure command to compile sqlcmd:
checking for popen... yes
checking for vsnprintf... yes
checking for mkstemp... yes
checking for special C compiler options needed for large files... no
checking for _FILE_OFFSET_BITS value needed for large files... no
checking readline/readline.h usability... no
checking readline/readline.h presence... no
checking for readline/readline.h... no
No GNU readline header - not looking for libraries
checking for /dev/stdin, /dev/stdout, /dev/stderr... yes
checking for INFORMIXDIR... /az/ifxtools64
checking for ESQL/C compiler and version... compiler esql (version
370)
checking for 32-bit vs 64-bit ESQL/C... 64 bits
checking ESQL/C compiler works... ./esqlc-3227: error while loading
shared libraries: libifsql.so: cannot open shared object file: No such
file or directory
configure: error: failed


The file is located in $INFORMIXDIR/lib/esql and this is included in
the LIBPATH
-rw-r--r-- 2 informix informix 558090 Jun 16 05:39 /az/ifxtools64/lib/
esql/libifsql.a
-rwxr-xr-x 3 informix informix 386037 Jun 16 05:39 /az/ifxtools64/lib/
esql/libifsql.so

Any ideas?
I just ran the configure out of the box and made no changes.
I also tried with setting:
CC="gcc -m64" ./configure


Thanks
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.