Openerp

From DWIKI

Links

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


Install notes

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

Profile

Partner

Domain

Model

Module

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

Coding

rc

database resource

res

board

Dashboard view

Development

Tools

  • bzr
  • bzr-tools
  • bzr-gtk


bzr vis

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