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

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



Work with Openbravo

Bulbgraph.png   This document refers to the appliances 12.04 and 14.04.


Connect to the database


Connect by ssh with openbravo user and then you can connect to the database with:

psql -h localhost -U tad openbravo

Default password: tad

pgadmin with ssh tunnel

ssh tunnel in linux

Connect by ssh doing a tunnel from your local port 5433 of the server port 5432

ssh openbravo@<IP_ADDRESS> -L 5433:localhost:5432

Then in your local pgadmin in host set localhost and port 5433

ssh tunnel in windows

PuTTY is an open source and free SSH client.

Use PuTTY to connect to PostgreSQL:

  1. Select Session'.
  2. In the Host Name' box, enter IP Address of the Openbravo Appliance.
  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 openbravo as user name and your password, then leave this Putty window opened.

pgAdmin connection setup

Now you can start psql, pgAdmin or your favorite client and use localhost as the host and 5433 as the port in the connection details.

The database name is openbravo, the username tad and the password tad.



Check that you are logged in with the openbravo user and in the /opt/OpenbravoERP folder.

You can check the current username with:


You can check the folder in which you are with:


Then you can compile. For example:

ant smartbuild
Bulbgraph.png   Do NOT use sudo or the root user for compilation.


The logfiles of openbravo are in the /var/log/openbravo folder.

The application logfiles:


The PostgreSQL logfile

/var/log/openbravo/postgresql-9.1-main.log  # Appliance 12.04
/var/log/openbravo/postgresql-9.3-main.log  # Appliance 14.04

And the log of the periodic/automatic backups


Customizing parameters

Customizing Tomcat parameters

The configuration for Tomcat is in


If you need to set more ram to tomcat take a look to the memory recommendations.

Customizing PostgreSQL parameters

The configuration for PostgreSQL is in this folder

/etc/postgresql/9.1/main/  # Appliance 12.04
/etc/postgresql/9.3/main/  # Appliance 14.04

For get a better performance with big volume databases a good idea it is to increase the memory assigned to postgres.

Customizing Ant parameters

The default options should be fine for most cases, but if you need to adjust them they are in


Restart services

Restart Tomcat

To restart Tomcat

sudo /etc/init.d/tomcat restart

Restart PostgreSQL

Usually it is not needed to restart PostgreSQL manually, only to apply some new configuration values.

Bulbgraph.png   PostgreSQL will not stop itself if there are open connections from i.e. tomcat, psql or pgadmin.

So before restarting PostgreSQL you need to close all pgadmin, psql connections and shutdown Tomcat.

sudo /etc/init.d/tomcat stop
sudo /etc/init.d/postgresql restart
sudo /etc/init.d/tomcat start

Retrieved from ""

This page has been accessed 28,768 times. This page was last modified on 30 April 2015, at 15:20. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.