OpenERP 6 requires Python 2.6 and Postgres 8.4. This document describes how to install these on Ubuntu 10.04. These instructions should be run as root on your server. Install and configure Postgresql 8.4 1. Install Postgres 8.4 apt-get install postgresql 1a. Make sure GCC is install apt-get install gcc 2. Allow remote PgAdmin clients access to the database: edit /etc/postgresql/8.4/main/pg_hba.conf. Add this line: listen_addresses = ‘*’ You could tighten this address range for better security. This is completely optional 3. Create openerp user su – postgres createuser –createdb –no-createrole –pwprompt openerp Enter password for new role: ….. Enter it again: ….. Shall the new role be a superuser? (y/n) y 4. Create an openerp database createdb -O openerp openerp 5. Allow openerp-server to login to postgresql: edit /etc/postgresql/8.4/main/pg_hba.conf. Modify lines as indicated below: # TYPE DATABASE USER CIDR-ADDRESS METHOD # “local” is for Unix domain socket connections only # MODIFY THE EXISTING LINE TO LOOK LIKE THIS: local all all trust # IPv4 local connections: # MODIFY THE EXISTING LINE TO LOOK LIKE THIS: host all all 127.0.0.1/32 trust # ADD THIS LINE TO ALLOW REMOTE ACCESS; use your own IP address range: local all all 10.10.155.0/24 trust # IPv6 local connections: host all all ::1/128 ident You could tighten this address range and methods for better security. 6. Set the logging level. To tell Postgres to log all SQL activity (i.e. to see all the SELECT’s, UPDATES, DELETEs and INSERT statements), add this line to /var/lib/pgsql/data/postgresql.conf: log_statement = ‘all’ 7. Restart Postgres service postgresql-8.4 restart Install Python 2.6 1. Install Python and the Develment packages: apt-get install python apt-get install python-dev Install packages required for OpenERP 6 1. Install setuptools: wget http://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c11.tar.gz Then unpack it and install it: python setup.py install 2. Install easy_install: easy_install Cython 3. Install pip: easy_install pip 4. Use pip to make sure these packages are installed: pip install mako pip install pydot pip install reportlab pip install pyyaml pip install pywebdav 5. Install required dependencies for OpenErp 6: apt-get install python-psycopg2 apt-get install python-reportlab apt-get install python-pychart apt-get install python-pydot apt-get install python-egenix-mxdatetime apt-get install python-lxml apt-get install python-tz apt-get install python-imaging apt-get install python-vobject apt-get install libxml2 apt-get install libxml2-devel 6. Install libtool: apt-get install libtool 7. Install psycopg: Download it and then install it with: apt-get build-dep python-psycopg2 pip install psycopg Install and configure the OpenERP 6 Server 1. Download the OpenERP6 server. Unpack it and install it: python26 setup.py install 2. Add an openerp user: adduser openerp 3. Make sure the new log file exists and is writable: touch /var/log/openerp-server.log chown openerp /var/log/openerp-server.log 4. Make sure the directory for the pidfile is writable by openerp: mkdir /var/run/openerp chown openerp /var/run/openerp 5. Edit ~openerp/.openerp_serverrc; make changes to look like this (don’t enter the “…” lines): debug_mode = True log_level = debug_rpc root_path = /usr/local/lib/python2.6/site-packages/openerp-server addons_path = /usr/local/lib/python2.6/site-packages/openerp-server/addons db_host = ‘localhost’ db_port = 5432 db_user = openerp db_name = openerp db_password = set-your-own-password-here 6. Edit ~openerp/.bashrc export LD_LIBRARY_PATH; LD_LIBRARY_PATH=/usr/local/lib 7. Give the OpenERP server user permission to install new modules chown openerp /usr/local/lib/python2.6/dist-packages/addons 8. Create a startup file called /etc/init.d/openerp-server, and add it as a service. Here is the contents of the script: #!/bin/sh # # OpenERP init script v0.1 for centos by Open-Future # Bert Deferme – www.open-future.be – bert@open-future.be # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License version 3 as # published by the Free Software Foundation. # # For a copy of the GNU General Public License, see . # chkconfig: 345 60 61 # description: starts the openerp-server service NAME=openerp-server USER=openerp PATH=/sbin:/bin:/usr/sbin:/usr/bin DAEMON=/usr/bin/openerp-server PIDFILE=/var/run/openerp/$NAME.pid DAEMONOPTS=”–syslog –log-level=debug –pidfile=${PIDFILE}” checkpid() { [ -f $PIDFILE ] || return 1 pid=`cat $PIDFILE` [ -d /proc/$pid ] && return 0 return 1 } do_start() { if [ -f $PIDFILE ]; then echo “pidfile already exists: $PIDFILE” exit 1 fi echo -n “Starting $NAME: ” su – $USER -c “nohup $DAEMON $DAEMONOPTS >/dev/null 2>&1 &” sleep 3 checkpid if [ $? -eq 1 ]; then rm -f $PIDFILE echo “failed.” exit 1 fi echo “done.” } do_stop() { checkpid if [ $? -eq 1 ]; then echo -n “$NAME not running… (no pidfile found)” exit 0 fi echo -n “Stopping $NAME: ” pid=`cat $PIDFILE` kill -15 $pid sleep 2 if [ $? -eq 1 ]; then echo “Failed. (pidfile found but process didn’t exist)” exit 1 fi echo “done.” } do_status() { echo -n “Checking $NAME: ” checkpid if [ $? -eq 1 ]; then echo “stopped.” else echo “running.” fi } do_restart() { do_stop if [ $? -eq 1 ]; then exit 1 fi do_start } case “$1″ in start) do_start ;; stop) do_stop ;; restart|force-reload) do_restart ;; status) do_status ;; *) N=/etc/init.d/$NAME echo “Usage: $N {start|stop|restart|status}” >&2 exit 1 ;; esac exit 0 Here is how to create it: vi /etc/init.d/openerp-server chmod 755 /etc/init.d/openerp-server sudo update-rc.d openerp-server defaults sysv-rc-conf – make sure 235 are checked off for openerp-server 9. Edit /etc/init.d/openerp-server and make the DAEMONOPTS line look like this. If file was not created see steps below to create: DAEMONOPTS=”–logfile=/var/log/openerp-server.log –log-level=debug_rpc_answer –pidfile=${PIDFILE}” See /usr/local/lib/python2.6/dist-packages/openerp-server/tools/config.py for other valid log levels. 10. Start the Openerp server: service openerp-server start Install and configure the OpenERP Web Server 1. Install the dependent, pyparsing: should be installed if you have already installed the dependecies above, to check run apt-get install python-pyparsing 2. Install the OpenERP Web Server tar -xzf openerp-web….tar.gz cd openerp-web… sudo python setup.py install 3. Create the OpenERP Web Server configuration file: cp /usr/local/lib/python2.6/dist-packages/openerp_web-6.0.0_rc1-py2.6.egg/openerp-web/doc /etc 4. Edit the configuration file, /etc/openerp-web.cfg. Add or uncomment lines to be like this: log.access_file = “/var/log/openerp-web/access.log” log.error_file = “/var/log/openerp-web/error.log” … company.url = ‘http://www.yoururl.com/your_logo.jpg’ 5. Make sure the log directory /var/log/openerp-web exists and is owned by openerp. mkdir /var/log/openerp-web chown openerp /var/log/openerp-web 6. Create a startup file called /etc/init.d/openerp-web, and add it as a service. Here is the contents of the script: #!/bin/sh # # OpenERP init script v0.1 for centos by Open-Future # Bert Deferme – www.open-future.be – bert@open-future.be # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License version 3 as # published by the Free Software Foundation. # # For a copy of the GNU General Public License, see . # chkconfig: 345 61 60 # description: runs the openerp-web service NAME=openerp-web USER=openerp PATH=/sbin:/bin:/usr/sbin:/usr/bin DAEMON=/usr/bin/openerp-web PIDFILE=/var/run/openerp/$NAME.pid DAEMONOPTS=”-c /etc/openerp-web.cfg” checkpid() { [ -f $PIDFILE ] || return 1 pid=`cat $PIDFILE` [ -d /proc/$pid ] && return 0 return 1 } do_start() { if [ -f $PIDFILE ]; then echo “pidfile already exists: $PIDFILE” exit 1 fi echo -n “Starting $NAME: ” su – $USER -c “nohup $DAEMON $DAEMONOPTS >/dev/null 2>&1 &” pid=`ps -ef|grep openerp-web|grep -v grep|cut -d ” ” -f3` echo $pid > $PIDFILE sleep 3 checkpid if [ $? -eq 1 ]; then rm -f $PIDFILE echo “failed.” exit 1 fi echo “done.” } do_stop() { checkpid if [ $? -eq 1 ]; then echo -n “$NAME not running… (no pidfile found)” exit 0 fi echo -n “Stopping $NAME: ” pid=`cat $PIDFILE` kill -15 $pid sleep 2 if [ $? -eq 1 ]; then echo “Failed. (pidfile found but process didn’t exist)” exit 1 fi rm $PIDFILE echo “done.” } do_status() { echo -n “Checking $NAME: ” checkpid if [ $? -eq 1 ]; then echo “stopped.” else echo “running.” fi } do_restart() { do_stop if [ $? -eq 1 ]; then exit 1 fi do_start } case “$1″ in start) do_start ;; stop) do_stop ;; restart|force-reload) do_restart ;; status) do_status ;; *) N=/etc/init.d/$NAME echo “Usage: $N {start|stop|restart|status}” >&2 exit 1 ;; esac exit 0 Here is how to create it: vi /etc/init.d/openerp-web chmod +x /etc/init.d/openerp-web sudo update-rc.d openerp-web defaults sysv-rc-conf – make sure 235 are checked off for openerp-web 7. Start the Openerp web server: service openerp-web start