From: peter.henderson at starjar.com (Peter Henderson) Date: Fri, 08 Sep 2006 13:41:32 +0100 Subject: [Pljava-dev] LD_LIBRARY_PATH on Ubuntu In-Reply-To: References: <45001DE8.5000607@starjar.com> Message-ID: <450164FC.7000404@starjar.com> I've added native_threads to my LD_LIBRARY_PATH Still no joy. Im pretty sure this issue is simply the server is not seeing my LD_LIBRARY_PATH OR Another idea. Maybe there is some form of linking/compiling incompatibility. I compiled pljava from source. --update-- I've just tried the pre-compiled binary version of pljava and all seems well. No idea why my version didnt work and the binary did, been many years since I've done much C/C++ But I'll have to figure out why sometime soon, when I deploy on an AMD64 server.. Regards Peter. Thomas Hallgren wrote: > Hi Peter, > Perhaps Ubuntu is one of those systems that also need > /opt/jdk1.5.0_08/jre/lib/i386/native_threads ? Something is definitely missing that prevents > the JVM from loading. > > Regards, > Thomas Hallgren > > > Peter Henderson wrote: >> Hi folks. >> >> >> I'm trying to setup pljava with postgresql on unbuntu 6.06 (aka Dapper >> Drake) on i386 >> >> I've managed to compile pljava, and copied the lib and jar to >> /usr/share/pljava >> >> So far all is good. >> >> But whenever I try to run the deployer, I get an error >> >> peter at peter-desktop:~/downloads/java/postgres/pljava-1.3.0$ >> ./deployer.sh -reinstall -host amd64 -database starjarpartech20060421 >> -user peter -password secret >> org.postgresql.util.PSQLException: ERROR: could not load library >> "/usr/share/pljava/pljava.so": /usr/share/pljava/pljava.so: undefined >> symbol: JNI_CreateJavaVM >> at >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512) >> at >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297) >> at >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:339) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:331) >> at >> org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474) >> at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269) >> >> >> Which I assume means, postgresql cannot load the library. >> >> >> So. >> I modified >> /etc/profile and added >> export >> LD_LIBRARY_PATH=/opt/jdk1.5.0_08/jre/lib/i386:/opt/jdk1.5.0_08/jre/lib/i386/client >> >> And I created >> /etc/ld.so.conf >> and put in it >> # Peter Henderson >> /opt/jdk1.5.0_08/jre/lib/i386 >> /opt/jdk1.5.0_08/jre/lib/i386/client >> >> then ran >> sudo su - >> lddconfig >> >> restarted the postgresql service >> /etc/init.d/postgresql-8.1 stop >> /etc/init.d/postgresql-8.1 start >> >> yet the same problem. >> >> There must be something else Im missing?? >> >> >> Peter Henderson > > _______________________________________________ > Pljava-dev mailing list > Pljava-dev at gborg.postgresql.org > http://gborg.postgresql.org/mailman/listinfo/pljava-dev >