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-requ...@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-requ...@lists.katipo.co.nz > > You can reach the person managing the list at > koha-ow...@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. <sossola...@hotmail.com> > To: <chr...@catalyst.net.nz> > Cc: koha@lists.katipo.co.nz > Subject: Re: [Koha] Rebuild-zebra stops working very often... > Message-ID: <snt123-w390b9b13c9175c8474f606dc...@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: chr...@catalyst.net.nz > Date: Sun, 24 Jun 2012 13:10:41 +1200 > To: sossola...@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." <sossola...@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 <chr...@catalyst.net.nz> > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Rebuild-zebra stops working very often... > Message-ID: <20120625015549.gf20...@rorohiko.wgtn.cat-it.co.nz> > Content-Type: text/plain; charset=us-ascii > > * Sonia P. (sossola...@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 <andisuga...@gmail.com> > To: Bernardo Gonzalez Kriegel <bgkrie...@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=jlb...@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 > <bgkrie...@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 <ro...@catalyst.net.nz> > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Rebuild-zebra stops working very often... > Message-ID: <4fe82d79.6080...@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 <ro...@catalyst.net.nz> > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] No errors, but no search results > Message-ID: <4fe83120.3090...@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 <ro...@catalyst.net.nz> > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Spell-check/ Did you mean > Message-ID: <4fe8322c.5050...@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 <ro...@catalyst.net.nz> > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Excel to MARC - Marcedit 5.8 > Message-ID: <4fe8340f.10...@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. <sossola...@hotmail.com> > To: <koha@lists.katipo.co.nz> > Subject: Re: [Koha] Rebuild-zebra stops working very often... > Message-ID: <snt123-w7a08df25fd8eff39155dbdc...@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: ro...@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 > ************************************ _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha