View source | Discuss this page | Page history | Printable version   

Release Management/Testing environments/Production to testing replication tool user manual



This document is a step by step guide on how to replicate the Openbravo ERP running in a production environment into a testing environment.

This guide is written from a user's perspective, for a more technical view you could follow this document. The tools used in this guide are explained in that technical document.

In order to understand why a testing environment should be used, read the testing environments explanation document.


A running Openbravo ERP installation and a clone, to be used as the testing environment. Going into details:

  1. A Openbravo ERP installation running in production.
    1. The database should be in the same server.
    2. Free space on disk to make the backup, take into account that can use more than 1GB.
  2. A Openbravo ERP installation running for testing. This machine should have this things equal to the production ones:
    1. The Catalina base path.
    2. The database:
      1. The database should be in the same server.
      2. The database server (Oracle or PostgreSQL). In case of PostgreSQL should have the same version (8.3 or 8.4)
      3. The database port.
      4. The database admin user/pass.
    3. Free space on disk to make the backup, take into account that can use more than 1GB.

Simplifying this, use clones as the testing environments. This make your tests as truthful to the reality as possible. As an example, you can use two Openbravo ERP Cloud Appliance" instances or two Ubuntu Linux instances .

In Linux

Before starting the script will ask some questions, so write down the following information.

IP address

The IP address of the production environment.

SSH port

The SSH port of the production environment.

If you haven't change it or you don't know which one it is, choose 22 as the port number.

SSH user name

The user name to connect to the production environment.

This user should have write permissions in the /tmp directory of the production server, should be able to export the database using pg_dump in PostgreSQL or exp in Oracle (this command should be in the user's PATH), should have read permission in the CATALINA_BASE directory and Openbravo ERP sources directory.

Sources directory

The Openbravo ERP sources directory of the production environment and testing environment.

If you have troubles finding it, these are the most typical paths:

Catalina base directory

The Catalina base directory of the production environment and testing environment.

This is the directory that contains the webapps directory of Tomcat, used to deploy Openbravo ERP. ($CATALINA_BASE/webapps/openbravo).

The most typical places for this folder are:

You can also check the contents of the CATALINA_BASE environment variable (although it might not be defined):


Get the tool

The replication is done from the testing environment, so the first step is to start a session in this machine.

To get the tool enter the Partner Portal and go to the Resources & Assets section. Then select the OBPS Software Downloads option in the left menu and finally click on Life Cycle Management: replicate Production to Testing - Tool.

This will download a compressed file with the two executables of the tool: and

Uncompress them in the server and make them executable:

chmod a+x
chmod a+x


Open a terminal in the testing environment and run the following command as root (su -):


The script asks for all the information that we have gathered before. Enter now the Catalina base and sources path related to the production environment.

After that, it asks you to double check that all the entered data is correct. Verify it and press 'y' and Enter to continue.

Now, behind the scenes, the script will copy the file into the production server and run it. This will create copy the Openbravo ERP sources, Tomcat webapp and database dump into the /tmp directory of the production server. Afterwards it will create a compressed file with all this data and it will send it back to the testing environment.

Once the compressed file is transferred from the production to the testing environment, it asks you to stop Tomcat. The procedure to Stop it might vary depending on your Linux distribution:

sudo /etc/init.d/tomcat stop


sudo /etc/init.d/tomcat-6 stop


sudo /etc/init.d/openbravo-erp-tomcat stop

In the next step, it asks for the sources path and the catalina base of the testing environment.

After that press 'y' and Enter to confirm the operation.

That's it, the script now finishes successfully. Now start Tomcat in the testing environment.

In Windows


Install and setup cygwin in your production and testing Machine. cygwin with default components should be fine.

Get Production details

Get the data, source and context from production machine, execute the below script.

NOTE: Actually this Scripts should be downloaded from Parter Portal, specifically from Professional Downloads area.

Remember to stop tomcat before executing

cd /cygdrive/c/tmp/
cd testing-environment/win-tool

Above script will ask few information about erp-source, tomcat path. On successful completion will generate a openbravo-erp.tar.gz file

Replicate it

cd /cygdrive/c/tmp/
cd testing-environment/win-tool

Above scripts will ask for erp source path and tomcat path, on successful completion start the tomcat and check for the test instance.

Retrieved from ""

This page has been accessed 10,838 times. This page was last modified on 24 August 2011, at 08:22. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.