Time Nick Message 06:17 * magnuse vinker 06:17 * LibraryClaire waves 06:24 magnuse guten morgen BüchereiKlara 06:28 LibraryClaire morning magnuse 06:30 magnuse indeed 06:31 magnuse @later tell LeeJ not sure there is much more to say about the nl-* scripts than what is in the POD. they are used for syncing data between Koha and the Norwegian national patron database 06:31 huginn` magnuse: The operation succeeded. 06:52 marcelr hi #koha 06:55 reiveune hello 07:01 alex_a bonjour 07:01 wahanui bonjour, alex_a 07:05 fridolin hi there 07:12 alexbuckley hi all 07:29 gaetan_B hello 07:29 wahanui salut, gaetan_B 07:45 * cait waves 07:45 cait magnuse: around? 07:52 magnuse yup 08:45 magnuse tjänare Stina 08:45 magnuse cait: yup 08:48 Stina Tjena @magnuse 08:49 magnuse :-) 08:53 eythian hi 08:53 wahanui niihau, eythian 09:20 magnuse wow, needs signoff < 100! 09:20 magnuse cait++ 09:20 magnuse alexbuckley++ 09:20 magnuse oleonard++ 09:21 alexbuckley thanks magnuse! 09:22 magnuse no, thank you alexbuckley 09:22 magnuse 19 signoffs is awesome! 09:22 alexbuckley yeah its very rewarding :) 09:23 marcelr cait++ alexbuckley++ 09:24 marcelr can we get some qaers please :) 09:25 marcelr 174.. 09:34 ammopt good morning all 09:56 marcelr alexbuckley: thx for followup on 18308; only problem would be now: do all libraries really want this? devs and admins do, but users.. 09:59 alexbuckley hmm it could be included in the onboarding tool so when Koha is being installed the value can be set but have it set to 3 by default in sysprefs.sql? 10:07 alexbuckley what do you think of that for a solution marcelr? 10:08 marcelr i strongly think that it should be 8, but i know there will be resistence 10:08 marcelr onboarding could be a good compromise 10:09 marcelr can we set it to 8 and optionally lower it in onboarding ? 10:09 alexbuckley yeah thats a good idea 10:10 marcelr yes with a little security advertisement :) 10:10 marcelr when you leave the door open, the burglars will not break your lock 10:11 alexbuckley yeah :) 10:12 alexbuckley Another password related bug I have noticed is in onboarding when a user creates a admin user they don't have password restrictions this is another security risk because the user is creating a superlibrarian 10:12 marcelr sounds worse 10:12 alexbuckley yeah 10:20 ammopt anyone experienced with the https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix that can advise me on how to fix corrupted data? 10:20 ammopt should i manually update the issue_id from old_issues to the next available id AFTER implementing the suggested fix? 10:41 marcelr @later tell tcohen Hope that the latest follow-up on 10306 address your most important concerns 10:41 huginn` marcelr: The operation succeeded. 10:41 marcelr adresses 10:52 marcelr @later tell Joubu Please push follow-up on 14826 10:52 huginn` marcelr: The operation succeeded. 11:27 * kidclamp waves 11:27 marcelr o/ 11:40 alexbuckley marcelr: I am halfway through updated patch for 18308, and I have finished a patch for the onboarding patron password: bug 19514 11:40 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19514 critical, P3, ---, alexbuckley, Needs Signoff , No Password restrictions in onboarding tool patron creation 11:40 alexbuckley Have set it to critical as I thought it was a pretty big security vulnerability 11:40 marcelr great 11:40 marcelr will have a (short) look now 11:40 alexbuckley thanks 11:41 alexbuckley If you can write your feedback on the bug report, I am going to head off to bed now its late here in NZ :) 11:41 marcelr sure 11:41 alexbuckley cheers seeya 11:41 marcelr bye 11:49 magnuse kia ora oleonard 11:49 oleonard Hi magnuse and all 12:19 Andrew27 Hello! 12:20 Andrew27 I have setup Koha which I documented as I went here: https://community.spiceworks.com/how_to/146465-install-koha-17-05-on-ubuntu-16-04-digitalocean-with-mariadb?source=navbar-community-notificationsbut 12:20 Andrew27 https://community.spiceworks.com/how_to/146465-install-koha-17-05-on-ubuntu-16-04-digitalocean-with-mariadb?source=navbar-community-notifications 12:21 Andrew27 The issue is that the CPU is constantly running high... any suggestions? 12:24 * fridolin releasing 17.05.05 12:24 magnuse fridolin++ 12:25 * magnuse eagerly awaits the packages :-) 12:56 magnuse kia ora nengard 12:56 nengard :) Hiya! 13:27 tcohen morning 13:57 Andrew27 Koha on Ubuntu, MySQL/MariaDB - CPU very high. Any thoughts? 13:59 tcohen hit by a crawler? (gogole? 14:04 eythian looks like Germany has fallen off the world! 14:14 mtompset Greetings, #koha. 14:14 mtompset Can anyone here help me with a git problem? I have an uncommited file remnant chasing me across branches, and I can't seem to get rid of it. 14:15 tuxayo mtompset: what's it's name? Can it be deleted or do you need it? 14:16 Joubu hola 14:16 mtompset At this point in time, I don't need it. 14:16 Joubu rm it :) 14:16 mtompset It's Koha/Schema/Result/Account[Oo]ffset.pm (yes, two files, that seem to come and go alternatively after hard resets. 14:18 tuxayo mtompset: I also have it (Koha/Schema/Result/Accountoffset.pm) shouldn't it be commited? 14:19 Joubu Accountoffset.pm has been moved to AccountOffset.pm 3d ago 14:19 Joubu (the table has been renamed) 14:19 eythian that may cause issues especially for people on windows or mac 14:19 mtompset I figured, but something is really weird for me. 14:20 mtompset git reset --hard origin/master brings it back. 14:25 mtompset bug 10222 -- puppy saved 14:25 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10222 normal, P5 - low, ---, cnighswonger, Needs Signoff , Error when saving Demco label templates 14:27 mtompset our Failed QA stack is large. 14:29 Joubu NQA is 175!!! 14:32 mtompset Failed QA is 327! I get that NQA is 175 is bad, but I think 327 Failed QA is worse. 14:44 mtompset I'm destroying and recreating my koha devbox, in hopes of ridding myself of this git ghost. 14:53 tcohen mtompset: no need to do that 14:55 Joubu khall, kidclamp: Hi! Can you give an answer on 12768, if you have it :) 14:56 khall Joubu: working on a patch right now 14:56 khall with unit tests ; ) 14:57 Joubu khall: I am talking about a new comment, there is a DB change on itemtypes.rentalcharge 14:57 khall ah, I'll look at that when I'm done with this 14:57 Joubu it has been modified from double(16,4) to decimal(28,6), but I am not sure it was expected 15:00 Joubu however it would make sense to have it decimal(28,6) as all other cost fields use this format 15:03 khall Joubu: agreed, I think the change was done to bring it in line with the other fields but they forgot to document it 15:08 Joubu khall: you forgot to add 'Processing Fee' to the sql file 15:08 Joubu installer/data/mysql/account_offset_types.sql 15:11 reiveune bye 15:16 khall Joubu: ah, thanks, I'll update the patch 15:17 * oleonard too has a ghost AccountOffset.pm 15:18 eythian oleonard: you work on windows though don't you? 15:20 oleonard Yes 15:20 oleonard kohadevbox on Windows 15:20 eythian that's probably the problem. 15:20 eythian it's a case change, and windows is insensitive. 15:20 eythian also, it doesn't care about case. 15:20 oleonard Oh right. heckin' Windows. 15:21 eythian it's probably enough to rm it and then git checkout -- /the/proper/name 15:33 eythian sorry, "del" it 15:33 eythian and \the\proper\name 15:43 huginn` New commit(s) kohagit: Bug 12768: DBRev 17.06.00.019 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=208500193ef23678793c00ca2a8da4c55dba9724> / Bug 12768: (QA follow-up) Use specific account offset types for Processing Fee and... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1ea5f9c82ac195c29ebeff2e534eedce54ae84ca> / Bug 12768: Fix tests - itemtypes.rentalcharge is now decimal(28,6) <http://git.koha-communit 15:50 mtompset nope... blowing away my windows clone, and recloning from scratch. 15:54 mtompset There does seem to be a way to do it, but given the assumption of case-insensitivity in the Windows API, things could break if... 15:54 mtompset You change HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\kernel\ dword:ObCaseInsensitive to 0 15:55 oleonard I'm almost certain I've dealt with this problem before but I can't remember what the solution was 15:57 tcohen mtompset: look at the followup for 14826 15:59 eythian You don't want to change the fs case sensitivity in a system not built with it in mind. Stuff will break. 16:01 mtompset tcohen: Eeeewww.... there it is. 16:01 tcohen and eythian is right, shit will get real if you change that 16:01 mtompset eythian: But a temporary tweak to get the ghost to go away might be useful. 16:02 eythian I would expect explosions. 16:02 eythian I'd suggest figuring out how to corral git as being a safer approach. 16:02 eythian Also, a useful learning exercise. 16:04 mtompset I'm not sure I have the patience to attempt to corral it. That's why I went full on rm -rf *; git clone. 16:04 oleonard And did that help? 16:04 mtompset Now I only have to watch for it clone over lunch. 16:04 mtompset then I'll know... in about 1-2 hours. 16:05 tcohen git fetch origin ; git reset --hard origin/master 16:05 tcohen ?? 16:06 eythian if it's a windows rename problem, that may not help. 16:06 oleonard it doesn't 16:06 eythian Hence why I figured deleting the problem file and rechecking it out might work. 16:07 eythian or apt-get install $a_real_os :) 16:08 Joubu mtompset: really, the brutal way would have been git reset --hard origin/master; git clean -f -d 16:09 Joubu I do not see the need to cloning the whole repo, you will face the same problem when you will `git checkout $commit_before_now` 16:09 jenkins Project Koha_Master_D8 build #275: STILL UNSTABLE in 31 min: https://jenkins.koha-community.org/job/Koha_Master_D8/275/ 16:09 jenkins * m.de.rooy: Bug 14826: (QA follow-up) Remove obsolete DBIx schema file 16:09 jenkins * Jonathan Druart: Bug 12768: Fix tests - itemtypes.rentalcharge is now decimal(28,6) 16:09 jenkins * kyle: Bug 12768: (QA follow-up) Use specific account offset types for 16:09 jenkins * Jonathan Druart: Bug 12768: DBRev 17.06.00.019 16:09 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14826 enhancement, P5 - low, ---, kyle.m.hall, Pushed to Master , Resurrect account offsets table 16:09 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12768 enhancement, P5 - low, ---, maxime.beaulieu, Pushed to Master , Replacement cost and processing fee management 16:11 Joubu khall: t/db_dependent/Circulation/NoIssuesChargeGuarantees.t is now failing 16:13 mtompset Ah... git clean -f -d -- Okay, I'll try that if the ghost rears its ugly head. 16:13 mtompset Joubu++ # thanks for the git idea. 16:14 Joubu well, be careful with this clean -f -d, it did exactly what it means! 16:24 oleonard "git reset --hard origin/master; git clean -f -d" worked for me mtompset 16:24 mtompset oleonard++ # thanks for the verification. 16:37 oleonard Joubu++ # for the suggestion 17:12 * cait waves 17:42 mtompset Wow. 2.8 GB full clone. 17:45 * magnuse waves 17:45 magnuse mtompset: yeah, don't try and tell us koha is a lightweight ils ;-) 17:45 * cait waves 17:45 cait hi georgewilliams and magnuse 17:46 georgewilliams He cait 17:46 magnuse hiya cait 17:46 georgewilliams Hi cait 17:46 huginn` New commit(s) kohagit: Bug 12768: (QA follow-up) Don't use manualinvoice for non-manual invoices in chargelo... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c63d560b041ab67bafc65a6f9e65eee9e43c2a1a> / Bug 19517: Prevent dateexpiry.t to fail randomly <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d37bf788936b43d942c44caa2e47fc39e5d0e2a1> 17:46 mtompset true, true, magnuse. 17:47 mtompset Greetings, magnuse cait oleonard-away georgewilliams Joubu -- some greetings being quite belated, but anyways. :) 17:48 * mtompset notes that greetings all around for those not expressly mentioned. 17:48 mtompset I was too lazy to scroll back. :) 17:48 cait :) 17:49 magnuse would it make sense to have on .psgi file per site on a packages install? so they could be tweaked individually? 17:49 magnuse *one 17:54 Joubu magnuse: yes, you can already do that 17:54 magnuse Joubu: i can? Excellent! but how? 17:54 Joubu koha-plack uses /etc/koha/sites/${instancename}/plack.psgi if exists 17:54 Joubu otherwise /etc/koha/plack.psgi 17:58 kidclamp @later tell fridolin 19296 for 17.05? 17:58 huginn` kidclamp: The operation succeeded. 18:00 magnuse awesome, thanks a ton for that piece of info, Joubu! 18:00 magnuse Joubu++ 18:05 magnuse bug 19518 18:05 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19518 enhancement, P5 - low, ---, magnus, NEW , Document per-site .psgi files 18:16 jenkins Project Koha_Master_D8 build #276: STILL UNSTABLE in 28 min: https://jenkins.koha-community.org/job/Koha_Master_D8/276/ 18:16 jenkins * Jonathan Druart: Bug 19517: Prevent dateexpiry.t to fail randomly 18:16 jenkins * kyle: Bug 12768: (QA follow-up) Don't use manualinvoice for non-manual 18:16 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19517 normal, P5 - low, ---, jonathan.druart, Pushed to Master , dateexpiry.t is failing randomly 18:16 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12768 enhancement, P5 - low, ---, maxime.beaulieu, Pushed to Master , Replacement cost and processing fee management 18:34 khall @later tell Joubu looks like the version of my followup you pushed is missing the addition of "Processing Fee" to the account_offset_types table, please it removes the unit tests I added : \ 18:34 huginn` khall: The operation succeeded. 18:37 * magnuse waves to khall 18:37 khall \0/ 18:38 magnuse :-) 19:10 tcohen bye #koha 19:41 * cait waves to kathryn 19:41 * kathryn waves back :) 19:42 magnuse have fun, #koha! 19:49 kathryn ni nengard and magnuse :) long time no see (I haven't been around much lately) 19:55 nengard howdy kathryn 19:56 kathryn :) 20:01 huginn` New commit(s) kohagit: Bug 12768: Fix bad merge resolution conflict <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=42c634745cac4fc33a53bc1312a3e143a2e0ffbc> 20:31 jenkins Yippee, build fixed! 20:31 wahanui o/ '`'`'`'`'`'`'`'`'` 20:31 jenkins Project Koha_Master_D8 build #277: FIXED in 28 min: https://jenkins.koha-community.org/job/Koha_Master_D8/277/ 20:31 jenkins Jonathan Druart: Bug 12768: Fix bad merge resolution conflict 20:31 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12768 enhancement, P5 - low, ---, maxime.beaulieu, Pushed to Master , Replacement cost and processing fee management 22:00 pastebot "mtompset" at 127.0.0.1 pasted "How do I fix this?" (5 lines) at http://paste.koha-community.org/62 22:00 mtompset Anyone familiar with what the POD coverage messages mean and how to fix them? 22:00 wizzyrea isn't the code of the qa tool avaliable? 22:00 wizzyrea available* 22:01 wizzyrea @later tell pianohacker because we are awesome. But also probably because we do important stuff for important people. 22:01 huginn` wizzyrea: The operation succeeded. 22:54 mtompset wizzyrea: Reading code to fix code which isn't my code... :( Not fun. 23:29 mtompset Let someone else figure it out... put up partial success. 23:31 oleonard Hey all, does anyone know if there are instructions for installing testing the Koha Dashboard locally? 23:32 oleonard I'm almost sure I've seen such a thing before, but now I can't find anything. 23:39 oleonard @later tell rangi Are there instructions for testing the Koha Dashboard locally? Should it be possible to do it in kohadevbox? 23:39 huginn` oleonard: The operation succeeded. 23:44 caboose @later tell edveal will be happy to take a look, thanks for pinging me! 23:44 huginn` caboose: The operation succeeded.