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.......................................................

How to enable root login in linux ubuntu 18.04 in graphical user interface

> go to terminal

> Type: [sudo passwd root] and press enter

> give your existing password and press enter

> type new password for root user

> retype new password for confirmation

> type: [sudo apt update] and press enter

> type: [sudo apt install lightdm]

> type: [cd /etc/lightdm/]

> type: [sudo nano lightdm.conf] when you press enter an editor will open then

> type below commands in the editor:

[SeatDefaults]

greeter-session=unity-greeter

user-session=ubuntu

greeter-show-manual-login=true

> Press ctrl + s to save and then press ctrl + x to close the editor

> type: [sudo reboot]

Root login created

Koha 18.11 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: follow the instruction given below

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 have 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

Koha Patrons Bulk Import

https://youtu.be/QmkHuPUpIQI