Postgres Pro
Downloads
Home   >   mailing lists

Thread: ODBC Unix distro building woes

ODBC Unix distro building woes

From
"Dave Page"
Date:
Having recently changed my dev box from Slackware Linux to FreeBSD
4.6.2, I'm having trouble building the 07.02.0004 psqlodbc tarball.

I've got (following some upgrades):

Autoconf 2.53
Automake 1.6.3
Libtool 1.4.3
PostgreSQL 7.3b5

Everything seems to build OK, and I get a configure script which runs
nicely, however, when I run a make, all I get is:

make: don't know how to make odbc-drop.sql. Stop

The file in question is built from odbc.sql using a simple sed script in
the Makefile.

Any ideas please?

Regards, Dave.

Re: ODBC Unix distro building woes

From
Peter Eisentraut
Date:
Dave Page writes:

> make: don't know how to make odbc-drop.sql. Stop

Try using GNU make to build the distribution.  I'll research a fix in the
meantime.  (AFAIK, once the distribution is built, there should not be a
problem with other make programs.)

Btw., I noticed that the latest version of the ODBC driver gets me a
linker error "undefined symbol WinMain@16" on Cygwin.  This used to work a
while ago.

--
Peter Eisentraut   peter_e@gmx.net

Re: ODBC Unix distro building woes

From
"Dave Page"
Date:

> -----Original Message-----
> From: Peter Eisentraut [mailto:peter_e@gmx.net]
> Sent: 11 November 2002 20:18
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: ODBC Unix distro building woes
>
>
> Dave Page writes:
>
> > make: don't know how to make odbc-drop.sql. Stop
>
> Try using GNU make to build the distribution.  I'll research
> a fix in the meantime.  (AFAIK, once the distribution is
> built, there should not be a problem with other make programs.)

Ack shoud have thought of that. Thanks.

> Btw., I noticed that the latest version of the ODBC driver
> gets me a linker error "undefined symbol WinMain@16" on
> Cygwin.  This used to work a while ago.

Hmm. I'll look into this tomorrow (unless you have any ideas Hiroshi?).

Regards, Dave.

Re: ODBC Unix distro building woes

From
Hiroshi Inoue
Date:
Dave Page wrote:
>
> > -----Original Message-----
> > From: Peter Eisentraut [mailto:peter_e@gmx.net]

[snip]

> > Btw., I noticed that the latest version of the ODBC driver
> > gets me a linker error "undefined symbol WinMain@16" on
> > Cygwin.  This used to work a while ago.
>
> Hmm. I'll look into this tomorrow (unless you have any ideas Hiroshi?).

It works here on cygwin.
Peter seems to be making a executable not a shared library.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/

Re: ODBC Unix distro building woes

From
"Dave Page"
Date:

> -----Original Message-----
> From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
> Sent: 12 November 2002 03:44
> To: Dave Page; Peter Eisentraut
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] ODBC Unix distro building woes
>
>
> Dave Page wrote:
> >
> > > -----Original Message-----
> > > From: Peter Eisentraut [mailto:peter_e@gmx.net]
>
> [snip]
>
> > > Btw., I noticed that the latest version of the ODBC
> driver gets me a
> > > linker error "undefined symbol WinMain@16" on Cygwin.
> This used to
> > > work a while ago.
> >
> > Hmm. I'll look into this tomorrow (unless you have any ideas
> > Hiroshi?).
>
> It works here on cygwin.
> Peter seems to be making a executable not a shared library.

I just tried it here with the 7.2.4 distro, and I get the same error as
Peter:

...
...
(cd . && ln -s gpps.lo gpps.o)
generating symbol list for `psqlodbc.la'
 dlltool --export-all --exclude-symbols
DllMain@12,_cygwin_dll_entry@12,_cygwin_
noncygwin_dll_entry@12,DllMainCRTStartup@12,DllEntryPoint@12
--output-def .libs/
psqlodbc.dll-def  info.lo bind.lo columninfo.lo connection.lo convert.lo
drvconn
.lo environ.lo execute.lo lobj.lo win_md5.lo misc.lo options.lo
pgtypes.lo psqlo
dbc.lo qresult.lo results.lo socket.lo parse.lo statement.lo tuple.lo
tuplelist.
lo dlg_specific.lo odbcapi.lo multibyte.lo gpps.lo
 sed -e "1,/EXPORTS/d" -e "s/ @ [0-9]*//" -e "s/ *;.*$//" <
.libs/psqlodbc.dll-d
ef > .libs/psqlodbc.exp
if test "x`sed 1q .libs/psqlodbc.exp`" = xEXPORTS; then cp
.libs/psqlodbc.exp .l
ibs/psqlodbc.dll-def; else echo EXPORTS > .libs/psqlodbc.dll-def;
_lt_hint=1; ca
t .libs/psqlodbc.exp | while read symbol; do set dummy $symbol; case $#
in 2) ec
ho " $2 @ $_lt_hint ; " >> .libs/psqlodbc.dll-def;; 4) echo " $2 $3 $4 ;
" >> .l
ibs/psqlodbc.dll-def; _lt_hint=`expr $_lt_hint - 1`;; *) echo " $2 @
$_lt_hint $
3 ; " >> .libs/psqlodbc.dll-def;; esac; _lt_hint=`expr 1 + $_lt_hint`;
done; fi
 gcc -Wl,--base-file,.libs/psqlodbc.dll-base
-Wl,-e,__cygwin_dll_entry@12 -o .li
bs/psqlodbc.dll  info.lo bind.lo columninfo.lo connection.lo convert.lo
drvconn.
lo environ.lo execute.lo lobj.lo win_md5.lo misc.lo options.lo
pgtypes.lo psqlod
bc.lo qresult.lo results.lo socket.lo parse.lo statement.lo tuple.lo
tuplelist.l
o dlg_specific.lo odbcapi.lo multibyte.lo gpps.lo
/usr/lib/libcygwin.a(libcmain.o)(.text+0x7c): undefined reference to
`WinMain@16
'
collect2: ld returned 1 exit status
make[1]: *** [psqlodbc.la] Error 1
make[1]: Leaving directory `/usr/local/src/psqlodbc-7.2.4'
make: *** [all] Error 2
PC9 $

I'm not sure what's causing it to be honest, but as Hiroshi says, it
does look like it's trying to build an exe (hence the WinMain). I've
CC'd this to the Cygwin list - maybe Jason has an idea.

Regards, Dave.

Re: ODBC Unix distro building woes

From
Hiroshi Inoue
Date:
Dave Page wrote:
>
> > -----Original Message-----
> > From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
> >
> > Dave Page wrote:
> > >
> > > > -----Original Message-----
> > > > From: Peter Eisentraut [mailto:peter_e@gmx.net]
> >
> > [snip]
> >
> > > > Btw., I noticed that the latest version of the ODBC
> > driver gets me a
> > > > linker error "undefined symbol WinMain@16" on Cygwin.
> > This used to
> > > > work a while ago.
> > >
> > > Hmm. I'll look into this tomorrow (unless you have any ideas
> > > Hiroshi?).
> >
> > It works here on cygwin.
> > Peter seems to be making a executable not a shared library.
>
> I just tried it here with the 7.2.4 distro, and I get the same error as
> Peter:

Hmm I'm using /usr/autotool/devel/share/libtool/libtool.m4
on cygwin. Maybe it isn't the right one but seems to work
at least on cygwin.

Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/

Re: [CYGWIN] ODBC Unix distro building woes

From
Jason Tishler
Date:
Hiroshi,
Dave,
Peter,

On Tue, Nov 12, 2002 at 07:47:29PM +0900, Hiroshi Inoue wrote:
> Dave Page wrote:
> > > -----Original Message-----
> > > From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
> > > Dave Page wrote:
> > > > > -----Original Message-----
> > > > > From: Peter Eisentraut [mailto:peter_e@gmx.net]
> > > [snip]
> > > > > Btw., I noticed that the latest version of the ODBC driver
> > > > > gets me a linker error "undefined symbol WinMain@16" on
> > > > > Cygwin.  This used to work a while ago.
> > > >
> > > > Hmm. I'll look into this tomorrow (unless you have any ideas
> > > > Hiroshi?).
> > >
> > > It works here on cygwin.  Peter seems to be making a executable
> > > not a shared library.
> >
> > I just tried it here with the 7.2.4 distro, and I get the same error
> > as Peter:
>
> Hmm I'm using /usr/autotool/devel/share/libtool/libtool.m4 on cygwin.
> Maybe it isn't the right one but seems to work at least on cygwin.

A comparison of Hiroshi's output of the following:

    $ cygcheck -c | egrep auto\|libtool

to Dave's and Peter's should help to determine which versions work and
which don't

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6