Time  Nick            Message
23:30 cait            np :)
23:30 oleonard        Cool, thanks cait
23:29 cait            mysql -u root
23:29 cait            oleonard: try empty
23:19 oleonard        Anyone awake? I seek the secret of a root mysql user in kohadevbox.
23:18 oleonard        Hi again for this day.
20:15 huginn          eythian: The current temperature in Amsterdam, Netherlands is 3.0°C (8:55 PM CET on February 13, 2017). Conditions: Clear. Humidity: 70%. Dew Point: -2.0°C. Windchill: -2.0°C. Pressure: 30.33 in 1027 hPa (Steady).
20:15 eythian         @wunder ams
19:43 huginn          cait: The current temperature in Mainaustraße, Konstanz, Germany is 2.9°C (7:46 PM CET on February 13, 2017). Conditions: Clear. Humidity: 80%. Dew Point: -0.0°C. Windchill: 3.0°C. Pressure: 30.24 in 1024 hPa (Steady).
19:43 cait            @wunder Konstanz
17:58 drojf           bye #koha
17:57 * drojf         heads home
17:57 drojf           but i had enough for today
17:57 drojf           at least most of it is in stretch now, so it's backporting, not doing all the packaging from scratch
17:56 tcohen          heh
17:55 drojf           heh
17:55 drojf           i don't think it would be fair to drop jessie now :P
17:55 JesseM          no targeting me  ;P
17:55 drojf           yes
17:55 tcohen          so we are still targeting Jessie :-D, good
17:54 drojf           but it's debian, so maybe it takes years after that :P
17:54 drojf           good question. i think they had freeze already
17:53 tcohen          when is strech released?
17:53 drojf           but it's more than i can do today, which is annoying. i thought i could get it done to the point where i set up a test repo
17:52 drojf           i think it's the packaging for stretch. i found one dep that did not really need perl 5.24 and works fine with a lower version. i assume that works for others too
17:51 tcohen          I mean, it is using Perl 5.20
17:51 drojf           :P
17:51 drojf           tcohen: yuck
17:51 tcohen          drojf: kohadevbox gets Catmandu installed by CPAN on Jessie
17:36 huginn          tcohen: The current temperature in Cordoba, Argentina is 26.0°C (2:00 PM ART on February 13, 2017). Conditions: Scattered Clouds. Humidity: 39%. Dew Point: 11.0°C. Pressure: 29.95 in 1014 hPa (Falling).
17:36 tcohen          @wunder cordoba, argentina
17:35 * cait          waves
17:29 oleonard        drojf: If your colleague ends up trying something like it I'd be interested to hear how it goes
17:24 drojf           i was more thinking of things like accidentally breaking the layout
17:24 oleonard        I suspect we do less cross-browser/cross-platform testing than we should, but I also don't think pixel-perfect matching is necessary
17:23 drojf           heh. ok. my office colleague has been looking into that and i was wondering if it would be useful for koha
17:22 oleonard        Neat. I've never seen that before. So I guess the answer is no
17:22 drojf           oleonard: i am talking of things like https://github.com/BBC-News/wraith
17:21 oleonard        drojf: I don't think I understand your question
17:21 drojf           oleonard: are you working with visual diffs for web development?
17:17 volve           oleonard: turns out that the digibib/koha-docker create a mysql trigger that tries to set frameworkcode to "DCHM" on any new records. I deleted this trigger becauase I don't have any frameworks with code of "DCHM", and all seems well now. I was able to add a record successfully.
17:16 oleonard        volve: What do you mean by no signs of it in the UI?
16:49 volve           hey all, if I have an old framework, but no signs of it in the UI, how can I make sure I nuke it from the database without losing everything else?
16:21 cait            ouch
16:21 cait            oh
16:19 drojf           i think the dependencies of dependencies require perl 5.24 :/
16:18 wahanui         well, catmandu is pretty super awesome
16:18 drojf           catmandu
16:18 drojf           nope
16:18 cait            not me i hope? drojf?
16:14 drojf           dependencies--
16:12 reiveune        bye
16:11 LibraryClaire   laters #koha
15:53 tcohen          eythian: troll
15:38 eythian         the particular tense you needed is actually called "the unreal past" apparently. That's a good name.
15:37 eythian         you should install one
15:37 tcohen          eythian: probably due to my lack of idiomatic checker
15:36 eythian         you definitely said multiple times that they polished it :)
15:36 tcohen          :-P
15:36 * tcohen        thinks the missing comma makes it clear and you are wrong
15:36 * LibraryClaire is sad there is no polished floor to slide on
15:35 * cait          blames tcohen for getting everyone confused
15:35 cait            ;)
15:35 cait            (15:46:46) tcohen: I couldn't be at the new house to open so the guys polished the new floor
15:34 tcohen          no one polished it
15:34 cait            squeee!
15:34 * LibraryClaire slides across shiny polished floor
15:33 eythian         if no one is there to open the door, how did they polish it?
15:33 tcohen          e
15:33 tcohen          far from where I liv
15:33 tcohen          it is outside Cordoba
15:33 tcohen          the house is empty, and no one is there to open the door!
15:32 cait            you wanted to watch them?
15:32 tcohen          I had an appointment so they polished it, and I missed it
15:29 cait            tcohen: was wondering why polishing hte floor was bad :)
15:25 * tcohen        is glad to see interest in kohadevbox and that more people contribute to it
15:14 tcohen          she wrote it here earlier
15:14 LibraryClaire   :D
15:14 tcohen          "Sent 11 hours and 25 minutes ago: <wizzycray> maybe it's time to move devbox out from under digibib?"
15:11 LibraryClaire   ultimate stealth message
15:10 * oleonard      is curious what tcohen was talking to wizzycray about
14:56 huginn          tcohen: The operation succeeded.
14:56 tcohen          @later tell wizzycray I've been thinking about it recently. now that people have interest on it it might be worth talking about that
14:49 tcohen          is the injectors :-P
14:49 tcohen          cait: the car's problem?
14:48 * oleonard      waves to newly woken up peoples
14:48 cait            tcohen: can you explain the problem?
14:46 * LibraryClaire 's brain didn't start this morning
14:46 tcohen          I couldn't be at the new house to open so the guys polished the new floor :-(
14:46 cait            :(
14:44 * tcohen        's car didn't start this morning, bad week start
14:44 LibraryClaire   hi tcohen
14:43 tcohen          hi drojf
14:42 drojf           hi tcohen
14:41 tcohen          morning
14:27 drojf           if i understand correctly, i can only test patch 3 and 4 in a regular debian installation
14:25 drojf           marcelr: works. are the tests supposed to be done step by step or can i test with the package that has all patches?
14:18 drojf           to confirm
14:18 drojf           but i will use it in my vm now which was broken last week
14:18 marcelr         good
14:18 marcelr         indirect test
14:18 drojf           so i am fairly certain it fixes it ;)
14:17 drojf           marcelr: i built a package with master + the patches and used it to upgrade a vm
14:17 marcelr         o no he is on top
14:17 wahanui         no drojf is afraid you will make me chair
14:17 marcelr         no drojf
14:16 marcelr         drojf: did you test it, or only noting ?
14:11 LibraryClaire   hi kidclamp
14:11 marcelr         hello kidclamp
14:10 kidclamp        morning
13:46 huginn          barton: The operation succeeded.
13:46 barton          @later tell tcohen something to look at with koha-zebra: zebrasrv has a 1024K default ceiling on record size. This can be increased. We should probably set it in $KOHA_CONF, the same way we set loglevels.
13:40 edveal          morning barton
13:40 barton          morning #koha!
13:34 edveal          Hello
13:34 Guest457        hello
12:49 wahanui         hi oleopard
12:49 drojf           hi oleonard
12:43 eythian         hi oleopard
12:42 oleonard        Hi everyone
12:27 magnuse         lulz
12:27 eythian         I think you must have the wrong Norway, magnuse. It's supposed to be -20 all the time there.
12:26 magnuse         phew
12:26 huginn          magnuse: The current temperature in Bodo Vi, Norway is 6.0°C (1:00 PM CET on February 13, 2017). Conditions: Light Rain. Humidity: 100%. Dew Point: 6.0°C. Pressure: 30.26 in 1025 hPa (Rising).
12:26 magnuse         @wunder enbo
12:04 eythian         hah, 0.1° warmer!
12:03 huginn          LibraryClaire: The current temperature in MainaustraÃ&#376;e, Konstanz, Germany is 3.2°C (12:49 PM CET on February 13, 2017). Conditions: Mostly Cloudy. Humidity: 79%. Dew Point: -0.0°C. Windchill: 3.0°C. Pressure: 30.27 in 1025 hPa (Steady).
12:03 LibraryClaire   @wunder konstanz
12:03 LibraryClaire   stupid keyboards
12:03 huginn          LibraryClaire: Error: HTTP Error 404: Not Found
12:03 LibraryClaire   @wunder konstany
12:00 eythian         Snow outside is slowly melting
11:59 eythian         that's better
11:59 huginn          eythian: The current temperature in Ten Kateplein, Amsterdam, Netherlands is 3.3°C (12:49 PM CET on February 13, 2017). Conditions: Clear. Humidity: 74%. Dew Point: -1.0°C. Windchill: 3.0°C. Pressure: 30.39 in 1029 hPa (Steady).
11:59 eythian         @wunder jordaan, ams
11:59 eythian         give it back!
11:48 drojf           it's all mine
11:48 huginn          drojf: The current temperature in Berlin, Berlin, Germany is -1.8°C (12:08 PM CET on February 13, 2017). Conditions: Clear. Humidity: 89%. Dew Point: -3.0°C. Windchill: -2.0°C. Pressure: 30.66 in 1038 hPa (Steady).
11:48 drojf           @wunder berlin, germany
11:47 eythian         drojf: apparently not.
11:33 drojf           eythian: no weather for you
10:58 eythian         :<
10:58 huginn          eythian: An error has occurred and has been logged. Please contact this bot's administrator for more information.
10:58 eythian         @wunder jordaan, ams
10:58 huginn          eythian: An error has occurred and has been logged. Please contact this bot's administrator for more information.
10:58 eythian         @wunder ams
10:58 wahanui         bidet, eythian
10:58 eythian         hi
10:24 cait            moin drojf
10:08 drojf           hi cait
09:58 * cait          waves
07:49 alex_a          hello LibraryClaire
07:46 LibraryClaire   hi alex_a
07:45 wahanui         hello, alex_a
07:45 alex_a          bonjour
07:38 magnuse         guten morgen LibraryClaire
07:38 wahanui         kamelåså
07:38 LibraryClaire   hi magnuse
07:38 wahanui         kamelåså
07:38 laurence        hi magnuse
07:37 wahanui         LibraryClaire is the monster under my bed
07:37 marcelr         and LibraryClaire
07:37 LibraryClaire   o/
07:37 marcelr         morning magnuse
07:37 magnuse         bonjour reiveune marcelr laurence
07:37 marcelr         hi drojf
07:37 drojf           hi marcelr
07:34 marcelr         hi #koha
07:33 wahanui         salut, reiveune
07:33 reiveune        hello
07:31 drojf           i don't think we had much + lately
07:31 drojf           i wonder if it's safe to walk on the canal close by
07:30 magnuse         it's safe to walk outside again!
07:30 magnuse         yup, all the ice is gone
07:30 drojf           nice!
07:30 drojf           hei magnuse
07:27 magnuse         drojf: it's about +6C here
07:26 magnuse         :-(
07:26 huginn          magnuse: An error has occurred and has been logged. Please contact this bot's administrator for more information.
07:26 magnuse         @wunder boo
07:26 huginn          magnuse: An error has occurred and has been logged. Please contact this bot's administrator for more information.
07:26 magnuse         @wunder bodø, norway
07:26 huginn          magnuse: An error has occurred and has been logged. Please contact this bot's administrator for more information.
07:26 magnuse         @wunder enbo
07:26 magnuse         moin drojf cait liw
07:22 cait            hmpf
07:22 huginn          cait: An error has occurred and has been logged. Please contact this bot's administrator for more information.
07:22 cait            @wunder Konstanz
07:00 drojf           everywhere is warmer than here
07:00 liw
07:00 drojf           hi liw
06:59 huginn          liw: The current temperature in Helsinki, Finland is -1.0°C (8:20 AM EET on February 13, 2017). Conditions: Clear. Humidity: 80%. Dew Point: -4.0°C. Windchill: -6.0°C. Pressure: 30.30 in 1026 hPa (Steady).
06:59 liw             @wunder helsinki
06:57 drojf           woop woop
06:57 huginn          drojf: The current temperature in Marseille, France is 15.0°C (7:30 AM CET on February 13, 2017). Conditions: Overcast. Humidity: 48%. Dew Point: 4.0°C. Pressure: 30.06 in 1018 hPa (Steady).
06:57 drojf           @wunder marseille, france
06:56 drojf           oj
06:56 huginn          drojf: The current temperature in Berlin, Berlin, Germany is -6.9°C (7:32 AM CET on February 13, 2017). Conditions: Clear. Humidity: 94%. Dew Point: -8.0°C. Windchill: -7.0°C. Pressure: 30.66 in 1038 hPa (Steady).
06:56 drojf           @wunder berlin, germany
06:52 drojf           hi #koha
06:46 * magnuse       waves
06:42 josef_moravec   morning#koha
05:13 huginn          irma: The operation succeeded.
05:13 irma            @later tell rangi Do you need instructions re Article request for the KC Manual 16.11?
05:11 irma            nice feature!
05:10 irma            would it help if we wrote the instruction for the Koha Manual 16.11?
05:10 huginn          04Bug 14610: new feature, P5 - low, ---, kyle.m.hall, Pushed to Stable , Add ability to place article requests in Koha
05:10 irma            hi rangi About the Article request function https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14610
03:49 volve           well it wasn't really foo ;)
03:48 * wizzycray     does not know of any bugs with naming things 'foo' in debian
03:48 wizzycray       well yay :)
03:47 volve           I gave it a different name and it's running fine now
03:47 volve           nope
03:47 wizzycray       is it the 2nd time you've done it?
03:47 volve           correction "User foo-koha already exists."
03:46 volve           on a brand new install
03:46 volve           odd, `koha-create --create-db foo` says "User foo already exists."
03:36 volve           so it would seem :D
03:36 wizzycray       which is cool, but it is hard to support :)
03:35 wizzycray       they have got their own special sauce
03:35 volve           right, right. Fun to think that koha-docker is running the Oslo Public Library
03:29 wizzycray       Europe should be waking up soon, should you run into any more problems
03:29 volve           thanks!
03:29 wizzycray       good luck
03:29 wizzycray       yep I know that feeling :)
03:28 volve           thanks for your help wizzycray, really appreciate it, hoping to get this deployed to a team of eager folks asap
03:26 wizzycray       it's ok it happens
03:26 volve           so clearly I missed it
03:26 wizzycray       \o/
03:26 volve           but not at the actually step for installing mysql, ha
03:26 wizzycray       keke
03:26 volve           oh hey funny there's a note at the top "Koha does not work well with MySQL 5.7 which is shipped with Ubuntu 16.04. use MariaDB instead."
03:25 wizzycray       it's a wiki ^.^
03:25 wizzycray       you can :)
03:25 volve           not/note
03:25 volve           who updates the Koha_on_Debian guide? I would have loved a mariadb reference or mysql version not ;)
03:24 wizzycray       but we're working on it :)
03:24 wizzycray       but yeah, mysql 5.7 is a bad deal atm
03:24 wizzycray       none of that hurts.
03:24 wizzycray       i mean, if you've got nothing in it
03:24 wizzycray       create database koha_the_name_of_your_instance
03:24 wizzycray       drop database koha_the_name_of_your_instance
03:23 wizzycray       sudo koha-mysql <the name of your instance>
03:23 wizzycray       and/or
03:23 wizzycray       and start again
03:23 wizzycray       you can always koha-remove <the name of your instance>
03:23 wizzycray       yeah, if you get yourself into that situation
03:23 wizzycray       good luck :)
03:23 * volve         gets typing
03:23 volve           happy to hear mariadb will solve it
03:22 volve           yep, I had to monkey with sql_mode to get past the installer, but at that point there were so many dupes in the database it was not usable and I gave-up, back to the docker situation
03:21 volve           well thank you wizzycray, I filed an issue for koha-docker, and will give mariadb a go with a fresh debian install
03:21 wizzycray       also some suggested work arounds
03:21 huginn          04Bug 17258: major, P5 - low, ---, gmcharlt, NEW , [OMIBUS] MySQL 5.7
03:21 wizzycray       https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258
03:20 volve           ah, ok
03:20 wizzycray       there is a bug for the 5.7 problems I don't remember the number
03:20 wizzycray       (yet)
03:20 wizzycray       nope, they haven't implemented the changes that break it in mysql 5.7
03:20 volve           I'm happy to give that another whirl
03:20 volve           any particular mariadb version?
03:19 wizzycray       yep
03:19 volve           that's frustrating
03:19 wizzycray       probably not, the 5.7 thing is quite new.
03:19 volve           yeah that's the one I followed, but it doesn't mention mysql versions I don't believe
03:19 wizzycray       but not this page, normally.
03:19 wizzycray       there are lots of blog posts, most of them are wrong in some way.
03:19 wizzycray       https://wiki.koha-community.org/wiki/Koha_on_Debian this is the most usually and frequently maintained guide
03:18 wizzycray       debian, generally.
03:18 wizzycray       generally speaking, the community likes debian 8
03:17 wizzycray       the ubuntu/debian version shouldn't give you too much hassle
03:17 wizzycray       either use mariadb, or mysql 5.5
03:17 wizzycray       basically, for current versions
03:17 volve           ok, well if I wanted to do a fool-proof production deployment, is there a better guide that has compatible mysql versions and such?
03:16 huginn          wizzycray: The operation succeeded.
03:16 wizzycray       @later tell tcohen maybe it's time to move devbox out from under digibib?
03:16 volve           oh, odd
03:16 wizzycray       I know it's confusing
03:16 wizzycray       community people do
03:16 wizzycray       they started that, but they don't maintain it to speak of.
03:16 wizzycray       yeah, but not really.
03:16 wizzycray       but don't run that in production.
03:16 volve           wizzycray: that's the same devs as the docker image, ha!
03:16 wizzycray       and you get a developer install too.
03:15 wizzycray       https://github.com/digibib/kohadevbox this is a much better route
03:15 volve           oh, what version of mysql is preferred then? the guides didn't specify
03:15 wizzycray       if you just want to play
03:15 wizzycray       which (all the sigh) is a known problem
03:15 wizzycray       that was probably mysql 5.7
03:14 volve           at the step where you choose which sample data you want, everything kept exploding
03:14 wizzycray       you'd have better luck getting help with those than with the digibib docker thing
03:14 volve           to be fair, I also did a vanilla Debian install using the official guide and got crazy database errors simply stepping through the install wizard :\
03:14 wizzycray       is this koha for production or for fun
03:13 wizzycray       which obviously breaks it
03:13 wizzycray       it's got their stuff in it
03:13 wizzycray       that's great, but it's not core Koha
03:13 volve           they publish their Koha images for Docker to Docker's image Hub - and their scripts do seem to work well
03:13 wizzycray       yeah don't use that
03:13 wizzycray       heh
03:12 wizzycray       was this a docker thing you downloaded from somewhere?
03:11 volve           "<option value="DCHM">Deichman-rammeverk</option>" in one of their patches
03:11 volve           So I'll dig some more
03:11 volve           but there's a reference to DCHM buried in there
03:11 volve           it's very active
03:11 volve           I think I may have found a reference. The devs that setup this docker image use this github repo: github.com/digibib/koha-docker/
03:10 volve           wizzycray: I've tried saving records as both, same error
03:09 volve           looking at the channel logs, the person in question magically figured it out with no explanation...
03:09 wizzycray       are you logged in as the database user or as a regular user with permissions/
03:09 volve           funnily enough Google found 1 result for this exact error, and pointed me here... 1 month ago
03:09 volve           I have no knowledge of what "DCHM" might mean
03:08 wizzycray       shh.
03:08 wahanui         i think the code is kept at git.koha-community.org
03:08 wizzycray       or the code?
03:08 wizzycray       is that the name of your library?
03:08 wizzycray       from*
03:08 wizzycray       I don't know where it's getting DCHM for
03:08 volve           And how can I get them out, ha
03:08 volve           So why would DCHM be a factor when trying to save a new record if there are no frameworks listed with a DCHM code?
03:07 volve           Indeed.
03:02 wizzycray       hm.
03:02 wizzycray       Ah
03:02 volve           it's running in a Docker container
03:01 volve           I think it's 16.04
02:59 * volve         double-checks
02:59 wizzycray       what version of ubuntu?
02:59 volve           Linux Ubuntu, Mysql 5.5.54
02:59 volve           16.11.02.000
02:58 wizzycray       and what server OS/MySQL version
02:58 wizzycray       yeah but what version
02:58 volve           my repro steps are: Cataloging -> New from Z39.50/SRU -> Title search from 2 targets -> Click "Import" on 1 of the 4 results -> Choose "Book" as Koha item type -> Hit Save -> "Internal Server Error" with log entry about DCHM
02:57 wizzycray       what version is this?
02:56 volve           yes
02:56 wizzycray       your default framework exists?
02:56 volve           I get this error when trying to add my very first record
02:56 wahanui         i guess the message is self-explanatory
02:56 wizzycray       where do you get the message?
02:56 volve           the funny thing is I have no records at all
02:55 volve           I can give it a try
02:55 wizzycray       it won't hurt, anyway.
02:54 wizzycray       does it magically start working?
02:54 wizzycray       then imported the default framework on top of that
02:54 wizzycray       created a new framework with the code DCHM
02:54 wizzycray       if you exported the default framework
02:54 wizzycray       but that's just a guess
02:54 wizzycray       that don't actually match up to an existent framework
02:54 wizzycray       it would seem that possibly you have set framework codes on your records
02:54 volve           why are you not surprised? :)
02:53 * wizzycray     is not surprised
02:53 volve           when I look at the marc frameworks page in intra, there's no code listed as DCHM, oddly
02:53 wizzycray       did you import your database from a different Koha?
02:52 volve           well that's curious
02:52 wizzycray       iirc.
02:52 wizzycray       ""
02:52 wizzycray       well the framework code on a new install for the default framework would be
02:52 volve           clearly something's wonky somewhere, but I'm a newb to Koha so have no idea where to look
02:52 volve           literally a fresh install
02:52 volve           not editted
02:52 volve           Default
02:51 wizzycray       new or old framework?
02:50 volve           when I poke at the database with `select count(*) from marc_subfield_structure where frameworkcode="DCHM" and kohafield="biblio.biblionumber";` comes back as 0, I'm not sure if that's right though
02:49 volve           and marc links is happy too
02:49 volve           yup :/
02:48 wizzycray       999c -> biblio.biblionumber
02:48 wizzycray       do you have it mapped to the biblionumber in koha->marc mappings?
02:48 volve           wizzycray: nope
02:44 wizzycray       did you delete the 999c from your framework?
02:41 volve           hey all, anyone around? I'm still battling this "No biblionumber tag for framework "DCHM" at /usr/share/koha/lib/C4/Biblio.pm line 3093" internal server error on my new install :(
02:37 wizzycray       Welcome to the #koha IRC chat | Code of conduct - https://koha-community.org/about/policy/code-of-conduct/ | Please use http://paste.koha-community.org for pastes | Installation guide for Koha is https://wiki.koha-community.org/wiki/Debian
02:37 hertz           ?
02:37 hertz           Is this room dedicated to programming
02:36 hertz           Hey whats up
02:26 wahanui         bonjour, hertz
02:26 hertz           Hello