Time Nick Message 00:14 urra hello, I have had many problems installing koha with mariadb 00:15 urra I have been working for two days and finally this I do not find a clear explanation 00:15 urra I have this error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") 01:00 mtj hi urra[m], that error usually means that the database is not running... 01:00 mtj https://mariadb.com/kb/en/troubleshooting-connection-issues/ 01:04 mtj also,,you shouldnt need to touch any database config files to install Koha 01:05 mtj https://wiki.koha-community.org/wiki/Koha_on_Debian 02:24 dcook Hey folks, I don't suppose anyone is having trouble with git-bz atm? 02:25 dcook Hmm actually looks like maybe I broke something somehow.. 02:31 dcook Annd sorted 02:31 hayley good job dcook 02:33 dcook Was a bit too free with the ol' delete key in the git config.. 06:55 cait mtj++ :) 07:49 reiveune hello 07:49 wahanui bonjour, reiveune 07:49 magnuse mtj: well, there is the autoincrement-fix 07:49 magnuse \o/ 07:55 marcelr hi #koha 08:00 calire morning #koha 08:01 magnuse bonjour calire marcelr 08:04 alex_a Bonjour 08:05 calire hey magnuse 08:06 ashimema[m] mornin' #koha 08:41 cait bgkriegel++ # patch for translating values of multi-select prefs 08:43 Joubu cait: which bug number is that? 08:45 cait Joubu: it's already done - just finishing the translation for 19.11 08:46 Joubu ha :) 08:46 cait bug 23452 08:46 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23452 normal, P5 - low, ---, bgkriegel, Pushed to master , Multiple select options in system preferences are not translatable 08:46 cait made it into the po files for the .01 08:47 Joubu that was the one I had in mind then. I thought there was an other one 08:48 ashimema[m] bernardo seems nice and active this cycle :) 08:49 ashimema[m] if anyone fancies looking at bug 13897 I'm sure he'd be apreciative :) 08:49 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13897 enhancement, P5 - low, ---, bgkriegel, Needs Signoff , Use XML files for installer data 08:49 nlegrand a good day #koha 08:50 ashimema[m] I'm still a bit vague as to how good an idea it is.. whether it's mysql and mariadb compatabile and whether it's a bit of a msqlism or not 08:51 ashimema[m] would appreciate peoples thoughts.. 08:51 ashimema[m] I wondered about doing something similar with SQL fairly 08:51 ashimema[m] * I wondered about doing something similar with SQL fairy 08:51 nlegrand I don't think most of the time. Thinking is dangerous. 08:51 ashimema[m] haha 08:56 cait ashimema++ # thx for participating in my survey ;) 09:04 Joubu ashimema[m]: it should be yml, not xml 09:05 Joubu ha 09:05 Joubu not possible :) 09:06 ashimema[m] ? 09:07 ashimema[m] you mean, you'd prefer it in yaml rather than using XML.. yeah, I think I probably agree 09:07 Joubu nevermind, speaking to quickly 09:07 ashimema[m] but.. he's using a standard XML output format supported by mysqldump I beleive.. 09:08 ashimema[m] must admit.. it's at least a month since I read the code and understood the bug fully 09:08 Joubu yes but, + my $query = "LOAD XML LOCAL INFILE '".$filename."' INTO TABLE ".$table; # MySQL only 09:08 Joubu we could writ our own stuff, yml-based 09:09 ashimema[m] I had a horrible feeling that might be the case.. not sure mariadb supports it too or not 09:10 ashimema[m] I would suggest, rather than completely roll our own, we use SQL::Translator 09:11 ashimema[m] https://metacpan.org/release/SQL-Translator 09:11 ashimema[m] there are loads of well maintained Parser/Producer pairs in there 09:12 ashimema[m] it natively uses XML internally I believe as it's middle format 09:14 ashimema[m] I'm thinking that route may also help us with database agnosticism if we are still keen to do that.. 09:14 Joubu fyi Bernardo's patch works with MariaDB 09:17 Joubu ashimema[m]: can you let a note about SQL::Translator? 09:22 ashimema[m] for how long I wonder ;) 10:11 cait Susi, bist du heute zum letzten Mal da? 10:11 cait wrong chat 10:12 cait please ignore 10:27 kohaputti Joubu, https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24137 not very happy about the commit message "Same fixes for *_local.sql files", better to copy the previous commit message where it tells what the commit does... Anyway, you set it to signed-off even though nobody has signed-off the last patch so do you think it would be okay if I just do the QA-sign-off there and it is enough? 10:28 huginn Bug 24137: major, P3, ---, jonathan.druart, Signed Off , Marc21 bibliographic fails to install for ru-Ru and uk-UA 10:29 Joubu I can change it to Needs Signoff if you think a signoff is required on the last patch 10:29 kohaputti I would like a sign-off for the last patch since it needs testing 10:29 Joubu commit message says "see before", it is what it does, the 2 perl commands to generate the patch, then the manual edit for "hidden" 10:30 Joubu I tested it, and you will. But we can ask for another test. 10:31 kohaputti ok, I will just change the status to needs sign-off 11:10 huginn News from kohagit: Bug 23233: DBRev 19.12.00.002 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9a5ce70d3bf01d91c5864ef7c83273d22e536376> 11:10 huginn News from kohagit: Bug 24241: (bug 23049 follow-up) Add description for manage_accounts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f115158d6df03b6238a1b2c22998b8c3a5a4cd07> 11:10 huginn News from kohagit: Bug 23233: (follow-up) Correct test description <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=dac488b55f76b511a5c9bd66ced6b1813368c83e> 11:10 huginn News from kohagit: Bug 23233: (follow-up) Add description to atomic upgrade <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b2b9f2ceb87189eab1cbfab8b291afe95101c4b8> 11:10 huginn News from kohagit: Bug 23233: (follow-up) Remove accidentally left comment <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1bd6c7d4571c1e7ad9ea8ee6f456260cb3636669> 11:10 huginn News from kohagit: Bug 23233: Remove use of AllowItemsOnHoldCheckout from C4::Items::GetItemsInfo <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f4746340c1bf1d6408aedae93d713f49760e1279> 11:10 huginn News from kohagit: Bug 23233: Remove use of AllowItemsOnHoldCheckout from Koha::Item::has_pending_hold... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f5435839263c31ef1c29e54f244a98ef7cce812e> 11:10 huginn News from kohagit: Bug 23233: AllowItemsOnHoldCheckout is misnamed and does not indicate it is for SIP... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=50bb8e96f10638278dcec9a8eebf52c7f74209f2> 11:13 koha-jenkins Project Koha_Master_D9_My8 build #42: STILL FAILING in 1 min 47 sec: https://jenkins.koha-community.org/job/Koha_Master_D9_My8/42/ 11:19 Joubu ashimema[m]: ^ oops, there were twice the --force-recreate flag. The docker-compose up command was failing. Fixed and new build in the pipe! 11:21 ashimema[m] hehe 11:21 ashimema[m] thanks 11:24 ashimema[m] oooh.. someone QAing like mad in the last few minutes :) 11:24 ashimema[m] kidclamp++ 11:24 ashimema[m] joubu++ 11:25 ashimema[m] * Joubu++ 11:28 kohaputti has anyone else noticed that /home/koha/misc4dev/create_superlibrarian.pl only sets empty password nowadays? There was some changes to setting patron password lately so I'm guessing this might be a regression (or then something is wrong with my environment (kohadevbox)) 11:29 kohaputti I'm using the latest master version 11:29 ashimema[m] ooh.. there could be 11:29 ashimema[m] we had to fix a similar issue in misc4dev 11:30 Joubu See the email I sent to koha-devel 11:30 ashimema[m] if the script uses store directly for changing password then it's wrong 11:30 ashimema[m] ah.. 11:30 ashimema[m] no.. you we talking about misc4dev 11:30 ashimema[m] my bad 11:30 ashimema[m] yup.. see Joubu's email 11:31 kohaputti thanks :) 11:41 koha-jenkins Yippee, build fixed! 11:41 wahanui Congratulations! 11:41 koha-jenkins Project Koha_Master_U18 build #506: FIXED in 47 min: https://jenkins.koha-community.org/job/Koha_Master_U18/506/ 11:52 koha-jenkins Project Koha_Master_D9_MDB_Latest build #11: UNSTABLE in 38 min: https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/11/ 11:52 koha-jenkins Project Koha_Master_D8 build #563: UNSTABLE in 38 min: https://jenkins.koha-community.org/job/Koha_Master_D8/563/ 12:26 koha-jenkins Project Koha_Master_D9 build #1032: UNSTABLE in 44 min: https://jenkins.koha-community.org/job/Koha_Master_D9/1032/ 12:31 koha-jenkins Project Koha_Master_D9_My8 build #43: NOW UNSTABLE in 39 min: https://jenkins.koha-community.org/job/Koha_Master_D9_My8/43/ 12:46 koha-jenkins Project Koha_Master_U18 build #507: UNSTABLE in 53 min: https://jenkins.koha-community.org/job/Koha_Master_U18/507/ 12:57 tcohen morning all 14:07 caroline_catlady hi everyone! 14:24 wizzyrea hi 14:24 caroline_catlady hi wizzyrea! 14:24 ashimema[m] wizzyrea, were you intending on doing a final release of 18.05 ? 14:37 kohaputti About bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22613 – there is already the /checkouts endpoint where you can search checkouts with borrowernumber and now there would be introduced a new endpoint with the same functionality but under the /patrons/<id>/checkouts endpoint. It is a tiny bit harder to keep up-to-date both of the end points. So just wondering if this topic has been discussed already and wha 14:37 kohaputti t was the outcome. 14:37 huginn Bug 22613: enhancement, P5 - low, ---, josef.moravec, Failed QA , Add /patrons/patron_id/checkouts endpoints 14:37 ashimema[m] tcohen thoughts ^ 14:38 ashimema[m] When I've done similar in the past in other project I've just aliased one route to the other.. 14:38 kohaputti ashimema[m], example of alias? 14:38 ashimema[m] so in effect only had one code path to really maintain 14:38 kohaputti aah, other project, sorry read too fast.. 14:39 ashimema[m] I'll see if I can dig it out.. it was also based on openapi and mojo ;) 14:39 kohaputti having an alias would be ideal here I think 14:39 tcohen in my opinion, whose should be aliases 14:40 tcohen I think $c->validation->param('patron_id') will read the same value if it is in the PATH or as a query param 14:40 tcohen so the code should be the same 14:40 ashimema[m] indeed 14:40 ashimema[m] it should 14:41 kohaputti so it is possible to just change the $ref to the old definition? 14:44 kohaputti I mean "$ref": "paths/checkouts.json#/~1patrons~1{patron_id}~1checkouts" would be something like $ref": "paths/checkouts.json#/~1checkouts~1{patron_id} 14:46 ashimema[m] pass 14:50 tcohen ~1checkouts~1{patron_id} looks wrong, it should be a checkout_id on the path definition 14:50 tcohen I think you mean a request like GET /checkouts?patron_id=XX 14:50 tcohen where patron_id is just a query param 14:50 kohaputti yes, I mean like that 14:50 tcohen ok 14:50 tcohen but you don't put that in the path 14:51 tcohen that goes in the parameters: [] definition of the /checkouts route 14:51 tcohen as { name: patron_id, type: string, in: query, … } 14:51 tcohen but that's already defined 14:51 kohaputti yes, but we need to now translate /patrons/<id>/checkouts to /checkouts?patron_id=<id> 14:52 tcohen ah no 14:52 tcohen I'm surprised 14:52 tcohen just add the patron_id query param as I mentioned, to the /checkouts path 14:52 ashimema[m] I think I left it in the spec and use a perl goto or something like that to translate it 14:53 tcohen <id> will be called 'patron_id' in both cases (in the specs) 14:53 tcohen so I would try that first 14:58 ashimema[m] had a go at bug 22359 if you wanted to give it a try cait ? 14:58 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22359 normal, P5 - low, ---, martin.renvoize, NEW , Improve usability of 'change calculation' (bug 11373) 14:59 cait it's on my list, but not today i am afraid 15:00 ashimema[m] okies 15:06 Joubu ashimema[m]: follow-up on bug 23233 15:06 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23233 minor, P5 - low, ---, kyle, Pushed to master , AllowItemsOnHoldCheckout is misnamed and should only work for for SIP-based checkouts 15:06 kohaputti tcohen, hmm, I'm not sure you understood what the problem is or maybe I don't understand your answer. So we want to add /patrons/<patron_id>/checkouts as an alias for /checkouts?patron_id=xxx. The endpoint /checkouts?patron_id=xxx is implemented already so we just need the alias now 15:08 kohaputti tcohen, if you have a solution for this can you comment with an example solution to the bug report? 15:12 kohaputti there doesn't appear to be any aliases in the current Koha REST API 15:14 tcohen by alias I mean to call the same controller method 15:14 ashimema[m] +1 15:14 ashimema[m] I meant the same 15:14 tcohen BUT 15:15 tcohen in /checkouts, there isn't a patron_id query param defined, so it would need to be added, and the controller should deal with it 15:16 kohaputti tcohen, patron_id is defined: "$ref": "../parameters.json#/patron_id_qp" 15:17 kohaputti so we are left with the part "controller should deal with it" 15:17 kohaputti soo we would have to make some code to do automatically aliases? 15:18 tcohen let me re-read 15:19 tcohen the controller code 15:25 kohaputti tcohen, and check the suggested patch too if you haven't already. I'm heading out soon so will probably read any replies to this tomorrow, see ya! 15:26 tcohen cya! 16:28 reiveune bye 16:35 oleonard Hi #koha 16:36 kidclamp hi oleonard 16:36 wahanui hi oleopard 16:36 eythian hi oleopard 17:22 tallerjoy good morning! 17:22 oleonard Oh no Joy is shrinking 17:22 talljoy happens with age. :( 17:22 talljoy lol 17:23 talljoy i do feel that way when i stand next to my kids. 17:41 wizzyrea hi 17:41 oleonard Hi wizzyrea 17:42 wizzyrea how is everybody 17:48 oleonard Quiet I guess. 18:57 vfernandes any plan to solve point 3 "Right now, the _background functions call straight through to the functions they're referring to. The intention is that they might fork and do it in the background, or they might send it to a daemon, or something like that. They need to get to the point where they can be smart, non-blocking, and can handle errors by deferring the indexing." ? 19:00 vfernandes bulk operations (item/record batch modification, inventory, etc.) are blocking Koha when the number of records/items is high 19:30 corilynn is there anyway to know if another cataloger has a record open? 19:30 pastebot "oleonard" at 127.0.0.1 pasted "Does id=2 refer to the biblionumber?" (17 lines) at http://paste.koha-community.org/18759 19:34 oleonard corilynn: I thought there was an open bug for that issue but I can't find it now 19:35 corilynn https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23705 19:35 huginn Bug 23705: enhancement, P5 - low, ---, koha-bugs, NEW , Add a syspref to enable record locking, so that when one record is opened to be edited, it's read only for other users 19:36 corilynn fairly new 19:37 oleonard Is that bug why you asked? 19:37 corilynn no, we're running into this problem daily on one of our projects 19:39 corilynn I'm reading through the senarios, but even a warning about the record being open in another instance might be helpful 19:40 oleonard corilynn: I'm not aware of a quick fix for that, but I'm not the best person to ask 19:46 corilynn just have the institutional knowledge that it existed, eh, oleonard? 19:47 oleonard I read lots of bug reports 19:47 corilynn Bug 22259 was labeled as the duplicate, but it has more info 19:47 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22259 normal, P5 - low, ---, koha-bugs, RESOLVED DUPLICATE, If two catalogers work on same record, one overwrites the other 19:48 oleonard Feel free to copy the additional info into the other report 19:50 rangi morning 19:52 oleonard Hi rangi 20:01 oleonard Bye rangi :P 20:40 hayley @later tell tcohen hi, have I been added to the email contacts for failing jobs with Jenkins? :) 20:40 huginn hayley: The operation succeeded. 21:09 huginn News from kohagit: Bug 24245: rename self reg confirm page body id <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=aea4407ef8728ec3cf130f3f910e01f31c96de47> 21:09 huginn News from kohagit: Bug 24085: Make print and cancel-hold buttons instead of submit <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=568cbb3a0e698c2b263bc27ead9cacb3fcd170ea> 21:09 huginn News from kohagit: Bug 24235: DUEDGST not sent if PREDUDGST checkbox is off <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f497008d7f7e029909f4a801ba8fa41482e03fdf> 21:09 huginn News from kohagit: Bug 24240: Move form closing tag outside of conditional <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=92d7749640172b7fc0fe815ee9edcd4e225b3ecd> 21:09 huginn News from kohagit: Bug 22381: Change wording on Calendar-related system <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e6af0471c281accd5dcf6205d5684712d835b050> 21:17 koha-jenkins Project Koha_18.11_D8 build #194: STILL UNSTABLE in 27 min: https://jenkins.koha-community.org/job/Koha_18.11_D8/194/ 21:20 ashimema[m] hayley: I've added you're email into the cc list for jenkins failures on the 18.11 branch now :) 21:20 koha-jenkins Project Koha_18.11_D9 build #195: STILL UNSTABLE in 31 min: https://jenkins.koha-community.org/job/Koha_18.11_D9/195/ 21:20 ashimema[m] @later tell tcohen I've added hayley to the cc lists for 18.11 builds so you don't have to :) 21:20 huginn ashimema[m]: The operation succeeded. 21:25 hayley thank you ashimema[m]! now to fix this thing haha 21:25 koha-jenkins Project Koha_18.11_U18 build #185: STILL UNSTABLE in 39 min: https://jenkins.koha-community.org/job/Koha_18.11_U18/185/ 21:25 ashimema[m] Good luck.. shout if you need me 21:26 hayley thank you! 21:48 koha-jenkins Project Koha_19.11_D8 build #5: STILL UNSTABLE in 31 min: https://jenkins.koha-community.org/job/Koha_19.11_D8/5/ 21:49 hayley apologies for all the build messages, false positive in Auth_with_shibboleth test that will need to be fixed 21:50 cait all good :) 21:52 lukeG hayley, if you push 24145 and 24199 to your build it should fix those 21:53 bag !bang 21:53 AnnaBoten There is no hunt right now! You can start a hunt with the 'start' command 21:53 hayley thank you lukeG! 21:54 cait hey bag 21:59 lukeG cait: do we still want bz23713 in 18.11.x? 21:59 koha-jenkins Project Koha_19.11_D9 build #6: STILL UNSTABLE in 39 min: https://jenkins.koha-community.org/job/Koha_19.11_D9/6/ 22:00 cait bug 23713 22:00 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23713 critical, P5 - low, ---, oleonard, RESOLVED FIXED, Subscription add form broken for translations 22:00 cait actually no.... the problem was caused by mana, which is not in 18.11 22:00 hayley sweet! :) 22:00 cait so my first comment was a mistake - sorry for the noise 22:01 lukeG no problem! just making sure! 22:03 ashimema[m] There's a failure on master too at the minute.. also a false positive I believe.. need to update the test for a reworded syspref I believe.. will take a look first thing in the morning.. 22:14 koha-jenkins Project Koha_19.11_U18 build #6: STILL UNSTABLE in 49 min: https://jenkins.koha-community.org/job/Koha_19.11_U18/6/ 22:33 koha-jenkins Project Koha_Master_D9 build #1033: STILL UNSTABLE in 44 min: https://jenkins.koha-community.org/job/Koha_Master_D9/1033/ 22:39 koha-jenkins Project Koha_Master_D9_My8 build #44: STILL UNSTABLE in 39 min: https://jenkins.koha-community.org/job/Koha_Master_D9_My8/44/ 22:49 koha-jenkins Project Koha_Master_D8 build #564: STILL UNSTABLE in 35 min: https://jenkins.koha-community.org/job/Koha_Master_D8/564/ 23:18 koha-jenkins Project Koha_Master_D9_MDB_Latest build #12: STILL UNSTABLE in 44 min: https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/12/ 23:21 koha-jenkins Project Koha_Master_U18 build #508: STILL UNSTABLE in 41 min: https://jenkins.koha-community.org/job/Koha_Master_U18/508/ 23:40 koha-jenkins Project Koha_19.05_U18 build #72: STILL UNSTABLE in 50 min: https://jenkins.koha-community.org/job/Koha_19.05_U18/72/ 23:47 koha-jenkins Project Koha_19.05_D8 build #71: UNSTABLE in 29 min: https://jenkins.koha-community.org/job/Koha_19.05_D8/71/ 23:56 koha-jenkins Project Koha_19.05_D9 build #73: UNSTABLE in 35 min: https://jenkins.koha-community.org/job/Koha_19.05_D9/73/