IRC log for #koha, 2021-06-28

All times shown according to UTC.

Time S Nick Message
00:01 Wainui joined #koha
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[…]ha_19.11_U18/325/
00:32 koha-jenkins Project Koha_20.11_U20 build #104: SUCCESS in 34 min: https://jenkins.koha-community[…]ha_20.11_U20/104/
00:32 koha-jenkins Project Koha_19.11_D8 build #398: SUCCESS in 32 min: https://jenkins.koha-community[…]oha_19.11_D8/398/
00:45 koha-jenkins Project Koha_19.11_D9 build #340: SUCCESS in 44 min: https://jenkins.koha-community[…]oha_19.11_D9/340/
00:57 koha-jenkins Project Koha_20.11_D10 build #118: UNSTABLE in 59 min: https://jenkins.koha-community[…]ha_20.11_D10/118/
01:01 koha-jenkins Project Koha_19.11_U20 build #224: SUCCESS in 29 min: https://jenkins.koha-community[…]ha_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[…]oha_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[…]oha_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[…]oha_20.11_U18/96/
01:24 koha-jenkins Project Koha_20.11_U20 build #105: SUCCESS in 51 min: https://jenkins.koha-community[…]ha_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[…]a_19.11_U2010/23/
01:38 koha-jenkins Project Koha_20.11_U_Stable build #12: SUCCESS in 53 min: https://jenkins.koha-community[…]0.11_U_Stable/12/
01:38 koha-jenkins Project Koha_19.11_U16 build #85: UNSTABLE in 41 min: https://jenkins.koha-community[…]oha_19.11_U16/85/
01:42 koha-jenkins Project Koha_20.11_U18 build #97: SUCCESS in 40 min: https://jenkins.koha-community[…]oha_20.11_U18/97/
01:56 koha-jenkins Project Koha_20.11_D11 build #129: SUCCESS in 48 min: https://jenkins.koha-community[…]ha_20.11_D11/129/
02:12 koha-jenkins Project Koha_20.11_D11 build #130: UNSTABLE in 58 min: https://jenkins.koha-community[…]ha_20.11_D11/130/
02:22 koha-jenkins Project Koha_19.11_D10 build #177: SUCCESS in 43 min: https://jenkins.koha-community[…]ha_19.11_D10/177/
02:31 koha-jenkins Project Koha_20.11_U_Stable build #13: SUCCESS in 52 min: https://jenkins.koha-community[…]0.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[…]oha_19.11_U16/86/
03:39 Wainui joined #koha
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:48 Wainui joined #koha
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 joined #koha
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[…]0.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[…]ha_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[…]0.11_D10-Full/36/
05:15 dcook mtj: yeah?
05:20 mtj fingers crossed :) - ill follow this thread -> https://lists.koha-community.o[…]April/046413.html
05:21 chriss joined #koha
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[…]ha_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:16 did joined #koha
06:33 magnuse joined #koha
06:37 reiveune joined #koha
06:37 reiveune hello
06:38 cait joined #koha
06:43 magnuse \o/
06:52 sophie_m joined #koha
06:53 alex_a joined #koha
06:53 alex_a Bonjour
06:55 lds joined #koha
06:59 cait1 joined #koha
07:04 cait2 joined #koha
07:49 alex_a joined #koha
07:53 lds_ joined #koha
08:01 Mesfin joined #koha
09:02 alex_a joined #koha
09:04 lmstrandatdesk joined #koha
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.or[…]_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/trou[…]rors-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:42 oleonard joined #koha
10:50 alex_a joined #koha
10:51 oleonard Hi #koha
10:53 khall joined #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:12 cait joined #koha
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.or[…]_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
12:55 lukeG joined #koha
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.
13:24 Dyrcona joined #koha
13:50 cait2 left #koha
14:31 petrus952 joined #koha
14:40 dpk joined #koha
15:02 petrus952 left #koha
15:31 cait joined #koha
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
16:08 reiveune left #koha
18:49 devap joined #koha
21:31 devap joined #koha
21:36 EvrenTombul joined #koha
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/[…]ds=&keywords=koha
21:43 cait https://wiki.koha-community.or[…]s_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
23:44 khall joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary