Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

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

3.3 Apache Tomcat 5.5

I have not tried the bundled Apache Tomcat in the CentOS 5 Repository, I went ahead and downloaded it anyway from the tomcat.apache.org site:

cd /opt

wget http://apache.cyberuse.com/tomcat/tomcat-5/v5.5.27/bin/apache-tomcat-5.5.27.tar.gz

tar xzf apache-tomcat-5.5.27.tar.gz

mv apache-tomcat-5.5.27 tomcat

Start the Tomcat Daemon and send it to the background:

/opt/tomcat/bin/startup.sh &

Append it to the rc.local file to start at boot time:

echo “/opt/tomcat/bin/startup.sh &” >> /etc/rc.local

3.4 Apache Ant 1.7

I have gone ahead and downloaded the source for apache ant too as I want to keep everything consistent and so it doesn`t break the CentOS installation. With this technique however, you can easily remove all the exported directories and delete the applications directory and install the stock rpm supplied with CentOS later if you like.

cd /opt

wget http://apache.promopeddler.com/ant/binaries/apache-ant-1.7.1-bin.tar.gz

tar xzf apache-ant-1.7.1-bin.tar.gz

mv apache-ant-1.7.1 ant

echo “export ANT_HOME=/opt/ant” >> /etc/rc.local

export ANT_HOME=/opt/ant

 

4. Downloading and Installing OpenBravo 2.4

I am using OpenBravo 2.4 because this Howto was tested and declared working. However, there is a new release 2.5 which I have not tested and so you can try at your won RISK.

cd /tmp

Download the installation binary from SourceForge:

wget http://surfnet.dl.sourceforge.net/sourceforge/openbravo/OpenbravoERP_2.40-linux-installer.bin

Make it executable:

chmod +x OpenbravoERP_2.40-linux-installer.bin

Run the installer:

./OpenbravoERP_2.40-linux-installer.bin

A text based installer will guide you through the installation. First press a few times ENTER to read the single parts of the license agreement. Type in yes at the end if you agree with it:

Do you accept this license? [y/n]: <– y

Before the installation begins you’ll be asked a few questions – answer them as follows:

Please specify the directory where Openbravo ERP will be installed

[/opt/OpenbravoERP]: <– ENTER

Please specify a directory for the Openbravo ERP attachments

[/opt/OpenbravoERP/AppsOpenbravo/attachments]: <– ENTER

Installation mode

Please select the installation mode you wish to perform

[1] Complete

The database and the application server in the same computer

[2] Distributed

The database and the application server in different computers

Please choose an option [1] : <– ENTER

Please select the installation type you wish to perform

[1] Standard

Installs the database and sets up the application server.

Recommended.

[2] Development

Installs the database and and sets up the application server

through a compilation process.

Recommended for developers.

Please choose an option [1] : <– ENTER

Please specify the directory where the JDK is located

[/opt/java]: <– ENTER

Please specify the location where the Ant executable is located

[/opt/ant/bin/ant]: <– ENTER

Please specify the directory where Tomcat is located.

In case of having Tomcat split into 2 directories, select the one containing the webapps directory

[/opt/tomcat]: <– ENTER

Please select a database

[1] PostgreSQL

[2] Oracle

Please choose an option [1] : <– ENTER

Please specify the directory where the binaries of the PostgreSQL installation are located (psql, pg_restore, vacuumdb)

[/usr/bin]: <– ENTER

Please enter the IP address of the PostgreSQL database

Database host [localhost]: <– ENTER

Please enter the port of the PostgreSQL database

Database port [5432]: <– ENTER

Enter the password for your “postgres” administrator user

Password : <– testpassword

Retype password : <– testpassword

Please enter the name of the PostgreSQL database

Database name [openbravo]: <– ENTER

Please enter a username for the Openbravo ERP PostgreSQL database

Username [tad]: <– admin

Please enter a password for the new database user

Password : <– adminpassword (a password of your choice)

Retype password : <– adminpassword

Enter a context name.

This is used in the URL to access Openbravo ERP:

http://<ip_address>:<port>/context_name

Context name [openbravo]: <– openbravoerp

Please select the preferred date and time formats

Date format

Date format

[1] DD MM YYYY

[2] MM DD YYYY

[3] YYYY MM DD

Please choose an option [1] : <– ENTER

Date separator

[1] –

[2] /

[3] .

[4] :

Please choose an option [2] : <– ENTER

Time format

[1] 12h

[2] 24h

Please choose an option [2] : <– ENTER

Time separator

[1] :

[2] .

Please choose an option [1] : <– ENTER

Should the installer populate the database with demo data?

[Y/n]: Y <– ENTER

Setup is now ready to begin installing Openbravo ERP on your computer.

Do you want to continue? [Y/n]: Y <– ENTER

The installation will take a few minutes, so please be patient:

Please wait while Setup installs Openbravo ERP on your computer.

Installing

0% ______________ 50% ______________ 100%

#########################################

—————————————————————————-

Setup has finished installing Openbravo ERP on your computer.

 

5. Testing the Waters

If everything up to this point is successful, then you have won!  You can access Openbravo at http://www.example.com:8080/openbravoerp or http://192.168.1.1:8080/openbravoerp.

Log in with the username Openbravo and the password openbravo.

Note: I have decided not to post any screen shot of this as this has been tested and declared working. If you need more information, you can use the links provided below as reference.

 

Openbravo: http://www.openbravo.com/

Centos: http://www.centos.org

PostgreSQL 8.3: http://yum.pgsqlrpms.org

Comments

comments