[Koha] Continuting z3950 madness

[Daehenoc]

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