Re: [ODBC] ODBC for Mac OS

On Tuesday 27 March 2007 07:59, Hiroshi Saito wrote:
> Hi Sean-san.
>
> From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
>
> > On Monday 26 March 2007 21:56, Hiroshi Saito wrote:
> >> Hi Sean Davis-san.
> >>
> >> I am wishing this to help you.
> >> Thanks!
> >>
> >> Regards,
> >> Hiroshi Saito
> >
> > Thank you very much, Hiroshi, for the quick response. That change does
> > appear to have fixed the SSL problem. However, there are other problems.
> > I have attached the entire config.log and make output, but here is the
> > last part of the make output:
> >
> > gcc -o .libs/psqlodbcw.so -bundle .libs/info.o .libs/bind.o
> > .libs/columninfo.o .libs/connection.o .libs/convert.o .libs/drvconn.o
> > .libs/environ.o .libs/execut e.o .libs/lobj.o .libs/win_md5.o
> > .libs/misc.o .libs/options.o .libs/pgtypes.o .l ibs/psqlodbc.o
> > .libs/qresult.o .libs/results.o .libs/socket.o .libs/parse.o .lib
> > s/statement.o .libs/tuple.o .libs/dlg_specific.o .libs/loadlib.o
> > .libs/multibyte .o .libs/odbcapi.o .libs/descriptor.o .libs/odbcapi30.o
> > .libs/pgapi30.o .libs/in fo30.o .libs/mylog.o .libs/odbcapi30w.o
> > .libs/odbcapiw.o .libs/win_unicode.o -L /usr/local/pgsql/lib -lssl
> > -lcrypto
> > /usr/bin/ld: Undefined symbols:
>
> Uga...As for it, the link is generated as follows if original.
>
> gcc -shared .libs/info.o .libs/bind.o .libs/columninfo.o
> .libs/connection.o .libs/convert.o .libs/drvconn.o .libs/environ.o
> .libs/execute.o .libs/lobj.o .libs/win_md5.o .libs/misc.o .libs/options.o
> .libs/pgtypes.o .libs/psqlodbc.o .libs/qresult.o .libs/results.o
> .libs/socket.o .libs/parse.o .libs/statement.o .libs/tuple.o
> .libs/dlg_specific.o .libs/loadlib.o .libs/multibyte.o .libs/odbcapi.o
> .libs/descriptor.o .libs/odbcapi30.o .libs/pgapi30.o .libs/info30.o
> .libs/mylog.o .libs/odbcapi30w.o .libs/odbcapiw.o .libs/win_unicode.o
> -L/usr/local/lib -L/usr/local/pgsql/lib -lpq -lpthread
> /usr/local/lib/libodbcinst.so -lssl -lcrypto -ldl -Wl,-soname
> -Wl,psqlodbcw.so -o .libs/psqlodbcw.so
>
> Umm, What result does your pg_config obtain?

I did a clean install of postgres, just to make sure....

bash$ pg_config
BINDIR = /usr/local/pgsql/bin
DOCDIR = /usr/local/pgsql/doc
INCLUDEDIR = /usr/local/pgsql/include
PKGINCLUDEDIR = /usr/local/pgsql/include
INCLUDEDIR-SERVER = /usr/local/pgsql/include/server
LIBDIR = /usr/local/pgsql/lib
PKGLIBDIR = /usr/local/pgsql/lib
LOCALEDIR =
MANDIR = /usr/local/pgsql/man
SHAREDIR = /usr/local/pgsql/share
SYSCONFDIR = /usr/local/pgsql/etc
PGXS = /usr/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--with-perl' '--with-python'
CC = gcc -no-cpp-precomp
CPPFLAGS =
CFLAGS
= -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
CFLAGS_SL =
LDFLAGS =
LDFLAGS_SL =
LIBS = -lpgport -lz -lreadline -lm
VERSION = PostgreSQL 8.2.3

The error when making psqlodbc is the same.

Sean