- Koha-devel - lists.koha-community.org

Koha on Ubuntu LTS
by Paul 28 Jul '12

28 Jul '12

On 7/24/2012 I wrote: [snip] >Anyway, I've just repartioned the sandbox, installed a fresh 12.04 server, >and am right now wget'ting 3.6.7 >More later ... Just got back after a few days away. Installation all went well (did not install php package, but used php-pear leaving Apache2 as worker) OPAC and staff client both functional from LAN workstations. Restored a working db (3.6.1) to MySQL, Koha "did its thing" updating the db format, OPAC showed a "System Maintenance" placard, I re-indexed biblios and authorities (no problem), checked the cron-job for the incremental zebra indexing (working properly.) So everything fine except: MAJOR: OPAC is stuck with the "System Maintenance" page - I've rebooted (same result), so am looking for ideas, please, as to where to start looking. This is _not_ a browser cache problem. SEMI-MAJOR: The cron /etc/cron.d/koha (exactly as per Wiki, README, etc) only works if owner:group is root:root or root:koha (fails completely if koha:koha). This (because the "user koha" appears in field #6, and without it, it fails) is leading to the zebra incremental running twice: Jul 28 17:20:01 server2 CRON[2132]: (root) CMD (koha $KOHAPATH/bin/migration_tools/rebuild_zebra.pl -a -b -z &> /dev/null) Jul 28 17:20:01 server2 CRON[2135]: (koha) CMD ( $KOHAPATH/bin/migration_tools/rebuild_zebra.pl -a -b -z &> /dev/null) This leads to another: SEMI-MAJOR: From Koha dependencies (I think) nullmailer got installed. It is doing a serious job of bloating the mail.log and mail.err (both up to over half a Gig in a couple of hours, because each "double cron" appears to want to email: Jul 28 17:20:01 server2 CRON[2136]: (koha) MAIL (mailed 1 byte of output; but got status 0x0001, #012) Is there any way in Koha to turn off this type of mailing? Or should I look for another way of sending these things to /dev/null without logging? (I get the nasty feeling that nullmailer is attempting to recursively retry to send the whole queue *every minute* i.e. whenever another input is detected from the one minute zebra cronjob. MINOR: "Superlibrarian" permission flags (not names|passwords) got lost (so I couldn't log in until I reset them; same for two other staff members, and with no permissions even the correct password doesn't let you in.) All other "less than supers" were fine ... Looking forward to suggestions, thanks - Paul [Notes, fairly detailed, at <http://navalmarinearchive.com/research/koha_ubuntu.html>

4 3

Official Koha Newsletter: Volume 3, Issue 7: July 2012
by Daniel Grobani 27 Jul '12

27 Jul '12

[Below is the text of the newsletter. For active links and a more readable format, please visit http://koha-community.org/koha-newsletter-volume-3-issue-7-july-2012] Official Koha Newsletter (ISSN 2153-8328) Volume 3, Issue 7: July 2012 Edited by Daniel Grobani, Koha Community Newsletter Editor. Please submit news items to danielg.koha(a)gmail.com. Table of Contents Koha Development Koha 3.8.3 Released Koha 3.6.7 Released Koha Statistics Release Manager’s Newsletter Roles for Koha 3.12 Testing, Testing Koha Dashboard Koha Community New Koha Libraries Community Gossip Past Koha Events July General IRC Meeting Upcoming Koha Events August General IRC Meeting KohaCon13 Venue Decided Koha Development Koha 3.8.3 Released by Chris Cormack The Koha community is proud to release Koha version 3.8.3. This is a bugfix release, and contains a number of important fixes You can obtain Koha 3.8.3 here. Debian packages will be available here soon. Release notes are here. Koha 3.6.7 Released by Jared Camins-Esakov The Koha release team is happy to announce the release of Koha 3.6.7. This is a stable release and contains bugfixes as well as updated translations. You can download Koha 3.6.7 here. Release notes are here. Go forth, download, and enjoy. Koha Statistics Chris Cormack, Koha Community statistics wizard, has posted statistics for Koha 3.6.7, Koha 3.8.3, and Bugzilla statistics for June. Release Manager’s Newsletter Paul Poulain, Koha 3.8 Release Manager, publishes a monthly newsletter dedicated to Koha 3.8 development. It can be found on the Koha Community website in the Koha News category. The latest issue is here. Roles for Koha 3.12 With the release of Koha 3.10.0 scheduled for 22 October 2012, the community is thinking about roles for 3.12. Release Manager candidate Jared Camins-Esakov has submitted a proposal outlining his intentions should he be elected RM. Testing, Testing There are a lot of developments in testing and signing off this month. Pages on the community wiki have been created on unit tests, continuous integration, interface testing with WWW::Mechanize, and sandboxes. Koha Dashboard Chris Cormack has created a dashboard showing the last five sign-offs, the five oldest bugs needing sign-offs, new features recently pushed, new developers, Jenkins status, bug activity, bug statuses, a random bug, a monthly scorecard, important dates, and statistics on commits to master. The dashboard is a work in progress and can benefit from your contribution to its development. Koha Community New Koha Libraries Biblioteca Nacional De Venezuela (Venezuela) Chinook Library Network (USA) (via ByWater Solutions) Converse Free Library (USA) (via ByWater Solutions) Shire of Derby West Kimberley (Australia) (via Calyx) Waimate District Library (New Zealand) (via Catalyst) Community Gossip Elliott Davis has joined ByWater Solutions as Development Support Specialist. Elliott is also working on a proof-of-concept to port Koha to the Catalyst MVC perl framework. He’s also posted a guide to configuring LDAP with Koha. Stefano Bargioni has prepared an experimental Dewey AutoSuggester that retrieves data from dewey.info using SPARQL in jsonp format. He’s working on integrating it into Koha. In the meantime, a demo is available. Plano Independent School District, in Plano, Texas, has set up their own VM internally running Koha 3.6.x and gone independent from their original support company as of June 6th. Nicole Engard is working on adding to Koha the ability to search for items by color. Vimal Kumar V. has created Koha Live CD Lite, a lightweight Koha live CD based on Ubuntu 10.04 Gnome desktop and Koha 3.8.2. Joy Nelson has posted some recommendations for naming conventions when creating codes in Koha. Past Koha Events July General IRC Meeting The July general IRC meeting was held on 18 July 2012. More information, including the agenda and links to the minutes, is here. Upcoming Koha Events August General IRC Meeting The August general IRC meeting will be held on 8 August 2012. More information, including the agenda, is here. KohaCon13 Venue Selected The voting for the venue for KohaCon13 has ended and the top choice was Reno, Nevada, USA. Complete voting results are here.

1 0

Koha Catalyst Work
by Travis Elliott Davis 27 Jul '12

27 Jul '12

Hi Everyone, I have semi-recently been working on a port of Koha to the Catalyst framework. I started right after school was out and didn¹t get a chance to spend much time working on it. I am taking my last class this summer and will be done in August and would like to pick my work back up on this port. What I would like to do is solicit opinions for what I could do as a proof of concept. I started work on re-writing notices when it occurred to me that this may not be something that anyone is interested in seeing. For those of you that don't know Catalyst is an MVC based framework written in perl. I believe that moving Koha to Catalyst would not only clean up the codebase but also help with the logical flow of code. I know when I first started developing for Koha the two most daunting tasks were navigating the codebase, and figuring out what pointed where. I am not suggesting that we all jump on a giant rebase project right now, but I would like to look into it and get opinions. Catalyst has a very active development community and seems to be very well supported. It already has support for Template Toolkit, Apache Solr, Plack, and a whole lot more. If you want to find out what is supported (which I encourage) you can hit up their website at http://www.catalystframework.org/. You can also find my latest work at: https://github.com/libsysguy/koha-catalyst. It is obviously not complete but it will run and give you a basic idea of the code structure. Let me know your thoughts and ideas, I'm excited to hear what you have to say (Even if it is "Elliott you've lost your mind"). All the Best, Elliott Davis

4 4

Koha 3.4 end of life?
by Owen Leonard 26 Jul '12

26 Jul '12

This question has come up in the last few IRC meetings, but we need a broader consensus: Should development of 3.4 be officially ended? If so, how should this be handled? Discussion in today's IRC meeting brought up the question of whether it should be "killed" or merely "orphaned." I would appreciate some explanation from both sides about the definition of those choices so we can proceed to an informal vote. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

5 6

Re: [Koha-devel] [Koha-translate] KOCT translatable, please translate !
by Paul Poulain 26 Jul '12

26 Jul '12

Hello all, > (in koct/chrome/locale directory if you clone the git repo) It seems I was not clear enough: KOCT is not in the Koha git repo, but in contrib, where are KOCT and sandboxes scripts: git clone git://git.koha-community.org/contrib/global.git -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

5 7

Ubuntu : MySQL GUI Tools
by Fridolyn SOMERS 26 Jul '12

26 Jul '12

Hie devs, I work on Ubuntu 12.04. I'm used to MySQL tools : Query Browser and Administrator. If found this tools are not available anymore in Ubuntu repositories, proposing MySQL Workbench instead. If you whant to find old tools, use the Tolaris repository : http://www.tolaris.com/apt-repository/ Thanks to Ubuntu community. -- Fridolyn SOMERS Biblibre - Pôle Support fridolyn.somers(a)biblibre.com <mailto:fridolyn.somers@biblibre.com>

1 0

Sandbox servers provided by BibLibre
by Paul Poulain 25 Jul '12

25 Jul '12

Hello, On the wiki page, you can see that the wiki page dealing with sandboxes provided by BibLibre now present 6 sandboxes (3 UNIMARC and 3 MARC21), instead of 9 The reason is: * there was only a few use of the sandboxes, 6 publicly open should be enough * we have found some volunteers in France to dedicate time to testing (for example, one of them promised to dedicate half a day every week). So we have decided to dedicate them a specific/named sandbox. previous testN.sandbox.biblibre.com have been reclycled If you see URL with french cheese in the name of some comment (http://camembert.sandbox.biblibre.com) you'll know it's a "recycled" sandbox (complete spoiler = the 1st letter of the cheese being also the 1st letter of the 1st name of the volunteer. In this case : Camembert = Corinne. You'll also have Pelardon for Pierre and Serac for Sonia. New ones should be coming with Mathilde, Leila, and hopefully some others) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

Biblio.pm subject of a bug?
by Paul 25 Jul '12

25 Jul '12

Re: 3.6.6 Biblio.pm With preference set to "do not use zebra", saving an "item" fails: "Can't call method "subfield" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 3104" (z39.50 and adding biblios works fine.) I see that there's a # FIXME ... ?? in the .pm but can't [easily] find a related bug: 3102 # get title of the record (to store the 10 first letters with the index) 3103 my ( $titletag, $titlesubfield ) = GetMarcFromKohaField( 'biblio.title', '' ); # FIXME: should be GetFrameworkCode($biblionumber) ?? 3104 $title = lc( $record->subfield( $titletag, $titlesubfield ) ); I tried using the FIXME, same error. I'm getting very close to restarting this sandbox project -- certainly with 3.6.7, but also maybe reverting to Ubuntu 11.10 (at least for me, I'll have a solid comparison with our production server.) Thoughts anyone? I genuinely set out to try and help the community (and it just might turn out that Ubuntu 12.04 is problematic - does anyone here use it?) as well as ensure a smooth upgrade to our production server. Thanks - Paul

5 4

Proposal for a new coding guideline for command line scripts
by Paul Poulain 25 Jul '12

25 Jul '12

Hello koha-devel, I just pushed a few minuts ago a new script in misc (bug 8376, but it doesn't matter for this mail) This script has a help that is displayed when you run it with -h. So far so good. BUT, it has no PODDOC. Not so good. I've discovered recently that we could use: > use Pod::Usage; > > sub usage { > pod2usage( -verbose => 2 ); > exit; > } > <snip> > usage() if $help; That will deal with both POD and -h flag. It's used in some scripts like misc/maintenance/touch_all_biblios.pl Do we agree it's a good idea to request that for future scripts, and add this in the coding guidelines ? -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

10 9

zebraidx errCode=109
by Paul 25 Jul '12

25 Jul '12

Yesterday, I took the plunge and installed 3.6.6 on a brand new install of Ubuntu 12.04 server. Everything went swimmingly well ('restored' an old Koha db, data conversion succeeded) until: koha@sandbox:/usr/share/koha/bin/migration_tools$ KOHA_CONF=/etc/koha/koha-conf.xml PERL5LIB=/usr/share/koha/lib perl rebuild_zebra.pl -b -r -v -x ........ Records exported: 37190 ==================== REINDEXING zebra ==================== zebraidx(1981) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/norm..LCK [No such file or Directory] zebraidx(1981) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/shadow..LCK [No such file or Directory] zebraidx(1981) [fatal] Could not select database biblios errCode=109 (repeated for pid 1982 and 1983) ==================== CLEANING ==================== koha@sandbox:/usr/share/koha/bin/migration_tools$ I find in the records, that Chris C. had addressed this in June 2011 "Your answer is here, you are missing those directories, you will need to create them and make sure they are writable by the user you run zebra as" and that Robin had followed up "There is a patch I need to write (that I did as a one-off on a laptop that was experiencing this issue) that I really need to submit that will prevent this occuring." Could someone please tell me what the patch might be? (and possibly point me to what and where to create?) For the record, when I installed 3.6.1 (our production machine) earlier this year, this error did not occur. The only slight difference [not relevant?] was that I used Ubuntu 11.10 (12.04 had not been released), and that this time I did install a memcache server prior to Koha (I installed it after Koha was running on the production box.) Thanks and br, Paul --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

2 5