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

Roadmap 23.11
by Tomas Cohen Arazi 21 Jun '23

21 Jun '23

Hi all, better late than never, here's the roadmap site for the upcoming 23.11 release: https://wiki.koha-community.org/wiki/Roadmap_for_23.11 As mentioned a few times already, that's where you should put your goals for the cycle, and the things you're willing to participate on. That way the release team knows who to reach and what to track. Enhancements and new features outside the roadmap document will have lesser priority for our non-infinite time. Team work is expected to take place. Best regards -- Tomás Cohen Arazi Theke Solutions (https://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

1 0

Synchronizing a Koha database with kohastructure.sql (Bug 34064)
by David Cook 21 Jun '23

21 Jun '23

Hi all, I think we've all encountered issues with a Koha database being out of sync with kohastructure.sql, and it's not a fun experience to have. Today, I ran into items.paidfor columns that have survived long past a 20.11.00 upgrade. While looking to resolve that across all my instances, I was thinking how there could be other quirks as well, so I thought it would be nice to have an audit script: "Bug 34064 - Compare kohastructure.sql against current database using database audit script" It's not 100% perfect, but it does a very good job of detecting differences between a live Koha database and kohastructure.sql, and provides suggestions on how to remedy the database. It could be further improved, but I'm quite happy with this first draft. I'd like to be able to run it using koha-foreach to get a sense of how in-sync my Koha databases are on a server. 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

2 2

Inventory improvements
by David Cook 19 Jun '23

19 Jun '23

Hi all, It's probably not the right time of year for inventory.pl improvements, but I've got a raft of changes for improving inventory.pl: Bug 31744 - Inventory tool can take a long time and never complete Bug 33989 - Inventory tool performs unnecessary authorized value lookups Bug 34051 - Koha::AuthorisedValues->get_description_by_koha_field not caching results for non-existent values If you dislike how slow inventory.pl is and how it has a tendency to timeout in managed IT environments, then you'll probably like these changes. I've applied the first 2 locally, and my librarians are much happier as a result. 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

Conflict between libossp-uuid-perl and libdata-uuid-perl
by Nigel Titley 16 Jun '23

16 Jun '23

I'm currently running 22.05.13-1 (oldoldstable) on Ubuntu Focal and I'm trying to update to 22.11.06-3 (oldstable) and perhaps eventually to stable However I'm getting the following complaint from apt The following packages have unmet dependencies: libossp-uuid-perl : Conflicts: libdata-uuid-perl E: Broken packages As far as I can see the sympa package depends on libossp-uuid-perl and koha depends on libdata-uuid-perl Before I start the laborious process of moving either Koha or Sympa to a different machine can anyone suggest a fix? It looks like koha introduced a dependency on libdata-uuid-perl between oldoldstable and oldstable Thanks for any help that anyone can offer Nigel

2 2

git-bz update
by Tomas Cohen Arazi 15 Jun '23

15 Jun '23

Hi all, I wanted to mention that the 'apply_on_cascade' branch for git-bz has been updated with a merge request from Andrii and Slava to upgrade it to Python 3. It should be bundled in the latest KTD. Kudos for them, and any issues you may find, please file a report on the project site [1]. Best regards [1] https://gitlab.com/koha-community/git-bz -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

1 0

Long-running inventory.pl causing timeout? There's a solution...
by David Cook 15 Jun '23

15 Jun '23

Hi all, I imagine everyone has encountered situations where a long-running inventory.pl has caused a timeout? Well, at https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31744 I have a solution (ie workaround). It requires running inventory.pl in CGI mode and without compression, so that it can stream null data out until the actual inventory output is ready. This prevents proxies from timing out while waiting for the inventory to process and print out its output. It works for both HTML and CSV output too. Ideally, it would be nice to have inventory.pl process in the background, but I think this is a very practical workaround that keep inventory.pl working until we can implement that more ideal solution. I'm going to have some libraries test the solution behind their corporate HTTP forward proxies and I'll let folks know on Bugzilla how that goes. I'm optimistic since all my testing has gone well so far. 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

koha docker debian container
by Waylon Robertson 14 Jun '23

14 Jun '23

is there a pre-rollled bullseye docker container with koha, elasticsearch, and memcache all pre-setup and ready to go, somewhere? one that i can koha-create, then import a old koha database into?

2 2

Call for news - Newsletter June 2023
by Koha Newsletter 13 Jun '23

13 Jun '23

Hi I'm collecting news for the June 2023 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

Useful fix for client IP address in plack.log for anyone running Koha behind a proxy
by David Cook 09 Jun '23

09 Jun '23

Hi all, Koha::Middleware::RealIP gives you the real client IP address in the Koha code when running Koha behind a proxy. However, I noticed that this real client IP address wasn't showing up in plack.log, and it really started to bug me. I discovered that Koha::Middleware::SetEnv was compromising the flow of the $env variable through the Plack middlewares, but I've fixed it: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33967 It was a crazy-making problem, but it was a very simple fix, and it will make your plack.log files much more useful. Simple yet comprehensive test plan too, so I hope that folk take a look at it. 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

Integrating MarcEdit on Linux with Koha
by David Cook 09 Jun '23

09 Jun '23

Hi all, Recently, I've been running the MarcEdit CLI tool cmarcedit.exe on Linux (using mono) to run task automations that were created by librarians using MarcEdit on Windows. I'm hoping to put together a Koha plugin to allow librarians to upload the tasks and choose which Koha MARC records to run them on. (In this case, it will be for export purposes rather than in-place updates, but easy enough for someone to change.) Does anyone think that sounds interesting? (Once the Koha REST API builds up a bit more for biblios/items and search, I was thinking of getting in touch with Terry Reese to see about improving the Koha integration in MarcEdit as well.) 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

2 1