Search:  
Gentoo Wiki

Openbravo_ERP


This article is part of the HOWTO series.
Installation Kernel & Hardware Networks Portage Software System X Server Gaming Non-x86 Emulators Misc

Contents

Introduction

Openbravo ERP is an open-source (MPL) web based ERP for SMEs. It encompasses a broad range of functionalities such as finance, supply chain, project management, manufacturing and much more. Currently it supports two databases: Oracle and PostgreSQL. This HOWTO focuses in the PostgreSQL version.

Preparing the system

The software requirements of version 2.35MP4 are:

* Sun JDK >= 1.5
* Apache Ant >= 1.6.5
* Apache Tomcat >= 5.5
* PostgreSQL >= 8.1.4

All these packages are included in portage. Openbravo ERP 2.35MP4 doesn't support PostgreSQL 8.3.x. Version 2.40alpha supports it. PostgreSQL 8.2.7 is still masked with ~keywords. You'll have to add this packages to your package.keywords.

File: /etc/portage/package.keywords
# PostgreSQL
dev-db/postgresql-server
virtual/postgresql-server
dev-db/postgresql-base
virtual/postgresql-base

After this, you are ready to emerge them:

emerge -av sun-jdk ant-core tomcat =postgresql-server-8.2.7
emerge --config =postgresql-8.2.7

Modifying system variables

The $JAVA_HOME variable must point to the 1.5 or 1.6 JDK. In my case I have sun-jdk-1.5, blackdown-jdk-1.4.2 and sun-jdk-1.6, so:

java-config -S sun-jdk-1.6

Now we'll tweak Tomcat's CATALINA_OPTS variable.

File: /etc/conf.d/tomcat-6
CATALINA_OPTS="-server -Xms384M -Xmx512M"

NOTE: -Xms384M and -Xmx512M performance values depend on the amount of memory of the system. This should be a good value for most systems, though.

PostgreSQL password

The postgres database user does not have a password by default (do not confuse with the system's postgres user), it accepts password-less logins from the local host. To set a password:

psql -U postgres
alter role postgres with password 'new_password';
\q
sed -i 's/trust$/md5/' /var/lib/postgresql/8.2/data/pg_hba.conf
/etc/init.d/postgresql-8.2 reload

Installing Openbravo

Download it from Sourceforge. Select the Linux, Linux-x64, Linux-ia64 or Linux-ppc version, depending on your processor.

Launch the installer as a non-root user:

chmod +x OpenbravoERP_2.35MP4-linux-installer.bin
./OpenbravoERP_2.35MP4-linux-installer.bin

It is possible to launch it in text mode by adding the "--mode text" argument.

These are the options I choose in the installer:

  1. Installation directory: /home/myuser/OpenbravoERP (default)
  2. Attachments directory: /home/myuser/OpenbravoERP/AppsOpenbravo/attachments (default)
  3. Installation type: Full (standard) installation. From sources, not binary. (default)
  4. Database: PostgreSQL
  5. Java home directory: /etc/java-config-2/current-system-vm (default)
  6. Ant home directory: /usr/share/ant-core/bin/ant (default)
  7. Tomcat installation directory: /var/lib/tomcat-6 (default)


  1. Web Server domain: MyHostName (write your hostname here)
  2. HTTP port: 8080 (default)
  3. Context name: openbravo (default)
  4. PostgreSQL directory: /usr/bin (it looks for the psql bunary)
  5. Database host: MyHostName (write your hostname here)
  6. Port: 5432 (default)
  7. Database name: openbravo (default)
  8. Database password: your_postgres_password, the one you've previously set
  9. Openbravo Database user: tad (default)
  10. Openbravo Database user: tad (or whatever)

Now it will start compiling. Take a cup of coffee, it takes 20 minutes on my 2.0GHz Core2Duo laptop. You can track the installations state by reading the log files in /opt/OpenbravoERP/installation_logs.

Test

It's done. Restart Tomcat:

/etc/init.d/tomcat-6 restart

Open http://MyHostName:8080/openbravo with your browser


Enjoy!

Contact / Feedback

Feel free to write in the Gentoo Forums post with comments, modifications or suggestions.

Sources/Further Information

Official Openbravo documentation

Gentoo official Tomcat guide

Gentoo official Java upgrade guide

Retrieved from "http://www.gentoo-wiki.info/Openbravo_ERP"

Last modified: Mon, 08 Sep 2008 03:34:00 +0000 Hits: 12,206