Sender: teo@flex.flex.ro
Message-ID: <3550A2A5.1AD2901@flex.ro>
Date: Wed, 06 May 1998 20:49:25 +0300
From: Constantin Teodorescu <teo@flex.ro>
Organization: FLEX Consulting Braila
MIME-Version: 1.0
To: "Jackson, DeJuan" <djackson@cpsgroup.com>
CC: "Brett W. McCoy" <bmccoy@lan2wan.com>, pgsql-questions@postgreSQL.org,
	PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] RE: [QUESTIONS] pgaccess
References: <F10BB1FAF801D111829B0060971D839F2716E6@dal_cps.cpsgroup.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> 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