April 2009 - Koha-devel - lists.koha-community.org

Re: [Koha-devel] Koha hosting - Zebra issues
by Joe Atzberger 29 Apr '09

29 Apr '09

I'm sorry, a step-by-step guide isn't something I have time to produce. In particular, the problem of already having Koha's installed is not one I have dealt with. We only do "dev" installs with the proper settings at outset, including zebra enabled, so we have not had to convert from nozebra to zebra for many instances in parallel. --Joe On Mon, Apr 27, 2009 at 3:34 PM, C W Nel <zang(a)zang.co.za> wrote: > Thanks Joe > > Will you be so kind to help with a "step by step" procedure to accomplish > this? > Our hosted systems are running 100% on no-zebra, but at this stage we want > to > enable Zebra. > Zebra is running and does function well on the default port and database > when activated. > > Thanks again for your help. > > ----- Original Message ----- > *From:* Joe Atzberger <ohiocore(a)gmail.com> > *To:* C W Nel <zang(a)zang.co.za> > *Sent:* Monday, April 27, 2009 6:50 PM > *Subject:* Re: [Koha-devel] Koha hosting - Zebra issues > > No, the same database *name* (of "biblios" or "authorities") can be used > when zebrasrv is running on a different port, with a different > koha-conf.xml. The data would actually be in a distinct DB per instance. > > --Joe > > On Mon, Apr 27, 2009 at 12:38 PM, C W Nel <zang(a)zang.co.za> wrote: > >> Thanks Joe >> >> Do I understand you correctly that the same zebra database is used for all >> the different instances? >> >> -----Original Message----- >> *From:* Joe Atzberger [mailto:ohiocore@gmail.com] >> *Sent:* Monday, April 27, 2009 4:20 PM >> *To:* C W Nel >> *Cc:* koha-devel(a)lists.koha.org >> *Subject:* Re: [Koha-devel] Koha hosting - Zebra issues >> >> If you just run the separate zebrasrv process as a different user, on a >> different port, then it can use the stock DB name as normal. This also >> helps keep one instance from taxing the others directly during execution. >> -- >> Joe Atzberger >> LibLime - Open Source Library Solutions >> >> 2009/4/27 C W Nel <zang(a)zang.co.za> >> >> Can anyone help with tips how to configure zebra in a hosted environment? >> >> With other words, how to create another zebra database and what is to be >> changed in >> >> the koha-conf.xml instances? >> >> Thanks >> >

2 1

Koha 3 and Zebra indexing with ICU
by Pongtawat Chippimolchai 29 Apr '09

29 Apr '09

Hello, I have problems trying to enable ICU support in Zebra under Koha 3. After enabling ICU support in Zebra and reindex Koha, all Koha search will return nothing. However, if I change Zebra to listen to TCP port and query it directly using SRU, it will give the correct results. I try to change many things without any success. I'm running Koha 3.0.1 on Ubuntu 8.04, Zebra is at version 2.0.36 from Index Data APT repository. ICU is enabled by adding "index: icu.idx" line to Koha-Zebra's .cfg (zebra-biblios.cfg, etc). Default word and phrase index setting in icu.idx is used. Other missing index types (u, n, 0, y, d) are added to icu.idx by copying from default.idx. Some files are copied to /etc/koha/zebradb/etc in order to make ICU indexing works. With icuchain option (the default one), searhing in Koha won't work. However, if I remove icuchain option searching will partially work (whole phrase exact search only). At first I though there is a problem with icuchain rule, but I test it with yaz-icu and it give the correct results. I also try patching Zebra ( http://lists.indexdata.dk/pipermail/zebralist/2009-March/002134.html) but it doesn't help either. What's strange is that if I put Zebra on TCP port and query it directly, e.g. " http://localhost:9999/biblios?version=1.1&operation=searchRetrieve&query=sc…", I get the expected answer (while there are no answer in Koha). So, could anybody please give me some suggestions? Thank you very much in advance! Pongtawat C. (pongtawat.ait(a)gmail.com) ==== Log file when searching in Koha ==== ... 14:54:35-27/04 zebrasrv(2) [debug] server select: config=/etc/koha/zebradb/zebra-biblios.cfg 14:54:35-27/04 zebrasrv(2) [debug] bend_init 14:54:35-27/04 zebrasrv(2) [debug] zebra_open zs=0x80756e8 returns 0x807aab0 14:54:35-27/04 zebrasrv(2) [debug] Sort handler installed 14:54:35-27/04 zebrasrv(2) [debug] Search handler installed 14:54:35-27/04 zebrasrv(2) [debug] ESRequest handler installed 14:54:35-27/04 zebrasrv(2) [debug] Delete handler installed 14:54:35-27/04 zebrasrv(2) [debug] Scan handler installed 14:54:35-27/04 zebrasrv(2) [debug] Segment handler installed 14:54:35-27/04 zebrasrv(2) [debug] result immediately available 14:54:35-27/04 zebrasrv(2) [debug] ir_session (output) 14:54:35-27/04 zebrasrv(2) [debug] Wrote PDU, 114 bytes 14:54:35-27/04 zebrasrv(2) [debug] ir_session (input) 14:54:35-27/04 zebrasrv(2) [debug] Got PDU, 447 bytes: lead=B6 80 8D 14:54:35-27/04 zebrasrv(2) [debug] ResultSet '1' 14:54:35-27/04 zebrasrv(2) [debug] zebra_register_open rw=0 useshadow=0 p=0x810fb28 n= rp=(none) 14:54:35-27/04 zebrasrv(2) [debug] mf_init(register) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort100 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort96 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort58 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort40 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort30 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: isambD consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: gmatch consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: reci consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: dict consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: isambA consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort50 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort26 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort92 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: isambB consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: isambC consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: recdB consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort36 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort63 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort44 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: sort85 consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] mf_init: recdA consists of 1 part(s) 14:54:35-27/04 zebrasrv(2) [debug] Using default resource recordCompression:none 14:54:35-27/04 zebrasrv(2) [debug] mf_open(reci bs=128, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] mf_open(recdA bs=128, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] mf_open(recdB bs=512, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] mf_open(dict bs=4096, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] Using default resource isamcDebug:0 14:54:35-27/04 zebrasrv(2) [debug] mf_open(isambA bs=32, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] mf_open(isambB bs=128, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] mf_open(isambC bs=512, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] mf_open(isambD bs=2048, RDONLY) 14:54:35-27/04 zebrasrv(2) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=explain.abs mode=r 14:54:35-27/04 zebrasrv(2) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=explain.att mode=r 14:54:35-27/04 zebrasrv(2) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=explain.tag mode=r 14:54:35-27/04 zebrasrv(2) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=tagsetm.tag mode=r 14:54:35-27/04 zebrasrv(2) [debug] Using default resource notimestamps:0 14:54:35-27/04 zebrasrv(2) [debug] read runnumber=10 14:54:35-27/04 zebrasrv(2) [debug] zebra_register_open ok p=0x810fb28 14:54:35-27/04 zebrasrv(2) [debug] Using default resource sortmax:1000 14:54:35-27/04 zebrasrv(2) [debug] rpn_search_APT 14:54:35-27/04 zebrasrv(2) [debug] index_type=p 14:54:35-27/04 zebrasrv(2) [debug] complete_flag=1 14:54:35-27/04 zebrasrv(2) [debug] search_type=phrase 14:54:35-27/04 zebrasrv(2) [debug] rank_type=rank,w=32,u=36 14:54:35-27/04 zebrasrv(2) [log] input school 14:54:35-27/04 zebrasrv(2) [debug] Using default resource truncmax:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=bib1.att mode=r 14:54:35-27/04 zebrasrv(2) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=gils.att mode=r 14:54:35-27/04 zebrasrv(2) [log] output M-7EE?\x01\x0A\x01\x0A 14:54:35-27/04 zebrasrv(2) [log] dict_lookup_grep: (\x01()M-7EE\?\x01\x01\x01\x0A\x01\x01\x01\x0A 14:54:35-27/04 zebrasrv(2) [debug] dict_lookup_grep range=0 14:54:35-27/04 zebrasrv(2) [debug] 0 40 ( 14:54:35-27/04 zebrasrv(2) [debug] 1 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 2 40 ( 14:54:35-27/04 zebrasrv(2) [debug] 3 41 ) 14:54:35-27/04 zebrasrv(2) [debug] 4 77 M 14:54:35-27/04 zebrasrv(2) [debug] 5 45 - 14:54:35-27/04 zebrasrv(2) [debug] 6 55 7 14:54:35-27/04 zebrasrv(2) [debug] 7 69 E 14:54:35-27/04 zebrasrv(2) [debug] 8 69 E 14:54:35-27/04 zebrasrv(2) [debug] 9 92 \ 14:54:35-27/04 zebrasrv(2) [debug] 10 63 ? 14:54:35-27/04 zebrasrv(2) [debug] 11 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 12 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 13 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 14 10 ? 14:54:35-27/04 zebrasrv(2) [debug] 15 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 16 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 17 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 18 10 ? 14:54:35-27/04 zebrasrv(2) [debug] max_pos = 1 14:54:35-27/04 zebrasrv(2) [debug] 0 positions 14:54:35-27/04 zebrasrv(2) [debug] Using default resource trunclimit:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [debug] rpn_search_APT 14:54:35-27/04 zebrasrv(2) [debug] index_type=p 14:54:35-27/04 zebrasrv(2) [debug] complete_flag=1 14:54:35-27/04 zebrasrv(2) [debug] search_type=phrase 14:54:35-27/04 zebrasrv(2) [debug] rank_type=rank,w=28,u=4 14:54:35-27/04 zebrasrv(2) [log] input school 14:54:35-27/04 zebrasrv(2) [debug] Using default resource truncmax:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [log] output M-7EE?\x01\x0A\x01\x0A 14:54:35-27/04 zebrasrv(2) [log] dict_lookup_grep: (\x01,)M-7EE\?\x01\x01\x01\x0A\x01\x01\x01\x0A 14:54:35-27/04 zebrasrv(2) [debug] dict_lookup_grep range=0 14:54:35-27/04 zebrasrv(2) [debug] 0 40 ( 14:54:35-27/04 zebrasrv(2) [debug] 1 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 2 44 , 14:54:35-27/04 zebrasrv(2) [debug] 3 41 ) 14:54:35-27/04 zebrasrv(2) [debug] 4 77 M 14:54:35-27/04 zebrasrv(2) [debug] 5 45 - 14:54:35-27/04 zebrasrv(2) [debug] 6 55 7 14:54:35-27/04 zebrasrv(2) [debug] 7 69 E 14:54:35-27/04 zebrasrv(2) [debug] 8 69 E 14:54:35-27/04 zebrasrv(2) [debug] 9 92 \ 14:54:35-27/04 zebrasrv(2) [debug] 10 63 ? 14:54:35-27/04 zebrasrv(2) [debug] 11 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 12 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 13 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 14 10 ? 14:54:35-27/04 zebrasrv(2) [debug] 15 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 16 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 17 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 18 10 ? 14:54:35-27/04 zebrasrv(2) [debug] max_pos = 1 14:54:35-27/04 zebrasrv(2) [debug] 0 positions 14:54:35-27/04 zebrasrv(2) [debug] Using default resource trunclimit:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [debug] rpn_search_APT 14:54:35-27/04 zebrasrv(2) [debug] index_type=w 14:54:35-27/04 zebrasrv(2) [debug] complete_flag=0 14:54:35-27/04 zebrasrv(2) [debug] search_type=phrase 14:54:35-27/04 zebrasrv(2) [debug] rank_type=rank,w=26,u=4 14:54:35-27/04 zebrasrv(2) [log] input school 14:54:35-27/04 zebrasrv(2) [debug] Using default resource truncmax:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [log] output M-7EE?\x01\x0A\x01\x0A 14:54:35-27/04 zebrasrv(2) [log] dict_lookup_grep: (\x01*)M-7EE\?\x01\x01\x01\x0A\x01\x01\x01\x0A 14:54:35-27/04 zebrasrv(2) [debug] dict_lookup_grep range=0 14:54:35-27/04 zebrasrv(2) [debug] 0 40 ( 14:54:35-27/04 zebrasrv(2) [debug] 1 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 2 42 * 14:54:35-27/04 zebrasrv(2) [debug] 3 41 ) 14:54:35-27/04 zebrasrv(2) [debug] 4 77 M 14:54:35-27/04 zebrasrv(2) [debug] 5 45 - 14:54:35-27/04 zebrasrv(2) [debug] 6 55 7 14:54:35-27/04 zebrasrv(2) [debug] 7 69 E 14:54:35-27/04 zebrasrv(2) [debug] 8 69 E 14:54:35-27/04 zebrasrv(2) [debug] 9 92 \ 14:54:35-27/04 zebrasrv(2) [debug] 10 63 ? 14:54:35-27/04 zebrasrv(2) [debug] 11 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 12 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 13 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 14 10 ? 14:54:35-27/04 zebrasrv(2) [debug] 15 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 16 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 17 1 ? 14:54:35-27/04 zebrasrv(2) [debug] 18 10 ? 14:54:35-27/04 zebrasrv(2) [debug] max_pos = 1 14:54:35-27/04 zebrasrv(2) [debug] 0 positions 14:54:35-27/04 zebrasrv(2) [debug] Using default resource trunclimit:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [debug] rpn_search_APT 14:54:35-27/04 zebrasrv(2) [debug] index_type=w 14:54:35-27/04 zebrasrv(2) [debug] complete_flag=0 14:54:35-27/04 zebrasrv(2) [debug] search_type=and-list 14:54:35-27/04 zebrasrv(2) [debug] rank_type=rank,w=16,u=-1 14:54:35-27/04 zebrasrv(2) [log] input school 14:54:35-27/04 zebrasrv(2) [debug] Using default resource truncmax:10000 14:54:35-27/04 zebrasrv(2) [debug] term_limits_APT ref_id=none limit=0 14:54:35-27/04 zebrasrv(2) [debug] result immediately available 14:54:35-27/04 zebrasrv(2) [debug] ir_session (output) 14:54:35-27/04 zebrasrv(2) [debug] Wrote PDU, 38 bytes 14:54:35-27/04 zebrasrv(2) [debug] ir_session (input) 14:54:35-27/04 zebrasrv(2) [debug] ir_session (input) 14:54:35-27/04 zebrasrv(2) [debug] zebra_close zh=0x807aab0 14:54:35-27/04 zebrasrv(2) [debug] zebra_register_close p=0x810fb28 14:54:35-27/04 zebrasrv(2) [debug] mf_close(dict) 14:54:35-27/04 zebrasrv(2) [debug] isamb_close returned 0 values, skipped 0 14:54:35-27/04 zebrasrv(2) [debug] mf_close(isambA) 14:54:35-27/04 zebrasrv(2) [debug] mf_close(isambB) 14:54:35-27/04 zebrasrv(2) [debug] mf_close(isambC) 14:54:35-27/04 zebrasrv(2) [debug] mf_close(isambD) 14:54:35-27/04 zebrasrv(2) [debug] mf_close(reci) 14:54:35-27/04 zebrasrv(2) [debug] mf_close(recdA) 14:54:35-27/04 zebrasrv(2) [debug] mf_close(recdB) ==== Log file when searching with Zebra directly ==== 14:59:39-27/04 zebrasrv(1) [debug] server select: config=/etc/koha/zebradb/zebra-biblios.cfg 14:59:39-27/04 zebrasrv(1) [debug] yaz_srw_decode returned 2 14:59:39-27/04 zebrasrv(1) [debug] yaz_sru_decode returned 0 14:59:39-27/04 zebrasrv(1) [debug] ResultSet 'default' 14:59:39-27/04 zebrasrv(1) [debug] rpn_search_APT 14:59:39-27/04 zebrasrv(1) [debug] index_type=w 14:59:39-27/04 zebrasrv(1) [debug] complete_flag=0 14:59:39-27/04 zebrasrv(1) [debug] search_type=phrase 14:59:39-27/04 zebrasrv(1) [debug] rank_type=void 14:59:39-27/04 zebrasrv(1) [log] input school 14:59:39-27/04 zebrasrv(1) [debug] Using default resource truncmax:10000 14:59:39-27/04 zebrasrv(1) [debug] term_limits_APT ref_id=none limit=0 14:59:39-27/04 zebrasrv(1) [log] output M-7EE?\x01\x0A\x01\x0A 14:59:39-27/04 zebrasrv(1) [log] dict_lookup_grep: (\x01\x0D)M-7EE\?\x01\x01\x01\x0A\x01\x01\x01\x0A 14:59:39-27/04 zebrasrv(1) [debug] dict_lookup_grep range=0 14:59:39-27/04 zebrasrv(1) [debug] 0 40 ( 14:59:39-27/04 zebrasrv(1) [debug] 1 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 2 13 ? 14:59:39-27/04 zebrasrv(1) [debug] 3 41 ) 14:59:39-27/04 zebrasrv(1) [debug] 4 77 M 14:59:39-27/04 zebrasrv(1) [debug] 5 45 - 14:59:39-27/04 zebrasrv(1) [debug] 6 55 7 14:59:39-27/04 zebrasrv(1) [debug] 7 69 E 14:59:39-27/04 zebrasrv(1) [debug] 8 69 E 14:59:39-27/04 zebrasrv(1) [debug] 9 92 \ 14:59:39-27/04 zebrasrv(1) [debug] 10 63 ? 14:59:39-27/04 zebrasrv(1) [debug] 11 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 12 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 13 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 14 10 ? 14:59:39-27/04 zebrasrv(1) [debug] 15 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 16 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 17 1 ? 14:59:39-27/04 zebrasrv(1) [debug] 18 10 ? 14:59:39-27/04 zebrasrv(1) [debug] max_pos = 11 14:59:39-27/04 zebrasrv(1) [debug] 1 positions 14:59:39-27/04 zebrasrv(1) [debug] Using default resource trunclimit:10000 14:59:39-27/04 zebrasrv(1) [debug] term_limits_APT ref_id=none limit=0 14:59:39-27/04 zebrasrv(1) [debug] isamb_pp_close lev=0 returned 0 values, skipped 0 14:59:39-27/04 zebrasrv(1) [debug] isamb_pp_close lev=0 returned 0 values, skipped 246 14:59:39-27/04 zebrasrv(1) [debug] srw_bend_fetch 1 14:59:39-27/04 zebrasrv(1) [debug] retrieve localno=256 score=-1 14:59:39-27/04 zebrasrv(1) [debug] grs_retrieve 14:59:39-27/04 zebrasrv(1) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=record.abs mode=r 14:59:39-27/04 zebrasrv(1) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=bib1.att mode=r 14:59:39-27/04 zebrasrv(1) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=gils.att mode=r 14:59:39-27/04 zebrasrv(1) [debug] data1_fath_fopen path=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en root=NULL file=usmarc.mar mode=r 14:59:39-27/04 zebrasrv(1) [debug] Got regexp: [^@]*/leader/record/$ 14:59:39-27/04 zebrasrv(1) [debug] Created xpath: '/*/controlfield[@tag="001"]' [.. lots of lines like above 2 ..] 14:59:39-27/04 zebrasrv(1) [debug] Created xpath: '/*/datafield[@tag="952"]/subfield[@code="y"]' 14:59:39-27/04 zebrasrv(1) [debug] Got regexp: [^(a)]*/subfield/datafield/.*/$ 14:59:39-27/04 zebrasrv(1) [debug] grs_retrieve: size 14:59:39-27/04 zebrasrv(1) [debug] grs_retrieve: syntax mapping 14:59:39-27/04 zebrasrv(1) [debug] grs_retrieve: schemaIdentifier 14:59:39-27/04 zebrasrv(1) [debug] grs_retrieve: element spec 14:59:39-27/04 zebrasrv(1) [debug] Esetname 'F' in simple compspec 14:59:39-27/04 zebrasrv(1) [debug] Element: all match 14:59:39-27/04 zebrasrv(1) [debug] grs_retrieve: transfer syntax mapping 14:59:39-27/04 zebrasrv(1) [debug] ir_session (output) 14:59:39-27/04 zebrasrv(1) [debug] Wrote PDU, 1757 bytes

1 0

Summary of Connecticut Hack-fest today
by Brendan Gallagher 29 Apr '09

29 Apr '09

Hello Koha - Developers - I just wanted to give a very brief summary of today's Connecticut Koha- Hack-Fest at the Middlebury Public Library. 1. We reviewed git cloning, git commands, and practice for submitting patches. 2. Coding practices for Koha 3. Customizing the look and feel of the OPAC 4. Linux system administration - tips and tricks 5. Resources for learning to "Do-It-Yourself" We are working on some dates for hosting another Koha-Hack-Fest towards the end of May. Most likely a Wednesday or Friday and will shortly send out a request for dates that people in the Northeast of USA may attend. Thanks, Brendan --------------------------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO, Director of Innovation Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting, Complete Support Packages Headquarters: Santa Barbara, CA - Office: West Haven, CT Phone # (203)823-5847 http://bywatersolutions.com info(a)bywatersolutions.com ---------------------------------------------------------------------------------------------------------------------------------

1 0

duedate differences between results and detail
by Wagner, Jane 28 Apr '09

28 Apr '09

I remember discussion about this problem but can't find specifics. In staff mode, the system is sometimes showing a different duedate in the results list than in the detail page. The one on the detail page is correct. It looks as if the results list is using the due_date variable calculated by Search.pm, and the detail page is using the datedue variable calculated by Items.pm. Are these pulling data from different places? I think that's what I'm remembering. If that's the case, does someone have a patch yet? I'm not finding anything on bugzilla that seems to be an exact match for the problem, although #3049 may be close. Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner(a)ptfs.com

1 0

Fixes to opac-search.pl and opac-advsearch.tmpl
by Wagner, Jane 28 Apr '09

28 Apr '09

I've been working on the OPAC advanced search page. I solved the problem of expanded search options not showing up. Now that they do, there's a section called Limit Type To that is puzzling me. Here's a sample entry. <td><input type="checkbox" id="mc-bks" name="limit" value="mc:t" /><label for="mc-bks" title="Books, Pamphlets, Technical reports, Manuscripts, Legal papers, Theses and dissertations"><img border="0" src="/intranet-tmpl/prog/en/images/AF.gif" alt="Books" />Books</label></td> First problem is that the images being called apparently don't exist anywhere, so the screen reads BooksBooks (alt text plus the text). Apart from that, I'm trying to figure out exactly what this is supposed to be searching. If I check the box and then search, I get an error of No results match your search for "mc:t" I'm still trying to learn the zebra stuff, but I couldn't find any reference to any of the mc: whatevers found in the various search elements here. Any idea what this is supposed to be doing? Is this a holdover from an old version that shouldn't be here any more, or something that got added but never worked? Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner(a)ptfs.com

4 8

Due Date check in C4::Circulation::CanBookBeIssued?
by Michael Hafen 28 Apr '09

28 Apr '09

The Due Date check is commented out in CanBookBeIssued. I'm planning uncomment and expand it. Before I do that I want to know why it's commented out. I seem to recall it being a problem for Offline Circ, but looking at process_koc.pl CanBookBeIssued isn't even called. Anyone know about this? -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha

2 5

Should we be cleaning zebraqueue and action_logs tables periodically?
by Michael Hafen 27 Apr '09

27 Apr '09

Please forgive me for pulling this bit from the patches list. I think the relevant discussion should be on this list. On Sat, 2009-04-25 at 13:29 -0400, Ryan Higgins wrote: > If you've never truncated your zebraqueue table, you might want to > update your index and truncate it before applying this patch and running updatedatabase. Truncating the zebraqueue table, as noted by Ryan with this patch, is probably something Koha itself should do periodically. Last time I looked at the cron example I didn't see anything to this end. The data in the table is quite small, but there are still a lot of rows there. This could also be applied to the action_logs table, which holds more data, and has more rows in my installation. Problem is troubleshooting or data retention requirements. I suppose there should be some config option to set a threshold on how old of data should be kept here. Or maybe a system preference could do that job. I for one would like to see Koha clearing these table itself, so there is one less thing for me to take care of. This is especially important to me as I didn't realize before today that these tables would be as large as they are ( as far as number of rows is concerned ). I would say it's safe to assume other system admins also aren't thinking about the size of these tables. Comments please. -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha

3 2

Amazon Documentation Question
by Nicole Engard 27 Apr '09

27 Apr '09

Hi all, With all of the recent Amazon patched, I'm reworking the documentation. I do have one question though. I have this note in several places "IMPORTANT: If this is ON, make sure that GoogleJackets and BakerTaylorEnabled are OFF." Is this still true? If you turn on more than one covers or book service which will work? Or if you have multiple on will you get duplicate info from each service? --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce(a)liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/

2 2

Regional Hack Fest - Connecticut
by Brendan Gallagher 27 Apr '09

27 Apr '09

Hey All -- We will be having a hackfest for Koha this coming Tuesday April 28th at the Middlebury Public Library, in Middlebury, CT 06762. If anyone is in the area and would like to attend please let me know (either on list or off list). We have a room scheduled at the library from 11am until 6pm. We will be providing lunch and caffeine for all those interested in attending. This will be in the style of an unconference, so there is no agenda or anything set. Personally I was interested in clearing a few more bugs and looking to see what bug work we can get moving on. If anyone has any ideas or thoughts - please forward them on. Thanks and I hope to see some of you, Cheers, Brendan --------------------------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO, Director of Innovation Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting, Complete Support Packages Headquarters: Santa Barbara, CA - Office: West Haven, CT Phone # (203)823-5847 http://bywatersolutions.com info(a)bywatersolutions.com ---------------------------------------------------------------------------------------------------------------------------------

4 4

Koha hosting - Zebra issues
by C W Nel 27 Apr '09

27 Apr '09

Can anyone help with tips how to configure zebra in a hosted environment? With other words, how to create another zebra database and what is to be changed in the koha-conf.xml instances? Thanks

2 1