Openerp

http://www.openerp.org

Installing

Gentoo

Dependencies

• lxml
• psycopg:0 (slotted version 1 )
• dev-python/pytz

documentation says:

su terp -c "/usr/local/openerp/bin/openerp-server --init=all -lnl_NL --pidfile=/var/run/TinyERP/tinyerp-server.pid --logfile=/var/log/TinyERP/tinyerp-server.log -s --stop-after-init"

Errors and possible interpretations of them

psycopg.ProgrammingError: ERROR: relation "ir_module_module" does not exist

This means no tables have been created, documentation of course fails to tell this.

Client on Gentoo

dependencies

• dev-python/pytz
• egenix-mx-base
• psycopg:0

./setup.py install

NOTES

server --init is broken, it won't create a database, if one exists it breaks because it can't find tables, use the client File->Databases dialog (just cancel the login dialog) after configuring config.py and create a postgres user with --create-db rights.

IOError: [Errno 2] No such file or directory:

               '/usr/local/openerp/lib64/python2.5/site-packages/openerp-server/addons/base/base.sql'

this is because base.sql only exists, (bug in setup.py) in the lib/python tree, copy it:

find /usr/local/openerp/lib/ -name "*'xml" | while read i; do rsync -avR $i /usr/local/openerp/lib64/ done
find /usr/local/openerp/lib/ -name "*'csv" | while read i; do rsync -avR $i /usr/local/openerp/lib64/ done

ERROR: syntax error at or near "EXISTS" at character 14

DROP VIEW IF EXISTS account_analytic_analysis_summary_month

upgrade postgresql to 8.2 or up

etc etc etc