public inbox for [email protected]  

help / color / mirror / Atom feed

[Pljava-dev] Help Permission Denied
3+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] Help Permission Denied
@ 2008-06-13 18:14  
  0 siblings, 1 reply; 3+ messages in thread

From:  @ 2008-06-13 18:14 UTC (permalink / raw)

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.

Any idea??? Help please

Parisso Escamilla
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20080613/5ff3e501/attachment.html;



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* [Pljava-dev] Help Permission Denied
@ 2008-06-16 22:01  
  parent: 
  0 siblings, 1 reply; 3+ messages in thread

From:  @ 2008-06-16 22:01 UTC (permalink / raw)

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* [Pljava-dev] Help Permission Denied
@ 2008-06-16 22:40  
  parent: 
  0 siblings, 0 replies; 3+ messages in thread

From:  @ 2008-06-16 22:40 UTC (permalink / raw)

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
>





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2008-06-16 22:40 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-13 18:14 [Pljava-dev] Help Permission Denied 
2008-06-16 22:01 ` 
2008-06-16 22:40   ` 

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox