Re: [INTERFACES] RE: [QUESTIONS] pgaccess

> I'm a little confused about the libraries pgaccess is supposed to be
> using, and the directions that came with it don't make much sense.
> The
> application wants libpgtcl.so and libpq.so, but these don't exist on
> my
> system after compiling and installing postgreSQL 6.3.2.  The
> instructtions
> provide these libraries for Red Hat 4.2, but nothing for Red Hat 5
> (which
> I am running).  What's the deal?  Is there something obvious I'm
> missing?
> The 4.2 libraries tell me 'crypt' is an undefined symbol when trying
> to load.

Yes. PgAccess need libpgtcl.so and libpq.so to be in the system /lib
directory.

PostgreSQL 6.3.2 had a little bug that was quickly fixed. He didn't
define LINUX_ELF and the Makefile refused to generate the shared
libraries (so).

A quick patch is to edit those Makefile's in src/interfaces/libpq and
src/interfaces/libpgtcl.so and insert a single line at the begining
LINUX_ELF = true.

Also, I understood that an official patch for this bug has been
released.

In RedHat 5.0, they decided to move the crypt function used by postgres
from the libc library to a separate library libcrypt.so  You will need
to add -lcrypt when linking libpgtcl.

Please let me know if you have solved the problem.

--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA