Re: [Koha] No errors, but no search results
I have exactly them same problem. I did install sudo cpan, no error, test all ok. I make file ok, install zebra with no error... I created some records with Marc frameworks. I can check out, check in, and check mysql that i did have some items (books) in library. The only problem is that i can't search. When i type some things on "search the catalog", the result always is not found. So did i have problem with zebra index? I tried reinstall it, nothing happened. Help me please! Kindest Regards! Nguyen Quoc Uy On 25-06-2012, at 17:18, koha-request@lists.katipo.co.nz wrote:
Send Koha mailing list submissions to koha@lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."
Today's Topics:
1. Re: Rebuild-zebra stops working very often... (Sonia P.) 2. Re: Rebuild-zebra stops working very often... (Chris Cormack) 3. 8 Perl Modules are Not Detected by koha_perl_deps.pl on VDS (was Re: Installing Koha on CentOS+cPanel Hosting Server) (Andi Sugandi) 4. Re: Rebuild-zebra stops working very often... (Robin Sheat) 5. Re: No errors, but no search results (Robin Sheat) 6. Re: Spell-check/ Did you mean (Robin Sheat) 7. Re: Excel to MARC - Marcedit 5.8 (Robin Sheat) 8. Re: Rebuild-zebra stops working very often... (Sonia P.)
----------------------------------------------------------------------
Message: 1 Date: Mon, 25 Jun 2012 03:44:12 +0200 From: Sonia P. <sossolapro@hotmail.com> To: <chrisc@catalyst.net.nz> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Rebuild-zebra stops working very often... Message-ID: <SNT123-W390B9B13C9175C8474F606DCE10@phx.gbl> Content-Type: text/plain; charset="iso-8859-1"
Hi there
Here is what our technician said in relation to your message : << If Zebra cannot connect to the database, Koha itself will not work. The database connection error is unrelated to the Koha search problem.
The Zebra logs are located under /var/log/koha/library, I have looked at the zebra-output.log file contained within the directory, there is nothing in it and it hasn't been written to since April 24. The zebra-error.log in the same directory hasn't been written to since the computer was installed. >>
So I don't know what to do... We are stuck. I can't restart zebra every two hours. Would reinstalling everything help? Wouldn't it take two weeks to set up and fix everything? If you have any idea about what's going on...
Cheers,
Sonia.
Subject: Re: [Koha] Rebuild-zebra stops working very often... From: chrisc@catalyst.net.nz Date: Sun, 24 Jun 2012 13:10:41 +1200 To: sossolapro@hotmail.com CC: koha@lists.katipo.co.nz
Ahh that is not the zebra error log. But the rebuild zebra one. I think you may be confusing zebra with the job to rebuild the zebra indexes, they are 2 quite different things.
However not being able to talk to the database is a fatal error for the rebuild zebra script. The database failing will also cause all sorts of other errors. I would get your tech people to look at your database set up. Something very bad is going wrong there.
Chris
"Sonia P." <sossolapro@hotmail.com> wrote:
Dear all
Thanks again for your help. Here is (below) the content of the zebra error file. Would you please have a look at it and tell me if there are things which could explain why zebra-rebuild stops working now and then? There is that DBIconnect error, but I am not sure it's related. And there is no time & day in the error file, so I can't check what happened when zebra rebuild doesn't work properly. (I have removed all the multiple duplicates...)
Cheers,
Sonia.
Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm line 96. DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to loc al MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm lin e 692 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/l ib/C4/Context.pm line 692. DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to loc al MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm lin e 692 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/l ib/C4/Context.pm line 692. DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to loc al MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line 692 Can't connect to local MySQL server throu gh socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib /C4/Context.pm line 692. error retrieving biblio 12126 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. error retrieving biblio 11493 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. error retrieving biblio 13829 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. $ Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm line 96. $ DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to local MySQL server through socket $ '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 692 error retrieving biblio 14703 at /usr/share/koha/bin/migration_tools/rebuild_ zebra.pl line 473. $ Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm line 96. $ DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to local MySQL server through socket $ '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 692 $ error retrieving biblio 14703 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473. $ Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm line 96. $ DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) failed: Can't connect to local MySQL server through socket $ '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 692 $ error retrieving biblio 14 703 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473.
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
Message: 2 Date: Mon, 25 Jun 2012 13:55:49 +1200 From: Chris Cormack <chrisc@catalyst.net.nz> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Rebuild-zebra stops working very often... Message-ID: <20120625015549.GF20097@rorohiko.wgtn.cat-it.co.nz> Content-Type: text/plain; charset=us-ascii
* Sonia P. (sossolapro@hotmail.com) wrote:
Hi there
Here is what our technician said in relation to your message : << If Zebra cannot connect to the database, Koha itself will not work. The database connection error is unrelated to the Koha search problem.
The Zebra logs are located under /var/log/koha/library, I have looked at the zebra-output.log file contained within the directory, there is nothing in it and it hasn't been written to since April 24. The zebra-error.log in the same directory hasn't been written to since the computer was installed. >>
So I don't know what to do... We are stuck. I can't restart zebra every two hours. Would reinstalling everything help? Wouldn't it take two weeks to set up and fix everything? If you have any idea about what's going on...
Your technician is sort of right. Koha itself will not work if it can not connect to the database. Zebra itself never ever connects to the database.
This is where the confusion is occuring I think we are talking past each other.
There is a script, that is written in perl, that connects to the Koha database, exports a bunch of MARC as xml files, then passes those off to the zebraidx job for it to index them.
None of this requires zebrasrv to be running (the actual zebras server process). zebrasrv itself never talks to Koha, or to mysql, it only looks at it's own index files.
Now, the script to rebuild the indexes will fail if it can not connect to the database. This looks like what was happening with the error log you pasted before.
So to be absolutely clear, it is the zebrasrv process that is dying? And it is not logging anywhere? Not even to syslog?
You are running from the debian packages right? If zebrasrv is dying I would expect to see things like this
$ sudo tail /var/log/koha/ashs/zebra-error.log.1
20120314 21:58:00 ashs-koha-zebra: client (pid 2441) exited with 1 status
$ sudo tail /var/log/koha/ashs/zebra-output.log.1
21:58:00-14/03 [fatal] Element <xslt stylesheet="/usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/xslt/MARC21slim2DC.xsl"/>: could not locate stylesheet '/usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/xslt/MARC21slim2DC.xsl' in config /etc/koha/sites/ashs/koha-conf.xml
Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
------------------------------
Message: 3 Date: Mon, 25 Jun 2012 15:12:42 +0700 From: Andi Sugandi <andisugandi@gmail.com> To: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> Cc: koha <koha@lists.katipo.co.nz> Subject: [Koha] 8 Perl Modules are Not Detected by koha_perl_deps.pl on VDS (was Re: Installing Koha on CentOS+cPanel Hosting Server) Message-ID: <CAP9RdOCXuBhP_dFLDB2OV0Yyz=Pmm-sd6At3369zYE6=jLBnGw@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
Hi all,
On Mon, Jun 4, 2012 at 7:07 PM, Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> wrote:
Hi,
cPanel only provides Perl 5.8, but Perl module Modern::Perl can only be installed on Perl 5.10 environment[1].
Koha (last versions) can only be installed on Perl >= 5.10
What do you think?
In a situation like yours, I have downloaded and compiled Perl (on /usr/local, 5.14), then I installed all the required modules from CPAN (a long long work) Then Koha. It works.
Get rid of cPanel and start providing Perl modules based on CentOS environment will simplify the installing process of Koha?
My advice would be not to touch anything in the system. Only install what is needed by Koha in /usr/local
I'm running Perl 5.16 now, installed manually in /usr/local directory:
# perl -v | grep version This is perl 5, version 16, subversion 0 (v5.16.0) built for x86_64-linux
Then trying to see whether all required Perl modules are already installed or not. But unfortunately something happened: There are 8 left, not detected by 'koha_perl_deps.pl' script [0], though these modules are already in place:
cpan[1]> install CGI Reading '/root/.cpan/Metadata' Database was generated on Sat, 23 Jun 2012 16:47:04 GMT CGI is up to date (3.59).
cpan[2]> install CGI::Carp CGI::Carp is up to date (3.51).
cpan[3]> install Digest::SHA Digest::SHA is up to date (5.71).
cpan[4]> install HTTP::OAI HTTP::OAI is up to date (3.28).
cpan[5]> install Net::Z3950::ZOOM Net::Z3950::ZOOM is up to date (1.28).
cpan[6]> install Template::Plugin::HtmlToText Template::Plugin::HtmlToText is up to date (0.03).
cpan[7]> install Test::Harness Test::Harness is up to date (3.25).
cpan[8]> install Test::More Test::More is up to date (0.98).
[0] http://paste.opensuse.org/view/simple/94354226
Does it mean that the Perl environment is not configured properly? How to solve this issue?
Any help will be very much appreciated.
Thanks in advance.
Best regards, -- Andi Sugandi.
------------------------------
Message: 4 Date: Mon, 25 Jun 2012 10:20:57 +0100 From: Robin Sheat <robin@catalyst.net.nz> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Rebuild-zebra stops working very often... Message-ID: <4FE82D79.6080904@catalyst.net.nz> Content-Type: text/plain; charset=UTF-8
Op 25-06-12 02:44, Sonia P. schreef:
So I don't know what to do... We are stuck. I can't restart zebra every two hours.
When you say that you are restarting zebra, what _exactly_ are you doing? Because, as Chris says, there seems to be some confusion: restarting zebra should not affect whether rebuild-zebra is doing its job or not. Also, rebuild-zebra fires up every 15 minutes or so do do things, does them, and then stops. There is something in your explanation that doesn't make sense that needs to be figured out before any useful suggestions can be made.
Would reinstalling everything help? Wouldn't it take two weeks to set up and fix everything?
No idea, it would depend on what the problem was. In theory, if you follow exactly the same steps that you did last time, you will have the same problems.
-- Robin Sheat Catalyst IT Ltd. ? +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
------------------------------
Message: 5 Date: Mon, 25 Jun 2012 10:36:32 +0100 From: Robin Sheat <robin@catalyst.net.nz> To: koha@lists.katipo.co.nz Subject: Re: [Koha] No errors, but no search results Message-ID: <4FE83120.3090507@catalyst.net.nz> Content-Type: text/plain; charset=UTF-8
Op 22-06-12 19:02, ShaneGreen schreef:
We ran zebra interactively and all sorts of problems showed up. There were four errors to correct, a missing file and couple of permissions to change. . .enough stuff that we can't remember the details exactly. But searches are working now!
It'd be great if you describe what errors you saw so we can determine if they need to fixed properly. At the least, then other people know what the solutions were.
Also, where did you get 3.7 from using the packages? The currently available packaged versions are 3.6, 3.8, and 3.9.
We still need to set up the chron job, etc. but the
All the cron jobs should be set up by the packages. I'm wondering if you stepped outside the package-provided utilities a bit and that caused permissions to get upset.
Thank you to everyone on the forum and the emails we received.
We have a forum?
-- Robin Sheat Catalyst IT Ltd. ? +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
------------------------------
Message: 6 Date: Mon, 25 Jun 2012 10:41:00 +0100 From: Robin Sheat <robin@catalyst.net.nz> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Spell-check/ Did you mean Message-ID: <4FE8322C.5050207@catalyst.net.nz> Content-Type: text/plain; charset=UTF-8
Op 22-06-12 21:29, Paul schreef:
Searching for "nature defecit" *with* the double quotes fails -- this I expect, as the quotes eliminate fuzziness.
Searching for nature defecit (no quotes) works perfectly.
Searching for "nature-deficit" (with quotes) fails; I am only semi-surprised as the logic of the - (minus sign) is to search for the phrase without the term after the minus. However +nature -deficit also finds that title alone and in my opinion should not (but my opinion is not definitive.)
Koha doesn't understand "phrase searching" and +with -without operators by default. It's possible to construct queries that will, but in general it doesn't.
-- Robin Sheat Catalyst IT Ltd. ? +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
------------------------------
Message: 7 Date: Mon, 25 Jun 2012 10:49:03 +0100 From: Robin Sheat <robin@catalyst.net.nz> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Excel to MARC - Marcedit 5.8 Message-ID: <4FE8340F.10109@catalyst.net.nz> Content-Type: text/plain; charset=UTF-8
Op 23-06-12 13:21, SANDEEP BHAVSAR schreef:
system.data.oledb.oledbexception (0X80004005): Make sure that it does not include invalid characters
As marcedit is proprietary software, unfortunately the only person who is likely to be able to help is the marcedit author, unless someone else has seen and solved it before.
-- Robin Sheat Catalyst IT Ltd. ? +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
------------------------------
Message: 8 Date: Mon, 25 Jun 2012 15:18:22 +0200 From: Sonia P. <sossolapro@hotmail.com> To: <koha@lists.katipo.co.nz> Subject: Re: [Koha] Rebuild-zebra stops working very often... Message-ID: <SNT123-W7A08DF25FD8EFF39155DBDCE10@phx.gbl> Content-Type: text/plain; charset="utf-8"
OK, thanks all for your help! I am sorry I don't know all the details and I am obviously not great with Koha.
Rebuild-zebra is supposed to run every 15 minutes for us, and sometimes it doesn't. I know, because then I am contacted by librarians who say they can't find books which they have just entered (or I check myself, I run a few mysql queries and check if I can find them on the website). So I know it's because the search indexes are not up to date. Then, I restart rebuild-zebra with the following: sudo koha-rebuild-zebra -v -f library And then the problem is solved, but not forever. It stops again later, the same day or another day, sometimes one week later. If I had more time to work on Koha, I could check exactly how often it happens and things like that, but I don't have time. :(
In << sudo tail /var/log/koha/ashs/zebra-error.log.1 >> is ashs the name of the library? On our server, the closest thing I could find is << sudo tail /var/log/koha/library/zebra-error.log >> and it doesn't give me any information. So, if I understand well "tail", it means that the file is empty. Same thing for zebra-output. When I look at the current processes (ps -aux), I can see that there is a zebrasrv process runing (it says << Mar26 2:02 zebrasrv -v none,fatal,warn -f /etc/koha/sites/library/koha-conf >>, March 26 being the day when we restarted the whole server). So all that probably means that there is no problem with Zebra, am I right?
With the errors I have reported previously (DBIconnect...), what is it that can't connect to MySQL? that perl script you describe, Chris? I understand it's not Zebra itself, is it rebuild-zebra?
Thanks a lot for all your explanations...
Cheers,
Sonia.
Date: Mon, 25 Jun 2012 10:20:57 +0100 From: robin@catalyst.net.nz To: koha@lists.katipo.co.nz Subject: Re: [Koha] Rebuild-zebra stops working very often...
Op 25-06-12 02:44, Sonia P. schreef:
So I don't know what to do... We are stuck. I can't restart zebra every two hours.
When you say that you are restarting zebra, what _exactly_ are you doing? Because, as Chris says, there seems to be some confusion: restarting zebra should not affect whether rebuild-zebra is doing its job or not. Also, rebuild-zebra fires up every 15 minutes or so do do things, does them, and then stops. There is something in your explanation that doesn't make sense that needs to be figured out before any useful suggestions can be made.
Would reinstalling everything help? Wouldn't it take two weeks to set up and fix everything?
No idea, it would depend on what the problem was. In theory, if you follow exactly the same steps that you did last time, you will have the same problems.
-- Robin Sheat Catalyst IT Ltd. ? +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
End of Koha Digest, Vol 80, Issue 38 ************************************
Did you check the system preference NoZebra? It should be set to: "Use" Regards Marc Am 25.06.2012 20:33, schrieb Uy:
I have exactly them same problem. I did install sudo cpan, no error, test all ok. I make file ok, install zebra with no error... I created some records with Marc frameworks. I can check out, check in, and check mysql that i did have some items (books) in library. The only problem is that i can't search. When i type some things on "search the catalog", the result always is not found. So did i have problem with zebra index? I tried reinstall it, nothing happened. Help me please!
Kindest Regards! Nguyen Quoc Uy
participants (2)
-
Marc Véron -
Uy