[Koha] Continuting z3950 madness

[Greg Vickers]

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