Thread: Re: [INTERFACES] lo_export & pgaccess

At 04:20 06/28/1999 +0000, you wrote:
>"Ken J. Wright" wrote:
>> 
>> Redhat 5.2
>> PostgreSQL 6.5
>> Compiled with --with-tcl (./configure --with-tcl).
>> 
>> pgaccess has error, couldn't load file libpgtcl.so: undefined symbol:
>> lo_export
>> 
>> ldconfig was run & pgaccess does show the correct path to libpgtcl in the
>> error message. Any suggestions?
>
>Presuming that libpgtcl.so was corectly installed in
>/usr/local/pgsql/lib directory, on a RedHat 5.2 I usually make a
>symbolic link :
>
>ln -s /usr/local/pgsql/lib/libpgtcl.so.2.0 /lib/libpgtcl.so
>
>and it works.
>
>Your error is quite a bit strange because pgacces does not use any of
>the large_object functions in libpgtcl.so !!!

It fails with or without the symbolic link, as it's finding it's way to the
same libpgtcl.so ok. I'm thinking there must be something wrong with the
build, but I'm not sure where to look. Are there other options besides
--with-tcl that are required?

Ken

"Ken J. Wright" <ken@ori-ind.com> writes:
> It fails with or without the symbolic link, as it's finding it's way to the
> same libpgtcl.so ok. I'm thinking there must be something wrong with the
> build, but I'm not sure where to look. Are there other options besides
> --with-tcl that are required?

Try adding -lcrypt to SHLIB_LINK in src/interfaces/libpgtcl/Makefile.in
(or .../Makefile if you already configured).  There is code in there
that is supposed to do that for you, but it is broken in the 6.5 release
due to a silly oversight :-(
        regards, tom lane

Tom Lane wrote:
> 
> "Ken J. Wright" <ken@ori-ind.com> writes:
> > It fails with or without the symbolic link, as it's finding it's way to the
> > same libpgtcl.so ok. I'm thinking there must be something wrong with the
> > build, but I'm not sure where to look. Are there other options besides
> > --with-tcl that are required?
> 
> Try adding -lcrypt to SHLIB_LINK in src/interfaces/libpgtcl/Makefile.in
> (or .../Makefile if you already configured).  There is code in there
> that is supposed to do that for you, but it is broken in the 6.5 release
> due to a silly oversight :-(

I am sorry to say, noone to blame, but that piece of code that is
supposed to do that didn't worked either in 6.4.x or in 6.5 beta x.
As I recall, I checked every version against lcrypt including in linking
but no version worked fine (at least for my RedHat 5.x servers).

But it ain't such a big problem. As Tom said, just adding -lcrypt to
SHLIB_LINK solve the problem.
PostgreSQL 6.5 is such a great thing so you can pass over those minor
problems!

-- 
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

> But it ain't such a big problem. As Tom said, just adding -lcrypt to
> SHLIB_LINK solve the problem.

This will be fixed in v6.5.1. In the meantime, a non-invasive way to
fix this is to put into your src/Makefile.custom the line

LIBS+= -lcrypt
                - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California