agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] could not access file " libpljava " : No such file or directory
Date: Sat, 30 Jul 2005 19:07:48 +0200
Message-ID: <thhal-0akzHA9VU77Q312Nk7gJyfwSTrnM9Fn@mailblocks.com> (raw)
In-Reply-To: <E1Dysxu-000EBE-00.jpalex-mail-ru@f31.mail.ru>
References: <E1Dysxu-000EBE-00.jpalex-mail-ru@f31.mail.ru>
<42EBB3E4.7040605@mailblocks.com>
<thhal-0aEzHA9NU77Qa8h0eI51R9FNUyC0ohT@mailblocks.com>
Alex,
My guess is that the LD_LIBRARY_PATH that you export in the .bashrc
isn't available to the PostgreSQL backend. Only the backend process (the
postmaster) needs the LD_LIBRARY_PATH setting. .bashrc for the root
account doesn't seemt to be the right place to put it.
The error you get from PostgreSQL is probably propagated from the
loader. The loader does find the libpljava.so but when it tries to load
it, it fails to find the stuff that's needed from the Java installation.
Regards,
Thomas Hallgren
JAlex Alex wrote:
>Hello everyone
>Really hope to get a peace of advice from you.
>Searching this maillist didn't help me anyhow.
>----------------
>Linux 2.6.12-1.1387_FC4 #1 Fri Jul 1 12:40:13 EDT 2005 x86_64 x86_64 x86_64 GNU/Linu
>
>(PostgreSQL) 8.0.3
>
>Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_04-b05)
>Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_04-b05, mixed mode)
>
>pljava-1.1.0
>
>-----------------
>/home/root/.bashrc
>
>export JAVA_HOME=/usr/local/java/jdk1.5
>export ANT_HOME=/usr/local/java/ant
>export PATH=${ANT_HOME}/bin:${PATH}
>export LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/amd64:$JAVA_HOME/jre/lib/amd64/native_threads:$JAVA_HOME/jre/lib/amd64/server
>
>-----------------
>/var/lib/pgsql/data/postgresql.conf
>
>dynamic_library_path = '$libdir:/usr/local/java/javalibs/pljava-1.1.0/build/objs'
>custom_variable_classes = 'pljava'
>pljava.classpath = '/usr/local/java/javalibs/pljava-1.1.0/build/pljava.jar'
>------------------
>
>when trying to run
>java org.postgresql.pljava.deploy.Deployer -install
>
>jjava.sql.SQLException: ERROR: could not access file "libpljava": No such file or directory
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
>....
>-------------------
>the postgresql log file
>
>DEBUG: ProcessUtility
>DEBUG: find_in_dynamic_libpath: trying "/usr/lib64/pgsql/libpljava"
>DEBUG: find_in_dynamic_libpath: trying "/usr/local/java/javalibs/pljava-1.1.0/build/objs/libpljava"
>DEBUG: find_in_dynamic_libpath: trying "/usr/lib64/pgsql/libpljava.so"
>DEBUG: find_in_dynamic_libpath: trying "/usr/local/java/javalibs/pljava-1.1.0/build/objs/libpljava.so"
>ERROR: could not access file "libpljava": No such file or directory
>-------------------
>
>Of course there is such file /usr/local/java/javalibs/pljava-1.1.0/build/objs/libpljava.so
>But there is no such file libpljava
>Why does it looks for that file?
>
>Can anyone explain me what's happening ?
>How to fight this problem?
>
>thanks in advance
>
>Alex
>
>
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
view thread (2+ messages)
Message-ID: <thhal-0akzHA9VU77Q312Nk7gJyfwSTrnM9Fn@mailblocks.com>
Permalink: ../thhal-0akzHA9VU77Q312Nk7gJyfwSTrnM9Fn@mailblocks.com/
Also on: postgresql.org/message-id/thhal-0akzHA9VU77Q312Nk7gJyfwSTrnM9Fn@mailblocks.com
reply
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: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] could not access file " libpljava " : No such file or directory
In-Reply-To: <thhal-0akzHA9VU77Q312Nk7gJyfwSTrnM9Fn@mailblocks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox