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