- Koha - lists.katipo.co.nz

some problems
by Nitesh Rijal 04 Feb '11

04 Feb '11

Dear all. I have been continuosly been developing a LIVE CD with Koha and GSDL integrated in it. Everything was fine until I upgraded to Koha-3.02.02. Please see the problems and suggest me if there is something that can be done. 1. If the database that koha uses is not empty, i.e. it has all the tables, then while running the web interface should it ask me for web installer? I think it should not, but it is asking. 2. I have made some changes in the database, i.e. added few system preferences of my own, for the integration and the table of content thing. Also I have added a new authorized value for fulltext link. The problem is that after the web installation, system preferences are not there while authorized value that I added are there. Is this normal? 3. I have deleted all the biblio records and biblio items from the database, then I imported a new set of marc record using bulkmarc import, using the "-d" switch as well. But still the results are shown in the search. After deleting the entries in zebraqueue table in the database, the results are not seen, but then the count of the result is still shown. Even if there are only 17 records in the system, it shows 29 of 17 records. What may be the solution to this? Please help me in these points. Regards. PS: The live cd I'm talking about can be downloaded at http://gsdlkohalive.sourceforge.net/ -- Er. Nitesh Rijal rijal.it(a)gmail.com http://niteshrijal.com.np http://facebook.com/openrijal http://twitter.com/open_zilla +9779841458173

2 1

Apache documentation
by Tom Hanstra 04 Feb '11

04 Feb '11

I'm having some install/setup problems with Apache that are probably all documented somewhere but I just have not come across it yet. Is there a good document which explains how to set up a generic Apache server and tie in the koha Apache includes properly. And then gives me a good understanding of what URL's should work when things are running properly? Thanks, Tom Hanstra -- ----------------------------------------------------------------------------- Thomas A. Hanstra Systems Administrator Hesburgh Libraries of Notre Dame Phone: (574)631-4686 213 Hesburgh Library Email: hanstra(a)nd.edu Notre Dame, IN 46556 Welcome back my friends, to the show that never ends. We're so glad you could attend. Come inside, come inside... ELP -----------------------------------------------------------------------------

2 1

Trouble getting zebra to work
by Doug Dearden 04 Feb '11

04 Feb '11

Hello all, I am having some trouble getting searches to work using zebra, and am suspicious that I may have caused my problems as I was going through the setup. I have set up a test server on Debian Lenny, using git to download koha. I am planning on doing some work that I hope to contribute back so chose a dev install when I was setting up. The files are in /home/doug/kohaclone and /home/doug/koha-dev . I was logged in as root when I ran the install routine, then changed ownership on all the files to the koha user later. After that, I restored one of my databases from my production server, copied the default koha-conf.xml and edited it to point to the correct database (named 'image'). I did the same with the koha-httpd.conf file, copying it and editing it where needed. While logged in as "koha", I would get an error when I tried to run rebuild_zebra.pl . I logged in as root and ran it that way and it didn't throw the error, but searches aren't finding anything. I then figured out that the new config files I created had root as the owner. I changed those to have koha as the owner. The rebuild_zebra.pl script would then run without throwing the error. I then read a post that indicated being logged in as root when running rebuild_zebra.pl would mess things up, as certain log files and lock files would get created with root as the owner and koha would not be able to access them. Any idea where I would find these files? I have several files in /home/doug/koha-dev/var/lock/zebradb/biblios but they are all owned by koha, not root. There is no koha directory in /var/log . I don't know what to expect from rebuild_zebra.pl . I am setting the KOHA_CONF and PERL5LIB variables. If I run "rebuild_zebra.pl -z -a -b" > /home/doug/zlog.txt the script appears to run (the cursor blinks for a bit, then the command prompt returns), and a 0 byte file named zlog.txt is created. If I change the system preferences setting to use the no zebra option, then run rebuild_nozebra.pl the indexes are built and searches work. Returning the system preferences to use zebra breaks things again. I have a feeling this is an ownership/permissions problem somewhere, either on some files or maybe relating to MySQL. I'm just not sure where to look or how to troubleshoot. Thanks for the look. Doug Dearden Director, IT School for Advanced Research (505)954-7220 sarweb.org Koha version: 3.03.00.014 OS version ('uname -a'): Linux SAR51Linux 2.6.26-2-686 #1 SMP Thu Nov 25 01:53:57 UTC 2010 i686 GNU/Linux Perl interpreter: /usr/bin/perl Perl version: 5.010000 Perl @INC: /home/doug/kohaclone /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 Apache version: Server version: Apache/2.2.9 (Debian) Zebra version: Zebra 2.0.45 (C) 1994-2010, Index Data ApS Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: ab5db8f3b991ecc823f92b3c8bfd22ede9b679df Using ICU

4 4

Re: [Koha] Vote for Koha Con 2011
by mohan pradhan 04 Feb '11

04 Feb '11

Dear Nicole Engard and All, Thanks for publication of official vote site for the location of Koha Con 2011 and announcing the ranking system. We would appreciate if you could develop a system by which country name should also be made mandatory along with the Name of Institution. The ranking system should also be made publicly open just like the present system i.e. whenever a vote is given. This will make the voting system more transparent. There should also be a system to give weightage system for counting vote. It should be country wise instead of Institution wise. Thanks, Mohan Raj Pradhan, M. Lib. Inf. Sc., MBA, Ph. D. General-Secretary Digital Library Network South Asia (DlnetSA) Associate Professor Central Dept. of Library and Information Science Tribhuvan University, Nepal Member-Secretary HealthNet Nepal On Thu, Feb 3, 2011 at 9:43 PM, <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: Trouble getting zebra to work (Chris Nighswonger) > 2. Re: [Koha-devel] Vote for KohaCon 2011 (Koustubha Kale) > 3. Logging of fines (Olugbenga Adara) > 4. Advice needed on fixing zebra issues resulting from upgrade > (Olugbenga Adara) > 5. Re: Koha Digest, Vol 64, Issue 8 (mohan pradhan) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 2 Feb 2011 18:42:33 -0500 > From: Chris Nighswonger <cnighswonger(a)foundations.edu> > Subject: Re: [Koha] Trouble getting zebra to work > To: Doug Dearden <dearden(a)sarsf.org> > Cc: Koha <Koha(a)lists.katipo.co.nz> > Message-ID: > <AANLkTi=4a8awhAUZwq8qM0GBm+yZmYoWzuP+JW=UpVCE(a)mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Hi Doug, > > > 2011/2/2 Doug Dearden <dearden(a)sarsf.org> > > > Hello all, > > > > > > > > I am having some trouble getting searches to work using zebra, and am > > suspicious that I may have caused my problems as I was going through the > > setup. I have set up a test server on Debian Lenny, using git to > download > > koha. I am planning on doing some work that I hope to contribute back so > > chose a dev install when I was setting up. The files are in > > /home/doug/kohaclone and /home/doug/koha-dev . I was logged in as root > when > > I ran the install routine, then changed ownership on all the files to the > > koha user later. After that, I restored one of my databases from my > > production server, copied the default koha-conf.xml and edited it to > point > > to the correct database (named ?image?). I did the same with the > > koha-httpd.conf file, copying it and editing it where needed. While > logged > > in as ?koha?, I would get an error when I tried to run rebuild_zebra.pl. > > I logged in as root and ran it that way and it didn?t throw the error, > but > > searches aren?t finding anything. I then figured out that the new config > > files I created had root as the owner. I changed those to have koha as > the > > owner. The rebuild_zebra.pl script would then run without throwing the > > error. I then read a post that indicated being logged in as root when > > running rebuild_zebra.pl would mess things up, as certain log files and > > lock files would get created with root as the owner and koha would not be > > able to access them. > > > > > > > > Any idea where I would find these files? I have several files in > > /home/doug/koha-dev/var/lock/zebradb/biblios but they are all owned by > koha, > > not root. There is no koha directory in /var/log . > > > > > > > > Check also files under /home/doug/koha-dev/etc/zebradb. > > Koha logs are in /home/doug/koha-dev/var/log > > > > I don?t know what to expect from rebuild_zebra.pl . I am setting the > > KOHA_CONF and PERL5LIB variables. If I run ?rebuild_zebra.pl ?z ?a ?b? > > > > /home/doug/zlog.txt the script appears to run (the cursor blinks for a > bit, > > then the command prompt returns), and a 0 byte file named zlog.txt is > > created. > > > > > > > > try './rebuild_zebra.pl -a -b -r -v' for verbose output and to completely > rebuild the indexes. > > > > If I change the system preferences setting to use the no zebra option, > then > > run rebuild_nozebra.pl the indexes are built and searches work. > Returning > > the system preferences to use zebra breaks things again. > > > > > > > > nozebra is basically deprecated and unsupported at this point in Koha > history. Avoid it like the plague. > > > > I have a feeling this is an ownership/permissions problem somewhere, > either > > on some files or maybe relating to MySQL. I?m just not sure where to > look > > or how to troubleshoot. > > > > > Probably permissions. Something here may be useful too: > http://koha-community.org/documentation/faq/searching/#18 > > Kind Regards, > Chris >

2 2

Can anybody that uses Epson Receipt Printers in Koha through Firefox send me a display on how the print out looks?
by James Ghiorzi 04 Feb '11

04 Feb '11

Hello everybody, Sorry for the exceptionally long subject. Can anybody that uses Epson Receipt Printers in Koha through Firefox send me a display on how the print out looks? Greatly appreciate any assistance. Respectfully, James Ghiorzi Library Assistant II San Benito County Free Library 470 Fifth St. Hollister, CA 95023 (831) 636-4107

3 3

Staged records auto match on ISBN
by Richard M. Jost 04 Feb '11

04 Feb '11

In the tools section, I recently tried to upload a file of MARC records to Koha. The match point was set to the ISBN (020$a) and I was notified of a match to a record already in my catalog. When I looked at the MARC records for the match however, the ISBN's are not the same and these two records should not have matched. This has happened several times and I am trying to figure out the reason for these matches. Any assistance would be appreciated! Here is the screen shot from the Staged records screen: [cid:image001.png@01CBC37F.571D1DE0] Here is the incoming record: [cid:image002.png@01CBC37F.571D1DE0] Here is the record that was already in our catalog: [cid:image003.png@01CBC37F.571D1DE0] ++++++++++++++++++++++++++++++++++++++ Richard M. Jost Information Systems Coordinator Senior Lecturer, The Information School University of Washington Gallagher Law Library L159 William H. Gates Hall, Box 353025 Seattle, WA 98195-3025 Voice: 206-685-4980 / Fax: 206-685-2165 rmjost(a)u.washington.edu ++++++++++++++++++++++++++++++++++++++

2 1

Re: [Koha] Koha Digest, Vol 64, Issue 8
by mohan pradhan 04 Feb '11

04 Feb '11

Dear Nicole Engard and All, Thanks for publication of official vote for the location of Koha Con 2011 and announcing the ranking system. We would appreciate if you could develop a system by which country name should also be made mandatory along with the Name of Institution. The ranking system should also be made publicly open just like the present system. This will make the voting system more transparent. There should also be system to give weightage system for counting vote. It should be country wise instead of Institution wise. Thanks, Mohan Raj Pradhan, M. Lib. Inf. Sc., MBA, Ph. D. General-Secretary Digital Library Network South Asia (DlnetSA) Associate Professor Central Dept. of Library and Information Science Tribhuvan University, Nepal Member-Secretary HealthNet Nepal Message: 2 Date: Wed, 2 Feb 2011 07:32:04 -0500 From: Nicole Engard <nengard(a)gmail.com> Subject: [Koha] Vote for KohaCon 2011 To: Koha <Koha(a)lists.katipo.co.nz>, Koha Devel <koha-devel(a)lists.koha-community.org> Message-ID: <AANLkTi=9097=wTxq= 5OgDq6MqGYWWNBMK3UG=DN0mWLC(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Hello all, I have published the official vote for the location of KohaCon 2011. The vote will remain open until the 17th of February (EST). Please enter one vote per person and rank your options with your most favorite as 1 and your least favorite as 4. If you won't go somewhere no matter what then don't vote for that location. Read the proposals before you vote: http://wiki.koha-community.org/wiki/KohaCon2011_Proposals Vote here: http://survey.web2learning.net/limesurvey/index.php?sid=15529&lang=en Thanks Nicole C. Engard Documentation Manager On Thu, Feb 3, 2011 at 12:53 AM, <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. Koha 3.6 Election in March (M. Brooke Helman) > 2. Vote for KohaCon 2011 (Nicole Engard) > 3. Re: Vote for KohaCon 2011 (Thomas Dukleth) > 4. Re: Koha license upgrade voting method (Chris Nighswonger) > 5. Advocating Koha for public libraries in Romania (Marius Stoica) > 6. Re: Vote for KohaCon 2011 (MJ Ray) > 7. Apache documentation (Tom Hanstra) > 8. HOW CAN I CUSTOMISE THE KOHA ? (rakesh vijayan) > 9. Cannot open koha2.2.9-w32-R1.Exe after download: unknown file > type (njuwigbo) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 2 Feb 2011 02:55:44 -0800 (PST) > From: "M. Brooke Helman" <abesottedphoenix(a)yahoo.com> > Subject: [Koha] Koha 3.6 Election in March > To: koha(a)lists.katipo.co.nz > Message-ID: <617438.69374.qm(a)web114702.mail.gq1.yahoo.com> > Content-Type: text/plain; charset=us-ascii > > Salvete! > > The community needs your help! Anyone willing to serve the community > in a > leadership capacity should list their name at > > http://wiki.koha-community.org/wiki/Roles_for_3.6 > > For information about what is involved, consult someone that's held > that > role in past. There's a list here > > http://wiki.koha-community.org/wiki/Release_Teams > > And please do show to vote. No vote, no complaining ;P > > Cheers, > Brooke > > > > > > ------------------------------ > > Message: 2 > Date: Wed, 2 Feb 2011 07:32:04 -0500 > From: Nicole Engard <nengard(a)gmail.com> > Subject: [Koha] Vote for KohaCon 2011 > To: Koha <Koha(a)lists.katipo.co.nz>, Koha Devel > <koha-devel(a)lists.koha-community.org> > Message-ID: > <AANLkTi=9097=wTxq=5OgDq6MqGYWWNBMK3UG=DN0mWLC(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hello all, > > I have published the official vote for the location of KohaCon 2011. > The vote will remain open until the 17th of February (EST). Please > enter one vote per person and rank your options with your most > favorite as 1 and your least favorite as 4. If you won't go somewhere > no matter what then don't vote for that location. Read the proposals > before you vote: > http://wiki.koha-community.org/wiki/KohaCon2011_Proposals > > Vote here: > http://survey.web2learning.net/limesurvey/index.php?sid=15529&lang=en > > Thanks > Nicole C. Engard > Documentation Manager > > > ------------------------------ > > Message: 3 > Date: Wed, 2 Feb 2011 12:43:01 -0000 (UCT) > From: "Thomas Dukleth" <kohalist(a)agogme.com> > Subject: Re: [Koha] Vote for KohaCon 2011 > To: "Nicole Engard" <nengard(a)gmail.com> > Cc: Koha <koha(a)lists.katipo.co.nz>, Koha Devel > <koha-devel(a)lists.koha-community.org> > Message-ID: > <afc10fa1123fca410ccb5aa67f0fb494.squirrel(a)wmail.agogme.com> > Content-Type: text/plain;charset=utf-8 > > I would appreciate people adding some informal range of expected > accommodation prices either to the wiki, > http://wiki.koha-community.org/wiki/KohaCon2011_Proposals , or on the > mailing list. > > > Thomas Dukleth > Agogme > 109 E 9th Street, 3D > New York, NY 10003 > USA > http://www.agogme.com > +1 212-674-3783 > > > > > ------------------------------ > > Message: 4 > Date: Wed, 2 Feb 2011 08:04:40 -0500 > From: Chris Nighswonger <cnighswonger(a)foundations.edu> > Subject: Re: [Koha] Koha license upgrade voting method > To: ????Nov????? :) <novamcccharles(a)gmail.com> > Cc: koha(a)lists.katipo.co.nz > Message-ID: > <AANLkTikbqJ=DqQ2gmaB2GjD_Z04nMdj+DiWqRDXH+HA6(a)mail.gmail.com<DqQ2gmaB2GjD_Z04nMdj%2BDiWqRDXH%2BHA6(a)mail.gmail.com> > > > Content-Type: text/plain; charset="utf-8" > > Hi Nova, > > Please notice the subject of this thread and only respond with comments > applicable to it. If you have an unrelated comment/question, kindly start a > new thread for it. > > Kind Regards, > Chris > > > 2011/2/2 ????Nov????? :) <novamcccharles(a)gmail.com> > > > Can anyone help me solving the zebra problem. Actually i need to make > > search in indian languages.. Thanks in advance. > > > > Regards > > Nova > > > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > >

2 1

Advice needed on fixing zebra issues resulting from upgrade
by Olugbenga Adara 03 Feb '11

03 Feb '11

Hello all, I am trying to upgrade a Koha installation from 3.0.1 to 3.2.2 I opted to install a fresh 3.2 on Ubuntu, then dropped the database and replaced it with the 3.0.1 database. Koha upgraded the database and though there were some few errors (Duplicate entry 'AllowRenewalLimitOverride' for key 'PRIMARY', Unknown column 'batch_id' in 'labels', Duplicate entry 'AllowNotForLoanOverride' etc) the upgrade worked quite well as far as I can tell. The installation was using NoZebra and searches work as usual. I changed to zebra (which was ok with the original 3.2.2 install), re-indexed but searches failed to work. On investigation, I discovered that the marc21 records in the upgraded database has different marc field mapping compared to the original 3.2.2 install. For instance Instead of 952$a as permanent location it is 952$d Instead of 999$c as biblionumber it is 090$c Instead of 999$d as biblioitemnumber it is 090$d Now I guess i have 2 options (from my knowledge) to correct this. Option 1: Change zebra configuration files so that the biblionumber etc will point to my upgraded installation's tags/fields. Option 2: Export out the Marc records and edit with markedit. Swap fields tags/fields as necessary and import back into Koha. Now my question is which option is the better? or do I have any additional option? if it's option 1, can someone recommend to me the zebra configuration files i need to change? If it's option 2, will other info like an item's check out history be affected? Suggestions/advice will be appreciated. Olugbenga Adara Mobile: 234-803-3220288

1 0

Logging of fines
by Olugbenga Adara 03 Feb '11

03 Feb '11

Hello all, Can anyone please confirm to me if the librarian who collected or wrote off a fine is logged. If it is not, then does anyone know the SQL to get this information out of the database? I have an installation running 3.0.1 and checking the fine log just puts kohaadmin (0) for all the fine events. Seems to me as if it is just logging the perl script "fines.pl". Upgrading to 3.2.2 just seems to do the same thing. Any help will be appreciated Olugbenga Adara Mobile: 234-803-3220288

1 0

Advocating Koha for public libraries in Romania
by Marius Stoica 03 Feb '11

03 Feb '11

Hi everybody !!! My name is Marius Stoica, I am a librarian at the Arad County Public Library<http://aradlibrary.org>from Romania. We are trying for some time to find the best and the most convenient Integrated Library System. We have finally two choices: our current ILS, a proprietary software that is immature and quite experimental and, of course, Koha. Next week I will make an official presentation of Koha and my colegues will have a trail period of about one week to test a Koha demo. Aftar that we will decide which of these two ILS to use and end this period of transition. In the last weeks I become quite familiar with Koha and a biG bIG BIG fan [?], I would like to see our library using Koha, even more, I would like to see a community of Koha users in my country. There are two small libraries that use Koha in Romania. Both are specialized academic libraries. Arad County Public Library <http://aradlibrary.org/> can be the first encyclopedic medium size library that uses Koha and this can be an extraordinary revelation for the other county libraries from Romania. Two ideas that can stand as a revelation: - first, there is the fact that with Koha you can implement a faster, easier and cheaper consortium network for all the libraries in a county, while in Romania there is no functional consortium of county public libraries; - second, there is the fact that librarians from Romania and the public servants in general are not aware of other choices regarding the IT infrastructure, i.e. free, open source software and the empowering and emancipation this kind of software can bring in the field of work. So, I want to have as many arguments as possible to advocate Koha in front of my colleges and the administration stuff of our library. I will appreciate any kind of support, advice or good thought. Warm regards, Marius Stoica

2 1