[Koha] No errors, but no search results
Uy
nguyenquocuy_1102 at yahoo.com
Tue Jun 26 06:33:52 NZST 2012
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 at lists.katipo.co.nz wrote:
> Send Koha mailing list submissions to
> koha at 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 at lists.katipo.co.nz
>
> You can reach the person managing the list at
> koha-owner at 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 at hotmail.com>
> To: <chrisc at catalyst.net.nz>
> Cc: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Rebuild-zebra stops working very often...
> Message-ID: <SNT123-W390B9B13C9175C8474F606DCE10 at 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 at catalyst.net.nz
> Date: Sun, 24 Jun 2012 13:10:41 +1200
> To: sossolapro at hotmail.com
> CC: koha at 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 at 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 at 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 at catalyst.net.nz>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Rebuild-zebra stops working very often...
> Message-ID: <20120625015549.GF20097 at rorohiko.wgtn.cat-it.co.nz>
> Content-Type: text/plain; charset=us-ascii
>
> * Sonia P. (sossolapro at 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 at gmail.com>
> To: Bernardo Gonzalez Kriegel <bgkriegel at gmail.com>
> Cc: koha <koha at 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 at 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 at 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 at catalyst.net.nz>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Rebuild-zebra stops working very often...
> Message-ID: <4FE82D79.6080904 at 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 at catalyst.net.nz>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] No errors, but no search results
> Message-ID: <4FE83120.3090507 at 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 at catalyst.net.nz>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Spell-check/ Did you mean
> Message-ID: <4FE8322C.5050207 at 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 at catalyst.net.nz>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Excel to MARC - Marcedit 5.8
> Message-ID: <4FE8340F.10109 at 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 at hotmail.com>
> To: <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Rebuild-zebra stops working very often...
> Message-ID: <SNT123-W7A08DF25FD8EFF39155DBDCE10 at 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 at catalyst.net.nz
>> To: koha at 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 at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> ------------------------------
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> End of Koha Digest, Vol 80, Issue 38
> ************************************
More information about the Koha
mailing list