Hi all, I'm still getting the problem below, are there Koha developers on this list (ideally the person who wrote Breeding.pm??) who might be able to help me with this one? The library I have installed this for would really like to make use of this feature and it is frustrating for them and I that we can't get it working. I do have a bit of an update, the apache error messages appear even when processz3950queue is not running - so I guess it's a problem with the Breeding.pm module. If anyone has any suggestions I can try, I'm all ears! :) Thanks, Greg Greg Vickers wrote:
Hi all,
I am still trying to get the biblio search working with this z39.50 daemon. I click on Catalogue, then 'Add biblio', then enter some data in the title and isbn fields, and click the Go button. The search fails to return any information and I click the 'Add New Biblio' button. From that screen I click on the 'z3950 search' and get the 'Z3950 Search Results' window up with the 'Still ?? requests to go' information bar.
I find in the following files:
#tail /usr/local/koha/log/z3950-daemon-20060519-0953.log DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 140. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 143. DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 148. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 149.
and in #tail /var/log/apache/koha/koha-error.log 220.239.73.84 - - [07/Jun/2006:22:01:43 +1000] "GET /cgi-bin/koha/z3950/search.pl?bibid=&random= HTTP/1.1" 200 1526 220.239.73.84 - - [07/Jun/2006:22:01:43 +1000] "GET /intranet-tmpl/default/en/includes/common-style.css HTTP/1.1" 200 7431 DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /usr/local/koha/intranet/modules/C4/Breeding.pm line 167. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Breeding.pm line 168.
So I know the z3950 daemon is running and I walked through all the scripts that are used to call it and I know it is passed all the correct environment information: #cat /usr/local/koha/intranet/scripts/z3950daemon/z3950-daemon-options RunAsUser=www-data KohaZ3950Dir=/usr/local/koha/intranet/scripts/z3950daemon KohaModuleDir=/usr/local/koha/intranet/modules LogDir=/usr/local/koha/log
It looks like the z3950 daemon doesn't know how to talk to the local mysql server - is there a place that I have to give the z3950 daemon a username and password for accessing the mysql database?
Thanks, Greg _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha