Openerp
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