Sunday, February 23, 2014

How to setup Open Bravo with MySQL database, for multi cashier, single database

I recently decided to use open bravo on my minimarket.

BUt it uses file based database, since i want to implement it on multi cashiers as clients and one of the cashier as server, so i try to change the database configuration to use mysql database.

First you have to Open Openbravo POS

Then Enter using Administrator privilege (click the adminsitrator button).

Click configuration from menu

Click configure Database

Use Library > Browse MySql connector i.e.

\app-path\mysql-connector-java-5.0.8-bin.jar  (u can download this library from mysql site) i download it from http://dev.mysql.com/downloads/connector/j/

fill the Driver class with com.mysql.jdbc.Driver

Set the URL to : jdbc:mysql://localhost:3306/dbname

Set the user to : MySql User

Set the Password to : MySql Password (If empty leave blank)

Click Save button and restart Openbravo POS system.

Before restarting, create a database first with name = dbname using phpmyadmin (i am currently using XAMPP on WIndows 7, since my lx300 epson currently have no win 8 compatibility).

Automatically MySql database will be created.

image

Saturday, February 22, 2014

AhadPOS, free point of sales software for Windows and Linux

AhadPOS is one amongst free and open source softwares that specialize in point of sales. this software was developed from scratch by RimbaLinux teams Indonesia, hence was initially directed towards indonesian minimarket owner.

This software is very easy to install, using php and mysql, can be used on multi cashier. There are also VM-version of the software that bundled this AHadPos with Ubuntu linux. You can download this free and open source software from http://ahadpos.wordpress.com/produk/

The review of this software will be available soon on this blog.