How to configure In-Out management plugin in koha

The in-out management system is a web-based application used to track the library users who visit the library or a particular location in the library. It will scan the barcode from the ID card and record the entry time and exit time of the user. The data of the user will be fetched from the KOHA database along with the images and displayed on this system.

Software Required: 

•  PHP
•  Apache 
•  MySQL/MariaDB 

In the above software, Apache and MySQL are already installed with the koha, here we need to install PHP on the server.

PHP Installation

Open the terminal and execute the following commands in order to install PHP and related packages

sudo su

sudo apt-get update

sudo apt-get install -y git php libapache2-mod-php php-{bcmath,bz2,intl,gd,mbstring,mysql,zip}

In-out Package installation

Download Stable Version 5.2 of the package from the Release Panel in the koha htdocs directory

cd /usr/share/koha/opac/htdocs

wget https://github.com/omkar2403/inout/archive/refs/tags/V5.2.zip

Unzip the file

unzip V5.2.zip

Change the name of the directory

 mv inout-5.2 inout

Now remove the zip file as it is not required

rm V5.2.zip

Change the permission for inout directory

sudo chmod 777 -R inout

Database setup

Create a database 

mysql -uroot -p

(Enter MySQL Root password)

Apply the following commands to create a database and grant permissions to the database

create database inoutsystem;

grant all privileges on inoutsystem.* to 'root'@'localhost' identified by 'admin@123';

Where:-
1.'' inoutsystem'' is the name of the database
2. ''root'' is the username of the MySQL database, it is usually root unless you changed it
3. ''admin@123'' is the password for the MySQL database

(Replace the above credentials with yours)

Flush privileges

flush privileges;

Exit from MySQL 

quit;

Now run the following commands to restore the sample database in the created database from the DB directory 

cd inout/DB

mysql -uroot -p inoutsystem < inout.sql

(Enter MySQL Root password e.g. admin@123)   

Now replace your database name, username, and password in the 'dbconn.php' file

sudo gedit /usr/share/koha/opac/htdocs/inout/functions/dbconn.php

Restart Apache

sudo systemctl restart apache2

inout plugin has been installed on your server and is ready to use. Locate the following URL in the browser to access the plugin

http://localhost/inout/login.php

Log in the with following default credentials to further settings and add the account for the administrator and users.

Username:  master

Password:   superuser

Location:    master

Note:- If you have changed the default port number for OPAC then you need to add the port number with the localhost while accessing the inout system e.g.  http://localhost:8000/inout/login.php

 

Backup of In-Out management database

Reference:-https://github.com/omkar2403/inout/