<div dir="ltr"><div>Hi John,</div>
<div> </div>
<div>This is an issue of authorities. My biblios export fine and I am able to search them also fine. Authorities are in their own different database right? and they should not be effected by Biblios??? </div>
<div> </div>
<div>I don't know if I am making any sense..</div>
<div> </div>
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">On Mon, Nov 2, 2009 at 11:41 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; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>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 <a href="http://rebuild_zebra.pl/" target="_blank">rebuild_zebra.pl</a>. <br>
try it<br><br><strong>John Smith<br>International Library of Southiana<br>IT Supports</strong><br><br><br> <br>
<hr>
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
<div class="im"><br>From: <a href="mailto:susan.mustafa@gmail.com" target="_blank">susan.mustafa@gmail.com</a><br></div>To: <a href="mailto:smith_me@live.com" target="_blank">smith_me@live.com</a><br>CC: <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a>
<div>
<div></div>
<div class="h5"><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/" target="_blank">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><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></span> </div>
<div><span></span> </div>
<div><span>Awaiting all the helpful replies,</span></div>
<div><span></span> </div>
<div><span>Thanks</span></div>
<div><span></span> </div>
<div> </div>
<div><br><br></div>
<div>On Mon, Nov 2, 2009 at 11:05 AM, john smith <span dir="ltr"><<a href="mailto:smith_me@live.com" target="_blank">smith_me@live.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; PADDING-LEFT: 1ex">
<div><br> Hi <br>It looks like erro in your permission verify it
<div><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" target="_blank">susan.mustafa@gmail.com</a><br>To: <a href="mailto:koha@lists.katipo.co.nz" target="_blank">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><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/" target="_blank">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" target="_blank">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" target="_blank">what you’re up to on Facebook.</a></div>
</blockquote></div><br></div><br></div></div>
<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="_blank">with what you do online.</a></div>
</blockquote></div><br></div>