Tuesday, 9 May 2023

Install Koha on Ubuntu (Linux)

 Install Ubuntu 22.04 and update

Koha can install various Ubuntu flavours like Xubuntu/Lubuntu. Xubuntu and Lubuntu are lightweight (fast-performance) Ubuntu flavours. Download the Linux iso file from either Xubuntu/Lubuntu from websites. Burn in a DVD or pen drive/DVD. Install the Linux operating system. 

Open the Terminal and get ready for installation
Open Applications > System Tools > Terminal and apply the commands one by one mentioned on this page.


Update Ubuntu
This process will update the Linux operating system latest by downloading new packages.

sudo apt update
sudo apt upgrade

Install Mousepad text editor

The mousepad is a lightweight text editor, which requires opening configuration files during the installation process of Koha.

sudo apt -y install mousepad

Add Koha community repository

Add Koha software channel into Ubuntu. Here we add the old stable version of Koha. We can define which version to install when adding the repository. Visit the Koha Wiki for details. Apply the following two commands one by one:

echo deb http://debian.koha-community.org/koha oldstable 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 update

Install MariaDB server


sudo apt install -y mariadb-server

Assign Root password for MariaDB

If the password asks during installation, enter the password in the window. Apply the following command, if the password window did not appear during the installation,

sudo mysqladmin -u root password newpassword       [Replace 'newpassword']

Install Koha

The following command will install the latest release of Koha.

sudo apt install -y koha-common

Server configuration

In this step, need to edit network information like domain name and port numbers.

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

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

INTRAPORT="8080"


Koha instance creation

Apply the 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

We have assigned 8080 port for the Koha staff client and 80 for OPAC.
Open the following file and add a new port.

sudo mousepad /etc/apache2/ports.conf

Copy-paste following line below Listen 80

Listen 8080

Restart Apache,

sudo service apache2 restart


Enable modules and sites

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


Setup the library

After the successful installation, you need to create initial parameters (e.g. branch, item type, superuser creation etc.) to start with Koha. We need to open the web interface of Koha and start the configuration of Koha to start.
Restart the Memcached service to open Koha web installer.

sudo service memcached restart

Open the following link in the web browser to open the staff client of Koha and set up the library,

http://127.0.1.1:8080 

Enter into the Koha staff client using the Database username and password of koha_library. It can find from the file, /etc/koha/sites/library/koha-conf.xml. Apply the following file in a terminal.

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

Search (Ctrl+F) for the segment MySQL in the text editor. Note down the database username and password and log into Koha web installer.

Change Koha default master password (Optional)

The password for the Koha database name was created during the installation process. The user can change the Koha database password. 

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



Sunday, 3 January 2016

Allocation of duties and responsibilities that are given to me in NIELIT Jorhat EC from 1st Jan, 2016  are:
1. Library work and maintenance;
2. Stock maintenance and issuing;
3. Maintenance physical asset register;
4. House keeping;
5. Any other duty as and when assigned.

Today I am preparing stock requirement sheet form Jan to March, 2016.

Tuesday, 22 December 2015

Cataloguing has been done yesterday in Koha: 1130 books (67 title)

Thursday, 17 December 2015

I have Installed KOHA 3.16 version in my library on 14th Dec, 2015.. and now I have updated it to Version 3.20.06.000, and its working nicely.

Wednesday, 16 December 2015

Today I have started classification with the help of (http://classify.oclc.org/classify2/).. most of the titles are available here...
Stock verification started today

Monday, 14 December 2015

About NIELIT Jorhat EC

In April’2012, the union cabinet has approved a project of the Dept. of Electronics & Information Tecnology (DeitY), Govt. of India, “Development of the North Eastern Region by enhancing Training/ Education capacity in the IECT Area”.Under which 6 (six) existing NIELITs of the NE region located at Imphal, Aizawl, Guwahati, Shillong, Gangtok, Itanagar were to be upgraded as NIELITs with own campus and also create/upgrade 12 (twelve) Extensions Centres in the entire NE region in order to increase training capacity of the NIELITs in the NE region from existing 3,080 to 14,400 per annum at the end of 5(five) years. Of the 12 (twelve) Extension Centres, 5 (five) were to be commissioned in Assam at locations Tezpur, Jorhat, Dibrugarh, Kokrajhar and Silchar under NIELIT Guwahati. As a consequence, the National Institute of Electronics & Information Technology (NIELIT) Jorhat Extension Centre is  one of the presently prevailed four extension Centres of NIELIT  Guwahati(formerly DOEACC Society),which is an autonomous scientific society under the Deptt. of Electronics & Information Technology (DeitY), Ministry of Communications and Information Technology, Govt. of India. 
The NIELIT Jorhat Extension Centre was established and is operational since August’2013 in rented premise located at 1st Floor of ISBT in the Knowledge City Jorhat of Assam ,which is also cultural hub of Assam. NIELIT Jorhat Extension Centre whose mandate is to  provide up-to-date industry relevant training programs in the areas of Information, Electronics and Communication Technology (IECT) in the non-formal sector, will start operating from it’s own permanent campus in land provided by the Govt. of Assam in Roroia,Jorhat in near future.With state-of-the-art infrastructure and equipments, Jorhat Extension Centre of NIELIT-Guwahati is one of the most renowned training centres in the whole of upper Assam.

 Courses Offered at NIELIT Guwahati Jorhat EC
(A) Long Term Courses (Minimum 1 year duration)

Sl NoName of the Course
01Software IT 'O' Level
02Software IT 'A' Level
03CHM 'O' level (Hardware)
04CHM 'A' level (Hardware)

(B) Short Term Courses (2-3 months duration)

Sl NoName of the Course
01Certificate Course in Soft Skills & Communicative English
02ITes-BPO (Customer Care)
03CCC (Course on Computer Concepts)
04BCC (Basic Computer Course)
05Certificate Course in Financial Accounting using Tally
06Certificate Course in PC Hardware and Networking
07Certificate Course in Programming through C Language
08Certificate Course in Core Java
09Certificate Course in Desktop Publishing
10Certificate Course in Web Designing
11Certificate Course in Office Automation
About NIELIT Library Jorhat EC

The library has a good collection of 1130 books, the library also subscribes magazines and daily newspapers. The library has 9 number of book shelves along with 3 almirahs, 2 numbers of study table with 10 numbers of chairs for students and staff members and one computer is for assistant librarian. Mr. Anupam Chanda is the Assistant Librarian of this library, he is the one and only library staff in this library who manages all the activities related to this library. On 14 December, 2015 he has installed KOHA (Version 3.16.05.001) Library Management Software in this library, and now its working on LAN also. At present this software is installed just for experimental purpose.