Installation und Konfiguration von OpenERP 6.0

• XenServer 5.6 SP2
• local Storage
• PowerEdge 2950

OpenERP Benutzer anlegen

 adduser --system --home=/opt/openerp --group openerp 

Installation benötigter Pakete

OpenERP Server

aptitude install python-dateutil python-libxslt1 python-lxml python-psycopg2 python-pydot python-pychart python-reportlab python-tz python-pyparsing python-yaml python-mako python-pkg-resources python-vobject python-webdav

PostgreSQL Datenbank

aptitude install postgresql

OpenERP Web

aptitude install python-cherrypy3 python-formencode python-pybabel python-simplejson python-pyparsing

Download OpenERP Pakete

wget http://www.openerp.com/download/stable/source/openerp-server-6.0.2.tar.gz

wget http://www.openerp.com/download/stable/source/openerp-web-6.0.2.tar.gz

mkdir /opt/openerp
cd /opt/openerp
tar xvf /root/openerp-server-6.0.2.tar.gz
tar xvf /root/openerp-web-6.0.2.tar.gz
chown -R openerp: *
cp -a openerp-server-6.0.2 server
cp -a openerp-web-6.0.2 web

su - postgres

postgres@cperp01:~$ createuser --createdb --username postgres --no-createrole --pwprompt openerp
Enter password for new role: 
Enter it again: 
Shall the new role be a superuser? (y/n) y 
exit

PW: GisteBier

OpenERP Server Konfiguration

svn export http://subversion/svn/Infrastruktur/OpenERP/server/openerp-server.conf

OpenERP Web Client Konfiguration

svn export http://subversion/svn/Infrastruktur/OpenERP/web/openerp-web.conf

• Kopieren der Dateien nach /etc/

chown openerp:root /etc/openerp-server.conf

chmod 640 /etc/openerp-server.conf

Startup Skripte

svn export http://subversion/svn/Infrastruktur/OpenERP/startup-scripts/openerp-server

svn export http://subversion/svn/Infrastruktur/OpenERP/startup-scripts/openerp-web

• Kopieren der Dateien nach /etc/init.d/

• Berechtigungen setzen und Dateien ausführbar machen

chmod 755 /etc/init.d/openerp-server

chown root: /etc/init.d/openerp-server

chmod 755 /etc/init.d/openerp-web

chown root: /etc/init.d/openerp-web

chown openerp:root /etc/openerp-web.conf

• chmod 640 /etc/openerp-web.conf

• Ordner für Logfiles anlegen und Berechtigungen setzen

mkdir /var/log/openerp

chown openerp:root /var/log/openerp

• Server starten und Logfile überprüfen

/etc/init.d/openerp-server start

/var/log/openerp/openerp-server.log

[2011-06-22 09:41:57,743][?] INFO:server:OpenERP version - 6.0.2
[2011-06-22 09:41:57,743][?] INFO:server:addons_path - /opt/openerp/server/bin/addons
[2011-06-22 09:41:57,743][?] INFO:server:database hostname - localhost
[2011-06-22 09:41:57,743][?] INFO:server:database port - 5432
[2011-06-22 09:41:57,743][?] INFO:server:database user - openerp
[2011-06-22 09:41:57,743][?] INFO:server:initialising distributed objects services
[2011-06-22 09:41:58,281][?] INFO:web-services:starting HTTP service at 0.0.0.0 port 8069
[2011-06-22 09:41:58,282][?] INFO:web-services:starting HTTPS service at 0.0.0.0 port 8071
[2011-06-22 09:41:58,282][?] INFO:web-services:Registered XML-RPC over HTTP
[2011-06-22 09:41:58,286][?] INFO:web-services:starting NET-RPC service at 0.0.0.0 port 8070
[2011-06-22 09:41:58,286][?] INFO:server:Starting 3 services
[2011-06-22 09:41:58,287][?] INFO:server:OpenERP server is running, waiting for connections...

• Server beenden und Logfile überprüfen

 /etc/init.d/openerp-server stop 

/var/log/openerp/openerp-server.log

[2011-06-22 09:43:13,119][?] INFO:server:Stopping 3 services
[2011-06-22 09:43:13,119][?] INFO:shutdown:Initiating OpenERP Server shutdown
[2011-06-22 09:43:13,120][?] INFO:shutdown:Hit CTRL-C again or send a second signal to immediately terminate the server...

Startskripte automatisch bei Serverboot starten

update-rc.d openerp-server defaults
update-rc.d openerp-web defaults

Soll der Zugriff über Port 80 möglich sein, muss ein Webserver (Apache installiert werden)

Installation Pakete für Apache

aptitude install apache2 libapache2-mod-proxy-html

Module aktivieren

a2enmod proxy_http headers rewrite

• Kopieren der Datei nach /etc/apache2/sites-available

http://subversion/svn/Infrastruktur/OpenERP/apache2/default

Webserver neustarten

 /etc/init.d/apache2 restart 

• check http://cperp01/