Thread: PgAccess Problem

PgAccess Problem

From

Matthew

Date:

28 October 1998, 17:21:56

Hello.  I am trying to get PgAccess to work on my system and I'm having
a few problems.  Here is what I have done.

I have installed RedHat 5.0 on my P75, I did not install PostgreSQL from
the RedHat CD
I downloaded the lates postgresql source, compiled and installed.
postgresql now works fine.  I can connect to it with psql.
I downloaded  libpgtcl.so and libpq.so and copied them to the /usr/lib
directory
I exploded the pgaccess files into ~pgaccess
I then ran pgaccess.tcl and this was the output

Error in startup script: couldn't load file "libpgtcl.so: undefined
symbol: crypt
    while executing
"load libpgtcl.so"
    (procedure "main" line 3)
    invoked from within
"main $argc $argv"
    (file "./pgaccess.tcl" line 4682)

Please help, do I to define crypt or something?

Thanks in advance,

Matt O'Connor

Re: [INTERFACES] PgAccess Problem

From

Gus Nwosu

Date:

28 October 1998, 18:10:45

Matthew,

I did the same but I made a few changes:

1. Imposed the linux_elf template in the configure command.

2. Edit the src/interfaces/lipgtcl/Makefile to include -L/usr/lib -lcrypt at the line that defines LIBPQ ie

LIBPQ= -L(SRCDIR)/interfaces/libpq -lpq -L/usr/lib -lcrypt

3. This compiled the shared library libpgtcl.so.1 with the crypt object resolved.

I had one problem which was apparently caused by the -O2 option of gcc. I just went back and repeated the compile (ie gcc command) with -O instead and everything seems to be fine.

Another option would be to go into src/Makefile.global and edit the -O2 to -O and compile.

I hope this is of some help.

Rgds

Gus

At 01:21 PM 10/28/98 -0600, Matthew wrote:

>Hello. I am trying to get PgAccess to work on my system and I'm having

>a few problems. Here is what I have done.

>I have installed RedHat 5.0 on my P75, I did not install PostgreSQL from

>the RedHat CD

>I downloaded the lates postgresql source, compiled and installed.

>postgresql now works fine. I can connect to it with psql.

>I downloaded libpgtcl.so and libpq.so and copied them to the /usr/lib

>directory

>I exploded the pgaccess files into ~pgaccess

>I then ran pgaccess.tcl and this was the output

>Error in startup script: couldn't load file "libpgtcl.so: undefined

>symbol: crypt

> while executing

>"load libpgtcl.so"

> (procedure "main" line 3)

> invoked from within

>"main $argc $argv"

> (file "./pgaccess.tcl" line 4682)

>Please help, do I to define crypt or something?

>Thanks in advance,

>Matt O'Connor

>
=============================================================
Gus Nwosu                                                                         Tel: 1-(713)350-4301
GeoRise Training Manager                                                     Fax: 1-(713)350-4103
5444 Westheimer Road
Houston. Tx 77056                                email: anwosu@houston.geoquest.slb.com
=============================================================