agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] LD_LIBRARY_PATH on Ubuntu
3+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] LD_LIBRARY_PATH on Ubuntu
@ 2006-09-07 13:26
2006-09-07 14:48 ` [Pljava-dev] LD_LIBRARY_PATH on Ubuntu
0 siblings, 1 reply; 3+ messages in thread
From: @ 2006-09-07 13:26 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] LD_LIBRARY_PATH on Ubuntu
2006-09-07 13:26 [Pljava-dev] LD_LIBRARY_PATH on Ubuntu
@ 2006-09-07 14:48 `
2006-09-08 12:41 ` [Pljava-dev] LD_LIBRARY_PATH on Ubuntu
0 siblings, 1 reply; 3+ messages in thread
From: @ 2006-09-07 14:48 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] LD_LIBRARY_PATH on Ubuntu
2006-09-07 13:26 [Pljava-dev] LD_LIBRARY_PATH on Ubuntu
2006-09-07 14:48 ` [Pljava-dev] LD_LIBRARY_PATH on Ubuntu
@ 2006-09-08 12:41 `
0 siblings, 0 replies; 3+ messages in thread
From: @ 2006-09-08 12:41 UTC (permalink / raw)
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-09-08 12:41 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-07 13:26 [Pljava-dev] LD_LIBRARY_PATH on Ubuntu
2006-09-07 14:48 `
2006-09-08 12:41 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox