Hi John, 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??? I don't know if I am making any sense.. On Mon, Nov 2, 2009 at 11:41 AM, john smith <smith_me@live.com> wrote:
Hi I suspect that your biblionumber and biblioitemnumber are stored in 090$c and 090$d, which Koha 3 expects by default to be in the 999 $c and $d. To tell Zebra this, go to the directory where you installed the Koha and Zebra configuration files and edit zebradb/marc_defs/marc21/biblios/record.abs. Comment out the following lines
melm 999$c Local-Number:n,Local-Number:w,Local-Number:s melm 999$d biblioitemnumber:n,biblioitemnumber:w,biblioitemnumber:s
and add
melm 090$c Local-Number:n,Local-Number:w,Local-Number:s melm 090$d biblioitemnumber:n,biblioitemnumber:w,biblioitemnumber:s
Then restart your Zebra server and try running rebuild_zebra.pl. try it
*John Smith International Library of Southiana IT Supports*
------------------------------ Date: Mon, 2 Nov 2009 11:35:43 +0400 Subject: Re: [Koha] Please Help: Authority Search - Not returning Result. Zebra Index Picks up 4 Authority Records
From: susan.mustafa@gmail.com To: smith_me@live.com CC: koha@lists.katipo.co.nz
I fixed those permissions issues, they were not the problem. It seems indexing does not happen for some reason.
Kindly note below the zebra server log and the indexing log.
====== STARTING SERVER MANUALLY ===========
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
=====================================
Then looking at the zebra_rebuild -a log i see
===================
mistuser@MIST-Koha-Test:~$ sudo perl -I /usr/share/koha/lib /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -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 ====================
===================================
I hope someoen can tell me WHY my authority database does not insert data!! As you can see in 11:27:12-02/11 zebraidx(10017) [log] Records: 0 i/u/d 0/0/0
Awaiting all the helpful replies,
Thanks
On Mon, Nov 2, 2009 at 11:05 AM, john smith <smith_me@live.com> wrote:
Hi It looks like erro in your permission verify it
zebra_lock_create fail fname=/var/lock/koha/zebradb/authorities/shadow..LCK [Permission denied] John Smith
------------------------------ Date: Sun, 1 Nov 2009 19:44:09 +0400 From: susan.mustafa@gmail.com To: koha@lists.katipo.co.nz Subject: [Koha] Please Help: Authority Search - Not returning Result. Zebra Index Picks up 4 Authority Records
Hi everyone,
I hope I can get a reply soon as it seems this is a very urgent issue and stopping me from going live.
Please note the following problem:
Simple Explanation: I create a new "Personal Name" authority framework, add only enter "Susan M" in Tab 1, Tag @a --Save
Do rebuild_zebra -a -r <-- For rebuilding Authority Indexes. It says exported 4 records, which is correct. I created 4 Authority Records in Koha.
Search Authority in Koha - Drop down [Personal Name]-Contains- Susan <-- Returns Nothing.
----------------------- 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.
Tail - Copy/Paste of koha-err.log [Sun Nov 01 16:22:41 2009] [error] [client 172.21.255.32] [Sun Nov 1 16:22:41 2009] authorities-home.pl: oAuth error: Database unavailable (109) authorities Bib-1, referer: http://172.21.236.24:8080/cgi-bin/koha/authorities/detail.pl?authid=4 mistuser@MIST-Koha-Dev-V2:/$
From zebraquedaemon
<Susan-Dev> 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$
Hope someone can help me. Please do try :) Don't mind the timestamp differences. I just copied the errors at different times.
I hope someone can help me.
Thank you,
------------------------------ Windows Live: Make it easier for your friends to see what you’re up to on Facebook.<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>
------------------------------ Windows Live: Keep your friends up to date with what you do online.<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>