From: tdavis at hydroblaster.com (Terrance Davis) Date: Tue, 24 May 2005 16:38:01 -0600 Subject: [Pljava-dev] libjvm.so error In-Reply-To: <42925C35.3080501@bonbon.net> Message-ID: <200505242238.j4OMbxEJ015903@bigmac.hydroblaster.com> I was having the same error today on linux, and happened to do an 'ldd' on 'libpljava.so' As I recall, it has a dependency on libjvm.so, but the installation of Java had not told the system where to find either the server or client version of libjvm.so, so I put a symbolic link to the libjvm.so version I wanted to use in the '/lib' directory and the error went away. I'm not sure if that is the right solution, but it seems to have worked so far. Terrance -----Original Message----- From: pljava-dev-bounces at gborg.postgresql.org [mailto:pljava-dev-bounces at gborg.postgresql.org] On Behalf Of Eric E Sent: Monday, May 23, 2005 4:42 PM To: pljava-dev at gborg.postgresql.org Subject: [Pljava-dev] libjvm.so error 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/pg 73b1jdbc3.jar ++ POSTGRES_LD_LIBRARY_PATH=/usr/lib/jvm/java/jre/lib/i386:/usr/lib/jvm/java/jr e/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/i38 6/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/i38 6/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 _______________________________________________ Pljava-dev mailing list Pljava-dev at gborg.postgresql.org http://gborg.postgresql.org/mailman/listinfo/pljava-dev