Ova stranica dokumentira naša podešavanja (i pokušaje) za što bržom Koha instalacijom.

Apache deflate kompresija

Smanjuje veličinu stranice koja se isporučije browersu.

Session

dpavlin@koha:~$ sudo ./mk-query-digest /var/log/mysql/mysql-slow.log

# Profile
# Rank Query ID           Response time    Calls R/Call   Item
# ==== ================== ================ ===== ======== ================
#    1 0xC7A803CDD4FE9A36 30517.0000 45.5%   349  87.4413 INSERT UPDATE sessions
#    2 0xB4F2B316DFE865C8  8027.0000 12.0%   119  67.4538 SELECT sessions
#    3 0x6019E0D94A244FF5  3952.0000  5.9%   275  14.3709 SELECT opac_news
#    4 0x1F809CA9753CDEE7  2753.0000  4.1%    23 119.6957 SELECT biblio
#    5 0x27CE7D5D2BC5F598  2305.0000  3.4%   206  11.1893 SELECT fieldmapping
#    6 0xB0F504DD073A49CB  2192.0000  3.3%    30  73.0667 SELECT issues items biblio biblioitems
#    7 0x8ED635CB153D27A5  2146.0000  3.2% 19313   0.1111 SELECT reserves reserveconstraints
#    8 0xDB6DC1962741AB10  1978.0000  3.0%     7 282.5714 SELECT biblio biblioitems itemtypes
#    9 0x32783383AEA5AD49  1642.0000  2.4%    10 164.2000 SELECT items
#   10 0x6DD9F09DA2455228  1361.0000  2.0%     8 170.1250 DELETE sessions

Promjeniti SessionStorage u "as temporary files" i opcionalno pomaknuti ih u /dev/shm umjesti o u /tmp/:

dpavlin@koha:~$ diff -urw /srv/koha/C4/Auth.pm /usr/share/koha/lib/C4/Auth.pm
--- /srv/koha/C4/Auth.pm        2010-02-20 21:41:34.000000000 +0100
+++ /usr/share/koha/lib/C4/Auth.pm      2010-04-26 16:03:17.671211497 +0200
@@ -1341,7 +1341,7 @@
     }
     else {
         # catch all defaults to tmp should work on all systems
-        $session = new CGI::Session("driver:File;serializer:yaml;id:md5", $sessionID, {Directory=>'/tmp'});
+        $session = new CGI::Session("driver:File;serializer:yaml;id:md5", $sessionID, {Directory=>

Profile

Devel::NYTProf

instalacija:

root@koha-dev-git-reorg:~# cpan Devel::NYTProf

profile search query:

root@koha-dev-git-reorg:/usr/share/koha/opac/cgi-bin/opac# time perl -d:NYTProf -I/usr/share/koha/lib/ opac-search.pl q=human | wc
   1553    3259   58648

real    0m4.001s
user    0m3.152s
sys     0m0.560s

generate html report:

root@koha-dev-git-reorg:/usr/share/koha/opac/cgi-bin/opac# nytprofhtml 
Generating report...
Reading nytprof.out
Writing report to nytprof directory

koha-240

First run

dpavlin@koha-240:/tmp$ time perl -d:NYTProf -I/usr/share/koha/lib/ /usr/share/koha/opac/cgi-bin/opac/opac-search.pl q=human | wc
Use of uninitialized value $borrowernumber in string eq at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 483.
Use of uninitialized value in string eq at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 486.
   1962    3177   64512

real    0m8.561s
user    0m5.708s
sys     0m0.724s

Second run

dpavlin@koha-240:/tmp$ time perl -d:NYTProf -I/usr/share/koha/lib/ /usr/share/koha/opac/cgi-bin/opac/opac-search.pl q=human | wc
Use of uninitialized value $borrowernumber in string eq at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 483.
Use of uninitialized value in string eq at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 486.
   1962    3177   64512

real    0m6.664s
user    0m5.636s
sys     0m0.816s

Drop caches and run profile:

dpavlin@koha-240:/tmp$ sudo sh -c 'echo 3 > /proc/sys/vm/drop_caches'

Zebra reindex

dpavlin@koha-240:/srv/koha$ sudo -u koha ./misc/migration_tools/rebuild_zebra.pl -b -v -r -d /tmp/indexing -k -x -nosanitize

MySQL baza iz komandne linije

Backup

$ mysqldump --add-drop-table --single-transaction -u _kohauser_ -p koha > 2008-11-11_koha.sql
$ mysqldump --add-drop-table -u _kohauser_ -p koha issues > 2008-11-11_koha.issues.sql

http://www.nabble.com/Backing-up-3.0-to21076508.html

Restore

$ mysql -u _kohauser_ -p koha < 2008-11-11_koha.sql
$ mysql -u _kohauser_ -p koha.issues < 2008-11-11_koha.issues.sql

Restore sa zfs

opr - zfs backup server

# Find backup snapshot to restore
dpavlin@opl:~$ ./veid2hostname.sh 
212052 koha-dev.rot13.org
212056 webpac2.rot13.org
212226 koha.ffzg.hr
dpavlin@opl:~$ sudo zfs list | grep 212226 | tail -3
opl/backup/212226@2010-01-05   662M      -  25.4G  -
opl/backup/212226@2010-01-06    28K      -  25.4G  -
opl/clone/212226-mlin         30.0M  24.5G  25.4G  /opl/clone/212226-mlin

# make clone to access files
dpavlin@opl:~$ sudo zfs clone opl/backup/212226@2010-01-06 opl/clone/koha-2010-01-06
dpavlin@opl:~$ df -h /opl/clone/koha-2010-01-06
Filesystem            Size  Used Avail Use% Mounted on
opl/clone/koha-2010-01-06
                       50G   26G   25G  51% /opl/clone/koha-2010-01-06

cpio file transfer

• mlin - hardware which provide resources
• opl - machine with backup files

root@mlin:/virtual.clone# mkdir koha-2010-01-06
root@mlin:/virtual.clone# cd koha-2010-01-06/

# start listener for cpio data transfer
root@mlin:/virtual.clone/koha-2010-01-06# nc -l -p 8888 | pv | cpio --extract --make-directories --preserve-modification-time --numeric-uid-gid --sparse

dpavlin@opl:~$ sudo bash
root@opl:~# cd /opl/clone/koha-2010-01-06
root@opl:/opl/clone/koha-2010-01-06# find . | cpio --create | pv | nc 10.60.0.93 8888

rsync file update

dpavlin@mlin:~$ sudo rsync -ravH --numeric-ids --sparse --delete --exclude 'backup*' \
  10.60.0.90:/opl/clone/koha-2010-01-06/ /virtual.clone/koha-2010-01-06/

real    24m48.767s
user    5m0.027s
sys     2m3.656s

Kopiranje postojeće virtualne mašine prije rsync-a da bi se smanjilo broj promjena koje treba prenjeti rsync-om:

dpavlin@mlin:/virtual.clone/koha.ffzg.hr$ time sudo cp -ar * ../koha-2010-01-06/

real    14m59.742s
user    0m0.932s
sys     0m38.278s

Virtualna mašina

Nakon restora sa zfs-a treba napraviti sljedeća podešavanja:

Pokrenuti screen u kojem će biti virtualna mašina

dpavlin@mlin:~$ screen -S koha-upgrade

Filesystem

lvcreate -s /dev/vg/koha -L 80G -n koha-upgrade

root@mlin:~# mount /dev/vg/koha-upgrade /virtual.clone/koha-upgrade/
root@mlin:~# df /virtual.clone/koha-upgrade/
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/mapper/vg-koha--upgrade
                      82569904  56551456  26018448  69% /virtual.clone/koha-upgrade

Start LXC

root@mlin:~# cd /srv/sysadmin-cookbook/recepies/lxc/
root@mlin:/srv/sysadmin-cookbook/recepies/lxc# ./ve2lxc.sh /virtual.clone/koha-upgrade/ 10.60.0.253 koha-upgrade

Setup inside LXC

• ugasiti monit apt-get remove monit
• provjeriti IP adrese u /etc/apache2/sites-enabled/

BTRFS

root@opl:~# zfs clone opl/backup/212226@2010-03-06 opl/clone/koha-2010-03-06

root@prod:/virtual# time rsync -rav --exclude 'backup/*' --delete 10.60.0.90::clone/koha-2010-03-06/ /virtual/koha/
receiving incremental file list
...

sent 3297036 bytes  received 4392640729 bytes  6527004.85 bytes/sec
total size is 23473104677  speedup is 5.34

real    11m13.873s
user    1m15.985s
sys     0m39.890s

root@prod:/virtual# btrfsctl -s /virtual/koha@2010-03-06 /virtual/koha
operation complete
Btrfs Btrfs v0.19

root@prod:/virtual# btrfsctl -s /virtual/koha-242 /virtual/koha
operation complete
Btrfs Btrfs v0.19

dpavlin@prod:~$ sudo bash ve2lxc.sh /virtual/koha-242 10.60.0.242 koha-242

Korisne bilješke za korištenje WebPAC2 sa Kohom.

Indeksiranje podataka iz Kohe

• http://blog.rot13.org/2009/07/sharing_mysql_between_openvz_containers.html

root@koha-hw:~# mount --bind /vz/root/212052/var/run/mysqld/ \
      /vz/root/212056/var/run/mysqld/

dpavlin@webpac2:/srv/webpac2$ export KOHA_USER=kohaadmin
dpavlin@webpac2:/srv/webpac2$ export KOHA_PASSWD=password
dpavlin@webpac2:/srv/webpac2$ ./run.pl --config vhost/koha/config.yml 

• http://webpac2.rot13.org/webpac2.cgi/koha

Drugi način je korištenje DBD::Gofer DBI_AUTOPROXY='dbi:Gofer:transport=stream;url=ssh:dpavlin@koha.ffzg.hr' ali za to cijeli resultset mora stati u memoriju

Za detalje pogledajte LDAP

Virtualni LDAP omogućava Kohi da isporučuje podatke preko LDAP-a drugim sustavima, u našem slučaju, kopirkama, vidi SafeQ integration.

Drugi dio sustava je LDAP rewrite koji omogućava korištenje login@ffzg.hr bez modifikacija kohe.

upgrade

Upgrade na r61 koji ima podršku za novu koha konfiguraciju i logine bez modifikacije kohe:

# tunnel
dpavlin@llin:~$ ssh -R 8022:localhost:22 10.60.0.252

dpavlin@koha-2010-01-06:~$ cd /srv/virtual-ldap/
dpavlin@koha-2010-01-06:/srv/virtual-ldap$ svn update
A    sql
A    sql/organizationalunit.sql
A    sql/group.sql
A    sql/hreduperson.sql
U    lib/LDAP/Virtual.pm
U    lib/LDAP/Koha.pm
U    bin/ldap-rewrite.pl
Updated to revision 61.

start server process

dpavlin@koha-upgrade:~$ screen -S virtual-ldap

Pokrenuti server (inače to radi monit, ali on je deinstaliran da ne gnjavi)

dpavlin@koha-upgrade:~$ cd /srv/virtual-ldap/
dpavlin@koha-upgrade:/srv/virtual-ldap$ ./bin/virtual-ldap.pl 
LDAP server listening on port 1389

Čudan depdendency koji ne bi trebao postojati (kako radi na produkciji?)

dpavlin@koha-upgrade:/srv/virtual-ldap$ ./bin/virtual-ldap.pl 
Can't locate Net/LDAP/Server.pm in @INC (@INC contains: lib /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at lib/LDAP/Virtual.pm line 12, <DATA> line 96.
BEGIN failed--compilation aborted at lib/LDAP/Virtual.pm line 12, <DATA> line 96.
Compilation failed in require at ./bin/virtual-ldap.pl line 7, <DATA> line 96.
BEGIN failed--compilation aborted at ./bin/virtual-ldap.pl line 7, <DATA> line 96.


dpavlin@koha-upgrade:/srv/virtual-ldap$ sudo apt-get install libnet-ldap-server-perl

Zotero is a free, easy-to-use Firefox extension
to help you collect, manage, and cite your research sources. It lives right where you do
your work—in the web browser itself.

Izazov

Problem (err, izazov) je u tome da želimo imati Zotero koji se autorizira WebDAV-om koristeći račune iz Kohe. Jedna od mogućnosti je koristiti jednostavno AAIEdu LDAP server ali onda nemamo korisnike koji su samo u Kohi.

Druga ideja je bila koristiti libapache2-mod-auth-mysql za autorizaciju direktno na Koha bazu, ali nažalost izgleda da se neda konfigurirati za isti oblik md5 hash-a passworda koji koristi koha (sigh)

Ostatak uputa je strgan (i/ili star) dok ne rješim problem!

http://bugs.rot13.org/rt/Ticket/Display.html?id=397

Za korisnike Zotera

Install Zotero Firefox plugin 2.0

install

Podešavanje servera

Apache kao SSL proxy

dpavlin@koha-dev:~$ sudo a2enmod proxy_http
Considering dependency proxy for proxy_http:
Enabling module proxy.
Enabling module proxy_http.
Run '/etc/init.d/apache2 restart' to activate new configuration!

    <Proxy *>
        Order deny,allow
#       Deny from all
#       Allow from localhost
        Allow from all
    </Proxy>

    ProxyRequests       on
    ProxyPass           /zotero http://localhost:4242/zotero
    ProxyPassReverse    /zotero http://localhost:4242/zotero

Apache WebDAV

dpavlin@koha-dev:~$ sudo a2enmod dav_fs dav
Considering dependency dav for dav_fs:
Enabling module dav.
Enabling module dav_fs.
Module dav already enabled
Run '/etc/init.d/apache2 restart' to activate new configuration!
dpavlin@koha-dev:~$ sudo /etc/init.d/apache2 restart
Restarting web server: apache2 ... waiting.

Apache auth

dpavlin@koha-dev:~$ sudo apt-get install libapache2-mod-auth-mysql

dpavlin@koha-dev:~$ sudo a2enmod auth_mysql
Enabling module auth_mysql.
Run '/etc/init.d/apache2 restart' to activate new configuration!
dpavlin@koha-dev:~$ sudo /etc/init.d/apache2 restart

Directory

dpavlin@koha-dev:~$ sudo mkdir /srv/zotero

Apache vhost

dpavlin@koha-dev:~$ cat /etc/apache2/sites-available/zotero-dev.vzb.ffzg.hr 
<VirtualHost *>
        ServerName zotero-dev.vbz.ffzg.hr
        DocumentRoot /srv/zotero
        <Directory /home/srw/example.com>
                Options Indexes MultiViews
                AllowOverride None
                Order allow,deny
                allow from all
        </Directory>

                Auth_MySQL_Info localhost LOGIN PASSWORD

        <Location />

                Auth_MYSQL on

                Auth_MySQL_Password_Table borrowers
                Auth_MySQL_Username_Field userid
                Auth_MySQL_Password_Field password
                Auth_MySQL_Empty_Passwords off
                Auth_MySQL_Encryption_Types Crypt_MD5
                #PHP_MD5

                DAV On
                AuthType Basic
                AuthName "Zotero WebDAV server - use Koha login and password"
                Require valid-user

        </Location>

</VirtualHost>

dpavlin@koha-dev:/etc/apache2/sites-enabled$ sudo a2ensite zotero-dev.vzb.ffzg.hr

Test

dpavlin@koha-dev:~$ sudo apt-get install cadaver

dpavlin@koha-dev:~$ cadaver http://zotero-dev.rot13.org

Koristi Webconverger distribuciju za kreiranje web kioska

Dodatno instalirani paketi

• dropbear
• http://webconverger.com/xpis/webcnoaddressbar.xpi - skrivanje address bar-a

Lokalne Webconverger modifikacije

instalacija

root@opr:/srv/pxelator# apt-get install squashfs-tools aufs-tools aufs-modules-`uname -r`

promjene

dpavlin@opr:/srv/pxelator$ ./bin/webc-overlay.sh 
+ mount+ egrep /tmp/(base|export|changes)

+ sudo mount /srv/pxelator/tftp/webconverger/iso/live/filesystem.squashfs /tmp/base/ -o loop
+ mkdir /tmp/changes /tmp/base /tmp/export
mkdir: cannot create directory `/tmp/changes': File exists
mkdir: cannot create directory `/tmp/base': File exists
mkdir: cannot create directory `/tmp/export': File exists
+ sudo mount -t aufs -o br:/tmp/changes/:/tmp/base/ none /tmp/export/
+ sudo chroot /tmp/export
root@opr:/# 

Nakon Ctrl+D rebuildati će se /srv/pxelator/tftp/webconverger/custom.squashfs koji koriste katalozi za boot.

u /srv/koha direktoriju

$ git pull
$ perl Makefile.PL
$ make
$ make test
$ sudo make install
$ git log

Git

• Pro Git Book: http://progit.org/book/
• GitCasts: http://gitcasts.com/

Korisne git komande

$ git diff --cached # difference between HEAD and the index; what
                    # would be committed if you ran "commit" now.
$ git diff          # difference between the index file and your
                    # working directory; changes that would not
                    # be included if you ran "commit" now.
$ git diff HEAD     # difference between HEAD and working tree; what
                    # would be committed if you ran "commit -a" now.
$ git status        # a brief per-file summary of the above.

Instalacija perl modula

pr. Test::More

$ apt-get install libtest-more-perl
ili
$ sudo cpan Test::More

Nakon nadogradnje na produkciji

• editirati SIPconfig.xml - u tagu service dodati odgovarajuću IP adresu
• restore LDAP setinga

How to Reset the Koha 3 Database

http://wiki.koha.org/doku.php?id=resetdatabasekoha3

Tutorial for Updating Database Files

http://wiki.koha.org/doku.php?id=en:documentation:tutorials:dbupdatetutorial

Repozitorij: koha-ffzg.git

Promijenjene datoteke:

C4/Circulation.pm
C4/Search.pm
cataloguing/additem.pl
koha-tmpl/intranet-tmpl/ffzg/en/includes/biblio-view-menu.inc
koha-tmpl/intranet-tmpl/ffzg/en/modules/cataloguing/additem.tmpl
koha-tmpl/intranet-tmpl/ffzg/en/modules/cataloguing/results.tmpl

Dodane datoteke

dla_interface/downloadLog.log
dla_interface/download.pl
dla_interface/output.txt
dla_interface/search.pl
catalogue/passhistory.pl
koha-tmpl/intranet-tmpl/ffzg/img/rfidPosition1.jpg
koha-tmpl/intranet-tmpl/ffzg/img/rfidPosition2.jpg
koha-tmpl/intranet-tmpl/ffzg/img/rfidPosition3.jpg
koha-tmpl/intranet-tmpl/ffzg/en/modules/catalogue/passhistory.tmpl
koha-tmpl/intranet-tmpl/ffzg/en/modules/dla_interface/search.tmpl

Promjene na bazi

Veličina polja

Potrebno je povećati broj znakova u nekim poljima u koha.items i koha.biblioitems

mysql> alter table items modify itemcallnumber varchar(255);

Opis potrebnih promjena

Prikaz bibliografskih podataka u normal view

Marijana:
koha-tmpl/intranet-tmpl/ffzg/en/modules/cataloguing/results.tmpl

Prikaz starog inventarnog broja u rezultatima pretraživanja

Sučelje je prilagođeno tako da je sa stranice s rezultatima odmah moguće doći na stranicu za uređivanje podataka o primjercima.
Budući da su podaci o primjercima generirani na temelju inventarnog broja, svaki zapis o primjerku ima taj broj u trenutku konverzije.
Inv. brojevi ispisuju se na stranici s rezultatima i klikom na pojedini inv. broj dolazi se na sučelje za editiranje primjerka s tim inventarnim brojem.

Dobrica:
C4/Search.pm
koha-tmpl/intranet-tmpl/ffzg/en/modules/cataloguing/results.tmpl

Potrebno je još:

• vizualno istaknuti podatak o lokaciji i signaturi na stranici s rezultatima pretraživanja
• omogućiti ograničavanje pretraživanja na podatak o signaturi - staroj i novoj - da li u istom kriteriju ili ne?
• vizualno istaknuti, različitim bojama naslove: Add item (crveno) i Edit item (zeleno)
• pored naslova Add Item i Edit item ispisati inv. broj
• pofarbati polje za signaturu u crveno

Unos podataka o primjercima

Indikator za poziciju RFID naljepnice

Dodane su slike s brojevima 1, 2 ili 3 koji ukazuju na pozicijamu RFID naljepnice na knjizi.
Za prvi primjerak broj se genira po slučaju, ostali primjerci istog naslova idu cirkularno.

Hrvoje Matasić, Vivainfo:
cataloguing/additem.pl
koha-tmpl/intranet-tmpl/ffzg/en/modules/cataloguing/additem.tmpl
koha-tmpl/intranet-tmpl/ffzg/img/rfidPosition1.jpg
koha-tmpl/intranet-tmpl/ffzg/img/rfidPosition2.jpg
koha-tmpl/intranet-tmpl/ffzg/img/rfidPosition3.jpg

Prikaz barkod broja u <title>

Barkod iz naslova se koristi kod čipiranja.

Hrvoje Matasić, Vivainfo:
cataloguing/additem.pl
koha-tmpl/intranet-tmpl/ffzg/en/modules/cataloguing/additem.tmpl

Statistika prolazaka kroz vrata

(ovo je nemoguće implementirati jer vrata ne mogu pročitati oznaku primjerka s čipa)

Hrvoje Matasić, Vivainfo:
koha-tmpl/intranet-tmpl/ffzg/en/modules/catalogue/passhistory.tmpl
catalogue/passhistory.pl
C4/Circulation.pm
koha-tmpl/intranet-tmpl/ffzg/en/includes/biblio-view-menu.inc

Sučelje za DLA

opis funkcionalnosti

Hrvoje Matasić, Vivainfo:
dla_interface/downloadLog.log
dla_interface/download.pl
dla_interface/output.txt
dla_interface/search.pl
koha-tmpl/intranet-tmpl/ffzg/en/modules/dla_interface/search.tmpl