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

Hi,

On Fri, 18 Feb 2011 09:07:40 -0000, Riese Wolfgang <W.Riese at zbw.eu> wrote:

> So far the only partly working solution I've found is putting the jars
> in the /var/lib/pgsql/data/ directory, and I mean putting them there,
> symbolic links didn't work for me.

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

> Since I don't want to have the same files in many locations I'd
> appreciate any hints on rules/file rights for SELinux, to solve this
> problem.

The user/role the Postgres server is running as will need read access to
these files. If you can read these files as the postgres user (as it's
traditionally called) and it still doesn't work with SELinux on then you
need to somehow tune the server process rights. Sadly I have no idea how
to configure SELinux itself.

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