search returns nothing, yaz-client returns values
We have a koha install that has had some issues (expounded upon below) At the moment, all searches from the webpage return no results. I can do a manual search using yaz-client, and get results. If I go to the "item search", I can see everything there. It appears to me that apache is not communicating with zebra. The koha-zebra is running (I can see it when I do a ps). I have done manual index rebuilds, and it looks like the cron re-indexing is happening. And, as I said, I can manually run yaz-client and get responses. The server is Debian Squeeze on a 64-bit system (actual hardware, not a VM). I am a pretty good techie, but I am new to koha. I will give a short version of the history in case something jumps out as something I did wrong. The server and Koha were installed by outside contractors. Koha was installed by git. The data came from an old version of koha that had crashed and was mangled. I was able to dig through 28,000 records and recover most of the data by repairing the sql by hand. The old version of Koha had a different format for some of the mysql tables. I manually added the fields so it is now the same as what the fresh koha install used. Because some of the sql had been mangled, there were a number of biblio records that threw errors during the zebra rebuild. I removed those records, and now zebra reindexes cleanly. I can do a yaz-client unix:/var/run/zebradb/bibliosocket -c /etc/koha/zebradb/ccl.properties base biblio f something and I get lots of responses that I can "show" I tried using tcp connections instead of sockets. I could connect by yaz-client, but nothing changed with koha. So I went back to sockets. The server is in Africa, and I am helping from the United States, and the Internet is down at the koha site. So I do not have access to the actual running system at the moment. But I am looking for any ideas that might help speed me on my way. I was about to read through the itemsearch.pl code to figure out how itemsearch.pl knows to use the socket or tcp connection, and maybe put in some debugging code to watch it. I saw someone mention that I could increase koha's logging ability and actually capture the queries that were sent to zebra? That would be helpful. - Tim Young
Hi, Il 11/02/2015 18:07, Tim Young ha scritto:
We have a koha install that has had some issues (expounded upon below) At the moment, all searches from the webpage return no results. I can do a manual search using yaz-client, and get results. If I go to the "item search", I can see everything there.
check the system preference 'OpacSuppression' [Opac section] If is on 'Hide', set on 'Don't hide'. And try again. Bye Zeno Tajoli -- Dr. Zeno Tajoli Servizi Innovativi -- Automazione Biblioteche z.tajoli@cineca.it fax +39 02 2135520 CINECA - Sede operativa di Segrate
No, OpacSuppression did not do it. It was already set to "don't hide." But it sounded really nice. Does anyone know how to turn on logging of zebra queries? Is there any way to increase Koha's logging verbosity? - Tim On 2/11/2015 11:43 AM, Tajoli Zeno wrote:
Hi,
check the system preference 'OpacSuppression' [Opac section] If is on 'Hide', set on 'Don't hide'.
And try again.
Bye Zeno Tajoli
Tim Young schreef op do 12-02-2015 om 08:50 [-0600]:
Does anyone know how to turn on logging of zebra queries? Is there any way to increase Koha's logging verbosity?
What I've done in the past is run zebrasrv in the foreground with debug on. I can't remember the details off the top of my head, but to start with start with the command line (and user - koha-shell helps with this) that's in your ps output for zebrasrv, and figure out the option to add debug to it. Then you should see what Koha is doing as it queries. You can increase Koha's verbosity by setting the DEBUG environment variable in the Apache config, but it's hard to say whether that'll actually help you. Also, it'd be handy to add a section about running zebra in debug mode to my slowly growing page here: http://wiki.koha-community.org/wiki/Troubleshooting_Zebra if you felt like it :) -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
Grrr.. Thanks, Robin. I will add some of my zebra findings to the wiki. That helped. First problem was an invalid character in the password. That let me get a little farther. In my apache log file I got: query problem with kw,wrdl,rtrn=mark ZOOM error 10014 "CCL parsing error" (where mark is the word I am trying to search for) Googling that led me to a ccl.properties error, and I made sure I got a good one of those. And I now have results. So much for Occams Razor. Bad libraries, an invalid character in the zebra password (the #, I believe), a changed ccl.properties file. Oh. I did not mention that the permissions were originally set improperly... (sigh) Thanks all for your help! - Tim On 2/12/2015 5:41 PM, Robin Sheat wrote:
Does anyone know how to turn on logging of zebra queries? Is there any way to increase Koha's logging verbosity? What I've done in the past is run zebrasrv in the foreground with debug on. I can't remember the details off the top of my head, but to start with start with the command line (and user - koha-shell helps with this)
Tim Young schreef op do 12-02-2015 om 08:50 [-0600]: that's in your ps output for zebrasrv, and figure out the option to add debug to it. Then you should see what Koha is doing as it queries.
You can increase Koha's verbosity by setting the DEBUG environment variable in the Apache config, but it's hard to say whether that'll actually help you.
Also, it'd be handy to add a section about running zebra in debug mode to my slowly growing page here:
http://wiki.koha-community.org/wiki/Troubleshooting_Zebra
if you felt like it :)
Tim Young schreef op do 12-02-2015 om 21:16 [-0600]:
And I now have results.
Awesome! If you feel like you need to do some Koha development, might I suggest something so that it throws a real error when zebra is malfunctioning, rather than the oh-so-common "0 results found" puzzler? :) -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
participants (3)
-
Robin Sheat -
Tajoli Zeno -
Tim Young