Time Nick Message 00:07 tcohen hi rangi 00:15 tcohen I sent a pull request on gitlab 00:15 tcohen there's still stuff to be fixed on jenkins 00:15 tcohen but at least it should point to the right place 02:15 mtj hey #koha, does anyone have root on the kc.org 'download' box? i need a quick perm change 02:15 mtj ^ rangi perhaps? 02:22 jcamins mtj: what permission do you need changed? 02:23 mtj hi jcamins.. ill pm you 02:24 jcamins mtj: whoops, don't think I can do that, sorry. 02:24 jcamins mtj: also, you have your PMs silenced. 02:27 mtj yeah, their was some message spam happening on OFTC, over the weekend 02:28 mtj the admins recommended seeting some /mode stuff, as a workaround 02:28 mtj /mode mtj -G +g 02:29 mtj ..for the logs :) 02:30 jcamins rangi: you're still needed. 02:31 mtj or wizzyrea, gmcharlt_, cheers :0) 02:32 wizzyrea mtj: rangi is afk atm, and I can't seem to get into download 02:33 mtj np wiz 02:37 wizzyrea hi what's your favourite way to drop the koha database in devbox? something with defaults-extra-file? 02:44 mtj mysql -u user -ppasswd -e ‘ drop database koha_xxx' 02:44 mtj wizzyrea: i do something like that from bash ^ 02:46 mtj ..can be handy, when mysql gets stuck loading a db sometimes 02:47 mtj sometimes a drop/create fixes the error 02:53 wizzyrea yeah, devbox users don't have the mysql root password tho 02:54 wizzyrea (this is for my interns I'm trying to find a less painful way) 02:54 wizzyrea well our interns 02:54 wizzyrea the interns. 02:54 wizzyrea I'll sort it out ;) 02:54 jcamins Can't you use koha-mysql? 02:55 wizzyrea not to drop it? 02:56 jcamins Oh, really? I thought I recalled being surprised and concerned to note that the Koha user had DROP privileges. Maybe not. 03:01 mtj hmm, DROP privs for its own db is OK tho? hey 03:01 * mtj doesnt yet know if thats actually possible with mysql 03:03 jcamins Of course it's possible. Users and databases are independent. 03:07 mtj sure, twas a silly statement 07:23 LibraryClaire morning #koha 07:30 * magnuse waves 07:42 LibraryClaire hey magnuse 07:42 magnuse kia ora BüchereiKlara 07:42 Joubu hi 07:42 LibraryClaire hi Joubu! 07:42 magnuse bonjour Joubu 07:43 eythian Hi 07:43 wahanui niihau, eythian 07:43 eythian @wunder Jordaan, ams 07:43 huginn eythian: The current temperature in Ten Kateplein, Amsterdam, Netherlands is 4.0°C (8:41 AM CET on December 06, 2016). Conditions: Mist. Humidity: 70%. Dew Point: -1.0°C. Windchill: 4.0°C. Pressure: 30.39 in 1029 hPa (Steady). 07:43 LibraryClaire @wunder Konstanz 07:44 huginn LibraryClaire: The current temperature in Mainaustraße, Konstanz, Germany is 2.3°C (8:40 AM CET on December 06, 2016). Conditions: Light Freezing Fog. Humidity: 87%. Dew Point: 0.0°C. Windchill: 2.0°C. Pressure: 30.42 in 1030 hPa (Steady). 07:44 LibraryClaire lol light freezing fog 07:44 LibraryClaire actually pretty accurate 07:48 reiveune hello 07:48 fridolin hie tehre 07:48 fridolin LibraryClaire: whouuu cooooooooold 07:49 fridolin + Freezing Fog 07:49 fridolin looks like Jack Frost is in the place 07:50 LibraryClaire hi Fridolin ^^ 07:54 alex_a hello 07:56 * LibraryClaire waves 08:47 magnuse @wunder enbo 08:47 huginn magnuse: The current temperature in Bodo, Norway is 3.0°C (9:20 AM CET on December 06, 2016). Conditions: Mostly Cloudy. Humidity: 81%. Dew Point: 0.0°C. Windchill: -3.0°C. Pressure: 30.06 in 1018 hPa (Steady). 08:49 magnuse solstice in 15 days! 08:57 AndrewIsh good morn' #koha 08:59 LibraryClaire hey AndrewIsh 09:00 AndrewIsh hi LibraryClaire 09:58 Joubu [@later tell marcelr 09:58 Joubu @later tell marcelr could you take a look at 17726 please 09:58 huginn Joubu: The operation succeeded. 09:58 Joubu better 10:40 Joubu khall: Hi! I have opened bug 17727 for the failing tests we were talking about yesterday (if ES is set) 10:40 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17727 normal, P5 - low, ---, jonathan.druart, ASSIGNED , A lot of tests fail if SearchEngine is set to Elastic 10:40 khall thanks! 10:46 eythian Joubu: https://www.youtube.com/watch?v=hGJVTV6c8P8 :) 10:49 Joubu eythian: lol 10:49 Joubu eythian: but... what is this white stuff? 10:49 eythian heh 11:15 eythian @wunder jordaan, ams 11:15 huginn eythian: The current temperature in Ten Kateplein, Amsterdam, Netherlands is 5.8°C (12:10 PM CET on December 06, 2016). Conditions: Clear. Humidity: 70%. Dew Point: 1.0°C. Windchill: 6.0°C. Pressure: 30.42 in 1030 hPa (Steady). 12:21 rsantellan good morning #koha 12:24 rsantellan I have a question about tools/calendar, when setting a holyday does it show on the OPAC somewhere? 12:50 LibraryClaire rsantellan: I don't think so, no 12:51 rsantellan LibraryClaire: on the intra is a message? 12:54 LibraryClaire I think all it does it set the closed days for the library so you can set items to not be due or charged for on those days 12:54 oleonard Hi all 12:55 LibraryClaire hi oleonard 12:55 wahanui hi olé onard 12:56 LibraryClaire rsantellan: it doesn't leave an automatic notification anywhere. 12:56 cait hi oleopard :) 12:56 cait (someone had to) 12:56 LibraryClaire wahanui let me down 12:56 wahanui LibraryClaire: what? 12:57 LibraryClaire shush you 12:57 oleonard wahanui is unpredictable 12:57 * LibraryClaire pokes wahanui 12:57 wahanui ouch! 12:57 rsantellan LibraryClaire: thanks 13:01 atheia Good day Koha :-) 13:01 LibraryClaire hi atheia :) 13:01 atheia \me waves 13:01 * atheia waves 13:02 atheia that's better :-) 13:02 LibraryClaire backwards waving 13:02 atheia We're developing a form of stockrotation (which is different from the existing rotating collections). 13:03 atheia For this I need to interface with branchtransfers — and I noticed branchtransfers does not have a primary key. 13:03 atheia My intuition would be to add a new column to branchtransfers, a simple branchtransfer_id, which would become the primary key. 13:04 atheia Does anyone know whether there is a reason why branchtransfers does not have such a column yet? 13:05 Joubu bug 14187 13:05 cait i think ther eis abug for adding a key somewhere 13:05 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14187 enhancement, P5 - low, ---, koha-bugs, In Discussion , branchtransfer needs a primary key (id) for DBIx and common sense. 13:05 cait yep 13:05 * cait waves at Joubu and atheia :) 13:06 Joubu hi! 13:06 atheia Hello cait, Joubu! 13:06 atheia Thanks for that will have a look. 13:06 oleonard Should that bug be "Needs signoff?" The last comment is a patch. 13:07 oleonard Oh, still no atomicupdate. Maybe "Failed QA" 13:07 cait Joubu: it looks like t/db_depenedent/Members.t is failing on my 16.11.x jenkins node... but it passes for me and tomas locally 13:07 cait do youhave any idea what that could be? 13:09 Joubu cait: number of tests? 13:09 cait sec, i will find the report 13:09 Joubu searchengine=ES? 13:09 cait it's here 13:09 cait https://jenkins.koha-community.org/job/Koha_16.11.x_D8/ 13:09 atheia oleonard I will adopt that bug. 13:09 cait Joubu: https://jenkins.koha-community.org/job/Koha_16.11.x_D8/lastCompletedBuild/testReport/ 13:10 cait tomas said to ingore the first one, because he forgot to set something up 13:10 cait but the Member.t ones i have no explanation for 13:10 cait the tests seem to be using the testbuilder 13:10 Joubu cait: certainly come from the data 13:11 Joubu ha wai 13:11 Joubu t 13:12 tcohen morning 13:12 LibraryClaire hi tcohen 13:12 Joubu cait: bug 17713? 13:12 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17713 normal, P5 - low, ---, jonathan.druart, Pushed to Stable , Members.t is failing randomly 13:12 magnuse ¡hola tcohen! 13:12 cait hm 13:12 cait but shouldn't that fix the problem? 13:13 Joubu yes, should 13:13 cait i pushed 17713 13:13 cait http://git.koha-community.org/gitweb/?p=koha.git;a=shortlog;h=refs/heads/16.11.x 13:13 Joubu yes but maybe jenkins is not using it yet? :-/ 13:14 cait hm it's listed in the changes for this run : https://jenkins.koha-community.org/job/Koha_16.11.x_D8/changes 13:14 Joubu yes 13:14 Joubu so it broke the tests... 13:15 Joubu will have a look later 13:15 cait thx 13:15 Joubu sorry, in the middle of 2 things already now 13:15 tcohen it fixed it in master 13:15 cait i am not sure how to track this... all green for me 13:17 daan cait: quick question on accessibility in koha staff interfaces 13:20 daan I´m helping a customer making decision about new ILS, they need the staff GUI accessible to work with screen readers. I´m having trouble finding info about if Koha is accessible as default. Can you cait or someone else please point me to some resources or help me where to start 13:20 daan The functions in focus patrons, circulation, reports/statistics 13:20 tcohen anyone has any thoughts on bug 16376? 13:20 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16376 critical, P5 - low, ---, koha-bugs, Failed QA , Koha::Calendar->is_holiday date truncation creates fatal errors for TZ America/Santiago 13:21 tcohen I was trying to write the regression tests, but not sure how to do it 13:21 tcohen Joubu: ? 13:22 Joubu tcohen: I did not get the question 13:22 tcohen my last comment on bug 16376 13:22 Joubu the code on the comment looks ok to me 13:22 Joubu yes, I read it 13:22 tcohen but the patch is fixing it somewhere else 13:23 tcohen it is makking the functions return floating tz 13:23 tcohen so it doesn't break in days_between 13:24 tcohen I don't know how to write the test 13:24 tcohen for the updated functions 13:24 Joubu testing days_between looks like the way to go 13:28 cait hi daan 13:28 daan hi cait 13:29 cait we don't have anything official and no documentation as far as I know I am afraid 13:29 cait we have been working with a library with a blind user 13:29 cait and i know that she uses circulation, checkouts and returns 13:29 cait item cataloguing 13:29 daan ok, interesting 13:29 wahanui i heard interesting was sometimes good and sometimes bad 13:29 cait I think she also uses MarcEdit and the staged tool - but not totally sure about that 13:29 cait also searching and editing borrowers 13:30 cait we've always asked them pre-update to test in the new version - I don't know all they tested 13:30 daan is it possible for me to connect to that user? 13:30 cait in the past we had to change pull downs to links - before the switch from yui to jQuery UI (hope i am right, oleonard?) 13:30 daan Do you run any wcag/wai tests? 13:30 cait well now menus and buttons all seem to work well 13:30 cait no 13:31 oleonard The switch was from YUI to Bootstrap, but I don't remember what the issue with YUI was 13:32 oleonard It may have been with menus which were generated 100% from Javascript 13:32 daan cait: "no" to connect to user or wai/wcag? 13:37 daan cait: thanks for the help. Maybe I´ll run some tests on one of the demoinstallations. bye 13:43 Joubu found too many bugs today... 13:43 magnuse Joubu: early xmas presents ;-) 13:43 Joubu I found one when trying to fix one 13:43 Joubu not sure when it will finish 13:44 magnuse will it ever? 13:44 Joubu I don't remember which one I was trying to fix, arggg 13:44 oleonard Now I know what magnuse wants for Christmas 13:44 magnuse fixed bugs ;-) 13:45 * magnuse waves in norwegian to StefanB 13:45 * oleonard watches in confusion as magnuse makes unintelligible hand gestures at StefanB 13:46 magnuse yeah, the old viking wave 13:46 LibraryClaire demo please 13:46 wahanui hmmm... demo is at http://koha-community.org/demo/ or http://wiki.koha-community.org/wiki/Koha_Demo_Databases 13:46 LibraryClaire not you wahanui! 13:51 barton good morning #koha! 13:51 oleonard Hi barton 13:52 LibraryClaire hi barton 13:52 barton is there any way to find the instance name via perl code? 13:52 tcohen barton: no 13:52 tcohen not yet 13:53 barton tcohen: I like your second answer better :-) 13:53 tcohen i have code 13:53 barton noice 13:55 magnuse LibraryClaire: something along the lines of https://www.youtube.com/watch?v=bBE6uT1QE6k 13:56 LibraryClaire magnuse: nice! :D 14:15 StefanB magnuse: Ok, I've heard of a mexican wave, but a norwegian, that's a new one. :) 14:17 StefanB Anyway... Tried upgrading my Ubuntu to 16.04, turning off strict mode in the MySQL, and ran straight into Bug 17717. I'm a bit confused though, since this seems to be a change in perl (5.22 in the newer ubuntu, 5.18 in our older one). I wonder if CAS-client works in any way with 5.22. 14:17 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17717 normal, P4, ---, gmcharlt, NEW , process_message_queue.pl: Can't locate Authen/CAS/Client/Response/Failure.pm 14:20 oleonard Is the typical process with kohadevbox that it uses an existing test database on the host machine? 14:21 magnuse oleonard: no, the db is entirely inside the devbox 14:21 oleonard So it's always sample data you're working with? 14:22 magnuse if you have an existing test db you want to use, you have to dump it on the host, drag it into devbox and then load it into the db there 14:23 magnuse oleonard: you can populate the db in the devbox however you like, but with a fresh install you get the sample data, yes (or you run through the webinstaller and select what you want) 14:23 magnuse tcohen did lots of work on this after me, i am on bit of shaky ground here, i feel 14:24 tcohen oleonard: what would you like to do? 14:24 tcohen if you load it using 14:25 tcohen SKIP_WEBINSTALLER=1 CREATE_ADMIN_USER=1 vagrant up 14:25 tcohen you end up with the sample data 14:25 tcohen and the superlibrarian user you ocnfigured in user.yml (or just admin admin) 14:25 tcohen BUT 14:25 oleonard tcohen: I'm finally giving kohadevbox a try, on Windows. 14:25 magnuse oleonard++ 14:25 tcohen if you don't use SKIP_WEBINSTALLER=1 14:25 oleonard So I'm new to the whole process. 14:25 tcohen you need to install yourself through the webinstaller 14:25 tcohen OR 14:25 tcohen you can load your own DB 14:26 tcohen remember that if you have an SQL dump 14:26 tcohen you can put it in the root directory for kohadevbox 14:26 tcohen and it will be rsynced into /vagrant inside the box 14:27 * magnuse wanders off to eat porridge 14:27 oleonard tcohen: Ah right, so I could import from there 14:27 tcohen yes 14:27 tcohen beware that the dir is rsynced the first time you load it 14:28 tcohen it is not a two-way sync 14:30 LibraryClaire has anyone ever had any luck with trying to use user defined variables in SQL reports in koha? Am trying to reduce the number of times someone has to enter a date (currently at three) I've seen this: http://bywatersolutions.com/2014/10/21/variables-koha-reports/ but can't get the same principle to work for me :( 14:31 tcohen LibraryClaire: I once filled a bug i didn't work on, with the idea of reusing variables 14:31 tcohen so, I don't think it works 14:31 LibraryClaire bum 14:32 LibraryClaire it also got upset when I tried to use SET ^^ 14:40 LibraryClaire tcohen do you know what the bug was called? or a number 14:40 tcohen https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9634 14:40 huginn 04Bug 9634: enhancement, P5 - low, ---, tomascohen, NEW , Allow for parameters re-use on SQL reports 14:41 tcohen I forgot about it 14:41 LibraryClaire aha thanks 14:41 * LibraryClaire thinks it would be useful 14:44 oleonard tcohen: So the kohadevbox uses a base Debian box and then Ansible automates the Koha-specific customizations? 14:54 oleonard "An error occurred while downloading the remote file...transfer closed with 148040155 bytes remaining to read" 14:57 tcohen downloading the vagratn box? 14:59 oleonard Yes 14:59 tcohen the internet is against us today 15:00 oleonard Oh I see it tries to resume. I'll try again. 15:05 CPLKatie Hello everyone, I'm trying to extract MARC records, but the batch won't extract from the Excel spreadsheet of bib numbers I've generated. Any ideas? 15:13 edveal Morning eveeryone 15:15 Joubu @later tell cait it seems to be random failures again. I have managed to make it fail 1 time out of 100, so quite hard to recreate and debug... 15:15 huginn Joubu: The operation succeeded. 15:28 LibraryClaire laters koha 16:14 Joubu @later tell cait bug 17733 should make Jenkins happy 16:14 huginn Joubu: The operation succeeded. 16:20 oleonard tcohen around? 16:53 oleonard Vagrant keeps telling me '"rsync" could not be found on your PATH' but I'm on Windows, shouldn't it be using type 'Virtualbox?' 17:06 Nuentoter good afternoon Koha peoples 17:29 reiveune bye 17:47 oleonard @later tell tcohen Having trouble getting kohadevbox running on Win7: https://gitlab.com/snippets/32950 17:47 huginn oleonard: The operation succeeded. 18:02 tcohen oleonard: just read your issue on kohadevbox 18:03 * cait waves weakly 18:03 cait first round of christmas shopping done 18:04 oleonard Well done cait 18:04 cait thx ;) 18:04 cait oleonard: did you start yet? 18:05 cait could someone sign off on 17733? 18:05 cait bug 17733 18:05 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17733 normal, P5 - low, ---, jonathan.druart, Needs Signoff , Members.t is still failing randomly 18:05 cait needed to make 16.11 go green :) 18:14 oleonard cait: I have started to think about starting to go christmas shopping 18:14 cait well done :) 18:37 Nuentoter people do christmas shopping BEFORE christmas? damn oops 18:56 rangi morning 18:57 tcohen morning rangi 19:03 oleonard Hi rangi 19:08 * cait waves 19:11 Nuentoter morning folks! 19:20 * magnuse waves 19:23 fabio_teles Hello all. Does some have some information regarding Koha LDAPS authentication with Windows Server 2012 R2 that could share? We are trying to implement it on our University 19:28 magnuse fabio_teles: this might be bad timing for a very specific question like that. you might have more luck writing to the (devel?) email list 19:30 tcohen rangi: did u get my PR? 19:32 * tcohen answers to himself, yes, and it is broken 19:36 rangi yeah badges are still broken 19:40 tcohen i hate jenkins 19:40 cait hate is such a strong word 19:40 * cait sends a muffin 19:41 cait @later tell drojf can you eat teff flour? 19:41 huginn cait: The operation succeeded. 19:43 tcohen hi jenkins 19:47 magnuse jenkins! 19:47 wahanui jenkins is http://jenkins.koha-community.org/ 19:47 tcohen wahanui: forget that 19:47 wahanui tcohen: I forgot that 19:48 tcohen wahanui: jenkins is https://jenkins.koha-community.org 19:48 wahanui ...but jenkins is http://jenkins.koha-community.org/... 19:48 tcohen jenkins? 19:48 wahanui i heard jenkins was http://jenkins.koha-community.org/ 19:48 tcohen boo 19:56 cait not good= 19:57 cait forget jenkins 19:57 wahanui cait: I forgot jenkins 19:57 cait jenkins is https://jenkins.koha-community.org 19:57 cait jenkins? 19:57 wahanui jenkins is https://jenkins.koha-community.org 19:57 cait tcohen: ok? 20:04 tcohen thanks cait 20:04 tcohen have to head home, BBL 20:04 cait bye :) 21:05 tcohen hi 21:05 tcohen @seen dcook 21:05 huginn tcohen: dcook was last seen in #koha 4 days, 15 hours, and 30 seconds ago: * dcook waves to cait1 21:28 tcohen oleonard: around? 21:32 eythian Itym oleopard 21:49 jenkins Project Koha_Master_D8 build #60: UNSTABLE in 1 hr 45 min: https://jenkins.koha-community.org/job/Koha_Master_D8/60/ 22:47 tcohen @later tell oleonard I've just added lessc to the kohadevbox, is there a specific version that we need? Please let me know, it seems to have installed 2.7.1 22:47 huginn tcohen: The operation succeeded.