Received: from gqserver.houston.geoquest.slb.com (gqserver.houston.geoquest.slb.com [163.185.30.150]) by hub.org (8.9.1/8.9.1) with SMTP id PAA29245 for ; Wed, 28 Oct 1998 15:10:22 -0500 (EST) (envelope-from anwosu@houston.geoquest.slb.com) Received: from grise20 by gqserver.houston.geoquest.slb.com (SMI-8.6/GeoQuest-Internal V1.02) id OAA02952; Wed, 28 Oct 1998 14:05:12 -0600 Message-Id: <199810282005.OAA02952@gqserver.houston.geoquest.slb.com> X-Sender: anwosu@163.185.30.150 X-Mailer: QUALCOMM Windows Eudora Pro Version 4.0.2 Date: Wed, 28 Oct 1998 14:02:47 -0600 To: Matthew From: Gus Nwosu Subject: Re: [INTERFACES] PgAccess Problem Cc: pgsql-interfaces@postgreSQL.org In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; types="text/plain,text/html"; boundary="=====================_16173013==_.ALT" --=====================_16173013==_.ALT Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=3D -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=20 >"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 >=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Gus Nwosu=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0Tel:=A0 1-(713)350-4301 GeoRise Training Manager=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 =20 Fax: 1-(713)350-4103 5444 Westheimer Road Houston. Tx 77056=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0email: anwosu@houston.geoquest.slb.com =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =20 --=====================_16173013==_.ALT Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
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=3D -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
>=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Gus Nwosu=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0Tel:=A0 1-(713)350-4301
GeoRise Training Manager=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0   Fax: 1-(713)350-4103
5444 Westheimer Road
Houston. Tx 77056=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0email: anwosu@houston.geoquest.slb.com
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--=====================_16173013==_.ALT--