Cataloguing of multi volume books

Here is the method to catalogue multi volume books. Here I am trying to catalogue the book "The Complete works of Swami Vivekananda". This books has nine volumes. Enter the biblio part same like any other book.

Cataloguing > New Record > 

Enter volume information in Biblio and Save.

Multi volume details can be enter in item information.

Save the item and add other volume details.

See the final record in OPAC (click on the picture to get enhanced view).

How to solve email sending problem with Postfix and Gmail

Many Koha users are using Gmail with Postfix mail server to send email notifications. Its essential to enable less secure sign in to start to send notifications from Gmail. Otherwise emails will not send.

Goto the following link and enable Less secure apps in Gmail account.

This option at the bottom of the page.

Information courtesy: Dr. Mukesh Pund, NISCAIR, New Delhi

Enable Google Indic Transliteration in OPAC search box

Google Indic Transliteration is a useful to enter search queries in regional languages. Here is the step to enable Transliteration option in Koha OPAC search box.

Administration > Global System Preferences > OPAC > GoolgeIndicTransliteration > Show

You can check how Google Indic Transliteration works with Koha OPAC from following link,

Attaching files to catalog records

Users can upload documents (e.g. pdf, text, doc etc.) while cataloging with Koha version 3.22.x. Uploaded documents store in internal directory and the link add in 856$u tag. The main advantage is that no need to store files in external storage places like Google Drive and Dropbox.

Little tweaks are necessary on Koha system to make available this feature. Follow the steps:

Set upload path

1. Check Koha > About Koha > System information. Check the following warning.
2. Open koha-conf.xml file with your favorite editor and place destination directory.

leafpad /etc/koha/sites/library/koha-conf.xml

Place following line below, <docdir>/usr/share/doc/koha-common</docdir>


3. Restart Apache 

/etc/init.d/apache2 restart

4. Check again Koha > About Koha > System information. No warning message, if destination folder is ready,

Assign OPACBaseURL

Search for OPACBaseURL in Koha > Administration > Global system preferences


Add plug-in in Bibliographic framework

Goto Administration > MARC Bibliographic Framework > Books, Booklets, Workbooks > MARC Structure

Search for Tag 856$u

Upload documents while cataloging

1. Click on the plug-in icon on 856$u field.

2. Upload file
 3. Choose the file to include in 856$u field.

4. Search in OPAC for the book and see the document link appeared in the details.

Auto spell check while cataloging

You can enable Auto spell check option in Firefox browser.

Type about:config in Firefox browser address bar.

Type layout.spellcheckDefault in Search box

Double click on the item and change the value to 2

Information courtesy: Owen Leonard, Web Developer
Athens County Public Libraries

Move old Koha database to new installation

1. Backup of old Koha
Take backup of your existing Koha database. Either you can make use a database kept in your pen drive otherwise you can apply following command to take backup,

mysqldump -uroot -pmysqlroot koha_library | gzip -9 > koha_library.sql.gz

2. Install Koha

3. Restoration of old Koha database to new one

Remove existing database in new installation

sudo su
mysql -uroot -p
[Enter the MySQL Root password]

drop database koha_library;
create database koha_library;

Copy your database backup from your pen drive to home folder.
Extract the backup file, the extension will be .sql

Then restore the old backup to new installation.

Database Restoration command,

mysql -uroot -p koha_library < koha_library.sql     [Check name of your source Koha database] 

koha_library - name of database in new installation
koha.sql - name of database in old installation

Enter the MySQL root password.

4. Upgrade Database Schema
Database schema of old Koha should upgrade to new one. Apply following commands in a terminal,

sudo su
koha-upgrade-schema library

5. Rebuild the Zebra Index.

Apply following command in a terminal,

sudo koha-rebuild-zebra -v -f library

Install Koha on Ubuntu 14.04

Install Ubuntu 14.04 and update

Koha can install on Ubuntu/Xubuntu/Kubuntu/Lubuntu/LinuxMint 17. Install the operating system first. Then update the system using following commands:

apt-get update
apt-get upgrade

Install 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 to 8080. Find following line in the file and make changes.


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 command:

sudo mysql_secure_installation

[Enter the MySQL Root password]

Give the answer n (no) for the first question. Give Y (Yes) for other questions.

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

Change Koha default master password
See the following link

Install missing PERL modules
After install need to install some PERL PERL modules using CPAN.

Koha > About Koha > Perl Modules

Find missing PERL modules in different colors.

Open a terminal and apply following command to enable CPAN.

sudo su

To install a particular PERL module, e.g.

install Test::DBix::Class

How to start Koha
Open following links, (Stff client) (Online catalogue)

Koha on Ubuntu Packages