From: Sean Davis <sdavis2@mail.nih.gov>
Organization: NIH
To: "Hiroshi Saito" <z-saito@guitar.ocn.ne.jp>
Subject: Re: [ODBC] ODBC for Mac OS
Date: Tue, 27 Mar 2007 08:17:45 -0400
User-Agent: KMail/1.9.5
Cc: pgsql-interfaces@postgresql.org, "Tom Lane" <tgl@sss.pgh.pa.us>,
	pgsql-odbc@postgresql.org
References: <4606AC15.90406@mail.nih.gov>
	<200703270631.30705.sdavis2@mail.nih.gov>
	<026e01c77067$58a10b00$c701a8c0@wiseknot.local>
In-Reply-To: <026e01c77067$58a10b00$c701a8c0@wiseknot.local>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200703270817.46083.sdavis2@mail.nih.gov>

On Tuesday 27 March 2007 07:59, Hiroshi Saito wrote:
> Hi Sean-san.
>
> From: "Sean Davis" <sdavis2@mail.nih.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