[Koha] Z39.50 search - "Nothing found"
Vasiliki Mela
vmela at ert.gr
Fri Dec 16 22:06:50 NZDT 2016
Hello,
Zebra is running. About the Z39.50 search, I use it to search other
libraries. From the perl modules table in Koha it looks like it is
using Net::Z3950::ZOOM
(1.16) 1.30. But I don't see it being executed as a daemon in Linux with
the command ps aux. Should it?
Recently, Koha was migrated using VM migration from VMware to hyper-V using
a migration tool.
In the error log of my original message there are mysql errors. It looks
like the remote libraries anwered my queries and returned data, but these
data, because of sql errors, were not inserted in the relevant DB tables
and did not appear in the new window.
For example:
[Wed Dec 14 11:30:28.333839 2016] [cgi:error] [pid 2028] [client
10.11.51.11:58571] AH01215: [Wed Dec 14 11:30:28 2016]
*z3950_search.pl <http://z3950_search.pl>: DBD::mysql::st execute failed:
Field 'marcxml_old'*
*doesn't have a default value* [for Statement "INSERT INTO
import_records (import_batch_id, record_sequence, marc, marcxml, :
/usr/share/koha/intranet/cgi-bin/cataloguing/z3950_search.pl, referer:
http://ert_lib-intra.ert2000.gr/cgi-bin/koha/cataloguing/
z3950_search.pl?biblionumber=0&frameworkcode=
[Wed Dec 14 11:30:28.334109 2016] [cgi:error] [pid 2028] [client
10.11.51.11:58571] AH01215: [Wed Dec 14 11:30:28 2016]
z3950_search.pl:
record_type, encoding, z3950random):
/usr/share/koha/intranet/cgi-bin/cataloguing/z3950_search.pl, referer:
http://ert_lib-intra.ert2000.gr/cgi-bin/koha/cataloguing/
z3950_search.pl?biblionumber=0&frameworkcode=
Operating system
ertadmin at srv-library:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.1 LTS
Release: 16.04
Codename: xenial
Zebra daemon
ertadmin at srv-library:~$ ps aux | grep zebra
ert_lib+ 1122 0.0 0.0 20132 204 ? S Dec14 0:00 daemon
--name=ert_lib-koha-zebra --pidfiles=/var/run/koha/ert_lib/
--errlog=/var/log/koha/ert_lib/zebra-error.log
--output=/var/log/koha/ert_lib/zebra-output.log
--verbose=1 --respawn --delay=30 --user=ert_lib-koha.ert_lib-koha --
zebrasrv -v none,fatal,warn -f /etc/koha/sites/ert_lib/koha-conf.xml
ert_lib+ 1124 0.0 0.1 127944 9872 ? S Dec14 0:00 zebrasrv
-v none,fatal,warn -f /etc/koha/sites/ert_lib/koha-conf.xml
ert_lib+ 1174 0.0 0.0 20132 204 ? S Dec14 0:00 daemon
--name=ert_lib-koha-indexer --errlog=/var/log/koha/ert_lib/indexer-error.log
--stdout=/var/log/koha/ert_lib/indexer.log
--output=/var/log/koha/ert_lib/indexer-output.log
--pidfiles=/var/run/koha/ert_lib/ --verbose=1 --respawn --delay=30
--user=ert_lib-koha.ert_lib-koha -- /usr/share/koha/bin/migration_tools/
rebuild_zebra.pl -daemon -sleep 5
ert_lib+ 1175 0.0 1.6 332860 132356 ? S Dec14 0:10
/usr/bin/perl /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -daemon
-sleep 5
ertadmin 6869 0.0 0.0 14224 972 pts/1 S+ 09:36 0:00 grep
--color=auto zebra
*Server information*
*Koha version:*
16.05.03.000
*OS version ('uname -a'):*
Linux srv-library 4.4.0-53-generic #74-Ubuntu SMP Fri Dec 2 15:59:10 UTC
2016 x86_64
*Perl interpreter:*
/usr/bin/perl
*Perl version:*
5.022001
*Perl @INC:*
/usr/share/koha/lib
/etc/perl
/usr/local/lib/x86_64-linux-gnu/perl/5.22.1
/usr/local/share/perl/5.22.1
/usr/lib/x86_64-linux-gnu/perl5/5.22
/usr/share/perl5
/usr/lib/x86_64-linux-gnu/perl/5.22
/usr/share/perl/5.22
/usr/local/lib/site_perl
/usr/lib/x86_64-linux-gnu/perl-base
.
*MySQL version:*
mysql Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using EditLine wrapper
*Apache version:*
Server version: Apache/2.4.18 (Ubuntu)
*Zebra version:*
Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free software, covered by
the GNU General Public License, and you are welcome to change it and/or
distribute copies of it under certain conditions. SHA1 ID:
c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU
*Perl modules*
*Algorithm::CheckDigits *(0.5)
0.50
AnyEvent (5.0)
7.12
AnyEvent::HTTP (2.13)
2.22
Archive::Extract (0.60)
*Not Installed*
Archive::Zip (1.30)
1.56
*Authen::CAS::Client *(0.05)
0.07
*Biblio::EndnoteStyle *(0.05)
0.05
*Business::ISBN *(2.05)
2.010
*CGI *(3.15)
4.26
*CGI::Carp *(1.29)
4.26
*CGI::Session *(4.2)
4.48
CGI::Session::Driver::memcached (0.04)
0.04
*CGI::Session::Serialize::yaml *(4.2)
4.26
Cache::FastMmap (1.34)
1.43
Cache::Memcached::Fast (0.17)
0.23
Cache::Memory (2.04)
2.11
*Class::Accessor *(0.3)
0.34
*Class::Factory::Util *(1.6)
1.7
Convert::BaseN (0.01)
0.01
*Crypt::Eksblowfish::Bcrypt *(0.008)
0.009
Crypt::GCrypt (1.24)
1.26
*DBD::Mock *(1.39)
1.45
DBD::SQLite2 (0.33)
0.37
*DBD::mysql *(4.004)
4.033
*DBI *(1.53)
1.634
*DBIx::Class::Schema::Loader *(0.07039)
0.07045
*DBIx::RunSQL *(0.14)
0.14
*Data::Dumper *(2.121)
2.158
*Data::ICal *(0.13)
0.22
*Date::Calc *(5.4)
6.4
*Date::Manip *(5.44)
6.52
*DateTime *(0.58)
1.21
*DateTime::Event::ICal *(0.08)
0.13
*DateTime::Format::ICal *(0.09)
0.09
*DateTime::Format::MySQL *(0.04)
0.05
*DateTime::Set *(0.28)
0.3600
*DateTime::TimeZone *(1.20)
1.95
Devel::Cover (0.89)
1.21
*Digest::MD5 *(2.36)
2.54
Digest::SHA (5.61)
5.95
*Email::Date *(1.103)
1.104
*Email::Valid *(0.190)
1.198
*Exception::Class *(1.38)
1.40
File::Copy (2.08)
2.30
File::Path (2.07)
2.09
File::Slurp (9999.13)
9999.19
File::Temp (0.22)
0.2304
*Font::TTF *(0.45)
1.05
GD (2.39)
2.53
*GD::Barcode::UPCE *(1.1)
1.1
*Getopt::Long *(2.35)
2.45
*Getopt::Std *(1.05)
1.11
Graphics::Magick (1.3.05)
1.3.23
Gravatar::URL (1.03)
1.06
*HTML::Entities *(3.69)
3.69
*HTML::FormatText *(1.23)
2.11
*HTML::Scrubber *(0.08)
0.15
*HTTP::Cookies *(1.39)
6.01
*HTTP::OAI *(3.2)
4.03
*HTTP::Request::Common *(1.26)
6.11
HTTPD::Bench::ApacheBench (0.73)
*Not Installed*
IO::Socket::IP (0.16)
0.37
*IPC::Cmd *(0.46)
0.92
*JSON *(2.07)
2.90
LWP::Protocol::https (5.836)
6.06
*LWP::Simple *(1.41)
6.15
*LWP::UserAgent *(2.033)
6.15
*Library::CallNumber::LC *(0.22)
0.23
Lingua::Ispell (0.07)
0.07
*Lingua::Stem *(0.82)
0.84
*Lingua::Stem::Snowball *(0.952)
0.952
*List::MoreUtils *(0.21)
0.413
*List::Util *(1.18)
1.41
*Locale::Currency::Format *(1.28)
1.35
*Locale::Language *(2.07)
3.34
*Locale::Maketext *(1.19)
1.26
*Locale::Maketext::Lexicon *(0.91)
1
*Locale::PO *(0.17)
0.27
*Log::Log4perl *(1.29)
1.44
*MARC::Charset *(0.98)
1.35
*MARC::File::XML *(1.0.1)
1.0.3
*MARC::Record *(2.0.6)
2.0.6
*MIME::Base64 *(3.07)
3.15
*MIME::Lite *(3)
3.030
*MIME::QuotedPrint *(3.07)
3.13
*Mail::Sendmail *(0.79)
0.79_16
*Modern::Perl *(1.03)
1.20150127
Module::Bundled::Files (0.03)
0.03
Module::Load::Conditional (0.38)
0.64
Module::Pluggable (3.9)
5.2
Mojolicious (6.0)
6.15
Moo (1)
2.000002
Net::LDAP (0.33)
0.65
Net::LDAP::Filter (0.14)
0.20
Net::SFTP::Foreign (1.73)
1.81
Net::Server (0.97)
2.008
*Net::Z3950::ZOOM *(1.16)
1.30
*Number::Format *(1.52)
1.75
*OpenOffice::OODoc *(2.125)
2.125
*PDF::API2 *(2)
2.025
*PDF::API2::Page *(2)
2.025
*PDF::API2::Simple *(1)
1.1.4
*PDF::API2::Util *(2)
2.025
PDF::FromHTML (0.31)
0.31
*PDF::Reuse *(0.36)
0.36
*PDF::Reuse::Barcode *(0.05)
0.07
*PDF::Table *(0.9.3)
0.9.6
*POSIX *(1.09)
1.53_01
*Plack::Middleware::ReverseProxy *(0.14)
0.15
Readonly (0.01)
2
Readonly::XS (0.01)
*Not Installed*
SMS::Send (0.05)
1.06
SOAP::Lite (0.712)
1.19
*Schedule::At *(1.06)
1.15
*Storable *(2.20)
2.53_01
*String::Random *(0.22)
0.29
Swagger2 (0.59)
0.77
*Template *(2.22)
2.24
*Template::Plugin::HtmlToText *(0.03)
0.03
*Template::Plugin::JSON::Escape *(0.02)
0.02
Template::Plugin::Stash (1.006)
1.006
*Term::ANSIColor *(1.1)
4.03
*Test *(1.25)
1.26
Test::DBIx::Class (0.42)
*Not Installed*
Test::Deep (0.106)
1.120
*Test::Harness *(2.56)
3.35
*Test::MockModule *(0.05)
0.11
Test::MockObject (1.09)
1.20150527
*Test::More *(0.8)
1.001014
Test::Strict (0.14)
0.36
Test::WWW::Mechanize (1.42)
1.42
Test::Warn (0.21)
0.30
Test::YAML::Valid (0.04)
0.04
*Text::Bidi *(0.03)
2.11
*Text::CSV *(0.01)
1.33
*Text::CSV::Encoded *(0.09)
0.25
*Text::CSV_XS *(0.32)
1.21
*Text::Iconv *(1.7)
1.7
*Text::PDF *(0.29)
0.29
*Text::Unaccent *(1.08)
1.08
Text::Unidecode (0.04)
1.27
*Text::Wrap *(2005.082401)
2013.0523
Time::Fake (0.11)
0.11
*Time::HiRes *(1.86)
1.9726
*Time::localtime *(1.02)
1.02
*UNIVERSAL::can *(1.10)
1.20140328
UNIVERSAL::require (0.13)
0.17
*URI::Escape *(3.31)
3.31
*UUID *(0.05)
0.24
*Unicode::Normalize *(0.32)
1.18
WWW::YouTube::Download (0.56)
*Not Installed*
*XML::Dumper *(0.81)
0.81
*XML::LibXML *(1.59)
2.0123
*XML::LibXSLT *(1.59)
1.94
*XML::RSS *(1.31)
1.58
*XML::SAX::ParserFactory *(1.01)
1.01
*XML::SAX::Writer *(0.44)
0.56
*XML::Simple *(2.14)
2.22
XML::Writer (0.614)
0.625
*YAML *(0.71)
1.15
*YAML::Syck *(0.71)
1.29
Apologies for the very long message
Vasiliki Mela
Librarian
vmela at ert.gr
On 15 December 2016 at 14:22, Dimitris Antonakis <dimantonak at gmail.com>
wrote:
> Hi Vasiliki,
>
> Did you make any changes to the Z39.50 server configuration settings?
> Please try to restart apache (/etc/init.d/apache2 restart)
>
> Dimitris Antonakis
> --
> Δημήτρης Αντωνάκης
>
More information about the Koha
mailing list