IRC log for #koha, 2017-01-27

All times shown according to UTC.

Time S Nick Message
01:06 * kidclamp_away hides the paint from dcook
01:07 dcook :P
02:55 irma joined #koha
03:53 irma joined #koha
04:19 Francesca joined #koha
06:22 drojf joined #koha
06:22 drojf morning #koha
06:29 Francesca joined #koha
06:34 bag hiya drojf
06:35 drojf hi bag
06:36 drojf how aree things?
06:36 drojf *are
06:41 laurence joined #koha
06:41 bag going well :)  I have so many thougts going through my mind - I am in writing things down mode
06:42 drojf sounds awesome
06:42 bag good thoughts ;) fundraising for Koha thoughts
06:42 drojf cool
06:42 bag :D
06:42 bag how about you drojf ?  how’s things
06:43 drojf good. lots of work but i hope i can work more on koha again
06:43 drojf got the first package into debian for elasticsearch
06:46 drojf started backporting stuff for the unstable repo to see what else needs to go in debian first. i hope it's only one more package to submit
06:47 irma joined #koha
06:52 LibraryClaire joined #koha
06:53 bag sweet drojf
06:53 LibraryClaire morning #koha
06:53 bag hi there LibraryClaire
06:53 LibraryClaire hey bag
06:53 LibraryClaire how's the foot?
06:53 drojf hi LibraryClaire
06:53 LibraryClaire moin drojf
06:53 bag hurting ;)
06:53 LibraryClaire aw :(
06:53 bag how you doing?
06:55 LibraryClaire alright thanks, hip seems to not be hurting much now
06:55 LibraryClaire hpefully will run at the weekend :)
06:56 bag excellent :)
06:57 bag whens the race date again?
07:01 liw @wunder helsinki
07:01 huginn liw: The current temperature in Helsinki, Finland is 0.0°C (8:50 AM EET on January 27, 2017). Conditions: Fog. Humidity: 100%. Dew Point: 0.0°C. Pressure: 30.12 in 1020 hPa (Steady).
07:02 LibraryClaire sorry went to grab breakfast from teh breakfast lady
07:02 LibraryClaire bag: err, Sunday after Easter 23rd ish of April
07:02 LibraryClaire I think
07:03 LibraryClaire @wunder konstanz
07:03 huginn LibraryClaire: The current temperature in Mainaustraße, Konstanz, Germany is -2.1°C (7:57 AM CET on January 27, 2017). Conditions: Clear. Humidity: 84%. Dew Point: -4.0°C. Windchill: -2.0°C. Pressure: 30.15 in 1021 hPa (Steady).
07:03 bag hmm.. I need a breakfast person
07:03 bag that sounds perfect
07:04 LibraryClaire she is here between 7:55 and like five or ten past 8
07:04 bag @wunder pdx
07:04 huginn bag: The current temperature in Portland, Oregon is 3.0°C (10:53 PM PST on January 26, 2017). Conditions: Clear. Humidity: 93%. Dew Point: 2.0°C. Pressure: 30.61 in 1036 hPa (Rising). Winter Weather Advisory in effect until 1 PM PST Wednesday...
07:04 LibraryClaire then she drives off
07:05 cait joined #koha
07:05 * LibraryClaire goes to find tea
07:06 * liw sips the first cuppa
07:06 bag aloha cait
07:10 * LibraryClaire burns her mouth on tea
07:21 * magnuse waves
07:21 magnuse bag: HI
07:21 LibraryClaire hei magnuse
07:21 bag magnuse: knuckles
07:21 magnuse guten morgen BüchereiKlara
07:21 magnuse bag: knuckles!
07:22 bag @wunder boo
07:22 huginn bag: Error: No such location could be found.
07:22 bag @wunder bodo
07:22 huginn bag: Error: No such location could be found.
07:22 bag ahh I can’t remember the correct one
07:22 bag @wunder bod
07:22 magnuse @wunder enbo
07:22 huginn bag: Error: No such location could be found.
07:22 drojf hei magnuse
07:22 huginn magnuse: The current temperature in Bodo, Norway is 5.0°C (7:50 AM CET on January 27, 2017). Conditions: Clear. Humidity: 81%. Dew Point: 2.0°C. Windchill: 1.0°C. Pressure: 29.92 in 1013 hPa (Steady).
07:22 drojf @wunder berlin, germany
07:23 huginn drojf: The current temperature in Berlin, Berlin, Germany is -4.6°C (8:22 AM CET on January 27, 2017). Conditions: Clear. Humidity: 96%. Dew Point: -5.0°C. Windchill: -5.0°C. Pressure: 30.27 in 1025 hPa (Steady).
07:23 bag ah!!! magnuse knows
07:23 drojf norwegian summer
07:23 magnuse it used to be boo
07:23 magnuse yeah. we had 8 yesterday
07:23 drojf global warming is a lie :P
07:23 LibraryClaire hah, northern Germany is now colder than the south
07:23 magnuse heh
07:23 drojf i thought that is the usual
07:24 eythian @wunder ams
07:24 huginn eythian: The current temperature in Amsterdam, Netherlands is -4.0°C (7:55 AM CET on January 27, 2017). Conditions: Clear. Humidity: 86%. Dew Point: -6.0°C. Windchill: -8.0°C. Pressure: 29.98 in 1015 hPa (Falling).
07:24 LibraryClaire yeah, but hasn't been in the last week or two
07:24 LibraryClaire I heard rumours we were gonna get plus temps :O
07:24 eythian We're supposed to get 10 next week!
07:25 * LibraryClaire sunbathes
07:25 eythian Huh, 7 today
07:25 eythian That'll be a change from -4
07:25 eythian I should wear shorts
07:26 drojf i used all sun yesterday, it's dead now
07:26 LibraryClaire we haven't had sun for a few days now at least, just thie kind of fog
07:27 drojf you live in a foggy place
07:27 LibraryClaire in the UK we just called it winter
07:27 drojf hah just wanted to say, it's kind of a british thing, right?
07:27 LibraryClaire british winter is generally just days and days of grey, kind of cold and damp but not mega cold, and some rain
07:28 LibraryClaire sometimes it gets cold enough for the south to have snow. Then all the infrastructure breaks and everyone buys all the bread
07:29 eythian We've had some serious fog here too lately
07:29 drojf yay hamsterkauf. like every day before a holiday in germany
07:30 LibraryClaire which is funny, cos they should be used to Sundays by now... so surely it's the same :P
07:30 drojf it's a deep trauma caused by closed shops on sundays i guess
07:31 magnuse hamsterkauf - that's funny
07:32 LibraryClaire i've not heard that phrase before
07:32 drojf we buy all the hamsters and then eat them when the shops are close
07:32 drojf d
07:32 * LibraryClaire moves across the border to Switzerland
07:33 drojf no, actually just carry our groceries home in the mouth
07:33 drojf *we
07:33 drojf also, swiss people do hamsterkauf in konstanz every day. not sure if that is where to go
07:34 LibraryClaire they come and buy our cheap toilet paper :P
07:34 drojf oh, sun
07:35 * drojf can't see anything
07:35 drojf but it feels good
07:37 * LibraryClaire wonders if it is possible to be higher than the fog
07:38 eythian In Wellington, I lived above the fog some days.
07:38 LibraryClaire I bet the sun is up there
07:38 paul_p joined #koha
07:38 marcelr joined #koha
07:38 marcelr hi #koha
07:39 reiveune joined #koha
07:39 eythian Morgen marcelr
07:39 marcelr eythian!
07:39 wahanui eythian is Time's Person of the Year for 2006.
07:39 reiveune hello
07:39 wahanui kia ora, reiveune
07:39 LibraryClaire hey marcelr
07:40 marcelr hi reiveune and LibraryClaire
07:40 LibraryClaire salut reiveune
07:40 drojf hi marcelr
07:41 marcelr hi drojf
07:43 alex_a joined #koha
07:44 alex_a hello
07:44 wahanui hola, alex_a
07:54 ashimema joined #koha
07:57 papa joined #koha
08:11 AndrewIsh joined #koha
08:12 fridolin joined #koha
08:12 fridolin hie ther
08:15 cait joined #koha
08:15 gaetan_B joined #koha
08:15 bag heya fridolin
08:15 wahanui fridolin is busy at the moment, I asked him to backport the bug fix
08:15 gaetan_B hello
08:15 bag aloha gaetan_B
08:16 LibraryClaire hi fridonlin
08:16 LibraryClaire close... fridolin
08:17 LibraryClaire hi gaetan_B
08:17 fridolin bag: LibraryClaire : and others : le Bonjour
08:17 paul_p_ joined #koha
08:17 LibraryClaire o/
08:17 Joubu hi #koha
08:17 LibraryClaire bonjour Joubu
08:18 cait morning #koha :)
08:18 cait @wunder Konstanz
08:18 huginn cait: The current temperature in Mainaustraße, Konstanz, Germany is -2.1°C (9:15 AM CET on January 27, 2017). Conditions: Clear. Humidity: 84%. Dew Point: -4.0°C. Windchill: -2.0°C. Pressure: 30.15 in 1021 hPa (Steady).
08:22 sophie_m joined #koha
08:28 Joubu Could some of you answer on bug 17793 comment 16?
08:28 huginn Bug[…]_bug.cgi?id=17793 enhancement, P5 - low, ---, aleishaamohia, In Discussion , Make sysprefs search show on all Administration pages
08:28 Joubu I'd like to get more opinions before passing QA on it
08:29 Joubu The question is: "Do you agree to remove the 'check in' and 'renew' tab from the header search of the administration module and replace them with a 'syspref search' tab which would be the default?"
08:31 marcelr will have a look
08:34 papa joined #koha
08:39 Francesca joined #koha
08:44 paul_p joined #koha
08:44 sophie_m1 joined #koha
08:59 cait Joubu: can we quickly summarize what remains? just looking at the bug
09:00 drojf joined #koha
09:01 drojf @wunder berlin, germany
09:01 huginn drojf: An error has occurred and has been logged. Please contact this bot's administrator for more information.
09:01 drojf :'(
09:01 drojf @wunder berlin, germany
09:01 huginn drojf: The current temperature in Berlin, Berlin, Germany is -3.4°C (9:59 AM CET on January 27, 2017). Conditions: Clear. Humidity: 95%. Dew Point: -4.0°C. Windchill: -3.0°C. Pressure: 30.27 in 1025 hPa (Steady).
09:02 sophie_m joined #koha
09:04 Joubu cait: what do you mean?
09:06 drojf @later tell rangi thanks!
09:06 huginn drojf: The operation succeeded.
09:06 cait which tabs will show after patch is pushed
09:07 cait i am pro syspref search, but we can't make it too crowded up there :)
09:07 eythian http://devopsreactions.tumblr.[…]otype-good-enough
09:09 Joubu cait: will be syspref|checkin|catalog search
09:09 Joubu iirc
09:09 Francesca joined #koha
09:09 Joubu instead of checkout|renew|catalog search
09:26 bag hi Joubu
09:27 Joubu hi bag!
09:29 Joubu fridolin: would you know why deletedborrowers.borrowernumber is not a PK?
09:30 Joubu fridolin: Do you think about a situation to have it?
09:34 fridolin Joubu: yes, deleted tables should not have a PK since they are composed of real data that use to have a PK
09:34 Joubu Could someone with a big and old DB execute: select count(*) as nb, borrowernumber from deletedborrowers  group by borrowernumber having nb > 1;
09:34 fridolin yep in theory
09:34 Joubu fridolin: I do not understand your assertion
09:34 fridolin the pb is that borrowernumber is autogenrated
09:34 Joubu it can be a PK and not AI
09:35 Joubu then what is wrong with having deletedborrowers.borrowernumber a primary key, not AI ?
09:35 fridolin if a borrower is deleted there is a chance another new borrower gets the same id
09:36 Joubu As long as we have AI on borrowers.borrowernumber, we should not have twice the same is
09:36 Joubu fridolin: how?
09:36 fridolin but for that the autogenrated must be reset, it happens only when table is empty and database is rebooted
09:36 fridolin this pb can exist for reserves and issues
09:36 Joubu AI is 42, add a patron, will be 42. AI is now 43. Delete it via the cli, AI is still 43
09:37 Joubu if the table is empty and the DB is rebooted, the AI is reset?
09:37 fridolin it will rare to empty borrowers table but the case exists
09:38 fridolin "if the table is empty and the DB is rebooted, the AI is reset?" in MySQL / MariaDB yes im pretty sure
09:38 fridolin i remember it is not the case in Oracle ...
09:38 fridolin in the end, deletedborrowers is only for statistics, a simple index on borrowernumber should be enought
09:39 fridolin and  regular delete of old entries
09:39 Joubu fridolin: we need a PK for DBIC
09:39 fridolin Joubu: ahhh always
09:39 fridolin then create a new column I-d say : deletedborrowernumber PK AI
09:40 fridolin how are old_issues and old_reserves ?
09:40 Joubu yes but I would make sure it's needed first
09:40 Joubu no PK atm
09:43 Joubu indeed the AI is reset if the table is empty and the dbms is restart
09:43 Joubu I guess it's a... feature
09:44 cait Joubu: checkin makes no sense for me
09:44 cait Joubu: i think better have patron and checkout or so
09:46 fridolin Joubu: i'm not a DB expert, i just know the AI reset issue can be very hard to detect
09:46 Joubu fridolin: so the only case it could happen is if you remove all the patrons of your DB but you have deleted patrons
09:46 fridolin the SQL just failes on existing PK
09:46 Joubu that's a weird case
09:46 fridolin indeed
09:47 cait reading back - what happens when you delete the last borrower added and then restart?
09:47 cait will it reset the AI then too?
09:48 fridolin Joubu: yes but if you must do something for old_issues/reservers, do the same for deleted* no ?
09:48 fridolin KISS
09:48 fridolin #KISS
09:48 Joubu the problematic use case: 1. install Koha, 2. Create a test patron, 3. Delete it. 4. Next day Create a patron => boom
09:48 fridolin before 4 reboot the server
09:48 Joubu well not boom yet, but when you will delete your first patron
09:48 fridolin i think you must empty RAM
09:49 fridolin yep 5. delete the new patron
09:49 fridolin if the borrowernumber is the same boom
09:49 Joubu so yes, that sucks
09:49 fridolin the new PK will seem useless but there are a lot, just there to id the line
09:50 fridolin the row i mean
09:50 fridolin maybe having deleted data tables is not a good idea in SQL
09:51 fridolin relationnal DB
09:52 Joubu yes I know...
09:52 Joubu opened this discussion one year ago, nobody cared about
09:52 Barrc joined #koha
09:53 Joubu cait: it's checkout indeed, not checkin!
09:54 Joubu so with the patch: "syspref | checkout | search cat"
09:54 * ashimema hasn't read all the way back.. but points out you can have a dbic primary key defined that's not actually a real primary key in the database
09:54 Joubu without the patch (master): checkout|checkin|renew|search cat
09:55 Joubu ashimema: how does dbic handle that?
09:55 Joubu if you call ->find on the pk? :)
09:56 ashimema you just tell it in the resultclass what field your treating as the primary key
09:56 ashimema in a meeting right now
09:56 Joubu https://bugs.koha-community.or[…]ment.cgi?id=59583
09:56 ashimema will reply proper in a few minutes
09:56 Joubu What khall suggested to do. It was me that asked if it was not better to have the constraint set at the DB level
09:56 Joubu ok thanks!
10:07 cait Joubu: ok with me then :)
10:07 cait @later tell khall ping me when you are around?
10:07 huginn cait: The operation succeeded.
10:13 ashimema 10 minutes to the next call
10:13 ashimema busy day for calls :(
10:13 ashimema so yeah.. khall has suggested what I was suggesting
10:14 ashimema back to the why it's not in the db.. I can't remember.. I'll ask a colleague.. I'm sure he had issue with it at some point
10:22 Joubu ashimema: just try kyle's patch:
10:22 Joubu tried*
10:22 Joubu if there is only 1 matching row, the find works
10:22 Joubu but if there are 2, I get a warning: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row.  SQL that returns multiple rows is DEPRECATED for ->find and ->single at line 584
10:22 Joubu and the last matching row is picked
10:22 Joubu nope, the first matching row!
10:24 alex_a_ joined #koha
10:25 cait in theory... that shouldn't happen
10:25 cait could we only set the column to unique?
10:25 cait without primary?
10:25 cait so have it unique and then the PK definition in the DBIX config?
10:26 ashimema so yeah.. the issue is why wuold you ever need/want duplicate borrowernumbers?
10:26 ashimema in the deleted_borrowers table
10:26 ashimema are you thinking people should be able to re-use borrowernumbers once the original user with that number has been deleted
10:26 Joubu I do not want or need, but it can happen
10:27 ashimema how can it happen
10:27 * ashimema thinks he may have seen it.. but can't understand where it came from
10:27 cait no
10:27 cait ashimema: cardnumbers - yes, but not borrowernumbers
10:27 Joubu the problematic use case: 1. install Koha, 2. Create a test patron, 3. Delete it. 4. Next day (after server reboot) Create a patron (get the same borrowernumber as the first one), 5. Delete it => boom
10:28 ashimema primary key should be borrowernumber :)
10:28 ashimema i can totally understand re0using cardnumbers
10:28 Joubu yes, it is
10:28 ashimema erm
10:28 ashimema after a server reboot
10:28 ashimema is mysql that bad
10:28 Joubu borrowernumber is the PK, but the fact that it is automatically set by AI will cause this problem
10:29 ashimema I thought it was an auto_increment primary key
10:29 ashimema AI?
10:29 wahanui AI is 42, add a patron, will be 42. AI is now 43. Delete it via the cli, AI is still 43
10:29 Joubu if mysql is restart and the table is empty, AI is reset
10:29 Joubu auto increment
10:29 Joubu forget AI
10:29 wahanui Joubu: I forgot ai
10:29 Joubu AI is Auto Increment
10:29 ashimema oh god.. AI is horrible in mysql
10:30 ashimema that wouldn't happen in postgres
10:30 ashimema it's ai is 'safe'
10:30 ashimema you have to work really hard in postgres to get such a cock up
10:31 Joubu we could deal with that at code level I guess, and force the borrowernumber when inserting it, if already exist in deletedborrowers
10:31 Joubu but that is awful
10:32 ashimema yeah.. that's not nice at all
10:33 ashimema ack.. i can't think of a nice way around this then :(
10:34 ashimema I wonder if ribasushi has ever come up against this sort of issue?
10:34 ashimema we 'could' use guid's
10:35 ashimema but that sorta feels really nasty too
10:39 tcohen joined #koha
10:39 tcohen morning
10:40 tcohen @wunder anisacate, argentina
10:40 huginn tcohen: Error: HTTP Error 404: Not Found
10:40 drojf hi tcohen and ashimema
10:40 magnuse ¡hola tcohen!
10:40 magnuse @wunder enbo
10:40 tcohen hola magnuse drojf and ashimema
10:40 huginn magnuse: The current temperature in Bodo, Norway is 7.0°C (11:20 AM CET on January 27, 2017). Conditions: Scattered Clouds. Humidity: 81%. Dew Point: 4.0°C. Windchill: 2.0°C. Pressure: 29.95 in 1014 hPa (Steady).
10:40 magnuse \o/
10:40 * ashimema is in his next call
10:41 tcohen ashimema: YAY
10:41 drojf yay calls. i did that yesterday, like half the day
10:41 tcohen @wunder ARXX1831
10:41 huginn tcohen: Error: HTTP Error 404: Not Found
10:41 tcohen ok
10:41 tcohen @wunder cordoba, argentina
10:41 huginn tcohen: The current temperature in Cordoba, Argentina is 11.0°C (7:00 AM ART on January 27, 2017). Conditions: Clear. Humidity: 88%. Dew Point: 9.0°C. Pressure: 30.18 in 1022 hPa (Steady).
10:41 drojf heh huginn is not happy today
10:43 Joubu ashimema, and for the record: bug 18003
10:43 huginn Bug[…]_bug.cgi?id=18003 enhancement, P5 - low, ---, gmcharlt, NEW , Should deletedborrowers.borrowernumber be a primary key?
10:46 Joubu alex_a_: you could have found a more exiting bug for 18000!
10:47 ashimema we 'could' mark borrowers in the borrowers table as deleted instead of having a deleted_borrowers table at all.. that would maintain integrity?
10:47 ashimema but it's a fairly drastic change
10:48 ashimema I'm not fully in the loop on why we're worrying about it all right now ;)
10:48 Joubu ashimema: I have brought this discussion last year, it did not interest lot of people
10:51 Joubu ashimema: I have explained on 18003 the problem and the different solutions I have in mind. I have also attached an example of why we need it
10:52 alex_a_ Joubu: we make great a thing by doing many small ones
10:52 alex_a_ -a
10:53 marcelr bug 18000
10:53 huginn Bug[…]_bug.cgi?id=18000 enhancement, P5 - low, ---, alex.arnaud, Needs Signoff , Add --tablename option to misc/devel/ script
10:53 marcelr aiming for bug 20000
10:53 huginn Bug[…]_bug.cgi?id=20000 could not be retrieved: InvalidBugId
10:55 marcelr who is signing off this trivial one: bug 17982
10:55 huginn Bug[…]_bug.cgi?id=17982 minor, P5 - low, ---,, Needs Signoff , Fix the use of uniq in sub themelanguage
10:55 tcohen alex_a_: hehe
10:55 tcohen Joubu, regarding 13757
10:55 tcohen my work was to resurrect that work
10:55 tcohen the plan to refactor some controller scripts and templates was left for later on purpose
10:56 marcelr @later tell kidclamp: please try bug 17980 for me
10:56 huginn marcelr: The operation succeeded.
10:56 Joubu tcohen: yep, seen your answer :)
10:56 Joubu tcohen: is it on your todolist? :D
10:57 tcohen of course
10:57 tcohen I started with CheckUniqueness
10:58 alex_a_ Joubu: What is fixed in new version of DBIx::Class::Schema::Loader ?
10:58 alex_a_ Never said that there was a bug in DBIx::Class::Schema::Loader
11:00 Joubu alex_a_: it will not modify the timestamp and so the md5sum unless modified
11:00 Joubu so you won't see all the schema files on git status
11:08 Joubu tcohen: found a bug, must be trivial to fix
11:08 tcohen Joubu: tell me
11:09 Joubu tcohen: I let a comment
11:09 tcohen Joubu: thanks!
11:10 tcohen most issues are related to how tied is the data model to the page structure
11:10 tcohen that's why this deserves to be rewritten on top of the REST api IMHO
11:11 Barrc left #koha
11:20 kmlussier joined #koha
11:37 Joubu khall: Hi! Can I get your opinion on bug 15545 please? See last comment
11:37 huginn Bug[…]_bug.cgi?id=15545 enhancement, P5 - low, ---,, Signed Off , Optionally make hold notes required when placing a hold (via Koha::Plugin)
11:37 khall sure!
12:03 rsantellan joined #koha
12:13 marcelr joined #koha
12:26 paul_p joined #koha
12:39 tcohen oleonard++
12:39 tcohen1 joined #koha
12:39 * tcohen1 loves to see more people contributing to make kohadevbox better
12:44 oleonard joined #koha
12:47 tcohen hi oleonard, thanks for taking care of
12:48 oleonard Sure, thanks for the instructions on filing an issue.
12:48 tcohen ha
12:48 tcohen I think it might be time to move kohadevbox into the koha repositories now that some people use it
12:48 tcohen and have a more koha-ish qa workflow
12:49 * tcohen loves superpowers, though
12:49 oleonard :D
12:49 oleonard Oh cool, updated VirtualBox Guest Additions getting installed automatically
12:50 * cait loves kohadevbox :)
12:51 tcohen finally!
12:52 meliss joined #koha
12:52 cait :P
12:54 * oleonard brb
12:54 oleonard quit
12:56 jzairo joined #koha
13:04 tcohen1 joined #koha
13:07 alex_a joined #koha
13:14 marcelr khall: not sure if i understand your comments on bug 15545 about odd behavior
13:14 huginn Bug[…]_bug.cgi?id=15545 enhancement, P5 - low, ---,, Signed Off , Optionally make hold notes required when placing a hold (via Koha::Plugin)
13:15 khall marcelr: as in the change is very very specific, and not general. It decides if one hold field is required, rather than all hold fields in general
13:16 marcelr yes, so a good reason for a plugin, yes?
13:18 misilot joined #koha
13:18 khall marcelr: pluggability should be for the controlling behavior, not for the action imo. I'm trying to say if the plugin hook could be used to decide if any given hold form field should be required it would make more sense to me. That being said, I'm not opposed to it the way it works atm. I'm wondering if maybe HEA should be able to track installed plugins, that would be useful
13:18 marcelr ok thx
13:19 cait plugin popularity - dokuwiki does that
13:23 mtompset_testing joined #koha
13:23 cait it's helpful when seleting a new plugin you want to use
13:23 magnuse plugins++
13:24 mtompset @seen tcohen
13:24 huginn mtompset: tcohen was last seen in #koha 33 minutes and 2 seconds ago: <tcohen> finally!
13:24 mtompset Greetings, #koha.
13:27 oleonard joined #koha
13:30 edveal joined #koha
13:30 edveal Hello
13:30 wahanui salut, edveal
13:32 tcohen hi mtompset
13:33 mtompset I'm just looking at your comment on the kohadevbox issue, tcohen
13:33 mtompset Personally, I'd just perfer a way to install the latest JRE as needed. The whole xenial/!xenial split is too rigid.
13:34 mtompset ^perfer^prefer^
13:35 tcohen joined #koha
13:37 edveal Happy Friday!
13:38 magnuse \o/
13:38 nengard joined #koha
13:39 * LibraryClaire does a Friday dance
13:40 tcohen mtompset: for ES 2.x+ we are pulling the Oracle Java runtime
13:40 * mtompset frowns.
13:40 mtompset Sorry, different context.
13:40 mtompset I can't sudo apt-get upgrade my kohadevbox.
13:41 mtompset it keeps barfing on koha-common
13:44 NateC joined #koha
13:55 paul_p joined #koha
14:06 misilot_ joined #koha
14:06 misilot__ joined #koha
14:06 kellym joined #koha
14:14 pastebot "mtompset" at pasted "Current 'vagrant up xenial' failure" (2 lines) at
14:15 tcohen mtompset: i got the same
14:15 tcohen vagrant xenial provision
14:15 tcohen should make it continue
14:17 mtompset Hmm... it had a skipping on that step this time. I'll have to check when it is finished.
14:18 JoshB joined #koha
14:18 kholt joined #koha
14:28 mtompset Hmmm.. same problem for Jessie.
14:29 mtompset When is the last time someone actually tried koha-create on a normal git clone?
14:29 tcohen something changed in the return value for koha-create
14:29 mtompset Yep. About to try to track that down.
14:36 kmlussier joined #koha
14:44 Joubu Is the pagination of the search result broken on the staff interface?
14:44 Joubu master
14:45 cait can't test right now
14:45 Joubu ha that may be caused by bootstrap3
14:45 Joubu I get 1 page per line, it's ugly
14:45 cait lucky we pushed early
14:46 LibraryClaire Joubu me too
14:47 Joubu ok confirmed it's bootstrap
14:48 Joubu josef_moravec: any chances you could take a lookt?
14:48 Joubu bug 18005
14:48 huginn Bug[…]_bug.cgi?id=18005 major, P5 - low, ---, gmcharlt, NEW , Pagination of the search result displayed wrong
14:50 gaetan_B joined #koha
14:52 jac joined #koha
14:54 drojf is it possible to get item info in OAI?
14:54 tcohen yes
14:55 tcohen in extended mode
14:55 tcohen
14:55 tcohen it is not properly documented
14:56 drojf i found bug 12252
14:56 huginn Bug[…]_bug.cgi?id=12252 enhancement, P5 - low, ---, robin, CLOSED FIXED, OAI-PMH GetRecord result doesn't include item data
14:56 drojf thanks, will have a look
14:58 tcohen include_items: 1
14:58 tcohen we should definitely ship a sample extended configuration file
14:59 Joubu Is bug 17978 a bug?
14:59 huginn Bug[…]_bug.cgi?id=17978 major, P5 - low, ---, koha-bugs, REOPENED , Circ rules will not limit holds
14:59 Joubu placerequest is added reserve without checking if the patron can still place a hold
14:59 misilot joined #koha
14:59 Joubu So if you are placing several holds in once row, there is no check...
15:00 Joubu well, there is 1 check. So if the patron can place 1 hold, he is able to place X holds
15:00 Joubu I guess it's a long standing bug
15:01 mtompset tcohen: I think it is the koha-start-zebra that is the broken this, not the create.
15:01 mtompset I vaguely recall worrying about that return 0 || return 1 mess.
15:02 eythian what is that?
15:02 eythian no one should ever write return 0 || return 1 I'm sure
15:02 tcohen mtompset: did you sign my patches removing koha-start-zebra already=?
15:03 mtompset don't recall anything. :)
15:03 mtompset just looking at the debian scripts file.
15:04 mtompset eythian: koha-start-zebra
15:04 pastebot "mtompset" at pasted "yuckiness" (15 lines) at
15:05 eythian ah
15:05 eythian that's legit
15:05 eythian it's not nice, but it's legit
15:05 drojf beer o'clock
15:05 wahanui rumour has it beer o'clock is a vital part of the Koha development process
15:06 tcohen mtompset: bug 17467
15:07 huginn Bug[…]_bug.cgi?id=17467 enhancement, P5 - low, ---, tomascohen, Needs Signoff , There should be a koha-zebra script to handle Zebra daemons for instances
15:07 mtompset So daemon returns non-zero and the && return 0 || return 1 toggles the value to a success (0) or failure (1)
15:07 mtompset ?
15:12 eythian yeah, it's left-associative. So if the daemon call is successful, it returns 0, else returns 1.
15:12 eythian I'd probably put it in an if for clarity myself.
15:14 mtompset Why if? Why not return $?;
15:14 Dyrcona joined #koha
15:17 LibraryClaire left #koha
15:17 tcohen mtompset: you provided a followup for 17467, do u plan to sign it?
15:18 eythian if you could return $?, then you wouldn't need the && || stuff anyway, you'd just return the value from daemon.
15:19 eythian you could put an if catching $?, that's probably not terrible.
15:19 eythian I'd just move everything to systemd units myself :)
15:23 mtompset tcohen: probably not? my kohadevboxes are down.. it will take 3 hours to get them back.
15:24 cait looking at indicators for
15:24 cait how do you interpret 3?
15:24 cait 'no note, added entry'?
15:24 cait "Whether a note and/or an added entry is generated from the field." not sure what that means really
15:25 fridolin left #koha
15:36 tcohen1 joined #koha
15:36 tcohen1 cait: that's left to the readers interpretation
15:40 alex_a joined #koha
15:40 drojf MARCfight!
15:40 * drojf throws MARC at cait
15:41 alex_a joined #koha
15:42 drojf have a nice weekend #koha
15:45 cait tcohen: afraid so
15:45 tcohen you are the reader this time, sorry
15:58 TGoat joined #koha
15:58 LibraryClaire joined #koha
16:04 reiveune bye
16:04 reiveune left #koha
16:05 * ashimema sits back to watch the MARC fight progress
16:06 * ashimema wonders if there's popcorn available ;)
16:14 mtompset Hmm... what is the difference between 2 and 3, cait?
16:15 cait no idea
16:15 tcohen mtompset: 1
16:15 mtompset Okay, re-reading it again... tcohen this is the MARC mess.
16:16 mtompset It seems to me that 0 and 2 must always have a second indicator of #.
16:16 tcohen 3 - 2 = 1
16:17 mtompset Where as 1 and 3 -- yes, yes, I got that, but that's not relevant to the context I'm thinking -- must have something saying what kind of title is generated.
16:17 cait like a $i?
16:17 cait where are you getting this from?
16:18 mtompset I'm just reading the link you gave.
16:19 mtompset I'm not a librarian, so I don't know.
16:19 cait hm When displayed/printed as a note, varying forms of titles are usually preceded by                an                introductory term or phrase that is generated as a display constant based on the second                indicator value.
16:19 cait but that's 0 and 1
16:20 cait and there is an example of 3 with the second indicator set
16:20 mtompset Oh, 245 isn't repeatable.
16:21 mtompset I would treat 246 like 245's if they could repeat. :)
16:21 mtompset But remember, I'm not a librarian, so I know squat in MARC. :)
16:21 tcohen can we invoke jcamins?
16:22 mtompset Oooo.... jcamins the demi-god of cataloguing.
16:24 tcohen need to spell his name three times I think
16:26 * druthb invokes the jcamins
16:26 * oleonard sets out a plate of freshly-baked cookies to lure jcamins
16:27 tcohen jcamins
16:28 tcohen jcamins
16:28 tcohen jcamins
16:29 jbeno joined #koha
16:30 mtompset I even posted on FB. :P
16:31 * tcohen is parsing the telephatic answer from Jared
16:31 * mtompset grins.
16:31 tcohen "The title entered is searchable but will not be shown.
16:31 tcohen For example:
16:31 tcohen 245 10 $a Apples & bears
16:31 tcohen 246 33 $a Apples and bears
16:31 tcohen That is a made up example, of course.
16:31 tcohen "
16:31 tcohen cait ^^^ that's for you
16:34 cait ah
16:34 cait is that in the docs somewhere that it should not be shown?
16:34 cait I'd file a bug then
16:38 tcohen that's Jared's understanding
16:38 cait ok
16:38 cait that suits me fine actually :)
16:39 cait is that for indicators 3 and 5?
16:39 cait 3 and 4?
16:39 wahanui 7
16:39 cait or only for 3?
16:40 cait hm think only 3
16:42 barton I have a yaz-client question -- the syntax for specifying a server, either on the command line or with 'open', is [(tcp|ssl|unix|http)':']host [:port][/base] ... but when connecting to a unix socket, the '/base' part (e.g. /biblios) isn't distinguishable from part of the socket path. yaz-client unix:/var/run/koha/switch/bibliosocket/biblios doesn't work.
16:42 cait oh
16:42 cait bug 18000
16:42 huginn Bug[…]_bug.cgi?id=18000 enhancement, P5 - low, ---, alex.arnaud, Needs Signoff , Add --tablename option to misc/devel/ script
16:42 cait not very spectacular :)
16:43 cait but nice anyway
16:43 wahanui nice is perhaps not as enthusiastic of a word as I meant
16:43 cait bug 18006
16:43 huginn Bug[…]_bug.cgi?id=18006 enhancement, P5 - low, ---, gmcharlt, NEW , MARC21: Don't show 246 when 1st indicator = 3
16:44 oleonard On to 19000
16:44 barton is there a way of specifying the database to connect to in yaz-client when we're using sockets?
16:45 barton I tried yaz-client unix:/var/run/koha/switch/bibliosocket /biblios, but that caused unhappiness.
16:46 barton I figured if I left an empty port, the colon would act as a delimiter:
16:46 barton yaz-client unix:/var/run/koha/switch/bibliosocket:/biblios didn't work either.
16:52 CrispyBran joined #koha
16:54 kellym joined #koha
16:55 sophie_m joined #koha
17:01 rocio joined #koha
17:03 kidclamp @wunder 05001
17:03 huginn kidclamp: The current temperature in Wilder Street, Hartford, Vermont is 3.4°C (12:02 PM EST on January 27, 2017). Conditions: Overcast. Humidity: 54%. Dew Point: -5.0°C. Windchill: 3.0°C. Pressure: 29.39 in 995 hPa (Falling).
17:05 oleonard Hi kidclamp
17:06 kidclamp hi oleonard
17:06 wahanui hi olé onard
17:12 josef_moravec left #koha
17:14 cait joined #koha
17:17 abbfla66 joined #koha
17:18 * mtompset curses apparmour and mysql not playing nice.
17:28 kellym joined #koha
18:10 laurence left #koha
19:01 talljoy joined #koha
19:28 oleonard Oh hey look Bug 17942 still needs a signoff.
19:28 huginn Bug[…]_bug.cgi?id=17942 enhancement, P5 - low, ---, oleonard, Needs Signoff , Update style of the web installer with Bootstrap 3
19:55 mtompset oleonard: I get a conflict
19:55 oleonard Dang.
19:56 mtompset oops...
19:56 mtompset typo
19:56 mtompset That's why.
19:56 mtompset Sorry for the heart attack. ;)
20:14 eythian @later tell drojf weirdos:[…]fore-world-war-ii
20:14 huginn eythian: The operation succeeded.
20:17 eythian bag: a correction about your Let's Encrypt press release: you're hopefully using TLS and not SSL.
20:17 bag :)
20:18 bag I wasn’t sure all the readers understood TLS so I went simple
20:18 bag that was probably my mistake
20:19 eythian But wrong to us pedants! Boo! Hiss! ;)
20:22 mtompset Okay, eythian edumacate me. TLS != SSL, explain the diff.
20:24 eythian You'd be better to look them up, my explanation will be a bit half arsed. The essence is that TLS is similar to, and the successor to, SSL. I think mostly SSL isn't able to do certain things that TLS can.
20:25 eythian (I want to say SNI is one of those, but I'm not sure.)
20:25 mtompset And potential legal issues with Netscape having SSL trademark or something?
20:26 eythian Not at all to my knowledge.
20:26 eythian But my knowledge isn't great on this.
20:26 eythian I should learn about it.
20:27 mtompset ""SSL" means "Secure Sockets Layer". This was coined by the inventors of the first versions of the protocol, Netscape (the company was later bought by AOL)." (http://security.stackexchange.[…]sl-tls-and-https)
20:29 mtompset eythian: You got a Xenial Kohadev box? :)
20:29 eythian I have no koha dev box at the moment
20:30 mtompset *gasp* I was curious if you could play with bug 17260, as it seems to make the installation process succeed for the Xenial Kohaev box. :)
20:30 huginn Bug[…]_bug.cgi?id=17260 major, P5 - low, ---, philippe.blouin, Needs Signoff , fails on invalid entries in ENUM and BOOLEAN columns
20:30 eythian I'm building a cluster, and when I get the infrastructure sorted, I'm going to have a go at splitting koha up to fit in it.
20:31 mtompset splitting, as in putting the DB on a different machine?
20:31 eythian Putting everything that can be separated on a different machine.
20:31 eythian My cluster is built of tiny machines
20:31 mtompset ooo... in that case, do I have a bug for you!
20:31 mtompset bug 16690
20:31 huginn Bug[…]_bug.cgi?id=16690 minor, P5 - low, ---, mtompset, Needs Signoff , Installing DB on remote server fails without *.* permissions
20:33 eythian Hmm, that looks like a problem. That'll hit many people.
20:34 mtompset And yet, no one has signed off for months. :(
20:34 eythian Well, I'll look at it if I get my system properly designed and built any time soon :)
20:37 bag yeah we do that eythian
20:37 mtompset That would make me happy. :)
20:38 bag currently zebra is a bit of a limitation in clustering and plack…  you need plack for every instance so you sort of suck up memory…  We need the single plack for multiple instances
20:38 bag can’t wait for ES - then clustering will be loads of fun ;)
20:40 mtompset Have a great day, #koha bag eythian
20:40 eythian bag: catalyst too (unless things have changed, but I doubt it.)
20:41 eythian Yeah, the namespacing of instances needs to be moved more into koha itself to solve that.
20:41 eythian Not impossible.
20:42 * eythian has moved into the team building the new highly containered Perl infrastructure at work, and is starting to develop Opinions on it.
20:43 eythian It's a crazy world at huge scale.
21:04 misilot_ joined #koha
21:33 sdlib joined #koha
21:34 sdlib how long does it take a quick slip update to take effect?
21:36 sdlib tried to edit 'issue quick slip' (print) and it did nothing, that was 2 hours ago
21:40 bag you probably have to restart memcached
21:40 sdlib ??
21:41 bag sdlib: is this san diego law library?
21:41 sdlib no
21:41 sdlib south dakota
21:42 bag ah SD cool - welcome
21:42 sdlib what is memchached, where is it, how do i restart it?
21:42 bag from the commandline on your server
21:43 sdlib hmm.... i am not sure i have access to that
21:44 sdlib our library's server?
21:44 bag yes where is koha hosted for you?
21:45 sdlib good question. so, basically i find out where koha is hosted for us and if it's something i have access to i restart memcached and if not i ask the people who host it for us to do it.
21:45 bag yes :)
21:45 sdlib i *think* we go through people called bywater solutions but idk if they do the actual hosting or not
21:46 bag cool yeah that’s us
21:46 sdlib i will find out. thanks!
21:46 kidclamp have a great weekend #koha
21:46 bag which library are you at now sdlib
21:46 bag I can get someone on that right away for you if you’re with bywater sdlib
21:47 sdlib Grace Balloch
21:48 bag perfect - yes you’re with us
21:48 bag we’ll get someone on that for you
21:48 sdlib thanks!
21:48 bag give me about 10 minutes and you should now see your changes
21:50 bag sdlib: restarted
21:51 sdlib ok i'll give it a few and see if i get the changes
21:52 JoshB left #koha
21:58 sdlib so is it configured to update after a certain amount of time or is it a manual thing? i think i changed the slips before several months ago and changes went through almost immediately
22:06 sdlib still no change
22:30 edveal left #koha
22:36 eythian @later tell LibraryClaire[…]ave-a-single-word
22:36 huginn eythian: The operation succeeded.
22:44 kmlussier joined #koha
22:50 * eythian wishes to remind you that the CPAN testing system is called CPANTS
22:50 eythian Because it's funny
23:18 jbeno_away joined #koha

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