Openbravo POS/Installation guide

From Wikibooks, open books for an open world
Jump to navigation Jump to search

Program installation[edit | edit source]

Install java[edit | edit source]

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

On Windows[edit | edit source]

You can install Java from Sun's website

On Ubuntu[edit | edit source]

Ensure to have the multiverse repository activated and type

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

Download and unpack openbravo POS[edit | edit source]

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

Run it![edit | edit source]

In windows execute the file "start.bat", in Linux execute "start.sh" to make sure everything is running correctly. openbravo POS should display a warning alerting that it has found an empty database. Click OK to create the database structure necessary to run LibrePOS.

At this point you should decide whether you want to run LibrePOS on the built-in HSQLDB engine or, alternatively Database_configuration|use the MySQL or PostgreSQL databases

Database configuration[edit | edit source]

LibrePOS supports four database engines: HSQLDB, MySQL, PostgreSQL and Oracle

LibrePOS uses HSQLDB by default for data storage. HSQLDB is bundled with the binary package of LibrePOS 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 LibrePOS, it will tell you that your database is empty and will offer you to create tables for your new database. This is normal. Click the 'yes' button to allow LibrePOS to create the tables for you (In LibrePOS 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 JAR file.
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[edit | edit source]

On Windows[edit | edit source]

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

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

Alternatively you can install all-in-one packages that include also Apache, PHP and phpMyAdmin like WAMP Server or XAMPP

On Ubuntu[edit | edit source]

Activate the universe repository and do

sudo apt-get install mysql-server libmysql-java

You can also install phpMyAdmin

sudo apt-get install phpmyadmin php5

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

Usage[edit | edit source]

Create a 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/tinapos
User: yourname
Password: yourhost

PostgreSQL[edit | edit source]

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

On Windows[edit | edit source]

Download the server and get the JDBC 3 driver according to your version

On Ubuntu[edit | edit source]

Ensure you have the universe repository activated and do

sudo apt-get install postgresql-8.2 libpg-java

You can also install administrators like pgAdmin3 or phpPgAdmin

sudo apt-get install pgadmin3
sudo apt-get install phppgadmin php5 php5-pgsql

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

Usage[edit | edit source]

After the database server is installed and running you have to create an empty database for LibrePOS 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/tinapos
 User youruser  
 Password: youpass

Oracle[edit | edit source]

Download and install Oracle XE and the JDBC Driver

Usage[edit | edit source]

An example of database configuration is

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