Sender: teo@flex.flex.ro
Message-ID: <36B05A58.207C9FA1@flex.ro>
Date: Thu, 28 Jan 1999 14:38:48 +0200
From: Constantin Teodorescu <teo@flex.ro>
Organization: FLEX Consulting
MIME-Version: 1.0
To: Paulo Ricardo Sikorski <paulo.sikorski@mais.sul.com.br>,
	PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] pgaccess troubles with crypt
References: <3.0.5.32.19990128100037.00921cd0@mais.sul.com.br>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Paulo Ricardo Sikorski wrote:
> 
>         I've seem messages with "crypt not included when compiling libpgtcl!!"
> title and I'm having  troubles with pgaccess.
> When pgaccess runs it reports the error below and abort execution.
> 
> Error in startup script: couldn't load file "libpgtcl.so":
>  /usr/local/pgsql/lib/libpgtcl.so: undefined symbol: crypt

Old desease ... :-)

> I did the modifications in SHLIB_LINK in libpq's makefile including
> -lcrypt. The "gmake all" was sucessfull, and the installation process too.

This is the sollution but I cannot understand why it didn't worked for
you.
Maybe it's a problem of confusing libraries and using by mistake an old
one.
I understood that you used postgresql 6.3.2 from RedHat 5.0
distribution.
I hope you previously delete *ANY* trace of postgresql-6.3.2 and it's
libraries and it's all files concerning postgres.

> I removed the Postgresql.6.3.x that came with RedHat (via rpm)

and postgresql-clients too (I hope).

> and got the postgresql-6.4.2.tar.gz
> The Postgresql is working and i get connection by psql.
> 
> The ldd results for /usr/local/pgsql/lib/libpq.so and
> /usr/local/pgsql/libpgtcl.so are below:
> 
> ldd: warning: you do not have execution permission for `./libpq.so'
>         libc.so.6 => /lib/libc.so.6 (0x40012000)
>         libcrypt.so.1 => /lib/libcrypt.so.1 (0x400b6000)
>         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x00000000)
> 
> ldd: warning: you do not have execution permission for `./libpgtcl.so'
>         libc.so.6 => /lib/libc.so.6 (0x40015000)
>         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x00000000)

Very strange !!!!!
I suspect a bad install.
Are they (libpq.so and libpgtcl.so) marked as execution (chmod a+x
libpq.so) ?
Are they owned (as whole /usr/local/pgsql directory) by postgres user ?
Is postmaster running under postgres id ? That means launched by
postgres user ?
Finally, be carefull, postmaster should be launched with -i option in
order to offer connectivity for PgAccess.


-- 
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA