December 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

Re: [Koha-devel] Improving permissions on lists (virtual shelves)
by Marcel de Rooy 02 Apr '12

02 Apr '12

Thanks all for responding to this inquiry. This was very helpful. I am merging here the results and will be posting them back to report 7310 or a wiki page. Feel free to correct me where I made the wrong conclusion. 1 Public lists in OPAC: Currently, a user should be logged in to create a list. I would strongly recommend to keep that restriction. A new preference is added that allows opac users to create public lists or does not allow that. Additionally, I would add the restriction that another opac user cannot change the list type of a public list to private list or change the list permissions when he did not create it (currently possible); the owner can do that or a staff member with permissions in the staff client. 2 Three new permissions per list: Add items, Delete own items, Delete other items. This makes the Open list type obsolete. 3 Share private lists with another patron (as described before). Can be turned on/off with a preference. 4 Staff client features: add an option under Tools to moderate inappropriate list names for public lists and shared private lists. (A library is free to use it or not.) Add staff list permission: allow to manage lists (virtual shelves). With that permission a staff member can moderate the list names as mentioned and access the staff Lists module. (He can change list type and permissions. He can take ownership of a public list if the owner has been deleted.) 5 [NEW] Deleting a patron should also delete his (unshared) private lists, his shares with private lists of someone else and clear owner on his public lists. [Currently, the virtualshelves table will contain lists (of any type) of deleted borrowers.] A new problem is what to do with shared private lists (still used by other patrons). Just deleting them would not be nice for those patrons. Just promoting them to public lists could not be ideal too; same for leaving this to be sorted out by the librarian. The best [pragmatic] solution is probably setting ownership to the first user that received a share on that list. (He already had access to those lists, but is now able to change settings on that list too.) ADDITIONAL COMMENT If a library does not allow public list creation in OPAC and does not share lists, how should a staff member change list type of a private list? This is not possible. You could say by design. It is the result of combining those two prefs. As a workaround, a staff member could enable public list creation, let the user change list type in opac and reset the pref. Or enable sharing lists, let the user share that list with staff member, accept it and reset the pref.

1 1

Speed improvement & T::T
by Paul Poulain 10 Feb '12

10 Feb '12

Hello Koha-devel, As I said during last IRC chat, I'm focusing on performance improvement those weeks. I've digged into Template::Toolkit, and here http://search.cpan.org/~abw/Template-Toolkit-2.22/lib/Template/Manual/Confi… I've found 2 options that look promizing : COMPILE_EXT and COMPILE_DIR The loading of the template seems to cost 150ms, and I feel that those 2 options could be usefull to speed up the process. Did anyone already saw this option before ? Is it something worth investigating more ? Here is the documentation of the 1st option: COMPILE_EXT >From version 2 onwards, the Template Toolkit has the ability to compile templates to Perl code and save them to disk for subsequent use (i.e. cache persistence). The COMPILE_EXT option may be provided to specify a filename extension for compiled template files. It is undefined by default and no attempt will be made to read or write any compiled template files. my $template = Template->new({ COMPILE_EXT => '.ttc', }); If COMPILE_EXT is defined (and COMPILE_DIR isn't, see below) then compiled template files with the COMPILE_EXT extension will be written to the same directory from which the source template files were loaded. Compiling and subsequent reuse of templates happens automatically whenever the COMPILE_EXT or COMPILE_DIR options are set. The Template Toolkit will automatically reload and reuse compiled files when it finds them on disk. If the corresponding source file has been modified since the compiled version as written, then it will load and re-compile the source and write a new compiled version to disk. This form of cache persistence offers significant benefits in terms of time and resources required to reload templates. Compiled templates can be reloaded by a simple call to Perl's require(), leaving Perl to handle all the parsing and compilation. This is a Good Thing. -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

4 6

software error
by kazi 14 Jan '12

14 Jan '12

Dear community, Is this a bug or some other error in 3.6.3.001. How to fix it? Date::Calc::Add_Delta_Days(): not a valid date at /usr/share/koha/opac/cgi-bin/opac/opac-user.pl line 113. With regards, Kazi -- View this message in context: http://koha.1045719.n5.nabble.com/software-error-tp5106744p5106744.html Sent from the Koha-devel mailing list archive at Nabble.com.

2 3

DataTables How-To
by Julian Maurice 30 Dec '11

30 Dec '11

Hi all! I just wrote a brief explanation on how to use the jQuery library DataTables in Koha pages. Here is the link http://wiki.koha-community.org/wiki/DataTables_HowTo Please feel free to give feedback and to contribute ;-) -- Julian Maurice <julian.maurice(a)biblibre.com> BibLibre

1 0

Official Koha Newsletter: Volume 2, Issue 12: December 2011
by Daniel Grobani 29 Dec '11

29 Dec '11

Official Koha Newsletter: Volume 2, Issue 12: December 2011 [Below is the text of the newsletter. For active links and a more readable format, please visit http://koha-community.org/koha-newsletter-volume-2-issue-12-december-2011] Official Koha Newsletter (ISSN 2153-8328) Volume 2, Issue 12: December 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.2 Released Koha 3.4.7 Released Koha 3.2.11 Released Koha 3.4.8 Status Koha Community New Koha Libraries Community Gossip Koha in Fiji Past Koha Events December General IRC Meeting Global Bug Squashing Day 2011-12-07 Upcoming Koha Events January General IRC Meeting Global Bug Squashing Day 2011-01-06 Marseilles Hackfest Koha Development Koha 3.6.2 Released by Chris Nighswonger It is with pleasure that I announce the release of Koha 3.6.2. The package can be retrieved from: http://download.koha-community.org/koha-3.06.02.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.06.02.tar.gz.MD5 http://download.koha-community.org/koha-3.06.02.tar.gz.MD5.asc http://download.koha-community.org/koha-3.06.02.tar.gz.sig Release notes for 3.6.2 are at http://koha-community.org/koha-3-6-2. Koha 3.4.7 Released by Chris Nighswonger It is with pleasure that I announce the release of Koha 3.4.7. The package can be retrieved from: http://download.koha-community.org/koha-3.04.07.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.04.07.tar.gz.MD5 http://download.koha-community.org/koha-3.04.07.tar.gz.MD5.asc http://download.koha-community.org/koha-3.04.07.tar.gz.sig Release notes for 3.4.7 are at http://koha-community.org/koha-3-4-7. Koha 3.2.11 Released by Chris Nighswonger It is with pleasure that I announce the release of Koha 3.2.11. The package can be retrieved from: http://download.koha-community.org/koha-3.02.11.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.02.11.tar.gz.MD5 http://download.koha-community.org/koha-3.02.11.tar.gz.MD5.asc http://download.koha-community.org/koha-3.02.11.tar.gz.sig Release notes for 3.2.11 are at http://koha-community.org/koha-3-2-11. Koha 3.4.8 Status by Chris Nighswonger Koha 3.4.8 will be released on 14 January 2012. The 3.4.x branch will enter a string freeze on 8 Jan 2012 00:00 UTC. Koha Community New Koha Libraries Centro de Investigación y Educación Popular – Programa por la Paz (via Organizadatos) Colegio San Bartolomé La Merced (via Organizadatos) Corporación Universitaria CENDA (via Organizadatos) Instituto Amazónico de Investigaciones Científicas, SINCHI (via Organizadatos) Red de Museodata para Bibliotecas de Museos (via Organizadatos) Community Gossip Equinox Software has bought a new office building and is moving into it. Kyle Hall has updated his Koha virtual appliances to 3.6, a complete rebuild using Debian 6.0 (Squeeze) instead of Lenny. For more info, see http://millruntech.com/koha/koha-virtual-appliances. Owen Leonard is working on replacing the YUI Library in Koha with jQueryUI. For more info, see his blog post at http://www.myacpl.org/koha/?p=701. Stefano Bargioni has made available MARCgrep.pl, a Perl script to filter or count MARC records based on the contents of tag names, indicators, or subfields. For more info, see http://en.pusc.it/bib/MARCgrep. Koha in Fiji by Smita Biswas I was seconded along with the Manager of Tauranga City Library, Jill Best, to implement Koha in the first public library in Fiji. The Nadi Town Council Library went live on Dec 6 2011 on version 3.6. We did it as a pilot project, which took about 4 months for me to learn and install on a local machine and then assist the Nadi Council IT officer to download a stable release. I then visited Nadi for a week along with Jill for implementation and training. We did a simple LAN set up between the Server and two staff machines, one being used for circulation and other for cataloguing and acquistion. Hopefully they will able to host their database on the web in the future. There is considerable interest among other Fiji public libraries, due to the enthusiastic campaign by Jill, who has been a long-time volunteer and donor of books to the Fiji Libraries. Since I had never worked with Koha or Linux I was finding it quite hard in the beginning just following the downloading instructions from the wiki. I am very grateful for the help provided by Steven and Richard from Technology Wise Ltd, Tauranga, NZ. They were amazing, they took me under their wing and assisted me with the first install. Thereafter I could do a second install under Richard’s guidance. Richard was also very good in assisting the Nadi Council IT officer to do the install, including working on his server remotely when the Council IT officer found it hard going due to lack of experience and knowledge of Linux. I also need to thank Paul Nielsen, Library Manager of Hauraki District Council Library, NZ, for helping me with the system settings. What a great user group we have here!! I am definitely a Koha convert now, seeing how easy it is to install and implement–this coming from a Librarian (with some systems backgroaund). I hope to convince our Council IT to consider Koha in future. I am also happy to talk to any other groups or libraries about my experience of doing this project. Jill is already lining me up for next year for Suva libraries and maybe Solomon Islands. I am just taking a breather at the moment. It was very very hot… Smita Biswas, ALIANZA, RLIANZA Collections & Information Manager Tauranga City Library Tauranga City Council Ph 07 5777260 M 0275999241 E smita.biswas(a)tauranga.govt.nz www.tauranga.govt.nz Past Koha Events December General IRC Meeting The December general IRC meeting was held on 7 December 2011. For more info, including the agenda and links to the minutes, see http://wiki.koha-community.org/wiki/General_IRC_Meeting,_7_December_2011. Global Bug Squashing Day 2011-12-07 by Magnus Enger A Global Bug Sqashing Day was held on 7 December 2011, and there was much rejoicing. For the numbers, see http://wiki.koha-community.org/wiki/2011-12-07_Global_bug_squashing_day. Upcoming Koha Events January General IRC Meeting The January general IRC meeting will be held on 4 January 2012. For more info, see http://wiki.koha-community.org/wiki/General_IRC_Meeting,_4_January_2012. Global Bug Squashing Day 2012-01-06 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. The next GBSD will be 6 January 2012. For more info, see http://wiki.koha-community.org/wiki/2012-01-06_Global_bug_squashing_day. Marseilles Hackfest by Paul Poulain BibLibre will be hosting a hackfest in Marseilles, France, from Monday to Friday, 19-23 March 2012. For more info, see http://drupal.biblibre.com/en/blog/entry/2012-hackfest-in-europe.

1 0

Re: [Koha-devel] FIXME in biblio.pm
by Paul 29 Dec '11

29 Dec '11

At 10:16 PM 12/16/2011 -0500, Chris Nighswonger wrote: >On Fri, Dec 16, 2011 at 10:12 PM, Chris Nighswonger ><<mailto:cnighswonger@foundations.edu>cnighswonger(a)foundations.edu> wrote: >On Fri, Dec 16, 2011 at 7:09 PM, Paul ><<mailto:paul.a@aandc.org>paul.a(a)aandc.org> wrote: >Lines 3006-3008 of <http://biblio.pm>biblio.pm called from ><http://additem.pl>additem.pl: >Â Â Â Â # get title of the record (to store the 10 first letters with >the index) >Â Â Â Â my ( $titletag, $titlesubfield ) = GetMarcFromKohaField( >'biblio.title', '' ); Â Â # FIXME: should be >GetFrameworkCode($biblionumber) ?? >Â Â Â Â $title = lc( $record->subfield( $titletag, $titlesubfield ) ); > >Before I start looking elsewhere, can someone kindly help me with the use >of FIXME comments? [snip] >Based on the commit message it looks like Joe was thinking that the second >argument passed to GetMarcFromKohaField might should be populated with the >results of GetFrameworkCode($biblionumber). In any case, it is still more >likely to be corrupted data than the empty framework parameter passed to >GetMarcFromKohaField that is causing your error. Just back from a few days holidays, I cannot find "corrupted data" (this was an sql dump of our 3.2 data file), EXCEPT that we appear to have completely lost "authorities." Could this be the "empty framework parameter" you mention? While I was away, our most experienced cataloguer entered 25 [biblios + items] at my request for debugging purposes. The biblios went fine, the items all produced the biblio.pm line 3009 error, but both OPAC and staff search find the items perfectly. However our "authorities" (personal names) which has some 15,000 entries is unsearchable (only the latest 25 appear.) Perhaps I'm way off-track, but this may have something to do with re-indexing zebra. I thought I had set up a cron job at 1 min intervals (as on the old server) but using both users (root and Koha) $ crontab -l gives nothing - so I am trying to set it up again, but find at <http://wiki.koha-community.org/wiki/Koha_on_Ubuntu> that "Do Either Option#1 [OPTION 1 is Highly RECOMMENDED for Koha version 3.06.02] or Option #2 DO NOT DO BOTH. Option #1: Use the Zebra Queue Daemon to manage indexing." I had always understood that the "daemon" was deprecated in favour of a cron job (has this changed for 3.6?) and am now afraid that the "daemon" may have been working in the background damaging {something} as our searches (staff and OPAC) find titles, authors etc -- just not "authorities." Fearing I'm getting into a potential mess here, could anyone please come up with suggestions? Thanks in advance and happy new year, Paul

1 0

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

mailman mailing lists hosting
by Paul Poulain 27 Dec '11

27 Dec '11

Hello & merry christmas, our contract with the provider that hosts the mailing lists (and also mails, DNS, and some other important things) will end on february 18th. We won't renew it for various reasons. So there are two options: * we move the mailing lists to a new server (a virtual one). * someone else want to host those mailing lists. To speak frankly, we (BibLibre) don't manage mailman for anything outside from koha mailing lists. So we are not experts in mailman, so if someone want to do it, we will be happy to switch. If no-one want to take the ball, we will continue on a new server, don't worry. So, the question: is there any volunteer ? -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

4 8