OpenbravoPOS Installation

Software installation

Install Java

Openbravo POS is an application developed in Java and to execute it you will need the Sun Java Runtime Environment 1.5 or greater.

On Windows

You can install Java from Sun's website

On Ubuntu

Ensure to have the multiverse repository activated and type

sudo apt-get install sun-java6-jre sun-java6-fonts

Download and unpack Openbravo POS

Download the lastest version of the binary package of Openbravo POS from Sourceforge, open it with your favourite decompresser and extract all the files to an empty folder.

Run it!

The first time Openbravo POS starts and there is not a a database, it display a warning alerting that it has found an empty database. If you click OK, Openbravo POS will create for you the database structure necessary to run.

On Windows

Execute the file start.bat just double clicking on it or from the command line. You can also create a shortcut to this file and place it in your preferred location: the desktop, the launch bar...

On Linux

Execute start.sh.

In linux need first to add execution permissions to the files start.sh and configure.sh to do this execute the following commands

chmod +x start.sh 
chmod +x configure.sh  

On MacOSX

Open the Apple Terminal (located at: /Applications/Utilities) and go with the command line to the location the start.sh file is located. Then type:

sh start.sh

Database configuration

Once Openbravo POS is installed you should decide whether you want to run Openbravo POS on the built-in engine or on any of the other database engines supported. Openbravo POS supports four database engines: HSQLDB, MySQL, PostgreSQL and Oracle

Openbravo POS uses HSQLDB by default for data storage. HSQLDB is bundled with the binary package of Openbravo POS and offers an advantage in that it doesn't have to be configured. However, a lot of users choose other relational databases for performance or reliability.

To configure the database go to the configuration panel or run the file configuration.bat in windows or configuration.sh in linux. Please be aware that once you restart Openbravo POS, it will tell you that your database is empty and will offer you to create tables for your new database. Click the yes button to allow Openbravo POS to create the tables for you (In Openbravo POS version 0.0.24 there should be 26 tables).

The properties related to the database configuration are:

Driver library

Is the file provided by the database engine vendor that contains the JDBC driver that allows Java programs to communicate with the database. It is usually a file with extension .jar.

Driver class

Is the java class name that implements the JDBC driver. This name is also defined by the database engine vendor.

URL

Is the connection string that uses JDBC to localize the JDBC the driver and the database.

User

The name of the authorized database user.

Password

The password of the database user.

MySQL

On Windows

Download MySQL server (essentials package recomended) and install it.

Download MySQL Connector/J, unzip the contents and place it in the same folder where Openbravo POS resides.

Alternatively you can install MySQL Administrator and MySQL Query Browser MySQL GUI Tools Downloads.

On Ubuntu

Activate the universe repository and do

sudo apt-get install mysql-server libmysql-java

You can also install MySQL Administrator and MySQL Query Browser

sudo apt-get install mysql-admin mysql-query-browser

Connector/J is on /usr/share/java/mysql.jar. You can copy or link it to Openbravo POS' folder

Usage

Create an user and a database. You can check MySQL documentation An example of a database configuration using MySQL as database engine is:

Driver library: mysql-connector-java-3.1.6-bin.jar
Driver class: com.mysql.jdbc.Driver  
URL: jdbc:mysql://localhost:3306/openbravopos
User: yourname
Password: yourpass

PostgreSQL

To use Openbravo POS with PostgreSQL you must have a PostgreSQL server running and the JDBC driver for PostgreSQL.

On Windows

Download the server PostgreSQL download and install it.

Download the JDBC driver PostgreSQL JDBC Driver acording to your version and install it.

You can also install the PosgreSQL administration tool pgAdminIII.

On Ubuntu

Ensure you have the universe repository activated and do

sudo apt-get install postgresql-8.2 libpg-java

You can also install the administrator tool pgAdmin3.

sudo apt-get install pgadmin3

The JDBC lib is on /usr/share/java/postgresql.jar. You can copy or link it to Openbravo POS' folder

Usage

After the database server is installed and running you have to create an empty database for Openbravo POS and a database user with privileges to connect to this database. You can check PostgreSQL documentation

An example of a database configuration using PostgreSQL as database engine is:

Driver library: postgresql-8.0.309.jdbc3.jar  
Driver class: org.postgresql.Driver  
URL: jdbc:postgresql://localhost:5432/openbravopos
User youruser  
Password: youpass

Oracle

To use Openbravo POS with Oracle you must have an Oracle server running and the JDBC driver for Oracle.

On Windows

Download and install Oracle XE and the JDBC Driver

You can also install to administer and query the database Oracle JDeveloper.

On Ubuntu

Download and install Oracle XE and the JDBC Driver

You can also install to administer and query the database Oracle JDeveloper.

Usage

After the database server is installed and running you have to create an empty database for Openbravo POS and a database user with privileges to connect to this database.

An example of database configuration is

Driver library: ojdbc14.jar
Driver class: oracle.jdbc.driver.OracleDriver
URL: jdbc:oracle:thin:@localhost:1521:xe
User youruser  
Password: youpass

Additional help

If you need additional help during installation please use the Openbravo POS community support forums.