Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

How To Install Openbravo ERP On Ubuntu 8.10


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

3 Openbravo ERP Installation

Go to http://sourceforge.net/projects/openbravo/ and download the latest Openbravo ERP installer (select 02-openbravo-installers on the download page), e.g. as follows:

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

Then make the installer executable…

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

… and start the Openbravo ERP installation:

./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

[/usr/lib/jvm/java-6-sun]: <– ENTER

Please specify the location where the Ant executable is located

[/usr/share/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

[/var/lib/tomcat5.5]: <– 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 : <– yourrootsqlpassword
Retype password : <– yourrootsqlpassword

Please enter the name of the PostgreSQL database

Database name [openbravo]: <– ENTER

Please enter a username for the Openbravo ERP PostgreSQL database

Username [tad]: <– ENTER

Please enter a password for the new database user

Password : <– tadsqlpassword (a password of your choice)
Retype password : <– tadsqlpassword

Enter a context name.

This is used in the URL to access Openbravo ERP:
http://<ip_address>:<port>/context_name

Context name [openbravo]: <– ENTER

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 [1] : <– 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]: <– ENTER

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

Do you want to continue? [Y/n]: <– 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.

Afterwards you can access Openbravo at http://server1.example.com:8180/openbravo or http://192.168.0.100:8180/openbravo. Log in with the username Openbravo and the password openbravo.

1

2

  • Openbravo: http://www.openbravo.com/
  • Openbravo user manual: http://wiki.openbravo.com/wiki/index.php/User_Manual
  • Ubuntu: http://www.ubuntu.com/

Comments

comments