From: thhal at mailblocks.com (Thomas Hallgren)
Date: Sat, 30 Jul 2005 19:07:48 +0200
Subject: [Pljava-dev] could not access file " libpljava "	: No such file
	or directory
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>
Message-ID: <thhal-0akzHA9VU77Q312Nk7gJyfwSTrnM9Fn@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
>  
>