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@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@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@ert.gr On 15 December 2016 at 14:22, Dimitris Antonakis <dimantonak@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 -- Δημήτρης Αντωνάκης