Re: [Koha-devel] Error on make

Hi Philippe, For your original/first problem, I have a short answer and a long answer. The long answer I'll include at the end of this email. The short answer is that the build step was copying Vue dist files you'd previously generated during your dev activities, setting them to a 444 read only

Re: [Koha-devel] Issues with database audit

Hi Pablo, Probably easier to have a conversation on Mattermost https://chat.koha-community.org/ but I’ll reply to you here. Yes, the warning is important. Don’t just blindly run whatever audit_database.pl prints out. I wrote it to only be a guide. I never intended people to actually run

Re: [Koha-devel] Koha-devel Digital asset management

We have some local customizations to embed the IIIF compatible Universal Viewer in Koha, dynamically generate IIIF manifests using a custom OPAC Perl script, and use Koha to serve the digital content instead of relying on a IIIF server (e.g. Cantaloupe). It's a bit hacky but it works. I'll DM yo

Re: [Koha-devel] Error on make

2 0899 -Original Message----- From: Koha-devel On Behalf Of David Cook via Koha-devel Sent: Wednesday, 7 May 2025 4:40 PM To: 'Philippe Blouin' ; koha-devel@lists.koha-community.org Subject: Re: [Koha-devel] Error on make Ahhh... I think I see. In "Bug 37911 - Prototype vue i

Re: [Koha-devel] Error on make

n older Debian container rather than a newer Ubuntu container, so that's interesting... I've got to take a phone call, but I'm going to come back to this shortly. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia O

Re: [Koha-devel] Error on make

e call, but I'm going to come back to this shortly. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 -Original Message- From: Koha-devel On Behalf Of David Cook via Koha-devel Sent: Wednesday, 7 May 2025

Re: [Koha-devel] Error on make

I have some more testing to do, but at a glance I think the problem is that we have generated files in our git working directory, and Make is trying to copy those over when they shouldn't exist at all. Give me a few minutes and I'll get back to you again... David Cook Senior Software Engineer P

Re: [Koha-devel] Error on make

Hi Philippe, I'm familiar with this type of error, but it's the first time I'm seeing mention of it for 'api/v1/swagger/swagger_bundle.json'. What do you see if you do "git log ./api/v1/swagger/swagger_bundle.json"? Are you sure that you're on "main" and not a custom branch? I'm on an up-to-d

Re: [Koha-devel] Koha, hackfest, bibframe, initiating discussion

Hi Paul, What was the outcome of BIBFRAME discussions at the hackfest in Marseille? David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 -Original Message- From: Koha-devel On Behalf Of David Cook via

Re: [Koha-devel] Koha, hackfest, bibframe, initiating discussion

Hi Paul, This is great to hear. I've added some comments, as I was actually thinking about BIBFRAME recently after a couple of libraries asked about Koha's support for it. I've also done a fair bit of work with RDF over the last 10 years both inside and outside of Koha. About 10 years ago, Ma

Re: [Koha-devel] REMINDER: Development Jitsi meeting 19 March 2025

Hi folks, I think that there is a problem with the time converter here? My email client says that I received this email at 18/03/2025 11:42pm Australia/Sydney time, and the time converter says the meeting was at 19/03/2025 1:00am Australia/Sydney time (or 18/03/2025 2:00pm UTC time). But then

Re: [Koha-devel] oom-killer / Out of memory: Killed process 1026641 (/usr/share/koha)

I just had a Koha OOM killed on a small server the other day, so I feel your pain. When you startup Starman, it won't be using very much memory, but the memory usage will grow with the more requests it serves. Part of that has to do with the loading of Perl modules needed by those new requests,

Re: [Koha-devel] oom-killer / Out of memory: Killed process 1026641 (/usr/share/koha)

HI Michael, That opac-search.pl log looks like a bot that is really stuck. That looks like it would yield an ever growing search query. Yeah, most bots don't honour robots.txt anymore it seems. Blocking bots that self-identify with user agent strings is certainly useful, but it wouldn't bloc

Re: [Koha-devel] Discussion around Koha ILS-DI endpoints expecting a CSRF token from third-party integrations

Hey folks, I’ve added a patch to “Bug 36560 - ILS-DI API POSTS cause CSRF errors”, although I’m not 100% sure it’s the best long-term option. It’s a practical short-term option, which I already use locally, but we need to do some thinking about the long-term as well… David Cook Seni

Re: [Koha-devel] Discussion around Koha ILS-DI endpoints expecting a CSRF token from third-party integrations

Hi Alex, As you may have seen, I’ve marked bug 37899 as a duplicate of bug 36560. ILS-DI doesn’t use cookie auth, so it’s not vulnerable to CSRF as such. (Of course, using IP authentication, it’s still problematic, but that’s a whole other story.) Locally, I’ve added an exemption to i

Re: [Koha-devel] Hackfest 2025 in Marseille

Looks good to me! Avoids Easter and school holidays. I really want to make it to a hackfest as well, although not sure if it’ll be this one. Going to keep my eye open for the dates… David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061

[Koha-devel] Issues with persistent TCP connections in Microsoft Azure cloud

Hi all, We recently migrated a busy Koha instance from an on-premises server to an Azure cloud server. During that move, we also took the opportunity to switch to using Elasticsearch (not located on the same virtual machine). Over time, we noticed that we were getting issues with SIP2 conn

[Koha-devel] What's your opinion on sorting facets with diacritics? (Bug 36947)

Hi all, Lari Strand pointed out on Bug 36947 that Koha doesn’t take into account diacritics when it sorts facet names. He talks about Elasticsearch there although it appears Zebra also has the same issue. The first proposed solution was to strip out the diacritics using Unicode::Normaliz

[Koha-devel] Bug 33092 - Add ability to search within a list

Hi all, Has anyone looked at this one? My first thought is that the list ID would need to be added to a repeatable subfield (e.g. 999$l) and indexed. That way it would be easy to allow any search engine query and then just wrap it like "() and (list_id=X)". But. it would mean that we'd

Re: [Koha-devel] Google OpenID Connect

The Google OpenID Connect specific functionality only targeted the OPAC. Probably because it’s the most common use case. (I wrote my own OpenID Connect integration for Koha about 10 years ago, and it only targeted the OPAC too.) However, Koha has a different more generic Oauth2/OpenID Connect

Re: [Koha-devel] SelfCheckoutByLogin

Hi long_sam, Thanks for your reply. You’re right; SAML does have single log out functionality. However, from my understanding it’s a “front-channel logout” mechanism that requires the redirecting of the user in the browser. With OpenID Connect, the “back-channel logout” is a request sent

Re: [Koha-devel] SelfCheckoutByLogin

Part of the reason is that it’s considerably more complicated and error-prone. If you log in using Google OpenID Connect, the self-checkout browser will retain your Google user session beyond your Koha self-checkout user session. Also, when Koha goes back to Google to authenticate someone el

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

I’m just finishing up the next version of the plugin which finds problem bib records, problem item records, and lets you fix 1 bib record and its X problem item records at a time. I’ll be putting it up online sometime in the next couple weeks. (I’m away a lot these couple of weeks, so tough

Re: [Koha-devel] [Koha] Error 500 when searching in Koha 23.11.0

Hi Michael, I don't think your database was properly upgraded, and doing these manual corrections isn't really going to be enough unless you go line by line through the upgrade scripts and figure out all the things that were missed. If you're able to, I would go back and try the upgrade again.

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

Magnus Enger via Koha-devel Sent: Friday, 12 April 2024 4:09 PM To: koha-devel@lists.koha-community.org Subject: Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL Den 12.04.2024 04:13, skrev David Cook via Koha-devel: > I have a RepairRecord plugin, so I might do a version

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

skrev David Cook via Koha-devel: > Hi all, > > I just wanted to share a (MariaDB) SQL report that I wrote for finding > bib records with invalid XML characters: > > select biblionumber from biblio_metadata where metadata REGEXP > '[^\\x{0009}\\x{000A}\\x{000D}\\x{00

[Koha-devel] Bug 36586 - Self-checkouts will get CSRF errors if left inactive for 8 hours

Hi all, We recently noticed that self-checkouts will generate CSRF errors when left unattended for over 8 hours (the lifetime of the CSRF token). Our solution is to use a timer to refresh the page every 8 hours or so, but open to other ideas. This will potentially affect Vue.js driven

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

e Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 From: Koha-devel On Behalf Of David Cook via Koha-devel Sent: Friday, 12 April 2024 11:36 AM To: 'Koha-devel' Subject: [Koha-devel] Finding invalid XML cha

[Koha-devel] Finding invalid XML characters in Koha data via SQL

Hi all, I just wanted to share a (MariaDB) SQL report that I wrote for finding bib records with invalid XML characters: select biblionumber from biblio_metadata where metadata REGEXP '[^\\x{0009}\\x{000A}\\x{000D}\\x{0020}-\\x{D7FF}\\x{E000}-\\x{FFFD}\\x{1000 0}-\\x{10}]+'; Newer versi

Re: [Koha-devel] Update to Koha 23.11.04 fails

Hi Michael, I've noticed that a bunch of the database changes for the additional_contents table can half-complete and not fatally fail in very ungraceful ways. In this case, I'd say an earlier update probably failed to rename "idnew" to "id". Hopefully this was a test upgrade, because otherwi

[Koha-devel] XZ Utils backdoor for Linux

Hi all, This isn't related to Koha per se, but I thought I'd share it for anyone who hasn't seen it: https://en.wikipedia.org/wiki/XZ_Utils_backdoor All the more reason to have things like Kohacon so that we actually know each other. David Cook Senior Software Engineer Prosentient Sys

Re: [Koha-devel] Elasticsearch sans Zebra

astiscearch and we have a process that deactivates zebra but we would love to see the change you proposed. I vaguely remember a bug where not having zebra running caused a problem (with background jobs i think) even if ES is in charge of indexing. cheers david (HKS3/www.koha-support.eu)

[Koha-devel] Elasticsearch indexing does not handle exceptions well

Hi all, I'm re-indexing Elasticsearch and I notice occasionally Elasticsearch will throw an exception when committing (e.g. Elasticsearch exception thrown: Request), and Koha just ignores it. That means that whole commit gets missed, so a default of 5000 records don't get indexed. You

[Koha-devel] Elasticsearch sans Zebra

Hi all, I have started using Elasticsearch more with Koha, and we're at a point of wanting to use Elasticsearch without Zebra for Koha. I came across "Bug 21820 - Zebraqueue should not be added to when only Elasticsearch is used" and it seems like other people are interested in this too.

Re: [Koha-devel] Random XSLT knowledge

ster_function with Koha functions to share? Marcel _____ Van: Koha-devel mailto:koha-devel-boun...@lists.koha-community.org> > namens David Cook via Koha-devel mailto:koha-devel@lists.koha-community.org> > Verzonden: vrijdag 8 maart 2024 03:02 Aan: 'Koha Devel' mail

[Koha-devel] SMTP servers requiring XOAUTH2

Hey folks, Is anyone using Koha with SMTP servers requiring XOAUTH2? It doesn't look like the Perl libraries used by Koha are anywhere near ready for it, but it looks like Postfix has an experimental plugin available: https://github.com/tarickb/sasl-xoauth2 or https://packages.debian.org/ex

[Koha-devel] Random XSLT knowledge

Hi all, I've been working on performance issues, and in the process I got looking at XSLTs. I just wanted to share that it's possible to pass strings to the XSLT's transform() method: -return $engine->transform($xmlrecord, $xslfilename ); #file or URL +return $engine->transform

[Koha-devel] PatternFly for design?

Hi all, Has anyone used PatternFly for designing? https://www.patternfly.org/ 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 __

[Koha-devel] Future of mod_security

Hi all, mod_security has had a troubled existence the past few years, but it looks like the company behind it has transferred it over to OWASP: https://owasp.org/blog/2024/01/09/ModSecurity.html Hopefully this means mod_security starts getting updated more. David Cook Senior Software

Re: [Koha-devel] Override sysprefs in Apache config

lay a message in the sysprefs if the staff client stating their likely override at the virtual host level. On Sun, 18 Feb 2024, 10:21 pm David Cook via Koha-devel, mailto:koha-devel@lists.koha-community.org> > wrote: Hi Magnus, Yeah, I was thinking it wouldn't make sense to

[Koha-devel] DataTables 2.0.0

Hi all, I do not intend to draw your attention to this in any meaningful way. I just wanted to point out that DataTables 2.0.0 was released on February 15th 2024 (https://cdn.datatables.net/2.0.0/). Just squirrel away that information in the back of your brain for later. David Cook Senior

Re: [Koha-devel] Override sysprefs in Apache config

From: Koha-devel On Behalf Of Magnus Enger via Koha-devel Sent: Friday, 16 February 2024 6:26 PM To: koha-devel@lists.koha-community.org Subject: Re: [Koha-devel] Override sysprefs in Apache config Hi! Den 16.02.2024 06:56, skrev David Cook via Koha-devel: > I think it might be partiall

Re: [Koha-devel] Override sysprefs in Apache config

I think it might be partially broken. As per https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16520 I added the following to the OPAC and the staff interface: RequestHeader add X-Koha-SetEnv "OVERRIDE_SYSPREF_LibraryName Potato\, Potato" It did indeed load into the OPAC. I

[Koha-devel] Override sysprefs in Apache config

Hi all, I've read this wiki page and tried this many times, and never ever gotten it to work. Is there something missing from these instructions? https://wiki.koha-community.org/wiki/Override_sysprefs_in_Apache_config David Cook Senior Software Engineer Prosentient Systems Suite 7.03

[Koha-devel] Session corruption in koha-testing-docker master

Hi all, The last two days I've noticed that my session is getting corrupted while I'm working on master in koha-testing-docker. I'm not touching the session myself, but seemingly randomly the session gets all kinds of DIBC data stuffed into it, and Koha seems to be parse it and Koha throws a fa

Re: [Koha-devel] Growing size of koha/koha-testing:master

vel] Growing size of koha/koha-testing:master On 24-02-04 23:30, David Cook via Koha-devel wrote: > Do we know what’s contributing to this? After running `ncdu /` from inside KTD Debian 10 (the smallest image it seems) - 661 M /kohadevbox/Cypress - 347 M /kohadevbox/node_modules - 95 M /koh

[Koha-devel] Growing size of koha/koha-testing:master

Hi all, I've noticed recently that koha/koha-testing:master has been steadily growing. At this point, it's about 4.37GB in size. For 21.11 I think it used to be about 2GB and 22.11 was 3.5GB. Do we know what's contributing to this? David Cook Senior Software Engineer Prosentient Sys

[Koha-devel] January point releases

Hi all, I think the January point releases have been done. Just curious when we'll see those flow through to the main repository? Thanks, David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online

Re: [Koha-devel] Dockerfile for koha/elasticsearch-icu:7.x image

can find the Dokerfiles here https://gitlab.com/koha-community/docker/koha-elasticsearch-icu and yes, they were just installing the ICU plugin El lun, 29 ene 2024 1:47, David Cook via Koha-devel mailto:koha-devel@lists.koha-community.org> > escribió: Hi all, Is there a pub

[Koha-devel] Dockerfile for koha/elasticsearch-icu:7.x image

Hi all, Is there a published version of the Dockerfile for the koha/elasticsearch-icu:7.x image? Is it just running "RUN /usr/share/elasticsearch/bin/plugin install --batch analysis-icu" or does it make other changes to the standard image as well? David Cook Senior Software Engineer P

[Koha-devel] 22.11.12 having package dependency problems?

I help out a few libraries running 22.11 straight from the community, and two libraries lately have had Koha go down during automatic upgrades to 22.11.12-1. koha-common mostly installs but fails to complete due to unmet dependencies: apt install koha-common -s Reading package lists... Do

[Koha-devel] "Online access" vs "Online resources"

Hi all, Detail pages say "Online resources" but search results say "Online access". I don't know if I've never noticed before or what but I had a librarian raise it today. I think it makes sense to harmonise so that they're both the same, but how do we choose which one? I've raised a t

Re: [Koha-devel] Using Elasticsearch in koha-testing-docker

env file. Le mar. 7 nov. 2023 à 03:55, David Cook via Koha-devel mailto:koha-devel@lists.koha-community.org> > a écrit : Hi all, I’m trying to use Elasticsearch in koha-testing-docker, and I would appreciate some assistance. Here’s the steps I’m taking: 1. Launch koha-testing

[Koha-devel] Using Elasticsearch in koha-testing-docker

Hi all, I'm trying to use Elasticsearch in koha-testing-docker, and I would appreciate some assistance. Here's the steps I'm taking: 1. Launch koha-testing-docker 2. Update Koha's sysprefs a. Change SearchEngine from "Zebra" to "Elasticsearch" at http://localhost:8081/cgi-b

Re: [Koha-devel] Last month before the release

responsibilize people (asking them to fix what they broke instead of fixing for them) and finally maybe have a live chat beginning of the cycle with RMaints and QA team to (re) explain how it works. Le vendredi 3 novembre 2023, David Cook via Koha-devel mailto:koha-devel@lists.koha-community.org

Re: [Koha-devel] Last month before the release

lease, responsibilize people (asking them to fix what they broke instead of fixing for them) and finally maybe have a live chat beginning of the cycle with RMaints and QA team to (re) explain how it works. Le vendredi 3 novembre 2023, David Cook via Koha-devel mailto:koha-devel@lists.koha-community.org> &

Re: [Koha-devel] Last month before the release

It’s not clear to me though how you look at Jenkins runs. Is it going to https://dashboard.koha-community.org/ and then clicking on one of the badges to go to Jenkins like https://jenkins.koha-community.org/job/Koha_Master_U22/ and then clicking on “Latest Test Result”? David Cook Senior S

Re: [Koha-devel] Last month before the release

What’s the best way to do this? I think Jenkins might send emails, but I think my mail server blocked it ages ago as spam. 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

Re: [Koha-devel] Memory footprint of Koha processes

Hi Philippe, I run quite a few Koha instances, so I feel your pain. A couple months ago I opened https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34477 but I haven’t dedicated any time to work on it yet (and I have no plans to work on it anytime soon). The ORM eats up a lot

Re: [Koha-devel] Anyone else having issues attaching patches to Bugzilla?

Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 From: Koha-devel On Behalf Of David Cook via Koha-devel Sent: Monday, 23 October 2023 1:47 PM To: 'David Nind' Cc: 'Koha Devel' Subject: Re: [Koha-devel] Anyone else having issues attaching

[Koha-devel] I'm not getting your emails on bugs...

Hi all, It looks like my "bugmail has been disabled" for the last 10 days on Bugzilla, so if I haven't responded to a comment on Bugzilla, it's not because I'm ignoring you. It's because I'm not getting the emails. (If an administrator sees this, please re-enable my bugmail. Thanks!) I've b

Re: [Koha-devel] Anyone else having issues attaching patches to Bugzilla?

Subject: Re: [Koha-devel] Anyone else having issues attaching patches to Bugzilla? Hi David. It's working for me, just signed of a patch - git bz attach -e X HEAD So it must be you! 8-) David Nind New Zealand On Mon, 23 Oct 2023 at 15:25, David Cook via Koha-devel mailto

[Koha-devel] Anyone else having issues attaching patches to Bugzilla?

Hi all, Trying to attach a patch to Bugzilla this afternoon and I get the following error: Cleaning up back to original state on error Traceback (most recent call last): File "/usr/bin/git-bz", line 2840, in do_attach(*args) File "/usr/bin/git-bz", line 2168, in do_attach

Re: [Koha-devel] Keycloak as Identity Provider using Koha's users

Sounds good. Thanks, Paul! 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 From: Paul Derscheid Sent: Friday, October 20, 2023 8:07 PM To: David Cook ; 'Koha Devel' Cc: 'R

Re: [Koha-devel] Background jobs quirks

tomp/source/lib/Net/Stomp.pm and it ignores SIGPIPE when it’s sending frames… so it’s probably not the $conn->ack() doing it. I do wonder if it’s “my $job = Koha::BackgroundJobs->find($args->{job_id});” I suppose we’ll see in the morning… David Cook Senior Software Engineer Prosent

Re: [Koha-devel] Background jobs quirks

er if it's "my $job = Koha::BackgroundJobs->find($args->{job_id});" I suppose we'll see in the morning. 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

Re: [Koha-devel] Background jobs quirks

gs->{job_id});" I suppose we'll see in the morning. 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 From: Koha-devel mailto:koha-devel-boun...@lists.koha-c

Re: [Koha-devel] Background jobs quirks

he $conn->ack() doing it. I do wonder if it's "my $job = Koha::BackgroundJobs->find($args->{job_id});" I suppose we'll see in the morning. David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia

[Koha-devel] Background jobs quirks

Hi all, Have you seen something like the following in your worker-error.log? 20231018 07:44:06 instance-koha-worker-long_tasks: client (pid 3949888) killed by signal 13, respawning 20231019 07:21:26 instance-koha-worker-long_tasks: client (pid 4082852) killed by signal 13, respawning I

[Koha-devel] MIssing emails for CC list?

Hi all, I'm used to getting emails for issues I'm CCed to, but I don't think I've gotten any for the last 1 week. Is this happening to anyone else or is it just me? I'm still getting emails addressed to koha-b...@lists.koha-community.org but

[Koha-devel] Keycloak as Identity Provider using Koha's users

Hi all, I've posted the Keycloak extension for using Koha's user database as Keycloak's user datastore: https://gitlab.com/minusdavid/keycloak-user-storage-koha This effectively allows you to use Koha (version 22.11.03 and upwards) as an Identity Provider - mediated via Keycloak (version 20