ERP 2.50:Openbravo ERP Installation/Ubuntu Installation

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 installation of Openbravo ERP in Ubuntu Lucid Lynx 10.04. It applies to a new Openbravo ERP installation only, NOT an upgrade of an existing installation.

Requirements

Hardware

• In order to install Openbravo ERP 2.50 it is necessary to have at least 1024MB of RAM.

Software

• Ubuntu version 10.04 (Lucid Lynx) is required

Openbravo ERP has these dependencies, that can be found in Ubuntu 10.04 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.

Enable Canonical's Partner Repository

Openbravo ERP is hosted in Canonical's partner repository, which is not enabled by default. You must enable it prior to installation.

With X server

Follow these instructions to enable the partner repositories: Adding Canonical Partner Repositories

Without X server

Enable the Partner’s Repository:

sudo add-apt-repository "deb http://archive.canonical.com/ubuntu YOUR_UBUNTU_VERSION_HERE partner"
sudo add-apt-repository "deb-src http://archive.canonical.com/ubuntu YOUR_UBUNTU_VERSION_HERE partner"

Replace YOUR_UBUNTU_VERSION_HERE with your Ubuntu version's short name(e.g. Lucid or Maverick).

Installation

$ sudo apt-get update
$ sudo apt-get install openbravo-erp

Other useful information about differences between Openbravo 2.50 and Openbravo 3 packages for Ubuntu you might find in the following blog.

Alternatively you can also use the Ubuntu Software Center if you are on the Desktop edition:

Note: these commands will ask for the user password.

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

• Openbravo ERP PostgreSQL port: 5832 (username: tad; password: tad)
• Openbravo ERP PostgreSQL cluster configuration: /etc/postgresql/8.4/openbravo-erp/

Upgrades

Upgrading Openbravo ERP in Ubuntu has two different parts:

1. Software stack: this are the software components required by Openbravo ERP, such as Sun JDK, Apache Ant, Apache Tomcat, Apache httpd, PostgreSQL, etc. These components are updated by Ubuntu's package manager.
2. Openbravo ERP: the ERP updates are delegated to Openbravo ERP 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-erp package, that update will take care of the software stack only. The ERP part must be handled independently through the Module Management Console.

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.

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

Follow the installation guide to install PostgreSQL and configure an admin (postgres) password.

Edit the /etc/postgresql/8.4/openbravo-erp/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/openbravo-erp/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-erp package by following the installation guide.

Then edit /opt/OpenbravoERP-2.50/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-2.50/openbravo-erp/
ant install.source

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

Login into Openbravo ERP

1. Type http://localhost/openbravo into your web browser's the address bar to log in into Openbravo ERP.
2. Use the following credentials:

• username: Openbravo
• password: openbravo

Note: the login credentials are case-sensitive.

Uninstallation

Backup

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

sudo /etc/init.d/openbravo-erp stop
cd /opt
tar cvzf OpenbravoERP-2.50.tar.gz OpenbravoERP-2.50

Restore

In order to restore the backup:

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

Uninstall maintaining the database

$ sudo apt-get remove openbravo-erp

Uninstall without maintaining the database

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

Start at boot time

By default, after installation, openbravo-erp 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-erp remove

To manually start openbravo-erp:

sudo /etc/init.d/openbravo-erp start

To enable again the start at boot time:

update-rc.d openbravo-erp defaults

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-2.50/openbravo-erp
ant <your-command>

Using Openbravo ERP

Navigate to the Openbravo ERP installation guide to discover how to use Openbravo ERP.

Categories: Templates | Installation ERP