Time Nick Message
02:13 C4R7 Hello
07:28 magnuse ashimema: "ancient perls" - are those the perls shipped with debian and ubuntu?
07:34 ashimema Yup, we lock ourselves to the lowest common denominator.. i.e lts debian
07:35 ashimema 5.14 perl
07:36 magnuse that is pretty low...
07:36 ashimema 5.24 would give us a fair bit from memory.. and the thinks that people are getting excited about in the perl world are brand new.. objects, signatures, etc
07:36 magnuse there are versions of debian/ubuntu we say we support that has perl as old as that?
07:37 ashimema 5.38 is current perl
07:37 ashimema Yup
07:37 magnuse how hard would it be to install a newer perl?
07:39 ashimema Looks like 5.28 is in buster.. the older non-lts debian
07:39 ashimema Whilst we stick to system perl, fairly hard
07:40 ashimema If we opted to try and go local lib it would mean some infrastructure change but then not so hard
07:40 ashimema I don't know the answer to be honest
07:40 ashimema Right, swim time for me.. be back in an hour
08:45 fridolin salutations
08:48 fridolin t/db_dependent/api/v1/erm_counter_registries.t failing on master 23.11
08:48 fridolin and t/db_dependent/api/v1/erm_sushi_services.t
08:49 fridolin maybe a change in the WS itself
08:49 fridolin any idea ?
09:00 Joubu PedroAmorim[m]: ?
09:01 Joubu t/db_dependent/api/v1/erm_sushi_services.t is failing because it compares an expected output with https://registry.projectcounter.org/api/v1/sushi-service/b94bc981-fa16-4bf6-ba5f-6c113f7ffa0b/
09:01 Joubu and there is "migrations" there
09:01 Joubu which may have been added recently
09:01 Joubu this test is really bad (ie. depending on an external resource)
09:02 Joubu unless it's what we want, but it's not clear what the test is actually testing
09:06 * cait waves
09:07 cait can anyone help with a password reset on the wiki? It looks like emails are not being sent out
09:07 Joubu fridolin: added a comment on bug 35218
09:07 huginn` 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35218 blocker, P5 - low, ---, martin.renvoize, RESOLVED FIXED, No tests for /erm/sushi_service
09:08 fridolin Joubu: tanks a lot
09:18 PedroAmorim[m] I was not aware of this
09:18 PedroAmorim[m] can take a look
10:24 dolf Hi there. I'm trying to upgrade an old Koha (21.05) step by step, starting with 21.05 -> 21.11. It's on debian, using apt. I updates the codename to 21.11 in /etc/apt/sources.list.d/koha/list and ran `apt update` followed by `apt upgrade`. The database schema upgrades started at 21.06.00.000 and went swimmingly until 21.06.00.041, when I got this error: ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too large. The maximum row size for the
10:24 dolf used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs at /usr/share/koha/lib/C4/Installer.pm line 743 . I'm not sure what to do with this...
10:24 cait you don't need to do a step by step update
10:25 cait but the error you ahve needs to be resolved, give me a moment
10:25 cait Bug 28267 - Older databases fail to upgrade due to having a row format other than "DYNAMIC"
10:25 dolf I realize that, but I tried to upgrade directly to the latest version before, and got the same error, so I reverted the state of the VM and tried again with a smaller increment. Also, our staff members like to test things thoroughly in between upgrades. Anyway, thanks for your time and attention!
10:26 cait yes, but testing every versin in between might be a bit of wasted energy
10:26 dolf Ah, it's the row format again. I think I ran into this on another instance a while ago!
10:26 cait have a look at the bug I posted, the link is https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267
10:26 huginn` 04Bug 28267: critical, P1 - high, ---, jonathan.druart+koha, RESOLVED FIXED, Older databases fail to upgrade due to having a row format other than "DYNAMIC"
10:28 cait comments 20/21 especially
10:30 dolf Thanks. I also found https://irc.koha-community.org/out.pl?channel=koha;date=2023-08-16 where I discussed the same problem. I'll just pick up from there! Thanks again.
10:48 paulderscheid[m] morning #koha
10:50 paulderscheid[m] I think we should make some efforts to get to 5.036 at least as one of perl's flagships (even if not this cycle). And I want these type checks as soon as they're in core :D
10:53 dolf Has the wiki account creation / email sending been sorted out yet? Back in August, davidnind tried to help me get my wiki account activated, but none of the e-mails are reaching me, so I can't (re)set my password. I would like to improve this page: https://wiki.koha-community.org/wiki/Database_row_format
10:54 cait dolf: we just found it not workign today/yesterday for another user
10:55 cait maybe you could comment here too: Bug 34637 - Wiki - email notifications aren't being sent (account registrations, password resets, etc.) - I left a comment earlier, but strangely I am receiving page update notifications to my email
11:01 Joubu paulderscheid[m]: we can already improve some of our old code. Waiting for a future version of Perl is just an excuse to procrastinate :D
11:02 paulderscheid[m] You are right
11:02 paulderscheid[m] ˆˆ
11:03 Joubu there are several places where prototype of subs is bad and can be improved/cleaned already
11:11 oleonard Hi #koha
11:50 cait hi oleonard
12:18 dolf cait: I commented on both issues. On Bug 28267 (the one about the DYNAMIC rows) I posted a link to the script that I used to convert everything to DYNAMIC row format. After that, the database upgrades worked, and this Koha instance is now on 21.11 at last. However, now I'm seeing another issue that I also had in August, and never got resolved (I ended up rolling back the VM). The discussion started here https://irc.koha-community.org/koha/2023-08-17#i_2503120
12:18 dolf . In summary, the search results and normal view on the biblio page are both omitting lots of data, even though the MARC data is all there and in good condition.
12:18 huginn` 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267 critical, P1 - high, ---, jonathan.druart+koha, RESOLVED FIXED, Older databases fail to upgrade due to having a row format other than "DYNAMIC"
12:21 dolf Unfortunately I did not check in between the row format conversion and the "apt upgrade" step, so I don't know which one is the problem.
12:25 dolf It's looking fine on the intranet, but on the OPAC in "Normal view" on the opac-detail.pl page, no record details are shown
12:27 dolf On the OPAC search page, only the covers are shown: https://library.refstudycentre.com/cgi-bin/koha/opac-search.pl?advsearch=1&idx=kw&q=commentary&weight_search=1&do=Search&sort_by=relevance
12:37 dolf brb
12:39 cait @later tell dolf sorry, I was afk. That sounds like you should check your frameworks - especially the visilbility settings. It didn't work in the past and then we fixed it. So field need to be set to be visible in the OPAC
12:39 huginn` cait: The operation succeeded.
12:40 cait and you will always want to have "default" in the XSLT prefs (non-XSLT views have been removed in newer versions anyway)
12:48 cait @later tell dolf: also check the logs for errors, XSLT errors can make themselves visible like this. In the frameworks you want to check for biblionumber 999 to be set to visible in the OPAC for a start.
12:48 huginn` cait: The operation succeeded.
13:58 dolf cait: Thanks, I'll look into that. Although I don't recall ever changing the frameworks or XLST stuff since installing Koha for the first time back in 2011.
13:59 dolf By the way, I reverted my VM to after converting the rows to DYNAMIC, and before upgrading to 21.11 (so it's still on 21.05) and now everything is working. So it's not the row format that is causing trouble. It must be one of the updates not playing nicely with my settings?
14:03 cait dolf: there can be different reasons
14:03 cait is it only in the opac or the staff interface as well?
14:04 cait meaning: does the result list and detail page in staff interface display normally?
14:05 dolf Staff displays normally, yes. The problem is only on the OPAC (both in search results and on the detail page)
14:06 cait ok, did you check the logs yet?
14:06 cait or first: go to your frameworks
14:07 cait check that all your frameworks have 999$c set to visible in the OPAC
14:07 dolf Will do!, as soon as I get the problem replicated on another VM. I need to keep it in a stable position for the following week until my next maintenance window. So I'm keeping it on 21.05 for now so that the staff can do their work.
14:08 cait ah ok, a separate system for testing might be useful :)
14:09 cait tail -f /var/log/koha/instance/*.log when you go to result list and look for anything error'y
14:23 dolf cait: Under /cgi-bin/koha/admin/marc_subfields_structure.pl?op=add_form&tagfield=999&frameworkcode=#subcfield the OPAC check box is ticked next to "Visibility" under "Advanced constraints". Is this the right place? I noticed that it's not possible to modify that check box.
14:23 cait that's odd
14:23 dolf (Still on 21.05, just poking around)
14:23 cait but yes, visibility
14:23 cait is it checked?
14:24 dolf Yes, Checked are OPAC, Intranet and Collapsed. Unchecked are Editor and Flagged.
14:28 dolf On the "Tag 999 Subfield structure" page, it says "subfield ignored" in the "Constraints" column of subfield "c". What does that mean?
14:52 cait i think that's ok
14:53 cait I think checking for an error would be the next step when you try to update again, in the logs, when you do a search
14:56 dolf Will do. In the mean time. I see that "OPACXSLTDetailsDisplay" and "OPACXSLTListsDisplay" and "OPACXSLTResultsDisplay" are empty instead of "default". Maybe that is the problem?
14:56 dolf What did you mean when you said "non-XSLT views have been removed in newer versions anyway" ?
14:58 oleonard-away dolf: There used to be two ways to show those pages, XSLT or non-XSLT.
15:05 dolf Without upgrading (i.e. still on 21.05) I changed all OPACXSLT*Display settings from empty to "default", and now I see the same problem as when I upgraded: Only the book cover picture is shown. The rest is missing, both on the book detail page and on the search results page.
15:06 dolf Changing back to empty fixed the problem. I don't understand this setting. Maybe the default xslt is missing or corrupted? Is it part of the deb package installed via APT?
15:07 oleonard dolf: I'm sorry if you've answered this already, but have you customized the default XSLT somehow?
15:07 dolf I have not. I would not know how. How can I check if it's still at "factory settings"?
15:08 cait the package update would also overwrite any local changes I think
15:08 cait we really need the error from the logs
15:08 cait if you see the problem now too, maybe check the logs now?
15:08 cait I thin it's something in the configuration
15:09 dolf Good thinking, I should have thought of that. Doing that ASAP
15:12 dolf There are some errors, but nothing new appears in the log when visiting opac-detail.pl , even though I see the issue (no details being displayed other than the book cover and the holdings table)
15:13 cait hm an XSLT bug should be logged soemwhere
15:13 cait are you checking all logs or only a specific one?
15:14 dolf I'm using tail -f /var/log/koha/instance/*.log as you suggested
15:14 dolf with instance being "rsc"
15:15 cait ok
15:15 cait hm
15:15 dolf I can paste some of the errors I see, but their timing don't coincide with my page reload
15:15 cait and when you go to results, there is nothing new?
15:15 dolf I don't understand what you mean
15:15 cait tail -f let's you watch the logs when you do the thing
15:15 cait so you can add empty lines and then reproduce the error, see if something turns up
15:16 dolf Yes, that's what I did. Nothing new pops up when I reload opac-detail.pl
15:16 cait and same for opac-results?
15:16 dolf Yes, same.
15:16 cait i mean the result list
15:16 dolf Got it
15:17 cait yep hm
15:17 cait there was a short ime when we didn't log XSLT errors right, but that would be a very unlucky coincidence
15:17 dolf I see some other errors popping up, but they seem unrelated. This is a production site, and people are searching, browsing, etc.
15:17 cait but you set XSLT to default now?
15:17 cait can you share a link?
15:18 cait I just want to check something real quick
15:18 dolf Yes, three OPACXSLT*Display settings all set to "default", which makes my stuff hidden.
15:18 cait in the browser
15:18 dolf https://library.refstudycentre.com/cgi-bin/koha/opac-search.pl?idx=&q=pastoral+epistles&weight_search=1
15:18 dolf https://library.refstudycentre.com/cgi-bin/koha/opac-detail.pl?biblionumber=38779
15:19 cait the bit where the output of the XSLt woudl be is completely missing from the page source
15:20 dolf Strange... Where do these default XSLT files live? Can I check them manually?
15:20 cait trying to remember the path for a package installation
15:20 cait they live in .... opac/bootstrap/xslt i think
15:21 cait the opac template directory
15:22 dolf I have /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/xslt . Is that right?
15:22 dolf Other one is /usr/share/koha/lib/Koha/XSLT
15:22 cait yes, that looks right
15:22 cait no the bootstrap one
15:22 cait the ohter is the perl module, that shoudl be alright
15:23 dolf I see 12 .xsl files here
15:24 dolf compact.xsl MARC21slim2OPACDetail.xsl MARC21slimUtils.xsl NORMARCslim2OPACResults.xsl plainMARC.xsl UNIMARCslim2OPACResults.xsl MARC21Languages.xsl MARC21slim2OPACResults.xsl NORMARCslim2OPACDetail.xsl NORMARCslimUtils.xsl UNIMARCslim2OPACDetail.xsl UNIMARCslimUtils.xsl
15:25 oleonard dolf: MARC21slim2OPACDetail.xsl & MARC21slim2OPACResults.xsl are for the OPAC details page and the OPAC search results page
15:26 oleonard dolf: What's your full Koha version number?
15:26 dolf `apt show koha-common` gives me `21.11.26-1`
15:27 dolf oh wait, I thought I was still on 21.05.
15:28 dolf Ah, `apt show` does not give the installed version, but the latest available one in the apt repos
15:28 oleonard dolf: The Koha "About" page will show you
15:28 dolf It
15:29 dolf It's 21.05.00.000
15:29 oleonard https://gitlab.com/koha-community/Koha/-/tree/21.05.x/koha-tmpl/opac-tmpl/bootstrap/en/xslt?ref_type=heads
15:36 dolf I downloaded from git and did a diff. The MARC21slim2OPACResults.xsl files are identical. The MARC21slim2OPACDetail.xsl files have a diff: https://pastebin.com/qh6Atnbx
15:37 dolf It looks like mine is just slightly older. Should I update to the latest 21.05.* ?
15:39 oleonard dolf: It couldn't hurt to try
15:41 cait I still think itmight be something int he data cuasing an error
15:41 cait but we need the error to be able to tell more
15:41 cait maybe if you try to update again, repeat checking the logs
15:51 dolf Something in the data: You mean in my MARC records? We have tens of thousands, and I did a spot check – all have the same problem.
15:51 dolf I updated to 21.05.21.000 now. Checking again ...
15:54 dolf Still no new lines in any log files when loading opac-detail or opac-search. When I change the OPACXSLT*Display settings back to empty, I can see the book details again.
15:55 cait can you still paste what you have in the logs?
15:55 dolf Yes, I'll do that. But I have to go soon. Thanks for all the help!!!
15:56 cait have to go soon too, but maybe someone will also read later
15:57 dolf opac-error.log https://pastebin.com/LD3JHkmg
15:57 dolf Any other files? There are many, but I assumed opac-error.log is the only relevant one.
15:57 dolf Bye now :)
15:57 cait i was thinking of anything that appears when you load the opac-rsult or opac-detail page
15:58 cait but ther eis nothing obvious there
15:58 dolf Nothing appeared when doing tail -f *.log during a reload.
15:58 cait hm
15:59 cait sorry, I am out of ideas :(
15:59 cait have a nice evening/rest of day #koha
16:36 paulderscheid[m] Is metacpan.org broken for anyone else (Search specifically)?
16:55 ashimema All works for me
17:04 paulderscheid[m] thanks ashimema
17:04 paulderscheid[m] now it works for me too
17:05 paulderscheid[m] Have you played w/ Mojo::JWT already ashimema?
17:07 ashimema Yeah, a few times over the years
17:11 paulderscheid[m] Would you recommend it for JWTs for Koha via OpenAPI or rather one of the other packages?
17:11 paulderscheid[m] I think there's also JSON::WebToken
17:11 paulderscheid[m] And many more
17:51 tuxayo paulderscheid: https://github.com/orgs/Perl-Apollo/discussions/49 => is that about optional typing?
17:51 tuxayo hi all :)
17:59 alexted[m] hello, I have jsut installed Koha on Debian (following the official Wiki: https://wiki.koha-community.org/wiki/Koha_on_Debian). My question is: which is the default password assigned to the system user "library-koha" created by the "koha-create"? Thanks!
18:11 tuxayo alexted: hi :)
18:11 tuxayo https://wiki.koha-community.org/wiki/Koha_on_Debian#Access_the_web_interface
18:11 tuxayo > When you see the login for the Koha installer, the username and password are in the koha-conf.xml file for the instance.
18:12 tuxayo > You can view the password with:
18:12 tuxayo > sudo koha-passwd libraryname
18:12 tuxayo I think it's that
18:17 alexted[m] tuxayo: hi! thanks for you reply :)
18:19 alexted[m] the password you are referring to is that of the MySQL user (koha_library), I was referring to that of the Debian system user (koha-library)
18:40 lukeg hi
18:41 cait alexted[m]: what are you trying to do?
18:41 cait you can use sudo koha-shell instance to switch to this user
19:06 alexted[m] cait: hi cait, thanks for your answer
19:07 alexted[m] i'm tring to rebuild Zebra with "sudo koha-rebuild-zebra -f -v instancename" and i don't know how to find the password for the koha system user
19:57 cait you don't need it
19:58 cait that's your normal root user, not the koha one
19:58 cait all the sudo koha-... commands are just run with your own password
19:59 cait and if you need to run other scripts you switch to the koha user using the command I gave earlier
20:20 paulderscheid[m] Hi tuxayo => yes
20:20 paulderscheid[m] Also: global big squashing days came up during the last dev meeting, just fyi if you want to organise
20:30 alexted[m] caitok, so so the "koha-rebuild"-zebracommand must be run as root user? thanks!
20:32 cait it will take care of using the right user internally I believe
20:32 cait you have the instance as parameter
20:41 alexted[m] ok, but the Koha Installation Guide on Debian https://wiki.koha-community.org/wiki/Koha_on_Debian says that "A system user is created, called library-koha. All things to do with this instance will be run as this user."
20:41 alexted[m] This is why I was wondering if the "koha-rebuild-zebra" command should be run as the library-koha user