Enable Memcached with Koha

What is Memcached?

"Free & open source, high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load" (https://memcached.org/).

Why we should use Memcached with Koha?

Memcached can boost the performance of Koha.

I have tried to enable Memcached with Koha versions 17.05.x to 18.05.x.

Check Memcached working with Koha

Open Koha > About Koha > Server Information

The red flag indicates that Memcached not working

Delete records in Koha

In certain occasions need to empty bibliographic, patron and transaction details from Koha database and clean the installation to start the process again. The user has to go to Koha database and empty the concerned tables.

Log into MySQL
Apply following commands to login to the MySQL database;

sudo su

mysql -uroot -p
use koha_library;

Delete circulation entries from databse tables (DBMS auto increment)

Certain records reluctant to Checkin due to DBMS auto increment problem. In such cases, the transaction remains in the tables. Developers still working on the solution. Here is a temporary solution. I tried this steps on Koha installed on Debian 8,9 and Ubuntu 16.04 with MySQL and MariaDB Server.

Symptoms of DB increment problem

Record reluctant to check-in.

How to change master password of Koha ?

Koha master login username and password is same as MySQL database (e.g. koha_library), where data stored.

First change the password of koha_library database.
Then put new password in /etc/koha/sites/library/koha-conf.xml

Apply following commands in Applications > Accessories > Terminal

sudo mysql -uroot -p  

[enter the MySQL Root password]

use mysql;
SET PASSWORD FOR 'koha_library'@'localhost' = PASSWORD('koha123');
flush privileges;
quit;

Need to change new password in Koha configuration file.

Open the configuration file using any text editor. Use any text editor, mousepad/leafpad. Install mousepad;

sudo apt-get install mousepad

sudo mousepad /etc/koha/sites/library/koha-conf.xml

The file will open. Scroll to bottom part of the file and find the line for password.

You can find old password. Place your new password.
Save [Ctrl+O] and close [Ctrl+x] the file. Login Koha using new password.