Installing Let’s Encrypt on Debian 11

In order to install Let’s Encrypt, we first need to install the Certbot tool. Run the following command to install the package: sudo apt -y ...

Using MySQL String Functions

MySQL can do much more than just store and retrieve data. We can also perform manipulations on the data before retrieving or saving it. That...

Creating a CRUD Web Application for Dissertation Catalog

In this post, I show how to create a CRUD application using Google Web App and Google Sheets for our (library) purpose. I was thinking of ha...

Few Branch-wise Reports (SQL) in Koha

Currently, I am working in a library which uses a single koha for various libraries. So, in course of time, I needed various reports specifi...

Using Koha as a Mini Digital Repository

Yes, of course, koha can be used as a mini digital repository, where you can upload any digital contents like question papers, PPTs, study m...

Configure Email in Koha using In-built SMTP Module

Configuring email in koha was a back-breaking task as far as the normal professionals are concerned, as It requires Linux command line knowl...

Install LAMP Stack on Debian 11 (Bullseye)

PC: www.geekboots.com Step 1: Update Debian 11 (Bullseye) As always it is recommended to keep the repository and packages up to date. Run th...

Setting up Apache as Reverse Proxy for Tomcat Server

This blog post will help you to set up an Apache web server as Reverse Proxy for the Tomcat hosted applications. Setup Scenario I have insta...

Install Crater Invoice App on Debian/Ubuntu

The crater is an open-source self-hosted invoicing application based on the Laravel PHP framework targeting individual users or small and me...

Enabling Automatic Updates on Debian/Ubuntu

Manually updating packages on Debian/Ubuntu may a tedious task and waste a lot of our time. This is time that could have been spent elsewher...

Using Google Drive create an Image Gallery for Koha's OPAC

Lets us see how we can create a separate page for image gallery in our koha's OPAC using Google Drive as image hosting, The advantage is...

Install PHP 8 on Debian 11

By default, PHP 8.0 is not included in the Debian 11 default repository. So you will need to add the PHP Sury repository to your server. Fir...

Accessing DSpace with a Subdomain

In this blog post, we learn how to map DSpace digital repository installed on a VPS/cloud server with a subdomain creating  VirtualHost  in ...

Create Library Membership Card using gLabels Software

GLabels is a free software tool to generate labels/barcodes for various purposes. GLabels can be used for creating library membership cards ...

Accession Register Report by Branch

Koha version: 20.11.09 Module: Catalogue Purpose: Getting details of all books under a specific branch library SELECT  items.barcode,items.i...

Using Ngrok remotely access Koha OPAC

Ngrok is a tunneling tool that can make localhost accessible on the internet, it's a good way to test our local web app. This is being m...