IRC log for #koha, 2019-06-10

All times shown according to UTC.

Time S Nick Message
00:24 dpk_ joined #koha
02:55 cait1 joined #koha
05:10 chris joined #koha
05:37 josef_moravec joined #koha
05:51 m23 joined #koha
06:35 reiveune joined #koha
06:36 reiveune hello
06:44 fridolin joined #koha
06:44 fridolin hi
06:44 alex_a joined #koha
06:44 alex_a bonjour
06:46 davidnind joined #koha
06:50 AndrewIsh joined #koha
07:05 cait joined #koha
07:07 ashimema Mornin' #koha
07:07 cait good morning #koha and ashimema :)
07:10 paul_p joined #koha
07:23 alex_a_ joined #koha
07:27 janPasi joined #koha
07:43 kohaputti joined #koha
07:53 cait matts: around?
08:11 josef_moravec morning #koha
08:12 cait good morning josef_moravec :)
08:13 josef_moravec sorry being not so active last weeks, it was crazy time for me ;)
08:13 cait i think it was for a lot of us, don't worry :)
08:14 josef_moravec cait: how it was going on KohaCon? ;)
08:14 cait it was exhausting in the most lovely way
08:14 josef_moravec ;)
08:14 cait i hope we meet one day!
08:15 josef_moravec I hope too, I would like to go to Marseile, hopefully
08:15 cait fingers crossed
08:17 ashimema yeay, josef_moravec is back :)
08:17 josef_moravec hi ashimema ;)
08:17 ashimema we all have busy times :)
08:17 * josef_moravec is happy to be back with Koha people ;)
08:32 andreashm joined #koha
08:32 * andreashm waves
08:32 * fridolin starting RMaint of 19.05.x
08:33 fridolin a new power is righsing... ;)
08:33 andreashm hi fridolin
08:33 fridolin (the Two Towers)
08:33 andreashm nice!
08:39 ashimema lol
08:39 cait heh
08:39 cait i love your nerdiness
08:47 andreashm We have been trying to upgrade to 18.11 lately, and have had some *interesting* results.
08:49 cait ohoh
08:49 andreashm The addition of changing collation to utf8mb4_unicode_ci creates duplicates in tables with unique keys, and have caused major problems with our (large) borrowers table.
08:49 cait our 18.11 behaves nicely so far
08:49 cait that sounds... interesting
08:49 cait do ou have a clue on how that was even possible?
08:49 andreashm This in turn wrecked InnoDB:s tablespace
08:49 andreashm Causing what we now less than fondly refer to Schrödingers tables
08:50 cait you don#t know if they are alive or not... until oyu try to access them?
08:50 ashimema that sounds really odd
08:50 ashimema not heard of that happening anywhere before
08:50 andreashm They can't be deleted because they don't exist, and can't be recreated because they already exist (according to InnoDB)
08:50 andreashm fun times
08:52 andreashm When not checking for diacritics we have duplicates on both barcode and user_id in the borrowers table.
08:52 andreashm The problem is most likely also our 220K patrons. This causes something to happen with the tablespace
08:53 andreashm We are asuming the introduction of changing collation (17.12.15?) is for chinese etc.?
08:54 andreashm So we have found the cause', and can work with it. But it's taken a long time to fiture out.
08:54 andreashm figure
08:54 cait i think some scripts that were not covered before yes
08:54 cait could you... kill the table ... convert from backup and relaod? or something like that?
08:55 cait filing a bug might lead to more clues
08:56 andreashm yeah, we should file a bug about that one. edge-case problably, but still nasty
08:57 andreashm nope, we couldn't do anything with the table. (or yes, we could of course, but since the problem was in the tablespace it "magically re-appered" after restarting the db)
08:57 andreashm (cait)
08:58 ashimema that's horrible
08:59 ashimema yuk
09:01 andreashm yup
09:01 andreashm yuk indeed
09:01 andreashm thankfully we have good staff here (maybe some of you met Leif at Kohacon in Dublin?). I would never have found the reason for that problem. =)
09:03 cait yep, saw Leif :)
09:03 cait probably scared him
09:03 ashimema haha
09:04 ashimema yeah, lovely person
09:04 andreashm haha
09:04 andreashm Leif is great
09:04 ashimema I don't know how we could have predicted such an issue.. it's really the sort of thing you'd only come accross in a massive production site by the sounds of it..
09:04 ashimema really nasty one
09:05 cait sounds like it could be a mysql bug too?
09:06 andreashm potentially yeah
09:06 andreashm (we use MariaDB)
09:06 josef_moravec I encountered the same issue too I think... only way to go live again was to use backup and recreate the tables
09:07 josef_moravec I believe, there is a bug in mysql too
09:12 cait can someone explain to me what a 'blanket po' is?
09:15 cait hm, i think invoices that don't relate to order lines maybe?
09:16 cait joined #koha
09:19 greenjimll joined #koha
09:24 cait @later tell oleonard can we please get your opinion on 23025?  thx
09:24 huginn` cait: The operation succeeded.
09:27 dpk_ joined #koha
09:32 andreashm josef_moravec: ah, you've had the same issue?
09:32 josef_moravec andreashm: yes
09:32 andreashm did you ever figure out if there was a bug in mysql?
09:32 andreashm and how did you solve this
09:32 andreashm ?
09:33 andreashm We are considering changing to not change collation for some tables, or to change the data before upgrade
09:33 josef_moravec i have no straight solution
09:33 andreashm we've located the duplicate data
09:33 josef_moravec only to remove mysql and start using mariadb...
09:34 andreashm we should _really_ add a bug for this. I will try to create one this week
09:34 josef_moravec i am sure it was during collation change
09:34 andreashm josef_moravec: we are using mariadb. same thing
09:34 andreashm yeah, it really looks like the collation is the problem
09:35 * andreashm doesn't really unserstand _why_ collation is changed.
09:35 josef_moravec but I don't know the reall reason what was wrong during the collation update process in db
09:35 andreashm same here, I think
09:36 josef_moravec because utf8 in mysql isn't real utf8, utf8mb4 is standard UTF-8
09:38 andreashm I had encoding issues
09:38 andreashm hhad/hate
09:38 andreashm ga, can't type
09:46 cait who doesn't
09:50 fridolin left #koha
10:17 josef_moravec left #koha
10:19 andreashm regarding the previous discussion:[…]hen-using-utf8mb4
10:27 khall joined #koha
10:33 cait happy birthday khall!
10:33 khall thanks cait! :)
10:33 cait actually someone with facebook told me ;)
10:34 cait what are you doing here instead of eating cake with the family?
10:36 ashimema :cake:
10:36 ashimema have a good one khall
10:36 khall lol, thanks!
10:37 cait khall: could you quickly weigh in on a bug about the library groups?
10:37 khall sure! what's the number?
10:38 cait just to see if i understand the intention right
10:38 cait bug 22937
10:38 huginn` Bug[…]_bug.cgi?id=22937 minor, P5 - low, ---, jonathan.druart, In Discussion , Searching by library groups uses  group Title rather than Description
10:45 khall cait I see where he's coming from but it was always my intention that the "title" be the "short description" and the description be the "long description". I think we need evidence to support his claim *and* a db update to swap the fields for existing libraries if this patch is going to make it into Koha. A label hint to indicate which field is displayed to users may also be helpful, probably more helpful that swapping the display
10:45 khall field in fact.
10:47 cait i was thinking
10:47 cait maybe we just change the labels
10:47 cait and keep structure as is
10:47 cait i can understand where Lisette was coming from
10:47 cait if you look at how libraries and itemtypes and patron categories work
10:47 cait description there is what we show
10:47 cait so what do you think about:
10:48 cait Title = Display text (or descrpition)
10:48 cait Description = Notes
10:48 cait so just people don't get hung up on terminology comparing to other forms
10:53 davidnind I signed-off on that as it worked
10:53 cait davidnind: yep, I understand, what do you think of changing the labels?
10:54 cait would that have made it more clear?
10:54 davidnind But I was confused about the labelling, having a title and description made sense to me
10:54 davidnind But I thought having the description display instead of the title is weird
10:56 davidnind Maybe someway to display the description when you hover over the title
10:56 davidnind However, I'm not really familiar with how things are done in other places in Koha
10:57 davidnind Keeping it consistent with however similar things are done would make sense to me
10:58 cait i think the descriptio is more internal use
10:58 cait i would not just expose it now as the feature has been in for longer
10:58 cait that would be maybe not a nice surprise :)
10:59 cait hm we lost andreashm
11:00 davidnind I agree
11:01 cait davidnind: btw - you should be sleeping probably... and the chocolate you gave me is soooooo good it makes me feel guilty i didn't have some more for you every time I eat a piece
11:03 davidnind It's only 11pm... You're chocolate was quite nice as well - sweeter than I'm used to, but nice flavours :)
11:03 cait yeah, yours is dark - if the salt chocolate one is out of the fridge I can smell it in the whole apartment
11:04 cait so good.
11:05 davidnind excellent!
11:05 wahanui darn tootin' it is.
11:05 cait i might have to bring you some swiss one next time :)
11:07 davidnind ooh, that would be nice - I haven't really tried swiss chocolate before
11:08 cait noted
11:08 davidnind will have to remember to buy some of these next Easter - they're only on sale for a short period of time[…]my-milk-kiwi-150g
11:09 cait I am not sure i could eat it
11:09 cait they are so super cute
11:09 davidnind I think they are better for decoration or gifts
11:10 cait I like they donate for kiwis with every sold kiwi :)
11:10 cait i saw a kiwi in rotorua
11:10 cait these are the most ridiculous lovely birds
11:12 khall joined #koha
11:13 cait wb khall :)
11:13 davidnind I've only seen one once at Zelandia I think, they are super cute![…]ttle-Spotted-Kiwi
11:14 cait in rotorua they have them in a house where they switch day/night
11:15 cait so you walk in there and it's dark during the day
11:15 cait but we were still quite lucky, the guide said we were the first group in a longer time to see them up so close
11:15 cait one was feeding right in front of the glass
11:16 davidnind very lucky!
11:16 cait it looked like it might fall over any moment
11:17 cait picking up things
11:18 cait they are breeding Kiwis in the Zoo in Frankfurt, but are ot showing them
11:18 cait they explained they didn't adjust to the 'night house' well, so they just keep them behind the scenes now and in their normal rhythm
11:20 oleonard joined #koha
11:22 oleonard Hi all
11:22 cait hi oleonard :)
11:22 davidnind that's interesting, I didn't know they were doing that!
11:23 davidnind looks like there is three places to see kiwis in Germany![…]here-to-see-kiwi/
11:24 cait oh interesting
11:25 cait they jump
11:25 cait best birds ever :)
11:26 davidnind we are very spoilt in NZ!
11:28 cait can't disagree there :)
11:28 dpk_ joined #koha
11:28 cait ashimema: khall: looking at bug 22421
11:28 huginn` Bug[…]_bug.cgi?id=22421 enhancement, P5 - low, ---, martin.renvoize, Signed Off , accountlines.issue_id is missing a foreign key constraint
11:29 cait would it make sense to have a fK for old_issue_id as well?
11:29 ashimema er.. don't I add one there
11:29 cait you do
11:29 cait i read the update wrong, sorry :)
11:29 khall :)
11:29 ashimema phew
11:29 cait i jsut saw it after I asked, the usual
11:30 cait i think this might be a pattern to adopt in other spots too?
11:31 ashimema mm, I'm torn between merging tables like this and doing this sort of key constraint thing
11:31 cait khall: did you see the relabelling question above? would those work for you? display text and notes?
11:31 ashimema I think having this in as an example/option is good but we probably need to make a case by case decision as to whether it makes sense as two tables or one
11:31 khall cait I'd be fine with the. Definitely the smallest cut. I also think a hint as to which field is shown in the pulldown would be helpful.
11:32 cait true
11:37 alex_a joined #koha
11:50 cait hi alex_a :)
11:51 alex_a hello cait
11:53 cait alex_a: thx for your work on Mana
11:54 cait khall: is there another way we put the issue_id in accountlines apart from F FU?
11:55 alex_a cait, thx to you for checking
11:57 khall cait I *think* lost fees perhaps? I'll have to double check
11:58 cait i'll play around a bit
11:58 cait fresh db... have to create data
11:58 khall cait confirmed
12:09 ashimema there's a few more recently cait
12:09 ashimema maybe not in yet
12:09 ashimema but I tried to consistently ensure issue_id was populated wherever we have an issue to associate with an accountline
12:10 magnuse joined #koha
12:10 ashimema so anything that could meaningfully be attached to an issue should be after all my accounts work ;)
12:10 cait ashimema: just trying to test your patch, it reads well
12:10 cait but see it in ation too
12:13 ashimema :)
12:15 khall joined #koha
12:31 davidnind left #koha
12:41 alex_a_ joined #koha
12:58 fridolin joined #koha
12:58 fridolin yop
13:05 liliputech_asu plop :)
13:17 arthur_ joined #koha
13:21 khall joined #koha
13:29 dpk_ joined #koha
13:30 wizzyrea joined #koha
13:31 oleonard Hi wizzyrea
13:32 wizzyrea hi :)
13:33 cait joined #koha
13:46 wizzyrea hi cait
13:46 * cait waves
13:58 lukeG joined #koha
14:10 chris_n joined #koha
14:14 oleonard khall still around?
14:20 oleonard How about Joubu?
14:20 wahanui i think Joubu is kidding, right ;)
14:20 Joubu not kidding, I am around
14:20 oleonard Hi Joubu
14:21 Joubu hi :)
14:21 oleonard I don't think I understand your comment on Bug 23025
14:21 huginn` Bug[…]_bug.cgi?id=23025 is not accessible.
14:30 Joubu I answered you privately
14:31 oleonard Thanks
15:07 fridolin left #koha
15:09 m23 joined #koha
15:11 mtompset joined #koha
15:12 mtompset Greetings, #koha.
15:12 mtompset Xmorave2++ # Thank you for adding that tweak to the wiki "The Easy Way" page.
15:18 reiveune bye
15:18 reiveune left #koha
15:30 dpk_ joined #koha
15:38 lukeG joined #koha
16:06 mtompset Has anyone here hit the validate_password_policy problem?
16:07 mtompset @seen kidclamp
16:07 huginn` mtompset: kidclamp was last seen in #koha 2 days, 23 hours, 22 minutes, and 58 seconds ago: <kidclamp> is this on master?
16:07 mtompset @seen bag
16:07 huginn` mtompset: bag was last seen in #koha 1 week, 3 days, 19 hours, 34 minutes, and 24 seconds ago: <bag> nice
16:07 mtompset @seen Joubu
16:07 huginn` mtompset: Joubu was last seen in #koha 1 hour, 37 minutes, and 15 seconds ago: <Joubu> I answered you privately
16:08 mtompset @seen oleonard
16:08 huginn` mtompset: oleonard was last seen in #koha 1 hour, 36 minutes, and 52 seconds ago: <oleonard> Thanks
16:08 oleonard Just checking, or do you have a question mtompset?
16:11 mtompset Ah...
16:11 mtompset Sorry for the slow reply.
16:11 mtompset Yes, have you tried to koha-create lately, oleonard?
16:12 oleonard No, sorry.
16:12 mtompset could you humour me and try?
16:12 oleonard Sorry I can't at the moment
16:13 mtompset No rush...
16:14 mtompset just that seems that MySQL has added validate_password plugin variable
16:14 mtompset and if you don't have validate_password_policy set to LOW... koha-create will fail.
16:17 khall joined #koha
16:22 oleonard khall awake?
16:22 khall what's up?
16:23 oleonard I have a question about the new devboxes that I hope you can answer
16:23 oleonard Sorry, sandboxes
16:23 oleonard I'd like to build one based on a gitlab branch and I'm not sure of the syntax
16:23 * ashimema is here and listening too
16:25 mtompset Ah, perhaps khall can test koha-create for me? It's failing by default. :)
16:26 khall oleonard can you send me a link to the gitlab repo?
16:26 oleonard khall: Is the "repository url" the project URL? e.g.
16:26 khall mtompset I think you'd be better asking tcohen :)
16:27 mtompset Anyone can run koha-create.
16:27 mtompset I just need someone to run it and confirm it fails for them too.
16:27 mtompset I have a patch idea too. :)
16:27 khall mtompset is there a bug number?
16:27 khall oleonard you'd want to put in the repository url field
16:28 khall and the branch name in the "name of branch" field
16:28 oleonard Thanks khall
16:37 mtompset I created bug 23090
16:38 huginn` Bug[…]_bug.cgi?id=23090 blocker, P1 - high, ---, mtompset, NEW , MySQL validate_password plugin breaks koha-create
16:39 oleonard khall: The sandboxes don't rebuild CSS?
16:39 khall oleonard not unless koha-testing-docker does
16:56 oleonard Anyone know if there is a way in kohadevbox to override the default .bashrc in a way which will persist through destruction/creation of boxes?
16:58 cait khall: does that mean yes or on for docker? (sorry, just problem parsing hte sentence)
16:58 cait yes or no
16:59 cait oleonard: sorry, don't know
17:06 wizzyrea oleonard, yes there is you'd need to modify the skeleton files
17:06 wizzyrea or create one and install it, though I think it ships with one
17:06 oleonard Oh no not my skeleton!
17:08 wizzyrea it's in kohadevbox/roles/kohadevbox/templates
17:10 wizzyrea what that'll do is make a change to the .bashrc that is installed with every new vagrant up
17:11 oleonard Yjsmld eoxxutrs@
17:11 oleonard ...which is "Thanks wizzyrea!" if my fingers are off by a key
17:29 wizzyrea hahaha
17:29 wizzyrea <3
17:29 wizzyrea yw
17:31 dpk_ joined #koha
17:53 ashimema I've not gotten around to adding buttons for all the koha-testing-docker improvements tchoen made yet
17:54 ashimema There will be a pull request incoming for the docker sandboxes repo at some point khall
17:54 khall awesome ashimema !
17:54 ashimema It'll add buttons for 'rebuild css', 'rebuild dbic schema'
17:55 ashimema I'm sure there were other little enhancements I had on my list but I can't remember what they were now
17:55 oleonard-away Excellent
17:55 wahanui darn tootin' it is.
17:55 * ashimema is in the parents queue waiting to pickup daughter 1 from martial arts class
17:56 ashimema oleonard  see above
17:56 ashimema Short is.. not yet but it's coming
18:28 oleonard Bye all
18:57 wizzyrea poll: is it mariah db, or maria db?
18:57 wizzyrea I always say maria
18:57 cait no h
18:58 wizzyrea :D
18:58 wizzyrea this is about pronunciation
18:58 cait the more german is the second, so i am probably used to this on
18:58 cait e
18:58 mtompset I thought it was like Ava Maria. ;)
18:59 mtompset Greetings, cait wizzyrea
18:59 mtompset Greetings ashimema
18:59 mtompset I put a patch up on bug 23090 now, khall :)
18:59 huginn` Bug[…]_bug.cgi?id=23090 blocker, P1 - high, ---, mtompset, Needs Signoff , MySQL validate_password plugin breaks koha-create
18:59 mtompset I should test this with MariaDB...
19:01 wizzyrea I also just learned of a tool called mydumper
19:01 wizzyrea which could have benefits over mysqldump for large Koha sites
19:01 wizzyrea and myloader, to load those dumps
19:02 wizzyrea it's in the stretch repositories
19:04 wizzyrea one of the A+ things is that you get separate files for tables
19:04 wizzyrea so if you only need to import one table, you can very easily do that from the dumps it makes.
19:05 wizzyrea I don't think we'd want to replace mysqldump, but I feel like we could make our scripts use mydumper, optionally.
19:32 dpk_ joined #koha
19:50 cait joined #koha
19:58 inlibro joined #koha
20:00 arthur_ joined #koha
20:01 khall joined #koha
20:17 inlibro arthur.bousquet: blou added to the channel by arthur.bousquet
20:23 inlibro joined #koha
20:25 ashimema Wha
20:25 alexbuckley joined #koha
20:25 ashimema Time for sleep.. nighty night #koha
20:26 inlibro charles: # 🌵
20:27 totomeow joined #koha
20:28 inlibro arthur.bousquet: 🌵
20:55 kathryn joined #koha
21:23 inlibro joined #koha
21:33 dpk_ joined #koha
21:38 koha-jenkins Project Koha_18.11_U18 build #92: STILL UNSTABLE in 27 min: https://jenkins.koha-community[…]oha_18.11_U18/92/
21:45 koha-jenkins Project Koha_18.11_D9 build #98: SUCCESS in 31 min: https://jenkins.koha-community[…]Koha_18.11_D9/98/
21:50 koha-jenkins Project Koha_18.11_D8 build #97: UNSTABLE in 40 min: https://jenkins.koha-community[…]Koha_18.11_D8/97/
22:06 mtompset Greetings, alexbuckley
22:07 m23 joined #koha
22:24 inlibro joined #koha
23:02 papa joined #koha
23:08 mtompset Greetings, inlibro papa
23:08 papa hey, good morning!
23:09 alexbuckley hey mtompset
23:09 wahanui rumour has it mtompset is going to try to work on bug 10589
23:09 huginn` Bug[…]_bug.cgi?id=10589 enhancement, P5 - low, ---, mtompset, ASSIGNED , Override OpacHiddenItems based on Patron Branch
23:10 mtompset Actually, wahanui I am trying to get a sign-off for bug 23090. :)
23:10 huginn` Bug[…]_bug.cgi?id=23090 blocker, P1 - high, ---, mtompset, Needs Signoff , MySQL validate_password plugin breaks koha-create
23:11 mtompset tried installing Koha on Ubuntu Bionic, and hit a MySQL "improvement"
23:12 mtompset there's a whole bunch of validate_password variables including a validate_password_policy, which determines what characters must be in the password.
23:12 mtompset So when koha-create tries to create a DB instance user, the 'pwgen -s' does not cut it.
23:12 mtompset Even though, it is pretty good.
23:13 mtompset Because it is lack a special character (you know like ,.$#@ etc. etc.)
23:13 mtompset The problem is with sed calls and such, certain special characters break the koha-create script.
23:14 mtompset So, I think I have something which works posted as a patch on bug 23090. :)
23:14 mtompset This do NOT affect MariaDB, as far as I know.
23:15 mtompset Because the MariaDB that Ubuntu installs by default doesn't have that validate_password mechanism.
23:15 mtompset This kind of ties into the problem that Charles was likely having on the mailing list.
23:16 mtompset (I think it was someone named Charles -- my memory is flakey sometimes :) )
23:24 inlibro joined #koha
23:34 dpk_ joined #koha
23:35 mtompset @seen tcohen
23:35 huginn` mtompset: tcohen was last seen in #koha 5 days, 9 hours, 6 minutes, and 6 seconds ago: <tcohen> caroline_catlady, davidnind I have access to the YouTube channel, I created it. Let's talk about handing you control

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