RE: [INTERFACES] Three posts and no response 8--( - Mailing list pgsql-interfaces

From Daren Sefcik
Subject RE: [INTERFACES] Three posts and no response 8--(
Date
Msg-id 818C0CABD178D2119DA700104B8ADF4005DE@PDSISD
Whole thread Raw
Responses Re: [INTERFACES] Three posts and no response 8--(
List pgsql-interfaces

On Tuesday, July 13, 1999 10:15 AM, Tom Lane [SMTP:tgl@sss.pgh.pa.us]
wrote:
> Daren Sefcik <daren@partnersdata.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???


pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Three posts and no response 8--(
Next
From: Doug Thistlethwaite
Date:
Subject: Re: [INTERFACES] JDBC connection problem while trying example.basic