Hardware:
A computer system with a widescreen monitor
Automatic barcode scanner
Installation:
PHP Installation: for Debian 10 & Ubuntu 20.04 LTS
Open a terminal and enter the following commands.
sudo apt-get install -y git php libapache2-mod-php php-{bcmath,bz2,intl,gd,mbstring,mysql,zip,cli,fpm,opcache,xml,curl,intl,xsl,soap,json}
cd /usr/share/koha/opac/htdocs
sudo git clone https://github.com/omkar2403/inout.git
sudo chmod 777 -R inout
Setup the database:
Go to MySQL shell and create a database, user, and password for inout
sudo su
mysql -uroot -p
[Enter MySQL Root password]
CREATE database libinout;
CREATE USER 'libinout'@'localhost' IDENTIFIED BY 'libinout123';
GRANT ALL PRIVILEGES ON *.* TO 'libinout'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit;
In the above syntax 'libinout' is the database, ‘libinout’ is the database username and ‘libinout123’ is the database password. Make sure you replace it with your credentials. Now restore the sample database which is present in the ‘inout/DB’ directory.
Run the following command in terminal
sudo su
mysql -uroot -p libinout < /usr/share/koha/opac/htdocs/inout/DB/inout.sql
[Enter MySQL Root password eg: mysqlroot]
Replace your database name, database username, and database password in the file dbconn.php located in ‘inout’ directory at line number 3 and change connection details
sudo gedit /usr/share/koha/opac/htdocs/inout/functions/dbconn.php
Restart Apache
sudo systemctl reload apache2
sudo systemctl restart apache2
The system is ready now.
You can access it at the address given below:
NB: If it results with 404 Error Page not Found, Please do the following
Check inout directory
This system should be installed in /usr/share/koha/opac/htdocs/ directory.
Check Port Number
Many libraries change their default port number for OPAC.
Backing up libinout database
sudo su
mysqldump -ulibinout -plibinout123 libinout | xz > libinout-$(date +%d-%m-%Y-%H.%M).sql.xz
Fix characters Length
Card numbers with more than 11 characters may not work with inout, that can be fixed,
Go to MySQL shell
sudo mysql -uroot -p
USE libinout;
ALTER TABLE 'inout' CHANGE 'cardnumber' 'cardnumber' VARCHAR(50);
.png)
.png)
Comments
Post a Comment