How To Install Openbravo ERP On Ubuntu 8.10

Version 1.0
Author: Falko Timme <ft [at] falkotimme [dot] com>
Last edited 01/07/2009

This document describes how to set up Openbravo ERP (enterprise management system) on Ubuntu 8.10. 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.

A list of Openbravo ERP features can be found on http://www.openbravo.com/product/product-features/.

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

1 Preliminary Note

In this tutorial I use the hostname server1.example.com with the IP address 192.168.0.100. These settings might differ for you, so you have to replace them where appropriate.

Make sure that you are logged in as root (type in

sudo su

to become root), because we must run all the steps from this tutorial as root user.

2 Installing Openbravo Dependencies

2.1 PostgreSQL

Install PostgreSQL:

apt-get install postgresql-8.3

Afterwards we have to set the PostgreSQL admin password:

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

Open a PostgreSQL shell...

psql -U postgres

... and set the password:

alter role postgres with password 'yourrootsqlpassword';
\q

(Replace yourrootsqlpassword with a password of your choice.)

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

2.2 Java JDK

Install the Java JDK as follows:

apt-get install sun-java6-jdk

Afterwards make it available systemwide:

update-java-alternatives -s java-6-sun
echo 'JAVA_HOME="/usr/lib/jvm/java-6-sun"' | tee -a /etc/environment

After that log out and in again for the changes to take effect.

After you've logged in again, don't forget to become root again:

sudo su

2.3 Apache Tomcat

Install Tomcat as follows:

apt-get install tomcat5.5 tomcat5.5-admin tomcat5.5-webapps

Afterwards we have to configure it:

vi /etc/init.d/tomcat5.5

Change TOMCAT5_SECURITY from yes to no:

[...]
# Use the Java security manager? (yes/no)
#TOMCAT5_SECURITY=yes
TOMCAT5_SECURITY=no
[...]

Restart Tomcat:

/etc/init.d/tomcat5.5 restart

Now let's look if all went well:

netstat -tap | grep jsvc

Tomcat should be listening on port 8180:

root@server1:~# netstat -tap | grep jsvc
tcp6       0      0 [::]:8009               [::]:*                  LISTEN      7865/jsvc
tcp6       0      0 [::]:8180               [::]:*                  LISTEN      7865/jsvc
root@server1:~#

Next we need to set a few environment variables:

echo 'CATALINA_HOME="/usr/share/tomcat5.5"' | tee -a /etc/environment
echo 'CATALINA_BASE="/var/lib/tomcat5.5"' | tee -a /etc/environment
echo 'CATALINA_OPTS="-server -Xms384M -Xmx512M"' | tee -a /etc/environment

After that log out and in again for the changes to take effect.

After you've logged in again, don't forget to become root again:

sudo su

2.4 Apache Ant

Apache ant has already been installed as dependency in the previous step - so all we have to do is set another environment variable:

echo 'ANT_HOME="/usr/share/ant"' | tee -a /etc/environment

After that log out and in again for the changes to take effect.

After you've logged in again, don't forget to become root again:

sudo su