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,
This is an old bug. Not as a fix, but to do that authorities search work do the following: Edit AuthoritiesMarc.pm (usually at /usr/share/koha/lib/C4/AuthoritiesMarc.pm), search for "Heading-Main" (on koha 3.0.3 is on line 223) and replace with "Heading", same value as 2 lines below ( it looks like '$attr =" \@attr 1=Heading ";'), and voilà! authorities search work. works for me. bgk PS: This a "solution" that I find googling around. Perhaps there is no many people that use authorities with koha, or we are doing things very bad, or I don't know how to work out a proper solution. 2009/11/1 Susan Mustafa <susan.mustafa@gmail.com>
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,
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi, Actually that is the the issue in my case. This bug is fixed on my version of Koha, since in the code, I only see "Heading", not "Main Heading". I am really unsure of what to do? For some reason, it is not picking up from the database. The biblios work, but the Authorities don't...why? I don't know. The export from rebuild_zebra exports 4 records [Which is how many authorities I have] Hope someone can help me out with this, On Mon, Nov 2, 2009 at 12:13 AM, Bernardo Gonzalez Kriegel < gonzalez@famaf.unc.edu.ar> wrote:
This is an old bug. Not as a fix, but to do that authorities search work do the following:
Edit AuthoritiesMarc.pm (usually at /usr/share/koha/lib/C4/AuthoritiesMarc.pm), search for "Heading-Main" (on koha 3.0.3 is on line 223) and replace with "Heading", same value as 2 lines below ( it looks like '$attr =" \@attr 1=Heading ";'), and voilà! authorities search work.
works for me. bgk
PS: This a "solution" that I find googling around. Perhaps there is no many people that use authorities with koha, or we are doing things very bad, or I don't know how to work out a proper solution.
2009/11/1 Susan Mustafa <susan.mustafa@gmail.com>
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,
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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]
Have you verified zebrasrv rights on those two files? -- Frédéric
Hi, What I did was simply do chmod 777 on those files. The user who owns them is koha. I don't know how to see if zebrasrv has permissions on file d things, this error does not show anymore for me. What shows when I do search is the following: In my koha-zebraqueue-output.file I see a bunch of DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at /usr/share/koha/bin/zebraqueue_daemon.pl line 284. exiting, over 100 posponed indexing update at /usr/share/koha/bin/ zebraqueue_daemon.pl line 362 exiting, over 100 posponed indexing update at /usr/share/koha/bin/ zebraqueue_daemon.pl line 362 exiting, over 100 posponed indexing update at /usr/share/koha/bin/ zebraqueue_daemon.pl line 362 exiting, over 100 posponed indexing update at /usr/share/koha/bin/ zebraqueue_daemon.pl line 362 exiting, over 100 posponed indexing update at /usr/share/koha/bin/ zebraqueue_daemon.pl line 362 On Mon, Nov 2, 2009 at 10:17 AM, Frederic Demians <frederic@tamil.fr> wrote:
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]
Have you verified zebrasrv rights on those two files?
-- Frédéric
I see a bunch of DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at /usr/share/koha/bin/zebraqueue_daemon.pl <http://zebraqueue_daemon.pl> line 284.
zebraqueue_daemon.pl SHOULD NOT be used anymore. Instead use rebuild_zebra.pl.
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/soc...
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>
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. _________________________________________________________________ Windows Live: Keep your friends up to date with what you do online. http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/soc...
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>
participants (4)
-
Bernardo Gonzalez Kriegel -
Frederic Demians -
john smith -
Susan Mustafa