Обсуждение: RE: [QUESTIONS] pgaccess
Don't think anyone has answered on QUESTION (could be wrong), so FORWARDING to INTERFACES. > -----Original Message----- > From: Brett W. McCoy [SMTP:bmccoy@lan2wan.com] > Sent: Sunday, May 03, 1998 8:44 PM > To: pgsql-questions@postgreSQL.org > Subject: [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. > > Brett W. McCoy > > http://www.lan2wan.com/~bmccoy/ > ---------------------------------------------------------------------- > - > "The number of UNIX installations has grown to 10, with more > expected." > -- The UNIX Programmer's Manual, 2nd Edition, June, 1972 > > -- > Official WWW Site: http://www.postgresql.org > Online Docs & FAQ: http://www.postgresql.org/docs > Searchable Lists: http://www.postgresql.org/mhonarc
> 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
On Wed, 6 May 1998, Constantin Teodorescu wrote:
> 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).
That's exactly the answer I wanted to the question, where are the shared
libaries? Thanks, Constantin!
> 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.
I think I ran into a similar problem a few months back with some other
software I was installing completely unrelated to postgres, and
discovered this. I'll put in those fixes. Thanks again.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
"The Number of UNIX installations has grown to 10, with more expected."
-- The UNIX Programmer's Manual, 2nd Edition, June, 1972
I had same problem. i commented the line "load ..." and used a itk
version which is already linked with libpg stuff.
however if you are on linux,... theres is a libpgtcl.so available which
you can download from
www.flex.ro/pgaccess
but there is no .so versions for other machines....gues you have to
do a hand job again....
mheravi@siac.com wrote: > > I had same problem. i commented the line "load ..." and used a itk > version which is already linked with libpg stuff. > > however if you are on linux,... theres is a libpgtcl.so available which > you can download from > www.flex.ro/pgaccess It's an older one. It's for PostgreSQL 6.2.1 and RedHat 4.2 Maybe I should deliver also version already compiled for PostgreSQL 6.3.1 and RedHat 4.2 and 5.0 but ... had no time! -- Constantin Teodorescu FLEX Consulting Braila, ROMANIA
On Wed, 6 May 1998, Constantin Teodorescu wrote:
> It's an older one. It's for PostgreSQL 6.2.1 and RedHat 4.2
>
> Maybe I should deliver also version already compiled for PostgreSQL
> 6.3.1 and RedHat 4.2 and 5.0 but ... had no time!
At the very least, you might want to just make a note of the fixes you
gave to me on your website, or make the patch available.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
"The Number of UNIX installations has grown to 10, with more expected."
-- The UNIX Programmer's Manual, 2nd Edition, June, 1972