From: mark81 at gmail.com (Mark Mitchell)
Date: Mon, 16 Jun 2008 18:40:05 -0400
Subject: [Pljava-dev] Help Permission Denied
In-Reply-To: <4856E2CA.8010801@ejurka.com>
References: <BLU148-DS76F6EBFD2C2F9E23E876DC8AC0@phx.gbl>
	<4856E2CA.8010801@ejurka.com>
Message-ID: <449f4cf70806161540l2891c5e1rb34b137f7486c1b3@mail.gmail.com>

Whatever database user you are loading the file with must also have
READ access to both the folder and file.

If you are running as user postgres, you can always copy the jar file
to /tmp to load it.

-Mark

On Mon, Jun 16, 2008 at 6:01 PM, Kris Jurka <books at ejurka.com> wrote:
> Parisso Escamilla wrote:
>> My system is CentOS 5.1
>> Postgres 8.1-11
>> Pl/Java 1.4
>>
>> Hi, i've benn trying to install a jar file  into the data base with
>> select sqlj.install_jar
>> ('file:/home/openxp/ServidorOXP/lib/sqlj.jar','openxp',true);.
>>
>> I??m getting: ERROR: java.sql.SQLException: I/O exception reading jar
>> file: /home/openxp/ServidorOXP/lib/sql.jar (Permission denied)
>>
>> I don?t know where is the problem, every folder has permission to read
>> and write, but i think the problem isn?t in that way.
>
> Not sure, it could be a se-linux problem?
>
> Kris Jurka
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>