How To Install Openbravo ERP On CentOS 5.2

This howto describes how to set up Openbravo ERP (enterprise management system) on CentOS 5.2 using PostgreSQL 8.3. Openbravo is an open source ERP solution designed specifically for the SME (small to midsize firm). Developed in a web based environment, it includes many robust functionalities which are considered part of the extended ERP: procurement and warehouse management, project and service management, production management, and financial management.

This is a follow up of Falko`s Wonderful "How To Install Openbravo ERP On Ubuntu 8.10".

I do not issue any guarantee that this will work for you!

 1. Preliminary Note

 This howto assumes you have freshly installed CentOS system along with the following.

 a) Hostname:- server1.example.com

 b) Server IP:- 192.168.1.1

 You must have root privileges to run most of the actions described in this Howto.

2. Setup DNS

yum install bind bind-utils

#nano /etc/named.conf

options
{
    directory 		"/var/named";
    dump-file 		"data/cache_dump.db";
    statistics-file 	"data/named_stats.txt";
    memstatistics-file 	"data/named_mem_stats.txt";
    forwarders {ISP_DNS_IP;};
};
zone "example.com" IN {
	type master;
	file "forward.zone";
};

#nano /var/named/forward.zone

$TTL 3h
@	IN	SOA	server1	muffycompoqm.gmail.com. (
		1	; Serial Number
		15m	; Refresh Rate
		30m	; Retry Interval
		1h	; Expire Delay
		2h )	; Negative Cache TTL
@	IN	NS	server1
@	IN	A	192.168.1.1
server1	IN	A	192.168.1.1
www	IN	CNAME	server1.example.com.
ftp	IN	CNAME   server1.example.com.	

#nano /etc/resolv.conf

search example.com
nameserver 127.0.0.1

#chkconfig --levels 35 named on

#service named start

3. Installing Openbravo Dependencies

3.1 Postgresql 8.3

Exclude Postgresql from the CentOS base repository as OpenBravo uses Postgresql 8.3 which is not included in the base repository.

#nano /etc/yum.repos.d/CentOS-Base.repo

Add to the bottom of the file:

exclude=postgresql*

Download and install the RPMs from http://yum.pgsqlrpms.org:

wget http://yum.pgsqlrpms.org/reporpms/8.3/pgdg-centos-8.3-6.noarch.rpm

rpm -ivh pgdg-centos-8.3-6.noarch.rpm

yum install postgresql postgresql-server

Afterwards we have to set the PostgreSQL admin password:

sed -i 's/ident sameuser$/trust/' /etc/postgresql/8.3/main/pg_hba.conf

service postgresql start

chkconfig --levels 35 postgresql on

Open a PostgreSQL shell and alter the postgres user role:

psql -U postgres

alter role postgres with password 'testpassword'; \q

sed -i 's/trust$/md5/' /etc/postgresql/8.3/main/pg_hba.conf

service postgresql reload

service postgresql restart

3.2 Sun Java JDK 1.6

You will have to download Java 1.6 JDK from http://java.sun.com/javase/downloads/index.jsp.

cp jdk-6u13-linux-i586.bin.bin /opt

cd /opt

sh jdk-6u13-linux-i586.bin.bin --unpack

mv jdk1-* java

echo "export JAVA_HOME=/opt/java" >> /etc/rc.local

export JAVA_HOME=/opt/java