Time Nick Message 00:03 tuxayo Wainui: hi :) 00:03 tuxayo did the release went well? 00:04 tuxayo mtj around ? 00:04 tuxayo It's expected that these build have failing tests right? 00:04 tuxayo Koha_20.11_D10-Core and Koha_20.11_D10-Full 00:04 Wainui Hi @tuxayo 00:05 Wainui running into problems with release 00:05 Wainui but doing it now 00:11 tuxayo Wainui: good luck, don't hesitate to ask if you have questions. 00:11 tuxayo My first release spanned over 3 days I think >< , struggling on almost everything. I hope the completions I did in wiki will help. 00:14 tuxayo Meanwhile I almost finished releasing 20.11.x on behalf of Fridolin. Who if currently moving to Papeete (French Polynesia) :D 00:14 tuxayo So they will be closer to Aotearoa 00:15 tuxayo (I phrased it like it was the goal of the move but no ^^) 00:31 koha-jenkins Project Koha_19.11_U18 build #325: SUCCESS in 31 min: https://jenkins.koha-community.org/job/Koha_19.11_U18/325/ 00:32 koha-jenkins Project Koha_20.11_U20 build #104: SUCCESS in 34 min: https://jenkins.koha-community.org/job/Koha_20.11_U20/104/ 00:32 koha-jenkins Project Koha_19.11_D8 build #398: SUCCESS in 32 min: https://jenkins.koha-community.org/job/Koha_19.11_D8/398/ 00:45 koha-jenkins Project Koha_19.11_D9 build #340: SUCCESS in 44 min: https://jenkins.koha-community.org/job/Koha_19.11_D9/340/ 00:57 koha-jenkins Project Koha_20.11_D10 build #118: UNSTABLE in 59 min: https://jenkins.koha-community.org/job/Koha_20.11_D10/118/ 01:01 koha-jenkins Project Koha_19.11_U20 build #224: SUCCESS in 29 min: https://jenkins.koha-community.org/job/Koha_19.11_U20/224/ 01:03 mtj hi tuxayo, yep, they are currrently experimental builds 01:05 koha-jenkins Project Koha_20.11_U16 build #95: SUCCESS in 33 min: https://jenkins.koha-community.org/job/Koha_20.11_U16/95/ 01:07 koha-jenkins Project Koha_20.11_D9 build #111: SUCCESS in 1 hr 8 min: https://jenkins.koha-community.org/job/Koha_20.11_D9/111/ 01:07 mtj tuxayo: they *should* build ok, but dont worry if they do not 01:13 koha-jenkins Project Koha_20.11_U18 build #96: SUCCESS in 1 hr 15 min: https://jenkins.koha-community.org/job/Koha_20.11_U18/96/ 01:24 koha-jenkins Project Koha_20.11_U20 build #105: SUCCESS in 51 min: https://jenkins.koha-community.org/job/Koha_20.11_U20/105/ 01:29 koha-jenkins Yippee, build fixed! 01:29 koha-jenkins Project Koha_19.11_U2010 build #23: FIXED in 23 min: https://jenkins.koha-community.org/job/Koha_19.11_U2010/23/ 01:38 koha-jenkins Project Koha_20.11_U_Stable build #12: SUCCESS in 53 min: https://jenkins.koha-community.org/job/Koha_20.11_U_Stable/12/ 01:38 koha-jenkins Project Koha_19.11_U16 build #85: UNSTABLE in 41 min: https://jenkins.koha-community.org/job/Koha_19.11_U16/85/ 01:42 koha-jenkins Project Koha_20.11_U18 build #97: SUCCESS in 40 min: https://jenkins.koha-community.org/job/Koha_20.11_U18/97/ 01:56 koha-jenkins Project Koha_20.11_D11 build #129: SUCCESS in 48 min: https://jenkins.koha-community.org/job/Koha_20.11_D11/129/ 02:12 koha-jenkins Project Koha_20.11_D11 build #130: UNSTABLE in 58 min: https://jenkins.koha-community.org/job/Koha_20.11_D11/130/ 02:22 koha-jenkins Project Koha_19.11_D10 build #177: SUCCESS in 43 min: https://jenkins.koha-community.org/job/Koha_19.11_D10/177/ 02:31 koha-jenkins Project Koha_20.11_U_Stable build #13: SUCCESS in 52 min: https://jenkins.koha-community.org/job/Koha_20.11_U_Stable/13/ 02:58 koha-jenkins Yippee, build fixed! 02:58 koha-jenkins Project Koha_19.11_U16 build #86: FIXED in 36 min: https://jenkins.koha-community.org/job/Koha_19.11_U16/86/ 03:39 Wainui hey to rmaints etc 03:39 Wainui I've done my stuff for the 19.11.19 release 03:39 Wainui and need to announce now I think 03:39 Wainui but not too sure how to log into the koha community site to make a post 03:49 Wainui oh and that is very cool about Fridolin's move! 03:50 Wainui but yeah I've done all my release things I think so just have to do announcements! 04:08 tuxayo back 04:08 tuxayo Oh, snap Wainui doesn't have website access 04:08 tuxayo I forgot to ask earlier 04:12 tuxayo gmcharlt arround? 04:15 tuxayo or rangi. 04:15 tuxayo Wainui needs an account on the Koha website to announce their release. And you are listed as having admin access to it :) 04:18 tuxayo mtj: great, no need to worry about. Thanks for experimenting stuff and making the CI even better :D 04:29 Wainui rangi said he isn't able to anymore :( 04:31 tuxayo :( 04:32 tuxayo Indeed, Chris only has sysadmin rights 04:46 koha-jenkins Project Koha_20.11_D10-Core build #37: STILL UNSTABLE in 29 min: https://jenkins.koha-community.org/job/Koha_20.11_D10-Core/37/ 04:54 koha-jenkins Yippee, build fixed! 04:54 koha-jenkins Project Koha_20.11_D11 build #131: FIXED in 37 min: https://jenkins.koha-community.org/job/Koha_20.11_D11/131/ 05:11 mtj dcook: i might attempt a koha-libs package this week 05:11 koha-jenkins Project Koha_20.11_D10-Full build #36: STILL UNSTABLE in 54 min: https://jenkins.koha-community.org/job/Koha_20.11_D10-Full/36/ 05:15 dcook mtj: yeah? 05:20 mtj fingers crossed :) - ill follow this thread -> https://lists.koha-community.org/pipermail/koha-devel/2021-April/046413.html 05:21 mtj dcook: i cant think how to test the pkg, once installed... can you? 05:23 mtj "I'm thinking about the absolute minimum required to run things like the SIP server or some other service/microservice (e.g. z3950-responder, REST service, etc)." 05:27 mtj dcook: do you have any of your rpm packaging stuff availble? 05:28 dcook mtj: Just in a virtual meeting at the moment heh 05:29 mtj no probs 🕠05:30 dcook The RPM "<package>-libs" stuff was for a different project which is not open source so I can't really share it. But it just leverages RPM spec file functionality. 05:30 dcook RPM spec files are a million times easier to work with than the DEB packaging mess.. 05:30 dcook As for testing, I'd have to put a bit of thought into it 05:31 dcook It should be easy to test anything that just processes data, but I can't think of a function off the top of my head 05:32 dcook For things that need to access the database, it might be enough to copy a koha-conf.xml file over and write a simple script that just fetches borrowers or something 05:32 dcook What I did lately with one project was to package "<package>-libs" and add that as a dependency to a different project where I just wrote a simple message queue consumer 05:40 mtj i got stuck on making an rpm koha package, when i clicked that all the a2* scripts for debian's apache are missing on redhat :'( 05:40 mtj i didnt realise they were debian specific 05:41 dcook Yeah very Debian specific 05:41 dcook Apache gets implemented so differently across the OSes 05:41 dcook Because why not, eh? haha 05:43 mtj it seems there is no equiv of the a2* scripts on redhat, so... thats a problem 05:46 dcook Is it? How often do you end up using them? 05:46 dcook I guess we do the a2enmod stuff and what not every time 05:47 dcook With my RPMs, I think I try not to touch anything Apache with my packages 05:47 dcook I consider them to be 2 separate things 05:47 dcook Of course easier said than done in the case of Koha 05:50 dcook Hmm opensuse has quite a few a2 scripts 05:50 dcook mtj: which version of RHEL are you looking at? 05:51 dcook Technically you could probably make some shims as well and use PATH magic to invoke them.. 05:53 mtj dcook: twas looking at fedora stable 05:55 mtj great find for a2* on opensuse 05:55 mtj there is a some a2* magic in koha-common.postinst, koha-remove, koha-plack, koha-create 05:56 dcook Of course there is heh 05:56 dcook A useful but problematic integration.. 05:56 mtj ..so all of those scripts will need to be patched to work on redhat/fedora (and friends) 05:57 dcook Yeah, that's a big part of why it's never happened 05:57 dcook The packaging isn't so hard, but supporting Koha on other OSes.. 05:57 dcook I've mostly given up on it 05:57 dcook We're migrating everyone to Debian/Ubuntu, because Koha is too wedded to those OSes 05:57 dcook And then special installs for RHEL where absolutely necessary 05:58 dcook I have thought a bit about how we might change Koha to not rely on Apache per se 05:59 dcook But also easier said than done 06:03 mtj ill take a look at opensuse, and see if i can make more progress with its apache 06:04 dcook What's the goal? 06:04 mtj 'personal growth' 06:04 koha-jenkins Project Koha_20.11_D10 build #119: STILL UNSTABLE in 53 min: https://jenkins.koha-community.org/job/Koha_20.11_D10/119/ 06:05 dcook Fair enough heh 06:07 mtj i have no knowledge of rpm packaging, creating a koha package could be a good way to learn 06:37 reiveune hello 06:43 magnuse \o/ 06:53 alex_a Bonjour 09:34 Mesfin hello everyone 09:35 Mesfin I am having problems upgrading Koha 20.05.06.000 to the latest version 09:35 Mesfin I am getting Row size too large. The maximum row size for the used table type, not counting BLOBs, is .... 09:36 Mesfin The table in question is the `items` table 09:36 cait2 hi Mesfin, we haven't encountered that with items yet, but we had it a whie ago with borrowers I think 09:37 Mesfin How did you resolve it? 09:37 cait2 i am trying to find the bug report 09:37 Mesfin Thank you for responding cait2 09:37 Mesfin My google search leads me to changing the table to Dynamic row_format 09:38 cait2 the bug in question was https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24986 09:38 huginn Bug 24986: critical, P5 - low, ---, jonathan.druart+koha, Pushed to oldoldstable , Maximum row size reached soon for borrowers and deletedborrowers 09:38 Mesfin Most of the tables in my Koha Database are in Compact Row_format 09:38 Mesfin Is this ok? 09:38 cait2 I cannot tell you, I am sorry 09:39 ashimema ooh, that would be a good bug report Mesfin. 09:39 cait2 hm the last 2 comments suggest it might be a possible solution 09:39 cait2 and yes, please report 09:39 cait2 ashimema++ 09:40 ashimema right now Dynamic should be fine 09:40 ashimema but yes, please report the bug.. we should split that table out if we can if we're reaching max row sizes 09:42 Mesfin so setting the items row_format to dynamic should address the problem and allow me to upgrade, right? 09:42 Mesfin Thank you, ashimema 09:42 ashimema I believe so 09:44 mtj Mesfin: this page looks helpful -> https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/ 09:46 Mesfin Thank you, mtj! I have looked at that. I wanted to be sure that changing the `items` table row_format to dynamic doesn't cause problems 09:50 Mesfin Thank you, friends. I will try upgrading again after this change. 09:51 Mesfin I have submitted a bug report as well 09:51 ashimema awesome, thanks Mesfin 10:30 magnuse ooh, not a fan of the "Showing 1 to 10 of 15 entries" feature when looking at a table in schema.k-c... 10:51 oleonard Hi #koha 10:55 ashimema which cait, cait1, cait2 do we have today? 10:55 ashimema hi oleonard 10:58 oleonard @wunder ashimema's house 10:58 huginn oleonard: Error: I could not find a valid location for: ashimema's house 10:59 ashimema lol 10:59 ashimema @wunder stevenage, UK 10:59 huginn ashimema: Error: I could not find a valid location for: stevenage, UK 10:59 ashimema * @wunder Stevenage, England 10:59 ashimema @wunder Stevenage, England 10:59 huginn ashimema: Error: I could not find a valid location for: Stevenage, England 10:59 ashimema grr.. wunder doesn't work so well these days 11:00 oleonard No so well, no. 11:00 ashimema 16 degrees C.. 11:00 ashimema and raining.. hehe 11:00 ashimema feel for bag.. man that's crazy hot over there.. 11:00 ashimema not so bad where you are though right? 11:00 oleonard High of 32C here today. Not great but not as bad as bag. 11:01 oleonard Although he seems to be doing fine with it XD 11:01 cait2 all of them? :) 11:01 cait2 but this one is heading to lunch 11:47 tcohen morning all 11:47 tcohen tuxayo you will need to mount your gpg stuff as well 11:50 mtj hi Mesfin, i will reply to your email on the koha mailing list, as others may find it helpful :) 11:56 mtj looks like bug 28267 describes the problem ^ 11:56 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267 normal, P1 - high, ---, jonathan.druart+koha, Needs Signoff , Koha-common package upgrade problem from 20.05.xx to 20.11.04-1 11:58 Mesfin Thank you, mtj 11:58 Mesfin Yeah, that will be very helpful 12:05 mtj ALTER TABLE `items` ROW_FORMAT=DYNAMIC; 12:05 mtj Mesfin: does that SQL fix your upgrade? ^ 12:06 Mesfin I have done that change already but waiting for off-peak hours to try the upgrade. Will try it tonight and update you. 12:08 Mesfin I have been upgrading Koha for sometime now and there are a number of tables in the database that are on compact row_format even though the default for the server is Dynamic. 12:10 Mesfin mtj: I am on Mariadb 103 12:10 Mesfin 10.3 12:32 mtj Mesfin: try to always test your major upgrades on another server/vm first 12:35 Mesfin What I usually do is take snapshots and if things don't work then I revert to the snapshots 12:35 Mesfin on the VM 12:40 mtj thats a good upgrade plan :p 13:09 tuxayo Does anyone know of package signature works when doing release maintenance? 13:09 tuxayo Like the following says it's OK 13:09 tuxayo *how the package signature 13:09 tuxayo gpg --verify releases/koha-20.05.13.tar.gz.MD5.asc 13:09 tuxayo Even when the tarball and it's MD5 file are not there. 13:11 tuxayo checking releases/koha-20.05.13.tar.gz.sig actually checks the tarball. 13:11 tuxayo but I don't know what the .tar.gz.MD5.asc is for. 13:11 tuxayo and the .tar.gz.MD5 file isn't checked by anything 13:12 tcohen that's for end users to verify the package is legit, right? 13:15 tuxayo tcohen: Indeed they can verify that the tarball is legit using the *.tar.gz.sig file. 13:15 tuxayo But the use of the *.tar.gz.MD5.asc is a mystery and the *.tar.gz.MD5 doesn't seem to be verifiable. 15:39 tuxayo > they can verify that the tarball is legit 15:39 tuxayo Well, if they had my public key lol 16:08 reiveune bye 21:40 EvrenTombul Hi everyone, I was wondering what the word koha means, does anyone know? Could you also explain the meaning of the word koha? meaning of letters 21:42 cait hi, there is a lot of information about this online 21:42 cait EvrenTombul: https://maoridictionary.co.nz/search?idiom=&phrase=&proverb=&loan=&histLoanWords=&keywords=koha 21:43 cait https://wiki.koha-community.org/wiki/The_Koha_Logo_:_Origins_and_Explanation 21:43 cait EvrenTombul: it's not an abbreviation, but a word - see the dictionary link above, so there is no meaning to the letters 21:43 cait Koha is the correct spelling 21:44 EvrenTombul thanks cait