Installation/Ubuntu: advanced topics

Installation

Ubuntu

Ubuntu Advanced topics

Introduction

Openbravo ERP is included in the Ubuntu partner repository, allowing Ubuntu users to easily and quickly add the software to their Ubuntu server.

This part of the document explains the advanced configuration of Openbravo in Ubuntu Lucid Lynx 10.04.

Software dependencies details

Openbravo has these dependencies, that can be found in Ubuntu repositories and are automatically resolved by this package:

• Tomcat 6 commons
• Ant 1.7.1
• PostgreSQL 8.4
• OpenJDK

If any of these packages aren't installed or they aren't in the right version, the package manager of Ubuntu will ask to the user to install/update them.

Running on Amazon EC2 and UEC

Ubuntu Lucid Lynx 10.04 provides official AMIs (Amazon Machine Image) for Amazon EC2, so that you can start your instance on the Cloud. See the list of official AMIs for details, as well as the EC2 Starter's Guide for detailed instructions on how to start and manage a new instance. The same applies to Ubuntu Enterprise Cloud.

Once your Ubuntu is ready the installation procedure is exactly the same as in a normal Ubuntu installation.

Running ant tasks

This package is targeted for Production environments, and therefore the Module Management Console should be used instead of the command line. However if you would like to run a specific ant task in command line, first make sure you do it with the openbravo system user:

sudo su - openbravo
cd /opt/OpenbravoERP-3.0/openbravo-erp
ant <your-command>

PostgreSQL configuration

Openbravo uses its own Tomcat and PostgreSQL configuration, for this reason these ports are not the standard ones:

• Openbravo PostgreSQL port: 5932 (username: tad; password: tad)
• Openbravo PostgreSQL cluster configuration: /etc/postgresql/8.4/openbravo-3/

To connect to the database you can use:

psql -d openbravo -U tad -h localhost -p 5932

Upgrades

Upgrading Openbravo in Ubuntu has two different parts:

1. Software stack: this are the software components required by Openbravo, such as Sun JDK, Apache Ant, Apache Tomcat, Apache httpd, PostgreSQL, etc. These components are updated by Ubuntu's package manager.
2. Openbravo: the ERP updates are delegated to Openbravo itself, through its Module Management Console. See the upgrade details for instructions.

So it is important to notice that even if the Ubuntu Package manager shows an available update for the openbravo-3 package, that update will take care of the software stack only. The ERP part must be handled independently through the Module Management Console.

Uninstallation

Backup

Before uninstall it is highly recommended to make a backup of all your data:

sudo /etc/init.d/openbravo stop
cd /opt
tar cvzf OpenbravoERP-3.0.tar.gz OpenbravoERP-3.0
sudo /etc/init.d/openbravo start

Restore

In order to restore the backup:

sudo /etc/init.d/openbravo stop
cd /opt
rm -r OpenbravoERP-3.0
tar xvzpf OpenbravoERP-3.0.tar.gz
sudo /etc/init.d/openbravo start

Uninstall maintaining the database

$ sudo apt-get remove openbravo-3

Uninstall without maintaining the database

$ sudo apt-get remove --purge openbravo-3

Dual-server configuration

In order to balance the workload of the ERP system it is interesting in some cases to install the database in separate server.

Server 1: PostgreSQL

Install PostgreSQL (the contrib package is needed for the UUID support):

sudo apt-get install postgresql-8.4 postgresql-contrib-8.4 postgresql-client-8.4

Set the postgres password:

sudo su - postgres -c psql
alter role postgres with password 'new_password';
\q

Edit the /etc/postgresql/8.4/main/postgresql.conf file, and uncomment the following line, assigning this new value:

listen_addresses='*'

This makes the database listen to all the interfaces available in your system and not only to localhost (default).

Edit the /etc/postgresql/8.4/main/pg_hba.conf file, and add this line at the end:

host    all         all         192.168.1.10/32          md5

Replace 192.168.1.10 with the IP of your Tomcat server.

Server 2: Tomcat server

Install the openbravo-3 package by following the installation guide.

Then edit /opt/OpenbravoERP-3.0/openbravo-erp/config/Openbravo.properties as follows:

Firstly, replace localhost with the IP address of the PostgreSQL server.

bbdd.url=jdbc:postgresql://localhost:5432

Then set the password for the postgres database super user.

bbdd.systemPassword=postgres

The final step is recompile using the new PostreSQL server:

cd /opt/OpenbravoERP-3.0/openbravo-erp/
ant install.source

Since the PostgreSQL is in another server, you can remove in Tomcat server the /etc/init.d/openbravo-postgresql file and also all the lines in /etc/init.d/openbravo that contain "/etc/init.d/openbravo-postgresql".

Start at boot time

By default, after installation, Openbravo will start automatically at boot time. If is not installed in dedicate server, can be useful to deactivate this autostart to save machine resources and reduce the boot time.

To disable the start at boot time:

update-rc.d -f openbravo remove

To manually start Openbravo:

sudo /etc/init.d/openbravo start

To enable again the start at boot time:

update-rc.d openbravo defaults

Categories: Installation | Templates