- Koha - lists.katipo.co.nz

Rv: Adoption of the I.L.S. Koha, for the National Library of Venezuela
by Ramon Figueroa 26 Jun '12

26 Jun '12

Caracas, June 21st2012 Koha Library Software Community Dear Sirs, It is a pleasure for us to announce you that the National Library of Venezuela, an Authonomous Institute of the Ministry of Culture of the Bolivarian Republic of Venezuela, has adopted the ILS Koha, as the automated system for the management of our library information. The system is available on the Internet by the link to the Catalogon our website: (http//:www.bnv.gob.ve) with the following URL: http://sisbiv.bnv.gob.ve. The adoption of the ILS Koha is a response to guidelines and presidential decrees, that regarding the use of software, commit us to the implementation of software developed by the free software community and the abandonment of proprietary packages and licenses of both software and hardware. It is important to point out that at present we have available for the library's patrons the OPAC and the cataloging module, and eventually we will incorporate the remaining modules of the system. For two years we have been assessing the functionality of Koha and, simultaneously, we have been doing research to complete the transfer of data from the proprietary system previously in use by our institution (NOTIS) and now we are able to reveal those results to the public. We are very satisfied with Koha, since we consider it a great gift of the world library community. For this reason, we request you to incorporate the National Library of Venezuela as an active member of the community in order to share our experiences and contribute, to the extent of our capabilities, to the development and improvement of such a great system. Thanking you for your attention, we remain, Yours sincerely, Lic. Samyra Handam. Directora de la Oficina de Tecnología de la Información. Samyra.handam(a)bnv.gob.ve Lic. Engels Arismendi. Lic. Ramón Figueroa. Jefe de División de Sistemas. Especialista en Información Engels.arismendi(a)bnv.gob.ve ramon.figueroa(a)bnv.gob.ve

1 0

Re: [Koha] Excel to MARC - Marcedit 5.8
by Randall Rowe 26 Jun '12

26 Jun '12

I haven't tried running MarcEdit in Wine. I've been amazed at what Wine will run. Randy Rowe Lincoln City Libraries I.T. -----Original Message----- From: "Paul" <paul.a(a)aandc.org> Sent 6/26/2012 9:13:32 AM To: "amit bondwal" <bondwal.amit(a)gmail.com>, koha(a)lists.katipo.co.nz Subject: Re: [Koha] Excel to MARC - Marcedit 5.8 At 05:44 AM 6/26/2012 -0700, amit bondwal wrote: >HI Sandeep, >I don't know much about it, but may be this can help, Is your excel >sheet have three sheets? then delete the two extra empty sheets in that >file and save as the file in text(tab delieted) format. >marc edit support more text(tab delimeted) format. >Then try to convert by marc edit in text delimated in addins. A couple of years ago we tried to use Office97 (we've never had a more recent version) to do just that -- but ended up using OpenOffice|LibreOffice to open and save the Excel files as tab-delimited .csv files. Excel appeared to have difficulties with UTF8 and special characters. Disclaimer: Terry Reece has done an apparently marvelous job developing MarcEdit; we've never been able to run recent versions as our old Windows laptop is more of a museum exhibit than a useful tool. I would strongly suggest joining the list at <http://metis3.gmu.edu/cgi-bin/wa?A0=MARCEDIT-L>. As an aside, has anyone managed to get MarcEdit to function on a Linux box? We have failed miserably. Best - Paul >Regards >Amit Bondwal > > >On Tue, Jun 26, 2012 at 1:40 AM, Stacy Pober [via Koha] ><ml-node+s1045719n5717713h8(a)n5.nabble.com> wrote: > > There's an excellent support list for MARCEDIT called MARCEDIT-L. Â Terry > > Reese, the author of the program monitors the list, and he will often offer > > solutions along with some of the other list subscribers. > > > > http://metis3.gmu.edu/cgi-bin/wa?A0=MARCEDIT-L > > > > It's also a good way to give input on features you'd like to see or to find > > out whether someone already has solved a particular problem you're having. > > > > Stacy > > > > On Mon, Jun 25, 2012 at 9:18 AM, <[hidden email]> wrote: > > > >> 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. > >> > > > > > > > > -- > > Stacy Pober > > Information Alchemist > > Riverdale, NY 10471 > > [hidden email] > > _______________________________________________ > > Koha mailing list Â http://koha-community.org > > [hidden email] > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > ________________________________ > > If you reply to this email, your message will be added to the discussion > > below: > > > http://koha.1045719.n5.nabble.com/Excel-to-MARC-Marcedit-5-8-tp5717503p5717… > > To unsubscribe from Koha, click here. > > NAML > > >-- >View this message in context: >http://koha.1045719.n5.nabble.com/Excel-to-MARC-Marcedit-5-8-tp5717503p5717… >Sent from the Koha-general mailing list archive at Nabble.com. >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca> _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Re: [Koha] Excel to MARC - Marcedit 5.8
by Paul 26 Jun '12

26 Jun '12

At 05:44 AM 6/26/2012 -0700, amit bondwal wrote: >HI Sandeep, >I don't know much about it, but may be this can help, Is your excel >sheet have three sheets? then delete the two extra empty sheets in that >file and save as the file in text(tab delieted) format. >marc edit support more text(tab delimeted) format. >Then try to convert by marc edit in text delimated in addins. A couple of years ago we tried to use Office97 (we've never had a more recent version) to do just that -- but ended up using OpenOffice|LibreOffice to open and save the Excel files as tab-delimited .csv files. Excel appeared to have difficulties with UTF8 and special characters. Disclaimer: Terry Reece has done an apparently marvelous job developing MarcEdit; we've never been able to run recent versions as our old Windows laptop is more of a museum exhibit than a useful tool. I would strongly suggest joining the list at <http://metis3.gmu.edu/cgi-bin/wa?A0=MARCEDIT-L>. As an aside, has anyone managed to get MarcEdit to function on a Linux box? We have failed miserably. Best - Paul >Regards >Amit Bondwal > > >On Tue, Jun 26, 2012 at 1:40 AM, Stacy Pober [via Koha] ><ml-node+s1045719n5717713h8(a)n5.nabble.com> wrote: > > There's an excellent support list for MARCEDIT called MARCEDIT-L. Â Terry > > Reese, the author of the program monitors the list, and he will often offer > > solutions along with some of the other list subscribers. > > > > http://metis3.gmu.edu/cgi-bin/wa?A0=MARCEDIT-L > > > > It's also a good way to give input on features you'd like to see or to find > > out whether someone already has solved a particular problem you're having. > > > > Stacy > > > > On Mon, Jun 25, 2012 at 9:18 AM, <[hidden email]> wrote: > > > >> 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. > >> > > > > > > > > -- > > Stacy Pober > > Information Alchemist > > Riverdale, NY 10471 > > [hidden email] > > _______________________________________________ > > Koha mailing list Â http://koha-community.org > > [hidden email] > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > ________________________________ > > If you reply to this email, your message will be added to the discussion > > below: > > > http://koha.1045719.n5.nabble.com/Excel-to-MARC-Marcedit-5-8-tp5717503p5717… > > To unsubscribe from Koha, click here. > > NAML > > >-- >View this message in context: >http://koha.1045719.n5.nabble.com/Excel-to-MARC-Marcedit-5-8-tp5717503p5717… >Sent from the Koha-general mailing list archive at Nabble.com. >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca>

1 0

Re: [Koha] Excel to MARC - Marcedit 5.8
by Stacy Pober 26 Jun '12

26 Jun '12

There's an excellent support list for MARCEDIT called MARCEDIT-L. Terry Reese, the author of the program monitors the list, and he will often offer solutions along with some of the other list subscribers. http://metis3.gmu.edu/cgi-bin/wa?A0=MARCEDIT-L It's also a good way to give input on features you'd like to see or to find out whether someone already has solved a particular problem you're having. Stacy On Mon, Jun 25, 2012 at 9:18 AM, <koha-request(a)lists.katipo.co.nz> wrote: > 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. > -- Stacy Pober Information Alchemist Riverdale, NY 10471 stacy.pober(a)manhattan.edu

2 1

Koha send mails
by alaa Badri 26 Jun '12

26 Jun '12

Dear All I asked before how i can enable koha to sending overdue notices email to patrons I hope i get response ASAP Best Regards, Alaa BadriSystem and network administrator New Generation International Schools01227204728

2 1

Fwd: add 035 tag in MarcView or ISBD
by Hugo Agud 26 Jun '12

26 Jun '12

Dear all We wish to add the 035 tag into the Marcview, but we can't ....... If we're not wrong we have to modify* opac-MARCdetail.tt file, but it seems it already have the "tag"configured here* * * * <table id="marc"> [% FOREACH tab0X IN tab0XX %] <tr><th colspan="2">[% tab0X.tag %]</th></tr> [% FOREACH subfiel IN tab0X.subfield %] <tr> <td>[% subfiel.marc_lib %]</td> <td>[% subfiel.marc_value %]</td> </tr> [% END %] [% END %] We have also checked the koga framework and it is this posisiotn 0 => OPAC Intranet Editor !Collapsed any suggestion? thanks a lot! * -- *Hugo Agud - Orex Digital * *www.orex.es* * * Director Avenida Sarriá 29 · 08029 Barcelona <http://twitter.com/OrexDigital> :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539 33 30 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema. -- *Hugo Agud - Orex Digital * *www.orex.es* * * Director Avenida Sarriá 29 · 08029 Barcelona <http://twitter.com/OrexDigital> :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539 33 30 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

1 0

Solr and enhanced searching (WAS: Re: Koha Digest, Vol 80, Issue 40)
by Stacy Pober 26 Jun '12

26 Jun '12

Jared, Thank you for the explanation. When I looked at the link you provided: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8233 I was surprised to see the heading: "*Bug 8233* <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8233>-New search engine layer - introduce solr without breaking anything else" Isn't the "without breaking anything else" something that is assumed in the software development process? There have been times I've wanted to add "without breaking anything else" or something similar to every enhancement and bug fix request going to our vendor, but I hoped it was something implied in any enhancement request. The enhancement that gave our version of Koha phrase searching does indeed break another very important feature when it's activated. Perhaps this level of explicitness is the model we need to follow. This makes me think of an old comedy routine where a man asks a faith healer to cure his twisted hand. The preacher says, "Lord, make this one hand like the other" and the guy gets two twisted hands. ( * http://tinyurl.com/79s7jea )* -- Stacy Pober Information Alchemist Riverdale, NY 10471 stacy.pober(a)manhattan.edu On Mon, Jun 25, 2012 at 2:34 PM, <koha-request(a)lists.katipo.co.nz> wrote: > From: Jared Camins-Esakov <jcamins(a)cpbibliography.com> > To: Stacy Pober <stacy.pober(a)manhattan.edu> > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Koha Digest, Vol 80, Issue 38 > Message-ID: > <CALVDfQxf8yeR6q71tFpNRNsRYU_tajukqZ8jq3yXAN6RVKJhqA(a)mail.gmail.com > > > Content-Type: text/plain; charset=UTF-8 > > Stacy, > > How is it that no one has added this kind of searching to the community > > version of Koha? It's a major omission. > > > > I think it's a matter of funding and interest. A lot of developers[1] would > love to see better search lexing in Koha[2], but the cost would be rather > high, as it requires a more-or-less complete rewrite of the searching code > in order to work, and my impression is that the searching works well enough > for most people that it just isn't a priority for most organizations > funding Koha development. That said, I am in complete agreement that not > having a flexible search lexer in Koha is a serious omission[3]. > > People are so used to using quote marks and those operators in search > > strings that they often try to use them in Koha even though they don't > work > > as expected. One of the features in an "easy to use" OPAC is that the > > searching conforms to expected norms that the public knows from other > > common search interfaces. > > > > I'm astonished that no one in the world has added properly working code > > that would make the most widely understood phrase searching method > > (quotation marks) available in community Koha. > > > > Quotation marks for identifying longer strings in searches do work, > actually, though not quite the way we might like. What we (as librarians) > call a phrase search is (sorry for the tautology) a search for a phrase > which comprises one or more words. What Zebra, the search engine the Koha > uses, considers a phrase search is a search for a phrase consisting of one > or more words that comprise the entire subfield in which they appear. The > fallback is something closer to what we might consider a phrase search, but > the results can sometimes be slightly skewed (fortunately for us, my > experience has been that for the most part, the skewing is slight enough > that patrons are able to find what they want). This causes all sorts of > mind-bending confusion, particularly in the area of subject tracings[4]. > > > > As for the + and - operators, if anyone tries adding that, they have to > > code it as a two-character string (space+ or space-) to prevent confusion > > when users are looking for hyphenated words. > > > > Right now, depending on your settings, punctuation may either be ignored > (in which case "+mice -computer" will return results about computer mice > only) or considered to be letters (in which case the search will not return > any results at all). This is an example of what I was talking about above: > in order for + and - operators to really work, a lexer that can understand > them would need to be available to Koha. > > Is anyone in the Koha-verse working on adding a search mode that > > uses quotation marks and + - operators? I mean, aside from the buggy > > version we have in Liblime's LAK. > > > > There is work on incorporating solr into Koha, which is very promising, and > will fix some of these problems[5]. Solr-based searching should be > available in 3.10, I think. A patch[6] is currently undergoing QA to > integrate BibLibre's work on Solr into Koha, and I don't imagine it will > take too long for it to be pushed. :) > > Hope that helps. > > Regards, > Jared > > [1] Well, I would love to see better search lexing in Koha, and a few other > people have agreed with me that it would be a great idea (usually while > backing away slowly and hoping I don't explain how I think it should work). > [2] A lexer is the tool that takes the query a user enters and turns it > into a data structure that tells the search engine "this is an unambiguous > representation of what the user asked for, to the extent that the user > provided an unambiguous query." Right now Koha uses the query lexer > provided by Zebra. OCLC's query lexer understand query strings like > "pd:moz,wol,a" and turns it into a query that could be expressed in English > as "Search the derived personal name index for records where the first > component [i.e. last name] starts with 'moz' the second component [i.e. > first name] starts with 'wol' and the third component [i.e. middle name] > starts with 'a.'" > [3] I would love to correct the omission myself, but it's far too large a > project to do for "fun" (also, the code in question is rather painful to > look at, so it wouldn't even be that much fun!). > [4] Galen Charlton and I have both been doing work relating to authorities > and indexing recently that will help to resolve many of the issues with > heading linking and searching. (see, for example, > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7284 and > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7818 though there > are a number of other related bugs as well; most of C & P's > authority-related developments are grouped under > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8212) > [5] As I understand it, though, we will be trading Zebra's lexer for solr's > slightly more capable lexer, which is still not the ideal. > [6] http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8233 > > -- > Jared Camins-Esakov > Bibliographer, C & P Bibliography Services, LLC > (phone) +1 (917) 727-3445 > (e-mail) jcamins(a)cpbibliography.com > (web) http://www.cpbibliography.com/ >

2 1

Re: [Koha] No errors, but no search results
by Uy 26 Jun '12

26 Jun '12

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

2 1

Re: [Koha] Koha Digest, Vol 80, Issue 38
by Stacy Pober 26 Jun '12

26 Jun '12

How is it that no one has added this kind of searching to the community version of Koha? It's a major omission. People are so used to using quote marks and those operators in search strings that they often try to use them in Koha even though they don't work as expected. One of the features in an "easy to use" OPAC is that the searching conforms to expected norms that the public knows from other common search interfaces. This feature was commissioned from the vendor our library uses, PTFS, but it doesn't work properly. (It kind of works, but if you turn this feature on, the boolean searching in Advanced Search stops working correctly. As a result, many of the libraries that have it as an option don't use it.) I'm astonished that no one in the world has added properly working code that would make the most widely understood phrase searching method (quotation marks) available in community Koha. As for the + and - operators, if anyone tries adding that, they have to code it as a two-character string (space+ or space-) to prevent confusion when users are looking for hyphenated words. Is anyone in the Koha-verse working on adding a search mode that uses quotation marks and + - operators? I mean, aside from the buggy version we have in Liblime's LAK. -- Stacy Pober Information Alchemist [speaking for myself, not representing any institution or group] Riverdale, NY 10471 stacy.pober(a)manhattan.edu On Mon, Jun 25, 2012 at 9:18 AM, <koha-request(a)lists.katipo.co.nz> wrote: From: Robin Sheat <robin(a)catalyst.net.nz> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Spell-check/ Did you mean Message-ID: <4FE8322C.5050207(a)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

3 2

No errors, but no search results
by ShaneGreen 26 Jun '12

26 Jun '12

Hello, We have installed and are hosting Koha for a new local library. Everything seems to be running fine with the exception of Zebra. With the help of the forums we have eliminated all the zebra error messages, but we still do not get any results when searching. http://koha.1045719.n5.nabble.com/default-idx-no-such-file-td5716932.html This community is below the poverty level and so we have donated our servers and time. Any debugging we hire will have to come out of our own pockets, but we are at a standstill and so something has to be done. If you've got suggestions we'd love to hear them. Or if you're great at debugging, tell us what you'll charge to get it working. Smacking my forehead against the keyboard. . . . -- View this message in context: http://koha.1045719.n5.nabble.com/No-errors-but-no-search-results-tp5717315… Sent from the Koha-general mailing list archive at Nabble.com.

3 6