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.

Three days Koha workshop at Kerala Library Association Kottayam region

HIGHLIGHTS OF THE WORKSHOP
1. Selection and management of Open Source software in library
2. Basic Linux training
3. Learning of Koha installation on Ubuntu 14.04 LTS
4. Hands on training of Koha modules
5. Tips for system maintenance and administration
6. How to utilize Koha community support

VENUE AND DATE
Venue: Marian College Kuttikkanam
Date: 17-19 September 2015

RESOURCE PERSONS
Vimal Kumar V.
Technical Assistant
Mahatma Gandhi University Library
Kottayam

Prajeesh Bhaskaran
Technical Assistant
Mahatma Gandhi University Library
Kottayam

Savithry T.K.
Technical Assistant
Mahatma Gandhi University Library
Kottayam

Jasimudeen S.
Librarian
St. Stephens College, Uzhavoor
Kottayam

Jobin Jose
Librarian
Marian College Kuttikkanam

REGISTRATION
A maximum of 30 participants will be permitted.
Admission is on first-come-first-serve basis.
The registration fee: Rs. 2000 . (To be paid by Demand Draft in favour of The Principal, Marian College Kuttikkanam payable at Peermade).
The Registration fee includes workshop kit, food and accommodation.

Advance online registration
https://docs.google.com/forms/d/1tUMI25qTyYFDnAD2qAt0f9BT2Djzsbsw2Cc9n1IWZd4/viewform?usp=send_form

You can download registration form from here

Duty leave will be available for the participants.

METHODOLOGY
Lectures, demonstration, discussions and extensive practical sessions will be available.

CONTACT DETAILS

Vimal Kumar V.
Secretary
Kerala Library Association
Kottayam Region
Mobile: 9846496323
vimal0212 at gmail.com

Mr JOBIN JOSE
Librarian,
Marian College Kuttikkanam
Peermade, Idukki Dt., Kerala – 685 531
Mob: 09447827393, 04689-232203 (O)

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 http://debian.koha-community.org/koha stable main | sudo tee /etc/apt/sources.list.d/koha.list
wget -O- http://debian.koha-community.org/koha/gpg.asc | 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:
libapache2-mpm-itk
apache2-mpm-itk
koha-common
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.

INTRAPORT=”80″

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=”;
FLUSH PRIVILEGES;
QUIT


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,

http://127.0.1.1:8080

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
http://kohageek.blogspot.in/2013/05/how-to-change-master-password-of-koha.html

Reference
Koha on Ubuntu Packages