Setup MySQL as Datasource for OFBiz


Derby is the default database of ofbiz. Now we migrate our database to MySQL from derby.
1. Before you start migrating check your installed MySQL version & download the supported version of mysql-connector.jar
2. Place the mysql-connector.jar to <ofbiz-dir>/framework/entity/lib/jdbc
3. Create 3 database [Ex. ofbiz, ofbizolap, ofbiztenant]
4. Open entityengine.xml file from <ofbiz-dir>/framework/entity/config/
5. Edit as follows,

Installing ibus-avro on Ubuntu


Installation process
Open Terminal and enter the following commands one by one.
1. Add ibus-avro repository
sudo add-apt-repository “deb ./”
2. Add key
wget -q -O- | sudo apt-key add –
3. Update package list
sudo apt-get update
4. Install ibus-avro
sudo apt-get install ibus-avro-trusty
5. Now you need to logout and login again or restart your computer.

Using ibus-avro
1. Click the IM icon in menubar and Select Text Entry Setting

2. In Text Entry Setting window click + icon (marked by arrow) in left pane. Write avro in the search box (marked by arrow). Choose Bengali (Avro Phonetic) from the list and press Add button to add Avro to the list.

3. (Optional) The keyboard shortcut to switch input method has been changed to Super+Space since ubuntu 13.10. You can change it to your preference from Text Entry Setting window.
4. Open any text editing software (like, gedit). Now Press Super+Space to toggle between English and Avro (Bengali)
5. Enjoy Avro Phonetic!

Uninstalling ibus-avro
1. Open Text Entry Setting and remove Avro Phonetic by clicking – icon.
2. Open Terminal and enter the following command:
sudo apt-get remove ibus-avro-trusty


Upgrade UBUNTU


Before updrade your ubuntu with the current stable release please run 
sudo apt-get update –fix-missing
instead of running
sudo apt-get update
because currently running ubuntu may not be able to fetch some archives.
Then enter the command
sudo apt-get upgrade