View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

How to Move Openbravo/fr

Needs help/review

Warning.png   This document is still a work in progress. It may contain inaccuracies or errors.

Contents

Introduction

Ce document explique le processus de déplacement d'une installation de Openbravo ERP d'une machine à une autre. Un exemple de scénario est la migration de Openbravo ERP dans un environnement de production depuis un serveur Microsoft Windows à un serveur Linux.

Sources

Take the AppsOpenbravo directory and create a compressed and portable file with it (eg. zip or tar.gz).

Once we have the AppsOpenbravo.zip, move it to the target machine. Unzip this file to the desired target directory:

unzip AppsOpenbravo -d /opt/AppsOpenbravo

Openbravo.properties and log4j.lcf files have all the paths referred to the old system. To update them, move to config/setup-tool folder and launch the graphical assistant (wizard):

Note that these wizards can also be run in a text mode without a graphical system. This is auto-detected.

Before starting with compilation, please check that Openbravo.properties and log4j.lcf files (inside config directory) have been properly configured. If not, edit them manually. Write all the paths taking into account the new location.

For systems prior to Openbravo ERP 2.40 (e.g., 2.35 MP5) you will have to modify:

  • AppsOpenbravo/build.xml
  • AppsOpenbravo/config/Openbravo.properties
  • AppsOpenbravo/config/dbCon5.xml
  • AppsOpenbravo/config/XmlPool.xml
  • AppsOpenbravo/config/log4j.lcf
  • If you have a different IP address, you need to change the IP or hostname in WebContent\WEB-INF\web.xml.

For this purpose, edit these files manually or run:

ant -f build.xml.template setup

Database

Export in old system

Oracle

To create a dump file of the database:

exp tad@XE file=c:\tmp\tad_ora.dmp log=c:\temp\tad_ora.log owner=tad statistics=none

In this case, the username is tad and the SID is XE.

PostgreSQL

To create a dump file of the database:

pg_dump -U tad -h localhost -F c -b -v -f C:\temp\tad_pgsql.dmp openbravo

In this case the username is tad and the database name openbravo.


Import in the target system

Oracle

Firstly create a new user:

sqlplus system@XE
create user tad identified by tad default tablespace users temporary tablespace temp;

Then import the previously exported file:

imp tad@XE file=/tmp/tad_ora.dmp log=/tmp/tad_ora.log fromuser=tad touser=tad


PostgreSQL

Firstly create a new user and a database:

psql -d postgres -U postgres
CREATE ROLE tad LOGIN PASSWORD 'tad' SUPERUSER CREATEDB CREATEROLE VALID UNTIL 'infinity';
UPDATE pg_authid SET rolcatupdate=true WHERE rolname='tad';
CREATE DATABASE openbravo WITH ENCODING='UTF8' OWNER=tad;
\q

Then import the previously exported file:

pg_restore -i -U tad -d openbravo -h localhost -v -O /tmp/tad_pgsql.dmp

Finally it's recommended to vacuum the database to increase performance:

vacuumdb -U tad -h localhost -d openbravo -f -z -v

Test

Compilation (optional)

This step is optional but highly recommended, just to make sure everything has been successful and the new build.xml file is correctly configured:

cd /opt/AppsOpenbravo
ant core.lib wad.lib trl.lib compile.complete

If it ends with a BUILD SUCCESSFUL then it's done.


Ready

Now the new system is ready to go. Copy the war file to the Tomcat webapps directory:

cd /opt/AppsOpenbravo
ant war
cp /opt/AppsOpenbravo/openbravo.war $CATALINA_BASE/webapps/

Start tomcat and that's all.

Retrieved from "http://wiki.openbravo.com/wiki/How_to_Move_Openbravo/fr"

This page has been accessed 3,994 times. This page was last modified on 4 June 2009, at 15:50. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.