[Koha] Please Help: Authority Search - Not returning Result. Zebra Index Picks up 4 Authority Records

john smith smith_me at live.com
Mon Nov 2 20:41:08 NZDT 2009


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 at gmail.com
To: smith_me at live.com
CC: koha at 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 at 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 at 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 at gmail.com
To: koha at 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 at MIST-Koha-Dev-V2:/$ 



More information about the Koha mailing list