[Pljava-dev] Problems loading jars with sqlj.install_jar

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
>>
>