I wants to test compiere (http://www.compiere.org/) with PostgreSQL. It is supported by http://www.e-evolution.com.mx/postgreinstall2.html. It needs pljava. I tried to test pljava, but it failes for me :( sun-jdk-1.5.0.02, postgresql-8.0.1 Any body has success on that process? Has ebuild? Reproducible: Always Steps to Reproduce: 1. 2. 3.
I have found my problem with PLJava. I have tried to start postgres through sudo, wich unset LD_LIBRARY_PATH. Installing pljava needs to patch /etc/init.d/postgresql to set LD_LIBRARY_PATH to locate libjvm.so and libpljava.so.
I have the same problem with LD_LIBRARY_PATH. Also tried out the e-volution port of compiere. When I do ldd libjava.so linux-gate.so.1 => (0xffffe000) libjvm.so => /opt/sun-jdk-1.4.2.07/jre/lib/i386/client/libjvm.so (0xb7b9f000) libverify.so => not found libnsl.so.1 => /lib/libnsl.so.1 (0xb7b8a000) libdl.so.2 => /lib/libdl.so.2 (0xb7b86000) libc.so.6 => /lib/tls/libc.so.6 (0xb7a6e000) libm.so.6 => /lib/tls/libm.so.6 (0xb7a4b000) libpthread.so.0 => /lib/tls/libpthread.so.0 (0xb7a37000) /lib/ld-linux.so.2 (0x80000000) When I try to use pljava (manually installed) I get the error message that libverify cannot be found. But it is present in ldconfig -p. I don't know why postgresql does not find it. Maybe this is not a java but a postgresql problem. I tested it with + sun-jdk-1.4.2.07 + postgresql-8.0.1-r2
I fixed this problem by calling not pg_ctl directly from "/etc/init.d/postgresql start", but wrapper which set environment variables and then call pg_ctl. To really fix this problem it is needed to modify start script.
Created attachment 56453 [details] my script to start postgresql Data dir and pg options must be evaluated each start time - it's done by including the same config file (/etc/conf.d/postgresql).
I've just hacked an ebuild that seems to work when not using gcj... It has a patch for fixing gcj compilation too. I've named the package dev-db/pljava.
Created attachment 84965 [details] pljava-1.2.0.ebuild Attached ebuild.
Created attachment 84966 [details, diff] fix-listeners.diff Attached patch fixing gcj compilation.
The use flag gcj enables compilation of pljava using GCJ instead of the usual JVM. It's known to be broken, though... I tested it NOT to work with both gcc 3.4.6 and gcc 4.1.0 :-( Configuration of the database (postgresql.conf) for using the pljava module and installation of the sqlj schema via deploy.jar must be done manually. Perhaps some einfo or enotice should be added in order to inform the user...
(this is an automated message based on filtering criteria that matched this bug) 'EBUILD' is in the KEYWORDS which should mean that there is a ebuild attached to this bug. This bug is assigned to maintainer-wanted which means that it is not in the main tree. Hello, The Gentoo Team would like to firstly thank you for your ebuild submission. We also apologize for not being able to accommodate you in a timely manner. There are simply too many new packages. Allow me to use this opportunity to introduce you to Gentoo Sunrise. The sunrise overlay[1] is a overlay for Gentoo which we allow trusted users to commit to and all users can have ebuilds reviewed by Gentoo devs for entry into the overlay. So, the sunrise team is suggesting that you look into this and submit your ebuild to the overlay where even *you* can commit to. =) Because this is a mass message, we are also asking you to be patient with us. We anticipate a large number of requests in a short time. Thanks, On behalf of the Gentoo Sunrise Team, Jeremy. [1]: http://www.gentoo.org/proj/en/sunrise/ [2]: http://overlays.gentoo.org/proj/sunrise/wiki/SunriseFaq
Created attachment 194336 [details] dev-db/pljava-1.4.0.ebuild new ebuild for 1.4.0
Created attachment 194408 [details] dev-db/pljava-1.4.0.ebuild Fixed dependencies, added pkg_postinst() information.
Created attachment 194410 [details] dev-db/pljava/files/postgresql.conf.pljava PL/Java configuration variables for postgresql.conf
Created attachment 194411 [details] dev-db/pljava/files/postgresql.conf_d.pljava Set libjvm.so LD_LIBRARY_PATH based on java-vm
Created attachment 194412 [details, diff] /etc/init.d/postgresql-8.3.diff Patch to postgresql init.d-script to use LD_LIBRARY_PATH in database process
(In reply to comment #14) > Created an attachment (id=194412) [edit] > /etc/init.d/postgresql-8.3.diff > > Patch to postgresql init.d-script to use LD_LIBRARY_PATH in database process > Patches to postgresql would be better done via an another bug that this bug depends on.
(In reply to comment #15) > (In reply to comment #14) > > Created an attachment (id=194412) [edit] > > /etc/init.d/postgresql-8.3.diff > > > > Patch to postgresql init.d-script to use LD_LIBRARY_PATH in database process > > > > Patches to postgresql would be better done via an another bug that this bug > depends on. > That is what bug #273867 is for. When I talked to dev-zero on IRC he said that the postgresql init.d-script was not right and the issue is not specific to LD_LIBRARY_PATH. Right now this is this is the only package I know of that needs to modify the LD_LIBRARY_PATH of postgresql. Should I open another bug just to track this?
Comment on attachment 194412 [details, diff] /etc/init.d/postgresql-8.3.diff No longer needed as #273867 has been fixed.
Comment on attachment 194411 [details] dev-db/pljava/files/postgresql.conf_d.pljava No longer needed as #273867 has been fixed.
Created attachment 217672 [details] dev-db/pljava-1.4.0.ebuild Updated ebuild supporting postgresql-server-8.4
Created attachment 217673 [details, diff] dev-db/pljava/files/pljava-1.4.0-compile-against-8.4.patch
Created attachment 217674 [details, diff] dev-db/pljava/files/pljava-1.4.0-jdbc.patch
Created attachment 290095 [details] dev-db/postgresql-server/postgresql-server-9.1.1.ebuild Added support for USE=pljava to postgresql-server-9.1.1 ebuild, recommend this approach over a separate ebuild for pljava.
Created attachment 290099 [details] dev-db/postgresql-server/files/pljava.sed Moved pljava configuration into a version independent sed script.
Hi there Is there someone still interested in adding pljava to the tree? Let us know. Thanks.
Apparently not. Closing this bug.