KOHA INSTALLATION ON UBUNTU 22.04

   $sudo apt-get update
   $sudo apt-get upgrade
   $sudo su
 

 1   sudo sh -c 'wget -qO - https://debian.koha-community.org/koha/gpg.asc | gpg --dearmor -o /usr/share/keyrings/koha-keyring.gpg'  

 

2  sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/koha-keyring.gpg] https://debian.koha-community.org/koha oldstable main" >> /etc/apt/sources.list.d/koha.list'

 

    3  sudo apt-get update
    4  sudo apt install koha-common
    5  sudo gedit /etc/koha/koha-sites.conf
    6  sudo apt install mariadb-server
 

   

sudo apt update

sudo apt install mariadb-server}

    7  sudo mysqladmin -u root password kohalib
    8  sudo a2enmod rewrite
    9  sudo a2enmod cgi
   10  sudo service apache2 restart
   11  sudo koha-create --create-db library
   12  sudo gedit /etc/apache2/ports.conf
   13  sudo service apache2 restart
   14  sudo a2dissite 000-default
   15  sudo a2enmod deflate
   16  sudo a2ensite library
   17  sudo service apache2 restart


open the web browser and type http://localhost:8000

koha web installer will appears and prompt for username and password

please change the username by editing koha-conf.xml file

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

ubder config section find out the line password and change it

<config>
 <db_scheme>mysql</db_scheme>
 <database>koha_library</database>
 <hostname>localhost</hostname>
 <port>3306</port>
 <user>koha_library</user>
 <pass>kohalib</pass>

then change mysql privileges

sudo mysql -uroot -p  

[enter the MySQL Root password]

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

restart apache2 and mysql 
sudo /etc/init.d/apache2 restart
sudo /etc/init.d/mysql restart 


Note: In case of perl dependencies missing reported use the following commands before installation of koha -common command

 

sudo apt-get install libmarc-record-perl
sudo apt-get install libxml-sax-perl
wget http://ftp.br.debian.org/debian/pool/main/libm/libmarc-charset-perl/libmarc-charset-perl_1.35-2_amd64.deb
wget http://ftp.br.debian.org/debian/pool/main/libm/libmarc-xml-perl/libmarc-xml-perl_1.0.3-1_all.deb
sudo dpkg -i libmarc-charset-perl_1.35-2_amd64.deb libmarc-xml-perl_1.0.3-1_all.deb
sudo apt-get install koha-common

FRAMEWORK FOR BOOKS

PLEASE USE THIS FRAMEWORK FOR BOOKS

MARCEDIT INSTALLATION ON UBUNTU

To use the marcedit in ubuntu, please follow the steps furnished below.

1. Download the marcedit from the following link
   https://marcedit.reeset.net/software/marcedit.bin.zip
2. Extract the downloaded file. (The extracted "marcedit" folder  may be copied to the home folder for convenience.)
3. Install mono frame work
    $sudo apt-get install mono-devel
    $sudo apt-get install mono-xsp4
 If you found the error "key is not found", please add the key as in the link below
https://www.mono-project.com/download/stable/

4. Open the terminal. change the directory to marcedit
     (eg:  cd marcedit/)
5. type "mono MarcEdit.exe" in terminal and the marcedit screen will appear
     (koha@ubuntu:~/marcedit$ mono MarcEdit.exe)
  

gLabel Barcode

This template can be used to print the barcode for normal use in the library. please change the library name. glabel for kcaet

KCAET LIBRARY-THESIS

Please click here to read the soft copy of theses of the KCAET Library. This site is under construction. please fill up the form to get the copy of the thesis which are not uploaded

phpmyadmin

Installation of phpmyadmin on Ubuntu 16.04LTS

phpMyAdmin is a free, open source web-based database management tool written using PHP programming language. It allows the database administrators to manage single or multiple database servers either from a local or remote system using a web browser. Using phpMyAdmin, we can create, delete, rename, edit databases, tables, fields, and also we can directly execute any SQL commands.

1. Open the terminal and type the following commands one by one

$sudo apt-get update
$sudo apt-get install phpmyadmin
      During the installation a box will appear to choose the web server that should be automatically configured to run phpmyadmin. Choose apache2 and click OK.

Again it will ask for the password for phpmyadmin. Enter the password and re-enter it again to confirm.

2. To get the phpmyadmin in web browser, please edit the following file.

$sudo gedit /etc/apache2/apache2.conf

Add the following line at the end

    Include /etc/phpmyadmin/apache.conf

3. Open the web browser and type

     http://localhost/phpmyadmin

Stock taking using excel

Stock taking in library is a time consuming process. Here is a simple way for carry out stock verification in the libraries where Koha ILMS is using.

1.  Run the Accession Register report in koha

   SQL Query for Accession Register report. Copy the following text and paste in the SQL report box in koha

 SELECT items.barcode,items.dateaccessioned,items.itemcallnumber,biblioitems.isbn,biblio.author,biblio.title,biblioitems.pages,biblioitems.publishercode,biblioitems.place,biblio.copyrightdate,items.price
FROM items
LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
ORDER BY items.barcode ASC

2. Download the report and save the file in excel compatible format. i.e  (.xlsx)

3. Copy the accession numbers taken during the stock verification in a different sheet of the same excel file of koha accession register report.

4. Rename the sheet2 of excel file as "sub" and sheet1 as "Main".

5. Go to sheet1 and insert a blank column just right to the column of  Accession number

6. Apply the following formula in second row of the column and drag the mouse to the end of the column

                         =VLOOKUP(A1,$sub.A:A,1,0) 

7. Now the blank column show appropriate missing numbers

Note: Make sure that the number in stored as 'numeric' in both koha report and value entered during stock verification