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
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
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
On Fri, Jun 16, 2006 at 12:51:54PM +1000, Daehenoc said:
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.
Hi Greg Couple of quick questions, so I can be sure that im looking at the right version, what version of Koha do you have installed? 2nd question, what templates are you using default or npl? Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
Hi Chris, Chris Cormack wrote:
On Fri, Jun 16, 2006 at 12:51:54PM +1000, Daehenoc said:
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.
Hi Greg
Couple of quick questions, so I can be sure that im looking at the right version, what version of Koha do you have installed? 2nd question, what templates are you using default or npl?
Thanks for the reply. We're running Koha 2.2.5 and since I don't know what npl is I guess we're running default templates. :p Actually, we installed the Canevas templates now I come to think about it. I'm fairly sure that this problem existed prior to installing the Canevas templates... but the Canevas installation and when we first tried to use the z39.50 daemon was a while ago. Thanks, Greg
On Fri, Jun 16, 2006 at 01:07:52PM +1000, Daehenoc said:
Thanks for the reply. We're running Koha 2.2.5 and since I don't know what npl is I guess we're running default templates. :p Actually, we installed the Canevas templates now I come to think about it.
I'm fairly sure that this problem existed prior to installing the Canevas templates... but the Canevas installation and when we first tried to use the z39.50 daemon was a while ago.
Canevas?? Thats a new one for me :) It looks to me like BreedingSearch is not being passed anything to search on If you look at Breeding.pm Line 167 is $sth->execute(@bind); Before that, could you put warn "query=$query title=$title isbn=$isbn"; And then try a z3950 search and check the error logs it should hopefully show us if the title and/or isbn are being passed through ok. Altho this is just searching the results of previous z3950 searches, so this wont help the actual z3950 searches work. The problem there was the other error. Ive attached a processz3950queue file that may (or may not) fix your disappearing server problem Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
Just a thought, *try* using the NPL templates instead. When I wrote the ccfls templates, z3950 was broken because I hadn't changed a couple lines of code. We know that z3950 works with NPL, so try again using the NPL templates to verify that's not the issue. Kyle On 6/15/06, Chris Cormack <chris@katipo.co.nz> wrote:
On Fri, Jun 16, 2006 at 01:07:52PM +1000, Daehenoc said:
Thanks for the reply. We're running Koha 2.2.5 and since I don't know what npl is I guess we're running default templates. :p Actually, we installed the Canevas templates now I come to think about it.
I'm fairly sure that this problem existed prior to installing the Canevas templates... but the Canevas installation and when we first tried to use the z39.50 daemon was a while ago.
Canevas?? Thats a new one for me :)
It looks to me like BreedingSearch is not being passed anything to search on If you look at Breeding.pm
Line 167 is $sth->execute(@bind);
Before that, could you put
warn "query=$query title=$title isbn=$isbn";
And then try a z3950 search and check the error logs it should hopefully show us if the title and/or isbn are being passed through ok.
Altho this is just searching the results of previous z3950 searches, so this wont help the actual z3950 searches work. The problem there was the other error.
Ive attached a processz3950queue file that may (or may not) fix your disappearing server problem
Chris
-- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- IT Tech Crawford County Federated Library System
Hi Chris, Chris Cormack wrote:
On Fri, Jun 16, 2006 at 01:07:52PM +1000, Daehenoc said:
Thanks for the reply. We're running Koha 2.2.5 and since I don't know what npl is I guess we're running default templates. :p Actually, we installed the Canevas templates now I come to think about it.
I'm fairly sure that this problem existed prior to installing the Canevas templates... but the Canevas installation and when we first tried to use the z39.50 daemon was a while ago.
Canevas?? Thats a new one for me :)
It looks to me like BreedingSearch is not being passed anything to search on If you look at Breeding.pm
Line 167 is $sth->execute(@bind);
Before that, could you put
warn "query=$query title=$title isbn=$isbn";
And then try a z3950 search and check the error logs it should hopefully show us if the title and/or isbn are being passed through ok.
OK I did this and got the following in the apache koha-error.log file: 220.239.73.84 - - [21/Jun/2006:21:30:16 +1000] "GET /cgi-bin/koha/z3950/search.pl?bibid=&random= HTTP/1.1" 200 1526 query=Select id,file,isbn,title,author from marc_breeding where title= isbn= at /usr/local/koha/intranet/modules/C4/Breeding.pm line 167. 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 168. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Breeding.pm line 169. So it looks like the title and isbn are not being passed to Breeding.pm :(
Altho this is just searching the results of previous z3950 searches, so this wont help the actual z3950 searches work. The problem there was the other error.
Ive attached a processz3950queue file that may (or may not) fix your disappearing server problem
I backed up the original processz3950queue script, installed this new script, killed the running process and removed the pid file. I then used z3950-daemon-launch.sh to start the daemon up again and got the same log result: 220.239.73.84 - - [21/Jun/2006:21:41:41 +1000] "GET /cgi-bin/koha/z3950/search.pl?bibid=&random= HTTP/1.1" 200 1526 query=Select id,file,isbn,title,author from marc_breeding where title= isbn= at /usr/local/koha/intranet/modules/C4/Breeding.pm line 167. 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 168. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Breeding.pm line 169. So where else should I look to see why BreedingSearch isn't being passed anything? Are we using the z39.50 search function incorrectly? Thanks, Greg
Hi Chris, Chris Cormack wrote:
On Fri, Jun 16, 2006 at 12:51:54PM +1000, Daehenoc said:
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.
Hi Greg
Couple of quick questions, so I can be sure that im looking at the right version, what version of Koha do you have installed? 2nd question, what templates are you using default or npl?
Thanks for the reply. We're running Koha 2.2.5 and since I don't know what npl is I guess we're running default templates. :p Actually, we installed the Canevas templates now I come to think about it. I'm fairly sure that this problem existed prior to installing the Canevas templates... but the Canevas installation and when we first tried to use the z39.50 daemon was a while ago. Thanks, Greg
Hi all, Greg Vickers wrote:
Hi all,
<snip>
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
OK, ok. We found out what was causing our 'problem'. The process we were following (see previous email) meant that our search data is not passed through to the empty bibliography screen - hence when we click on the 'z3950 search' button the daemon would fail to return any results! We populated the "Biblionumber : With Framework" page with some data (i.e. an ISBN number or something) and voila! The z3950 daemon would successfully return data! Credit goes to Stephen P. Gregory, here is his message to me: <quote> After you do a search locally and it fails to return any records, you click "Add New Biblio" and the flow proceeds to a screen with some blank fields for entering MARC info, and a "Z3950 Search" button, but none of the MARC fields are filled in - a naive user such as myself might assume that the MARC 020|a field would be populated with the ISBN on which I searched (locally) in the previous step, but it isn't. If I click "Z3950 Search" now I get the misbehavior that you described, including the Breeding.pl line 168 thing in the log. But if I type the ISBN I'm looking for into the 020|a field on the "new biblio" form, then click "Z3950 Search", then the Z39.50 search executes OK and finds the record. So it looks to me as if the ISBN/Title on which you search locally in the previous step is not being passed forward and attached to the "Z3950 Search" button. Is this normal? I don't know whether I'm using this feature as the authors intended, but it works when I do it that way. </quote> Stephen and ourselves both were caught in this idiosyncrasy (obvious in hindsight!) which seems like a trap for new players. Maybe a note should be added to these pages on how to use them successfully? Thanks all, Greg
But if I type the ISBN I'm looking for into the 020|a field on the "new biblio" form, then click "Z3950 Search", then the Z39.50 search executes OK and finds the record.
I can't remember when this feature was added, but current versions of the Add Biblio screen include a validation routine that warns you that you must fill in certain fields in order for the z39.50 search to work. Perhaps we need to add a z39.50 search box to the cataloging home page and search results screen? -- Owen ---- Nelsonville Public Library http://www.athenscounty.lib.oh.us
participants (5)
-
Chris Cormack -
Daehenoc -
Greg Vickers
-
Kyle Hall -
Owen Leonard