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

View: New views
15 Messages — Rating Filter:   Alert me  

Parent Message unknown Please Help: Authority Search - Not returning Result. Zebra Index Picks up 4 Authority Records

by Susan Mustafa :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


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@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by Bernardo Gonzalez Kriegel :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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@...>

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@...
http://lists.katipo.co.nz/mailman/listinfo/koha



_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by Susan Mustafa :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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@...> 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@...>

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@...
http://lists.katipo.co.nz/mailman/listinfo/koha




_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by Frederic Demians :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


> 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

_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by Susan Mustafa :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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@...> 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



_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by Frederic Demians :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

 
> 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.
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by john smith-108 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

 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@...
To: koha@...
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.
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by Susan Mustafa :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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@...> 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@...
To: koha@...
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.


_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by john smith-108 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.
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@...
To: smith_me@...
CC: koha@...

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@...> 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@...
To: koha@...
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.
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by Susan Mustafa :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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@...> 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 To: smith_me@...
CC: koha@...


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@...> 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@...
To: koha@...
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.


_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

Parent Message unknown Re: Please Help: Authority Search - Not returning Result. Zebra Index Picks up 4 Authority Records

by Susan Mustafa :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Good Day Frederic,

Kindly tell me how do I disable the Authority? in Koha?

Right now, if we try to create a new Marc Record, start from empty record, and go to the tag that have to put a Author Personal Name for example, it GREYS the box, and ONLY a popup window can be used to search for an already existing authority??

Can you tell me how I disable this popup window and simply make Koha understand simple text rather than Authority??

I hope I am making sense.

Would you recommend that I re-install to keep with future changes?? Because it took me a long time to setup Koha, since I am a beginner and really worried that it would delay the project from going live even more.

Someone today in IRC mentioned that I am using the old version of idzebra when I should be using idzebra-2.0, so I think tomorrow morning my time i will try that..and keep you guys on the loop.

Please do remember me if you come across aything related to this, Thanks alot



2009/11/2 Frédéric DEMIANS <f.demians@...>
Your Koha installation is messed up for whatever reason. I recommend you reinstalling everything. The best installation documentation, and most up-to-date, is INSTALL.debian-lenny. I've seen on IRC that you customized your template. Avoid that if you don't know how to track your modifications with a code version control program like git. Otherwise, you won't be able to upgrade to Koha newer version, which is very important for a software like Koha.

Another option is to disable completely authorities (in Framework), as suggested by Chris. Believe me, if your catalog is small, authority management is a nonsense. We have lot of small libraries using Koha without authorities for the sake of users!

Hope it helps.

--
Frédéric DEMIANS
http://www.tamil.fr/u/fdemians.html



_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by Beda Szukics-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Susan

Susan Mustafa schrieb:
> Kindly tell me how do I disable the Authority? in Koha?

Go to Koha Administration->MARC Framework and select "MARC structure"
for the framework you are using.

There search the tag you have problems with (e.g. 100), select
"subfields", click on "Edit Subfields", select the subfield (usually
"a"), select "display more constraints" and at the bottom you will see
"Other Options" with "Thesaurus: PERSO_NAME". Change that to blank using
the pull-down-menu and you should be happy :-)

You have to do that for every framework and for every field wich might
use authority control (there are quite a few).


Or you can start over installing koha and deselect in the web-installer
authority-control. (I'm not quite sure, but I think the easiest way to
do that consists in dropping your database in mysql and recreating it
manually - but I have never tried that!).


Greetings               Beda
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by Suchetha Wijenayake-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

this sounds WAY too much like a question i am facing right now

we are adding books to the library, and have got past the books that
have MARC records already available.

which means that we are starting to write our own records (help!!)

the problem is we can't write an author name into it (100a)

i am trying to figure it out, but i am right now without a clue.

can someone
a. talk me through it
b. send me a link that will talk me through it

thank you all

Suchetha

On Tue, Nov 3, 2009 at 2:37 PM, Beda Szukics <beda@...> wrote:

> Hi Susan
>
> Susan Mustafa schrieb:
>> Kindly tell me how do I disable the Authority? in Koha?
>
> Go to Koha Administration->MARC Framework and select "MARC structure"
> for the framework you are using.
>
> There search the tag you have problems with (e.g. 100), select
> "subfields", click on "Edit Subfields", select the subfield (usually
> "a"), select "display more constraints" and at the bottom you will see
> "Other Options" with "Thesaurus: PERSO_NAME". Change that to blank using
> the pull-down-menu and you should be happy :-)
>
> You have to do that for every framework and for every field wich might
> use authority control (there are quite a few).
>
>
> Or you can start over installing koha and deselect in the web-installer
> authority-control. (I'm not quite sure, but I think the easiest way to
> do that consists in dropping your database in mysql and recreating it
> manually - but I have never tried that!).
>
>
> Greetings               Beda
> _______________________________________________
> Koha mailing list
> Koha@...
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



--
Check my photo album:
http://picasaweb.google.com/suchetha

Rants Raves and Miscellaneous Musings:
http://raramimu.blogspot.com

Why do I smell brimstone? And what am I doing in this hand-basket?
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by Ian Bays :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,
Quoting from a few of Nicole's previous posts on exactly this subject:

"To add to Ben's answer - if you don't want to use authorities - you
don't have to - see this FAQ:

http://koha.org/documentation/faq/why-cant-i-enter-a-value-in-the-100-field

Nicole
"
----- Original Message -----
From: "Suchetha Wijenayake" <suchetha@...>
To: "Beda Szukics" <beda@...>
Cc: <koha@...>
Sent: Tuesday, November 03, 2009 9:27 AM
Subject: Re: [Koha] Please Help: Authority Search - Not returning
Result.Zebra Index Picks up 4 Authority Records


> this sounds WAY too much like a question i am facing right now
>
> we are adding books to the library, and have got past the books that
> have MARC records already available.
>
> which means that we are starting to write our own records (help!!)
>
> the problem is we can't write an author name into it (100a)

_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

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

by Suchetha Wijenayake-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Thank you very much.

that did the trick

Suchetha

On Tue, Nov 3, 2009 at 3:59 PM, Ian  Bays <ian.bays@...> wrote:

> Hi,
> Quoting from a few of Nicole's previous posts on exactly this subject:
>
> "To add to Ben's answer - if you don't want to use authorities - you
> don't have to - see this FAQ:
>
> http://koha.org/documentation/faq/why-cant-i-enter-a-value-in-the-100-field
>
> Nicole
> "
> ----- Original Message -----
> From: "Suchetha Wijenayake" <suchetha@...>
> To: "Beda Szukics" <beda@...>
> Cc: <koha@...>
> Sent: Tuesday, November 03, 2009 9:27 AM
> Subject: Re: [Koha] Please Help: Authority Search - Not returning
> Result.Zebra Index Picks up 4 Authority Records
>
>
>> this sounds WAY too much like a question i am facing right now
>>
>> we are adding books to the library, and have got past the books that
>> have MARC records already available.
>>
>> which means that we are starting to write our own records (help!!)
>>
>> the problem is we can't write an author name into it (100a)
>
> _______________________________________________
> Koha mailing list
> Koha@...
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



--
Check my photo album:
http://picasaweb.google.com/suchetha

Rants Raves and Miscellaneous Musings:
http://raramimu.blogspot.com

Why do I smell brimstone? And what am I doing in this hand-basket?
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha