Openerp

Links

• https://launchpad.net/openobject
• http://www.openerp.org

Installing

useradd -m openerp

Installing database

Assuming 'openerp' is the user you start the server as. As root do:

su postgres
createuser openerp
exit

As user openerp run

openerp-server.py

As any user run

openerp-client.py

Cancel the first dialog, and instead go File->Databases->New. The first password is "admin" by default, the second one is up to you to decide.

Server on FreeBSD

Required packages

this one already pulls in a fair bit of stuff needed!

• py-psycopg2
• py-reportlab
• py-chart
• py-pydot
• py-mx-base
• py-libxslt
• py25-lxml
• py25-xml
• py-libxml2
• py-libxslt
• py25-pytz
• py-imaging
• py-vobject

postgresql82-server, or whatever version pulled in by psycopg2

create user openerp, and database user openerp

Running the beast

as user openerp:

-su: ./openerp-server.py: /usr/bin/python: bad interpreter: No such file or directory

Server on Debian

WARNING make sure your locale is like en_US.UTF-8 when installing postfix, or things go wrong creating database!

/etc/default/locale 

Required packages

• python-psycopg2
• python-reportlab
• python-pychart
• python-pydot
• python-egenix-mxdatetime
• python-xml
• python-lxml
• python-libxslt1
• python-tz
• python-imaging
• python-vobject

Server on Gentoo

Dependencies

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

• python-tz ( on debian )

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.

FATAL: Ident authentication failed for user

Means given user is not allowed to connect to database

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

Terminology

Model

Module

stored in server/bin/addons/modulename/ should contain __terp__.py, __init__.py

Coding

rc

database resource

board

Dashboard view

Development

Tools

• bzr
• bzr-tools
• bzr-gtk

bzr vis

Ubuntu: sources.list: deb http://ppa.launchpad.net/bzr/ubuntu intrepid main