[How To] install OpenERP on CentOS

OpenERP is an open-source enterprise resource planning (ERP) software and alternative to the paid ERP software. OpenERP installation is bit tedious but on CentOS 6.x version, it becomes very easy. CentOS 6.x is recommended for using OpenERP as the packages required for OpenERP are easily available.

Let us see how to install OpenERP:

1) Enable EPEL & REMI Repository:

Download repositories:

REMI repository:

wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

EPEL repository:

64-bit

wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

or

32-bit

wget http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

Install repositories:

rpm -Uvh remi-release-6*.rpm epel-release-6*.rpm

EPEL repo is enabled by default. Enable REMI repo by by replacing enabled=0 to enabled=1 in /etc/yum.repos.d/remi.repo file.

2) Install Python Packages:

yum install python python-setuptools python-ldap python-ldaphelper PyXML python-psycopg2 pychart pydot libxml2-python python-lxml libxslt-python pytz postgresql-python graphviz python-imaging python-devel openldap-clients python-dev python-reportlab

3) OpenERP User:

Create user say openerp to run openerp process under it.

adduser openerp

4) PostgreSQL DB Setup:

Create Postgres user and database say "openerp" and grant super privileges for the user to the database.

5) PostgreSQL Configuration:

Allow local access to PostgreSS DB by updating file pg_hba.conf. The update part looks like below

# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust //important
# IPv4 local connections:
host all all 127.0.0.1/32 trust //important
# IPv6 local connections:
host all all ::1/128 md5

Note: Replace md5 with trust in the file at two places shown above.

6) OpenERP Setup:

Download latest source of OpenERP, extract the archive and update OpenERP configuration file with PostgreSQL database details:

 vi path-to-openerp-folder/install/openerp-server.conf

[options]
; This is the password that allows database operations:
; admin_passwd = admin
db_host = localhost
db_port = 5432
db_user = openerp
db_password = openerp
db_name = openerp

7) Environment Variables Setup:

Set Java and PostgreSQL environment variables

8) Compiler & Other Installation:

Install following packages if not present on the server

yum install postgresql-devel python-dev* gcc gcc-c++ autoconf automake

9) Installing OpenERP:

Navigate to OpenERP directory and execute following command

python setup.py install

This will install and configure all the required packages/modules.

10) Starting OpenERP:

Always start OpenERP using user openerp

su openerp
openerp-server -s

11) Accessing OpenERP:

OpenERP runs on port 8069

http://localhost:8069
or
http://youripaddress:8069

12) Stopping OpenERP:

To stop OpenERP, use ctrl+c twice.

Hope this helps!