Sunday, January 16, 2011

Openbravo: Servers 1 and 2

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:
  • username: Openbravo
  • password: openbravo
Note: the login credentials are case-sensitive.