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/