How to install OpenERP modules on Synology NAS that use PostgreSQL procedural languages like plpgsql.so?
Ok so we have setup OpenERP on our DS213 and everything works fine until we start installing certain Modules. Two that we are having particular problem with are: OpenErpPlm & project_timesheet
We could almost live without OpenErpPlm for now (which allow our 3D data to be managed using OpenERP) but the "project_timesheet" is more critical as it is needed for our engineers to clock their time per tasks and have that time be available in the HR & accounting modules to issue invoices.
The problem seem to reside in the fact that the PostgreSQL database installed on the Synology is missing a number of procedural languages that normally come standard with a PostgreSQL install.
This is the error we get in OpenERP when trying to install those modules: "OperationalError: could not load library "/usr/syno/pgsql/lib/plpgsql.so": /usr/syno/pgsql/lib/plpgsql.so: cannot open shared object file: No such file or directory"
I'd love to know of a workaround to fix this.
Thanks in advance!
I do not have the answer and I am not an expert but maybe I can help you in finding the answer. Testconfiguration:
- Testsystem Synology DS112J with DSM4.1 build 2626
- OpenERP 6.1.1-012 (I don't know the builnummer of OpenERP, I hope I find out once how to retrieve this)
PostgreSQL Database Server 8.3.11.
First step I usualy take is close all other services on the Synology. Log in as administrator. Go to packages
and stop all excluding Python and OpenERP. This is because there are a lot of services on Synology that use Postgres and Pgsql which can conflict OpenERP / Postgres / pgsql. Stop and start openERP and try to do what
failed again. If it is ok, you know a lot .... If it is not ok you can restart all other packages.
Second step is I started Itari's admin tool - this is a must have tool for in depth managing a Synology and it is free - and I looked for libraries.
Findings: In user/syno/pgsql there are no libraries. In usr/ lib ->/lib there are symlinks with libraries. However I didn't see plpgsql.so.
- You could check on a Ubuntu 12.04 reference system (you can use a virtual machine for this) the locations of the libraries and if more libraries are missing.
- Copy in the missing libraries from the Ubuntu configuration or from internet to the synology.
- You can also check the configuration files on Synology where libraries are expected to be.
- If the copy doesn't work you need to install plpgsql.so the formal way as described here: http://www.postgresql.org/docs/8.2/static/xplang-install.html For synology a variant on this can be needed.
I am very interested if this is of help for you. And if you find a solution please report your steps in detail as an answer on your own question.
I have posted a lot of the configuration parameters of OpenERP 6.1.1-011 on a synology DS412+: http://forum.synology.com/enu/viewtopic.php?f=184&t=56373
Added 10 April 2013:
There is also an other method you can use to add the missing libraries with apt-get. Therefor you need to install Debian Chroot on your Synology.
This software is available from the Synology Community:
Add in your Package Center packetsources:
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 3/29/13, 5:49 PM|
|Seen: 14545 times|
|Last updated: 3/16/15, 8:10 AM|