Tuesday, 1 October 2019

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/


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

 

 

 

 

Language Searching

 Inorder to enable regional language searching the following file need to be modofied.
 

sudo gedit /etc/koha/zebradb/etc/default.idx

comment the line "charmap word-phrase-utf.chr" ( Put # mark at the beginning of the line) 

add the following line after the commented line

"icuchain words-icu.xml "

Rebuild the Zebra index

sudo koha-rebuild-zebra -v -f library 

Saturday, 27 July 2019

photo-Bulk import


1. Arrange your photos in a folder. Ensure that photo name must be card number of patrons.
2. Goto the following link and click on Download button.
https://docs.google.com/file/d/0B6E3iEzJp74uWWI4V3BwdUppdk0/edit?usp=sharing


3. Put idlink.py script in photo folder.

4. Open a terminal and enter inside photo folder and apply following commands,

chmod +x idlink.py
./idlink.py

5. After the process, you can see zip file, where all your photos compressed.

Goto Koha > Tools > Upload Patron Images

Upload the zip file.
 
Note:
 
1. In ubuntu 20.04 LTS an error will show
     i.e usr/bin/env pyhton3 
 
      to eliminate the error, use the following command in terminal

        sudo ln -s /usr/bin/python3 /usr/bin/python
 2. There is an error message in idlink.py script will show

an error in line 10 did you mean print (s)
Solution: open the idlink.py using text editor and change the line 10 as print (s) instead of print s
 
 Note : 2
If the folder is unable to upload. extract the created file and the copy all the contents to a new folder and zip this folder and then upload. Then it is possible to upload

 

Friday, 22 February 2019

e-mail facility in koha

Apply following commands one-by-one in the terminal
1. sudo su
2. apt-get update

3. apt-get install postfix
    ( press 'OK' when asks in package configuration and for general type of mail configuration "no configuration" then OK)
  
4.cp /usr/share/postfix/main.cf.debian /etc/postfix/main.cf

5.apt-get install libsasl2-2

6. apt-get install libsasl2-modules

7. apt-get install ca-certificates

8. gedit /etc/postfix/main.cf

pleasse add the following lines at the bottom of the file.

relayhost = [smtp.gmail.com]:587
smtp_sasl_auth_enable = yes
smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd
smtp_sasl_security_options = noanonymous
smtp_tls_CAfile = /etc/postfix/cacert.pem
smtp_use_tls = yes
 
 
 9. gedit /etc/postfix/sasl_passwd

[smtp.gmail.com]:587    urgmailid@gmail.com:yourpassword #replace with your gmail id and password

10.chmod 400 /etc/postfix/sasl_passwd

11. postmap /etc/postfix/sasl_passwd

12. postalias hash:/etc/aliases

13 cat /etc/ssl/certs/thawte_Primary_Root_CA.pem >> /etc/postfix/cacert.pem

14 /etc/init.d/postfix restart

15 koha-email-enable library