3 Replies Latest reply on Nov 23, 2010 11:41 AM by rareddy

    Teiid odbc drive client installation error

    bo.sun

      Hi, all, 

       

      we have been following Teiid odbc drive client installation guide below:

       

      http://docs.jboss.org/teiid/7.2.0.Final/client-developers-guide/en-US/html/ODBC.html#install

       

       

      we installed the 2.3 version of unixodbc.

       

      [root@weblab357 psqlodbc-08.04.0200]# odbcinst --version

      unixODBC 2.3.0

      [root@weblab357 psqlodbc-08.04.0200]# odbcinst -q -d

      odbcinst: SQLGetPrivateProfileString failed with .

      [root@weblab357 psqlodbc-08.04.0200]# odbcinst -q -s

      [MMOdbcServer]

      [ODBC]

       

       

      While installing the PostgreSQL tar file I get this (./configure).

       

      [root@weblab357 psqlodbc-08.04.0200]# ./configure

      checking for a BSD-compatible install... /usr/bin/install -c

      checking whether build environment is sane... yes

      checking for gawk... gawk

      checking whether make sets $(MAKE)... yes

      checking whether to enable maintainer-specific portions of Makefiles... no

      checking for style of include used by make... GNU

      checking for gcc... gcc

      checking for C compiler default output file name... a.out

      checking whether the C compiler works... yes

      checking whether we are cross compiling... no

      checking for suffix of executables...

      checking for suffix of object files... o

      checking whether we are using the GNU C compiler... yes

      checking whether gcc accepts -g... yes

      checking for gcc option to accept ANSI C... none needed

      checking dependency style of gcc... gcc3

      checking for pg_config... no

      checking for gcc... (cached) gcc

      checking whether we are using the GNU C compiler... (cached) yes

      checking whether gcc accepts -g... (cached) yes

      checking for gcc option to accept ANSI C... (cached) none needed

      checking dependency style of gcc... (cached) gcc3

      checking build system type... x86_64-unknown-linux-gnu

      checking host system type... x86_64-unknown-linux-gnu

      checking for a sed that does not truncate output... /bin/sed

      checking for egrep... grep -E

      checking for ld used by gcc... /usr/bin/ld

      checking if the linker (/usr/bin/ld) is GNU ld... yes

      checking for /usr/bin/ld option to reload object files... -r

      checking for BSD-compatible nm... /usr/bin/nm -B

      checking whether ln -s works... yes

      checking how to recognise dependent libraries... pass_all

      checking how to run the C preprocessor... gcc -E

      checking for ANSI C header files... yes

      checking for sys/types.h... yes

      checking for sys/stat.h... yes

      checking for stdlib.h... yes

      checking for string.h... yes

      checking for memory.h... yes

      checking for strings.h... yes

      checking for inttypes.h... yes

      checking for stdint.h... yes

      checking for unistd.h... yes

      checking dlfcn.h usability... yes

      checking dlfcn.h presence... yes

      checking for dlfcn.h... yes

      checking for g++... g++

      checking whether we are using the GNU C++ compiler... yes

      checking whether g++ accepts -g... yes

      checking dependency style of g++... gcc3

      checking how to run the C++ preprocessor... g++ -E

      checking for g77... g77

      checking whether we are using the GNU Fortran 77 compiler... yes

      checking whether g77 accepts -g... yes

      checking the maximum length of command line arguments... 32768

      checking command to parse /usr/bin/nm -B output from gcc object... ok

      checking for objdir... .libs

      checking for ar... ar

      checking for ranlib... ranlib

      checking for strip... strip

      checking if gcc static flag  works... yes

      checking if gcc supports -fno-rtti -fno-exceptions... no

      checking for gcc option to produce PIC... -fPIC

      checking if gcc PIC flag -fPIC works... yes

      checking if gcc supports -c -o file.o... yes

      checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes

      checking whether -lc should be explicitly linked in... no

      checking dynamic linker characteristics... GNU/Linux ld.so

      checking how to hardcode library paths into programs... immediate

      checking whether stripping libraries is possible... yes

      checking for shl_load... no

      checking for shl_load in -ldld... no

      checking for dlopen... no

      checking for dlopen in -ldl... yes

      checking whether a program can dlopen itself... yes

      checking whether a statically linked program can dlopen itself... yes

      checking if libtool supports shared libraries... yes

      checking whether to build shared libraries... yes

      checking whether to build static libraries... no

      configure: creating libtool

      appending configuration tag "CXX" to libtool

      checking for ld used by g++... /usr/bin/ld -m elf_x86_64

      checking if the linker (/usr/bin/ld -m elf_x86_64) is GNU ld... yes

      checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes

      checking for g++ option to produce PIC... -fPIC

      checking if g++ PIC flag -fPIC works... yes

      checking if g++ supports -c -o file.o... yes

      checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes

      checking dynamic linker characteristics... GNU/Linux ld.so

      checking how to hardcode library paths into programs... immediate

      checking whether stripping libraries is possible... yes

      checking for shl_load... (cached) no

      checking for shl_load in -ldld... (cached) no

      checking for dlopen... (cached) no

      checking for dlopen in -ldl... (cached) yes

      checking whether a program can dlopen itself... (cached) yes

      checking whether a statically linked program can dlopen itself... (cached) yes

      appending configuration tag "F77" to libtool

      checking if libtool supports shared libraries... yes

      checking whether to build shared libraries... yes

      checking whether to build static libraries... no

      checking for g77 option to produce PIC... -fPIC

      checking if g77 PIC flag -fPIC works... yes

      checking if g77 supports -c -o file.o... yes

      checking whether the g77 linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes

      checking dynamic linker characteristics... GNU/Linux ld.so

      checking how to hardcode library paths into programs... immediate

      checking whether stripping libraries is possible... yes

      checking for library containing SQLGetPrivateProfileString... -lodbcinst

      checking for pthread_create in -lpthreads... no

      checking for pthread_create in -lpthread... yes

      checking for PQconnectdb in -lpq... no

      configure: error: libpq library not found

      [root@weblab357 psqlodbc-08.04.0200]#

      [root@weblab357 psqlodbc-08.04.0200]# ./configure --with-backends="pgsql"

      checking for a BSD-compatible install... /usr/bin/install -c

      checking whether build environment is sane... yes

      checking for gawk... gawk

      checking whether make sets $(MAKE)... yes

      checking whether to enable maintainer-specific portions of Makefiles... no

      checking for style of include used by make... GNU

      checking for gcc... gcc

      checking for C compiler default output file name... a.out

      checking whether the C compiler works... yes

      checking whether we are cross compiling... no

      checking for suffix of executables...

      checking for suffix of object files... o

      checking whether we are using the GNU C compiler... yes

      checking whether gcc accepts -g... yes

      checking for gcc option to accept ANSI C... none needed

      checking dependency style of gcc... gcc3

      checking for pg_config... no

      checking for gcc... (cached) gcc

      checking whether we are using the GNU C compiler... (cached) yes

      checking whether gcc accepts -g... (cached) yes

      checking for gcc option to accept ANSI C... (cached) none needed

      checking dependency style of gcc... (cached) gcc3

      checking build system type... x86_64-unknown-linux-gnu

      checking host system type... x86_64-unknown-linux-gnu

      checking for a sed that does not truncate output... /bin/sed

      checking for egrep... grep -E

      checking for ld used by gcc... /usr/bin/ld

      checking if the linker (/usr/bin/ld) is GNU ld... yes

      checking for /usr/bin/ld option to reload object files... -r

      checking for BSD-compatible nm... /usr/bin/nm -B

      checking whether ln -s works... yes

      checking how to recognise dependent libraries... pass_all

      checking how to run the C preprocessor... gcc -E

      checking for ANSI C header files... yes

      checking for sys/types.h... yes

      checking for sys/stat.h... yes

      checking for stdlib.h... yes

      checking for string.h... yes

      checking for memory.h... yes

      checking for strings.h... yes

      checking for inttypes.h... yes

      checking for stdint.h... yes

      checking for unistd.h... yes

      checking dlfcn.h usability... yes

      checking dlfcn.h presence... yes

      checking for dlfcn.h... yes

      checking for g++... g++

      checking whether we are using the GNU C++ compiler... yes

      checking whether g++ accepts -g... yes

      checking dependency style of g++... gcc3

      checking how to run the C++ preprocessor... g++ -E

      checking for g77... g77

      checking whether we are using the GNU Fortran 77 compiler... yes

      checking whether g77 accepts -g... yes

      checking the maximum length of command line arguments... 32768

      checking command to parse /usr/bin/nm -B output from gcc object... ok

      checking for objdir... .libs

      checking for ar... ar

      checking for ranlib... ranlib

      checking for strip... strip

      checking if gcc static flag  works... yes

      checking if gcc supports -fno-rtti -fno-exceptions... no

      checking for gcc option to produce PIC... -fPIC

      checking if gcc PIC flag -fPIC works... yes

      checking if gcc supports -c -o file.o... yes

      checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes

      checking whether -lc should be explicitly linked in... no

      checking dynamic linker characteristics... GNU/Linux ld.so

      checking how to hardcode library paths into programs... immediate

      checking whether stripping libraries is possible... yes

      checking for shl_load... no

      checking for shl_load in -ldld... no

      checking for dlopen... no

      checking for dlopen in -ldl... yes

      checking whether a program can dlopen itself... yes

      checking whether a statically linked program can dlopen itself... yes

      checking if libtool supports shared libraries... yes

      checking whether to build shared libraries... yes

      checking whether to build static libraries... no

      configure: creating libtool

      appending configuration tag "CXX" to libtool

      checking for ld used by g++... /usr/bin/ld -m elf_x86_64

      checking if the linker (/usr/bin/ld -m elf_x86_64) is GNU ld... yes

      checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes

      checking for g++ option to produce PIC... -fPIC

      checking if g++ PIC flag -fPIC works... yes

      checking if g++ supports -c -o file.o... yes

      checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes

      checking dynamic linker characteristics... GNU/Linux ld.so

      checking how to hardcode library paths into programs... immediate

      checking whether stripping libraries is possible... yes

      checking for shl_load... (cached) no

      checking for shl_load in -ldld... (cached) no

      checking for dlopen... (cached) no

      checking for dlopen in -ldl... (cached) yes

      checking whether a program can dlopen itself... (cached) yes

      checking whether a statically linked program can dlopen itself... (cached) yes

      appending configuration tag "F77" to libtool

      checking if libtool supports shared libraries... yes

      checking whether to build shared libraries... yes

      checking whether to build static libraries... no

      checking for g77 option to produce PIC... -fPIC

      checking if g77 PIC flag -fPIC works... yes

      checking if g77 supports -c -o file.o... yes

      checking whether the g77 linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes

      checking dynamic linker characteristics... GNU/Linux ld.so

      checking how to hardcode library paths into programs... immediate

      checking whether stripping libraries is possible... yes

      checking for library containing SQLGetPrivateProfileString... -lodbcinst

      checking for pthread_create in -lpthreads... no

      checking for pthread_create in -lpthread... yes

      checking for PQconnectdb in -lpq... no

      configure: error: libpq library not found

       

       

       

      Have anyone experienced this before? Please help.

       

      Best regards,

       

      Bo Sun