Installation/Ubuntu: advanced topics
Ubuntu Advanced topics
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
- 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>
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
Upgrading Openbravo in Ubuntu has two different parts:
- 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.
- 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.
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
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
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:
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.
Then set the password for the postgres database super user.
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