ByWater Solutions Announces the Open to Everyone Webinar Series

The Koha Staff Experience July 14, 2022

In this 30 minute, The Koha Staff Experience, we will cover the basics of the Koha Staff interface and how staff can intuitively navigate through the models

Registration Link:

Discover the Koha OPAC on August 9, 2022

In this 30-minute webinar, Discover the Koha OPAC, we will cover how patrons can intuitively navigate through the Koha OPAC, access their account information, and browse all materials!

Registration Link:

Technical Services Overview September 15, 2022

In this 30-minute webinar, Technical Services Overview, we will cover the basics of cataloging, acquisitions, serials, and the tools for technical services workflows in Koha!

Registration Link:

The Koha Staff Experience October 18, 2022

In this 30-minute, The Koha Staff Experience, we will cover the basics of the Koha Staff interface and how staff can intuitively navigate through the models.

Registration Link:

The Basics of Circulation November 16, 2022

In this 30-minute webinar, The basics of circulation, we will cover how staff can utilize the circulation functionality and integrate it into their daily workflows for a successful customer experience.

Registration Link:

An Administrators Overview December 8, 2022

In this 30-minute webinar, An Administrators Overview, we will cover how Koha’s administration functionality can help users easily perform their day-to-day jobs at the library.

Registration Link:

Install MarcEdit on Ubuntu

MARCEdit was originally developed on the .NET development platform for Windows operating system. MARCEdit developers offer a Linux version, it requires a Windows-like environment in Linux. We need to install Mono to prepare the Linux-based operating system for the installation of MARCEdit. Following are the steps to install Mono and MARCEdit software on Ubuntu. I tried this method to install MARCEdit on Ubuntu 20.04 and 22.04.

Add the Mono repository to your system

Apply the following commands one by one,

sudo apt install gnupg ca-certificates

sudo apt-key adv --keyserver hkp:// --recv-keys 3FA7E0328081BFF6A14DA29AA6A19B38D3D831EF

echo "deb stable-focal main" | sudo tee /etc/apt/sources.list.d/mono-official-stable.list

sudo apt update

Install Mono

No need to install the full Mono package to run MARCEdit.

The following package mono-xsp4 is enough for running ASP.NET applications.

sudo apt install mono-xsp4

Installation of MarcEdit

Download the MarcEdit package suitable for Linux based OS from here,

The filename would be

Give permission to MarcEdit package,

sudo chmod +x

Apply the following command to install the package,

sudo ./ --target ~/Documents/marcedit

If the installation succeeds, the MarcEdit icon will appear on the desktop. Don't worry if the icon does not appear on the screen. We can run the MarcEdit software from the folder. The MarcEdit folder appeared on the Document folder. Change the permission of the marceditor folder.

cd Documents
sudo chmod -R 777 marcedit

Open the marcedit folder and find the MarcEdit.exe, double click on it. 

MarcEdit starts.

Fix MySQL/MariaDB socket error

Socket file helps to facilitate communication between different processes of the MySQL and MariaDB server. The file associated with the process is, mysqld.sock and is located at the folder, /var/run/mysqld/. Due to many reasons, MariaDB cannot establish a connection with the socket file. Sometimes socket files are missing from the location. It results in the stopping of the MariaDB service. The problem with the socket file also affects the working of Koha. Often Koha screen shows the following error on the screen.

Possible solutions

We can try to apply three solutions to evoke socket files; restarting the MariaDB service, changing user permissions, and reinstalling MariaDB. 

Solution 1: Try to restart the MariaDB service and check whether it's working.

sudo systemctl start mariadb

Refresh the Koha page. If it works, it means the socket file works. If it does not open, we go to the next solution.

Solution 2: Next, we will check whether the mysqld. sock file missing or not. Apply the following command,

ls -a /var/run/mysqld

The file is there, we can see a file with the name, mysqld.sock. If the file is missing from there, the reason may be that MariaDB has no proper permissions to create it. Give the directory permission to MariaDB users to make necessary changes.

sudo chown mysql:mysql /var/run/mysqld/
sudo chmod -R 755 /var/run/mysqld/

Restart the MariaDB service,

sudo systemctl restart mysql

If it is reluctant to start the service and shows the error, find other ways to solve it. The last resort is to reinstall the MariaDB.

Solution 3: Reinstall MariaDB

The first step is the uninstall the MariaDB without removing the Koha databases  (e.g. koha_library). The default location of the data directory of MariaDB is at /var/lib/mysql/, where we can see the Koha database directory.

The location of MariaDB data directory, /var/lib/mysql/
Apply the following commands to uninstall MariaDB,

sudo apt purge "mariadb*" -y

When it asks for deleting databases, give the answer No. It will retain the Koha database.

Apply the following command to remove unwanted packages after the uninstallation of MariaDB.
sudo apt autoremove -y

Apply the following command to reinstall the MariaDB,

sudo apt-get install mariadb-server mariadb-client

I faced the socket problem with MariaDB 10.3 on Ubuntu 20.04. I used the opportunity and installed a higher version of MariaDB (10.04) by adding a repository. The download page in the MariaDB home page gives you instructions to install a higher version of the package. Please check it,

After the successful installation of MariaDB, open the Koha Staff Client and check the page loads or not.


How To Troubleshoot Socket Errors in MySQL

MariaDB installation - dependency problems and failed to start service

Database administration tools other than PHPMyAdmin

DBeaver interface

is a popular database administration tool among Koha users. For beginners, the installation of PHPMyAdmin is complicated. A database administration tool is beneficial for Koha users and administrators to import and export data in a particular context. 

If you feel difficult to install PHPMyAdmin, we can try alternatives like DBeaver and Beekeeper Studio. Several other database administration tools are also available. The convenience of the Dbeaver and Beekeeper Studio is the ease of installation. Installation is easy; either use apt or Snap store. Both software has a simple interface and is easy to log in and manage databases. Certain features are missing with Beekeeper Studio (e.g., import from CSV), and I hope that those features will add soon. 

The home page of DBeaver is Here is the command to install DBeaver using Snaps, 

sudo snap install dbeaver-ce 

The home page of Beekeeper Studio is Here is the command to install Beekeeper Studio, 

sudo snap install beekeeper-studio 

The main highlight of the tools mentioned above is that the Snaps packages ( are available and it makes the installation easy.

Translate Koha into Indian languages

Eight regional languages in India were placed in the Koha translation project. Hindi and Telugu translation is almost finished, and other languages work is in progress. Except for Hindi and Telugu, no other Indian languages received community participation in the translation process.

How to participate in Koha translation

Koha Software community maintains an online platform for translation activities. The Koha translation website is available at The Koha software community uses free software called Pootle to manage translations. Each version of Koha is treated as a project and contains languages and translation files. Translation entries are saved in .po files and multiple .po files for different modules of Koha ILS. You can participate in translation activities by creating an account on the website. No technical knowledge is required to participate in translation activities.

Select the language (e.g. Malayalam) from the top of the website. Translation work on the four Koha editions is underway at the same time. 

Select the latest version of Koha for translation. Enter into the translation activities by clicking on the Koha version. When a new version of Koha is released, the current translation entries carry over to the latest one.

The translation entries are stored in different files. For ease of translation, lines related to various modules such as online catalogue, staff interface, messages and installer are stored in separate files. Clicking on the file link will allow you to enter into the file and view the lines to be translated.

Click on the Untranslated link, and it will list out the entries that need a translation. Translate the highlighted entries. 

Translate the highlighted English entries. Type the translated entries in the regional language in the box. Use Google Chrome browser, and the  Input Tools extension (Google Input Tools) to input translated entries. The translated entry can be submitted by clicking on the Submit / Suggest button. Suggested translations become part of the Malayalam translation once approved by the Administrator.

If there is a variable in the entries, it should be left as it is. Numbers, amounts, dates, etc., appear in the variable position. %s can be found where the variable appears. Even if you change the structure of the lines, add the variable note in the desired position. Do not delete the variable part.

When the translation of each line is complete, the next line is highlighted for translation.

Participation in the Koha translation project does not require technical expertise. Best collaboration space for LIS students and professionals. Participation in the Koha translation project helps the students and professionals acquaint themselves with Free Software’s sharing culture. Become a contributor and help in Koha translation.

Install Elasticsearch for Koha

Zebra is the default search engine with Koha. Koha project preparing to adopt Elasticsearch as the default search in the near future. Koha users can try Elasticsearch with Koha. Elasticsearch offers speed and more functionality than its counterparts and is considered an innovative search engine suitable to match the latest requirements. 

Here is the installation manual of Elasticsearch for Koha. I prepared this manual by receiving inspiration from the installation manual prepared by Dr Mohan Raj Pradhan, Professor (Retired), Department of Library and Information Science, Tribhuvan University, Nepal. I tried the installation of ElasticSearch on Ubuntu 20.04 LTS. Install the Koha before the implementation of Elasticsearch. Try the Elasticsearch installation on a test machine, not on Koha production computer.

Install the Koha dependencies and the Java JDK

sudo apt install koha-elasticsearch openjdk-11-jdk-headless

Installation of Elasticsearch

Elasticsearch 7 is the latest version. But Koha is not ready to adopt version 7. Koha uses Elasticsearch version 6.
sudo wget -qO - | sudo apt-key add -
sudo echo "deb stable main" | sudo tee -a /etc/apt/sources.list.d/elastic-6.x.list
sudo apt-get update && sudo apt-get install elasticsearch

Configure Elasticsearch for auto start

sudo /bin/systemctl daemon-reload
sudo /bin/systemctl enable elasticsearch.service

Install the analysis-icu plugin

sudo /usr/share/elasticsearch/bin/elasticsearch-plugin install analysis-icu

Restart the Elasticsearch server

sudo systemctl start elasticsearch.service

Check running status of Elasticsearch

Wait a few seconds then check if it is running correctly
sudo apt install curl
curl localhost:9200
curl http://localhost:9200/_cluster/health?pretty

Check installed Elasticsearch version

cd /usr/share/elasticsearch
sudo ./bin/elasticsearch --version

Change Search engine in Koha

Administration > Global system preferences > Administration > Search engine.

Rebuild search index

sudo koha-elasticsearch --rebuild -d library

Elasticsearch in Koha