[Pljava-dev] (Third try to post) Installation issue: /usr/share/pljava/pljava.so: undefined symbol: session_timezone

I have been trying to install pljava on a system and keep running into
the same issue. I have managed to work my way through the majority of
the common installation issues (libjvm not in ldconfig, etc), but now
I'm stuck.

My system:

Red Hat Linux ES 5 (selinux disabled)

Postgres 8.2.6

Java jre1.6.0

When I try to run the "deploy" command, I get:

java -cp $CLASSPATH org.postgresql.pljava.deploy.Deployer -install
-database provision -user postgres

org.postgresql.util.PSQLException: ERROR: could not load library

"/usr/share/pljava/pljava.so": /usr/share/pljava/pljava.so: undefined

symbol: session_timezone at

org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1592)

at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1327)

at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
192)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:451)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:336)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:328)

at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474
)

at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)

Linking wise, if I do an ldd -v /usr/share/pljava/pljava.so, I see the

following:

[root at localhost pljava]# ldd -v /usr/share/pljava/pljava.so

linux-gate.so.1 =3D> (0x00d49000)

libjvm.so =3D> /usr/java/latest//lib/i386/client/libjvm.so

(0x00d4a000)

libc.so.6 =3D> /lib/libc.so.6 (0x00175000)

libm.so.6 =3D> /lib/libm.so.6 (0x00110000)

libdl.so.2 =3D> /lib/libdl.so.2 (0x00b20000)

libpthread.so.0 =3D> /lib/libpthread.so.0 (0x00ad6000)

/lib/ld-linux.so.2 (0x006b8000)

Version information:

/usr/share/pljava/pljava.so:

libjvm.so (SUNWprivate_1.1) =3D>
/usr/java/latest//lib/i386/client/libjvm.so

libc.so.6 (GLIBC_2.1.3) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.3) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.0) =3D> /lib/libc.so.6

/usr/java/latest//lib/i386/client/libjvm.so:

libm.so.6 (GLIBC_2.0) =3D> /lib/libm.so.6

libdl.so.2 (GLIBC_2.1) =3D> /lib/libdl.so.2

libdl.so.2 (GLIBC_2.0) =3D> /lib/libdl.so.2

libc.so.6 (GLIBC_2.2.4) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.1) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.1.3) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.1.2) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.2) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.0) =3D> /lib/libc.so.6

libpthread.so.0 (GLIBC_2.2.3) =3D> /lib/libpthread.so.0

libpthread.so.0 (GLIBC_2.2) =3D> /lib/libpthread.so.0

libpthread.so.0 (GLIBC_2.0) =3D> /lib/libpthread.so.0

libpthread.so.0 (GLIBC_2.1) =3D> /lib/libpthread.so.0

/lib/libc.so.6:

ld-linux.so.2 (GLIBC_PRIVATE) =3D> /lib/ld-linux.so.2

ld-linux.so.2 (GLIBC_2.3) =3D> /lib/ld-linux.so.2

ld-linux.so.2 (GLIBC_2.1) =3D> /lib/ld-linux.so.2

/lib/libm.so.6:

ld-linux.so.2 (GLIBC_PRIVATE) =3D> /lib/ld-linux.so.2

libc.so.6 (GLIBC_2.1.3) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.0) =3D> /lib/libc.so.6

/lib/libdl.so.2:

ld-linux.so.2 (GLIBC_PRIVATE) =3D> /lib/ld-linux.so.2

libc.so.6 (GLIBC_2.1.3) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.1) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.0) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_PRIVATE) =3D> /lib/libc.so.6

/lib/libpthread.so.0:

ld-linux.so.2 (GLIBC_2.3) =3D> /lib/ld-linux.so.2

ld-linux.so.2 (GLIBC_2.1) =3D> /lib/ld-linux.so.2

ld-linux.so.2 (GLIBC_PRIVATE) =3D> /lib/ld-linux.so.2

libc.so.6 (GLIBC_2.1.3) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.1) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.3.2) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.2) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_PRIVATE) =3D> /lib/libc.so.6

libc.so.6 (GLIBC_2.0) =3D> /lib/libc.so.6

I tried to run "ldconfig" on the /usr/share/pljava directory, but it did
not appear to find anything in that directory.

[root at localhost pljava]# ldconfig -v /usr/share/pljava

/usr/share/pljava:

/usr/lib/qt-3.3/lib:

libqui.so.1 -> libqui.so.1.0.0

libqt-mt.so.3 -> libqt-mt.so.3.3.6

/lib:

libnss_ldap.so.2 -> libnss_ldap-2.5.so . . .

Finally, when I do an "ldd -r" on the pljava.so file, I see the
following (and many more) unrecognized symbols. Anyone have a clue what
libraries I'm missing?

[root at localhost pljava]# ldd -r pljava.so

linux-gate.so.1 =3D> (0x00c2a000)

libjvm.so =3D> /usr/java/latest//lib/i386/client/libjvm.so
(0x00cc5000)

libc.so.6 =3D> /lib/libc.so.6 (0x002dd000)

libm.so.6 =3D> /lib/libm.so.6 (0x006df000)

libdl.so.2 =3D> /lib/libdl.so.2 (0x00292000)

libpthread.so.0 =3D> /lib/libpthread.so.0 (0x00421000)

/lib/ld-linux.so.2 (0x006b8000)

undefined symbol: QueryCancelPending (./pljava.so)

undefined symbol: proc_exit_inprogress (./pljava.so)

undefined symbol: SPI_tuptable (./pljava.so)

undefined symbol: CurrentMemoryContext (./pljava.so)

undefined symbol: PG_exception_stack (./pljava.so)

undefined symbol: MyProcPid (./pljava.so)

undefined symbol: TopMemoryContext (./pljava.so)

undefined symbol: assert_enabled (./pljava.so)

undefined symbol: textout (./pljava.so)

undefined symbol: stack_base_ptr (./pljava.so)

undefined symbol: ProcDiePending (./pljava.so)

undefined symbol: log_min_messages (./pljava.so)

undefined symbol: SPI_result (./pljava.so)

undefined symbol: session_timezone (./pljava.so)

undefined symbol: error_context_stack (./pljava.so)

undefined symbol: SPI_processed (./pljava.so)

undefined symbol: client_min_messages (./pljava.so)

undefined symbol: InterruptPending (./pljava.so)

undefined symbol: SPI_execute_plan (./pljava.so)

undefined symbol: heap_copytuple (./pljava.so)

undefined symbol: elog_finish (./pljava.so)

undefined symbol: inv_drop (./pljava.so)

undefined symbol: SPI_cursor_fetch (./pljava.so)

Anyone have any ideas of what to try next?

Michael

This message is confidential to Prodea Systems, Inc unless otherwise indicated
or apparent from its nature. This message is directed to the intended recipient
only, who may be readily determined by the sender of this message and its
contents. If the reader of this message is not the intended recipient, or an
employee or agent responsible for delivering this message to the intended
recipient:(a)any dissemination or copying of this message is strictly
prohibited; and(b)immediately notify the sender by return message and destroy
any copies of this message in any form(electronic, paper or otherwise) that you
have.The delivery of this message and its information is neither intended to be
nor constitutes a disclosure or waiver of any trade secrets, intellectual
property, attorney work product, or attorney-client communications. The
authority of the individual sending this message to legally bind Prodea Systems
is neither apparent nor implied,and must be independently verified.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20080304/63b39f68/attachment.html>