Building ODBC driver issue

I am having a problem building the Postgresql ODBC driver without
openSSL.

The output from the

1 % export PG_CONFIG=3D/c4_working/postgresql/pgsql/bin/pg_config
2 % export LD_LIBRARY_PATH=3D/c4_working/postgresql/iODBC/lib
3 % ls /c4_working/postgresql/pgsql/bin/pg_config
/c4_working/postgresql/pgsql/bin/pg_config*
4 % ls /c4_working/postgresql/iODBC/lib
../ libiodbcinst.la* libiodbc.la* libodbc.a@
.../ libiodbcinst.so@ libiodbc.so@
libodbc.so@
libiodbc.a libiodbcinst.so.2@ libiodbc.so.2@ pkgconfig/
libiodbcinst.a libiodbcinst.so.2.1.18* libiodbc.so.2.1.18*
5 % ./configure --disable-openssl
--with-iodbc=3D/c4_working/postgresql/iODBC
--prefix=3D/c4_working/postgresql/psqlodbc
--exec-prefix=3D/c4_working/postgresql/psqlodbc --enable-shared
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
configure: using -I/c4_working/postgresql/iODBC/include
-L/c4_working/postgresql/iODBC/lib -liodbc -liodbcinst
checking for pg_config... /c4_working/postgresql/pgsql/bin/pg_config
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...=20
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 ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... 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... /usr/bin/sed
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for ld used by gcc... /usr/x86_64-suse-linux/bin/ld
checking if the linker (/usr/x86_64-suse-linux/bin/ld) is GNU ld... yes
checking for /usr/x86_64-suse-linux/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... no
checking for f77... no
checking for xlf... no
checking for frt... no
checking for pgf77... no
checking for cf77... no
checking for fort77... no
checking for fl32... no
checking for af77... no
checking for f90... no
checking for xlf90... no
checking for pgf90... no
checking for pghpf... no
checking for epcf90... no
checking for gfortran... no
checking for g95... no
checking for f95... no
checking for fort... no
checking for xlf95... no
checking for ifort... no
checking for ifc... no
checking for efc... no
checking for pgf95... no
checking for lf95... no
checking for ftn... no
checking whether we are using the GNU Fortran 77 compiler... no
checking whether accepts -g... no
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 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 static flag -static works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/x86_64-suse-linux/bin/ld -m
elf_x86_64) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... cat:
/etc/ld.so.conf.d/*.conf: No such file or directory
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... yes
checking whether a program can dlopen itself... yes
checking whether a statically linked program can dlopen itself... no
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/x86_64-suse-linux/bin/ld -m
elf_x86_64
checking if the linker (/usr/x86_64-suse-linux/bin/ld -m elf_x86_64) is
GNU ld... yes
checking whether the g++ linker (/usr/x86_64-suse-linux/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++ static flag -static works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/x86_64-suse-linux/bin/ld -m
elf_x86_64) supports shared libraries... yes
checking dynamic linker characteristics... cat:
/etc/ld.so.conf.d/*.conf: No such file or directory
GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
appending configuration tag "F77" to libtool
checking for library containing SQLGetPrivateProfileString... none
required
checking for pthread_create in -lpthreads... no
checking for pthread_create in -lpthread... yes
checking locale.h usability... yes
checking locale.h presence... yes
checking for locale.h... yes
checking sys/un.h usability... yes
checking sys/un.h presence... yes
checking for sys/un.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking whether time.h and sys/time.h may both be included... yes
checking for long... yes
checking size of long... 8
checking for void *... yes
checking size of void *... 8
checking for long long... yes
checking for ssize_t... yes
checking for size_t... yes
checking whether struct tm is in sys/time.h or time.h... time.h
checking for struct addrinfo... yes
checking for an ANSI C-conforming const... yes
checking for strerror_r... yes
checking for strtoul... yes
checking for strtoll... yes
checking for iswascii... no
checking for localtime_r... yes
checking for strtok_r... yes
checking for pthread_mutexattr_settype... yes
configure: creating ./config.status
config.status: creating Makefile
config.status: creating config.h
config.status: config.h is unchanged
config.status: executing depfiles commands
6 % make clean
test -z "psqlodbcw.la" || rm -f psqlodbcw.la
rm -f "./so_locations"
rm -rf .libs _libs
rm -f *.o
rm -f *.lo
7 % make
make all-am
make[1]: Entering directory `/c4_working/postgresql/psqlodbc-08.02.0500'
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT info.lo -MD -MP -MF
".deps/info.Tpo" -c -o info.lo info.c; \
then mv -f ".deps/info.Tpo" ".deps/info.Plo"; else rm -f
".deps/info.Tpo"; exit 1; fi
mkdir .libs
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT info.lo -MD -MP -MF
..deps/info.Tpo -c info.c -fPIC -DPIC -o .libs/info.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT bind.lo -MD -MP -MF
".deps/bind.Tpo" -c -o bind.lo bind.c; \
then mv -f ".deps/bind.Tpo" ".deps/bind.Plo"; else rm -f
".deps/bind.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT bind.lo -MD -MP -MF
..deps/bind.Tpo -c bind.c -fPIC -DPIC -o .libs/bind.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT columninfo.lo -MD -MP
-MF ".deps/columninfo.Tpo" -c -o columninfo.lo columninfo.c; \
then mv -f ".deps/columninfo.Tpo" ".deps/columninfo.Plo"; else rm -f
".deps/columninfo.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT columninfo.lo -MD -MP
-MF .deps/columninfo.Tpo -c columninfo.c -fPIC -DPIC -o
..libs/columninfo.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT connection.lo -MD -MP
-MF ".deps/connection.Tpo" -c -o connection.lo connection.c; \
then mv -f ".deps/connection.Tpo" ".deps/connection.Plo"; else rm -f
".deps/connection.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT connection.lo -MD -MP
-MF .deps/connection.Tpo -c connection.c -fPIC -DPIC -o
..libs/connection.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT convert.lo -MD -MP
-MF ".deps/convert.Tpo" -c -o convert.lo convert.c; \
then mv -f ".deps/convert.Tpo" ".deps/convert.Plo"; else rm -f
".deps/convert.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT convert.lo -MD -MP -MF
..deps/convert.Tpo -c convert.c -fPIC -DPIC -o .libs/convert.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT drvconn.lo -MD -MP
-MF ".deps/drvconn.Tpo" -c -o drvconn.lo drvconn.c; \
then mv -f ".deps/drvconn.Tpo" ".deps/drvconn.Plo"; else rm -f
".deps/drvconn.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT drvconn.lo -MD -MP -MF
..deps/drvconn.Tpo -c drvconn.c -fPIC -DPIC -o .libs/drvconn.o
drvconn.c: In function 'dconn_get_connect_attributes':
drvconn.c:492: warning: passing argument 1 of 'dconn_get_attributes'
from incompatible pointer type
drvconn.c: In function 'dconn_get_common_attributes':
drvconn.c:498: warning: passing argument 1 of 'dconn_get_attributes'
from incompatible pointer type
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT environ.lo -MD -MP
-MF ".deps/environ.Tpo" -c -o environ.lo environ.c; \
then mv -f ".deps/environ.Tpo" ".deps/environ.Plo"; else rm -f
".deps/environ.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT environ.lo -MD -MP -MF
..deps/environ.Tpo -c environ.c -fPIC -DPIC -o .libs/environ.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT execute.lo -MD -MP
-MF ".deps/execute.Tpo" -c -o execute.lo execute.c; \
then mv -f ".deps/execute.Tpo" ".deps/execute.Plo"; else rm -f
".deps/execute.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT execute.lo -MD -MP -MF
..deps/execute.Tpo -c execute.c -fPIC -DPIC -o .libs/execute.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT lobj.lo -MD -MP -MF
".deps/lobj.Tpo" -c -o lobj.lo lobj.c; \
then mv -f ".deps/lobj.Tpo" ".deps/lobj.Plo"; else rm -f
".deps/lobj.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT lobj.lo -MD -MP -MF
..deps/lobj.Tpo -c lobj.c -fPIC -DPIC -o .libs/lobj.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT win_md5.lo -MD -MP
-MF ".deps/win_md5.Tpo" -c -o win_md5.lo win_md5.c; \
then mv -f ".deps/win_md5.Tpo" ".deps/win_md5.Plo"; else rm -f
".deps/win_md5.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT win_md5.lo -MD -MP -MF
..deps/win_md5.Tpo -c win_md5.c -fPIC -DPIC -o .libs/win_md5.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT misc.lo -MD -MP -MF
".deps/misc.Tpo" -c -o misc.lo misc.c; \
then mv -f ".deps/misc.Tpo" ".deps/misc.Plo"; else rm -f
".deps/misc.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT misc.lo -MD -MP -MF
..deps/misc.Tpo -c misc.c -fPIC -DPIC -o .libs/misc.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT options.lo -MD -MP
-MF ".deps/options.Tpo" -c -o options.lo options.c; \
then mv -f ".deps/options.Tpo" ".deps/options.Plo"; else rm -f
".deps/options.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT options.lo -MD -MP -MF
..deps/options.Tpo -c options.c -fPIC -DPIC -o .libs/options.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT pgtypes.lo -MD -MP
-MF ".deps/pgtypes.Tpo" -c -o pgtypes.lo pgtypes.c; \
then mv -f ".deps/pgtypes.Tpo" ".deps/pgtypes.Plo"; else rm -f
".deps/pgtypes.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT pgtypes.lo -MD -MP -MF
..deps/pgtypes.Tpo -c pgtypes.c -fPIC -DPIC -o .libs/pgtypes.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT psqlodbc.lo -MD -MP
-MF ".deps/psqlodbc.Tpo" -c -o psqlodbc.lo psqlodbc.c; \
then mv -f ".deps/psqlodbc.Tpo" ".deps/psqlodbc.Plo"; else rm -f
".deps/psqlodbc.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT psqlodbc.lo -MD -MP
-MF .deps/psqlodbc.Tpo -c psqlodbc.c -fPIC -DPIC -o .libs/psqlodbc.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT qresult.lo -MD -MP
-MF ".deps/qresult.Tpo" -c -o qresult.lo qresult.c; \
then mv -f ".deps/qresult.Tpo" ".deps/qresult.Plo"; else rm -f
".deps/qresult.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT qresult.lo -MD -MP -MF
..deps/qresult.Tpo -c qresult.c -fPIC -DPIC -o .libs/qresult.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT results.lo -MD -MP
-MF ".deps/results.Tpo" -c -o results.lo results.c; \
then mv -f ".deps/results.Tpo" ".deps/results.Plo"; else rm -f
".deps/results.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT results.lo -MD -MP -MF
..deps/results.Tpo -c results.c -fPIC -DPIC -o .libs/results.o
results.c: In function 'enlargeUpdated':
results.c:2455: warning: assignment from incompatible pointer type
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT socket.lo -MD -MP -MF
".deps/socket.Tpo" -c -o socket.lo socket.c; \
then mv -f ".deps/socket.Tpo" ".deps/socket.Plo"; else rm -f
".deps/socket.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT socket.lo -MD -MP -MF
..deps/socket.Tpo -c socket.c -fPIC -DPIC -o .libs/socket.o
socket.c:16:25: error: openssl/ssl.h: No such file or directory
socket.c:155: warning: initialization from incompatible pointer type
socket.c: In function 'format_sockerr':
socket.c:175: warning: cast to pointer from integer of different size
socket.c: In function 'SOCK_SSL_recv':
socket.c:487: error: 'SSL_ERROR_NONE' undeclared (first use in this
function)
socket.c:487: error: (Each undeclared identifier is reported only once
socket.c:487: error: for each function it appears in.)
socket.c:489: error: 'SSL_ERROR_WANT_READ' undeclared (first use in this
function)
socket.c:495: error: 'SSL_ERROR_WANT_WRITE' undeclared (first use in
this function)
socket.c:498: error: 'SSL_ERROR_SYSCALL' undeclared (first use in this
function)
socket.c:505: error: 'SSL_ERROR_SSL' undeclared (first use in this
function)
socket.c:506: error: 'SSL_ERROR_ZERO_RETURN' undeclared (first use in
this function)
socket.c: In function 'SOCK_SSL_send':
socket.c:532: error: 'SSL_ERROR_NONE' undeclared (first use in this
function)
socket.c:534: error: 'SSL_ERROR_WANT_READ' undeclared (first use in this
function)
socket.c:535: error: 'SSL_ERROR_WANT_WRITE' undeclared (first use in
this function)
socket.c:541: error: 'SSL_ERROR_SYSCALL' undeclared (first use in this
function)
socket.c:548: error: 'SSL_ERROR_SSL' undeclared (first use in this
function)
socket.c:549: error: 'SSL_ERROR_ZERO_RETURN' undeclared (first use in
this function)
make[1]: *** [socket.lo] Error 1
make[1]: Leaving directory `/c4_working/postgresql/psqlodbc-08.02.0500'
make: *** [all] Error 2
10 % gcc --version
gcc (GCC) 4.1.2 20070115 (prerelease) (SUSE Linux)
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is
NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE.

11 % uname -a
Linux c4dev-lathrs1 2.6.16.46-0.14-smp #1 SMP Thu May 17 14:00:09 UTC
2007
x86_64 x86_64 x86_64 GNU/Linux

__________________
Stephen M. Lathrop mailto:lathrop_steve@emc.com
EMC Corporation phone: (508) 305-8596
32 Coslin Drive internal: 824-48596
Southboro, MA 01772 fax: (508) 305-8474
www.emc.com

Have-a-heck-of-a-day
4 under 4 apart

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: Building ODBC driver issue

Hi.

Uga...Surely disable was not effective:-( ....sorry.
Although it is ad hoc, please comment out USE_SSL of config.h for yourself.
I will improve again. Thanks this report!

Regards,
Hiroshi Saito

----- Original Message -----
From:
To:
Sent: Friday, January 25, 2008 11:42 PM
Subject: [ODBC] Building ODBC driver issue


I am having a problem building the Postgresql ODBC driver without
openSSL.

The output from the

1 % export PG_CONFIG=/c4_working/postgresql/pgsql/bin/pg_config
2 % export LD_LIBRARY_PATH=/c4_working/postgresql/iODBC/lib
3 % ls /c4_working/postgresql/pgsql/bin/pg_config
/c4_working/postgresql/pgsql/bin/pg_config*
4 % ls /c4_working/postgresql/iODBC/lib
../ libiodbcinst.la* libiodbc.la* libodbc.a@
.../ libiodbcinst.so@ libiodbc.so@
libodbc.so@
libiodbc.a libiodbcinst.so.2@ libiodbc.so.2@ pkgconfig/
libiodbcinst.a libiodbcinst.so.2.1.18* libiodbc.so.2.1.18*
5 % ./configure --disable-openssl
--with-iodbc=/c4_working/postgresql/iODBC
--prefix=/c4_working/postgresql/psqlodbc
--exec-prefix=/c4_working/postgresql/psqlodbc --enable-shared
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
configure: using -I/c4_working/postgresql/iODBC/include
-L/c4_working/postgresql/iODBC/lib -liodbc -liodbcinst
checking for pg_config... /c4_working/postgresql/pgsql/bin/pg_config
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 ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... 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... /usr/bin/sed
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for ld used by gcc... /usr/x86_64-suse-linux/bin/ld
checking if the linker (/usr/x86_64-suse-linux/bin/ld) is GNU ld... yes
checking for /usr/x86_64-suse-linux/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... no
checking for f77... no
checking for xlf... no
checking for frt... no
checking for pgf77... no
checking for cf77... no
checking for fort77... no
checking for fl32... no
checking for af77... no
checking for f90... no
checking for xlf90... no
checking for pgf90... no
checking for pghpf... no
checking for epcf90... no
checking for gfortran... no
checking for g95... no
checking for f95... no
checking for fort... no
checking for xlf95... no
checking for ifort... no
checking for ifc... no
checking for efc... no
checking for pgf95... no
checking for lf95... no
checking for ftn... no
checking whether we are using the GNU Fortran 77 compiler... no
checking whether accepts -g... no
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 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 static flag -static works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/x86_64-suse-linux/bin/ld -m
elf_x86_64) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... cat:
/etc/ld.so.conf.d/*.conf: No such file or directory
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... yes
checking whether a program can dlopen itself... yes
checking whether a statically linked program can dlopen itself... no
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/x86_64-suse-linux/bin/ld -m
elf_x86_64
checking if the linker (/usr/x86_64-suse-linux/bin/ld -m elf_x86_64) is
GNU ld... yes
checking whether the g++ linker (/usr/x86_64-suse-linux/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++ static flag -static works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/x86_64-suse-linux/bin/ld -m
elf_x86_64) supports shared libraries... yes
checking dynamic linker characteristics... cat:
/etc/ld.so.conf.d/*.conf: No such file or directory
GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
appending configuration tag "F77" to libtool
checking for library containing SQLGetPrivateProfileString... none
required
checking for pthread_create in -lpthreads... no
checking for pthread_create in -lpthread... yes
checking locale.h usability... yes
checking locale.h presence... yes
checking for locale.h... yes
checking sys/un.h usability... yes
checking sys/un.h presence... yes
checking for sys/un.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking whether time.h and sys/time.h may both be included... yes
checking for long... yes
checking size of long... 8
checking for void *... yes
checking size of void *... 8
checking for long long... yes
checking for ssize_t... yes
checking for size_t... yes
checking whether struct tm is in sys/time.h or time.h... time.h
checking for struct addrinfo... yes
checking for an ANSI C-conforming const... yes
checking for strerror_r... yes
checking for strtoul... yes
checking for strtoll... yes
checking for iswascii... no
checking for localtime_r... yes
checking for strtok_r... yes
checking for pthread_mutexattr_settype... yes
configure: creating ./config.status
config.status: creating Makefile
config.status: creating config.h
config.status: config.h is unchanged
config.status: executing depfiles commands
6 % make clean
test -z "psqlodbcw.la" || rm -f psqlodbcw.la
rm -f "./so_locations"
rm -rf .libs _libs
rm -f *.o
rm -f *.lo
7 % make
make all-am
make[1]: Entering directory `/c4_working/postgresql/psqlodbc-08.02.0500'
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT info.lo -MD -MP -MF
".deps/info.Tpo" -c -o info.lo info.c; \
then mv -f ".deps/info.Tpo" ".deps/info.Plo"; else rm -f
".deps/info.Tpo"; exit 1; fi
mkdir .libs
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT info.lo -MD -MP -MF
..deps/info.Tpo -c info.c -fPIC -DPIC -o .libs/info.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT bind.lo -MD -MP -MF
".deps/bind.Tpo" -c -o bind.lo bind.c; \
then mv -f ".deps/bind.Tpo" ".deps/bind.Plo"; else rm -f
".deps/bind.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT bind.lo -MD -MP -MF
..deps/bind.Tpo -c bind.c -fPIC -DPIC -o .libs/bind.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT columninfo.lo -MD -MP
-MF ".deps/columninfo.Tpo" -c -o columninfo.lo columninfo.c; \
then mv -f ".deps/columninfo.Tpo" ".deps/columninfo.Plo"; else rm -f
".deps/columninfo.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT columninfo.lo -MD -MP
-MF .deps/columninfo.Tpo -c columninfo.c -fPIC -DPIC -o
..libs/columninfo.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT connection.lo -MD -MP
-MF ".deps/connection.Tpo" -c -o connection.lo connection.c; \
then mv -f ".deps/connection.Tpo" ".deps/connection.Plo"; else rm -f
".deps/connection.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT connection.lo -MD -MP
-MF .deps/connection.Tpo -c connection.c -fPIC -DPIC -o
..libs/connection.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT convert.lo -MD -MP
-MF ".deps/convert.Tpo" -c -o convert.lo convert.c; \
then mv -f ".deps/convert.Tpo" ".deps/convert.Plo"; else rm -f
".deps/convert.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT convert.lo -MD -MP -MF
..deps/convert.Tpo -c convert.c -fPIC -DPIC -o .libs/convert.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT drvconn.lo -MD -MP
-MF ".deps/drvconn.Tpo" -c -o drvconn.lo drvconn.c; \
then mv -f ".deps/drvconn.Tpo" ".deps/drvconn.Plo"; else rm -f
".deps/drvconn.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT drvconn.lo -MD -MP -MF
..deps/drvconn.Tpo -c drvconn.c -fPIC -DPIC -o .libs/drvconn.o
drvconn.c: In function 'dconn_get_connect_attributes':
drvconn.c:492: warning: passing argument 1 of 'dconn_get_attributes'
from incompatible pointer type
drvconn.c: In function 'dconn_get_common_attributes':
drvconn.c:498: warning: passing argument 1 of 'dconn_get_attributes'
from incompatible pointer type
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT environ.lo -MD -MP
-MF ".deps/environ.Tpo" -c -o environ.lo environ.c; \
then mv -f ".deps/environ.Tpo" ".deps/environ.Plo"; else rm -f
".deps/environ.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT environ.lo -MD -MP -MF
..deps/environ.Tpo -c environ.c -fPIC -DPIC -o .libs/environ.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT execute.lo -MD -MP
-MF ".deps/execute.Tpo" -c -o execute.lo execute.c; \
then mv -f ".deps/execute.Tpo" ".deps/execute.Plo"; else rm -f
".deps/execute.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT execute.lo -MD -MP -MF
..deps/execute.Tpo -c execute.c -fPIC -DPIC -o .libs/execute.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT lobj.lo -MD -MP -MF
".deps/lobj.Tpo" -c -o lobj.lo lobj.c; \
then mv -f ".deps/lobj.Tpo" ".deps/lobj.Plo"; else rm -f
".deps/lobj.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT lobj.lo -MD -MP -MF
..deps/lobj.Tpo -c lobj.c -fPIC -DPIC -o .libs/lobj.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT win_md5.lo -MD -MP
-MF ".deps/win_md5.Tpo" -c -o win_md5.lo win_md5.c; \
then mv -f ".deps/win_md5.Tpo" ".deps/win_md5.Plo"; else rm -f
".deps/win_md5.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT win_md5.lo -MD -MP -MF
..deps/win_md5.Tpo -c win_md5.c -fPIC -DPIC -o .libs/win_md5.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT misc.lo -MD -MP -MF
".deps/misc.Tpo" -c -o misc.lo misc.c; \
then mv -f ".deps/misc.Tpo" ".deps/misc.Plo"; else rm -f
".deps/misc.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT misc.lo -MD -MP -MF
..deps/misc.Tpo -c misc.c -fPIC -DPIC -o .libs/misc.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT options.lo -MD -MP
-MF ".deps/options.Tpo" -c -o options.lo options.c; \
then mv -f ".deps/options.Tpo" ".deps/options.Plo"; else rm -f
".deps/options.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT options.lo -MD -MP -MF
..deps/options.Tpo -c options.c -fPIC -DPIC -o .libs/options.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT pgtypes.lo -MD -MP
-MF ".deps/pgtypes.Tpo" -c -o pgtypes.lo pgtypes.c; \
then mv -f ".deps/pgtypes.Tpo" ".deps/pgtypes.Plo"; else rm -f
".deps/pgtypes.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT pgtypes.lo -MD -MP -MF
..deps/pgtypes.Tpo -c pgtypes.c -fPIC -DPIC -o .libs/pgtypes.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT psqlodbc.lo -MD -MP
-MF ".deps/psqlodbc.Tpo" -c -o psqlodbc.lo psqlodbc.c; \
then mv -f ".deps/psqlodbc.Tpo" ".deps/psqlodbc.Plo"; else rm -f
".deps/psqlodbc.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT psqlodbc.lo -MD -MP
-MF .deps/psqlodbc.Tpo -c psqlodbc.c -fPIC -DPIC -o .libs/psqlodbc.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT qresult.lo -MD -MP
-MF ".deps/qresult.Tpo" -c -o qresult.lo qresult.c; \
then mv -f ".deps/qresult.Tpo" ".deps/qresult.Plo"; else rm -f
".deps/qresult.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT qresult.lo -MD -MP -MF
..deps/qresult.Tpo -c qresult.c -fPIC -DPIC -o .libs/qresult.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT results.lo -MD -MP
-MF ".deps/results.Tpo" -c -o results.lo results.c; \
then mv -f ".deps/results.Tpo" ".deps/results.Plo"; else rm -f
".deps/results.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT results.lo -MD -MP -MF
..deps/results.Tpo -c results.c -fPIC -DPIC -o .libs/results.o
results.c: In function 'enlargeUpdated':
results.c:2455: warning: assignment from incompatible pointer type
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT socket.lo -MD -MP -MF
".deps/socket.Tpo" -c -o socket.lo socket.c; \
then mv -f ".deps/socket.Tpo" ".deps/socket.Plo"; else rm -f
".deps/socket.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT socket.lo -MD -MP -MF
..deps/socket.Tpo -c socket.c -fPIC -DPIC -o .libs/socket.o
socket.c:16:25: error: openssl/ssl.h: No such file or directory
socket.c:155: warning: initialization from incompatible pointer type
socket.c: In function 'format_sockerr':
socket.c:175: warning: cast to pointer from integer of different size
socket.c: In function 'SOCK_SSL_recv':
socket.c:487: error: 'SSL_ERROR_NONE' undeclared (first use in this
function)
socket.c:487: error: (Each undeclared identifier is reported only once
socket.c:487: error: for each function it appears in.)
socket.c:489: error: 'SSL_ERROR_WANT_READ' undeclared (first use in this
function)
socket.c:495: error: 'SSL_ERROR_WANT_WRITE' undeclared (first use in
this function)
socket.c:498: error: 'SSL_ERROR_SYSCALL' undeclared (first use in this
function)
socket.c:505: error: 'SSL_ERROR_SSL' undeclared (first use in this
function)
socket.c:506: error: 'SSL_ERROR_ZERO_RETURN' undeclared (first use in
this function)
socket.c: In function 'SOCK_SSL_send':
socket.c:532: error: 'SSL_ERROR_NONE' undeclared (first use in this
function)
socket.c:534: error: 'SSL_ERROR_WANT_READ' undeclared (first use in this
function)
socket.c:535: error: 'SSL_ERROR_WANT_WRITE' undeclared (first use in
this function)
socket.c:541: error: 'SSL_ERROR_SYSCALL' undeclared (first use in this
function)
socket.c:548: error: 'SSL_ERROR_SSL' undeclared (first use in this
function)
socket.c:549: error: 'SSL_ERROR_ZERO_RETURN' undeclared (first use in
this function)
make[1]: *** [socket.lo] Error 1
make[1]: Leaving directory `/c4_working/postgresql/psqlodbc-08.02.0500'
make: *** [all] Error 2
10 % gcc --version
gcc (GCC) 4.1.2 20070115 (prerelease) (SUSE Linux)
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is
NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE.

11 % uname -a
Linux c4dev-lathrs1 2.6.16.46-0.14-smp #1 SMP Thu May 17 14:00:09 UTC
2007
x86_64 x86_64 x86_64 GNU/Linux

__________________
Stephen M. Lathrop mailto:lathrop_steve@emc.com
EMC Corporation phone: (508) 305-8596
32 Coslin Drive internal: 824-48596
Southboro, MA 01772 fax: (508) 305-8474
www.emc.com

Have-a-heck-of-a-day
4 under 4 apart

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: Building ODBC driver issue

I don't have openssl installed on my machine, so, I also had to modify
socket.c to:

#ifdef USE_SSL
#include
#endif

-----Original Message-----
From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]=20
Sent: Friday, January 25, 2008 11:16 AM
To: Lathrop, Steve; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Building ODBC driver issue

Hi.

Uga...Surely disable was not effective:-( ....sorry.
Although it is ad hoc, please comment out USE_SSL of config.h for
yourself.
I will improve again. Thanks this report!

Regards,
Hiroshi Saito

----- Original Message -----=20
From:
To:
Sent: Friday, January 25, 2008 11:42 PM
Subject: [ODBC] Building ODBC driver issue


I am having a problem building the Postgresql ODBC driver without
openSSL.

The output from the

1 % export PG_CONFIG=3D/c4_working/postgresql/pgsql/bin/pg_config
2 % export LD_LIBRARY_PATH=3D/c4_working/postgresql/iODBC/lib
3 % ls /c4_working/postgresql/pgsql/bin/pg_config
/c4_working/postgresql/pgsql/bin/pg_config*
4 % ls /c4_working/postgresql/iODBC/lib
../ libiodbcinst.la* libiodbc.la* libodbc.a@
.../ libiodbcinst.so@ libiodbc.so@
libodbc.so@
libiodbc.a libiodbcinst.so.2@ libiodbc.so.2@ pkgconfig/
libiodbcinst.a libiodbcinst.so.2.1.18* libiodbc.so.2.1.18*
5 % ./configure --disable-openssl
--with-iodbc=3D/c4_working/postgresql/iODBC
--prefix=3D/c4_working/postgresql/psqlodbc
--exec-prefix=3D/c4_working/postgresql/psqlodbc --enable-shared
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
configure: using -I/c4_working/postgresql/iODBC/include
-L/c4_working/postgresql/iODBC/lib -liodbc -liodbcinst
checking for pg_config... /c4_working/postgresql/pgsql/bin/pg_config
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...=20
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 ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... 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... /usr/bin/sed
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for ld used by gcc... /usr/x86_64-suse-linux/bin/ld
checking if the linker (/usr/x86_64-suse-linux/bin/ld) is GNU ld... yes
checking for /usr/x86_64-suse-linux/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... no
checking for f77... no
checking for xlf... no
checking for frt... no
checking for pgf77... no
checking for cf77... no
checking for fort77... no
checking for fl32... no
checking for af77... no
checking for f90... no
checking for xlf90... no
checking for pgf90... no
checking for pghpf... no
checking for epcf90... no
checking for gfortran... no
checking for g95... no
checking for f95... no
checking for fort... no
checking for xlf95... no
checking for ifort... no
checking for ifc... no
checking for efc... no
checking for pgf95... no
checking for lf95... no
checking for ftn... no
checking whether we are using the GNU Fortran 77 compiler... no
checking whether accepts -g... no
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 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 static flag -static works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/x86_64-suse-linux/bin/ld -m
elf_x86_64) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... cat:
/etc/ld.so.conf.d/*.conf: No such file or directory
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... yes
checking whether a program can dlopen itself... yes
checking whether a statically linked program can dlopen itself... no
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/x86_64-suse-linux/bin/ld -m
elf_x86_64
checking if the linker (/usr/x86_64-suse-linux/bin/ld -m elf_x86_64) is
GNU ld... yes
checking whether the g++ linker (/usr/x86_64-suse-linux/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++ static flag -static works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/x86_64-suse-linux/bin/ld -m
elf_x86_64) supports shared libraries... yes
checking dynamic linker characteristics... cat:
/etc/ld.so.conf.d/*.conf: No such file or directory
GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
appending configuration tag "F77" to libtool
checking for library containing SQLGetPrivateProfileString... none
required
checking for pthread_create in -lpthreads... no
checking for pthread_create in -lpthread... yes
checking locale.h usability... yes
checking locale.h presence... yes
checking for locale.h... yes
checking sys/un.h usability... yes
checking sys/un.h presence... yes
checking for sys/un.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking whether time.h and sys/time.h may both be included... yes
checking for long... yes
checking size of long... 8
checking for void *... yes
checking size of void *... 8
checking for long long... yes
checking for ssize_t... yes
checking for size_t... yes
checking whether struct tm is in sys/time.h or time.h... time.h
checking for struct addrinfo... yes
checking for an ANSI C-conforming const... yes
checking for strerror_r... yes
checking for strtoul... yes
checking for strtoll... yes
checking for iswascii... no
checking for localtime_r... yes
checking for strtok_r... yes
checking for pthread_mutexattr_settype... yes
configure: creating ./config.status
config.status: creating Makefile
config.status: creating config.h
config.status: config.h is unchanged
config.status: executing depfiles commands
6 % make clean
test -z "psqlodbcw.la" || rm -f psqlodbcw.la
rm -f "./so_locations"
rm -rf .libs _libs
rm -f *.o
rm -f *.lo
7 % make
make all-am
make[1]: Entering directory `/c4_working/postgresql/psqlodbc-08.02.0500'
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT info.lo -MD -MP -MF
".deps/info.Tpo" -c -o info.lo info.c; \
then mv -f ".deps/info.Tpo" ".deps/info.Plo"; else rm -f
".deps/info.Tpo"; exit 1; fi
mkdir .libs
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT info.lo -MD -MP -MF
..deps/info.Tpo -c info.c -fPIC -DPIC -o .libs/info.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT bind.lo -MD -MP -MF
".deps/bind.Tpo" -c -o bind.lo bind.c; \
then mv -f ".deps/bind.Tpo" ".deps/bind.Plo"; else rm -f
".deps/bind.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT bind.lo -MD -MP -MF
..deps/bind.Tpo -c bind.c -fPIC -DPIC -o .libs/bind.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT columninfo.lo -MD -MP
-MF ".deps/columninfo.Tpo" -c -o columninfo.lo columninfo.c; \
then mv -f ".deps/columninfo.Tpo" ".deps/columninfo.Plo"; else rm -f
".deps/columninfo.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT columninfo.lo -MD -MP
-MF .deps/columninfo.Tpo -c columninfo.c -fPIC -DPIC -o
..libs/columninfo.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT connection.lo -MD -MP
-MF ".deps/connection.Tpo" -c -o connection.lo connection.c; \
then mv -f ".deps/connection.Tpo" ".deps/connection.Plo"; else rm -f
".deps/connection.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT connection.lo -MD -MP
-MF .deps/connection.Tpo -c connection.c -fPIC -DPIC -o
..libs/connection.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT convert.lo -MD -MP
-MF ".deps/convert.Tpo" -c -o convert.lo convert.c; \
then mv -f ".deps/convert.Tpo" ".deps/convert.Plo"; else rm -f
".deps/convert.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT convert.lo -MD -MP -MF
..deps/convert.Tpo -c convert.c -fPIC -DPIC -o .libs/convert.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT drvconn.lo -MD -MP
-MF ".deps/drvconn.Tpo" -c -o drvconn.lo drvconn.c; \
then mv -f ".deps/drvconn.Tpo" ".deps/drvconn.Plo"; else rm -f
".deps/drvconn.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT drvconn.lo -MD -MP -MF
..deps/drvconn.Tpo -c drvconn.c -fPIC -DPIC -o .libs/drvconn.o
drvconn.c: In function 'dconn_get_connect_attributes':
drvconn.c:492: warning: passing argument 1 of 'dconn_get_attributes'
from incompatible pointer type
drvconn.c: In function 'dconn_get_common_attributes':
drvconn.c:498: warning: passing argument 1 of 'dconn_get_attributes'
from incompatible pointer type
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT environ.lo -MD -MP
-MF ".deps/environ.Tpo" -c -o environ.lo environ.c; \
then mv -f ".deps/environ.Tpo" ".deps/environ.Plo"; else rm -f
".deps/environ.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT environ.lo -MD -MP -MF
..deps/environ.Tpo -c environ.c -fPIC -DPIC -o .libs/environ.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT execute.lo -MD -MP
-MF ".deps/execute.Tpo" -c -o execute.lo execute.c; \
then mv -f ".deps/execute.Tpo" ".deps/execute.Plo"; else rm -f
".deps/execute.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT execute.lo -MD -MP -MF
..deps/execute.Tpo -c execute.c -fPIC -DPIC -o .libs/execute.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT lobj.lo -MD -MP -MF
".deps/lobj.Tpo" -c -o lobj.lo lobj.c; \
then mv -f ".deps/lobj.Tpo" ".deps/lobj.Plo"; else rm -f
".deps/lobj.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT lobj.lo -MD -MP -MF
..deps/lobj.Tpo -c lobj.c -fPIC -DPIC -o .libs/lobj.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT win_md5.lo -MD -MP
-MF ".deps/win_md5.Tpo" -c -o win_md5.lo win_md5.c; \
then mv -f ".deps/win_md5.Tpo" ".deps/win_md5.Plo"; else rm -f
".deps/win_md5.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT win_md5.lo -MD -MP -MF
..deps/win_md5.Tpo -c win_md5.c -fPIC -DPIC -o .libs/win_md5.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT misc.lo -MD -MP -MF
".deps/misc.Tpo" -c -o misc.lo misc.c; \
then mv -f ".deps/misc.Tpo" ".deps/misc.Plo"; else rm -f
".deps/misc.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT misc.lo -MD -MP -MF
..deps/misc.Tpo -c misc.c -fPIC -DPIC -o .libs/misc.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT options.lo -MD -MP
-MF ".deps/options.Tpo" -c -o options.lo options.c; \
then mv -f ".deps/options.Tpo" ".deps/options.Plo"; else rm -f
".deps/options.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT options.lo -MD -MP -MF
..deps/options.Tpo -c options.c -fPIC -DPIC -o .libs/options.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT pgtypes.lo -MD -MP
-MF ".deps/pgtypes.Tpo" -c -o pgtypes.lo pgtypes.c; \
then mv -f ".deps/pgtypes.Tpo" ".deps/pgtypes.Plo"; else rm -f
".deps/pgtypes.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT pgtypes.lo -MD -MP -MF
..deps/pgtypes.Tpo -c pgtypes.c -fPIC -DPIC -o .libs/pgtypes.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT psqlodbc.lo -MD -MP
-MF ".deps/psqlodbc.Tpo" -c -o psqlodbc.lo psqlodbc.c; \
then mv -f ".deps/psqlodbc.Tpo" ".deps/psqlodbc.Plo"; else rm -f
".deps/psqlodbc.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT psqlodbc.lo -MD -MP
-MF .deps/psqlodbc.Tpo -c psqlodbc.c -fPIC -DPIC -o .libs/psqlodbc.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT qresult.lo -MD -MP
-MF ".deps/qresult.Tpo" -c -o qresult.lo qresult.c; \
then mv -f ".deps/qresult.Tpo" ".deps/qresult.Plo"; else rm -f
".deps/qresult.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT qresult.lo -MD -MP -MF
..deps/qresult.Tpo -c qresult.c -fPIC -DPIC -o .libs/qresult.o
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT results.lo -MD -MP
-MF ".deps/results.Tpo" -c -o results.lo results.c; \
then mv -f ".deps/results.Tpo" ".deps/results.Plo"; else rm -f
".deps/results.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT results.lo -MD -MP -MF
..deps/results.Tpo -c results.c -fPIC -DPIC -o .libs/results.o
results.c: In function 'enlargeUpdated':
results.c:2455: warning: assignment from incompatible pointer type
if /bin/sh ./libtool --tag=3DCC --mode=3Dcompile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT socket.lo -MD -MP -MF
".deps/socket.Tpo" -c -o socket.lo socket.c; \
then mv -f ".deps/socket.Tpo" ".deps/socket.Plo"; else rm -f
".deps/socket.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT socket.lo -MD -MP -MF
..deps/socket.Tpo -c socket.c -fPIC -DPIC -o .libs/socket.o
socket.c:16:25: error: openssl/ssl.h: No such file or directory
socket.c:155: warning: initialization from incompatible pointer type
socket.c: In function 'format_sockerr':
socket.c:175: warning: cast to pointer from integer of different size
socket.c: In function 'SOCK_SSL_recv':
socket.c:487: error: 'SSL_ERROR_NONE' undeclared (first use in this
function)
socket.c:487: error: (Each undeclared identifier is reported only once
socket.c:487: error: for each function it appears in.)
socket.c:489: error: 'SSL_ERROR_WANT_READ' undeclared (first use in this
function)
socket.c:495: error: 'SSL_ERROR_WANT_WRITE' undeclared (first use in
this function)
socket.c:498: error: 'SSL_ERROR_SYSCALL' undeclared (first use in this
function)
socket.c:505: error: 'SSL_ERROR_SSL' undeclared (first use in this
function)
socket.c:506: error: 'SSL_ERROR_ZERO_RETURN' undeclared (first use in
this function)
socket.c: In function 'SOCK_SSL_send':
socket.c:532: error: 'SSL_ERROR_NONE' undeclared (first use in this
function)
socket.c:534: error: 'SSL_ERROR_WANT_READ' undeclared (first use in this
function)
socket.c:535: error: 'SSL_ERROR_WANT_WRITE' undeclared (first use in
this function)
socket.c:541: error: 'SSL_ERROR_SYSCALL' undeclared (first use in this
function)
socket.c:548: error: 'SSL_ERROR_SSL' undeclared (first use in this
function)
socket.c:549: error: 'SSL_ERROR_ZERO_RETURN' undeclared (first use in
this function)
make[1]: *** [socket.lo] Error 1
make[1]: Leaving directory `/c4_working/postgresql/psqlodbc-08.02.0500'
make: *** [all] Error 2
10 % gcc --version
gcc (GCC) 4.1.2 20070115 (prerelease) (SUSE Linux)
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is
NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE.

11 % uname -a
Linux c4dev-lathrs1 2.6.16.46-0.14-smp #1 SMP Thu May 17 14:00:09 UTC
2007
x86_64 x86_64 x86_64 GNU/Linux

__________________
Stephen M. Lathrop mailto:lathrop_steve@emc.com
EMC Corporation phone: (508) 305-8596
32 Coslin Drive internal: 824-48596
Southboro, MA 01772 fax: (508) 305-8474
www.emc.com

Have-a-heck-of-a-day
4 under 4 apart

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Building ODBC driver issue

Hi.

Ooop sorry, I forgot the report to you.
Fixed this.

Subject: [COMMITTERS] psqlodbc - psqlodbc: Fix problem disable of USE_SSL.


> Log Message:
> -----------
> Fix problem disable of USE_SSL.
> Per report Stephen M. Lathrop.
>
> Modified Files:
> --------------
> psqlodbc:
> configure.ac (r1.72 -> r1.73)
> (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlod bc/configure.ac.diff?r1=1.72&r2=1.73)
>

Thanks!

Regards,
Hiroshi Saito

From:


I don't have openssl installed on my machine, so, I also had to modify
socket.c to:

#ifdef USE_SSL
#include
#endif

-----Original Message-----
From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]
Sent: Friday, January 25, 2008 11:16 AM
To: Lathrop, Steve; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Building ODBC driver issue

Hi.

Uga...Surely disable was not effective:-( ....sorry.
Although it is ad hoc, please comment out USE_SSL of config.h for
yourself.
I will improve again. Thanks this report!

Regards,
Hiroshi Saito

----- Original Message -----
From:
To:
Sent: Friday, January 25, 2008 11:42 PM
Subject: [ODBC] Building ODBC driver issue


I am having a problem building the Postgresql ODBC driver without
openSSL.

The output from the

1 % export PG_CONFIG=/c4_working/postgresql/pgsql/bin/pg_config
2 % export LD_LIBRARY_PATH=/c4_working/postgresql/iODBC/lib
3 % ls /c4_working/postgresql/pgsql/bin/pg_config
/c4_working/postgresql/pgsql/bin/pg_config*
4 % ls /c4_working/postgresql/iODBC/lib
../ libiodbcinst.la* libiodbc.la* libodbc.a@
.../ libiodbcinst.so@ libiodbc.so@
libodbc.so@
libiodbc.a libiodbcinst.so.2@ libiodbc.so.2@ pkgconfig/
libiodbcinst.a libiodbcinst.so.2.1.18* libiodbc.so.2.1.18*
5 % ./configure --disable-openssl
--with-iodbc=/c4_working/postgresql/iODBC
--prefix=/c4_working/postgresql/psqlodbc
--exec-prefix=/c4_working/postgresql/psqlodbc --enable-shared
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
configure: using -I/c4_working/postgresql/iODBC/include
-L/c4_working/postgresql/iODBC/lib -liodbc -liodbcinst
checking for pg_config... /c4_working/postgresql/pgsql/bin/pg_config
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 ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... 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... /usr/bin/sed
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for ld used by gcc... /usr/x86_64-suse-linux/bin/ld
checking if the linker (/usr/x86_64-suse-linux/bin/ld) is GNU ld... yes
checking for /usr/x86_64-suse-linux/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... no
checking for f77... no
checking for xlf... no
checking for frt... no
checking for pgf77... no
checking for cf77... no
checking for fort77... no
checking for fl32... no
checking for af77... no
checking for f90... no
checking for xlf90... no
checking for pgf90... no
checking for pghpf... no
checking for epcf90... no
checking for gfortran... no
checking for g95... no
checking for f95... no
checking for fort... no
checking for xlf95... no
checking for ifort... no
checking for ifc... no
checking for efc... no
checking for pgf95... no
checking for lf95... no
checking for ftn... no
checking whether we are using the GNU Fortran 77 compiler... no
checking whether accepts -g... no
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 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 static flag -static works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/x86_64-suse-linux/bin/ld -m
elf_x86_64) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... cat:
/etc/ld.so.conf.d/*.conf: No such file or directory
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... yes
checking whether a program can dlopen itself... yes
checking whether a statically linked program can dlopen itself... no
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/x86_64-suse-linux/bin/ld -m
elf_x86_64
checking if the linker (/usr/x86_64-suse-linux/bin/ld -m elf_x86_64) is
GNU ld... yes
checking whether the g++ linker (/usr/x86_64-suse-linux/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++ static flag -static works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/x86_64-suse-linux/bin/ld -m
elf_x86_64) supports shared libraries... yes
checking dynamic linker characteristics... cat:
/etc/ld.so.conf.d/*.conf: No such file or directory
GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
appending configuration tag "F77" to libtool
checking for library containing SQLGetPrivateProfileString... none
required
checking for pthread_create in -lpthreads... no
checking for pthread_create in -lpthread... yes
checking locale.h usability... yes
checking locale.h presence... yes
checking for locale.h... yes
checking sys/un.h usability... yes
checking sys/un.h presence... yes
checking for sys/un.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking whether time.h and sys/time.h may both be included... yes
checking for long... yes
checking size of long... 8
checking for void *... yes
checking size of void *... 8
checking for long long... yes
checking for ssize_t... yes
checking for size_t... yes
checking whether struct tm is in sys/time.h or time.h... time.h
checking for struct addrinfo... yes
checking for an ANSI C-conforming const... yes
checking for strerror_r... yes
checking for strtoul... yes
checking for strtoll... yes
checking for iswascii... no
checking for localtime_r... yes
checking for strtok_r... yes
checking for pthread_mutexattr_settype... yes
configure: creating ./config.status
config.status: creating Makefile
config.status: creating config.h
config.status: config.h is unchanged
config.status: executing depfiles commands
6 % make clean
test -z "psqlodbcw.la" || rm -f psqlodbcw.la
rm -f "./so_locations"
rm -rf .libs _libs
rm -f *.o
rm -f *.lo
7 % make
make all-am
make[1]: Entering directory `/c4_working/postgresql/psqlodbc-08.02.0500'
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT info.lo -MD -MP -MF
".deps/info.Tpo" -c -o info.lo info.c; \
then mv -f ".deps/info.Tpo" ".deps/info.Plo"; else rm -f
".deps/info.Tpo"; exit 1; fi
mkdir .libs
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT info.lo -MD -MP -MF
..deps/info.Tpo -c info.c -fPIC -DPIC -o .libs/info.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT bind.lo -MD -MP -MF
".deps/bind.Tpo" -c -o bind.lo bind.c; \
then mv -f ".deps/bind.Tpo" ".deps/bind.Plo"; else rm -f
".deps/bind.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT bind.lo -MD -MP -MF
..deps/bind.Tpo -c bind.c -fPIC -DPIC -o .libs/bind.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT columninfo.lo -MD -MP
-MF ".deps/columninfo.Tpo" -c -o columninfo.lo columninfo.c; \
then mv -f ".deps/columninfo.Tpo" ".deps/columninfo.Plo"; else rm -f
".deps/columninfo.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT columninfo.lo -MD -MP
-MF .deps/columninfo.Tpo -c columninfo.c -fPIC -DPIC -o
..libs/columninfo.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT connection.lo -MD -MP
-MF ".deps/connection.Tpo" -c -o connection.lo connection.c; \
then mv -f ".deps/connection.Tpo" ".deps/connection.Plo"; else rm -f
".deps/connection.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT connection.lo -MD -MP
-MF .deps/connection.Tpo -c connection.c -fPIC -DPIC -o
..libs/connection.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT convert.lo -MD -MP
-MF ".deps/convert.Tpo" -c -o convert.lo convert.c; \
then mv -f ".deps/convert.Tpo" ".deps/convert.Plo"; else rm -f
".deps/convert.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT convert.lo -MD -MP -MF
..deps/convert.Tpo -c convert.c -fPIC -DPIC -o .libs/convert.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT drvconn.lo -MD -MP
-MF ".deps/drvconn.Tpo" -c -o drvconn.lo drvconn.c; \
then mv -f ".deps/drvconn.Tpo" ".deps/drvconn.Plo"; else rm -f
".deps/drvconn.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT drvconn.lo -MD -MP -MF
..deps/drvconn.Tpo -c drvconn.c -fPIC -DPIC -o .libs/drvconn.o
drvconn.c: In function 'dconn_get_connect_attributes':
drvconn.c:492: warning: passing argument 1 of 'dconn_get_attributes'
from incompatible pointer type
drvconn.c: In function 'dconn_get_common_attributes':
drvconn.c:498: warning: passing argument 1 of 'dconn_get_attributes'
from incompatible pointer type
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT environ.lo -MD -MP
-MF ".deps/environ.Tpo" -c -o environ.lo environ.c; \
then mv -f ".deps/environ.Tpo" ".deps/environ.Plo"; else rm -f
".deps/environ.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT environ.lo -MD -MP -MF
..deps/environ.Tpo -c environ.c -fPIC -DPIC -o .libs/environ.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT execute.lo -MD -MP
-MF ".deps/execute.Tpo" -c -o execute.lo execute.c; \
then mv -f ".deps/execute.Tpo" ".deps/execute.Plo"; else rm -f
".deps/execute.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT execute.lo -MD -MP -MF
..deps/execute.Tpo -c execute.c -fPIC -DPIC -o .libs/execute.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT lobj.lo -MD -MP -MF
".deps/lobj.Tpo" -c -o lobj.lo lobj.c; \
then mv -f ".deps/lobj.Tpo" ".deps/lobj.Plo"; else rm -f
".deps/lobj.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT lobj.lo -MD -MP -MF
..deps/lobj.Tpo -c lobj.c -fPIC -DPIC -o .libs/lobj.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT win_md5.lo -MD -MP
-MF ".deps/win_md5.Tpo" -c -o win_md5.lo win_md5.c; \
then mv -f ".deps/win_md5.Tpo" ".deps/win_md5.Plo"; else rm -f
".deps/win_md5.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT win_md5.lo -MD -MP -MF
..deps/win_md5.Tpo -c win_md5.c -fPIC -DPIC -o .libs/win_md5.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT misc.lo -MD -MP -MF
".deps/misc.Tpo" -c -o misc.lo misc.c; \
then mv -f ".deps/misc.Tpo" ".deps/misc.Plo"; else rm -f
".deps/misc.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT misc.lo -MD -MP -MF
..deps/misc.Tpo -c misc.c -fPIC -DPIC -o .libs/misc.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT options.lo -MD -MP
-MF ".deps/options.Tpo" -c -o options.lo options.c; \
then mv -f ".deps/options.Tpo" ".deps/options.Plo"; else rm -f
".deps/options.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT options.lo -MD -MP -MF
..deps/options.Tpo -c options.c -fPIC -DPIC -o .libs/options.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT pgtypes.lo -MD -MP
-MF ".deps/pgtypes.Tpo" -c -o pgtypes.lo pgtypes.c; \
then mv -f ".deps/pgtypes.Tpo" ".deps/pgtypes.Plo"; else rm -f
".deps/pgtypes.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT pgtypes.lo -MD -MP -MF
..deps/pgtypes.Tpo -c pgtypes.c -fPIC -DPIC -o .libs/pgtypes.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT psqlodbc.lo -MD -MP
-MF ".deps/psqlodbc.Tpo" -c -o psqlodbc.lo psqlodbc.c; \
then mv -f ".deps/psqlodbc.Tpo" ".deps/psqlodbc.Plo"; else rm -f
".deps/psqlodbc.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT psqlodbc.lo -MD -MP
-MF .deps/psqlodbc.Tpo -c psqlodbc.c -fPIC -DPIC -o .libs/psqlodbc.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT qresult.lo -MD -MP
-MF ".deps/qresult.Tpo" -c -o qresult.lo qresult.c; \
then mv -f ".deps/qresult.Tpo" ".deps/qresult.Plo"; else rm -f
".deps/qresult.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT qresult.lo -MD -MP -MF
..deps/qresult.Tpo -c qresult.c -fPIC -DPIC -o .libs/qresult.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT results.lo -MD -MP
-MF ".deps/results.Tpo" -c -o results.lo results.c; \
then mv -f ".deps/results.Tpo" ".deps/results.Plo"; else rm -f
".deps/results.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT results.lo -MD -MP -MF
..deps/results.Tpo -c results.c -fPIC -DPIC -o .libs/results.o
results.c: In function 'enlargeUpdated':
results.c:2455: warning: assignment from incompatible pointer type
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT socket.lo -MD -MP -MF
".deps/socket.Tpo" -c -o socket.lo socket.c; \
then mv -f ".deps/socket.Tpo" ".deps/socket.Plo"; else rm -f
".deps/socket.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
-I/c4_working/postgresql/pgsql/include -g -O2 -MT socket.lo -MD -MP -MF
..deps/socket.Tpo -c socket.c -fPIC -DPIC -o .libs/socket.o
socket.c:16:25: error: openssl/ssl.h: No such file or directory
socket.c:155: warning: initialization from incompatible pointer type
socket.c: In function 'format_sockerr':
socket.c:175: warning: cast to pointer from integer of different size
socket.c: In function 'SOCK_SSL_recv':
socket.c:487: error: 'SSL_ERROR_NONE' undeclared (first use in this
function)
socket.c:487: error: (Each undeclared identifier is reported only once
socket.c:487: error: for each function it appears in.)
socket.c:489: error: 'SSL_ERROR_WANT_READ' undeclared (first use in this
function)
socket.c:495: error: 'SSL_ERROR_WANT_WRITE' undeclared (first use in
this function)
socket.c:498: error: 'SSL_ERROR_SYSCALL' undeclared (first use in this
function)
socket.c:505: error: 'SSL_ERROR_SSL' undeclared (first use in this
function)
socket.c:506: error: 'SSL_ERROR_ZERO_RETURN' undeclared (first use in
this function)
socket.c: In function 'SOCK_SSL_send':
socket.c:532: error: 'SSL_ERROR_NONE' undeclared (first use in this
function)
socket.c:534: error: 'SSL_ERROR_WANT_READ' undeclared (first use in this
function)
socket.c:535: error: 'SSL_ERROR_WANT_WRITE' undeclared (first use in
this function)
socket.c:541: error: 'SSL_ERROR_SYSCALL' undeclared (first use in this
function)
socket.c:548: error: 'SSL_ERROR_SSL' undeclared (first use in this
function)
socket.c:549: error: 'SSL_ERROR_ZERO_RETURN' undeclared (first use in
this function)
make[1]: *** [socket.lo] Error 1
make[1]: Leaving directory `/c4_working/postgresql/psqlodbc-08.02.0500'
make: *** [all] Error 2
10 % gcc --version
gcc (GCC) 4.1.2 20070115 (prerelease) (SUSE Linux)
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is
NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE.

11 % uname -a
Linux c4dev-lathrs1 2.6.16.46-0.14-smp #1 SMP Thu May 17 14:00:09 UTC
2007
x86_64 x86_64 x86_64 GNU/Linux

__________________
Stephen M. Lathrop mailto:lathrop_steve@emc.com
EMC Corporation phone: (508) 305-8596
32 Coslin Drive internal: 824-48596
Southboro, MA 01772 fax: (508) 305-8474
www.emc.com

Have-a-heck-of-a-day
4 under 4 apart

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Re: Building ODBC driver issue

Uga..sorry
It is a misapprehension again.:-(
include was another bug.

I will check it...

Regards,
Hiroshi Saito

----- Original Message -----
From: "Hiroshi Saito"
To:
Cc:
Sent: Tuesday, January 29, 2008 12:03 AM
Subject: Re: [ODBC] Building ODBC driver issue


> Hi.
>
> Ooop sorry, I forgot the report to you.
> Fixed this.
>
> Subject: [COMMITTERS] psqlodbc - psqlodbc: Fix problem disable of USE_SSL.
>
>
>> Log Message:
>> -----------
>> Fix problem disable of USE_SSL.
>> Per report Stephen M. Lathrop.
>>
>> Modified Files:
>> --------------
>> psqlodbc:
>> configure.ac (r1.72 -> r1.73)
>> (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlod bc/configure.ac.diff?r1=1.72&r2=1.73)
>>
>
> Thanks!
>
> Regards,
> Hiroshi Saito
>
> From:
>
>
> I don't have openssl installed on my machine, so, I also had to modify
> socket.c to:
>
> #ifdef USE_SSL
> #include
> #endif
>
> -----Original Message-----
> From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]
> Sent: Friday, January 25, 2008 11:16 AM
> To: Lathrop, Steve; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Building ODBC driver issue
>
> Hi.
>
> Uga...Surely disable was not effective:-( ....sorry.
> Although it is ad hoc, please comment out USE_SSL of config.h for
> yourself.
> I will improve again. Thanks this report!
>
> Regards,
> Hiroshi Saito
>
> ----- Original Message -----
> From:
> To:
> Sent: Friday, January 25, 2008 11:42 PM
> Subject: [ODBC] Building ODBC driver issue
>
>
> I am having a problem building the Postgresql ODBC driver without
> openSSL.
>
> The output from the
>
> 1 % export PG_CONFIG=/c4_working/postgresql/pgsql/bin/pg_config
> 2 % export LD_LIBRARY_PATH=/c4_working/postgresql/iODBC/lib
> 3 % ls /c4_working/postgresql/pgsql/bin/pg_config
> /c4_working/postgresql/pgsql/bin/pg_config*
> 4 % ls /c4_working/postgresql/iODBC/lib
> ./ libiodbcinst.la* libiodbc.la* libodbc.a@
> ../ libiodbcinst.so@ libiodbc.so@
> libodbc.so@
> libiodbc.a libiodbcinst.so.2@ libiodbc.so.2@ pkgconfig/
> libiodbcinst.a libiodbcinst.so.2.1.18* libiodbc.so.2.1.18*
> 5 % ./configure --disable-openssl
> --with-iodbc=/c4_working/postgresql/iODBC
> --prefix=/c4_working/postgresql/psqlodbc
> --exec-prefix=/c4_working/postgresql/psqlodbc --enable-shared
> 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
> configure: using -I/c4_working/postgresql/iODBC/include
> -L/c4_working/postgresql/iODBC/lib -liodbc -liodbcinst
> checking for pg_config... /c4_working/postgresql/pgsql/bin/pg_config
> 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 ISO C89... none needed
> checking for style of include used by make... GNU
> checking dependency style of gcc... 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... /usr/bin/sed
> checking for grep that handles long lines and -e... /usr/bin/grep
> checking for egrep... /usr/bin/grep -E
> checking for ld used by gcc... /usr/x86_64-suse-linux/bin/ld
> checking if the linker (/usr/x86_64-suse-linux/bin/ld) is GNU ld... yes
> checking for /usr/x86_64-suse-linux/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... no
> checking for f77... no
> checking for xlf... no
> checking for frt... no
> checking for pgf77... no
> checking for cf77... no
> checking for fort77... no
> checking for fl32... no
> checking for af77... no
> checking for f90... no
> checking for xlf90... no
> checking for pgf90... no
> checking for pghpf... no
> checking for epcf90... no
> checking for gfortran... no
> checking for g95... no
> checking for f95... no
> checking for fort... no
> checking for xlf95... no
> checking for ifort... no
> checking for ifc... no
> checking for efc... no
> checking for pgf95... no
> checking for lf95... no
> checking for ftn... no
> checking whether we are using the GNU Fortran 77 compiler... no
> checking whether accepts -g... no
> 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 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 static flag -static works... yes
> checking if gcc supports -c -o file.o... yes
> checking whether the gcc linker (/usr/x86_64-suse-linux/bin/ld -m
> elf_x86_64) supports shared libraries... yes
> checking whether -lc should be explicitly linked in... no
> checking dynamic linker characteristics... cat:
> /etc/ld.so.conf.d/*.conf: No such file or directory
> 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... yes
> checking whether a program can dlopen itself... yes
> checking whether a statically linked program can dlopen itself... no
> 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/x86_64-suse-linux/bin/ld -m
> elf_x86_64
> checking if the linker (/usr/x86_64-suse-linux/bin/ld -m elf_x86_64) is
> GNU ld... yes
> checking whether the g++ linker (/usr/x86_64-suse-linux/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++ static flag -static works... yes
> checking if g++ supports -c -o file.o... yes
> checking whether the g++ linker (/usr/x86_64-suse-linux/bin/ld -m
> elf_x86_64) supports shared libraries... yes
> checking dynamic linker characteristics... cat:
> /etc/ld.so.conf.d/*.conf: No such file or directory
> GNU/Linux ld.so
> checking how to hardcode library paths into programs... immediate
> appending configuration tag "F77" to libtool
> checking for library containing SQLGetPrivateProfileString... none
> required
> checking for pthread_create in -lpthreads... no
> checking for pthread_create in -lpthread... yes
> checking locale.h usability... yes
> checking locale.h presence... yes
> checking for locale.h... yes
> checking sys/un.h usability... yes
> checking sys/un.h presence... yes
> checking for sys/un.h... yes
> checking sys/time.h usability... yes
> checking sys/time.h presence... yes
> checking for sys/time.h... yes
> checking whether time.h and sys/time.h may both be included... yes
> checking for long... yes
> checking size of long... 8
> checking for void *... yes
> checking size of void *... 8
> checking for long long... yes
> checking for ssize_t... yes
> checking for size_t... yes
> checking whether struct tm is in sys/time.h or time.h... time.h
> checking for struct addrinfo... yes
> checking for an ANSI C-conforming const... yes
> checking for strerror_r... yes
> checking for strtoul... yes
> checking for strtoll... yes
> checking for iswascii... no
> checking for localtime_r... yes
> checking for strtok_r... yes
> checking for pthread_mutexattr_settype... yes
> configure: creating ./config.status
> config.status: creating Makefile
> config.status: creating config.h
> config.status: config.h is unchanged
> config.status: executing depfiles commands
> 6 % make clean
> test -z "psqlodbcw.la" || rm -f psqlodbcw.la
> rm -f "./so_locations"
> rm -rf .libs _libs
> rm -f *.o
> rm -f *.lo
> 7 % make
> make all-am
> make[1]: Entering directory `/c4_working/postgresql/psqlodbc-08.02.0500'
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT info.lo -MD -MP -MF
> ".deps/info.Tpo" -c -o info.lo info.c; \
> then mv -f ".deps/info.Tpo" ".deps/info.Plo"; else rm -f
> ".deps/info.Tpo"; exit 1; fi
> mkdir .libs
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT info.lo -MD -MP -MF
> .deps/info.Tpo -c info.c -fPIC -DPIC -o .libs/info.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT bind.lo -MD -MP -MF
> ".deps/bind.Tpo" -c -o bind.lo bind.c; \
> then mv -f ".deps/bind.Tpo" ".deps/bind.Plo"; else rm -f
> ".deps/bind.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT bind.lo -MD -MP -MF
> .deps/bind.Tpo -c bind.c -fPIC -DPIC -o .libs/bind.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT columninfo.lo -MD -MP
> -MF ".deps/columninfo.Tpo" -c -o columninfo.lo columninfo.c; \
> then mv -f ".deps/columninfo.Tpo" ".deps/columninfo.Plo"; else rm -f
> ".deps/columninfo.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT columninfo.lo -MD -MP
> -MF .deps/columninfo.Tpo -c columninfo.c -fPIC -DPIC -o
> .libs/columninfo.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT connection.lo -MD -MP
> -MF ".deps/connection.Tpo" -c -o connection.lo connection.c; \
> then mv -f ".deps/connection.Tpo" ".deps/connection.Plo"; else rm -f
> ".deps/connection.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT connection.lo -MD -MP
> -MF .deps/connection.Tpo -c connection.c -fPIC -DPIC -o
> .libs/connection.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT convert.lo -MD -MP
> -MF ".deps/convert.Tpo" -c -o convert.lo convert.c; \
> then mv -f ".deps/convert.Tpo" ".deps/convert.Plo"; else rm -f
> ".deps/convert.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT convert.lo -MD -MP -MF
> .deps/convert.Tpo -c convert.c -fPIC -DPIC -o .libs/convert.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT drvconn.lo -MD -MP
> -MF ".deps/drvconn.Tpo" -c -o drvconn.lo drvconn.c; \
> then mv -f ".deps/drvconn.Tpo" ".deps/drvconn.Plo"; else rm -f
> ".deps/drvconn.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT drvconn.lo -MD -MP -MF
> .deps/drvconn.Tpo -c drvconn.c -fPIC -DPIC -o .libs/drvconn.o
> drvconn.c: In function 'dconn_get_connect_attributes':
> drvconn.c:492: warning: passing argument 1 of 'dconn_get_attributes'
> from incompatible pointer type
> drvconn.c: In function 'dconn_get_common_attributes':
> drvconn.c:498: warning: passing argument 1 of 'dconn_get_attributes'
> from incompatible pointer type
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT environ.lo -MD -MP
> -MF ".deps/environ.Tpo" -c -o environ.lo environ.c; \
> then mv -f ".deps/environ.Tpo" ".deps/environ.Plo"; else rm -f
> ".deps/environ.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT environ.lo -MD -MP -MF
> .deps/environ.Tpo -c environ.c -fPIC -DPIC -o .libs/environ.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT execute.lo -MD -MP
> -MF ".deps/execute.Tpo" -c -o execute.lo execute.c; \
> then mv -f ".deps/execute.Tpo" ".deps/execute.Plo"; else rm -f
> ".deps/execute.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT execute.lo -MD -MP -MF
> .deps/execute.Tpo -c execute.c -fPIC -DPIC -o .libs/execute.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT lobj.lo -MD -MP -MF
> ".deps/lobj.Tpo" -c -o lobj.lo lobj.c; \
> then mv -f ".deps/lobj.Tpo" ".deps/lobj.Plo"; else rm -f
> ".deps/lobj.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT lobj.lo -MD -MP -MF
> .deps/lobj.Tpo -c lobj.c -fPIC -DPIC -o .libs/lobj.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT win_md5.lo -MD -MP
> -MF ".deps/win_md5.Tpo" -c -o win_md5.lo win_md5.c; \
> then mv -f ".deps/win_md5.Tpo" ".deps/win_md5.Plo"; else rm -f
> ".deps/win_md5.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT win_md5.lo -MD -MP -MF
> .deps/win_md5.Tpo -c win_md5.c -fPIC -DPIC -o .libs/win_md5.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT misc.lo -MD -MP -MF
> ".deps/misc.Tpo" -c -o misc.lo misc.c; \
> then mv -f ".deps/misc.Tpo" ".deps/misc.Plo"; else rm -f
> ".deps/misc.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT misc.lo -MD -MP -MF
> .deps/misc.Tpo -c misc.c -fPIC -DPIC -o .libs/misc.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT options.lo -MD -MP
> -MF ".deps/options.Tpo" -c -o options.lo options.c; \
> then mv -f ".deps/options.Tpo" ".deps/options.Plo"; else rm -f
> ".deps/options.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT options.lo -MD -MP -MF
> .deps/options.Tpo -c options.c -fPIC -DPIC -o .libs/options.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT pgtypes.lo -MD -MP
> -MF ".deps/pgtypes.Tpo" -c -o pgtypes.lo pgtypes.c; \
> then mv -f ".deps/pgtypes.Tpo" ".deps/pgtypes.Plo"; else rm -f
> ".deps/pgtypes.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT pgtypes.lo -MD -MP -MF
> .deps/pgtypes.Tpo -c pgtypes.c -fPIC -DPIC -o .libs/pgtypes.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT psqlodbc.lo -MD -MP
> -MF ".deps/psqlodbc.Tpo" -c -o psqlodbc.lo psqlodbc.c; \
> then mv -f ".deps/psqlodbc.Tpo" ".deps/psqlodbc.Plo"; else rm -f
> ".deps/psqlodbc.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT psqlodbc.lo -MD -MP
> -MF .deps/psqlodbc.Tpo -c psqlodbc.c -fPIC -DPIC -o .libs/psqlodbc.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT qresult.lo -MD -MP
> -MF ".deps/qresult.Tpo" -c -o qresult.lo qresult.c; \
> then mv -f ".deps/qresult.Tpo" ".deps/qresult.Plo"; else rm -f
> ".deps/qresult.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT qresult.lo -MD -MP -MF
> .deps/qresult.Tpo -c qresult.c -fPIC -DPIC -o .libs/qresult.o
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT results.lo -MD -MP
> -MF ".deps/results.Tpo" -c -o results.lo results.c; \
> then mv -f ".deps/results.Tpo" ".deps/results.Plo"; else rm -f
> ".deps/results.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT results.lo -MD -MP -MF
> .deps/results.Tpo -c results.c -fPIC -DPIC -o .libs/results.o
> results.c: In function 'enlargeUpdated':
> results.c:2455: warning: assignment from incompatible pointer type
> if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
> -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT socket.lo -MD -MP -MF
> ".deps/socket.Tpo" -c -o socket.lo socket.c; \
> then mv -f ".deps/socket.Tpo" ".deps/socket.Plo"; else rm -f
> ".deps/socket.Tpo"; exit 1; fi
> gcc -DHAVE_CONFIG_H -I. -I. -I. -I/c4_working/postgresql/iODBC/include
> -I/c4_working/postgresql/pgsql/include -g -O2 -MT socket.lo -MD -MP -MF
> .deps/socket.Tpo -c socket.c -fPIC -DPIC -o .libs/socket.o
> socket.c:16:25: error: openssl/ssl.h: No such file or directory
> socket.c:155: warning: initialization from incompatible pointer type
> socket.c: In function 'format_sockerr':
> socket.c:175: warning: cast to pointer from integer of different size
> socket.c: In function 'SOCK_SSL_recv':
> socket.c:487: error: 'SSL_ERROR_NONE' undeclared (first use in this
> function)
> socket.c:487: error: (Each undeclared identifier is reported only once
> socket.c:487: error: for each function it appears in.)
> socket.c:489: error: 'SSL_ERROR_WANT_READ' undeclared (first use in this
> function)
> socket.c:495: error: 'SSL_ERROR_WANT_WRITE' undeclared (first use in
> this function)
> socket.c:498: error: 'SSL_ERROR_SYSCALL' undeclared (first use in this
> function)
> socket.c:505: error: 'SSL_ERROR_SSL' undeclared (first use in this
> function)
> socket.c:506: error: 'SSL_ERROR_ZERO_RETURN' undeclared (first use in
> this function)
> socket.c: In function 'SOCK_SSL_send':
> socket.c:532: error: 'SSL_ERROR_NONE' undeclared (first use in this
> function)
> socket.c:534: error: 'SSL_ERROR_WANT_READ' undeclared (first use in this
> function)
> socket.c:535: error: 'SSL_ERROR_WANT_WRITE' undeclared (first use in
> this function)
> socket.c:541: error: 'SSL_ERROR_SYSCALL' undeclared (first use in this
> function)
> socket.c:548: error: 'SSL_ERROR_SSL' undeclared (first use in this
> function)
> socket.c:549: error: 'SSL_ERROR_ZERO_RETURN' undeclared (first use in
> this function)
> make[1]: *** [socket.lo] Error 1
> make[1]: Leaving directory `/c4_working/postgresql/psqlodbc-08.02.0500'
> make: *** [all] Error 2
> 10 % gcc --version
> gcc (GCC) 4.1.2 20070115 (prerelease) (SUSE Linux)
> Copyright (C) 2006 Free Software Foundation, Inc.
> This is free software; see the source for copying conditions. There is
> NO
> warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR
> PURPOSE.
>
> 11 % uname -a
> Linux c4dev-lathrs1 2.6.16.46-0.14-smp #1 SMP Thu May 17 14:00:09 UTC
> 2007
> x86_64 x86_64 x86_64 GNU/Linux
>
> __________________
> Stephen M. Lathrop mailto:lathrop_steve@emc.com
> EMC Corporation phone: (508) 305-8596
> 32 Coslin Drive internal: 824-48596
> Southboro, MA 01772 fax: (508) 305-8474
> www.emc.com
>
> Have-a-heck-of-a-day
> 4 under 4 apart
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Building ODBC driver issue

Hi.

fixed now. thanks!!

Regards,
Hiroshi Saito

Subject: [COMMITTERS] psqlodbc - psqlodbc: Fix bug of the selection not using SSL.


> Log Message:
> -----------
> Fix bug of the selection not using SSL.
> Per report Stephen M. Lathrop.
>
> Modified Files:
> --------------
> psqlodbc:
> connection.c (r1.168 -> r1.169)
> (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlod bc/connection.c.diff?r1=1.168&r2=1.169)
> socket.c (r1.59 -> r1.60)
> (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlod bc/socket.c.diff?r1=1.59&r2=1.60)
> socket.h (r1.38 -> r1.39)
> (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlod bc/socket.h.diff?r1=1.38&r2=1.39)
> version.h (r1.117 -> r1.118)
> (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlod bc/version.h.diff?r1=1.117&r2=1.118)
>



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq