From: Constantin Teodorescu <teo@flex.ro>
To: Paulo Ricardo Sikorski <paulo.sikorski@mais.sul.com.br>
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] pgaccess troubles with crypt
Date: Thu, 28 Jan 1999 14:38:48 +0200
Message-ID: <36B05A58.207C9FA1@flex.ro> (raw)
References: <3.0.5.32.19990128100037.00921cd0@mais.sul.com.br>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: teo@flex.ro, paulo.sikorski@mais.sul.com.br
Subject: Re: [INTERFACES] pgaccess troubles with crypt
In-Reply-To: <36B05A58.207C9FA1@flex.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox