From: pierce at hogranch.com (John R Pierce)
Date: Thu, 15 Apr 2010 16:27:54 -0700
Subject: [Pljava-dev] building pljava for solaris 10 sparc 64bit
In-Reply-To: <alpine.BSO.2.00.1004151856090.26552@leary.csoft.net>
References: <4BC78D22.7020809@hogranch.com>
	<alpine.BSO.2.00.1004151811500.29195@leary.csoft.net>
	<4BC79676.8050007@hogranch.com>
	<alpine.BSO.2.00.1004151856090.26552@leary.csoft.net>
Message-ID: <4BC7A0FA.4050600@hogranch.com>

Kris Jurka wrote:
> On Thu, 15 Apr 2010, John R Pierce wrote:
> (... pl/java HEAD building on sparc 64bit solaris, pg8.4.3, jdk 
> 1.5.0_23....)
>> this script is setting PGBIN, PGDATA, and PGLOG before running 
>> pg_ctl, so I am pretty sure its already in the target user.   yes, 
>> indeed, SMF has a service property "method_context/user astring 
>> postgres"  which specifies what user to run the start method as, so 
>> its looking like changing the user is done -before- running this script.
>
> Perhaps you need to export those variables:
>
> export LD_LIBRARY_PATH

duh, I should have thought of that...
all reet...   that got me to a NEW error :-)   [the fun never ends!]

$ java org.postgresql.pljava.deploy.Deployer -install -password XXXXXX
org.postgresql.util.PSQLException: ERROR: could not load library 
"/opt/FIS/pljava/pljava.so": ld.so.1: postgres: fatal: relocation error: 
file /opt/FIS/pljava/pljava.so: symbol Int64GetDatum: referenced symbol 
not found
        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:430)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:332)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:324)
        at 
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474)
        at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)


with the same environment stuff set in my shell, that .so seems to pass 
ldd just fine.

$ ldd /opt/FIS/pljava/pljava.so
        libjvm.so =>     
/usr/jdk/jdk1.5.0_23/jre/lib/sparcv9/server/libjvm.so
        libsocket.so.1 =>        /lib/64/libsocket.so.1
        libsched.so.1 =>         /usr/lib/64/libsched.so.1
        libdl.so.1 =>    /lib/64/libdl.so.1
        libCrun.so.1 =>  /usr/lib/64/libCrun.so.1
        libm.so.1 =>     /lib/64/libm.so.1
        libthread.so.1 =>        /lib/64/libthread.so.1
        libc.so.1 =>     /lib/64/libc.so.1
        libnsl.so.1 =>   /lib/64/libnsl.so.1
        libmp.so.2 =>    /lib/64/libmp.so.2
        libmd.so.1 =>    /lib/64/libmd.so.1
        libscf.so.1 =>   /lib/64/libscf.so.1
        libdoor.so.1 =>  /lib/64/libdoor.so.1
        libuutil.so.1 =>         /lib/64/libuutil.so.1
        libgen.so.1 =>   /lib/64/libgen.so.1
        libm.so.2 =>     /lib/64/libm.so.2
        /platform/SUNW,Sun-Fire-V490/lib/sparcv9/libc_psr.so.1
        /platform/SUNW,Sun-Fire-V490/lib/sparcv9/libmd_psr.so.1