From: whalesuit at bonbon.net (Eric E)
Date: Mon, 23 May 2005 18:41:57 -0400
Subject: [Pljava-dev] libjvm.so error
Message-ID: <42925C35.3080501@bonbon.net>

Howdy,
    I'm having a bit of trouble installing PL/JAVA.  I believe I've the
LD_LIB and CLASSPATH variables correctly, but I'm still getting the
error about libjvm.so:
---------------
java.sql.SQLException: ERROR:  could not load library
"/usr/lib/postgresql/libpljava.so": libjvm.so: cannot open shared object
file: No such file or directory
---------------

I believe I'm setting both CLASSPATH and LD_LIBRARY_PATH correctly for
my machine.  Can you think of any reason why this error might occur?

Below is the output of the init script to start postgres.

Many thanks,

Eric

---------------
# bash -x /etc/init.d/postgresql restart
+ PG_SYSCONFIG=/etc/sysconfig/postgresql
+ test -f /etc/sysconfig/postgresql
+ . /etc/sysconfig/postgresql
++ POSTGRES_DATADIR='~postgres/data'
++ POSTGRES_OPTIONS=
++ POSTGRES_LANG=
++
POSTGRES_CLASSPATH=/usr/lib/postgresql/pljava/pljava.jar:/usr/share/pgsql/pg73b1jdbc3.jar
++
POSTGRES_LD_LIBRARY_PATH=/usr/lib/jvm/java/jre/lib/i386:/usr/lib/jvm/java/jre/lib/i386/client:/usr/lib/jvm/java/jre/lib/i386/native_threads
+ export
CLASSPATH=/usr/lib/postgresql/pljava/pljava.jar:/usr/share/pgsql/pg73b1jdbc3.jar
+
CLASSPATH=/usr/lib/postgresql/pljava/pljava.jar:/usr/share/pgsql/pg73b1jdbc3.jar
+ export
LD_LIBRARY_PATH=/usr/lib/jvm/java/jre/lib/i386:/usr/lib/jvm/java/jre/lib/i386/client:/usr/lib/jvm/java/jre/lib/i386/native_threads
+
LD_LIBRARY_PATH=/usr/lib/jvm/java/jre/lib/i386:/usr/lib/jvm/java/jre/lib/i386/client:/usr/lib/jvm/java/jre/lib/i386/native_threads
+ . /etc/rc.status
++ test -z '' -o -z ''
+++ exec
+++ stty size
+++ read L C
+++ echo LINES=24 COLUMNS=80
++ eval LINES=24 COLUMNS=80
+++ LINES=24
+++ COLUMNS=80
++ test 24 -eq 0
++ test 80 -eq 0
++ export LINES COLUMNS
++ case $PATH in
++ test -t 1 -a xterm '!=' raw -a xterm '!=' dumb
++ stty size
+++ echo -en '\033'
++ esc=$'\E'
++ extd=''
++ warn=''
++ done=''
++ attn=''
+++ echo -en '\017'
++ norm=''
+++ echo -en
'\015                                                                      '
++ stat='                                                             '
++ rc_done='                                                          done'
++ rc_running='
running'
++ rc_failed='
failed'
++ rc_missed='
missing'
++ rc_skipped='
skipped'
++ rc_dead='                                                          dead'
++ rc_unused='
unused'
++ rc_unknown='
failed''
++ rc_reset=''p='
++ rc_save=''
++ rc_restor'='
++ _rc_service=/etc/init.d/postgresql
++ _rc_status=0
++ _rc_status_all=0
++ _rc_todo=restart
++ test restart = status
++ test -n restart
+ LOGFILE=/var/log/postgresql
+ eval 'DATADIR=~postgres/data'
++ DATADIR=/var/lib/pgsql/data
+ OPTIONS=
+ H=/usr/bin/postmaster
+ test -x /usr/bin/postmaster
+ '[' -r /var/lib/pgsql/data/PG_VERSION ']'
++ /usr/bin/postmaster --version
++ sed 's/.* \([0-9]\+\.[0-9]\+\).*/\1/'
+ BIN_VERSION=7.4
++ cat /var/lib/pgsql/data/PG_VERSION
+ DATA_VERSION=7.4
+ '[' 7.4 '!=' 7.4 ']'
+ rc_reset
+ _rc_status=0
+ _rc_status_all=0
+ rc_check
+ _rc_status_ret=0
+ test 0 -eq 0
+ test 0 -eq 0
+ return
+ return 0
+ case "$1" in
+ /etc/init.d/postgresql stop
Shutting down PostgreSQL                                              done
+ /etc/init.d/postgresql start
Starting PostgreSQL                                                   done
+ rc_status
+ rc_check
+ _rc_status_ret=0
+ test 0 -eq 0
+ test 0 -eq 0
+ return
+ test 0 -gt 7
+ _rc_status_ret=0
+ case "$_rc_todo" in
+ local i
+ return 0
+ rc_exit
+ exit 0

here's libjvm.so:

# ls -l /usr/lib/jvm/java/jre/lib/i386/client
total 4997
drwxr-xr-x  2 root root     144 Mar 18 12:11 .
drwxr-xr-x  5 root root     976 Mar 18 12:11 ..
-rw-r--r--  1 root root    1386 Sep 28  2004 Xusage.txt
lrwxrwxrwx  1 root root      13 Mar 18 12:11 libjsig.so -> ../libjsig.so
-rwxr-xr-x  1 root root 5103795 Sep 28  2004 libjvm.so