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

Re: [Koha-devel] [Koha] Invalid value "0000-00-00 00:00:00" in field "borrowers.updated_on" with LDAP
by Michael Kuhn 05 May '25

05 May '25

Hi Chris Many thanks for your message! You wrote: > My far from optimal "workaround" (yeah... permanent workaround :) ) > for this issue was to cron a shellscript to run every minute during > library hours which does this: > > /usr/bin/mysql -u *db user* -D "*library database name*" -e "update > borrowers set updated_on = NULL where updated_on = '0000-00-00 > 00:00:00';" &>> /home/*user*/quickfix.log; > > Anything bookended by *'s is redacted. The log catches any errors or > messages. > > I keep meaning to experiment with inserting a NULL value from the xml > LDAP config, but am yet to find a quiet moment for that. Also, not > sure if it's any better a solution, since much as it pains me to run a > polling-type script every minute, it fixes the issue when it's there > but otherwise does nothing with little overhead, whereas re-inserting > a NULL value only has the benefit of being a non-polling approach. > > Anyway, that's one way to do it. I now just implemeted the command in the crontab. It's about the same idea I alread use on my Koha demo installation to prevent some wise guys to change the password of the supreuser so they have the whole installation for themselves - there I reset the password every minute to the original one every minute. As Alex Buckley pointed out in mailinglist "koha-devel" the error is probably fixed with https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36822 in Koha 24.05.06. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch > On Mon, Nov 18, 2024 at 8:51 PM Michael Kuhn <mik(a)adminkuhn.ch > <mailto:mik@adminkuhn.ch>> wrote: > > Hi > > In an installation of Koha 24.05.03 I am successfully authenticating > against an LDAP server which is writing the data of the authenticating > user into the Koha database. But as soon as I search for the added user > in the staff client I get the message: "500: Internal Server Error. > Month out of range." This is because table field "borrowers.updated_on" > is automatically filled with the value "0000-00-00 00:00:00". > > I am aware of bug > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31143 > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31143> (We > should attempt to fix/identify all cases where '0000-00-00' may still > remain in the database) but of course it is not possible to manually > change the value of field "borrowers.updated_on" from "0000-00-00 > 00:00:00" to NULL every time a user successfully logs into the OPAC. > > So I tried to set the value of "borrowers.updated_on" by using lines > like the following, but unfortunately they all resulted in the invalid > value "0000-00-00 00:00:00". > > <updated_on is="">NULL</updated_on> > <updated_on is="potato"></updated_on> > <updated_on is="">2024-11-18 00:00:00</updated_on> > > How can I prevent Koha filling in this invalid value when > authenticating > against LDAP and instead generate a NULL value? > > Best wishes: Michael > -- > Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis > Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz > T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch > <mailto:mik@adminkuhn.ch> · W www.adminkuhn.ch <http://www.adminkuhn.ch> > _______________________________________________ > > Koha mailing list http://koha-community.org <http://koha-community.org> > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > <https://lists.katipo.co.nz/mailman/listinfo/koha> >

2 1

Karanga Mai | Call for Presentations for Kohacon25 Now Open!
by Chris Cormack 02 Mar '25

02 Mar '25

Kia ora koutou, We're very happy to announce that the call for presentations for KohaCon25 is now open! As Koha returns to Aotearoa for its 25th birthday, we're keen to hear your stories and insights for both our conference sessions and working together days. ## Te Kaupapa | Theme Our theme is "Coming Home" as we celebrate a quarter-century of Koha. We're particularly interested in presentations that: - Share success stories from your Koha journey - Highlight how Koha has grown and evolved since its beginnings in Horowhenua - Showcase innovative ways libraries are using Koha - Reflect on the impact of open source in libraries - Look towards the next 25 years of Koha ## Conference Days (17-19 November) We welcome presentations ranging from 15 minutes to 1 hour, including: - Feature showcases - Case studies - Community stories - Future visions - Lightning talks ## Working Together Days (21-23 November) We're seeking workshop proposals for our hands-on sessions, such as: - Technical workshops - Development sprints - Documentation improvements - Training sessions - Community initiatives - Collaborative problem-solving ## Ngā Kōrero | Presentation Details - All presentations will be in-person at Te Whanganui-a-Tara | Wellington - Sessions will be live-streamed for our global whānau - When submitting, please indicate your preferred time length and session type ## Tukua Mai | How to Submit Submit your proposal through our online form at https://cfp.kohacon.org/forms/kohacon25-talks-submission-lfe0lb by 1 March 2025. Your submission should include: - Title of your presentation or workshop - Abstract - Session type (conference talk or workshop) - Preferred length - Brief bio - Any technical requirements ## Important Dates - Submissions close: 1 March 2025 - Presenters notified: 15 March 2025 ## Questions? Flick us an email at chris(a)bigballofwax.co.nz if you have any questions. Share your story as part of this milestone celebration of Koha's journey home. Whether you're a long-time community member or new to the whānau, we'd love to hear from you. Ngā mihi nui, Chris

1 2

Introducing Koha Status Monitor - Open Source Solution for Library System Monitoring
by Atanu from Koha Support Team 28 Jan '25

28 Jan '25

2 2

Koha Community Newsletter: January 2025
by Michael Kuhn 27 Jan '25

27 Jan '25

The Koha Community Newsletter for January 2025 is here: https://koha-community.org/koha-community-newsletter-january-2025/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me (mik(a)adminkuhn.ch) with any corrections or suggestions. Michael Kuhn Editor, Koha Community Newsletter

1 0

REMINDER: Development Jitsi meeting 22 January 2025
by Paul Derscheid 21 Jan '25

21 Jan '25

Hi all, We have a Development Jitsi meeting scheduled for tomorrow: https://wiki.koha-community.org/wiki/Development_IRC_meeting_22_January_2025 Time converter: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+M… Please feel free to add any topics you’d like to discuss to the agenda or let me know and I am happy to add them for you. If you are lead or supporter of a roadmap project, we will be happy to get an update on progress. See you there! Paul

1 0

Roadmap 25.05 / Update
by Fischer, Katrin 20 Jan '25

20 Jan '25

Hi all, an update on the roadmap: https://wiki.koha-community.org/wiki/Roadmap_25.05 · At the last development meeting we decided on the first 2 sprint projects: o Sprint 1: Tidy the whole codebase (starting today) o Sprint 2: Refactor modal logic · Join the new Mattermost channel ‘Sprints’ to learn more, get updates and figure out how you can help! · The slot for ‘Sprint 3’ is still to be decided about. Please add your proposals to the wiki. · The ‘other development projects’ section still looks suspiciously empty. Please let us know what you are working on for 25.05! Have a great week! Katrin -- Katrin Fischer Bibliotheksservice-Zentrum Baden-Wuerttemberg (BSZ) 78457 Konstanz / Germany Phone: +49 7531 - 88 4934 E-Mail: katrin.fischer(a)bsz-bw.de http://bsz-bw.de

1 0

BibLibre community resources, hackfest, server update, shibboleth server
by Paul Poulain 16 Jan '25

16 Jan '25

Hello everybody, BibLibre provides some technical resources for Koha (and don't plan to stop) : * mailman mailing lists * hea server * mana-kb server * translation server (https://wiki.koha-community.org/wiki/Website_Administration) Some of them are pretty old, and would deserve an update. We plan to dedicate some time during the hackfest in Marseille (march 31-apr 4) to think and work on this (keywords: linux update, container/VM) BibLibre is also willing to provide a new community resource : IDP shibboleth. That would require a shibboleth server and a LDAP one. That will also require that, as a community, we decide who will administer it. Explanation: when we want to test a patch, we may need to alter the attributes returned, or enable a new Koha URL to use the IDP. We also plan to talk about that during the hackfest. -- 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

Activating preference "ILLModule" leads to error 500 in Koha 24.05
by Michael Kuhn 15 Jan '25

15 Jan '25

Hi When in Koha 24.05 trying to activate the system preference "ILLModule" it leads to error 500 when clicking Koha staff client menu "ILL requests" or clicking menu "About > System information". In file "/var/log/koha/<instancename>/plack-error.log" it says: Can't call method "GetPlugins" on an undefined value at /usr/share/koha/lib/Koha/ILL/Request/Config.pm line 118. This behavior appears in Koha 24.05.01 and 24.05.05 (but it works as expedted in 24.11) . Does anyone know the solution of this problem? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 2

Call for news - Newsletter January 2025
by Michael Kuhn 13 Jan '25

13 Jan '25

BETREFF: Call for news - Newsletter January 2025 Hi I'm collecting news for the January 2025 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * Relevant news items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text format criteria: * Just structured plain text, or * HTML text to include tables or similar For events: * Consider adding your event to the Koha Community calendar at https://koha-community.org/calendar/ Thank you! Michael Kuhn Editor, Koha Community Newsletter

1 0

Integration troubleshooting tips after upgrading to Debian 12 (Bookworm)
by Alex Buckley 09 Jan '25

09 Jan '25

Kia ora/Hello Koha community, Over the last few months we have been upgrading the OS of our Koha, database, load balancer and VuFind servers from Debian 11 (Bullseye) to Debian 12 (Bookworm). We have noticed two things which we thought might be helpful for others: 1) Third-party integrations using Stunnel (for example EZproxy) fail after the OS upgrade, if the vendor's stunnel.conf file is configured with: /sslVersion = TLSv1./ You will see an error like this in your /var/log/stunnel4/stunnel.log: /SSL_accept: ../ssl/t1_lib.c:3364: error:0A000076:SSL routines::no suitable signature algorithm/ By default, TLSv1 is NOT considered a suitable signature algorithm in Debian Bookworm. The integration vendor needs to update their stunnel.conf to/: sslVersion = TLSv1.2 /and a stunnel restart is needed on their end and on the Koha end. --- 2) SFTP file uploads (e.g. MARC or patron csv file uploads to Koha servers) fail if the server uploading the files is using a ssh-rsa public key. You would see the following error in your /var/log/auth.log file, when the uploading server accepts to connect: /userauth_pubkey: signature algorithm ssh-rsa not in PubkeyAcceptedAlgorithms [preauth]/ By default, Debian 12 does not support ssh-rsa public keys. Fix: A new key pair needs to be generated on the uploading server using a supported algorithm like SHA-2 or ED25519. That public key then needs to be copied into the authorized_keys file on your server to restore SFTP authorisation. We hope this information helps others. Thanks, Alex -- *Alex Buckley (he/him)* Developer, Implementation Lead | Rōpū kohinga *Catalyst.Net Limited - Expert Open Source Solutions* *Catalyst.Net Limited - a Catalyst IT group company* www.catalyst.net.nz <http://www.catalyst.net.nz> Follow Catalyst Koha on Twitter <https://twitter.com/catalystkoha> | Subscribe to the Catalyst Koha newsletter <https://catalyst.us4.list-manage.com/subscribe?u=62457ff5060d15ee3c07d3fc4&…> Catalyst Logo 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 2