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

How to get CAS based Single Sign On working?
by Koustubha Kale 25 May '15

25 May '15

Hi All, I have a situation where we have a main website based on Joomla. This Joomla site uses CAS to authenticate users. We would like users ( who have already logged in to the Joomla site via CAS) to be able to follow a link to Koha site and be logged in automatically ( e.g. Single Sign On ). I have got simple CAS ( not proxy CAS ) working with Koha ( version 3.2.6 ) using the same CAS server as used by Joomla site. Still when I login to Joomla site with CAS, and then go to Koha and click on login and follow the CAS login link, I am asked to fill up CAS login information again. How can this be avoided by using CAS SSO? I have read through http://wiki.koha-community.org/wiki/SSO_CAS_improvements and am confused by the statement "Note: simple sso cas support (no proxy) has been done already by biblibre, is in testing and should be released in Koha 3.2" in there. Does this statement mean that SSO is possible with simple CAS? If yes how to set it up? If not, I have also read through bugs 6012, 5630 and the CAS Proxy examples. Frankly I haven't been able to figure out how I can achieve the above required functionality based on all the reading. Any help is much appreciated.. Another related query is, Is it possible to automatically create users in Koha once they have authenticated with CAS? Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2

3 3

koha-3.00.00 make fails
by Rick Welykochy 28 Dec '13

28 Dec '13

Hi all, I have downloaded http://download.koha.org/koha-3.00.00.tar.gz and began installing it on Debian/etch (in a Linux vserver environment). 0. FINE: cd koha-3.00.00 1. FINE: perl Makefile.PL 2. FAIL: make : : : Manifying blib/man3/C4::UploadedFile.3pm Manifying blib/man3/C4::BackgroundJob.3pm Manifying blib/man3/opac::opac-dictionary.3pm Manifying blib/man3/serials::member-search.3pm /usr/bin/perl "-Iblib/arch" "-Iblib/lib" fix-perl-path.PL blib /usr/bin/perl "-Iblib/arch" "-Iblib/lib" rewrite-config.PL blib/KOHA_CONF_DIR/koha-conf.xml Bad arg length for Socket::inet_ntoa, length is 0, should be 4 at rewrite-config.PL line 67. make: *** [blib/KOHA_CONF_DIR/koha-conf.xml] Error 255 Any ideas what went wrong and how to fix? Aside: there were a couple of other problems with this "out of the box" debian based install of Koha 3.0 which had to be fixed along the way, e.g. seven missing perl modules and libgd not found. I'll report on the entire process from unpacking to a running Koha/3.00.00 once I get to the end. cheers rickw -- ________________________________________________________________ Rick Welykochy || Praxis Services || Internet Driving Instructor The manual said Windows XP/SP2 or better so I installed Linux.

4 5

RM monthly newsletter
by Paul Poulain 29 Dec '11

29 Dec '11

Hello, I'll try to release every month a newsletter that will summarize what has been done during the previous month. i've started my job one month ago, so, here is my 1st newsletter == Starting my job == We had a few trouble to setup the permissions on git repository. Thanks to chris & brendan work, I could start pushing during the KohaCon11. I have written on the wiki how I push patches on git.koha-community.org (http://wiki.koha-community.org/wiki/How_the_RM_push) There are a few patches i've pushed directly (and only) on master branch. That's only documentation of typo fixes. == Roadmap == I've written a roadmap on the wiki (see http://wiki.koha-community.org/wiki/Roadmap_to_3.8) There are 2 differents parts on this roadmap: technical improvements and functionnal improvements. Some of those improvements already have a bugzilla entry, and some of them even have a patch. For technical improvements, i've made an omnibus entry: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7119 For functionnal improvements promized by BibLibre, there is an omnibus entry as well: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7163 I highlight 2 points on the roadmap that have seen some progress this month: === Updatedatabase news === There has been a lot of discussions about database update, and how to de-linearize the DB update process. The bug is the number 7167, and some code will be submitted very soon === YUI/Jquery stuff === We plan to remove YUI in favor of jquery. Owen has started a lot of work on this, you can look at bug 5481, that provide a link to his gitorious repository. We also have to replace the old calendar picker by a more recent one, owen's work does that as well Last comment on jquery: Julian has submitted some code in bug 6836. Jared & Owen are working on this patch, and I hope it will be signed-off & pushed quickly. One it's OK, the hardest part will have to be made= work on each page with a table to replace tablesorter by datatables ! == Important patch pushed == This paragraph highlight some patches that are not related to features, but to the code itself === mySQL error trapping === (Bug 7184) If you set DEBUG=1 in your Apache virtual host, any MySQL error will result in a die with the exact error. This will prevent Koha being silent in case of a wrong SQL query and help a lot fixing any problem === docbook documentation === (Bug 4877) Many documentation has been added to manage koha-* tools. Thanks to Magnus == Perl::Critic compliance == (Bug 6697) Many scripts have been updated to be Perl::Critic compliant. Thanks to chris for the effort, hoping other will join. It's quite "easy" to identify what must be done: just run "perlcritic scriptname.pl" to test if scriptname.pl is compliant or no. If it is not, you'll have errors detailled. For example: perlcritic tools/export.pl says: tools/export.pl: I/O layer ":utf8" used at line 59, column 5. Use ":encoding(UTF-8)" to get strict validation. (Severity: 5) == Hilighted patches needing signoff == All patches are worth being signed-off, but i'd like to hilight some of them: - Bug 6836, to replace tablesorter by datatable - Bug 7127, to have templates be valid XHTML - Bug 7240, to clean up the database from out-of-date datas (old imported_records for example) - Bug 6990, to improve performances of MARC to Koha decoding. This sub is called in many places, so the improvement will be a big boost ! - Bug 6875, to improve performances, by de-nesting nested C4::Packages. Some of the proposed bugs have already been pushed, but many are still to be signed-off. If everything was signed-off, that would mean -24% in the number of perl statements executed on mainpage.pl and -16% for opac-details ! - Bug 6716, to improve the database documentation. This will be usefull for schema.koha-community.org and all users wanting to build SQL queries == Bugzilla == When I push a patch, I usually check the following things: - is the patch "assigned" ? Sometimes, it's still "NEW". In this case, I set the patch to "ASSIGNED", and, if needed update the assignee to reflect the author of the patch pushed - if the patch is an ENH, set version to rel_3_8. Otherwise, set version to rel_3_6. It help chris_n knowing which patch must be pushed on 3.6.x, and will also help knowing what is in rel_3_8 == Jenkins == At the moment, jenkins says that master is unstable. It means some test have failed. If someone want to volunteer to investigate why and fix the problem, he will be warmly welcomed ! It can be because a patch has been pushed with a problem, or because the test is wrong. In this case, just fix the test in t/ directory, and, once it's pushed by me, jenkins will automatically run the updated test. See you next month for the 2nd RM newsletter ! PS: is this newsletter worth being published on koha-community.org website ? somewhere else (send me your ideas !) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

3 3

what is the need of the tables: deletedbiblio, deletedbiblioitems, deleteditems
by tanzeem 09 Dec '11

09 Dec '11

what is the need of the tables: deletedbiblio,deletedbiblioitems,deleteditems in the koha database. Does it have anything to do with restoring deleted biblio items.If yes then please explain how to restore deleted values -- View this message in context: http://koha.1045719.n5.nabble.com/what-is-the-need-of-the-tables-deletedbib… Sent from the Koha-devel mailing list archive at Nabble.com.

2 1

Fresh install 3.6.1
by Paul 30 Nov '11

30 Nov '11

Just built a new server (Ubuntu 11.10) and preparing it for a fresh install of Koha 3.6.1 -- we're trying to take all precautions ahead of time, so ran the Perl dependencies script: paul@nelson:~/koha/koha-3.06.01$ perl koha_perl_deps.pl -m -u [Wed Nov 30 09:07:17 2011] koha_perl_deps.pl: could not find ParserDetails.ini in /usr/local/share/perl/5.10.1/XML/SAX Installed Required Module is Module Name Version Version Required -------------------------------------------------------------------------------------------- Business::ISBN 0 * 2.05 Yes CGI::Session::Driver::memcached 0 * 0.04 No Gravatar::URL 0 * 1.03 No -------------------------------------------------------------------------------------------- Total modules reported: 3 * Module is missing or requires an upgrade. I would appreciate help on two points: 1) I don't know if that is the definitive list of "missing" dependencies, as koha_perl_deps.pl seems to be looking for ParserDetails.ini in a spot where it isn't: paul@nelson:~/koha/koha-3.06.01$ locate ParserDetails.ini /etc/perl/XML/SAX/ParserDetails.ini /usr/share/perl5/XML/SAX/ParserDetails.ini /var/lib/ucf/cache/:etc:perl:XML:SAX:ParserDetails.ini 2) memcached 1.4.6 *is* installed (haven't yet looked into the other two) Thanks in advance - Paul Paul Tired old sys-admin

2 1

Re: [Koha-devel] Bug 6328 (fine in days) and updatedatabase
by Paul Poulain 30 Nov '11

30 Nov '11

Hi chris_n, The 6328 patch has been QAed by Ian, and can now be pushed. BUT there is a problem that i'll try to explain: * as i've announced in my Koha 3.8 release notes and we've worked during KohaCon11 Hackfest, we're working on a new method to update database on a non linear way. Jonathan has written code for that. It works pretty well, i'm testing and there is only (I think) a remaining problem for fresh installs I plan to work on today. Then i'll submit the patch (see bug 7167). * my plan, until this is ready, is to queue all patches that have a database update. Thus, 3.8 will only have the new method for update. * The problem is for bugfixes that have a DB update and must be in 3.6. There should be only a few of them, but here is the 1st, so, we must deal with it. My proposition: * you apply this patch on the 3.6.x * when the new method is ready, we rewritte the patch for 3.8 updatedb At the end: * fresh 3.8 will have directly the correct DB * 3.6.2+ will be updated to have the correct DB. When upgrading to 3.8, the new updater will have to check for this and not try to update the DB once again * 3.6.0 upgraded to 3.8 will be upgraded through the new DB update, that will handle this case. Is there something i'm missing ? Are you OK with this proposition ? -------- Message original -------- Sujet: Re: Bug 6328 (fine in days) and QA Date : Sat, 19 Nov 2011 10:08:36 -0500 De : Ian Walls <ian.walls(a)bywatersolutions.com> Pour : Paul Poulain <paul.poulain(a)biblibre.com> Passed, with a note about a small template change still required on circ/circulation.tt <http://circulation.tt> around line 390. Not worth holding up QA for this, though, as a followup patch could be very easily generated. -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

6 18

New dates for GBSD: 2011-12-07 and 2012-01-06
by Magnus Enger 30 Nov '11

30 Nov '11

Yes, that's right, after some consultation on IRC I'm proposing two dates, to avoid the short notices that have been creeping up on us lately: http://wiki.koha-community.org/wiki/2011-12-07_Global_bug_squashing_day http://wiki.koha-community.org/wiki/2012-01-06_Global_bug_squashing_day And yes, 2011-12-07 is a Wednesday (some of us have been talking about trying another dey than Friday) and yes it does fall on the same date as the next general IRC meeting. The devious plan of the bug wranglers is to cajole people into squashing bugs after the meeting! ;-) See you there! Magnus

2 1

Testing patches with a lot of comments
by Paul Poulain 30 Nov '11

30 Nov '11

Hello koha-devel, I sometimes face patches that have a lot of comments, more than one patch, and it's not always easy to understand how to test the proposed patches. We need the following things to be very clearly explained: * test case / step to reproduce * which patch(es) to apply (* anything else ?) Does anyone see a way to have those points clearly displayed/described in the bug ? For example, look at bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5549, about hourly loans = 33 comments, it has only 2 small patches, it's clear more things are needed, maybe the git repo in comment 1. Or is it the one in comment 3? which repo does comment 6 use ? Maybe it's comment 25 in fact. Anyway, it's quite unclear, and, even with all my willingness, I don't know how/what to test. I took this example just because Eliott rises this bug a few hours ago on this ML. But it's not a single case. If anyone has a suggestion, it's welcomed !!! -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

2 1

Hourly Loans
by Elliott Davis 30 Nov '11

30 Nov '11

Hi Koha Devels, I am running the hourly loans branch in my production system and am merging it daily with master. It seems like this gets harder with each merge because of increasing code conflicts. Recently I have set up a branch to keep hourly up to date with master that is on github<https://github.com/libsysguy/koha-hourly>. As I'm sure most of you know I have been actively pushing to get the hourly branch merged into master. I am sending this message to the devel list in an attempt to possibly expedite this process. The issue that I believe we have is this branch is fairly untested which we all know can cause issues when pushed into prod. I am running this branch with no issues in production but I would like to see some other libraries pick up this branch and test. As a side note I think to really generate serious academic library interest in Koha the hourly loans module is a must. I know it was for us when we implemented Koha and not having it in master is really hurting us in regards to time solving merge conflicts. Let me know if anyone is interested. Best, Elliott Davis Robert R. Muntz Library University of Texas at Tyler

2 2

Official Koha Newsletter: Volume 2, Issue 11: November 2011
by Daniel Grobani 29 Nov '11

29 Nov '11

[Below is the text of the newsletter. For active links and a more readable format, please visit http://koha-community.org/koha-newsletter-volume-2issue-11-november-2011] Official Koha Newsletter (ISSN 2153-8328) Volume 2, Issue 11: November 2011 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.4.6 Released Koha 3.4.x String Freeze Koha 3.6.1 Released Request for Koha Data for Development Koha Community New Koha Libraries Community Gossip PTFS/LibLime Granted Provisional NZ Koha Trademark Past Koha Events KohaCon11 Reports November General IRC Meeting Global Bug Squashing Day Upcoming Koha Events December General IRC Meeting KohaCon12 Koha Development Koha 3.4.6 Released by Chris Nighswonger It is with pleasure that I announce the release of Koha 3.4.6. The package can be retrieved from: http://download.koha-community.org/koha-3.04.06.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.04.06.tar.gz.MD5 http://download.koha-community.org/koha-3.04.06.tar.gz.MD5.asc http://download.koha-community.org/koha-3.04.06.tar.gz.sig Release notes for 3.4.6 are at http://koha-community.org/koha-3-4-6. Koha 3.4.x String Freeze by Chris Nighswonger The 3.4.x branch will enter a string freeze on 30 November. Koha 3.4.7 will release on 7 December. Koha 3.6.1 Released by Chris Nighswonger It is with pleasure that I announce the release of Koha 3.6.1. The package can be retrieved from: http://download.koha-community.org/koha-3.06.01.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.06.01.tar.gz.MD5 http://download.koha-community.org/koha-3.06.01.tar.gz.MD5.asc http://download.koha-community.org/koha-3.06.01.tar.gz.sig Release notes for 3.6.1 are at http://koha-community.org/koha-3-6-1. Request for Koha Data for Development by Chris Nighswonger A common problem among those of us who do development work on Koha is the lack of complete datasets for the development and testing of features. This is probably more of a problem for those of us who do not support a large variety of organizations running Koha. I would like to see some good, sanitized datasets available for development and testing. Several of us have pleaded for this for years. Just now, the lack of a good dataset including a sizable number of serials is preventing me from doing some testing and development on DataTables integration work, which has been started by Biblibre. So, this is a request to all of you libraries out there with small, medium, or large datasets who would be willing to contribute sanitized data for development purposes, to do so. It would be a great way to give back to the community that has provided such a wonderful product with all of its attendant benefits. Kind Regards, Chris Nighswonger Koha 3.4/3.6 Release Maintainer cnighswonger(a)foundations.edu Koha Community New Koha Libraries Hernando County Public Library (via ByWater Solutions) Reserve Bank of New Zealand (via Catalyst) Shasta Historical Society (via ByWater Solutions) Community Gossip Albert Oller has joined ByWater Solutions as Development Support Specialist. ByWater Solutions has posted a Koha Testing Plan at http://bywatersolutions.com/koha-testing-plan/. Chris Cormack has posted a visualisation of when work is done on Koha at http://blog.bigballofwax.co.nz/2011/11/04/nice-visualisation-of-when-work-i…. Chris Hall is back working on Koha at Catalyst for the New Zealand summer. Ed Veal has joined ByWater Solutions as Development Support Specialist. Ian Walls writes about integrating Solr into Koha at http://bywatersolutions.com/2011/11/02/kohacon-11-solr-and-koha/. Laurence Lefaucheur is now posting a French translation of the Koha community newsletter at http://www.koha-fr.org/category/tags/newsletter. Paul Poulain, Koha 3.8 Release Manager, will be publishing a monthly newsletter summarizing 3.8 developments of the previous month. His first issue can be read at http://lists.koha-community.org/pipermail/koha-devel/2011-November/036525.h…. Paul Poulain has also posted a first draft of a document outlining how the release manager pushes a patch at http://wiki.koha-community.org/wiki/How_the_RM_push. PTFS/LibLime Granted Provisional NZ Koha Trademark PTFS/LibLime has been granted provisional use of a trademark for the use of the term Koha as it applies to Integrated Library Software (ILS) in New Zealand. PTFS’s press release is at http://www.liblime.com/ptfsliblime-granted-provisional-use-of-koha-trademar…. Joann Ransom’s plea to assist Horowhenua Library Trust in disputing the decision is at http://library-matters.blogspot.com/2011/11/plea-for-help-from-horowhenua-l…; her update is at http://library-matters.blogspot.com/2011/11/update-on-nz-koha-trademark.html. Nicole Engard is maintaining a bibliography of the dispute. Her initial post is at http://www.web2learning.net/archives/4910; updates are at http://www.web2learning.net/archives/4915 and http://www.web2learning.net/archives/4921. The entire bibliography can be viewed at https://www.zotero.org/groups/koha/items/collectionKey/RR77I3HT/order/dateM…. Past Koha Events KohaCon11 Reports KohaCon11 was held 31 October to 6 November 2011 in Thane, India. Bob Birchall reports: One of the exciting aspects of the Hackfest was that a Koha training course was conducted for about 36 local librarians and students. Run over two days, the course covered all major features of Koha. Trainers were Jo Ransom (New Zealand), Marijana Glavica (Croatia), Irma and Bob Birchall (Australia) and Savitra Sirohi (India); Brooke Johnson (US) helped out and ByWater Solutions provided the training Koha instance – a real international effort! It was a pleasure to teach these librarians who were so hungry for knowledge of Koha. Also during the Hackfest the translation of Koha into Hindi was progressed and translation into Marathi started. Congratulations to the staff and students of VPM Thane for this outstanding contribution to Koha. Robin Sheat reports: A few of us got together to work on improving Koha’s Open Library integration. On the OL side there was Noufal Ibrahim and Anand Chitipothu. From the Koha side, Dobrica Pavlinušić, Ian Walls, Savitra Sirohi, and I spent time discussing how to make things work. I then spent much of the hackfest adding features to Koha that would allow Open Library to become something of a central cover repository with streamlined uploading to it. At the same time, Anand was working on the APIs on the OL side that Koha would talk to to make this easy. This project is still a work in progress, but the current state can be seen at http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7152. For more stuff about the Open Library + Koha integration that went on, have a look at Noufal’s blog post at http://blog.openlibrary.org/?p=954. JoAnn Ransom blogged about some of her KohaCon11 experiences at http://library-matters.blogspot.com/2011/10/notes-from-day-1-of-kohacon11-i…. The slides from her keynote address are at http://www.slideshare.net/jransom/it-takes-a-village-9955138. Paul Poulain blogged about BibLibre’s presentations at http://drupal.biblibre.com/en/blog/entry/kohacon11-our-presentations. Mumbai-based newspaper DNA reported on KohaCon11 at http://epaper.dnaindia.com/epapermain.aspx?edorsup=Sup&queryed=37&querypage…. November General IRC Meeting The November general IRC meeting was held on 16 November 2011. For more info, including the agenda and links to the minutes, see http://wiki.koha-community.org/wiki/General_IRC_Meeting,_16_November_2011. Global Bug Squashing Day by Magnus Enger A Global bug sqashing day was held on 4 November 2011, and there was much rejoicing. For the numbers, see http://wiki.koha-community.org/wiki/2011-11-04_Global_bug_squashing_day. Upcoming Koha Events December General IRC Meeting The December general IRC meeting will be held on 7 December 2011. For more info, see http://wiki.koha-community.org/wiki/General_IRC_Meeting,_7_December_2011. KohaCon12 MJ Ray reports that KohaCon12 will probably be held 5-7 June 2012 for the conference and 9-11 June for the hackfest.

1 0