From: jason at hyett.org (Jason Hyett)
Date: Wed, 01 Mar 2006 12:00:17 +0000
Subject: [Pljava-dev] Problems loading jars with sqlj.install_jar
In-Reply-To: <44058103.4030201@tada.se>
References: <44055B8C.1080904@hyett.org> <44058103.4030201@tada.se>
Message-ID: <44058CD1.60907@hyett.org>

No, I checked that ;) I have successfully defined a function to access 
the VM system properties. This reports 'user.name' as 'postgres'. This 
user has full access to the jar file.

I had thought that it may be a problem with the security manager 
installed by pljava, so I thought I'd debug it. I added 
'-Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=8000' to the 
VM options so that I could attach remotely. This causes the VM to fail 
to start.

ERROR: transport error 202: bind failed: Permission denied 
["transport.c",L41]
ERROR: JDWP Transport dt_socket failed to initialize, 
TRANSPORT_INIT(510) ["debugInit.c",L500]
JDWP exit error JVMTI_ERROR_INTERNAL(113): No transports 
initializedINFO:  00000: FATAL ERROR in native method: JDWP No 
transports initialized, jvmtiError=JVMTI_ERROR_INTERNAL(113)

Does the fact that the VM can't open a socket suggest some kind of lower 
level security issue? Should I be able to remote debug the code in this 
way? Remote debugging works if I launch the VM from the command line 
with these options as the postgres user?

thanks, Jason

Thomas Hallgren wrote:
> Hi Jason,
> The only reason I can think of is that the account that runs the 
> backend process (postmaster) lacks the needed privileges to read the 
> file or the /tmp directory.
>
> Regards,
> Thomas Hallgren
>
> Jason Hyett wrote:
>> Hello all,
>>
>> I'm getting a permission denied error when I try and install any jar 
>> into the database with sqlj.install_jar(). The following output is 
>> produced in the Postgresql log:
>>
>> STATEMENT:  select 
>> sqlj.install_jar('file:///tmp/test.jar','test',false);
>> java.sql.SQLException: I/O exception reading jar file: /tmp/test.jar 
>> (Permission denied)
>>        at 
>> org.postgresql.pljava.internal.Backend.addClassImages(Backend.java:201)
>>        at 
>> org.postgresql.pljava.management.Commands.installJar(Commands.java:527)
>>        at 
>> org.postgresql.pljava.management.Commands.installJar(Commands.java:205)
>> ERROR:  XX000: java.sql.SQLException: I/O exception reading jar file: 
>> /tmp/test.jar (Permission denied)
>>
>> I'm running Fedora Core 4 with the Postgresql 8.1.3 and PL/Java 1.2.0 
>> binaries plus Sun's 1.5.0_06 VM.
>>
>> Has anyone else seen this and do you know of a workaround?
>>
>> thanks, Jason
>>
>>
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>   
>