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++