Openerp: Difference between revisions

From DWIKI
mNo edit summary
mNo edit summary
 
(25 intermediate revisions by the same user not shown)
Line 1: Line 1:
http://www.openerp.org
=Links=
*https://launchpad.net/openobject
*http://www.openerp.org


=Installing=
=Installing=
==Gentoo==
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===
===Dependencies===
*lxml
*lxml
*psycopg:0 (slotted version 1 )
*psycopg:0 (slotted version 1 )
*dev-python/pytz
*dev-python/pytz
*python-tz ( on debian )


documentation says:
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"
  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
==Errors and possible interpretations of them==
psycopg.ProgrammingError: ERROR:  relation "ir_module_module" does not exist
psycopg.ProgrammingError: ERROR:  relation "ir_module_module" does not exist


Line 17: Line 78:




=Client on Gentoo=
==FATAL:  Ident authentication failed for user==
==dependencies==
Means given user is not allowed to connect to database
 
 
==Client on Gentoo==
===dependencies===
*dev-python/pytz
*dev-python/pytz
*egenix-mx-base
*egenix-mx-base
Line 25: Line 90:
./setup.py install
./setup.py install


==Error: python module mx.DateTime (date and time handling routines for Python) is required==


==Install notes==


=NOTES=
=NOTES=
Line 35: Line 100:
                 '/usr/local/openerp/lib64/python2.5/site-packages/openerp-server/addons/base/base.sql'
                 '/usr/local/openerp/lib64/python2.5/site-packages/openerp-server/addons/base/base.sql'


this is because base.sql only exists in the lib/python tree, copy it


IOError: File not found : /usr/local/openerp/lib64/python2.5/site-packages/openerp-server/addons/base/base_data.xml
this is because base.sql only exists, (bug in setup.py) in the lib/python tree, copy it:
IOError: [Errno 2] No such file or directory: '/usr/local/openerp/lib64/python2.5/site-packages/openerp-server/import_xml.rng'
 
IOError: File not found : /usr/local/openerp/lib64/python2.5/site-packages/openerp-server/addons/base/base_menu.xml
 
IOError: File not found : /usr/local/openerp/lib64/python2.5/site-packages/openerp-server/addons/base/security/base_security.xml
find /usr/local/openerp/lib/ -name "*'xml" | while read i; do rsync -avR $i /usr/local/openerp/lib64/ done
IOError: File not found : /usr/local/openerp/lib64/python2.5/site-packages/openerp-server/addons/base/ir/wizard/wizard_menu_view.xml
find /usr/local/openerp/lib/ -name "*'csv" | while read i; do rsync -avR $i /usr/local/openerp/lib64/ done
IOError: File not found : /usr/local/openerp/lib64/python2.5/site-packages/openerp-server/addons/process/security/ir.model.access.csv




Line 48: Line 111:


DROP VIEW IF EXISTS account_analytic_analysis_summary_month
DROP VIEW IF EXISTS account_analytic_analysis_summary_month
upgrade postgresql to 8.2 or up


etc etc etc
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

Latest revision as of 11:42, 4 June 2009

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

Retrieved from "https://wiki.dhits.nl/index.php?title=Openerp&oldid=4005"