RE: [INTERFACES] Three posts and no response 8--(

From: Daren Sefcik <daren(at)partnersdata(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: RE: [INTERFACES] Three posts and no response 8--(
Date: 1999-07-13 17:44:31
Message-ID: 818C0CABD178D2119DA700104B8ADF4005DE@PDSISD
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

On Tuesday, July 13, 1999 10:15 AM, Tom Lane [SMTP:tgl(at)sss(dot)pgh(dot)pa(dot)us]
wrote:
> Daren Sefcik <daren(at)partnersdata(dot)com> writes:
> >> The eventual patch will be a change/addition in src/Makefile.shlib,
> >> in the section for your platform (solaris_sparc). I am guessing
that
> >> we might need to add a line like
> >> SHLIB_LINK += -lc
>
> > Well that did something..but I don't think it fixed it completly:
>
> > ldd -r ./libpsqlodbc.so.0.25
> > warning: ldd: ./libpsqlodbc.so.0.25: is not executable
> > libc.so.1 => /usr/lib/libc.so.1
> > libdl.so.1 => /usr/lib/libdl.so.1
> > /usr/platform/SUNW,UltraSPARC-IIi-Engine/lib/libc_psr.so.1
> > symbol not found: pow (./libpsqlodbc.so.0.25)
> > symbol not found: shutdown
(./libpsqlodbc.so.0.25)
> > symbol not found: inet_addr
(./libpsqlodbc.so.0.25)
> > symbol not found: gethostbyname
(./libpsqlodbc.so.0.25)
> > symbol not found: socket
(./libpsqlodbc.so.0.25)
> > symbol not found: connect
(./libpsqlodbc.so.0.25)
> > symbol not found: send (./libpsqlodbc.so.0.25)
> > symbol not found: recv (./libpsqlodbc.so.0.25)
>
> Ah: looks like we are on the right track but you need more than just
> -lc, then. pow() would be in libm, so you need -lm as well, and I'll
> bet that the networking calls are not in libc on your platform either.
> Do you have a libsocket? Check to see what is getting linked to psql,
> for example (go into src/bin/psql, remove and remake psql, and look
> at the command that make is using). Add -l switches to SHLIB_LINK as
> needed. I'd keep -lc last. Maybe "-lsocket -lm -lc" will do it.

Ahhhh....THANKS!!
I have been at this for three weeks...here is what did it:

-ldl -lsocket -lresolv -lnsl -lm -lc

Now it seems to work:

> ldd -r lib/libpsqlodbc.so
warning: ldd: lib/libpsqlodbc.so: is not executable
libdl.so.1 => /usr/lib/libdl.so.1
libsocket.so.1 => /usr/lib/libsocket.so.1
libresolv.so.2 => /usr/lib/libresolv.so.2
libnsl.so.1 => /usr/lib/libnsl.so.1
libm.so.1 => /usr/lib/libm.so.1
libc.so.1 => /usr/lib/libc.so.1
libmp.so.2 => /usr/lib/libmp.so.2
/usr/platform/SUNW,UltraSPARC-IIi-Engine/lib/libc_psr.so.1

> /opt/ISLIodbc/2.11/bin/qetestlib /usr/local/pgsql/lib/libpsqlodbc.so
Load of /usr/local/pgsql/lib/libpsqlodbc.so successful, qehandle is
0xEF6C078C

Now I can try to actually use it...
THANKS!!

Daren

BTW---are you the person who could submit this for future reference
and/or patches???

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 1999-07-13 17:53:23 RE: [INTERFACES] JDBC connection problem while trying example.bas ic
Previous Message Doug Thistlethwaite 1999-07-13 17:23:28 Re: [INTERFACES] JDBC connection problem while trying example.basic