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 and enable the 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.
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:
; 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
1 2 3
http://localhost:8069 or http://youripaddress:8069
12) Stopping OpenERP:
To stop OpenERP, use ctrl+c twice.
Hope this helps!