Koha - my learnings

Wednesday, July 5, 2017

Email - Message Templates

In general, from the Library 5 auto generated emails are sent to every borrower as per the due date of the books/documents issued. Depends on the circulation policies and rules, you could further change the templates as per your Library requirements.

1) Book Check-Out (Issue) Message

--------------------------------------------------------------------

Dear <<borrowers.firstname>> <<borrowers.surname>>,

The following book is checked out (Issued) from the library for your card number: <<borrowers.cardnumber>>

Accession No: <<items.barcode>>

Call No: <<items.itemcallnumber>>

Title: <<biblio.title>>

Author: <<biblio.author>>

Check Out on: <<issues.issuedate>>

Due Date: <<issues.date_due>>

This email is system generated. Please do not reply to this mail.

Library and Informaiton Centre,

Your Library Name

====================================================================

2) Book Check-in (Return) Message

--------------------------------------------------

Dear <<borrowers.firstname>> <<borrowers.surname>>,

The following book is returned (check-in) to the library for your card number : <<borrowers.cardnumber>>

Accession No: <<items.barcode>>

Call No: <<items.itemcallnumber>>

Title: <<biblio.title>>

Author: <<biblio.author>>

Borrowed On : <<items.datelastborrowed>>

Library and Informaiton Centre,

Your Library Name

====================================================================

3) Pre-Due Reminder ( Before Due Date)

--------------------------------------

Dear <<borrowers.firstname>> <<borrowers.surname>>,

The following book will be due soon for your card number <<borrowers.cardnumber>> :

Accession No: <<items.barcode>> - <<biblio.title>>, by <<biblio.author>>

Due Date: <<issues.date_due>>

Please return or renew them before due date.

Library and Informaiton Centre,

Your Library Name

Please do not reply to this notification as it was automatically generated.

If you have any question regarding this notification, please contact Librarian

=====================================================================

4) Due Reminder (After Due Date)

-------------------------------------

Dear <<borrowers.firstname>> <<borrowers.surname>> CARD NUMBER <<borrowers.cardnumber>>,

According to our current records, you have following book(s) that is/are overdue. Please return or renew them at the Circulation section as soon as possible.

Title: <<biblio.title>>, by <<biblio.author>>

Accession No: <<items.barcode>>

Check out (Borrowed) date: <<issues.issuedate>>

Due Date: <<issues.date_due>>

Library and Information Centre,

Govt.Engineering College,Hassan

Please do not reply to this notification as it was automatically generated.

If you have any question regarding this notification, please contact Librarian.

======================================================================

5) Over Due (Final and Last Reminder)

Dear <<borrowers.firstname>> <<borrowers.surname>>,

According to our Library records, you have books pending/overdue for your card number : <<borrowers.cardnumber>> . Please return or renew them as soon as possible.

There are two auto generated reminder emails has been sent by the system to you regarding library dues. Please refer previous emails with the subject - Item Due Reminder or Advance Notice of Item Due" for finding books details. Please note that, this is the final reminder email.

Note: Faculty Members/staffs are here by informed to return or renew books at the end of each semester (last working day) before going for vacation.

Library and Informaiton Centre,

Your Library Name

Thursday, May 16, 2013

Zebra Service for Koha

How to Start Zebra Service in Linux for Koha

After Installing Koha, you can check from the staff client, in the about koha page, bottom of the page.

root@gechlibrary:/build/koha-3.10.05# /usr/share/koha/bin/koha-zebra-ctl.sh stop
Stopping Zebra Server

root@gechlibrary:/build/koha-3.10.05# /usr/share/koha/bin/koha-zebra-ctl.sh start
Starting Zebra Server

and use ps aux |grep zebra to see the zebra service is on or not.

root@gechlibrary:/build/koha-3.10.05# ps aux |grep zebra
koha     11090 0.0 0.0   3676   548 ?        S    13:12   0:00 daemon --name=koha-zebra-ctl.koha --errlog=/var/log/koha/koha-zebradaemon.err --stdout=/var/log/koha/koha-zebradaemon.log --output=/var/log/koha/koha-zebradaemon-output.log --verbose=1 --respawn --delay=30 --user=koha.koha -- /usr/local/bin/zebrasrv -v none,fatal,warn -f /etc/koha/koha-conf.xml
koha     11091 1.0 0.2 27684 4888 ?        S    13:12   0:00 /usr/local/bin/zebrasrv -v none,fatal,warn -f /etc/koha/koha-conf.xml
root     11093 0.0 0.0   3304   764 pts/1    S+   13:12   0:00 grep zebra

Friday, May 10, 2013

Web Installer Error in Koha

Software error:

Access denied for user 'kohaadmin'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 790.
BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 63.
Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25.
BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 25.

Reason:
'koha' user doesn't have access to the koha database with the credentials supplied. Can you check the user and password you specified in the /etc/koha/koha-conf.xml file? (search for "db_scheme" and you'll see the database details below that)

In the file... /etc/koha/koha-conf.xml, search , what password has been set and compare the same while you creating mysql db and grating all privileges.




<config>
<db_scheme>mysql</db_scheme>
<database>koha</database>
<hostname>localhost</hostname>
<port>3306</port>
<user>kohaadmin</user>
<pass>password</pass> {the password here should match with mysql db user password you entered at the time of grating all privileges}
<biblioserver>biblios</biblioserver>
<biblioservershadow>1</biblioservershadow>
<authorityserver>authorities</authorityserver>
<authorityservershadow>1</authorityservershadow>
<intranetdir>/usr/share/koha/intranet/cgi-bin</intranetdir>
<opacdir>/usr/share/koha/opac/cgi-bin/opac</opacdir>
<opachtdocs>/usr/share/koha/opac/htdocs/opac-tmpl</opachtdocs>
<intrahtdocs>/usr/share/koha/intranet/htdocs/intranet-tmpl</intrahtdocs>
<includes>/usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/</includes>
<logdir>/var/log/koha</logdir>
<backupdir>/var/spool/koha</backupdir>

as a root or dba
#grant all on <kohadatabasename>.* to '<kohadatabaseuser>'@'localhost'
identified by '<mysql-password-for-kohadatabaseuser>'

Now, you should be able to run the web installer.

Patron Image Upload Error in Koha ( GD Perl Module Error)

After spending 3-4 days for searching solutions for fixing the error with GD module used in koha, finally I am successful to upload the patron images in to koha after referring many forums. and am documenting the same here.

I manually installed GD after downloading it from CPAN.
the perl dependencies check was not showing any problem but while uploading patron images I was getting following error:

Can't locate object method "newFromjPeg" via package "GD::Image" at /usr/local/lib/perl/5.10.1/GD/Image.pm line 81.

Reason: ( provided in the various forums)

Building GD perl modules or libgd without jpeg/png support might cause
that error. libgd-gd2-perl ( in ubuntu) which is good enough
and should be used instead of build-it-yourself from cpan.

Steps followed :
Adding the lib path (in specific to Red Hat/Fedora)

1) open /etc/ld.so.conf and add
Include /usr/local/lib
and run

#ldconfig -v
------

2) libgd
+ Downloaded from : https://bitbucket.org/libgd/gd-libgd/downloads
+ mkdir /usr/local/gd
+ ./configure --prefix=/usr/local/gd --with-jpeg=/usr/local/jpeg-6b
+ make
+ make install

or
../configure --enable-shared
make && make install

3) install libpng:

Download at: http://www.ijg.org/files/
make && make install

In detail:
+ mkdir /usr/local/jpeg-6b
+ mkdir /usr/local/jpeg-6b/bin
+ mkdir /usr/local/jpeg-6b/man
+ mkdir /usr/local/jpeg-6b/man/man1
+ mkdir /usr/local/jpeg-6b/incude
+ mkdir /usr/local/jpeg-6b/lib
+ ./configure --prefix=/usr/local/jpeg-6b --enable-shared
+ make
+ make test
+ make install

4) install jpeg libs :

../configure --enable-shared
make && make install

5) install freetype2:
../configure
make && make install

6) png/jpeg packages
search libpng in debian packages.
eg: libpng3_1.2.44-1+squeeze4_all.deb

7) install perl module GD
download GD-2.49.tar.gz from CPAN

LD_LIBRARY_PATH="/usr/local/lib"

export LD_LIBRARY_PATH
perl Makefile.PL
make && make test && make install

In detail:
+ export
LD_LIBRARY_PATH=/usr/local/lib:/usr/local/gd/lib:/usr/local/zlib/lib:/usr/local/jpeg-6b/lib:$LD_LIBRARY_PATH
+ perl Makefile.PL GD_JPEG -lib_gd_path /usr/local/gd -lib_jpeg_path
/usr/local/jpeg-6b -lib_zlib_path /usr/local/zlib

Tuesday, May 7, 2013

Installation of Koha on Debian Squeeze

This documentation was prepared for: installing Koha 3.x.x on Debian.
Add the key in gpg.asc to your APT trusted keys:
wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add -

sudo apt-get update
sudo apt-get install koha

root@gechlibrary:~/Desktop/koha-3.10.05# dpkg --set-selections <install_misc/debian.packages
dselect is a high-level interface for managing the installation and removal of Debian software packages.

Many users find dselect intimidating and new users may prefer to use apt-based user interfaces. 
example: Package: dselect (1.15.8.13) 
----
root@gechlibrary:~# dselect
bash: dselect: command not found
root@gechlibrary:~# apt-get install dselect
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following NEW packages will be installed:
  dselect
0 upgraded, 1 newly installed, 0 to remove and 100 not upgraded.
Need to get 0 B/901 kB of archives.
After this operation, 2,449 kB of additional disk space will be used.
Selecting previously deselected package dselect.
(Reading database ... 116397 files and directories currently installed.)
Unpacking dselect (from .../dselect_1.15.8.12_i386.deb) ...
Processing triggers for man-db ...
Setting up dselect (1.15.8.12) ...
----
root@gechlibrary:~# dselect
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following NEW packages will be installed:
  apache2 apache2-mpm-worker apache2-utils apache2.2-common autopoint binutils cvs daemon gcc gcc-4.4 gettext git libbit-vector-perl libc-dev-bin libc6-dev
  libcarp-clan-perl libclass-accessor-perl libclass-singleton-perl libcommon-sense-perl libconvert-asn1-perl libdate-calc-perl libdate-manip-perl
  libdatetime-locale-perl libdatetime-perl libdatetime-timezone-perl libdbd-mysql-perl libdbi-perl libdigest-hmac-perl libdigest-sha1-perl liberror-perl
  libgcrypt11-dev libgpg-error-dev libgravatar-url-perl libhtml-template-perl libio-multiplex-perl libjson-perl libjson-xs-perl liblist-moreutils-perl
  libmail-sendmail-perl libmysqlclient16 libnet-cidr-perl libnet-daemon-perl libnet-dns-perl libnet-ip-perl libnet-ldap-perl libnet-server-perl
  libparams-validate-perl libplrpc-perl libsub-name-perl libsys-hostname-long-perl libtemplate-plugin-htmltotext-perl libunistring0 libxml-dom-perl libxml-libxml-perl
  libxml-namespacesupport-perl libxml-perl libxml-regexp-perl libxml-sax-expat-perl libxml-sax-perl libxml-simple-perl libxml2-dev libxslt1-dev libyaml-perl
  libyaml-syck-perl linux-libc-dev make manpages-dev mysql-client-5.1 mysql-common mysql-server mysql-server-5.1 mysql-server-core-5.1 rsync
The following packages will be upgraded:
  apache2.2-bin bind9-host bogofilter bogofilter-bdb bogofilter-common cups cups-bsd cups-client cups-common cups-pk-helper cups-ppdc dhcp3-client dhcp3-common
  dnsutils exim4 exim4-base exim4-config exim4-daemon-light ghostscript ghostscript-cups gnupg gpgv host iceweasel isc-dhcp-client isc-dhcp-common libavcodec52
  libavformat52 libavutil49 libbind9-60 libcups2 libcupscgi1 libcupsdriver1 libcupsimage2 libcupsmime1 libcupsppdc1 libcurl3-gnutls libdns69 libexif12 libexpat1
  libgs8 libisc62 libisccc60 libisccfg62 liblwres60 libmozjs2d libnss3-1d libopenjpeg2 libperl5.10 libpostproc51 libproxy0 libsmbclient libssh-4 libssl0.9.8
  libswscale0 libtiff4 libwbclient0 libxml2 libxml2-utils libxslt1.1 linux-base linux-image-2.6.32-5-686 openoffice.org openoffice.org-base openoffice.org-base-core
  openoffice.org-calc openoffice.org-common openoffice.org-core openoffice.org-draw openoffice.org-emailmerge openoffice.org-evolution openoffice.org-filter-binfilter
  openoffice.org-filter-mobiledev openoffice.org-gcj openoffice.org-gnome openoffice.org-gtk openoffice.org-help-en-us openoffice.org-impress
  openoffice.org-java-common openoffice.org-math openoffice.org-officebean openoffice.org-report-builder-bin openoffice.org-style-galaxy openoffice.org-style-tango
  openoffice.org-writer openssl perl perl-base perl-modules python-libxml2 python-uno sudo ttf-opensymbol uno-libs3 ure xserver-common xserver-xephyr
  xserver-xorg-core xsltproc xulrunner-1.9.1 
100 upgraded, 73 newly installed, 0 to remove and 0 not upgraded.
Need to get 265 MB/299 MB of archives.
After this operation, 170 MB of additional disk space will be used.
Do you want to continue [Y/n]? -----