IRC log for #koha, 2019-12-16

All times shown according to UTC.

Time S Nick Message
00:01 khall_ joined #koha
00:10 khall_ joined #koha
00:13 urra joined #koha
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")
00:19 khall_ joined #koha
00:30 inlibro joined #koha
01:00 mtj hi urra[m], that error usually means that the database is not running...
01:00 mtj[…]onnection-issues/
01:04 mtj also,,you shouldnt need to touch any database config files to install Koha
01:05 mtj https://wiki.koha-community.or[…]ki/Koha_on_Debian
01:30 inlibro joined #koha
02:21 alexbuckley joined #koha
02:24 dcook joined #koha
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:30 inlibro joined #koha
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..
03:30 inlibro joined #koha
04:30 inlibro joined #koha
05:30 inlibro joined #koha
06:04 chris1 joined #koha
06:30 calire joined #koha
06:31 inlibro joined #koha
06:35 cait joined #koha
06:40 fridolin joined #koha
06:55 cait mtj++ :)
07:31 inlibro joined #koha
07:49 reiveune joined #koha
07:49 reiveune hello
07:49 wahanui bonjour, reiveune
07:49 magnuse mtj: well, there is the autoincrement-fix
07:49 magnuse \o/
07:50 paul_p joined #koha
07:55 marcelr joined #koha
07:55 marcelr hi #koha
07:58 chris2 joined #koha
08:00 calire morning #koha
08:01 magnuse bonjour calire marcelr
08:03 alex_a joined #koha
08:04 alex_a Bonjour
08:05 calire hey magnuse
08:06 ashimema[m] mornin' #koha
08:07 cait joined #koha
08:24 andreashm joined #koha
08:31 inlibro joined #koha
08:34 sophie_m joined #koha
08:40 sophie_m joined #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[…]_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[…]_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:54 andreashm joined #koha
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]
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 ;)
09:27 andreashm joined #koha
09:31 inlibro joined #koha
09:37 JesseM_ joined #koha
09:38 chris3 joined #koha
09:40 greenjimll joined #koha
09:59 vfernandes joined #koha
10:11 cait Susi, bist du heute zum letzten Mal da?
10:11 cait wrong chat
10:12 cait please ignore
10:16 andreashm joined #koha
10:27 kohaputti Joubu, https://bugs.koha-community.or[…]_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
10:31 inlibro joined #koha
10:36 kathryn joined #koha
11:10 huginn News from kohagit: Bug 23233: DBRev <[…]7c83273d22e536376>
11:10 huginn News from kohagit: Bug 24241: (bug 23049 follow-up) Add description for manage_accounts <[…]22998b8c3a5a4cd07>
11:10 huginn News from kohagit: Bug 23233: (follow-up) Correct test description <[…]6ced6b1813368c83e>
11:10 huginn News from kohagit: Bug 23233: (follow-up) Add description to atomic upgrade <[…]8b291afe95101c4b8>
11:10 huginn News from kohagit: Bug 23233: (follow-up) Remove accidentally left comment <[…]6f456260cb3636669>
11:10 huginn News from kohagit: Bug 23233: Remove use of AllowItemsOnHoldCheckout from C4::Items::GetItemsInfo <[…]93d713f49760e1279>
11:10 huginn News from kohagit: Bug 23233: Remove use of AllowItemsOnHoldCheckout from Koha::Item::has_pending_hold... <[…]f244a98ef7cce812e>
11:10 huginn News from kohagit: Bug 23233: AllowItemsOnHoldCheckout is misnamed and does not indicate it is for SIP... <[…]8eebf52c7f74209f2>
11:13 koha-jenkins Project Koha_Master_D9_My8 build #42: STILL FAILING in 1 min 47 sec: https://jenkins.koha-community[…]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:20 khall joined #koha
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/ 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:30 paul_p joined #koha
11:31 kohaputti thanks :)
11:32 inlibro joined #koha
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[…]a_Master_U18/506/
11:52 koha-jenkins Project Koha_Master_D9_MDB_Latest build #11: UNSTABLE in 38 min: https://jenkins.koha-community[…]D9_MDB_Latest/11/
11:52 koha-jenkins Project Koha_Master_D8 build #563: UNSTABLE in 38 min: https://jenkins.koha-community[…]ha_Master_D8/563/
11:55 andreashm joined #koha
12:02 dcook_ joined #koha
12:10 andreashm joined #koha
12:12 khall joined #koha
12:26 koha-jenkins Project Koha_Master_D9 build #1032: UNSTABLE in 44 min: https://jenkins.koha-community[…]a_Master_D9/1032/
12:31 koha-jenkins Project Koha_Master_D9_My8 build #43: NOW UNSTABLE in 39 min: https://jenkins.koha-community[…]Master_D9_My8/43/
12:32 inlibro joined #koha
12:46 koha-jenkins Project Koha_Master_U18 build #507: UNSTABLE in 53 min: https://jenkins.koha-community[…]a_Master_U18/507/
12:57 tcohen morning all
12:57 andreashm joined #koha
13:07 khall joined #koha
13:32 inlibro joined #koha
13:40 wizzyrea joined #koha
13:44 khall joined #koha
14:00 andreashm joined #koha
14:07 caroline_catlady joined #koha
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:29 Marie-Luce joined #koha
14:30 Dyrcona joined #koha
14:32 inlibro joined #koha
14:37 kohaputti About bug https://bugs.koha-community.or[…]_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#/~1patr​ons~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[…]_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[…]_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:10 alex_a_ joined #koha
15:11 calire left #koha
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!
15:32 inlibro joined #koha
15:49 JesseM joined #koha
16:04 fridolin joined #koha
16:16 cait left #koha
16:19 khall_ joined #koha
16:25 fridolin left #koha
16:28 reiveune bye
16:28 reiveune left #koha
16:32 inlibro joined #koha
16:35 oleonard-away joined #koha
16:35 oleonard Hi #koha
16:36 kidclamp hi oleonard
16:36 wahanui hi oleopard
16:36 eythian hi oleopard
16:43 khall joined #koha
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:33 inlibro joined #koha
17:41 wizzyrea hi
17:41 oleonard Hi wizzyrea
17:42 wizzyrea how is everybody
17:48 oleonard Quiet I guess.
17:52 cait joined #koha
18:17 corilynn joined #koha
18:33 inlibro joined #koha
18:51 lukeG joined #koha
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:03 kathryn joined #koha
19:04 andreashm joined #koha
19:30 corilynn is there anyway to know if another cataloger has a record open?
19:30 pastebot "oleonard" at pasted "Does id=2 refer to the biblionumber?" (17 lines) at
19:33 inlibro joined #koha
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.or[…]_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[…]_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:03 hayley joined #koha
20:16 aleisha joined #koha
20:33 inlibro joined #koha
20:35 lukeG joined #koha
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.
20:42 andreashm joined #koha
20:58 khall joined #koha
21:09 huginn News from kohagit: Bug 24245: rename self reg confirm page body id <[…]f910e01f31c96de47>
21:09 huginn News from kohagit: Bug 24085: Make print and cancel-hold buttons instead of submit <[…]ead9cacb3fcd170ea>
21:09 huginn News from kohagit: Bug 24235: DUEDGST not sent if PREDUDGST checkbox is off <[…]1ba8fa41482e03fdf>
21:09 huginn News from kohagit: Bug 24240: Move form closing tag outside of conditional <[…]ee9edcd4e225b3ecd>
21:09 huginn News from kohagit: Bug 22381: Change wording on Calendar-related system <[…]5d5684712d835b050>
21:17 koha-jenkins Project Koha_18.11_D8 build #194: STILL UNSTABLE in 27 min: https://jenkins.koha-community[…]oha_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[…]oha_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[…]ha_18.11_U18/185/
21:25 ashimema[m] Good luck.. shout if you need me
21:26 hayley thank you!
21:33 inlibro joined #koha
21:48 koha-jenkins Project Koha_19.11_D8 build #5: STILL UNSTABLE in 31 min: https://jenkins.koha-community[…]/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 khall joined #koha
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[…]/Koha_19.11_D9/6/
22:00 cait bug 23713
22:00 huginn Bug[…]_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:04 hayleymapley_ joined #koha
22:14 koha-jenkins Project Koha_19.11_U18 build #6: STILL UNSTABLE in 49 min: https://jenkins.koha-community[…]Koha_19.11_U18/6/
22:33 koha-jenkins Project Koha_Master_D9 build #1033: STILL UNSTABLE in 44 min: https://jenkins.koha-community[…]a_Master_D9/1033/
22:33 inlibro joined #koha
22:39 koha-jenkins Project Koha_Master_D9_My8 build #44: STILL UNSTABLE in 39 min: https://jenkins.koha-community[…]Master_D9_My8/44/
22:49 koha-jenkins Project Koha_Master_D8 build #564: STILL UNSTABLE in 35 min: https://jenkins.koha-community[…]ha_Master_D8/564/
23:18 koha-jenkins Project Koha_Master_D9_MDB_Latest build #12: STILL UNSTABLE in 44 min: https://jenkins.koha-community[…]D9_MDB_Latest/12/
23:21 koha-jenkins Project Koha_Master_U18 build #508: STILL UNSTABLE in 41 min: https://jenkins.koha-community[…]a_Master_U18/508/
23:33 lukeG1 joined #koha
23:34 inlibro joined #koha
23:40 koha-jenkins Project Koha_19.05_U18 build #72: STILL UNSTABLE in 50 min: https://jenkins.koha-community[…]oha_19.05_U18/72/
23:47 hayleymapley_ joined #koha
23:47 koha-jenkins Project Koha_19.05_D8 build #71: UNSTABLE in 29 min: https://jenkins.koha-community[…]Koha_19.05_D8/71/
23:54 khall joined #koha
23:56 koha-jenkins Project Koha_19.05_D9 build #73: UNSTABLE in 35 min: https://jenkins.koha-community[…]Koha_19.05_D9/73/

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