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

Re: [Koha-devel] [Koha-patches] [PATCH] Bug 6701 - login timeout is in seconds
by Robin Sheat 28 Mar '12

28 Mar '12

Dobrica Pavlinusic schreef op di 27-03-2012 om 15:20 [+0200]: > + - seconds of inactivity. Adding d will specify it in > days, e.g. 1D is timeout of one day. 'd' or 'D'? Perhaps good to be consistent :) (I spent a few days recently battling with an API because it turned out the docs had used both 'ca' and 'CA', and only one was right. I picked the wrong one.) -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D

2 2

Official Koha Newsletter: Volume 3, Issue 3: March 2012
by Daniel Grobani 27 Mar '12

27 Mar '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-3-march-2012] Official Koha Newsletter (ISSN 2153-8328) Subscribe Volume 3, Issue 3: March 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.6.4 Released Koha 3.8 Status Koha 3.10 Roles Release Manager’s Newsletter Koha Statistics Koha Community New Koha Libraries Community Gossip New Zealand Meeting Call Meeting Logs Past Koha Events Marseille Hackfest March General IRC Meeting Global Bug Squashing Week Upcoming Koha Events April General IRC Meeting KohaCon12 Koha Development Koha 3.6.4 Released by Chris Nighswonger It is with pleasure that I announce the release of Koha 3.6.4. The package can be retrieved from: http://download.koha-community.org/koha-3.06.04.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.06.04.tar.gz.MD5 http://download.koha-community.org/koha-3.06.04.tar.gz.MD5.asc http://download.koha-community.org/koha-3.06.04.tar.gz.sig Release notes for 3.6.4 are at http://koha-community.org/koha-3-6-4. Koha 3.8 Status Koha 3.8.0 is scheduled to be released on 23 April 2012. As of 26 March, 3.8 is in a feature freeze. Paul Poulain, Koha 3.8 Release Manager, has posted a roadmap to 3.8. Koha 3.10 Roles by MJ Ray With the release of Koha 3.8.0 scheduled for 23 April 2012, it’s time to start thinking about roles for the 3.10 series. We would like volunteers for: Release Manager Translation Manager Documentation Manager Database Documentation Manager Quality Assurance (QA) Manager Assistant QA Managers Specific Module maintainers Release Maintainers Packaging Manager (and grasshopper) Bug Wranglers (the more the merrier!) Meeting chair Anyone who wants take on any of these roles is more than welcome to write their name next to one on the Roles for 3.10 wiki page and perhaps link to their proposal. The community will vote on these during the April General IRC meeting, 4 April 2012 at 10:00 UTC +0000, straight after the release news. Please, consider stepping forwards to help lead Koha’s development. Release Manager’s Newsletter Paul Poulain, Koha 3.8 Release Manager, is publishing a monthly newsletter dedicated to Koha 3.8 development. It can be found on the Koha Community website in the Koha News category. The fourth issue is here. Koha Statistics Chris Cormack, statistician par excellence, has posted some recent stats on Koha: February bug/enhancement statistics Statistics for Koha 3.6.4 Koha Community New Koha Libraries Columbia County Rural Library District (via ByWater Solutions) Kalamaria Public Library (Thessaloniki, Greece) (via Union Catalog of Academic Libraries) Plum Creek Library System (via ByWater Solutions) Southern NH Library Cooperative (via ByWater Solutions) Walla Walla Public Library (via ByWater Solutions) Washoe County Library System (via ByWater Solutions) Wilderness Coast Public Libraries (via ByWater Solutions) Community Gossip Marc Balmer reports that he has integrated the proprietary arcapos point of sale system with Koha using the SIP protocol. This combination enables the sale of items in the library with seamless integration of fee processing and payment. More info is here. Stefano Bargioni has developed a Perl script to generate authority records from bibliographic records, which would be useful for migrating data to Koha from an ILS that lacks authority records. You can download the script and get more info here. Stefano would appreciate help with replacing XML::Simple with YAML::Sick and with preparing config files for non-MARC21. Mysore University Library has implemented a mobile version of their Koha opac. Kristina D.C. Hoeppner posted to her blog an account of her introduction to squashing bugs during Global Bug Squashing Week. Vimal Kumar V. has posted a survey to measure adoption and user perceptions of potential Koha users in India. Chris Cormack tweeted that by upgrading to Koha version 3.6.4, Horowhenua Library Trust, the New Zealand library that sponsored the original development of Koha, is now running a version of Koha containing a contribution by the 14-year-old son of the Trust’s Head of Libraries, Joann Ransom. Chris added that when the original Koha first went live, it also contained a contribution by the son of the Head of Libraries at that time. Chris has also posted info on using Koha with citation managers Zotero, Endnote, and RefWorks. New Zealand Meeting Call by Hannah Benbow We’re keen for another Koha users group meeting here in New Zealand. If you’d be interested in coming along, let me know so we can get an idea of interest. Contact me on: +64 4 917 6103 or email Hannah.benbow(a)treasury.govt.nz. I’ve heard really great things about the last meeting hosted by the Horowhenua Library Trust and would be keen for something similar—an opportunity for users to talk about how to get the best out of Koha and to share their knowledge and ideas. If there’s enough interest for this to proceed, the Central Agencies Shared Services Information Management team would be happy to host it here at Treasury. Meeting Logs by Galen Charlton Minutes and logs of community meetings that are recorded by MeetBot can now be found at http://meetings.koha-community.org/. I’ve updated all links to meeting minutes on the wiki and instituted a redirect from the previous URL base. I ask any webmasters who link to meeting logs to update their links accordingly. Past Koha Events Marseille Hackfest Paul Poulain has posted an extensive report on the Hackfest that took place in Marseille from 19-25 March. Gaëtan Boisson posted an earlier report. March General IRC Meeting The March general IRC meeting was held on 21 March 2012. More info, including the agenda and links to the minutes, is here. Global Bug Squashing Week 2012-03-19 by Magnus Enger Global bug squashing days are days designated to a concerted effort to get bugs and patches moving along in the right direction. A global bug squashing week is 5 global bug squashing days in a row. ;-) The week of 19-23 March 2012 was a global bug squashing week, coinciding with the Marseille Hackfest. More info is here. Upcoming Koha Events April General IRC Meeting The April general IRC meeting will be held on Wednesday, 4 April 2012. More info is here. KohaCon12 KohaCon12 will be held in Edinburgh, Scotland, UK, 5-7 June 2012. A hackfest will be held 9-11 June. This is a free conference for everyone interested in the Koha library system, which is Free and Open Source Software. There is no registration fee, but we will ask that attendees pre-register. Further calls, including calls for papers and registrations will be posted soon. Details (travel, hotels, agenda draft, etc) can be found linked from here. KohaCon12 is the fifth KohaCon, following last year’s successful conference in India which brought together users and developers worldwide. KohaCon12 will feature an international slate of speakers (both Koha users and active Koha contributors) conducting presentations and workshops on a diverse range of topics. Talks will cover a range of topics from general experiences of Koha through to technical information on the various modules. “We expect this event to have wide appeal,” said MJ Ray of host organisation and Koha support provider software.coop. “The conference is for both techies and non-techies. In addition to presentations on the technical side of Koha, the conference will be a demonstration of how users and developers around the world cooperate to improve Free and Open Source Software. software.coop is delighted to host KohaCon in Edinburgh in our tenth anniversary year and this UN International Year of Co-operatives.” “Koha conferences are always an informative and uplifting event, I have no doubt that this years conference in Edinburgh will be the best conference yet.” said Chris Cormack, one of the original authors of the Koha version 1.0.

1 0

3.8 feature freeze
by Paul Poulain 27 Mar '12

27 Mar '12

Hello koha-devel, 2 weeks ago I posted a mail about the release schedule, saying: March, 23th (1 month before the release) = feature freeze. April, 6th = strong feature freeze, string freeze April 20th = starting release process, everything frozen April 23th = release of Koha 3.8.0 The "feature freeze" was explained a little bit more on the wiki page: * No major enhancements will be included after this date for this release. By "major" I mean an enhancement that has many string change(s) and/or database change and/or introduce major changes in the core of Koha, with an important risk of side-effect. * other enhancements can still make their way into 3.8 * bugfixes can still make their way into 3.8 I couldn't push all what was passed QA on friday, so I pushed some patches today, without taking care of the feature freeze, that I declare for the end of today. Some have aked me what I would consider as a "major ENH", and what I would consider as a "not major enh" ? (that still can be pushed this or next week)? I've reviewed all the patches that are in "need signoff" or "signed off" status, and could find only 2 that fit the definition of "major ENH" * Bug 7710 - multiple holds per title * Bug 7818 - support DOM mode for Zebra indexing of bibliographic records Those bugs 1-are large 2-are related to the core of Koha 3- could have side effect So they will wait for 3.10. All other patches can still continue their way for Koha 3.8 For the following bugs i'll be double checking, because there is a risk of side effect that is not negligible, and I hesitated to put them in the previous list: * Bug 7420 - Add max fines to circulation matrix * Bug 7641 - Add ability to suspend reserves * Bug 7736 - Edifact QUOTE and ORDER functionality (the side effect of this one is negligible, but the patch is huge !) But if they have a strong signoff (or, better, 2) before the "strong feature freeze", I'll push them. Comment on some other bugs: Bug 7759 - Use Koha-Contrib-Tamil to update Zebra data in background => would be an alternative, not a replacement, so could push it. Also, as a conclusion: as the perltidy process has not reached a consensus -which I sincerely thought it had !- I won't do anything about it. -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

5 4

Fwd: [Koha-zebra] Apache issue
by Mason James 26 Mar '12

26 Mar '12

Begin forwarded message: > From: luis diaz <luisete2106(a)gmail.com> > Date: 24 March 2012 12:41:41 AM NZDT > To: koha-zebra(a)lists.koha-community.org > Subject: [Koha-zebra] Apache issue > > Hello > > I have a rhel6 server (Linux el6.x86_64 #1 SMP Fri Feb 10 15:22:22 EST 2012 x86_64 x86_64 x86_64 GNU/Linux) > Red Hat Enterprise Linux Server release 6.2 (Santiago) > > and I have install koha version 3.06.04 > So, all the steps have been done without errors, inclusive the compilation of all the perl packages. > But, I have an error with the apache configuration, the web pages do not appear, and I have this error: > > Internal Server Error > > The server encountered an internal error or misconfiguration and was unable to complete your request. > > Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error. > > More information about this error may be available in the server error log. > > Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request > > > I don't know what to look, the error_log do not helps here: > > [Fri Mar 23 06:43:20 2012] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) > [Fri Mar 23 06:43:20 2012] [notice] Digest: generating secret for digest authentication ... > [Fri Mar 23 06:43:20 2012] [notice] Digest: done > [Fri Mar 23 06:43:20 2012] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations > [Fri Mar 23 07:36:37 2012] [notice] caught SIGTERM, shutting down > [Fri Mar 23 07:36:38 2012] [notice] SELinux policy enabled; httpd running as context unconfined_u:system_r:httpd_t:s0 > [Fri Mar 23 07:36:38 2012] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) > [Fri Mar 23 07:36:38 2012] [notice] Digest: generating secret for digest authentication ... > [Fri Mar 23 07:36:38 2012] [notice] Digest: done > [Fri Mar 23 07:36:38 2012] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations > The specidif koha error log is empty: > > koha]# tail -200f /var/log/koha/koha-error_log > > Maybe I must disable this: > > SELinux policy enabled? > > Hope some one can help here. > > Thanks a lot in advance > > >

2 1

Adding support for PostgreSQL, no new MySQLisms, please
by Marc Balmer 24 Mar '12

24 Mar '12

Dear Koha-Devels, during the Marseille Hackfest 2012 I started together with Stephane and Christophe from BibLibre to add support for the PostgreSQL database. The ultimate goal of this work is that Koha can run on a PostgreSQL server as as good as it does now on a MySQL server. This mostly boils down to removing the MySQLisms in the current code, which I am currently doing. The collect-all-activity bug for this is 7365, it holds dependencies to the individual bugs like 7802, 7806 etc. (more to come, obviously). There is also a wiki page wiki.koha-community/wiki/PostgreSQL which I update frequently. This work also means that you must not add new MySQLisms in new code. Especially don't use backuotes in column names, write INSERT INTO foo (bar) VALUES (42); instead of INSERT INTO foo(`bar`) VALUES (42); For more idioms, consult above mentioned Wiki page, and if in doubt you can contact me, I am always willing to help with database issues. And please be advised that adding MySQLisms in new code will fail in QA. Thanks for your cooperation! If all goes well, this work should be concluded in a few months (but we are not in a hurry). - Marc Balmer

8 16

Next week is Global Bug Squashing Week!
by Magnus Enger 24 Mar '12

24 Mar '12

Dear Community, The deadlines for getting stuff into version 3.8 are drawing near: http://wiki.koha-community.org/wiki/Roadmap_to_3.8 As most of you are probably aware now, there will be a super cool hackfest in Marseille next week: http://drupal.biblibre.com/en/blog/entry/2012-hackfest-in-europe For those of us who can't be there in person, it's still possible to contribute to the fun, by joining the Global bug squashing week: http://wiki.koha-community.org/wiki/2012-03-19_Global_bug_squashing_week As far as I can tell, the beginning of this week will be the last chance for having new features signed off with any hope of getting them into 3.8. And there are bugfixes and minor improvements to look after. Not sure how you can help? Jump on the IRC channel ( http://koha-community.org/get-involved/irc/ ) and we will help you get started! And with the sandboxes provided by BibLibre all you need in order to join the fun is a web browser! http://wiki.koha-community.org/wiki/2012-03-19_Global_bug_squashing_week See you there! Magnus Enger

6 6

Hackfest 2012 in Marseille feedback
by Paul Poulain 23 Mar '12

23 Mar '12

Hello, If you want to know what we made during the hackfest i've written an entry in koha-community.org : http://koha-community.org/marseille-hackfest-2012-feedback/ Happy reading & thanks to all of those who came ! -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

Hourly loans -bug 5549- pushed, please test
by Paul Poulain 22 Mar '12

22 Mar '12

Hello, I just pushed a large patch that is related to hourly loans. It has been tested by a lot of ppl (including at the hackfest), but it's worth more tests, so feel free to update your git repositories and report the result of your tests here ! -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

For those running master
by Paul Poulain 22 Mar '12

22 Mar '12

Hello koha-devel, if any of you is running master, I pushed a large patch with a DB revision mistake yesterday. The 3.07.00.032 DBrev won't apply correctly. If you've already updated and have applied this DBrev, I suggest you run the following SQL commands: ALTER TABLE virtualshelves MODIFY COLUMN owner int; UPDATE virtualshelves vi LEFT JOIN borrowers bo ON bo.borrowernumber=vi.owner SET vi.owner=NULL where bo.borrowernumber IS NULL; DELETE FROM virtualshelves WHERE owner IS NULL and category=1; ALTER TABLE virtualshelves ADD COLUMN allow_add tinyint(1) DEFAULT 0, ADD COLUMN allow_delete_own tinyint(1) DEFAULT 1, ADD COLUMN allow_delete_other tinyint(1) DEFAULT 0, ADD CONSTRAINT `virtualshelves_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL; UPDATE virtualshelves SET allow_add=0, allow_delete_own=1, allow_delete_other=0 WHERE category=1; UPDATE virtualshelves SET allow_add=0, allow_delete_own=1, allow_delete_other=0 WHERE category=2; UPDATE virtualshelves SET allow_add=1, allow_delete_own=1, allow_delete_other=1 WHERE category=3; UPDATE virtualshelves SET category=2 WHERE category=3; ALTER TABLE virtualshelfcontents ADD COLUMN borrowernumber int, ADD CONSTRAINT `shelfcontents_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL; UPDATE virtualshelfcontents co LEFT JOIN virtualshelves sh USING (shelfnumber) SET co.borrowernumber=sh.owner; CREATE TABLE virtualshelfshares (id int AUTO_INCREMENT PRIMARY KEY, shelfnumber int NOT NULL, borrowernumber int, invitekey varchar(10), sharedate datetime, CONSTRAINT `virtualshelfshares_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `virtualshelfshares_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacAllowPublicListCreation',1,'If set, allows opac users to create public lists',NULL,'YesNo'); INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacAllowSharingPrivateLists',0,'If set, allows opac users to share private lists with other patrons',NULL,'YesNo'); If you haven't updated between yesterday and now, you have nothing to do, i've pushed a fix that will make your update work smoothly -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 1

Koha patron import
by ZUULU COOPER 22 Mar '12

22 Mar '12

Can anyone send me a copy a patron import file for me to try. I have run out of options. I recently installed Koha 3.06.04 Live DVD and I am getting errors the surname, borrowernumber, branchcode and categorycode. I do not know what I am doing wrong. I installed the Koha GSDL and I get the same error. I enter the some of sample data from the GSDL version into the LIVE DVD and I still get the same error. -- Zuulu Cooper Founder & Executive Director Libraries for Liberia Foundation 5919 Dakar Road West Suite 100 Westerville, OH 43081 614 270 3464 Skype: Shaka_zu00 website : http://librariesforliberiafoundation.com email: info(a)librariesforliberiafoundation.com *“Cause change and lead, accept change and survive, resist change and die.” * Ray Noorda - 1924-2006, technology pioneer, Novell Corporation CEO.

1 0