> 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