[Pljava-dev] Problems with SELinux and PL/Java

On Mon, 21 Feb 2011 08:44:10 -0000, Riese Wolfgang <W.Riese at zbw.eu> wrote:

> Hi,
>
> thank you for your answer.

>> Usually jars are put in the database with the sqlj.install_jar()
>> function,
>> but I presume you have a reason to have them elsewhere?

> Ok, I was led to believe that the jars would always be loaded from disk,
> since the table "jar_repository" records the filespace origin of the
> jars, my mistake.

> But that leaves me with the problem that the GeoIP Api can't access it's
> data file, while SELinux is turned on.

Can you check that the postgres' server user can read the data file? That
is, the Linux user/role the server is run as. You can check with the head
or od commands for example.

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/