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

String Freeze Notice
by Joy Nelson 12 Aug '22

12 Aug '22

Greetings! Just a quick note that string freeze will go into effect at the end of day 12/16/2019 for the maintenance branches. Maintenance releases scheduled for the 23rd. Translations can begin on the 17th. Thanks! -- Joy Nelson President, Koha Division ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>

3 3

update MARC::Transform in debian.koha-community.org
by Stéphane Delaune 08 Jun '20

08 Jun '20

Hello, I'm Stéphane Delaune (aka reiveune) from BibLibre I am the developer of the Perl module MARC::Transform ( https://metacpan.org/pod/MARC::Transform ), this module is in version 0.003008 since april but, in debian.koha-community.org, the version is only 0.003006 that is 5 years old (2 versions late, including a bugfix) I would like to know if someone is able to update this package in debian.koha-community.org (and in https://packages.qa.debian.org/libm/libmarc-transform-perl.html on which the version is 0.003007) thank you in advance Stéphane Delaune

3 4

Build the easy way throws error
by M.Wahls 09 Apr '20

09 Apr '20

hi folks, I'm new to: koha, this community and the debian-build process I'm familiar with: linux (archlinux), software development I'm struggling while building the koha package. And get the following errors (here are the last few lines the build-script throws): make[1]: Leaving directory '/tmp/buildd/koha-19.05.09+20200110003754.96ab4982' fakeroot debian/rules binary dh binary --fail-missing --with bash-completion dh_testroot -O--fail-missing dh_prep -O--fail-missing dh_installdirs -O--fail-missing /tmp/buildd/koha-19.05.09+20200110003754.96ab4982/debian/koha-common.dirs: 1: /tmp/buildd/koha-19.05.09+20200110003754.96ab4982/debian/koha-common.dirs: etc/koha/sites: not found /tmp/buildd/koha-19.05.09+20200110003754.96ab4982/debian/koha-common.dirs: 2: /tmp/buildd/koha-19.05.09+20200110003754.96ab4982/debian/koha-common.dirs: var/cache/koha: not found /tmp/buildd/koha-19.05.09+20200110003754.96ab4982/debian/koha-common.dirs: 3: /tmp/buildd/koha-19.05.09+20200110003754.96ab4982/debian/koha-common.dirs: var/lib/koha: not found /tmp/buildd/koha-19.05.09+20200110003754.96ab4982/debian/koha-common.dirs: 4: /tmp/buildd/koha-19.05.09+20200110003754.96ab4982/debian/koha-common.dirs: var/log/koha: not found /tmp/buildd/koha-19.05.09+20200110003754.96ab4982/debian/koha-common.dirs: 5: /tmp/buildd/koha-19.05.09+20200110003754.96ab4982/debian/koha-common.dirs: var/lock/koha: not found /tmp/buildd/koha-19.05.09+20200110003754.96ab4982/debian/koha-common.dirs: 6: /tmp/buildd/koha-19.05.09+20200110003754.96ab4982/debian/koha-common.dirs: var/spool/koha: not found dh_installdirs: problem reading debian/koha-common.dirs: debian/rules:9: recipe for target 'binary' failed make: *** [binary] Error 127 dpkg-buildpackage: error: fakeroot debian/rules binary gave error exit status 2 E: Failed autobuilding of package I: unmounting dev/pts filesystem I: unmounting run/shm filesystem I: unmounting proc filesystem I: cleaning the build env I: removing directory /var/cache/pbuilder/build//1505 and its subdirectories Don't know if it's problematic but following the build output there are a lot fail-missings: dh_auto_build dh_auto_clean dh_auto_configure dh_auto_test dh_binary dh_build dh_clean dh_installdirs dh_prep dh_testdir dh_testroot dh_update_autotools_config changing the compatability-level of pbuilder wasn't helpful. My VirtualBox looks like this: 4GB Ram, variable filesystem size (max 32GB). Debian 8 (Jessie) is used (but Stretch has the exact same issues). Used the default installation from Debian, but XFCE as desktop environment. These packages where installed by myself: git, libmodern-perl-perl, pbuilder, dh-make, gnupg2, devscripts, dput, build-essential, module-assistant As root: m-a prepare; mount /usr/lib/virtualbox/additions/VBoxGuestAdditions.iso sh /media/cdrom/VBoxLinuxAdditions.run adduser marco vboxsfsu mounting host partition under /media/sf_Share as root: pbuilder create --distribution jessie ...and as root (like in the tutorial for building packages the easy way): pbuilder --login --save-after-login echo "deb http://debian.koha-community.org/koha stable main" > /etc/apt/sources.list.d/koha.list apt-get install wget gnupg2 wget -O- http://debian.koha-community.org/koha/gpg.asc | apt-key add - apt-get update exit checkout koha: cd /media/sf_Share (mounted host-partition) git clone git://git.koha-community.org/koha.git git checkout -b 19.05.x origin/19.05.x cd /media/sf_Share cp -rf koha koha-build cd /media/sf_Share/koha-build as root: /media/sf_Share/koha-build/debian/build-git-snapshot -v 19.05.09 -d Thats all i did. What am i doing wrong? Any ideas or more information needed? Best wishes Marco

4 7

Koha release 19.11.04
by Joy Nelson 31 Mar '20

31 Mar '20

Greetings! The Koha community is proud to announce the release of Koha 19.11.04. It includes 1 new feature, 6 enhancements, 44 bug fixes. The new feature allows libraries to easily modify due dates for checkouts. This was pushed to accommodate libraries needs during Covid-19. This does contain some untranslated strings. Apologies for any inconvenience this may cause. Details can be seen here: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24846 The full release notes are available at https://koha-community.org/koha-19-11-04-release/ Debian packages will be updated within a few days -- Joy Nelson President, Koha Division ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>

2 2

Minor update to atomicupdate files
by Renvoize, Martin 27 Mar '20

27 Mar '20

Hi all, With the push of 24131 we have a new method for reporting update success. I have updated the skeleton.perl file under installer/data/mysql/atomicupdate to match the new syntax but thought it would be worth sharing here too. The new syntax is: NewVersion( $DBversion, XXXXX, "Description"); The final parameter can be either a string or an arrayref of strings in which case each string will appear on its own line in the output. Note: At the moment this is not a required change and any patches you have already submitted with the old format will not fail QA. I will update them upon push. What does this change bring to the table I hear you ask? 1/ A slightly more concise syntax 2/ Nicely aligned multi-line descriptions 3/ A followup has already been pushed which adds timestamps to update lines. Many thanks, *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager Community Release Manager (19.11, 20.05) *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize(a)ptfs-europe.com *Fax:* +44 (0) 800 756 6384 www.ptfs-europe.com Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info(a)ptfs-europe.com

1 0

Re: [Koha-devel] Fwd: Koha and Ebsco OpenAthens
by Alex Buckley 25 Mar '20

25 Mar '20

Hi Paul, I've done an integration of Openathens with Koha using the mod_auth_mellon Apache module https://github.com/latchset/mod_auth_mellon (rather than using the EBSCO plugin). The workflow I did is: 1. Checked out the master branch of mod_auth_mellon 2. Navigated into mod_auth_mellon 3. Generated the Koha SP (Service Provider) XML metadata endpoint, cert and key file. ./mellon_create_metadata.sh <full_opac_test_site_url> <full_opac_test_site_url>/saml 4. Moved those files into a new directory /etc/koha/sites/<instance>/saml 5. Sent the metadata XML file I'd made to EBSCO and received their one back and put it in /etc/koha/sites/<instance>/saml 6. Edit Apache conf file ( /etc/apache2/sites-available/<instance>.conf ): <Location /> MellonEnable "auth" MellonUser "NameID" MellonSPPrivateKeyFile /etc/koha/sites/<instance>/saml/<opac_test_site_url>.key MellonSPCertFile /etc/koha/sites/<instance>/saml/<opac_test_site_url>.cert MellonSPMetadataFile /etc/koha/sites/<instance>/saml/<opac_test_site_url>.xml MellonIdPMetadataFile /etc/koha/sites/<instance>/saml/<client_supplied_metadata>.xml MellonEndpointPath /saml # Set environment variables with the values of IdP attributes MellonSetEnv "principalname" "<IdP_UPN_attribute_name>" MellonSetEnv "givenname" "<IdP_firstaname_attribute_name>" MellonSetEnv "surname" "<IdP_surname_attribute_name>" MellonSetEnv "email" "<IdP_email_attribute_name>" # Unset and reset X_REMOTE_UPN Header unset X_REMOTE_UPN RequestHeader unset X_REMOTE_UPN RequestHeader set X_REMOTE_UPN %{MELLON_principalname}e # Unset and reset the X_REMOTE_GIVENNAME Header unset X_REMOTE_GIVENNAME RequestHeader unset X_REMOTE_GIVENNAME RequestHeader set X_REMOTE_GIVENNAME %{MELLON_givenname}e # Unset and reset the X_REMOTE_SURNAME Header unset X_REMOTE_SURNAME RequestHeader unset X_REMOTE_SURNAME RequestHeader set X_REMOTE_SURNAME %{MELLON_surname}e # Unset and reset the X_REMOTE_EMAIL Header unset X_REMOTE_EMAIL RequestHeader unset X_REMOTE_EMAIL RequestHeader set X_REMOTE_EMAIL %{MELLON_email}e </location> Here the /IdP_UPN_attribute_name/ is the attribute (claim) that Openathens is sending to Koha in the SAML POST request, we're assigning it to the Mellon environment variable "principalname" and then putting it in the header as /X_REMOTE_UPN/ 7. Install the following packages: sudo apt-get install libapache2-mod-auth-mellon sudo s2enmod expires sudo systemctl restart apache2 sudo apachectl configtest sudo apachectl restart apt-cache policy libapache2-mod-auth-mellon sudo apt-get install liblasso3 sudo apachectl restart 8. Amend the koha-conf.xml file adding the following tags: <trusted_header_upn>X_REMOTE_UPN</trusted_header_upn> <trusted_header_givenname>X_REMOTE_GIVENNAME</trusted_header_givenname> <trusted_header_surname>X_REMOTE_SURNAME</trusted_header_surname> <trusted_header_email>X_REMOTE_EMAIL</trusted_header_email> 9. Somethings to note is that using mod_auth_mellon is that plack user runs as www-data so you will need to change the AssignUserID in the Apache conf to be: AssignUserID www-data <instance>-koha You'll also need to amend your debian/scripts/koha-plack script to replace: instance_user="${instancename}-koha" With: instance_user="www-data" Also please note when using mod_auth_mellon you'll need to make sure the Koha instance your setting this up for is on a standalone server (i.e. no other Koha instance on the server) because the changing of the user that Plack runs as introduces a security risk on a multi-instance server. 10. Change the ownership of /var/cache/koha/<instance> file, because Plack now running as /www-data/ can not read the file: sudo chown www-data -R /var/cache/koha/<instance> 11. You'll need to introduce a customization in C4/Auth.pm now (though I am shortly going to be upstreaming this customization so you'll see a bug report from me for it soon): 11a. Add a new subroutine get_header() - This retrieves the Openathens values stored in the header in the Apache conf: /sub get_header {/ // / my ($header) = @_;// // my $q = CGI->new();// // # Prepend HTTP_ as that's how they come through/ // / my $h_val = $q->http('HTTP_' . $header);// // return $h_val;// //}/ 11b. Amend C4::Auth->checkauth(): / / /my $trusted_header = C4::Context->config('trusted_header');// //my $trust_head_val = get_header($trusted_header) if $trusted_header; #Store the header values returned from get_header subroutine which are: UPN, givenname, surname and email in $trust_head_val hash. / .... Now above this line (/elsif//( //$emailaddress//) {/ ) add in a new elsif: / / /} elsif ($trust_head_val && $trust_head_val ne '(null)') {// // $userid=$trust_head_val;// // # This uses something like// // # <trusted_header>X_REMOTE_USER</trusted_header>// // # in koha-conf.xml, and checks that header on the incoming request.// // # If it is there and contains a user ID, we believe it and log the// // # user in with that. This is intended for things like plack behind a// // # reverse proxy that does auth, and puts the user ID into a header.// // #// // # Basically, we treat it just like basic auth.// // $cookie = $query->cookie(// // -name => 'CGISESSID',// // -value => '',// // -expires => '',// // -HttpOnly => 1,// // );// // C4::Context->_new_userenv(undef);// // $loggedin = check_user_exists($userid); #Call check_user_exists subroutine and check if there is a borrower.userid matching the UPN// // // // }// / Note: This is assuming the UPN Openathens is sending Koha matches/is stored in the borrower.userid. If Openathens wants to only use email i.e. the email address Openathens sends Koha in POST request matches borrowers.email then you'll need to amend the SQL query in check_user_exists. A couple more things to note: 1. If your Koha server is behind a load balancer then you need to include the https:// directive in the servername e.g. Servername https://demo.koha.com This is because SAML requires the web server to identify as the same server in the SP metadata (e.g. https://<URL>). But when a Koha server is behind a LB it does not identify itself including the https protocol so you need to include it. There is more detail on that here: https://jdennis.fedorapeople.org/doc/mellon-user-guide/mellon_user_guide.ht… I know that is for Fedora (I can't find the documentation link I had discussing it in a Ubuntu context) but it is the same principal. I hope all this helps and if you need any more information please let me know! Thanks, Alex On 25/03/20 5:00 am, Chris Cormack wrote: > > > ------------------------------------------------------------------------ > *From:* Paul Poulain <paul.poulain(a)biblibre.com> > *Sent:* 25 March 2020 4:57:14 AM NZDT > *To:* "koha-devel(a)lists.koha-community.org" > <koha-devel(a)lists.koha-community.org> > *Subject:* [Koha-devel] Koha and Ebsco OpenAthens > > Hello, > > does anyone have experience in setting OpenAthens for Koha. There's an > Ebsco plugin (https://github.com/ebsco/openathens-koha-plugin) but it > seems to be for old versions of Koha. > > any feedback highly appreciated ! > > -- > Paul Poulain, Associé-gérant / co-owner > BibLibre, Services en logiciels libres pour les bibliothèques > BibLibre, Open Source software and services for libraries > ------------------------------------------------------------------------ > Koha-devel mailing list > Koha-devel(a)lists.koha-community.org > https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > website : http://www.koha-community.org/ > git : http://git.koha-community.org/ > bugs : http://bugs.koha-community.org/ > > -- > Sent from my Android device with K-9 Mail. Please excuse my brevity. -- Alex Buckley Koha Developer Catalyst IT - Expert Open Source Solutions DDI: +64 4 803 2378 | Mob: +64 22 429 6157 | www.catalyst.net.nz CONFIDENTIALITY NOTICE: This email is intended for the named recipients only. It may contain privileged, confidential or copyright information. If you are not the named recipient, any use, reliance upon, disclosure or copying of this email or its attachments is unauthorised. If you have received this email in error, please reply via email or call +64 4 499 2267.

2 1

Koha and Ebsco OpenAthens
by Paul Poulain 24 Mar '20

24 Mar '20

Hello, does anyone have experience in setting OpenAthens for Koha. There's an Ebsco plugin (https://github.com/ebsco/openathens-koha-plugin) but it seems to be for old versions of Koha. any feedback highly appreciated ! -- Paul Poulain, Associé-gérant / co-owner BibLibre, Services en logiciels libres pour les bibliothèques BibLibre, Open Source software and services for libraries

1 0

Plugin with JS datatable
by Fridolin SOMERS 24 Mar '20

24 Mar '20

Hi, I've been working on a small plugin : https://github.com/biblibre/koha-plugin-users-by-permissions/ It shows a table with users and there permissions. JS Datatable is OK with Koha 18.11 but not with master. Whats wrong ? I could use some help ;) Best regards. -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> Software and system maintainer 🦄 BibLibre, France

3 4

remote training on Koha & covid-19
by Paul Poulain 23 Mar '20

23 Mar '20

Hello all, In France, we always move to the library for training. With the covid-19 we may have to do some remote training. Have you experimented remote training ? How does it go ? How do you organise the training ? Any hints ? Thanks for anything shared, that will be helpful for us ! -- Paul Poulain, Associé-gérant / co-owner BibLibre, Services en logiciels libres pour les bibliothèques BibLibre, Open Source software and services for libraries

3 3

Koha:::Logger configuration maintenance
by Tomas Cohen Arazi 20 Mar '20

20 Mar '20

Hi all. I'm not that familiar with our Koha::Logger class usage, but I noticed there's no 'api' target and it would be handy to have it. There's a bug for a 'sip' target and for other things. It looks like the main reason for adopting log4perl was the flexibility it provided, and it makes sense: many appenders, several options, centralized config, etc. The question is: how do we update people's config? We cannot just go edit their configs, right? The current log4perl.conf on each instance is generated using the template and adjusting the instance name. Has anyone thought about this update problem? Ideas? -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

3 4