One day Koha training program for LIS students

Kerala Library Association, Kottayam Region and BCM College, Kottayam jointly organised one-day training program on Koha Open Source library management system on 24 May 2017. MLISc students from St. Berchmans College, Changanacherry participated in the training program. The main aim of the program was to give Koha training and enhance confidence level of LIS students before entering into a workplace.

Koha workshop-Sr. Gracena
Welcome speech by Sr. Gracena, Librarian, BCM College, Kottayam
Koha workshop-inauguration
Koha training inaugurated by Prof. Sheela K. Cherian, Principal, BCM College, Kottayam.
Koha workshop
Participants of Koha training.
Koha workshop Tinju
Vote of thanks by Rev. Fr. Tinju Tom.

Install Koha on Ubuntu 14.04

Install Ubuntu 14.04 and update
Koha can install on Ubuntu/Xubuntu/Kubuntu/Lubuntu/LinuxMinst 17. Install the operating system first. Then update the system using following commands:apt-get update
apt-get upgradeInstall lightweight text editor
apt-get install leafpad

Add Koha community repository
Add Koha software channel into Ubuntu.
echo deb stable main | sudo tee /etc/apt/sources.list.d/koha.list
wget -O- | sudo apt-key add –

apt-get update

Install Koha
Following command will install latest release of Koha.

apt-get install koha-common

The command will start to download Koha and required packages.
On the way, the process will ask to enter mail of system. Accept the default values.
Have you got following error message?
Errors were encountered while processing:
E: Sub-process /usr/bin/dpkg returned an error code (1)
This error related with  apache2-mpm-itk issue. Apply following commands. If you have not found error related to apache2-mpm-itk, skip following section.

How to solve apache2-mpm-itk issue?
Apply following commands in a terminal
sudo a2dismod mpm_event
sudo a2enmod mpm_prefork
sudo service apache2 restart

sudo apt-get install -f

Server configuration
In this step, need to edit network information like domain name and port numbers.

sudo leafpad /etc/koha/koha-sites.conf

Here I change port number of Koha staff client. Find following line in the file and change 80 to 8080.


Install MySQL server
Apply following command to install MySQL server.

sudo apt-get install mysql-server

Give a new password for root user while installation.

Koha instance creation
Apply following commands to create Apache configuration files.

sudo a2enmod rewrite
sudo a2enmod cgi
sudo service apache2 restart

Create a Koha instance with the name library.

sudo koha-create –create-db library

Ubuntu MySQL security Tweak
Apply following commands:

sudo su
mysql -u root -p

[Enter the MySQL Root password when it ask]

Execute the following commands  too,

USE mysql;
DELETE FROM user WHERE user=”;

Adding ports
We have assigned 8080 port for Koha staff client and 80 for OPAC.
Open following file and add new port.

sudo leafpad /etc/apache2/ports.conf

Copy paste following line below Listen 80

Listen 8080

Restart Apache,

sudo service apache2 restart

Enable modules and sites

sudo a2dissite 000-default
sudo a2enmod deflate
sudo a2ensite library
sudo service apache2 restart

Start web installation of Koha

The username to log in with will be koha_library and the password will be near the end of /etc/koha/sites/library/koha-conf.xml

Apply the following command to see the koha login password. Note down the password.

sudo xmlstarlet sel -t -v ‘yazgfs/config/pass’ /etc/koha/sites/library/koha-conf.xml
Open following link in a browser and proceed with the post installation configurations,

Default User Name is koha_library

How to change Koha default master password?
Default master passerword of Koha is difficult to remember. Either note down the password in a diary or change the password.

See the following link

Koha on Ubuntu Packages