agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] could not access file " libpljava " : No such file or directory
2+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] could not access file " libpljava " : No such file or directory
@ 2005-07-30 15:09
0 siblings, 1 reply; 2+ messages in thread
From: @ 2005-07-30 15:09 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* [Pljava-dev] could not access file " libpljava " : No such file or directory
@ 2005-07-30 17:07
parent:
0 siblings, 0 replies; 2+ messages in thread
From: @ 2005-07-30 17:07 UTC (permalink / raw)
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
>
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-07-30 17:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-30 15:09 [Pljava-dev] could not access file " libpljava " : No such file or directory
2005-07-30 17:07 ` [Pljava-dev] could not access file " libpljava " : No such file or directory
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox