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

Koha Community Newsletter: December 2022
by Koha Newsletter 29 Dec '22

29 Dec '22

The Koha Community Newsletter for December 2022 is here: https://koha-community.org/koha-community-newsletter-december-2022/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

KTD - stable branches
by Tomas Cohen Arazi 23 Dec '22

23 Dec '22

Hi all, I made some pushes to the stable branches (22.11, 22.05 and 21.11) so the images are (internally) aligned with (master's) `ktd` command. Please let me know if you encounter any issues. Merry xmas everyone! -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

1 0

The many failings of background_jobs_worker.pl
by Philippe Blouin 22 Dec '22

22 Dec '22

Howdy! Since moving a lot of our users to 22.05.06, we've installed the worker everywhere. But the number of issues encountered is staggering. The first one was Can't call method "process" on an undefined value where the id received from MQ was not found in the DB, and the process is going straight to process_job and failing. Absolutely no idea how that occurs, seems completely counterintuitive (the ID comes from the DB after all), but here it is. Hacked the code to add a "sleep 1" to fix most of that one. Then came the fact that stored events were not checked if the connection to MQ was successful at startup. Bug 30654 refers it. Hacked a little "$init" in there to clear that up at startup. Then came the malformed UTF-8 character in JSON string, at character offset 296 (before "\x{e9}serv\x{e9} au ...") at decode_json that crashes the whole process. And for some reason, it never gets over it, gets the same problem at every restart, like the event is never "eaten" from the queue. Hacked an eval then a try-catch over it... After coding a monitor to alert when a background_jobs has been "new" over 5 minutes in the DB, I was inundated by messages. There's alway one elasticsearch_update that escapes among the flurry, and they slowly add up. At this point, the only viable solution is to run the workers but disable RabbitMQ everywhere. Are we really the only ones experiencing that? Regards, PS Our servers are well-above-average Debian 11 machines with lot of firepower (ram, cpu, i/o...). -- Philippe Blouin, Directeur de la technologie Tél. : (833) 465-4276, poste 230 philippe.blouin(a)inLibro.com inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>

6 12

Added Testing SSO guide to wiki
by David Cook 20 Dec '22

20 Dec '22

Hi all, At Martin's request at https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31651#c3 I've put together a wiki page for testing single sign on (SSO) using Keycloak in koha-testing-docker: https://wiki.koha-community.org/wiki/Testing_SSO#SAML It's a first draft, so it might not be perfect, but I was able to use Keycloak to log into Koha using OpenID Connect and SAML while writing the guides, so it should work. Note that the instructions are just for testing. They're not production instructions. The intention is just to provide this for Koha developers, so that everyone can easily work on Koha SSO patches without being a SSO expert or without having commercial 3rd party SSO services available. I hope people find it useful! Let me know if you have any feedback on how it can improved. (Note: I already know the formatting is awful, but I was in a hurry and I'm not familiar enough with Mediawiki to format it better. Maybe someone can give a hand there?) David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

1 0

HOLDPLACED should be emailed to item branch rather than patron branch
by David Cook 20 Dec '22

20 Dec '22

Hi all, I had some librarians raise to me that the HOLDPLACED email goes to the patron branch rather than the item branch. I've raised https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32499 to address this, but can anyone think of a reason why it should stay the patron branch and not the item branch? David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

1 0

ktd - enhancements
by Tomas Cohen Arazi 19 Dec '22

19 Dec '22

Hi all, just wanted to let you know that we solved a long standing issue in KTD [1] that made it awkward to switch from using ES or not with KTD (required tweaking the .env file and would break if things didn't match). The `ktd` command now takes advantage of this enhancement so, as a reminder, if you want to run KTD with ES 7 [2] you just need to run: $ ktd --es7 up Any questions about it, just ask on IRC or on this thread. Best regards [1] https://gitlab.com/koha-community/koha-testing-docker/-/issues/306 [2] ktd --help will show you all the available options -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

1 0

Jenkins notifications
by Tomas Cohen Arazi 15 Dec '22

15 Dec '22

Hi all, I've (finally) restored jenkins notifications, and I plan to send failure notifications to: - Release maintainers - QA team Developers whose commits are suspected to have broken the tests will still be notified. I created two forwarding addresses to simplify notifications as well. -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

2 1

Call for news - Newsletter December 2022
by Koha Newsletter 13 Dec '22

13 Dec '22

Hi I'm collecting news for the December 2022 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * 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

What's the definitive way to use Perl tidy in koha-testing-docker?
by David Cook 11 Dec '22

11 Dec '22

Hi all, I've heard a few people saying lately that they wish people would use Perl tidy more. So I used the ":Tidy" command in koha-testing-docker on my visual selection and I got the following: + $this_item->{shelves} = + Koha::Virtualshelves->get_shelves_containing_record( + { + biblionumber => $biblionumber, + borrowernumber => $loggedinuser, + } + ); But that goes against the Indentation coding guidelines from https://wiki.koha-community.org/wiki/Coding_Guidelines#Indentation So. what are we supposed to be doing these days? David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

3 3

Formally give up on trying to provide PostgreSQL DB support?
by David Cook 11 Dec '22

11 Dec '22

Hi all, Should we formally give up on trying to provide PostgreSQL support? I find it highly unlikely that we will ever provide it. We may as well close issues like the following: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7802 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11422 Over the last year or so, the Keycloak community has undergone a lot of conversations on database support. Historically, it's provided support for MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, and more. However, going forward, Keycloak plans to only provide first class support for PostgreSQL and CockroachDB databases. CockroachDB uses the same wire protocol as PostgreSQL, so really they're supporting 1 database type. You can read more about it all at the following links: https://www.keycloak.org/2022/02/dbs.html https://www.keycloak.org/2022/07/storage-map.html Personally, I really like PostgreSQL. I use it for a number of other projects. But I think we're pretty wedded to MySQL/MariaDB with Koha, and maybe we just need to own that? David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595

5 4