Koha 3 from non zebra to zebra, if at all possible
While I really do like Koha, I have now run into something I don't seem to be able to solve. The issue is that while I managed to get Koha 3 running without Zebra, it is very sluggish, to a degree that it is barely workable, but I don't seem to be able to get it running WITH zebra. Each and every search results in 'no results found'. Yes, zebra is running (ps -ef | grep returns: biblios@debian:~$ ps -ef | grep zebrasrv koha 2442 1 0 11:55 ? 00:00:00 daemon --name=koha-zebra-ctl.koha --errlog=/var/log/koha/koha-zebradaemon.err --stdout=/var/log/koha/koha-zebradaemon.log --output=/var/log/koha/koha-zebradaemon-output.log --verbose=1 --respawn --delay=30 --user=koha koha -- /usr/bin/zebrasrv -v none,fatal,warn -f /etc/koha/koha-conf.xml koha 2444 2442 0 11:55 ? 00:00:00 /usr/bin/zebrasrv -v none,fatal,warn -f /etc/koha/koha-conf.xml biblios 3278 3173 0 13:25 pts/0 00:00:00 grep zebrasrv) Yes, I have done rebuild_zebra.pl (which ALWAYS ends with zebraidx[3185] [warn] Record didn't contain match fields in (bibl,Local-number) , is it supposed to? ) I also restored the kohastructure.sql on somebody's advice. No gain there. I have a backup file from my nozebra box, but no matter what I do, after restoring it, it never runs with zebra. Backup files are made with mysqldump Koha > date_koha.sql from the nozebra box, then restoring it with koha < date_koha.sql. This obviously does restore my database, but also includes all nozebra settings. koha error logs: biblios@debian:/var/log/koha$ cat koha-zebraqueue.err 20100116 19:32:48 koha-zebraqueue-ctl-koha: client (pid 28978) killed by signal 15, stopping 20100116 21:36:12 koha-zebraqueue-ctl-koha: client (pid 2413) killed by signal 15, stopping 20100203 10:30:58 koha-zebraqueue-ctl-koha: client (pid 2384) killed by signal 15, stopping 20100203 11:54:49 koha-zebraqueue-ctl-koha: client (pid 2387) killed by signal 15, stopping biblios@debian:/var/log/koha$ cat koha-zebraqueue-output.log DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at /usr/share/koha/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/bin/zebraqueue_daemon.pl line 124. apache2 error logs (truncated); [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value in split at /usr/share/koha/lib/C4/Languages.pm line 126. [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value $string in pattern match (m//) at /usr/share/koha/lib/C4/Languages.pm line 411. [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value $current_language in string eq at /usr/share/koha/lib/C4/Languages.pm line 288. [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value $current_language in string eq at /usr/share/koha/lib/C4/Languages.pm line 288. [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value in hash element at /usr/share/koha/lib/C4/Languages.pm line 294. [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value in hash element at /usr/share/koha/lib/C4/Languages.pm line 295. [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value in string eq at /usr/share/koha/lib/C4/Languages.pm line 306. [Wed Feb 3 13:21:44 2010] install.pl: INSERT Version at /usr/share/koha/lib/C4/Installer.pm line 518. So, maybe I am not too bright and miss something obvious, but I CANNOT find it. Please help me figure this one out, thanks, Marty __________________________________________________________________ The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/
Marty <ontariowolf64@yahoo.com>
I have done rebuild_zebra.pl (which ALWAYS ends with zebraidx[3185] [warn] Record didn't contain match fields in (bibl,Local-number) , is it supposed to? ) [...] Please help me figure this one out, thanks,
I'm grasping at straws and don't have free time to help solve this properly, but I think no-one else has replied, so I'll point you in the direction I'd start: 1. use the Koha-MARC mapping check in the Administration pages; 2. try searching zebra from the command-line with yaz-client Searching this list archive should help find more detailed instruction on how to do either of those. Hope that helps, -- MJ Ray (slef) Webmaster and LMS developer at | software www.software.coop http://mjr.towers.org.uk | .... co IMO only: see http://mjr.towers.org.uk/email.html | .... op
Hi, 2010/2/3 Marty <ontariowolf64@yahoo.com>
Yes, I have done rebuild_zebra.pl (which ALWAYS ends with zebraidx[3185] [warn] Record didn't contain match fields in (bibl,Local-number) , is it supposed to? )
This indicates a mismatch between the MARC tag containing the bib ID (biblio.biblionumber) as set in your frameworks vs. what Zebra is expecting. If you're using MARC21, by default Zebra expects that the local-number will be in the 999$c. Is that what your frameworks map biblio.biblionumber to? If not, the easiest thing to do would be to edit record.abs for your MARC flavor and replace the melm 999$c line with something like: melm 090$9 Local-Number:n,Local-Number:w,Local-Number:s The specific subfield and tag depending on what your framework mappings are set to, of course. Regards, Galen -- Galen Charlton gmcharlt@gmail.com
Yo, thank you, you genius! That solved EVERYTHING! Thank you sooo much! (it took me a while to get back to it, was busy with work) Thanks again, Marty --- On Tue, 2/9/10, Galen Charlton <gmcharlt@gmail.com> wrote: From: Galen Charlton <gmcharlt@gmail.com> Subject: Re: [Koha] Koha 3 from non zebra to zebra, if at all possible To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Tuesday, February 9, 2010, 9:06 AM Hi, 2010/2/3 Marty <ontariowolf64@yahoo.com>
Yes, I have done rebuild_zebra.pl (which ALWAYS ends with zebraidx[3185] [warn] Record didn't contain match fields in (bibl,Local-number) , is it supposed to? )
This indicates a mismatch between the MARC tag containing the bib ID (biblio.biblionumber) as set in your frameworks vs. what Zebra is expecting. If you're using MARC21, by default Zebra expects that the local-number will be in the 999$c. Is that what your frameworks map biblio.biblionumber to? If not, the easiest thing to do would be to edit record.abs for your MARC flavor and replace the melm 999$c line with something like: melm 090$9 Local-Number:n,Local-Number:w,Local-Number:s The specific subfield and tag depending on what your framework mappings are set to, of course. Regards, Galen -- Galen Charlton gmcharlt@gmail.com __________________________________________________________________ Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now http://ca.toolbar.yahoo.com.
I'm trying to do the same thing (switch to Zebra from a non-zebra system). How did you initially configure the Zebra? I'm stuck with some variables that I don't know how to set. Marty-33 wrote:
While I really do like Koha, I have now run into something I don't seem to be able to solve.
The issue is that while I managed to get Koha 3 running without Zebra, it is very sluggish, to a degree that it is barely workable, but I don't seem to be able to get it running WITH zebra. Each and every search results in 'no results found'.
Yes, zebra is running (ps -ef | grep returns: biblios@debian:~$ ps -ef | grep zebrasrv koha 2442 1 0 11:55 ? 00:00:00 daemon --name=koha-zebra-ctl.koha --errlog=/var/log/koha/koha-zebradaemon.err --stdout=/var/log/koha/koha-zebradaemon.log --output=/var/log/koha/koha-zebradaemon-output.log --verbose=1 --respawn --delay=30 --user=koha koha -- /usr/bin/zebrasrv -v none,fatal,warn -f /etc/koha/koha-conf.xml koha 2444 2442 0 11:55 ? 00:00:00 /usr/bin/zebrasrv -v none,fatal,warn -f /etc/koha/koha-conf.xml biblios 3278 3173 0 13:25 pts/0 00:00:00 grep zebrasrv)
Yes, I have done rebuild_zebra.pl (which ALWAYS ends with zebraidx[3185] [warn] Record didn't contain match fields in (bibl,Local-number) , is it supposed to? )
I also restored the kohastructure.sql on somebody's advice. No gain there.
I have a backup file from my nozebra box, but no matter what I do, after restoring it, it never runs with zebra. Backup files are made with mysqldump Koha > date_koha.sql from the nozebra box, then restoring it with koha < date_koha.sql. This obviously does restore my database, but also includes all nozebra settings.
koha error logs: biblios@debian:/var/log/koha$ cat koha-zebraqueue.err 20100116 19:32:48 koha-zebraqueue-ctl-koha: client (pid 28978) killed by signal 15, stopping 20100116 21:36:12 koha-zebraqueue-ctl-koha: client (pid 2413) killed by signal 15, stopping 20100203 10:30:58 koha-zebraqueue-ctl-koha: client (pid 2384) killed by signal 15, stopping 20100203 11:54:49 koha-zebraqueue-ctl-koha: client (pid 2387) killed by signal 15, stopping
biblios@debian:/var/log/koha$ cat koha-zebraqueue-output.log DBD::mysql::st execute failed: Table 'koha.zebraqueue' doesn't exist at /usr/share/koha/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/bin/zebraqueue_daemon.pl line 124.
apache2 error logs (truncated); [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value in split at /usr/share/koha/lib/C4/Languages.pm line 126. [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value $string in pattern match (m//) at /usr/share/koha/lib/C4/Languages.pm line 411. [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value $current_language in string eq at /usr/share/koha/lib/C4/Languages.pm line 288. [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value $current_language in string eq at /usr/share/koha/lib/C4/Languages.pm line 288. [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value in hash element at /usr/share/koha/lib/C4/Languages.pm line 294. [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value in hash element at /usr/share/koha/lib/C4/Languages.pm line 295. [Wed Feb 3 13:18:49 2010] install.pl: Use of uninitialized value in string eq at /usr/share/koha/lib/C4/Languages.pm line 306. [Wed Feb 3 13:21:44 2010] install.pl: INSERT Version at /usr/share/koha/lib/C4/Installer.pm line 518.
So, maybe I am not too bright and miss something obvious, but I CANNOT find it. Please help me figure this one out, thanks,
Marty
__________________________________________________________________ The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/ _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://old.nabble.com/Koha-3-from-non-zebra-to-zebra%2C-if-at-all-possible-t... Sent from the Koha - Discuss mailing list archive at Nabble.com.
participants (4)
-
Galen Charlton -
Marty -
MJ Ray -
PasiK