Time  Nick          Message
00:13 oleonard      Why might I get a "MySQL server has gone away" error when importing database dump SQL file?
00:14 oleonard      Seeing in in koha-testing-docker, never got it before with kohadevbox
00:14 * oleonard    wonders if it is another strict mode thing
00:15 oleonard      Oh, looks like it doesn't like the image data
00:15 * oleonard    jettisons it
00:18 hayley        if it doesn't bring you joy, let it go
00:18 hayley        :P
00:20 oleonard      Me while testing a web cam feature: https://zivotdesign.com/p/view.php?p=15828491947695
00:21 hayley        haha
00:54 corilynn      ha
01:04 oleonard      Hi corilynn
06:40 marcelr       hi #koha
07:28 * magnuse     waves
07:36 reiveune      hello
07:38 marcelr       hi reiveune
08:26 marcelr       ashimema[m]: around?
08:30 ashimema[m]   mornin'
08:30 eythian       hi
08:32 ashimema[m]   how can I help marcelr
08:33 marcelr       bug 24756
08:33 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24756 normal, P5 - low, ---, m.de.rooy, Needs Signoff , Occasional D8 and U18 failures for Koha/XSLT/Security.t
08:33 marcelr       im interested to see if jenkins handles this one better?
08:34 marcelr       Cant reproduce the problem myself on D8 ;)
08:39 ashimema[m]   interesting..
08:39 ashimema[m]   worth a try
08:40 ashimema[m]   as it's purely in tests I tihnk we can safely push that as is and watch for the outcome :)
08:40 marcelr       maybe the easiest now
08:41 marcelr       and if it is not consistent, remove that part altoghether
08:41 ashimema[m]   It's really weird isn't it..
08:41 ashimema[m]   I hate randomly failing tests..
08:41 marcelr       yes
08:44 ashimema[m]   pushed
08:44 huginn        News from kohagit: Bug 24756: Fix D8 and U18 failures for Koha/XSLT/Security.t <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=2c8a1176041f5ab13c68f42ff585332b11a07339>
08:44 * ashimema[m] crosses fingers
08:44 marcelr       ok lets see !
08:45 marcelr       hoping that U18 want to cooperate too
08:49 ashimema[m]   fancy an easy QA?
08:50 ashimema[m]   bug 24739 should be obvious :)
08:50 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24739 normal, P5 - low, ---, dcook, Signed Off , Buster ships with Net::Netmask 1.9104 which supports IPv6
08:50 ashimema[m]   David's done a great little investigation and detailed it in a comment on the bug.. takes all the hard work out of it :)
08:51 * ashimema[m] feels really positive about things this morning :)
08:52 marcelr       can have a look, not sure if it is easy btw :)
08:52 ashimema[m]   though I'm sure the NQA queue was below 100 only a day or two ago... SO must be going strong at the moment to see it back up to 127
08:52 marcelr       that is high
08:53 ashimema[m]   I suppose it's perspective.. if you're not familiar with the networking it could be challenging... I can have khall take a look if you'd rather.. i know it falls in his expertise area
08:54 marcelr       no problem i check
08:54 marcelr       just responding to easy
08:55 * ashimema[m] likes graphs.. I do like the Pushed graphs we have on the dashboard now.. but would love to also have graphs for the various queue.. spot trends :)
09:18 koha-jenkins  Project Koha_Master_D10 build #97: STILL UNSTABLE in 33 min: https://jenkins.koha-community.org/job/Koha_Master_D10/97/
09:21 marcelr       ashimema[m]: building a buster container now
09:22 marcelr       built a jessie one this morning, so give it a try :)
09:23 marcelr       could have tried cpanm of course too
09:25 ashimema[m]   ?
09:25 ashimema[m]   with koha-testing-docker you mean?
09:25 ashimema[m]   I'm really pleased with how well that works for me at the momen
09:25 marcelr       hmm my own docker container
09:25 ashimema[m]   * I'm really pleased with how well that works for me at the moment
09:25 ashimema[m]   oh cool.. even better
09:26 ashimema[m]   I've not got that clever yet ;)
09:26 marcelr       im still using docker only and not compose
09:26 marcelr       have to do that some time
09:26 ashimema[m]   sooo many things still to learn and soo little time :(
09:26 marcelr       right
09:26 magnuse       right
09:26 ashimema[m]   haha.. it's always the way
09:26 * magnuse     tries to get his head around selinux
09:26 ashimema[m]   my list of pet projects only ever grows
09:27 marcelr       ashimema[m]: D10 failed but not on Security.t !
09:27 ashimema[m]   ah.. selinux.. one day I understood that.. but alas my knowledge there has been cast asside to make room for something else
09:27 marcelr       magnuse: selinux is on my todo list still
09:27 magnuse       lulz
09:28 magnuse       i have a customer requiring it...
09:28 ashimema[m]   D10 is expected to fail at the moment.. we're still working through the last few failures :)
09:28 marcelr       i had it once
09:28 ashimema[m]   but at least it now builds :)
09:28 marcelr       before stepping to debian
09:28 ashimema[m]   which is a massive improvement on only a few days ago
09:28 marcelr       ok
09:28 magnuse       there is still misc/bin/set-selinux-labels.sh
09:28 ashimema[m]   The RealIP failures are that bug I pointed you to earlier :)
09:29 marcelr       in about 10 mins we know about U18
09:29 ashimema[m]   the Koha::Patrons one's are new.. interesting
09:29 marcelr       i saw them passing by earlier this morning
09:29 ashimema[m]   the SearchEngine one I think may be a newer ES version issue. need to get kidclamp to investigate that one for me
09:29 marcelr       magnuse: yeah it stems from 3-4 years ago
09:31 ashimema[m]   I can't remember now what debian/ubuntu went for instead of selinux
09:31 ashimema[m]   AppArmor.. that's the one
09:35 koha-jenkins  Project Koha_Master_U18 build #642: STILL UNSTABLE in 50 min: https://jenkins.koha-community.org/job/Koha_Master_U18/642/
09:36 paxed         i had to set lxc.apparmor.profile = unconfined on d10 to get it even working
09:36 paxed         it == lxc conts
09:40 marcelr       ashimema[m]: hmm that wasnt the U18 response we were looking for
09:41 marcelr       i should know how the warning looks like in U18
09:44 koha-jenkins  Project Koha_Master_D9_My8 build #177: UNSTABLE in 57 min: https://jenkins.koha-community.org/job/Koha_Master_D9_My8/177/
09:45 koha-jenkins  Project Koha_Master_D8 build #720: UNSTABLE in 27 min: https://jenkins.koha-community.org/job/Koha_Master_D8/720/
09:46 marcelr       D8 passes for XSLT
09:49 * marcelr     trying an U18 build anyway
09:57 marcelr       alas no U18 build
10:23 koha-jenkins  Project Koha_Master_D9_MDB_Latest build #153: UNSTABLE in 48 min: https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/153/
10:25 marcelr       D9 failed ?
10:27 ashimema[m]   wow..
10:27 ashimema[m]   they all failed
10:27 ashimema[m]   all on that Patrons test
10:28 marcelr       but XSLT is a problem too ?
10:28 ashimema[m]   that's really odd
10:28 marcelr       still not sure whats happening there
10:28 ashimema[m]   D9 MDB failed the XSLT one
10:29 ashimema[m]   still seems to be completely random :(
10:29 marcelr       yeah i added a skip line for U18 but that is useless
10:29 ashimema[m]   think the patrons one must be a datetime thing
10:29 marcelr       probably
10:30 marcelr       datetime stuff is a bit sensitive
10:30 ashimema[m]   leap year this year isn't it
10:30 marcelr       right
10:30 marcelr       thats probably it
10:30 marcelr       dont run tests tomorrow :)
10:30 ashimema[m]   well.. i think we're seeing the failure today for it.. not sure wh
10:30 ashimema[m]   * well.. i think we're seeing the failure today for it.. not sure why
10:31 ashimema[m]   I've fixed loads of those sorts of errors of late
10:31 ashimema[m]   last cycle we had a whole bunch that Joubu and I worked through
10:31 ashimema[m]   seems we still have a few
10:31 ashimema[m]   will take a look later
10:31 marcelr       i will still think about that xslt one
10:32 marcelr       we're looking in the wrong direction somehow
10:32 ashimema[m]   indeed
10:33 Joubu         Patron's tests are failing because of leap day tomorrow, for sure
10:33 ashimema[m]   shout if you'd like me to do some digging of my own
10:33 ashimema[m]   just trying to catch up with a migration at the minute ;)
10:33 marcelr       np
10:33 ashimema[m]   I've not investigated yet Joubu, but yeah, that's my hunch
10:34 Joubu         I do not have time right now, could someone open a bug report about it (and assign it to me)? I will take a look next week.
10:35 ashimema[m]   sure
10:38 ashimema[m]   bug 24757
10:38 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24757 enhancement, P5 - low, ---, jonathan.druart, NEW , t/db_dependent/Koha/Patrons.t get_age fails on February 28 in a Leap Year
10:38 koha-jenkins  Project Koha_Master_D9 build #1180: UNSTABLE in 53 min: https://jenkins.koha-community.org/job/Koha_Master_D9/1180/
10:39 marcelr       ashimema[m]: the regular D9 did not fail on xslt ;)
10:39 ashimema[m]   :)
10:39 ashimema[m]   good news :)
10:39 marcelr       hmm
11:24 marcelr       ashimema[m]: yet another call for 24756 ;)
11:28 ashimema[m]   so you've replaced the tempfile by a xslt string?
11:29 marcelr       yeah it is just another parameter of transform
11:29 marcelr       the parameter file or code is tested somewhere else
11:29 ashimema[m]   looks reasonable
11:29 huginn        News from kohagit: Bug 24756: Fix failing tests by removing temporary filenames <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e1ea21415ea3457bcf855485907b59e0b5b4db42>
11:29 * ashimema[m] crosses fingers
11:30 marcelr       only weird that File::Temp gives back the same filename after about 5 calls
11:30 ashimema[m]   strange indeed
11:31 marcelr       but i decided not to test file::temp there
11:50 magnuse       thou shalt never let thine temp files exceed 5 in number
12:02 koha-jenkins  Project Koha_Master_D10 build #98: STILL UNSTABLE in 32 min: https://jenkins.koha-community.org/job/Koha_Master_D10/98/
12:03 marcelr       no xslt failure !
12:19 koha-jenkins  Project Koha_Master_U18 build #643: STILL UNSTABLE in 49 min: https://jenkins.koha-community.org/job/Koha_Master_U18/643/
12:28 koha-jenkins  Project Koha_Master_D9_My8 build #178: STILL UNSTABLE in 56 min: https://jenkins.koha-community.org/job/Koha_Master_D9_My8/178/
12:31 koha-jenkins  Project Koha_Master_D8 build #721: STILL UNSTABLE in 28 min: https://jenkins.koha-community.org/job/Koha_Master_D8/721/
12:36 oleonard      Hi #koha
12:58 koha-jenkins  Project Koha_Master_D8 build #722: STILL UNSTABLE in 27 min: https://jenkins.koha-community.org/job/Koha_Master_D8/722/
13:07 koha-jenkins  Project Koha_Master_D9_MDB_Latest build #154: STILL UNSTABLE in 48 min: https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/154/
13:21 koha-jenkins  Project Koha_Master_D9 build #1181: STILL UNSTABLE in 52 min: https://jenkins.koha-community.org/job/Koha_Master_D9/1181/
14:13 oleonard      it's Friday, so why not beta-test my patch for Bug 6815?
14:13 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6815 enhancement, P5 - low, ---, mtompset, ASSIGNED , Capture member photo via webcam
14:20 oleonard      Joubu around?
14:45 ashimema[m]   would if I had a webcam ;)
14:47 oleonard      ashimema[m]: Yeah my work on it a little sporadic because of that issue. My main work computer doesn't have one either.
14:47 * ashimema[m] remembers his laptop has one built in.. don't think he's ever actually checked it works though
14:58 ashimema[m]   we don't half have some dopy code..
14:58 oleonard      quote add that one
14:58 ashimema[m]   lol
14:58 ashimema[m]   no idea how
15:05 oleonard      ashimema[m]: Your comment reminds me of the 12-year-old FIXME I saw today :|
15:05 Joubu         oleonard: yes
15:05 oleonard      Hi Joubu. I was unable to reproduce the problem you described in your last comment on Bug 13327 and I wonder if it's an issue with which MARC tags are being shown
15:05 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13327 normal, P5 - low, ---, oleonard, Failed QA , OPACPopupAuthorsSearch doesn't work with XSLT views
15:06 oleonard      Could you tell me where the "additional author" information is coming from when it's not working for you?
15:06 Joubu         oleonard: did you check with biblio 15 with sample data?
15:07 oleonard      No I didn't realize that was the data you were working with. I don't usually use the sample data
15:07 Joubu         are not you using the docker container now?
15:08 oleonard      I am, with my own data
15:08 huginn        News from kohagit: Bug 24753: Change Koha/Middlware to Koha/Middleware in test name <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=cad8540cbf7d4b3469568e82b4b8d9384a09df8d>
15:08 huginn        News from kohagit: Bug 24739: Perform IPv6 tests only if Net::Netmask is correct version <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c497d4f5a6af3648127ab14ef6e2e970c8258a64>
15:08 huginn        News from kohagit: Bug 24739: Skip tests when IPv6 support is found <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d33c2506d5173f8243adf39566a67b6b8ab096b7>
15:09 oleonard      Joubu: If you have the sample data loaded now could you take a look?
15:10 Joubu         oleonard: ok, maybe you fixed a bug actually
15:11 Joubu         on master, without xslt and author pref on, I see: https://snipboard.io/YTMfvA.jpg
15:11 Joubu         so there is only 1, maybe you fixed that, it's not needed to display the popup if only 1 checkbox?
15:11 oleonard      I fixed a bug? Don't sound so surprised ;)
15:11 ashimema[m]   lol
15:12 jim           hello
15:15 oleonard      Hi jim
15:16 oleonard      Joubu: Yes, if there is only one the popup should not display
15:21 jim           when i search with barcode it retrieves more than one
15:21 jim           any body else faced similar problem
15:27 oleonard      jim: A keyword search by barcode will return more than one because it does a "fuzzy" search
15:27 oleonard      That's assuming you're talking about a catalog search
15:35 jim           yes catalog search within staff client
15:35 jim           when specifying a barcode it should give me that particular record
15:43 koha-jenkins  Project Koha_Master_D9_MDB_Latest build #155: STILL UNSTABLE in 34 min: https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/155/
15:43 * oleonard    wonders if jim will be back to learn about item search
15:46 koha-jenkins  Project Koha_Master_D8 build #723: STILL UNSTABLE in 38 min: https://jenkins.koha-community.org/job/Koha_Master_D8/723/
15:56 jim           hello
15:57 koha-jenkins  Project Koha_Master_D9 build #1182: STILL UNSTABLE in 47 min: https://jenkins.koha-community.org/job/Koha_Master_D9/1182/
16:09 reiveune      bye
16:12 oleonard      jim: You can use item search instead
16:18 koha-jenkins  Project Koha_Master_U18 build #644: STILL UNSTABLE in 35 min: https://jenkins.koha-community.org/job/Koha_Master_U18/644/
16:21 jim           item search you mean by title
16:22 oleonard      jim: I mean the search function specifically for items: /cgi-bin/koha/catalogue/itemsearch.pl
16:24 jim           ok
16:27 Marie-Luce    Hi
16:29 oleonard      Hi Marie-Luce
16:29 Marie-Luce    Is anyone familar with the restricted item status 952$5?
16:29 jim           hi Marie
16:30 jim           when importing how to fetch withdrawn book status from excel
16:32 Marie-Luce    I was thinking in terms of circulation, would it prevent checkout for certain patron categories?
16:34 Marie-Luce    sorry, I may have interrupted a conversation here
16:34 oleonard      Marie-Luce: It looks like the restricted status is limited in its affect on circulation policy based on this comment: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10591#c2
16:34 huginn        Bug 10591: normal, P5 - low, ---, koha-bugs, In Discussion , Why do we allow holds on restricted items (952$5=Use restrictions)? Place a hold for reference?
16:36 koha-jenkins  Project Koha_Master_D10 build #99: STILL UNSTABLE in 50 min: https://jenkins.koha-community.org/job/Koha_Master_D10/99/
16:37 Marie-Luce    Thanks oleonard for this information
16:38 oleonard      jim I don't understand your question
16:39 Marie-Luce    So, the restricted status is not a good way to prevent some patron categories to borrow an item.
16:40 oleonard      Marie-Luce: No, for that I think you would need to define a circulation rule and use a combination of patron category and item type.
16:40 Marie-Luce    It makes sense.
16:41 Marie-Luce    oleonard: thank you again form your help
16:41 oleonard      :)
16:41 Marie-Luce    :)
16:47 koha-jenkins  Project Koha_Master_D9_My8 build #179: STILL UNSTABLE in 50 min: https://jenkins.koha-community.org/job/Koha_Master_D9_My8/179/
16:51 oleonard      kidclamp: Bug 23753
16:51 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23753 normal, P5 - low, ---, oleonard, Needs Signoff , Add missing humanMsg library to pages using background job JavaScript
16:59 kidclamp      oleonard++
17:02 jim           i am taking about importing from excel to koha records
17:03 oleonard      jim: You'll have to convert your excel data to MARC in order to import it
17:13 tcohen        !bang
17:13 AnnaBoten     There is no hunt right now! You can start a hunt with the 'start' command
17:14 tcohen        jim: take a look at this plugin ;-) https://github.com/bywatersolutions/koha-plugin-csv2marc
17:52 jim           I imported mrc file
17:52 jim           that means converting the file to MARC
17:52 jim           but it ddin't fetch the withdrawal status of my records
18:31 koha-jenkins  Project Koha_Master_D10_Deps build #5: NOW UNSTABLE in 47 min: https://jenkins.koha-community.org/job/Koha_Master_D10_Deps/5/
18:52 mwr           Koha LDAP question: What ports are used? Just 389 for ldap:// and 636 for ldaps://? I need to forward the correct ports on my firewall.
19:06 davidnind     mwr: I don't really know anything about LDAP or setting it up, but it would be what is configured in the koha-conf.xml settings file (see https://bywatersolutions.com/education/koha-ldap https://wiki.koha-community.org/wiki/Ldap_testing and https://openschoolsolutions.org/koha-ldap-setup/ )
19:08 davidnind     mwr: See also the recent post to the mailing list if you are using Microsoft's active directory https://lists.katipo.co.nz/pipermail/koha/2020-February/054309.html and https://lists.katipo.co.nz/pipermail/koha/2020-February/054292.html
19:14 mwr           davidnind: Thank you, I'll read up on it.