INOUT MANAGEMENT SYSTEM

Installation:
PHP Installation: (Optional)
Open a terminal and enter following commands.

sudo apt-get update
sudo apt install -y php libapache2-mod-php php-{bcmath,bz2,intl,gd,mbstring,mysql,zip,cli,fpm,opcache,xml,curl,intl,xsl,soap,json,apcu,imap}

 

 Php7.4 installation

php -v
  sudo apt -y install software-properties-common
 sudo add-apt-repository ppa:ondrej/php
  sudo apt-get update
 sudo apt -y install php7.4
  sudo apt-get install -y php7.4-cli php7.4-json php7.4-common php7.4-mysql php7.4-zip php7.4-gd php7.4-mbstring php7.4-curl php7.4-xml php7.4-bcmath
 2004  history

 

 

Download the latest version of in out management system.

https://github.com/omkar2403/inout/releases/

Rename inout*.* directory as inout

Now we have to copy the inout directory into OPAC htdocs directory. Open the terminal into
Home directory and apply the following commands.

sudo su
sudo mv /home/inout /usr/share/koha/opac/htdocs
cd /usr/share/koha/opac/htdocs
chmod 777 -R inout

Setup the database:
Open the terminal and apply the following commands.
sudo su
mysql -uroot -p   [Enter MySQL Root password]
create database lib;
grant all privileges on lib.* to 'root'@'localhost' identified by 'kohalib';
flush privileges;

Quit;

Replace your password in the file dbconn.php located in ‘inout’ directory at the line number 3.

 

copy the database inout.sql (/inout/DB/inout.sql) to the lib.sql 

 

Sudo mysql -uroot -p lib < usr/share/koha/opac/htdocs/inout/DB/inout.sql

sudo systemctl reload apache2 && sudo systemctl restart apache2

 

Access the Gate register

http://{opac url}/inout

 

First Login as username: master Password: superuser 

 

Choose the option setup and Enter Library name, Closing time Submit

Then add location and submit

Next is to setup user account

give username and password of user account

Database connection error

Not connected: Access denied for user 'root'@'localhost' (using password: YES)

Cause

This is issue occurring because of user restriction for root.

Solution

There are two solutions. One is modify root user (Which is risky) and second is to create new user.

I'm giving solution 2 that is how to create a new user for inout system.

Please follow the instructions

Open Terminal

sudo su

[Enter Password]

mysql -uroot -p

[Enter Mysql Password]

CREATE USER 'inout'@'%' IDENTIFIED BY 'password_here';

Replace password_here with your own password

GRANT ALL PRIVILEGES ON *.* TO 'inout'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

quit;

And thats it. Now exit from sudo mode by entering Exit command.

Test your user by entering following command.

mysql -uinout -p

[Enter Password for Inout User mentioned above]

Note: Now edit dbconn.php in inout directory. Replace the username to inout and password to respected password.

 

Update Your College Institution Logo on Display Screen

There are two logos by default on the left & the right side of the display interface. If you want to update your own logo follow the steps.

Note : Logo should be in square size.

Rename the logo file as "logo.jpg" (Left Side Logo) .

Rename the 2nd logo file as "iso.png" (Right Side Logo)

Copy both the files in to "inout/img/" location. (Replace the existing files)

Open the index.php file in any editor.

Uncomment the code the line number "from 23 to 25" and "from 31 to 33" which is looks like as follows.

23 <!-- <div class="col-xs-2 col-md-2 col-lg-2">

24 <img src="img/logo.jpg" height="125" width="125">

25 </div> -->

31 <!-- <div class="col-xs-2 col-md-2 col-lg-2" >

32 <img src="img/iso.png" style="float:right;" height="125" width="125">

33 </div> -->

Now replace the below line on the line number 26.

<div class="col-xs-8 col-md-8 col-lg-8 text-center main_title" >

All set. Refresh your interface.

 

Logout After 20 Minute Issue

You have to change default session time in php.ini file.

To Open the file.

sudo nano /etc/php/5.6/apache2/php.ini

[Enter password]

A text editor will open. To find variable session.gc_maxlifetime Press Ctrl + W and paste this variable then press ENTER.

It'll find the session.gc_maxlifetime.In front of that the default value is 1440 second that is 24 Minutes.

Change this value to 7200 that is 2 hours.

After changing values Press Ctrl + O then ENTER. It'll save the file. Then exit by Pressing Ctrl + X.

 

PDF is not working on some systems

In the LAN pdf generator is not working. PDF generator are using the directory "cache" present in the "inout" directory. This directory should have full access/permission. Follow the steps to give permission.

Open terminal in inout directory and type following commands.

sudo su

[Enter Password]

chmod 765 -R cache

chmod 777 pdfexport.php

exit