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