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

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

Proposed fixes for XSLT files
by Wagner, Jane 27 Apr '09

27 Apr '09

I'm working on several changes to the XSLT files for hitlist and individual record display. Some of them are listed as bugs, while others should probably be so listed. We also have some that are individual to the site; I thought I'd fix the overall problems and send a patch, then do the site's changes. Before I send a patch, I want to run my proposed fixes by everyone. Bug 2822 for leader6 types of i (nonmusical) or j (musical), the hitlist uses an icon and label of Sound while the record display page uses Music. Modified record display to use Sound. Bug 2551 for leader7 type of i says it's type Serial which is incorrect. The bug report suggested Integrating Resource" but the latest install's hitlist page uses Continuing Resource. Changed the record display page to also use Continuing Resource. Not reported as a bug, but we've run into it and I should create a bug report -- if you have a 110 or 710 with a subfield a and a subfield b, there's no space between them (on either hitlist or record display). The two headings run together in the display. Modified the utils file to force a space. Bug 2771 asks to have the 245 subfields a,b,p,n display. The latest files seem to have a,b,h in the hitlist and a,b,h,f,g,k,n,p,s in the record display page. Does that meet the need, or should I add n and p to the hitlist page while I'm at it? I have two other bug reports in which I haven't quite figured out how to do yet -- making the XSLT pages obey the sysprefs for opening URLs in new windows and substituting URL link text. 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

2 2

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

27 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

FW: [Koha] Modifying Field's Data Type In the Koha Database
by Irma Birchall 27 Apr '09

27 Apr '09

_____ From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Melanie Saldua Sent: Monday, 27 April 2009 11:16 AM To: koha(a)lists.katipo.co.nz Subject: [Koha] Modifying Field's Data Type In the Koha Database Hello! I'm a new koha user and I'm trying to migrate my existing database to the koha database. I was wondering if it is possible to change the data type of the fields in the koha database? I need to modify biblionumber's data type from int(11) to bigint(100). Is there a faster way to do it than modify every table?

1 0

Last Koha development version (from git) mentions missing prerequisites that are already installed
by Ricardo Dias Marques 24 Apr '09

24 Apr '09

Hi list, I'm updating a local Koha installation from "git" to the last commit available at this time (commit 8f95ec3dbef2cf9bf214fb2b25587f2bb4ebba15 sent by Owen Leonard, submitted on 20-Apr-2009, "Fix for Bug 3119: Add due date to the patron circulation history window"). In order to do this, I did a "git pull". I got the expected many lines of "Getting index for pack", "got", "walk", "create mode", "delete"... After doing this, I ran the following command: myhost:~/mykohaclone # perl Makefile.PL --prev-install-log /root/my-koha-head/misc/koha-install-log That command produced the expected output, EXCEPT for the last lines (that have some information that seems correct BUT other info seems wrong): _____________________ [Wed Apr 22 11:52:18 2009] Makefile.PL: Warning: prerequisite DBD::SQLite 1.13 not found. We have 1.11. [Wed Apr 22 11:52:18 2009] Makefile.PL: Warning: prerequisite Date::ICal 1.72 not found. [Wed Apr 22 11:52:18 2009] Makefile.PL: Warning: prerequisite HTTP::OAI 3.2 not found. [Wed Apr 22 11:52:19 2009] Makefile.PL: Warning: prerequisite JSON 2.07 not found. [Wed Apr 22 11:52:20 2009] Makefile.PL: Warning: prerequisite SMS::Send 0.05 not found. [Wed Apr 22 11:52:21 2009] Makefile.PL: Warning: prerequisite XML::SAX::Writer 0.44 not found. Writing Makefile for koha _____________________ OK. My setup is a Linux virtual machine, running SLES (SUSE Linux Enterprise Server) 10 with SP2 (Service Pack 2) installed. It is true that I had DBD::SQLite v1.11 installed in the past, from a RPM package for SLES: myhost:~/mykohaclone # rpm -qa | grep -i perl-dbd-sqlite perl-DBD-SQLite-1.11-14.6 So this first "Warning" line seems CORRECT: I have DBD::SQLite 1.11 installed, but I now need DBD::SQLite 1.13. OK, no problem. I installed it from CPAN. Now, the PROBLEM is in the 2nd line. I already have Date::ICal version 1.72 installed, also from a RPM package for SLES: myhost:~/mykohaclone # rpm -qa | grep -i perl-date-ical perl-Date-ICal-1.72-2.1 This seems to be confirmed by running the following command: myhost:~/mykohaclone # locate ICal | grep -i date /root/mykohaclone/perl-Date-ICal-1.72-2.1.i586.rpm /usr/lib/perl5/vendor_perl/5.8.8/Date/ICal /usr/lib/perl5/vendor_perl/5.8.8/Date/ICal/Duration.pm /usr/lib/perl5/vendor_perl/5.8.8/Date/ICal.pm /usr/share/doc/packages/perl-Date-ICal /usr/share/doc/packages/perl-Date-ICal/Changes /usr/share/doc/packages/perl-Date-ICal/README /usr/share/man/man3/Date::ICal.3pm.gz /usr/share/man/man3/Date::ICal::Duration.3pm.gz /var/adm/perl-modules/perl-Date-ICal So, is this "Warning", during Koha installation, WRONG (regarding Date::ICal not being installed)? I have the same problem with SMS::Send. I already have SMS::Send version 0.05 installed by RPM: myhost:~/mykohaclone # rpm -qa | grep -i sms perl-SMS-Send-0.05-3.2 But, as I pointed out above, I also got a Warning message, in this Koha update, saying that "[Wed Apr 22 11:52:20 2009] Makefile.PL: Warning: prerequisite SMS::Send 0.05 not found. " What do you think about this? Thanks in advance. Cheers, Ricardo Dias Marques lists AT ricmarques DOT net Installation Guide for Installing Koha 3 on openSUSE 11 http://wiki.koha.org/doku.php?id=opensuse_11.0

3 5

Koha Con Survey
by Nicole Engard 24 Apr '09

24 Apr '09

Here is the right link to this survey: https://spreadsheets.google.com/viewform?formkey=cFJWZm83SlZudDQ1bWI3Z2pBal… --- 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/

1 0

Fwd: KohaCon 2009 Feedback and update!
by dschust1＠tx.rr.com 24 Apr '09

24 Apr '09

Please forgive all the cross posting - I wanted to give everyone the opportunity to provide feedback to KohaCon2009 - even if you didn't attend - but also to provide the community information about the sessions!

3 3

Regional Hackfests
by Chris Cormack 24 Apr '09

24 Apr '09

Hi All After coming back home from the Koha conference and following developer conference. I have been thinking how productive and useful it was for the developers to be in a room together. Now as we are spread across the globe this is not able to occur very often, but what we could do is try to organise regional hack fests. I'm just throwing the idea out there at this point, without any concrete ideas of how it could work. Here in wellington nz we have super happy dev house http://superhappydevhouse.org.nz/ and I know this is based on the same idea in the US. One day, in a bar or a hotel or somewhere with wifi, that doesnt charge much, where developers can get together and throw ideas around. Anyway, it's just an idea at this point to see if there is any enthusiasm. I know that I plan to get together with Mason and Bob in Wellington, and whoever else is interested. Chris

7 6

Folded plugin on Koha's DokuWiki
by Pablo A. Bianchi 23 Apr '09

23 Apr '09

Hi! Sometimes articles becomes very big but because of their structure is not useful to divide them. Usually the problem is are the portions of source code. It could be great to have the possibility to fold some parts of the article, even to have everything more tidy and clear. For this exist a plugin for DokuWiki: Folded http://www.dokuwiki.org/plugin:folded There is any problem to install it on wiki.koha.org? Cheers, Pablo

2 1

Koha project IRC meeting
by Galen Charlton 22 Apr '09

22 Apr '09

Hi, I would like to call a general meeting on the #koha IRC channel on Wednesday, 6 May 2009 at 19:00 UTC with a nominal finish time of 21:00. I would like to hold this meeting monthly, and I'll arbitrarily pick the first Wednesday of every month. I would appreciate feedback on the time of day I've selected; I'm thinking of rotating the meeting time each month so that no one timezone always ends up having the IRC meeting fall in the middle of the night. Here are some items I would like to discuss. 1. Koha 3.2/tip status and timeline 2. Koha 3.0.x status 3. Koha bugs database 4. KohaCon 2009 report Please use this thread to suggest any other discussion topics. The #koha IRC channel (irc://irc.katipo.co.nz/#koha) can be accessed with the following settings: Server: irc.katipo.co.nz Port: 6667 Chanel: #koha Regards, Galen -- Galen Charlton Koha 3.2 Release Manager VP, Research & Development, LibLime galen.charlton(a)liblime.com p: 1-888-564-2457 x709 skype: gmcharlt

3 3