Log in / create account
Openbravo.com
Partner Portal
Issues
Blogs
Forge
Exchange
University
Downloads
View source | Discuss page | Page history | Printable version   
ADVERTISEMENT
Accounting eLearning Courses
Partnerships
SourceForge.net Logo
Openbravo ERP at SourceForge

SourceForge.net Logo
Openbravo POS at SourceForge

Open Solution Alliance Logo
Openbravo at Open Solutions Alliance

ERP/2.50/Openbravo ERP Installation

Rating :
5.00/5
(5 votes cast)
You have to be registered to be able to vote
Languages: 

English  |  Italiano  |  日本語 | Translate this article...

Contents

Introduction

This article describes the installation procedure for Openbravo ERP 2.50.

In this release, you can install Openbravo ERP following 3 different approaches:

License

Openbravo ERP is licensed under the Openbravo Public License Version 1.1:

The contents of this file are subject to the Openbravo Public License Version 1.1 (the "License"), being the Mozilla Public License version 1.1 with a permitted attribution clause; you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.openbravo.com/product/legal/license/.

Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for the specific language governing rights and limitations under the License.

The Original Code is (C) Openbravo ERP. The Initial Developer of the Original Code is Openbravo SLU. All portions are Copyright (C) 2001-2008 Openbravo SLU. All Rights Reserved.

Community Appliance

A virtual appliance is a minimally preinstalled and preconfigured application and operating system, designed to run under VMware, Xen or any other virtualization technology. The Openbravo ERP project provides virtual appliances to simplify the evaluation process. For that purpose, these appliances include a sample database client called BigBazaar.

The appliance images are available at the SourceForge download area.

General information

Included software

The appliances include the following software:

Minimum requirements and image details

VMware appliance
Xen appliance
QEMU appliance
Parallels appliance
VirtualBox appliance

Login into Openbravo ERP

  1. At the end of the boot process, a message appears indicating the IP address you need to launch Openbravo ERP. In your chosen web browser, type that IP address into the address box. The login screen appears.
  2. In the Username box, type Openbravo
  3. In the Password box, type openbravo
    Both the username and password are case sensitive.

Linux passwords

Note that these passwords are not used to login to Openbravo ERP, but in Linux.

Direct database access

For security reasons the appliance runs a firewall (iptables) that blocks every external access except to the SSH (22), HTTP (80) and HTTPS (443) ports. So in order to connect to the database using an external tool, such as PgAdmin3, it is necessary to establish a SSH tunnel, described as follows.

Linux, MAC and *BSD
  1. Open a command-line terminal and type the following command, replacing ip_address with the correct IP address: 
    ssh -N -L 5433:localhost:5432 openbravo@ip_address
    This forwards the appliance's PostgreSQL port into the 5433 port of the user's local client machine, tunneled over a SSH connection.
  2. Type the openbravo user password and leave this terminal open.
  3. Open the PostgreSQL client (e.g. PgAdmin3), specify the following connection settings and click OK:
    • Name: OpenbravoERP
    • Host: localhost
    • Port: 5433
    • Username: tad
    • Password: tad

The connection will be available as long as the previous SSH connection is opened.

Windows

Use PuTTY to connect to PostgreSQL in Windows. PuTTY is an open source and free SSH client:

  1. Select Session.
  2. In the Host Name box, enter IP Address of the Openbravo Network machine.
  3. Select Connection > SSH > Tunnels.
  4. In the Source port field, enter 5433.
  5. In the Destination field, enter localhost:5432.
  6. Click Add.
  7. Click Open to open the SSH connection.
  8. Type the openbravo user name and its password and leave this terminal open.

Misc

The Manager username is admin and the password openbravo.

Installation and usage

Common steps

In general, the process of running Openbravo ERP on a virtual appliance are as follows:

  1. Download a virtualization program. See below for specific instructions on VMware, Xen, QEMU, Parallels and VirtualBox.
  2. Download the virtual appliance and open it with the virtualization program.
  3. The following message is shown at the end of the boot process, indicating the URL to access Openbravo ERP with your web browser:
    Welcome to Openbravo ERP Community
    To login to Openbravo ERP use your web browser to go to http://<IP_ADDRESS>

VMware

Use VMware Player (freeware) to run pre-built virtual machines on your desktop. To run the Openbravo appliance, follow these steps:

  1. Download and install VMware Player. There are versions for Microsoft Windows and Linux. VMware Fusion is the Macintosh version.
  2. Download the latest version of the Openbravo VMware image and unpack the files.
  3. Run VMware Player (or VMware Fusion on a Mac).
  4. Select the decompressed .vmx file.

If there is DHCP on your network, no further steps are required. The final boot message within the virtual machine play window will show the URL to access Openbravo ERP from your browser.

If your network does not have DHCP you can either:

To create an internal subnet:

  1. Launch the VMware player.
  2. Change the network adapter options from Bridged to NAT.
  3. Restart the virtual machine.

To set a fixed IP address and gateway:

  1. Log in as root (passwordless)
  2. Type the following commands to set a specific ip IP_ADDRESS and a gateway IP_GATEWAY: 
    $ /sbin/ifconfig eth0 IP_ADDRESS netmask 255.255.255.0 up
    $ /sbin/route add default gw IP_GATEWAY
  3. Finally to make the IP address available to the Internet, assign some DNS servers to it: 
    $ echo "nameserver IP_DNS1" >> /etc/resolv.conf
    $ echo "nameserver IP_DNS2" >> /etc/resolv.conf
  4. To launch Openbravo ERP, launch your chosen web browser and type 'http://<IP_ADDRESS>' into the address box, where 'IP_ADDRESS' is the IP address you specified in step 2.
Image:Bulbgraph.png   If your Openbravo ERP VMware virtual machine hangs when restoring its previous state, just follow this simple trick.

Xen appliance

Xen is an open source and free virtualization software. To run the Openbravo ERP appliance within Xen, follow these steps.

Running on Amazon EC2

To deploy the Xen appliance into Amazon EC2, follow these steps. Make sure all the environment variables are correctly configured:

  1. Bundle the image using the following command: 
    $ ec2-bundle-image -i OpenbravoERP-2.50MP13-x86.ext3 -r i386 -k $EC2_PRIVATE_KEY -c $EC2_CERT -u $EC2_USER_ID
  2. Upload the image into a Amazon S3 bucket: 
    $ ec2-upload-bundle -b OpenbravoERP -m /tmp/OpenbravoERP-2.50MP13-x86.fs.manifest.xml -a $EC2_ACCESS_KEY -s $EC2_SECRET_KEY
  3. Register the image: 
    $ ec2-register OpenbravoERP/OpenbravoERP-2.50MP13-x86.fs.manifest.xml
    ami-xxxxxx
  4. Use the ami-xxxxxx returned by this command to run the instance: 
    $ ec2-run-instance ami-xxxxxx

QEMU appliance

The installation and its networking configuration are out of the scope of this document. Assuming it is ready, run the following command: 

$ qemu -hda OpenbravoERP-2.50MP13-x86.qemu-parallels -m 512 -net tap -net nic

Parallels appliance

Decompress OpenbravoERP-2.50MP13-x86.qemu-parallels.gz and open the OpenbravoERP-2.50MP13-x86.qemu-parallels file with Parallels.

VirtualBox appliance

In order to use Openbravo ERP it is necessary to access the virtual appliance through the network. There are two options here: 

$ VBoxManage setextradata "Openbravo ERP Community" "VBoxInternal/Devices/pcnet/0/LUN#0/Config/guesthttpd/HostPort" 8000
$ VBoxManage setextradata "Openbravo ERP Community" "VBoxInternal/Devices/pcnet/0/LUN#0/Config/guesthttpd/GuestPort" 80
$ VBoxManage setextradata "Openbravo ERP Community" "VBoxInternal/Devices/pcnet/0/LUN#0/Config/guesthttpd/Protocol" TCP

Where "Openbravo ERP Community" matches with the name given to the appliance in its creation.

Afterwards it is necessary to shut down VirtualBox and start the appliance again. Then, to access Openbravo ERP enter http://localhost:8000 in a web browser.

Amazon EC2 Image

We have a Community Appliance EC2 AMI.

You can found the latest availables AMIs in the release notes page of 2.50MP13.

In order to use the AMI image, simply start a new instance of this AMI from the Web console interface of EC2 or install and configure the api-tools to start the AMI by command line. 

$ ec2-run-instance ami-xxxxxx

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 Karmic Koala 9.10. It applies to a new Openbravo ERP installation only, NOT an upgrade of an existing installation.

Requirements

Hardware

Software

Openbravo ERP has these dependencies, that can be found in Ubuntu 9.10 repositories:
  • Tomcat 6 commons
  • Ant 1.7.1
  • PostgreSQL 8.4
  • Java Sun JDK 1.6
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.
Image:Bulbgraph.png   There's also a 2.50 Ubuntu package for Ubuntu Jaunty 9.04. Note however that it is highly recommended to install the Ubuntu Karmic 9.10 version, it includes several improvements that significantly improve the end user experience

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

For those installations without an X server (e.g. Server edition) you must directly edit /etc/apt/sources.list, and uncomment the following lines (removing the '#' character): 

deb http://archive.canonical.com/ubuntu karmic partner
deb-src http://archive.canonical.com/ubuntu karmic partner

Installation 

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

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:

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 Karmic Koala 9.10 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:

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
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

Custom Installation

A custom installation provides you with maximum deployment flexibility and full control over the technology stack and its configuration. However, it can be laborious and requires a high degree of experience.

For this reason, we recommend to novice users not to attempt custom installations and to instead evaluate Openbravo ERP using the Community Appliance.

System Requirements

Operating Systems

Architectures

Databases Supported

Stack required

Deployment Topology

A custom installation allows you to choose your preferred deployment topology, depending on your data volume and user load:

Technology Stack Installation

You can optimize your installation of Openbravo ERP, depending on how you intend to use it:

Downloading Openbravo ERP

You can to obtain a copy of the source code by either:

Downloading the tarball

You can download a tarball of the Openbravo ERP source code from SourceForge.

Once the download is complete, you can extract the code with the following command: 

tar -xvf OpenbravoERP-2.50xx.tar.bz2
Image:Bulbgraph.png   Replace the xx with the latest version. e.g OpenbravoERP-2.50MP13.tar.bz2

Mercurial clone

To be able to check out Openbravo ERP source code from Openbravo Mercurial repository you need to first install the Mercurial client.

Once the Mercurial client is installed, move to the directory to which you want to check out the source code.

To check out the latest source code tag, type the command: 

$ hg clone http://code.openbravo.com/erp/devel/main OpenbravoERP-2.50MP13
$ hg up 2.50MP13

In order for the Module Management Console to work correctly it is necessary that the user running the Tomcat process is a trusted user to access the Mercurial repository, trust from Mercurial's point of view. If you are running Tomcat with the same user that has done the hg clone, then you can skip this step. Otherwise, add the tomcat user (e.g. tomcat) to the trusted group: 

$ mkdir /etc/mercurial
$ cat << EOF >> /etc/mercurial/hgrc
[trusted]
users = tomcat
EOF

Openbravo ERP Installation

Once you have obtained the source code follow these steps to install it.

Editing the Configuration files

  1. Move to the OpenbravoERP-2.50MPX in a command line terminal and run: 
    ant setup
  2. Move to the OpenbravoERP-2.50MPX/config directory.
  3. Access the graphical configuration wizard:
    • Linux: make executable and run setup-properties-linux.bin
    If you face any segfaults running this tool, add --mode xwindow or --mode text as an argument.
    • Windows: run setup-properties-windows.exe
  4. Configure the Openbravo.properties and log4j.lcf files using the configuration wizard.

These configuration wizard can also run in text mode without a graphical system. It will detect the correct display mode for your system.

Compilation

Before starting with compilation, check that Openbravo.properties and log4j.lcf files (in the config directory) have been properly configured. If not, edit them manually.

  1. In the command line type: 
    ant install.source
    The ant install.source command creates the database from *.xml files and installs Openbravo ERP.
  2. If you have explicitly selected war as the deploy.mode during the setup, you must deploy the openbravo.war file into the Apache Tomcat context directory using the command: 
    ant deploy.context
    Note that this step is not needed if you selected the default options.

Database cleanup

If you are using PostgreSQL database, you must clean the database before you access Openbravo ERP to prevent performance issues. Use the command: 

vacuumdb -f -z -h ''hostname'' -d ''dbname'' -U ''username''

Replacing hostname with the actual hostname of your DB server, dbname with the database name (by default openbravo), and username with the name of the DB user (by default tad).

Configuration Validation

Before you access your Openbravo instance, it is strongly recommended that you run the following command to validate your system configuration: 

ant diagnostic

Using Openbravo ERP

Login into Openbravo ERP

  1. Open your chosen web browser.
  2. In the address bar, type the context URL. The context URL takes the form:
    http://hostname:port/context_name
    For example:
    http://localhost:8080/openbravo
  3. The Login screen appears:
  4. In the Username box, type the default username Openbravo.
  5. In the Password box, type the defalt password openbravo.
  6. Click Login. Openbravo ERP starts.

Login troubleshooting: If the error page HTTP Status 404 - File not found appears instead of the Login page, it means that there is a problem with the context URL. Check that the your_context_name directory has been created inside the Apache Tomcat webapps directory.

Note: the first time you log into Openbravo ERP, the system logs you on using the System Administrator role, so you can only see administration tasks on the Application menu. If you try to access business options (for example Business partners, products and sales and procurement orders) the message AccessTableNoView will display instead. To access business options, you must change your role to an Admin role, such as BigBazaar Adminor Openbravo Admin.

  1. Click the Openbravo link in the upper left hand corner of the window. The User Options window appears.
    image:ChangeRole1.png
    From the Role Information menu, select an Admin role (Openbravo Admin or BigBazaar Admin).
  2. To set the Admin role as default, select the Set as default checkbox.


Configuring Openbravo ERP

After Openbravo ERP is properly installed and running, you can customize it to suit your country or region.

Installing a translation

Openbravo ERP supports different languages. To translate the application into your language, download a translation.

Configuring the default date and time formats

To change the default Openbravo ERP date format launch the setup tool inside the config/setup-tool directory.

Once all the changes are done, recompile and deploy Openbravo ERP: 

ant compile.complete.deploy

Configuring the default numbering format

You can modify the way numbers are displayed in reports for example whether , or . is used as the decimal point.

  1. In the directory where Openbravo ERP is installed, navigate to the config folder.
  2. Using a text editor edit the Format.xml file.
  3. Modify the default numbering formats as required.
  4. Save the Format.xml file
  5. Restart the Tomcat service.

Upgrading

Upgrading from previous versions

An upgrade path is available from the 2.40 series to 2.50.

Upgrading to the latest maintenance pack

There are two possible ways of doing it: online and offline, depending if the server has an Internet connection or not.

Note: If you are upgrading from Openbravo ERP 2.50MP2 or earlier, you first need to upgrade to MP3 using the Offline method, to then be able to upgrade to the latest version. Starting from 2.50MP3 updates can be applied cumulatively. For example, this means that you can update from 2.50MP3 to 2.50MP13 in a single step.

Image:Bulbgraph.png   Community Appliance users who want to upgrade their appliance should first increase the system RAM memory to 1024MB at least. Prior it follow these instructions to activate your Openbravo ERP instance.

Online

To update from 2.50 to the latest 2.50 maintenance pack (e.g. 2.50MP13) go to the Module Management Console inside Openbravo ERP, click on Scan for updates and apply the Core update.

Note that this method works starting from 2.50MP6.

Offline

If the server doesn't have a Internet connection available and you want to update from 2.50 to the latest 2.50 maintenance pack (e.g. 2.50MP13) download the Core OBX module from Partner Restricted Area and apply it using the Module Management Console inside Openbravo ERP.

Image:Bulbgraph.png   Starting from 2.50MP10 the OBX files are exclusive for Professional Subscribers and they're available in the Partner Restricted Area. The 2.50MP9 version is the last Community OBX, which can be obtained from its release notes page.

Other resources and links

Additional useful tips related to rebuilding the system when installing or upgrading modules or upgrading Openbravo Core could be found here.

Openbravo ERP FAQ

Openbravo's ERP Frequently Asked Questions (FAQ).

Support

For any question or doubt regarding Openbravo ERP installation, post them in Openbravo Help forum or join #openbravo IRC channel in Freenode.

Retrieved from "http://wiki.openbravo.com/wiki/ERP/2.50/Openbravo_ERP_Installation#Ubuntu_Installation"

This page has been accessed 70,875 times. This page was last modified 10:40, 17 March 2010. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.


Category: Installation ERP