Category: Ubuntu

13/02/2021

How to Install Koha on Ubuntu 20.04 LTS | Install Koha on Ubuntu (with easy steps)

You can easily install Koha on Ubuntu Operating system using below process. In this process we will install latest stable version of Koha on Ubuntu. Open Terminal in your Ubuntu machine for Koha Installation. Update Ubuntu OS using below commands: sudo su apt-get update apt-get upgrade Install Leafpad Text Editor apt-get install leafpad Add Koha Community Repository & Trusted Repository Key sudo echo deb http://debian.koha-community.org/koha […]

27/08/2020

Koha Reports – Tested with Koha 20.05

Koha Reports: You can easily add customized reports in your Koha Software. Accession Register (Complete List of Books-Sorted by Barcode) SELECT CONCAT(‘<a href=”/cgi-bin/koha/catalogue/detail.pl?biblionumber=’, biblio.biblionumber,'”>’,biblio.biblionumber,'</a>’) AS biblionumbers, items.barcode, 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 LPAD (items.barcode,40,’ ‘) ASC Detailed Accession Register Report SELECT oo.dateaccessioned AS ‘Date’, oo.barcode AS ‘Acc. No./Barcode’, […]

22/05/2020

How to Install Java, Tomcat, MySQL, phpMyAdmin on Ubuntu 20.04 in GCP/AWS Intance

Before you deploy any Web Application on your Ubuntu Server, You have to install Java , Tomcat Server, MySql Database, phpMyAdmin etc. First of all open Terminal on GCP Ubuntu Instance OR connect your AWS Ubuntu Instance in Putty Software through SSH. Login as root and update > sudo su > apt-get update Install JAVA (OpenJDK) Run below command to install OpenJDK 11 > sudo […]

06/02/2020

Koha Auto Increment Fix | How to fix Koha Auto Increment Problem

Follow these steps to apply the solution for the “library” instance for Koha Auto Increment Fix: sudo gedit /etc/mysql/my.cnf Locate the [mysqld] section and add: init-file=/var/lib/mysql/init-file_koha_fix.sql sudo gedit /var/lib/mysql/init-file_koha_fix.sql Copy following code and paste into “init-file_koha_fix.sql” file. USE koha_library;   SET @new_AI_borrowers = ( SELECT GREATEST( IFNULL( ( SELECT MAX(borrowernumber) FROM borrowers ), 0 ), IFNULL( ( SELECT MAX(borrowernumber) FROM deletedborrowers ), 0 ) ) + […]

23/01/2020

Install Anydesk on Ubuntu | Install Teamviewer on Ubuntu 16.04/18.04/20.04

Install Anydesk on Ubuntu Run the following commands as root user: wget -qO – https://keys.anydesk.com/repos/DEB-GPG-KEY | apt-key add – echo “deb http://deb.anydesk.com/ all main” > /etc/apt/sources.list.d/anydesk-stable.list apt update apt install anydesk Install TeamViewer 0n Ubuntu Run the following commands as root user: ### 64-bit systems wget https://download.teamviewer.com/download/linux/teamviewer_amd64.deb ### 32-bit systems wget https://download.teamviewer.com/download/linux/teamviewer_i386.deb sudo dpkg -i teamviewer_amd64.deb sudo apt-get -f install teamviewer References: How to Install TeamViewer 13 on Linux […]

04/12/2019

Install Koha Software on Ubuntu 16.04 & 18.04 LTS

Open Terminal and get ready for installation Update Ubuntu sudo su  apt-get update apt-get upgrade Install Leafpad text editor apt-get install leafpad Add Koha community repository 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 Koha sudo apt install koha-common Server Configuration In this step, need to edit network […]

18/03/2019

Koha Backup | How to Setup Automatic Backup in Koha

Create Shell Script for Daily Koha Backup If you want to setup Automatic Koha Backup, Follow the below process. Create directory for backup> mkdir koha_backupAllow write permission to this folder> sudo chmod 777 koha_backup(Exit from root directory)Create a file> sudo gedit koha_backup/backup.shCopy below text into file and save it. #!/bin/bashmysqldump -u[username] -p[password] koha_library | xz > koha_backup/koha_library-$(date +%d-%m-%Y-%H.%M).sql.xz (Change [username] & [password] as per your Koha Database Credentials) […]

16/03/2019

Koha Data Migration | Import Marc file into Koha using Terminal

Koha Data Migration is very time consuming process, So you can import you Bibliographic Data into Koha Software by using Terminal Commands In the process of Koha Data Migration, You can import .mrc file into koha directly using Terminal commands. Follow the steps below and run commands one by one carefully: sudo su export PERL5LIB=”/usr/share/koha/lib” export KOHA_CONF=”/etc/koha/sites/library/koha-conf.xml” Next, Move your .mrc file into folder where […]

16/03/2019

Install phpMyAdmin on Ubuntu

After installing MySql/MariaDB Database Server, You can easily install phpMyAdmin on Ubuntu Machine.Follow the steps below:1. Update the package index and upgrade the system packages to the latest versions:     > sudo apt update     > sudo apt upgrade  (optional)2. Install the phpMyAdmin package     > sudo apt install phpmyadmin3. Choose apache2 by pressing Space Key and then Enter on Keyboard, when a popup screen appears.4. Next, you will be asked […]