Time Nick Message
06:33 magnuse \o/
06:40 reiveune hello
06:50 Joubu On the roadmap there is "There are still major issues with the task queue". Which ones?
08:24 * cait1 waves
08:40 magnuse \o/
08:45 cait1 oh no... a 1
08:45 * cait is trying hard not to duplicate
08:49 aw-bib[m] hi! don't get me wrong, the webinstaller/onboarding tool are great. but is there a simple way to script them? (iow avoid to click through it.) I'll have to do this several times and I admit I'd prefer the "clicks" to be in my git somehow.
08:53 Joubu skip it?
08:54 Joubu for testing or production purpose?
08:54 aw-bib[m] but i'd neet to populate the db etc. or do you recommend to set up some "golden system" without records and install a dump?
08:55 aw-bib[m] in the end I'll need at least one dev box but a few prod boxes with vey similar setup.
08:56 Joubu misc4dev - this repo is used by our dev environments to populate the DB
08:56 Joubu especifically this script: https://gitlab.com/koha-community/koha-misc4dev/-/blob/master/do_all_you_can_do.pl
08:56 Joubu you will find populate_db.pl that is inserting the sample data
08:57 Joubu create_superlibrarian.pl to create a first superlibrarian user
08:58 aw-bib[m] ah! thanks that sounds promising :) I'll have a look at this.
08:58 Joubu insert_data.pl is dealing with MARC records, specific require data (some installed during the onboarding, some not: circ rule, acq data, etc)
09:34 magnuse aw-bib[m]: you could also setup one "template" instance with the settings you want to be in each instance, and then copy the database to the other instances instead of running through the web installer
11:23 marcelr hi #koha
11:24 marcelr so much noise here
11:24 cait yeah, can hardly stand it
11:44 oleonard Do we still have problems loading external XSL over https? It sure seems like it
11:44 oleonard Unless this is a problem peculiar to KTD
11:46 oleonard [WARN] XSLT::Base: I/O warning : failed to load external entity "MARC21slimUtils.xsl"
11:46 oleonard ...but I've confirmed that the file is there
11:46 tcohen hola #koha o/
11:54 cait1 oleonard: did you change the include paths in your XSL?
11:54 oleonard Yes
11:54 cait1 I think they need to be absolute from what was discussed on the bug
11:55 cait1 also URLs
11:55 oleonard Even if they're in the same directory?
11:55 cait1 wher is your main XSLT?
11:55 cait1 and I think yes, because Koha does the processing... but I might be wrong
12:01 oleonard I'm testing in KTD, and the XSLT files (which are copies of master) are on an external server
12:03 oleonard I've tried an absolute URL with https:// and with just // and neither work
12:13 tcohen power outage in the area, please email me if you need something from the RM
12:51 marcelr hi oleonard there is a difference between using an external xslt and an external import or include
12:52 marcelr we only solved the file issue not the import
12:52 marcelr the latter being a bit more complicated..
12:55 oleonard Both MARC21slim2OPACResults.xsl and MARC21slimUtils.xsl have includes, so that doesn't get me very far :(
12:58 magnuse i'm confused: https://wiki.koha-community.org/wiki/Shibboleth_Configuration talks about "AD FS", but is that the same as "Azure AD"?
13:01 magnuse ah, this sounds slightly promising: https://lists.katipo.co.nz/public/koha/2020-December/055619.html "I was (eventually) successful setting up Koha to use SAML2 SSO to AD FS, which is similar to Azure AD"
13:06 Joubu oleonard: did you try to modify the import?
13:07 Joubu Replace <xsl:import href="MARC21slimUtils.xsl"/> with the https full path in the href attr
13:07 oleonard Yes, that didn't work for me
13:08 marcelr it is a bug in the underlying xslt modules
13:08 marcelr libraries
13:08 wahanui libraries is needed too
13:10 oleonard marcelr: ...which they seem very opposed to fixing apparently
13:11 Joubu did you find a bug report?
13:12 oleonard I found this via Bug 12758 https://gitlab.gnome.org/GNOME/libxml2/-/issues/160
13:12 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12758 normal, P5 - low, ---, m.de.rooy, CLOSED FIXED, Failure when loading or parsing XSLT stylesheets over HTTPS
13:16 Joubu lol ok, fair enough. Not sure to understand what's the workaround then...
13:16 marcelr it is just a partial fix
13:17 marcelr the real fix should be in the libxslt stuff
13:17 Joubu yes, I am talking about the libxml2 issue
13:20 Joubu I guess the solution is to build a unique xsl that does not rely on other files
13:21 cait1 I don't think that's a great idea
13:21 cait1 unless you keep it really simple
13:22 cait1 ... and MARC is never simple
13:22 tcohen can't you just embed MARC21slimUtils?
13:22 tcohen it hardly ever changes
13:23 oleonard Yes it seems to work to embed MARC21slimUtils and MARC21Languages
13:35 cait1 it's huge
13:35 cait1 gues sit just makes the file pretty big
13:39 Joubu it must be automated
13:39 Joubu not manual
13:40 tcohen a script that embeds them
13:49 Joubu tcohen: "
13:49 Joubu Your Opensource subscription will expire on 2023-07-20
13:49 Joubu "
13:49 Joubu gitlab is displaying a big red warning, did you see it?
13:50 marcelr no open source for tcohen any more
13:51 tcohen is that on the Community site?
13:51 tcohen or Theke's?
13:52 tcohen I mean namespace
13:52 Joubu https://gitlab.com/koha-community/
13:52 tcohen ok, will check
13:52 Joubu I am seeing it when I am under koha-community
13:52 tcohen I got an auto-renewal email a couple weeks ago
13:53 tcohen it said we didn't need to do anything unless we wanted to cancel
13:53 tcohen but worth checking with them
13:59 thd tcohen: I never found the alias email address for Koha team last week and then I was sick for a few days from eating the wrong bacteria.
14:01 thd tcohen: If you have that alias I will use it otherwise I will use the few address I have collected.
14:08 tcohen koha-release-team@theke.io
14:09 thd tcohen: Sorry, I did not wait long enough. Do you see a message from td-koha AT agogme.com ?
14:11 thd Is there also a development meeting now?
14:20 KakhaberRevazishvili[m] hi there!
14:20 thd One week from the previous meeting may be catching people by surprise.
14:21 KakhaberRevazishvili[m] i have problem with KOha search. In Opac search with unicode give unnormal results - getting more results. In English search all ok
14:23 tcohen thd: I don't think we have a meeitng
14:23 thd https://wiki.koha-community.org/wiki/Development_IRC_meeting_5_July_2023
14:25 thd Perhaps a mistake. Why was the general meeting set for tomorrow a Thursday?
14:26 caroline thd davidnind and I just chose a date since we skipped a lot of general meetings
14:26 caroline the previous one was skipped, so there was no "next meeting"
14:28 thd KakhaberRevazishvili[m]: What Koha version are you testing?
14:30 cait1 KakhaberRevazishvili[m]: if you are using Zebra, you need to configure it with ICU for non-latin scripts
14:30 cait1 https://wiki.koha-community.org/wiki/ICU_chains_configuration
14:31 Joubu why isn't it the default?
14:36 cait there are some catches with it
14:36 cait I am not sure what has been resolved in newer Zebra versions and what not, but some differences in what would work
14:37 thd Joubu: As you know Unicode should always be the default but problematic behaviour from memory or other issues with the C library for Zebra has made it less desirable than Latin if not needed.
14:37 cait I think exact search only worked without ICU and there was some issue with Fuzzy/Stemming/Weighted search
14:37 cait also indexes get bigger I ws told
14:37 cait I feel it's much less problematic than it sued to be, but haven't tested
14:38 Joubu ok..
14:38 Joubu ktd not starting up with D12 and ES, is that a known issue?
14:38 Joubu Exception 'Koha::Exception' thrown 'Unable to update mappings for index "koha_kohadev_biblios". Reason was: "". Index needs to be recreated and reindexed'
14:38 tcohen we should remove zebra
14:38 Joubu ES7
14:38 cait it looks like exact search is not working with ICU in 20.11 at least
14:38 cait don't have a newer one to test with right now
14:39 Joubu and... bookworm:
14:39 Joubu root@kohadevbox:koha$ koha-shell kohadev
14:39 Joubu This account is currently not available.
14:39 Joubu wt..?
14:39 cait tcohen: just a note... you can't do exact search with Elastic right now...
14:39 cait exact field search that is
14:40 cait a prime example is searchign for "nature"
14:40 cait Elastic is not always better ;)
14:43 thd kados ensured that the default configuration for Zebra would allow searching for "It" in a useful way while "it" is usually an English stop word.
14:43 thd There is "It" by Stephen King.
14:46 thd tcohen: Do you see a message from td-koha AT agogme.com ?
14:46 tcohen no
14:46 tcohen koha-release-team@theke.io
14:46 thd tcohen: Check your junk messages at gmail.
14:47 tcohen oh yeah
14:47 tcohen there it ois
14:47 Joubu bug 34174 is bad
14:47 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34174 major, P5 - low, ---, oleonard, Needs Signoff , Saving RIS results to Error 505
14:47 tcohen looking, Joubu
14:47 Joubu tcohen: "This account is currently not available." did you already see that?
14:47 tcohen where?
14:48 Joubu `koha-shell kohadev` in bookworm
14:48 tcohen is master => bookworm?
14:49 tcohen Running KOHA_IMAGE=master-bookworm ktd up -d
14:49 tcohen to try
14:49 Joubu yes
14:49 Joubu no
14:49 Joubu master is bullseye
14:49 Joubu bookworm is D12
14:50 tcohen I'll roll-back
14:50 tcohen I cannot test right now
14:50 tcohen it takes too long to download on 3G
14:50 tcohen happy if anyone can take a look
14:50 Joubu I don't understand why bug 33341 has been backported into all stables
14:50 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33341 normal, P5 - low, ---, tomascohen, Pushed to oldoldstable , Perl 5.36 doesn't consider some of our code cool
14:51 Joubu it was more an enh than bug
14:51 tcohen only affecting distros with Perl 5.36
14:51 Joubu no
14:52 Joubu it breaks Ris export for everybody
14:52 tcohen ah, was about to submit a bug
14:52 tcohen :_D
14:53 Joubu tcohen: On the roadmap there is "There are still major issues with the task queue". Which ones?
14:53 wahanui i already had it that way, Joubu.
14:54 tcohen that has been copied from the old one?
14:54 tcohen I'm not sure what's the answer
14:54 tcohen I think that's no longuer the case
14:54 tcohen just the race/deadlocks with batch import
14:55 Joubu I don't know, you added it..
14:55 Joubu 26 kohadev-koha:x:1000:1000:Koha instance kohadev-koha,,,:/var/lib/koha/kohadev:/usr/sbin/nologin
14:55 Joubu why nologin?!
14:56 cait there are certainly still open bugs
14:56 cait maybe reviewing those would help?
14:56 cait I can make a list if that helps any (have been looking at bugs a lot lately)
14:56 Joubu there are bugs, I am not aware of "major" ones
14:57 Joubu bug 32395 and bug 32708 are on my list
14:57 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32395 enhancement, P5 - low, ---, koha-bugs, In Discussion , Why do we send jobs params to the broker
14:57 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32708 enhancement, P5 - low, ---, koha-bugs, NEW , REST API route to list background jobs should not decode data
14:57 Joubu but pretty sure nobody is interested in them, so... :D
14:57 cait bug 32481 ?
14:57 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32481 critical, P5 - low, ---, dcook, Pushed to oldoldstable , Rabbit times out when too many jobs are queued and the response takes too long
14:58 cait oops Pushed already ;D
14:58 cait bug 30645
14:58 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30645 normal, P5 - low, ---, koha-bugs, NEW , Patron search not building the query correctly for extended attributes if several terms passed
14:58 cait bug 32305
14:58 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32305 major, P5 - low, ---, koha-bugs, Failed QA , Background worker doesn't check jobs receive from rabbitmq are in 'new' state
14:59 cait bug 30654 (ignore 30645)
14:59 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30654 major, P5 - low, ---, martin.renvoize, In Discussion , Even with RabbitMQ enabled, we should poll the database for jobs at worker startup
14:59 cait bug 34070
14:59 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34070 major, P5 - low, ---, koha-bugs, NEW , background_jobs_worker.pl floods logs when not connecting
14:59 cait so 3 open major
15:01 Joubu only the last one is really bad and there is no step to recrate
15:01 Joubu tcohen: nologin - koha-create has:
15:01 Joubu 775 adduser --no-create-home --disabled-login \
15:01 Joubu so nologin is expected
15:02 Joubu are we doing something later (ktd?) to change that?
15:02 tcohen changing the uid?
15:03 Joubu it's 1000
15:04 Joubu ok nevermind, I am switching back to bullseye and wait for somebody else to fix it :D
15:04 tcohen rogue Joubu
15:08 Joubu in bullseye: 28 kohadev-koha:x:1000:1000:Koha instance kohadev-koha,,,:/var/lib/koha/kohadev:/bin/bash
15:10 Joubu If I create a new library, I still have /bin/bash
15:10 Joubu so it's not ktd
15:11 tcohen a bug in adduser making --disabled-login useless?
15:11 Joubu --disabled-login
15:11 Joubu Do not run passwd to set the password. The user won't be able to use her account until the password is set.
15:11 tcohen ah
15:12 tcohen so it's a default shell thing?
15:12 Joubu 86 echo "${KOHA_INSTANCE}:koha_${KOHA_INSTANCE}:${KOHA_DB_PASSWORD}:koha_${KOHA_INSTANCE}" > /etc/koha/passwd
15:12 Joubu is that it?
15:12 reiveune bye
15:15 Joubu adduser --no-create-home --disabled-login --gecos foo --home "/var/lib/koha/foo" --quiet "foo"
15:15 Joubu foo:x:1002:1002:foo,,,:/var/lib/koha/foo:/bin/bash
15:15 Joubu this is still bullseye
15:15 Joubu looks like they fixed --disabled-login in bookworm :D
15:18 Joubu bug 34204
15:18 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34204 enhancement, P5 - low, ---, koha-bugs, NEW , Koha user needs to be able to login
15:19 caroline does anyone know what aqbooksellers.gstreg is for? It is a yes/no choice in the vendor information, but it doesn't look like it does anything?
15:20 MatthewBlenkinsop[m] The comment against the database field is: is your library charged tax (1 for yes, 0 for no)
15:21 caroline but it doesn't affect tax calculation
15:21 caroline The label in the interface is "Tax number registered"
15:22 caroline bug 12839 (from 2014!) says it is not used
15:22 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12839 normal, P5 - low, ---, jonathan.druart+koha, CLOSED FIXED, aqbooksellers.gstreg is never used
15:26 thd tcohen: I resent the DMARC message using the alias. Using the alias might land in fewer junk boxes.
15:36 Joubu caroline: the DB column should have been removed by 12939
15:37 caroline i'll open a new bug
15:38 Joubu thx!
15:41 cait caroline: i think there is a bug now to make it used
15:42 cait I was worng, they went for a new pref: Bug 31631 - Optionally choose for tax-exclusive values to be used for calculating fund values (spent, ordered)
15:42 cait but I believe that was the original use
15:54 Joubu tcohen, ashimema: could one of you approve the tidiness check for the QA script? https://gitlab.com/koha-community/qa-test-tools/-/merge_requests/53
15:55 caroline interesting, we have the same here too (for one of the taxes; we have two). When I used to do acquisitions, I ignored the taxes on books since it was to be refunded anyway
15:56 oleonard We don't have a script for populating a db with ERM test data do we?
15:57 Joubu There is something on bug 33435
15:57 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33435 enhancement, P5 - low, ---, pedro.amorim, RESOLVED INVALID, We're missing sample dev data for ERM
15:58 PedroAmorim[m] oleonard I also have some WIP at https://github.com/ammopt/koha-ill-dev
15:59 PedroAmorim[m] it can be used to generate fake ILL data, but I'll work on ERM fake data at some point
15:59 PedroAmorim[m] (I hope)
16:00 oleonard Thanks PedroAmorim[m]
16:27 caroline my
16:27 caroline oops, wrong window, sorry! :)
16:49 paulderscheid[m] Hi #koha, signing off for the day, but I worked on a little thing on the side. It's wip but you can try it out already.
16:49 paulderscheid[m] If you have a better idea on extracting usable paths, dm me or write an issue on github.
16:49 paulderscheid[m] https://github.com/pders01/koha-plugin-command-palette
17:08 caroline It seems I still haven't learned how to get a kpz from github... Do I have to clone the thing a zip it myself?
17:08 paulderscheid[m] There's a kpz under the releases
17:09 caroline a-ha! thanks!
17:10 paulderscheid[m] You need to restart plack and then press Ctrl + Shift + P anywhere in the staff interface.
19:04 * tcohen feels old. what is mastodon?
19:06 oleonard-away It's basically an open version of Twitter, but made up of lots of interconnected systems instead of one big one
19:42 tcohen do we have the GPL mentioned somewhere on the community site?
19:47 tcohen I need that for renewing the Gitlab for FOSS licence we have
19:51 caroline it needs to be on the website?
19:51 caroline it's on the wiki and in the code
19:54 tcohen https://snipboard.io/7sF1V3.jpg
19:55 tcohen it'd be the first required upload
19:56 caroline Isn't this the project detail page? https://gitlab.com/koha-community/Koha
19:58 tcohen ah, that's right
19:58 caroline phew!
19:59 caroline We should probably add it to the website too, though, but it's not as urgent
20:46 tcohen already sent the renewal request to Gitlab
20:46 caroline tcohen++