ERP 2.50:Openbravo ERP Installation/Ubuntu Installation
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.
- In order to install Openbravo ERP 2.50 it is necessary to have at least 1024MB of RAM.
- 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
- 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).
$ 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/
Upgrading Openbravo ERP in Ubuntu has two different parts:
- 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.
- 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.
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:
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.
Then set the password for the postgres database super user.
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
- Type http://localhost/openbravo into your web browser's the address bar to log in into Openbravo ERP.
- Use the following credentials:
- username: Openbravo
- password: openbravo
Note: the login credentials are case-sensitive.
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
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.