agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] Problem using pljava-1.1.0 and PostgreSQL 8.0.3 for Compiere-2.5.2 on Redhat Linux AS 4
Date: Sun, 22 May 2005 12:11:20 +1000
Message-ID: <20050522021120.GC14268@www.zoong.com> (raw)
I have problem using pljava-1.1.0 and PostgreSQL 8.0.3 for Compiere-2.5.2
on Redhat Enterprise Linux AS 4 Intel 32 bit.
Here are the command and error message:
/opt/SUNWappserver/jdk/bin/java -cp /home/zoong/JDK/pljava-1.1.0/build/deploy.jar:/usr/share/java/postgresql-8.0-311.jdbc3.jar org.postgresql.pljava.deploy.Deployer -install -user compiere -database cmpcs
java.sql.SQLException: ERROR: could not load library "/usr/lib/libpljava.so": /usr/lib/libpljava.so: failed to map segment from shared object: Permission denied
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:306)
at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:419)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
#
Here are the details:
0) uninstalled the following Rehdat default PostgreSQL 7 packages:
postgresql-odbc-7.3-8
postgresql-pl-7.4.6-1.RHEL4.2
postgresql-libs-7.4.6-1.RHEL4.2
postgresql-7.4.6-1.RHEL4.2
postgresql-test-7.4.6-1.RHEL4.2
postgresql-devel-7.4.6-1.RHEL4.2
postgresql-jdbc-7.4.6-1.RHEL4.2
postgresql-python-7.4.6-1.RHEL4.2
postgresql-contrib-7.4.6-1.RHEL4.2
postgresql-docs-7.4.6-1.RHEL4.2
postgresql-server-7.4.6-1.RHEL4.2
qt-PostgreSQL-3.3.3-9.3
freeradius-postgresql-1.0.1-2.RHEL4
postgresql-tcl-7.4.6-1.RHEL4.2
1) installed PostgreSQL 8 using RPMs from postgresql.org:
# rpm -qa | grep postgresql
postgresql-contrib-8.0.3-1PGDG
postgresql-server-8.0.3-1PGDG
postgresql-libs-8.0.3-1PGDG
postgresql-docs-8.0.3-1PGDG
postgresql-test-8.0.3-1PGDG
postgresql-8.0.3-1PGDG
postgresql-jdbc-8.0.3-1PGDG
postgresql-pl-8.0.3-1PGDG
postgresql-python-8.0.3-1PGDG
postgresql-devel-8.0.3-1PGDG
#
2) installed Sun SDK j2eesdk-1_4_01_2005Q1-linux.bin downloaded from java.sun.com
# ls -l /opt/SUNWappserver
total 2260
-rw-r--r-- 1 root root 260543 May 21 19:00 3RD-PARTY-LICENSE.txt
-rw-r--r-- 1 root root 1569997 May 21 18:59 appserv_uninstall.class
drwxr-xr-x 2 root root 4096 May 21 19:01 bin
drwxr-xr-x 2 root root 4096 May 21 19:01 config
-rw-r--r-- 1 root root 4365 May 21 19:00 COPYRIGHT
drwxr-xr-x 5 root root 4096 May 21 19:00 docs
drwxr-xr-x 4 root root 4096 May 21 19:01 domains
drwxr-xr-x 8 root root 4096 May 21 19:02 imq
drwxr-xr-x 8 root root 4096 May 21 18:59 jdk
drwxr-xr-x 11 root root 4096 May 21 19:01 lib
-rw-r--r-- 1 root root 12656 May 21 19:00 LICENSE.txt
drwxr-xr-x 5 root root 4096 May 21 19:02 pointbase
drwxr-xr-x 20 root root 4096 May 21 19:00 samples
-rwxr-xr-x 1 root root 347912 May 21 18:59 uninstall
3) installed pljava-src-1.1.0.tar.gz:
# export PATH=/opt/SUNWappserver/jdk/bin:$PATH
# export JAVA_HOME=/opt/SUNWappserver/jdk
# tar zxf pljava-src-1.1.0.tar.gz
# cd pljava-1.1.0
# make; make install
That installed these libs into /usr/lib/
-rw-r--r-- 1 root root 2097994 May 22 00:10 libpljava.a
-rwxr-xr-x 1 root root 1159391 May 22 00:10 libpljava.so.1.1
lrwxrwxrwx 1 root root 16 May 22 00:10 libpljava.so.1 -> libpljava.so.1.1
lrwxrwxrwx 1 root root 16 May 22 00:10 libpljava.so -> libpljava.so.1.1
4) Updated postgresql.conf:
# grep pljava.classpath /var/lib/pgsql/data/postgresql.conf
pljava.classpath = '/home/zoong/JDK/pljava-1.1.0/build/pljava.jar'
# ls -l /home/zoong/JDK/pljava-1.1.0/build/pljava.jar
-rwxr-xr-x 1 root root 126271 May 22 00:10 /home/zoong/JDK/pljava-1.1.0/build/pljava.jar
# grep dynamic /var/lib/pgsql/data/postgresql.conf
dynamic_library_path = '$libdir:/usr/lib/pgsql:/usr/lib'
5) started PostgreSQL:
su - postgres
$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/SUNWappserver/jdk/jre/lib:/usr/lib:/usr/lib/pgsql:/opt/SUNWappserver/jdk/jre/lib/i386:/opt/SUNWappserver/jdk/jre/lib/i386/client:/opt/SUNWappserver/jdk/jre/lib/i386/native_threads
$ export PATH=/opt/SUNWappserver/jdk/bin:$PATH
$ export JAVA_HOME=/opt/SUNWappserver/jdk
$ pg_ctl start -D /var/lib/pgsql/data -l logfile -o "-i"
Any help would be very appreciated.
Zoong
Message-ID: <20050522021120.GC14268@www.zoong.com>
Permalink: ../20050522021120.GC14268@www.zoong.com/
Also on: postgresql.org/message-id/20050522021120.GC14268@www.zoong.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Problem using pljava-1.1.0 and PostgreSQL 8.0.3 for Compiere-2.5.2 on Redhat Linux AS 4
In-Reply-To: <20050522021120.GC14268@www.zoong.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox