Koha manual installation

Koha Manual Installation

> Step 1: Downloaded ubuntu 18.04 iso file from ubuntu official website.

> Step 2: Burn USB Bootable via Power ISO software or others..

>Step 3: Boot it and install ubuntu

>Step 4: after installation go to youtube and search 3. Installation of koha-18.05 on ubuntu18.04 LTS

> follow the instruction given in video and also below instructions

Installation of Koha on Ubuntu-18.04 LTS

Type these commands in terminal. To open terminal either you can press CTRL+ALT+T together or open through GUI.

Then enter

sudo su
(enter password, it will not be visible so be careful. Here you have to enter the same password which you have given at the time of installation).


Update Ubuntu

sudo apt-get update
sudo apt-get upgrade


Add Koha community repository


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 -

Update the software repository

sudo apt-get update

Install Koha

sudo apt-get install koha-common

Server configuration

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

Here I change the port number of Koha staff client to 8000. Find the following line in the file and make changes.

INTRAPORT="8000"

Install MySQL server

sudo apt-get install mysql-server

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

Add new port

Open the following file and add a new port.

sudo nano /etc/apache2/ports.conf

Copy paste following line below Listen 80

Listen 8000

Restart Apache,

sudo service apache2 restart

Enable modules and sites

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

Generate Koha Interface Login Password.

sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/library/koha-conf.xml

It will generate the password at terminal. Just copy or even password you can locate at  /etc/koha/sites/library/koha-conf.xml

Restart Memcached

sudo service memcached restart


Now, Koha has been installed successfully.

Open the browser and type the following:

For Koha Staff Interface: http://localhost:8000
For Koha OPAC : http://localhost


Thanks
For more details, watch video at www.youtube.com/c/librarianguide

How to Upgrade Koha

Open terminal (Ctrl + Alt + t)

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install koha-common

wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add -

sudo apt-get clean 

Upgrade Database Schema

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

sudo koha-upgrade-schema library

Rebuild the Zebra Index.

Apply following command in a terminal,

sudo koha-rebuild-zebra -v -f library

Koha Backup and Restore (koha 3.22 to koha 18.11)

Move old Koha database to new installation

1. Backup of old Koha

Take the 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 the backup,

sudo su

mysqldump -uroot -p koha_library | xz > koha_library.sql.xz

Put MySQL root password, when it asks.

2. Install Koha

Follow the instructions in Koha wiki

3. Restoration of old Koha database to a new one

Remove the existing database in the new Koha installation

sudo su

mysql -uroot -p 

[Enter the MySQL Root password]

drop database koha_library;

create database koha_library;

quit;

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 the new Koha installation.

Database Restoration commands,

sudo su

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

exit

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 match with the new version. Apply following commands in a terminal one by one,

sudo service memcached restart

sudo koha-upgrade-schema library

5. Rebuild the Zebra Index.

Apply following command in a terminal,

sudo koha-rebuild-zebra -v -f library

………………………… END…………………

How to upload local cover book image

> Koha tools

> click on Upload local cover image

> click on browse

> select the file and

> click on upload file

> select image file

> enter cover biblio number

> click on process images

> go to koha administration > global System preferences > Enhanced Content

> Local Cover Images > AllowMultipleCovers [allow]

            > LocalCoverImages [Display]

            > OPACLocalCoverImages [display]

> Save all opac preferences

How to change Koha Opac Header Image (banner)

> Create your banner and

> Login as Root User in Ubuntu

> save it as koha_banner.jpg in /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/images

> Open Koha and go to System Preferences >OPAC >opacheader >click to edit

> copy the below code and paste it in opacheader area and click on Save all opac preferences.

......................................................................end.......................................................