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

> Do the regression tests pass?

I am running them now..am I looking for something
in particular??.it seems like some fail and some don't
which kinda follows what the docs say.


> 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)
 


Any other thoughts..??

Thanks for the help!
Daren

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.
        regards, tom lane

On 13-Jul-99 Tom Lane 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  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
       This may be the problem. Most OS's demand that a shared library
be executable. Try doing a "chmod ugo+x ./libpsqlodbc.so.0.25" (or 
wherever your ODBC library ended up). It's also possible that some part
of your compile failed when you were building the library, which would
explain why the permissions aren't already set correctly.

>>         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)
> 


----------------------------------
Date: 13-Jul-99  Time: 11:01:36

Craig Orsinger                  (email: <orsingerc@epg.lewis.army.mil>)
Logicon RDA
Bldg. 8B28                      "Just another megalomaniac with ideas above his
6th & F Streets                 station. The Universe is full of them."
Ft. Lewis, WA   98433                   - The Doctor
----------------------------------