<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi<BR>
I suspect that your<BR>biblionumber and biblioitemnumber are stored in 090$c and 090$d, which<BR>Koha 3 expects by default to be in the 999 $c and $d. To tell Zebra<BR>this, go to the directory where you installed the Koha and Zebra<BR>configuration files and edit<BR>zebradb/marc_defs/marc21/biblios/record.abs. Comment out the<BR>following lines<BR><BR>melm 999$c Local-Number:n,Local-Number:w,Local-Number:s<BR>melm 999$d biblioitemnumber:n,biblioitemnumber:w,biblioitemnumber:s<BR><BR>and add<BR><BR>melm 090$c Local-Number:n,Local-Number:w,Local-Number:s<BR>melm 090$d biblioitemnumber:n,biblioitemnumber:w,biblioitemnumber:s<BR><BR>Then restart your Zebra server and try running rebuild_zebra.pl. <BR>
try it<BR><BR><STRONG>John Smith<BR>International Library of Southiana<BR>IT Supports</STRONG><BR><BR><BR> <BR>
<HR id=stopSpelling>
Date: Mon, 2 Nov 2009 11:35:43 +0400<BR>Subject: Re: [Koha] Please Help: Authority Search - Not returning Result. Zebra Index Picks up 4 Authority Records<BR>From: susan.mustafa@gmail.com<BR>To: smith_me@live.com<BR>CC: koha@lists.katipo.co.nz<BR><BR>
<DIV dir=ltr>
<DIV>I fixed those permissions issues, they were not the problem. It seems indexing does not happen for some reason.</DIV>
<DIV> </DIV>
<DIV>Kindly note below the zebra server log and the indexing log.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>====== STARTING SERVER MANUALLY ===========</DIV>
<DIV><PRE><FONT size=4>11:13:05-02/11 [log] zebra_start /etc/koha/zebradb/zebra-biblios.cfg 1.3.50
11:13:05-02/11 [log] zebra_start /etc/koha/zebradb/zebra-authorities-dom.cfg 1.3.50
11:13:05-02/11 [server] Adding dynamic listener on unix:/var/run/koha/zebradb/bibliosocket id=1
11:13:05-02/11 [server] Adding dynamic listener on unix:/var/run/koha/zebradb/authoritysocket id=2
11:13:05-02/11 [server] Starting server zebrasrv pid=20923
11:14:30-02/11 zebrasrv(1) [session] Session - OK 1 unix:/var/run/koha/zebradb/authoritysocket 26487
11:14:30-02/11 zebrasrv(1) [log] User perm for perm.koha: rw
11:14:30-02/11 zebrasrv(1) [request] Auth idPass koha -
11:14:30-02/11 zebrasrv(1) [request] Init OK - ID:81/81 Name:ZOOM-C/YAZ Version:1.116/2.1.54
11:14:30-02/11 zebrasrv(1) [log] ResultSet '1'
11:14:30-02/11 zebrasrv(1) [debug][log] zebra_register_open rw = 0 useshadow=0 p=0x944db68,n=,rp=(none)
11:14:30-02/11 zebrasrv(1) [log] profilePath=/etc/koha/zebradb/authorities/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/authorities:/etc/koha/zebradb/lang_defs/en:/etc/koha/zebradb/xsl cwd=/var/lib/koha/zebradb/authorities
11:14:30-02/11 zebrasrv(1) [log] 0 keys, 0 sysnos, sort
11:14:30-02/11 zebrasrv(1) [log] term="0" nn=0 type=void count=0
11:14:30-02/11 zebrasrv(1) [log] term="CORPO_NAME" nn=0 type=void count=0
11:14:30-02/11 zebrasrv(1) [log] term="Chris" nn=0 type=void count=0
11:14:30-02/11 zebrasrv(1) [log] user/system: 0/0
11:14:30-02/11 zebrasrv(1) [request] Search authorities ERROR 109 1 1+0 RPN @attrset Bib-1 @or @attr "1=Heading" @attr 7=1 0 @and @attr 5=100 @attr "1=authtype" CORPO_NAME @attr 4=6 @attr 5=1 @attr "1=Heading" Chris
11:14:31-02/11 zebrasrv(1) [session] Connection closed by client
11:14:31-02/11 zebrasrv(1) [debug][log] zebra_register_close p=0x944db68
11:15:04-02/11 zebrasrv(2) [session] Session - OK 2 unix:/var/run/koha/zebradb/authoritysocket 28481
11:15:04-02/11 zebrasrv(2) [log] User perm for perm.koha: rw
11:15:04-02/11 zebrasrv(2) [request] Auth idPass koha -
11:15:04-02/11 zebrasrv(2) [request] Init OK - ID:81/81 Name:ZOOM-C/YAZ Version:1.116/2.1.54
11:15:04-02/11 zebrasrv(2) [log] ResultSet '1'
11:15:04-02/11 zebrasrv(2) [debug][log] zebra_register_open rw = 0 useshadow=0 p=0x944db68,n=,rp=(none)
11:15:04-02/11 zebrasrv(2) [log] profilePath=/etc/koha/zebradb/authorities/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/authorities:/etc/koha/zebradb/lang_defs/en:/etc/koha/zebradb/xsl cwd=/var/lib/koha/zebradb/authorities
11:15:04-02/11 zebrasrv(2) [log] 0 keys, 0 sysnos, sort
11:15:04-02/11 zebrasrv(2) [log] term="0" nn=0 type=void count=0
11:15:04-02/11 zebrasrv(2) [log] term="PERSO_NAME" nn=0 type=void count=0
11:15:04-02/11 zebrasrv(2) [log] term="susan" nn=0 type=void count=0
11:15:04-02/11 zebrasrv(2) [log] user/system: 0/0
11:15:04-02/11 zebrasrv(2) [request] Search authorities ERROR 109 1 1+0 RPN @attrset Bib-1 @or @attr "1=Heading" @attr 7=1 0 @and @attr 5=100 @attr "1=authtype" PERSO_NAME @attr 4=6 @attr 5=1 @attr "1=Heading" susan
11:15:05-02/11 zebrasrv(2) [session] Connection closed by client
11:15:05-02/11 zebrasrv(2) [debug][log] zebra_register_close p=0x944db68</FONT>
</PRE><PRE>=====================================</PRE><PRE> </PRE></DIV>
<DIV>Then looking at the zebra_rebuild -a log i see </DIV>
<DIV> </DIV>
<DIV>===================</DIV>
<DIV> </DIV><PRE>mistuser@MIST-Koha-Test:~$ sudo perl -I /usr/share/koha/lib /usr/share/koha/bin/migration_tools/<A href="http://rebuild_zebra.pl/">rebuild_zebra.pl</A> -aZebra configuration information
================================
Zebra biblio directory = /var/lib/koha/zebradb/biblios
Zebra authorities directory = /var/lib/koha/zebradb/authorities
Koha directory = /usr/share/koha/intranet/cgi-bin
BIBLIONUMBER in : 999$c
BIBLIOITEMNUMBER in : 999$d
================================
====================
exporting authority
====================
1..
Records exported: 3
====================
REINDEXING zebra
====================
11:27:12-02/11 zebraidx(10017) [log] zebra_start /etc/koha/zebradb/zebra-authorities-dom.cfg 1.3.50
11:27:12-02/11 zebraidx(10017) [debug][log] zebra_register_open rw = 1 useshadow=1 p=0x823a058,n=,rp=(none)
11:27:12-02/11 zebraidx(10017) [log] enabling cache spec=/var/lib/koha/zebradb/authorities/shadow:1G
11:27:12-02/11 zebraidx(10017) [log] cache_fname = /var/lib/koha/zebradb/authorities/shadow/cache
11:27:12-02/11 zebraidx(10017) [log] profilePath=/etc/koha/zebradb/authorities/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/authorities:/etc/koha/zebradb/lang_defs/en:/etc/koha/zebradb/xsl cwd=/home/mistuser
11:27:12-02/11 zebraidx(10017) [log] dir /tmp/zzuTCKMwth/authority
11:27:12-02/11 zebraidx(10017) [warn] No such record type: dom./etc/koha/zebradb/authorities/etc/dom-config-marc.xml
11:27:12-02/11 zebraidx(10017) [log] zebra_end_trans
11:27:12-02/11 zebraidx(10017) [log] sorting section 1
11:27:12-02/11 zebraidx(10017) [log] Iterations . . . 30
11:27:12-02/11 zebraidx(10017) [log] Distinct words . 15
11:27:12-02/11 zebraidx(10017) [log] Updates. . . . . 11
11:27:12-02/11 zebraidx(10017) [log] Deletions. . . . 2
11:27:12-02/11 zebraidx(10017) [log] Insertions . . . 2
11:27:12-02/11 zebraidx(10017) [debug][log] zebra_register_close p=0x823a058
11:27:12-02/11 zebraidx(10017) [log] Records: 0 i/u/d 0/0/0
11:27:12-02/11 zebraidx(10017) [log] user/system: 0/0
11:27:12-02/11 zebraidx(10017) [debug][log] zebra_stop
11:27:12-02/11 zebraidx(10017) [log] zebraidx times: 0.03 0.00 0.00
11:27:12-02/11 zebraidx(10020) [log] zebra_start /etc/koha/zebradb/zebra-authorities-dom.cfg 1.3.50
11:27:12-02/11 zebraidx(10020) [log] enabling cache spec=/var/lib/koha/zebradb/authorities/shadow:1G
11:27:12-02/11 zebraidx(10020) [log] cache_fname = /var/lib/koha/zebradb/authorities/shadow/cache
11:27:12-02/11 zebraidx(10020) [log] commit start
11:27:12-02/11 zebraidx(10020) [debug][log] zebra_stop
skipping biblios
====================
CLEANING
====================
</PRE>
===================================<BR>
<DIV> </DIV>
<DIV>I hope someoen can tell me WHY my authority database does not insert data!! As you can see in <SPAN id=ecxtext class=ecxmain-span><FONT style="BACKGROUND: rgb(255,255,255)" color=#000000>11:27:12-02/11 zebraidx(10017) [log] Records: 0 i/u/d 0/0/0</FONT></SPAN></DIV>
<DIV><SPAN class=ecxmain-span></SPAN> </DIV>
<DIV><SPAN class=ecxmain-span></SPAN> </DIV>
<DIV><SPAN class=ecxmain-span>Awaiting all the helpful replies,</SPAN></DIV>
<DIV><SPAN class=ecxmain-span></SPAN> </DIV>
<DIV><SPAN class=ecxmain-span>Thanks</SPAN></DIV>
<DIV><SPAN class=ecxmain-span></SPAN> </DIV>
<DIV> </DIV>
<DIV><BR><BR></DIV>
<DIV class=ecxgmail_quote>On Mon, Nov 2, 2009 at 11:05 AM, john smith <SPAN dir=ltr><<A href="mailto:smith_me@live.com">smith_me@live.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE style="BORDER-LEFT: #ccc 1px solid; PADDING-LEFT: 1ex" class=ecxgmail_quote>
<DIV><BR> Hi <BR>It looks like erro in your permission verify it
<DIV class=ecxim><BR>zebra_lock_create fail fname=/var/lock/koha/zebradb/authorities/shadow..LCK [Permission denied] <BR></DIV>John Smith<BR> <BR>
<HR>
Date: Sun, 1 Nov 2009 19:44:09 +0400<BR>From: <A href="mailto:susan.mustafa@gmail.com">susan.mustafa@gmail.com</A><BR>To: <A href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</A><BR>Subject: [Koha] Please Help: Authority Search - Not returning Result. Zebra Index Picks up 4 Authority Records
<DIV>
<DIV></DIV>
<DIV class=h5><BR><BR><BR>
<DIV dir=ltr>
<DIV>
<DIV dir=ltr>
<DIV><BR>
<DIV dir=ltr>Hi everyone,<BR><BR>I hope I can get a reply soon as it seems this is a very urgent issue and stopping me from going live.<BR><BR>Please note the following problem:<BR><BR>Simple Explanation: I create a new "Personal Name" authority framework, add only enter "Susan M" in Tab 1, Tag @a --Save<BR><BR>Do rebuild_zebra -a -r <-- For rebuilding Authority Indexes. It says exported 4 records, which is correct. I created 4 Authority Records in Koha.<BR><BR>Search Authority in Koha - Drop down [Personal Name]-Contains- Susan <-- Returns Nothing.<BR><BR><BR>-----------------------<BR>Biblios works perfectly fine. Only Authorities do not show in Koha. I really did do my best, but I can't seem to solve it on my own. So any help is greatly appreciated.<BR><BR><BR>Tail - Copy/Paste of koha-err.log<BR>[Sun Nov 01 16:22:41 2009] [error] [client 172.21.255.32] [Sun Nov 1 16:22:41 2009] <A href="http://authorities-home.pl/">authorities-home.pl</A>: oAuth error: Database unavailable (109) authorities Bib-1, referer: <A href="http://172.21.236.24:8080/cgi-bin/koha/authorities/detail.pl?authid=4">http://172.21.236.24:8080/cgi-bin/koha/authorities/detail.pl?authid=4</A><BR>mistuser@MIST-Koha-Dev-V2:/$ <BR><BR>From zebraquedaemon<BR><BR><SPAN><FONT color=#008000><</FONT><FONT style="BACKGROUND: rgb(255,255,255)" color=#000000>Susan-Dev</FONT><FONT color=#008000>></FONT><FONT style="BACKGROUND: rgb(255,255,255)" color=#000000> 13:53:59-15/11 zebrasrv(107) [request] Search authorities ERROR 109 1 1+0 RPN @attrset Bib-1 @or @attr "1=Heading" @attr 7=1 0 @attr 4=6 @attr 5=1 @attr "1=Heading" susan 13:54:00-15/11 zebrasrv(107) [session] Connection closed by client 14:04:21-15/11 zebrasrv(108) [session] Session - OK 108 unix:/var/run/koha/zebradb/authoritysocket 369 14:04:21-15/11 zebrasrv(108) [log] User perm for perm.koha: rw 14:04:21-15/11 zebrasrv(108) [request] Auth idPass koha - 14:04:21-15/11 zebrasrv(108) [request] Init OK - ID:81/81 Name:ZOOM-C/YAZ Version:1.116/2.1.54 14:04:21-15/11 zebrasrv(108) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/authorities/norm..LCK [Permission denied] 14:04:21-15/11 zebrasrv(108) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/authorities/shadow..LCK [Permission denied] 14:04:21-15/11 zebrasrv(108) [request] Search authorities ERROR 109 1 1+0 RPN @attrset Bib-1 @or @attr 2=103 @attr "1=_ALLRECORDS" '' @attr "1=Heading" @attr 7=1 0 14:04:21-15/11 zebrasrv(108) [session] Connection closed by client mistuser@MIST-Koha-Dev-V2:/var/lock/koha/zebradb$ <BR><BR><BR></FONT></SPAN>Hope someone can help me. Please do try :) Don't mind the timestamp differences. I just copied the errors at different times.<BR><BR>I hope someone can help me.<BR><BR>Thank you,<BR><BR><BR></DIV><BR></DIV><BR></DIV></DIV><BR></DIV><BR></DIV></DIV>
<HR>
Windows Live: Make it easier for your friends to see <A href="http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_2:092009">what you’re up to on Facebook.</A></DIV></BLOCKQUOTE></DIV><BR></DIV> <br /><hr />Windows Live: Keep your friends up to date <a href='http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_1:092010' target='_new'>with what you do online.</a></body>
</html>