![http://30.media.tumblr.com/tum[…]1qzo0vqo1_500.jpg](http://30.media.tumblr.com/tumblr_lt0pjtyFDn1qzo0vqo1_500.jpg){kind=link}
![http://wiki.koha-community.org[…]Kohastructure.png](http://wiki.koha-community.org/w/images/Kohastructure.png){kind=link}
![http://wiki.koha-community.org[…]Kohastructure.png](http://wiki.koha-community.org/wiki/File:Kohastructure.png){kind=link}
← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:08 | larryb_away joined #koha | |
| 00:16 | NateC joined #koha | |
| 00:36 | eythian | http://30.media.tumblr.com/tum[…]1qzo0vqo1_500.jpg |
| 01:16 | melia left #koha | |
| 01:30 | larryb_away left #koha | |
| 01:32 | miguelxercode joined #koha | |
| 01:41 | eythian joined #koha | |
| 01:47 | trea joined #koha | |
| 02:38 | rangi | right back after meetings and moving my desk back upstairs |
| 02:38 | wizzyrea | meetings, oy |
| 03:09 | jenkins_koha | Starting build 480 for job Koha_master (previous build: SUCCESS) |
| 03:09 | huginn | New commit(s) kohagit: Fix for Bug 6970 - logout not redirecting to login page <http://git.koha-community.org/[…]4898d57f678acf9f4> |
| 03:22 | Irma joined #koha | |
| 03:23 | Amit_Gupta joined #koha | |
| 03:23 | Amit_Gupta | heya gm |
| 03:23 | heya chris | |
| 03:28 | phlunk3 | have a great weekend everyone, gonna be busy helping clean up the beaches myself :/ seeyas |
| 04:10 | alohalog` joined #koha | |
| 04:10 | Topic for #koha is now Koha 3.4.5 is now available; Next General IRC Meeting 16 November 2011 at 02:00 UTC+0 | http://www.koha-community.org | http://paste.koha-community.org | |
| 04:30 | trea joined #koha | |
| 04:50 | Irma left #koha | |
| 05:06 | cait joined #koha | |
| 05:07 | cait | good morning #koha |
| 05:12 | Oak | good morning cait \o |
| 05:12 | cait | hi Oak :) |
| 05:12 | miguelxercode joined #koha | |
| 05:12 | rangi | eveninvg |
| 05:12 | -v | |
| 05:12 | trea | o/ morning cait |
| 05:12 | cait | hi trea and evening rangi |
| 05:12 | Oak | good evening rangi |
| 05:12 | rangi | holy crap trea |
| 05:12 | cait | yes, why are you awake? |
| 05:13 | rangi | I just finished beer o'clock and on the bus home |
| 05:14 | trea | looking at tickets |
| 05:14 | rangi | ahh |
| 05:14 | * wizzyrea | is awake too |
| 05:14 | wizzyrea | making teh opac secksee time. |
| 05:14 | cait | hi wizzyrea :) |
| 05:14 | rangi | youre a good man charlie brown |
| 05:15 | cait | tickets like air plane tickets or problem tickets? |
| 05:15 | rangi | id like to just note it |
| 05:15 | and this isn't the kilkenny talking | |
| 05:16 | the rea's are cool as hell | |
| 05:16 | wizzyrea | aww |
| 05:16 | cait | aw |
| 05:16 | :) | |
| 05:16 | wizzyrea | <3 |
| 05:16 | speaking of cool as hell | |
| 05:16 | catalog-test.nexpresslibrary.org | |
| 05:17 | cait | squeee :) |
| 05:17 | rangi | wooo |
| 05:18 | cait left #koha | |
| 05:18 | cait joined #koha | |
| 05:18 | wizzyrea | it was so cool she left |
| 05:18 | rangi | it was too cool |
| 05:18 | wizzyrea | oh good she's back! |
| 05:18 | rangi | snap! |
| 05:18 | cait | couldn't type |
| 05:18 | unhappy pidgin | |
| 05:18 | :) | |
| 05:18 | trea | aw shucks rangi |
| 05:18 | rangi | stop drinking then |
| 05:20 | wizzyrea | you should bean that pidgin |
| 05:21 | rangi | did you know |
| 05:21 | Oak | yes |
| 05:21 | rangi | in philadelphia |
| 05:21 | they sell pigeons | |
| 05:21 | wizzyrea | for eating? |
| 05:22 | trea | ^^snarktastic |
| 05:22 | Johnindy joined #koha | |
| 05:22 | wizzyrea | that's right, I went there. |
| 05:22 | rangi | yes |
| 05:23 | eatig | |
| 05:23 | but I had cheesesteak instead | |
| 05:23 | wizzyrea | you are wise. |
| 05:23 | cheesepigeon | |
| 05:24 | cait | eew |
| 05:25 | I didn't even had breakfast yet and you talk about eating pidgeons | |
| 05:25 | rangi | ill have a cheese with |
| 05:25 | I could live on those things | |
| 05:25 | * wizzyrea | suggests a healthy pop tart |
| 05:26 | cait | sorry, pop tarts are not available in your country... |
| 05:26 | wizzyrea | WUT |
| 05:26 | rangi | hmm can u get them in canadia |
| 05:26 | ? | |
| 05:27 | u can't get them here | |
| 05:27 | wizzyrea | (I don't actually really like pop tarts) |
| 05:27 | rangi | I should bring hokme some for lauel |
| 05:27 | wizzyrea | (I don't buy them anyway) |
| 05:27 | rangi | and learn o type |
| 05:28 | wizzyrea | look at that user account page... fabissimo: margin: 0 5px 5px 0 ; |
| 05:28 | no! | |
| 05:28 | stupid jing. | |
| 05:28 | http://screencast.com/t/lWpv9JHPh4 | |
| 05:28 | there we go | |
| 05:29 | cait | very nice :) |
| 05:29 | rangi | css3 is ur biatch |
| 05:29 | cait | fabissimo? :) |
| 05:29 | wizzyrea | word. |
| 05:29 | i lubs it | |
| 05:33 | rangi | @wunder wellington nz |
| 05:33 | huginn | rangi: The current temperature in Wellington, New Zealand is 11.0°C (6:00 PM NZDT on October 14, 2011). Conditions: Mostly Cloudy. Humidity: 76%. Dew Point: 7.0°C. Pressure: 29.83 in 1010 hPa (Rising). |
| 05:33 | rangi | lies |
| 05:34 | its pouring rain | |
| 05:34 | wizzyrea | hmm |
| 05:34 | cait | @wunder Konstanz |
| 05:35 | huginn | cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 7.7°C (7:34 AM CEST on October 14, 2011). Conditions: Mostly Cloudy. Humidity: 78%. Dew Point: 4.0°C. Windchill: 8.0°C. Pressure: 30.36 in 1028.0 hPa (Steady). |
| 05:35 | cait | oh |
| 05:35 | 7.7 | |
| 05:35 | rangi | @wunder vancouver bc |
| 05:35 | huginn | rangi: The current temperature in Vancouver, British Columbia is 10.0°C (10:00 PM PDT on October 13, 2011). Conditions: Overcast. Humidity: 87%. Dew Point: 8.0°C. Pressure: 30.09 in 1019 hPa (Falling). |
| 05:35 | rangi | I can live with 10 |
| 05:35 | kmkale joined #koha | |
| 05:36 | kmkale | Namaskar #koha |
| 05:36 | rangi | hi kmkale |
| 05:36 | kmkale | heya chris |
| 05:37 | rangi | how's the hand? |
| 05:37 | cait | hi kmkale :) |
| 05:38 | kmkale | hi cait |
| 05:39 | rangi: the cast comes off on monday. will know about further treatement ( if required ) then | |
| 05:39 | * rangi | hopes not |
| 05:39 | kmkale | me too :) |
| 05:39 | Oak | typing with one hand? |
| 05:40 | kmkale | yup the wrong one |
| 05:40 | rangi | my stop bbiab |
| 05:40 | Oak | uh oh |
| 05:54 | wizzyrea | trea says goodnight |
| 05:54 | :) | |
| 06:08 | ropuch | hdl: Morning #koha |
| 06:08 | uh | |
| 06:09 | Must h-tabbed hdl ;> | |
| 06:12 | alex_a | hi |
| 06:15 | ropuch | Hello alex_a |
| 06:18 | cait | hi all :) |
| 06:20 | ropuch | Guten morgen kf ;-) |
| 06:22 | alex_a | ropuch, cait \o |
| 06:23 | BobB_ | kmkale about? |
| 06:46 | reiveune joined #koha | |
| 06:46 | reiveune | bonjour |
| 06:48 | cait | hi reiveune :) |
| 06:49 | reiveune | hi cait, magnuse |
| 06:49 | cait left #koha | |
| 06:49 | magnuse | guten morgen reiveune and #koha |
| 06:59 | Guillaume joined #koha | |
| 06:59 | hdl joined #koha | |
| 07:06 | julian_m joined #koha | |
| 07:10 | asaurat joined #koha | |
| 07:11 | ropuch joined #koha | |
| 07:18 | clrh joined #koha | |
| 07:18 | clrh | hello |
| 07:18 | francharb joined #koha | |
| 07:19 | magnuse | bonjour clrh |
| 07:20 | francharb | hi all |
| 07:20 | hi magnuse | |
| 07:20 | magnuse | bonjour francharb |
| 07:21 | francharb | goddag (?) magnuse |
| 07:21 | ;) | |
| 07:21 | magnuse | francharb: two words: god dag ;-) |
| 07:23 | francharb | thanks magnuse (@wikitravel.org--) ;) |
| 07:23 | sophie_m joined #koha | |
| 07:26 | kf joined #koha | |
| 07:26 | kf | hi again #koha |
| 07:26 | paul_p joined #koha | |
| 07:26 | magnuse | guten morgen kf and paul_p |
| 07:26 | kf | bonjour paul_p |
| 07:26 | god morgen magnuse | |
| 07:27 | paul_p | bonjour magnuse & kf & everybody |
| 07:28 | miguelxercode joined #koha | |
| 07:31 | asaurat joined #koha | |
| 07:33 | kf | hi asaurat :) |
| 07:42 | kmkale joined #koha | |
| 07:45 | asaurat | hi kf! wie geht es dir ? :) |
| 07:45 | kf | gut, danke. und dir? |
| 07:45 | asaurat | sehr gut, danke! |
| 07:48 | one of my flatmates is leaving for Berlin next month (he'll stay there until April or something), I will have to prepare a survival guide for him, explaining, among other things, how to obtain the dreaded FREIZÜGIGKEITSBESCHEINIGUNG !! | |
| 07:48 | (even Mary Poppins would have a hard time with this one) | |
| 07:48 | miguelxercode left #koha | |
| 07:49 | kf | oh |
| 07:49 | is this a german thing you need to work here? | |
| 07:49 | sounds evil | |
| 07:50 | magnuse | sounds painful |
| 07:50 | asaurat | yeah, this testifies that you can move in and work in germany :p |
| 07:51 | kf | terrible paperwork? |
| 07:51 | asaurat | but I've been redirected to the wrong office several times... |
| 07:51 | kf | ah, yes, that sounds very painful |
| 09:22 | Guillaume left #koha | |
| 09:42 | kf | thx slef |
| 10:06 | clrh joined #koha | |
| 10:41 | miguelxercode joined #koha | |
| 10:41 | miguelxercode left #koha | |
| 11:04 | juan_sieira joined #koha | |
| 11:06 | magnuse | @arewethereyet |
| 11:06 | huginn | magnuse: Not yet - wait 8 days |
| 11:26 | tcohen joined #koha | |
| 11:26 | kf | ? |
| 11:30 | paul_p joined #koha | |
| 11:43 | nengard joined #koha | |
| 12:08 | jwagner joined #koha | |
| 12:18 | alex_a1 joined #koha | |
| 12:27 | JesseM joined #koha | |
| 12:27 | oleonard joined #koha | |
| 12:29 | NateC joined #koha | |
| 12:36 | trea joined #koha | |
| 12:49 | magnuse | kia ora americans |
| 12:52 | kf | kia ora |
| 12:52 | jwagner | hi magnuse and kf |
| 12:58 | magnuse | hiya jwagner |
| 13:01 | gmcharlt | kf: @arewethereyet is counting down the days until release |
| 13:05 | kf | gmcharlt: thx :) |
| 13:09 | miguelxercode joined #koha | |
| 13:09 | dschust1 joined #koha | |
| 13:10 | dschust1 | druthb |
| 13:15 | hdl | nengard: kf where are the notices refactoring notes ? |
| 13:15 | is there a due date ? | |
| 13:16 | kf | hdl: sorry, can you explain? |
| 13:16 | ah | |
| 13:16 | the notes | |
| 13:16 | oleonard | nengard: Bug 7030 = Bug 4045? |
| 13:16 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7030 enhancement, P5, ---, kyle.m.hall, NEW , maximum number of holds |
| 13:16 | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=4045 critical, P5, ---, gmcharlt, NEW , No check for maximum number of allowed holds. | |
| 13:16 | kf | it's on the wiki |
| 13:16 | let me find it for you | |
| 13:16 | notification overhaul? | |
| 13:17 | notifications overhaul is http://wiki.koha-community.org[…]aging_rewrite_RFC | |
| 13:18 | hdl | when should it be done ? |
| 13:18 | nengard | oleonard oh yeah - we have a sys pref for that |
| 13:18 | k | |
| 13:18 | oleonard | Not really--it doesn't work. |
| 13:18 | Hence Bug 4045 :( | |
| 13:19 | ...and it should be in the circ rules interface anyway | |
| 13:19 | kf | oleonard: nengard: evil bug :( having somehting configurable tht does not work :( |
| 13:19 | nengard | i think i'd rather see it on the circ martix page so it can be done on a branch by branch basis |
| 13:19 | kf | hdl: I th ink we talked about having another meeting after release |
| 13:19 | nengard | but i marked it as a dup for now |
| 13:19 | kf | hdl: because at the moment we are all a bit busy |
| 13:20 | hdl: and then identify chunks of work and make some plan | |
| 13:20 | hdl | ok |
| 13:21 | alex_a joined #koha | |
| 13:27 | hdl | kf when should the next meeting take place ? |
| 13:27 | kf is there any schedule ? | |
| 13:27 | maximep joined #koha | |
| 13:27 | kf | hdl: oyu might want to ask on the mailing list or libsysguy - I think we have not decided on a date |
| 13:28 | sekjal joined #koha | |
| 13:28 | nengard | did we decide not to email signed off patches? Or is that still being discussed? I just emailed one and then thought maybe I shouldn't have |
| 13:29 | oleonard | nengard: I wonder if that's on the agenda for the holds rewrite (speak of the devil) |
| 13:29 | nengard | it might be |
| 13:29 | that was before i started writing the specs :) so I don't know for sure | |
| 13:30 | hdl | oleonard: nengard good news is that we have some patches for 4045. |
| 13:30 | nengard | woooo hooooo |
| 13:30 | magnuse | bug 4045 |
| 13:30 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=4045 critical, P5, ---, gmcharlt, NEW , No check for maximum number of allowed holds. |
| 13:31 | hdl | http://git.biblibre.com/?p=koh[…]imoges/bug/MT7053 |
| 13:31 | Maybe someone can take that on... | |
| 13:31 | bad news is that it is still H::T::Pro. | |
| 13:34 | sekjal | hdl: is the BZ number on the commit? |
| 13:35 | hdl | sekjal: I was not even aware that it was referenced on bugzilla ? |
| 13:36 | sekjal | hdl: just trying to find the right bit of code on that branch that applies to 4045 |
| 13:40 | hdl | begins at this patch |
| 13:40 | 60c5d5ca838b94d9db9b9b8489c8603581ed6df6 | |
| 13:40 | all those are related to that bug. | |
| 13:40 | It has been done with xercode. | |
| 13:42 | talljoy joined #koha | |
| 13:42 | hdl | sekjal: just hopes that helps. |
| 13:42 | sekjal | awesome, thanks hdl |
| 14:20 | jcamins | Good morning, #koha |
| 14:20 | magnuse | hiya jcamins |
| 14:22 | kf | hi jcamins :) |
| 14:23 | hi sekjal | |
| 14:23 | and thx nengard :) | |
| 14:23 | nengard++ | |
| 14:23 | nengard | np |
| 14:24 | sekjal | morning, kf! |
| 14:34 | miguelxercode left #koha | |
| 14:43 | kf | jcamins: around? |
| 14:43 | jcamins | kf: I am. |
| 14:46 | aarkerio joined #koha | |
| 14:57 | jcamins | kf: did you have a question? |
| 14:57 | hdl | sekjal: is there a "share with/share on" delicious / twitter / and so on feature planned somwhere ? |
| 14:58 | sekjal | hdl: that is possible from either SearchForTitleIn or OPACMySummaryHTML |
| 14:58 | since they can process the BIBLIONUMBER token | |
| 14:59 | just wrap whatever service's API code in there, and provide the link back to the material you want to share | |
| 14:59 | jcamins | But do consider the privacy implications of that decision. |
| 15:00 | magnuse | here's an example: http://wiki.koha-community.org[…]OPACMySummaryHTML |
| 15:00 | hdl | http://wiki.koha-community.org[…]OPACMySummaryHTML |
| 15:00 | jcamins | (the decision to include a share feature... apparently the Facebook button notifies Facebook every page you look at, even if you don't click it) |
| 15:00 | magnuse | and there is http://manual.koha-community.o[…]OPACMySummaryHTML |
| 15:01 | aarkerio | hi! in which table MARC info is saved? |
| 15:01 | magnuse | jcamins: but this should be pretty safe: <a href="http://www.facebook.com/sharer[…].pl?biblionumber={BIBLIONUMBER}">Share on Facebook</a> |
| 15:01 | aarkerio: several... | |
| 15:01 | jcamins | magnuse: yep. |
| 15:02 | reiveune | bye |
| 15:02 | magnuse | aarkerio: marc_subfield_structure and marc_tag_structure are the main suspects |
| 15:02 | reiveune left #koha | |
| 15:02 | aarkerio | I am saving an info in tab 6 -> SUBJECT ADDED ENTRY--PERSONAL NAME + − -> Numeration |
| 15:02 | hdl | thanks folks |
| 15:03 | magnuse | aarkerio: there is also biblio_framework, which is just the names of frameworks |
| 15:03 | aarkerio | and I am making an SQL report and I like to add it |
| 15:03 | magnuse | aarkerio: see http://schema.koha-community.org/ for a pretty view of the gory details |
| 15:03 | aarkerio | is this the current scheme? |
| 15:03 | http://wiki.koha-community.org[…]Kohastructure.png | |
| 15:04 | jcamins | aarkerio: see the following: |
| 15:04 | sql reports library? | |
| 15:04 | wahanui | well, sql reports library is at http://wiki.koha-community.org[…]L_Reports_Library |
| 15:04 | jcamins | ^^ that |
| 15:04 | aarkerio | thanx! |
| 15:05 | magnuse | aarkerio: http://wiki.koha-community.org[…]Kohastructure.png says 2010-05-10 and "This is just the first 54 of 116 tables in kohastructure.sql" |
| 15:06 | nengard | and that was over a year ago too |
| 15:07 | things have changed a little | |
| 15:07 | magnuse | 3.4 had more than a 100 db changes, i seem to recall? |
| 15:11 | Oak joined #koha | |
| 15:11 | magnuse | Oak |
| 15:11 | Oak | magnuse |
| 15:11 | :) | |
| 15:17 | kf, http://www.youtube.com/watch?v=GGMHSbcd_qI | |
| 15:18 | rhcl | Oak! |
| 15:18 | Oak | rhcl :] |
| 15:21 | chris_n | wow, rolling back from the package maintainer's version of a pm to the cpan version can be a real chore :P |
| 15:24 | rhcl | wheels of progress rolling backwards? |
| 15:25 | chris_n | actually the package maintainer is a couple of years behind |
| 15:30 | it was worth the trouble, though.... fixed a bugger of a bug | |
| 15:33 | * magnuse | is slightly curious about what the pm was... |
| 15:34 | alex_a left #koha | |
| 15:42 | chris_n | magnuse_afk: Catalyst |
| 15:42 | the bug had to do with quoting mysql field names when using dotted notation | |
| 15:46 | maximep left #koha | |
| 15:49 | melia joined #koha | |
| 15:50 | maximep joined #koha | |
| 15:53 | oleonard | Of interest? https://github.com/visionmedia/git-extras |
| 15:54 | wizzyrea | oh |
| 15:54 | that 'git feature blah' thing looks pretty hawt | |
| 15:55 | * oleonard | couldn't get it to work, himself |
| 15:55 | wizzyrea | well i'm not sure it works with repos other than github |
| 15:55 | oleonard | But I are not smrt. |
| 15:55 | wizzyrea | it seems to be designed for work with github |
| 15:56 | i'm sure one of our leet haxxors could mod it to work with our git tho :P | |
| 16:00 | francharb left #koha | |
| 16:01 | oleonard | Ah, I guess I didn't read that far :P |
| 16:01 | * oleonard | being a Drupal user should be accustomed by now to things which don't explain what they do |
| 16:04 | libsysguy joined #koha | |
| 16:04 | libsysguy | sekjal? |
| 16:04 | wahanui | it has been said that sekjal is someone's favorite propeller-head. |
| 16:04 | sekjal | hey, libsysguy |
| 16:04 | wahanui | libsysguy is Koha's hottest developer or partying with swedes on his deck |
| 16:04 | libsysguy | heh that never gets old |
| 16:04 | sekjal | wahanui? |
| 16:04 | wahanui | yes, sekjal? |
| 16:05 | wizzyrea | hehe |
| 16:05 | libsysguy | anyway I saw where you changed hourly…just wondering what I should do to get it in |
| 16:05 | or if I even can do anything | |
| 16:05 | sekjal | libsysguy: feel like fixing the merge conflicts with current master? |
| 16:05 | libsysguy | well I've done it 3 times already so I've gotten pretty good at it |
| 16:07 | every time I merge I get a conflict with kohaversion and updatedatabase | |
| 16:07 | but when I merged the first time I had to resolve those | |
| 16:07 | it took about 20 mins | |
| 16:08 | the majority of the tt ones are changes to the [% ( var ) %] style | |
| 16:08 | sekjal | ah, okay |
| 16:09 | I only looked at one conflict, then decided I should just report it, rather than try to slog through fixing each | |
| 16:11 | libsysguy | yeah they weren't bad…some whitespace conflicts |
| 16:11 | * wizzyrea | wants the ability to add a parameter to koha-disable instancename -note"ETA to return: X hours" |
| 16:11 | wizzyrea | and have the note show on the maintenance page |
| 16:11 | jcamins | wizzyrea: brilliant! |
| 16:11 | libsysguy | but I can set up a master based install and merge hourly if that will help |
| 16:11 | jcamins | wizzyrea: I'll sign off over the weekend. :) |
| 16:12 | libsysguy | wizzyrea: can we make it a function of the maintainers average typing speen |
| 16:12 | speed** | |
| 16:12 | wizzyrea | lol |
| 16:12 | ropuch | wizzyrea: I was looking for such feture 10 minutes ago ;> |
| 16:12 | *feature | |
| 16:12 | wizzyrea | how funny |
| 16:12 | well in that case your note would be "ETA to return X hours from XX:XX" | |
| 16:13 | ropuch | Is there any on/off switch for opac? Even without eta? |
| 16:13 | wizzyrea | yea, in the sysprefs |
| 16:13 | opacmaintenance or somethin | |
| 16:13 | sekjal | libsysguy: any rebasing work you can do is greatly appreciated |
| 16:13 | wizzyrea | I always search for "maintenance" in the sysprefs. |
| 16:13 | sekjal | wizzyrea: what if we make OpacMaintenance syspref text, instead of YesNo? |
| 16:14 | wizzyrea | or an additional "maintenance text" syspref |
| 16:14 | so, turn it on/off, and give your custom text | |
| 16:14 | that goes with the existing message | |
| 16:14 | libsysguy | sekjal ok, how would i go about submitting it? Would i just merge and then make a patch to push on that bug? |
| 16:14 | wizzyrea | we also need a staff maintenance mode |
| 16:14 | where it locks out everyone but superlibrarians | |
| 16:16 | ropuch | wizzyrea: Oh, I misread this syspref, I was sure it defines the Koha behavior IF there is a maintenance, not actually switching it ;> |
| 16:16 | wizzyrea | :) |
| 16:17 | sekjal | libsysguy: hmmm, not sure the best way to handle that. |
| 16:17 | libsysguy | if only this patch wasn't so massive |
| 16:18 | sekjal | there has got to be a way to encapsulate the merge conflict fixes in a patch, so it can just be added as a followup to the topic branch |
| 16:18 | jcamins | sekjal: libsysguy: I had to ask rangi to do it for me for the analytic code. |
| 16:18 | libsysguy | well i guess you could do a git add <conflict files> after merging |
| 16:19 | then when you commit it would just add those files to the patch | |
| 16:19 | i think | |
| 16:20 | sekjal | libsysguy: that makes sense... do the merge, fix the problems, then format the merge commit as a patch |
| 16:20 | but it's probably not so simple | |
| 16:21 | libsysguy | it never is :-\ |
| 16:22 | jcamins | libsysguy: what about rebasing and squashing? Then you'd be left with just one commit. |
| 16:23 | libsysguy | so checkout hourly…merge with master then commit? |
| 16:23 | I'm surprised this hasn't come up before | |
| 16:25 | jcamins | No. |
| 16:25 | Checkout hourly, rebase -i onto Master, then commit. | |
| 16:25 | The issue is the merging. Usually it's rebase. | |
| 16:26 | libsysguy | hmm I have never done that before |
| 16:26 | but i can try it | |
| 16:28 | jcamins | libsysguy: it's something like: |
| 16:28 | git checkout -b bug_whatever ${HOURLYBRANCH} | |
| 16:28 | libsysguy | following... |
| 16:28 | jcamins | git rebase -i origin/master |
| 16:29 | It should pop up with a long list of commits in a text file. | |
| 16:29 | libsysguy | ok |
| 16:29 | jcamins | Set the first one to pick, and change the rest to squash. |
| 16:29 | Save and close. | |
| 16:29 | It will complain about errors. | |
| 16:30 | (merge errors) | |
| 16:30 | Fix them. | |
| 16:30 | git add the commits that conflicted. | |
| 16:30 | git commit. | |
| 16:30 | libsysguy | interesting |
| 16:30 | wahanui | interesting is good |
| 16:30 | jcamins | git-bz attach ${HOURLYBUG} HEAD |
| 16:31 | Disclaimer: I'm not entirely sure that will do anything like what I think it will. | |
| 16:31 | libsysguy | haha |
| 16:35 | kf left #koha | |
| 16:35 | jcamins | Let me know if my instructions work, by the way. |
| 16:39 | aarkerio | so I guess when I save a new MARC row the fields and values are created "on the fly", right? |
| 16:40 | libsysguy | jcamins I will…I just have to finish up this indexing engine for class |
| 16:40 | jcamins | aarkerio: yes. |
| 16:41 | aarkerio | but I can't find the table, is not marc_matchers table |
| 16:43 | jcamins | aarkerio: the data is stored in biblioitems. |
| 16:43 | sql reports library? | |
| 16:43 | wahanui | sql reports library is at http://wiki.koha-community.org[…]L_Reports_Library |
| 16:43 | jcamins | ^^ see that page for examples of how to extract MARC data. |
| 16:43 | I think it's the first section. | |
| 16:44 | aarkerio | I'll check, thanks! |
| 16:50 | * oleonard | looks forward to seeing Bug 7031 happen |
| 16:50 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7031 enhancement, P5, ---, ian.walls, NEW , More options for AdvancedSearchTypes |
| 16:51 | sekjal | oleonard: I have the patch; I'll put it up on the bug report, along with some screenshots |
| 16:52 | ropuch | Is there a painless way to bulk update marc records in Koha? |
| 16:55 | oleonard | there will be ropuch: Bug 5725 |
| 16:55 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5725 enhancement, PATCH-Sent, ---, paul.poulain, ASSIGNED , Batch modifications for Biblios |
| 16:57 | sekjal | oleonard: how's that one progressing? I see Paul did an updated patch, and you provided a followup. |
| 16:58 | ropuch | Hm, sounds nice |
| 16:58 | oleonard | Hmmm... I guess I didn't answer paul's question in the bug, about how the solve the 000 problem |
| 16:59 | * oleonard | thinks we're going to have to remove 000 from the options since it doesn't seem to work |
| 17:01 | sekjal | bulk edits to 000.... how desirable is that? |
| 17:02 | miguelxercode joined #koha | |
| 17:03 | trea joined #koha | |
| 17:05 | oleonard | sekjal: We have an ongoing project of hand-correcting 1000s of records with inaccurate 000 data |
| 17:05 | sekjal | ...ew |
| 17:05 | okay, so bulk editing is definitely a desirable thing | |
| 17:05 | so this patch needs to fix that, somehow | |
| 17:06 | cait joined #koha | |
| 17:06 | trea joined #koha | |
| 17:06 | oleonard | But, as I just commented on the bug, not a blocker for acceptance of the patch |
| 17:06 | Better to have it mostly working and exclude the option of editing 000 | |
| 17:07 | sekjal | is it working in all other regards? |
| 17:08 | oleonard | Oh wait, there was another outstanding issue... |
| 17:08 | cait | hi all :) |
| 17:08 | oleonard | Damn, I guess I didn't put that on the bug report either. |
| 17:08 | * oleonard | goes to dig through the IRC log |
| 17:19 | aarkerio | can I: |
| 17:19 | SELECT ExtractValue(marcxml,'//datafield[@tag="600"]/*'), biblio.author, biblio.title, biblioitems.isbn, items.barcode FROM biblio, biblioitems, items WHERE biblio.biblionumber=biblioitems.biblionumber AND biblio.biblionumber=items.biblionumber ORDER BY biblio.biblionumber; | |
| 17:19 | ? | |
| 17:20 | cait | what are you trying to do? |
| 17:20 | this looks a bit overly complicated | |
| 17:21 | hm, or perhaps it isn't | |
| 17:21 | reading it again | |
| 17:21 | does it work? | |
| 17:24 | sekjal | aarkerio: all the values in all the subfields of the 600 will be squished into a single cell in the return; you won't get separate lines for each 600 in a biblio, or separate lines for different subfields |
| 17:25 | aarkerio | I want all the records in the catalog and also de 600-b field |
| 17:27 | jcamins | aarkerio: there's an example that does almost exactly that on the reports wiki. Look through the table of contents. |
| 17:33 | kmkale joined #koha | |
| 17:34 | kmkale | Namaskaar #koha |
| 17:41 | aarkerio | this works: |
| 17:41 | SELECT ExtractValue(marcxml,'//datafield[@tag="600"]/subfield[@code="b"]'), biblio.author, biblio.title, biblioitems.isbn, items.barcode FROM biblio, biblioitems, items WHERE biblio.biblionumber=biblioitems.biblionumber AND biblio.biblionumber=items.biblionumber ORDER BY biblio.biblionumber | |
| 17:41 | but I don't know why ;-) | |
| 17:41 | Is funny actually!! | |
| 17:44 | sekjal | aarkerio: looks like a good query. only suggestion I'd make is to as an "as marc600" after the Extract Value, so the return headers are a little nicer to look at |
| 17:45 | aarkerio | yea, right! I will fix that |
| 17:59 | Oak | how is the hand kmkale ? |
| 18:00 | cait | |
| 18:00 | cait | hi Oak |
| 18:00 | Oak | :) |
| 18:00 | what are you doing? | |
| 18:01 | jcamins | Oak: it's not that late in Germany yet. |
| 18:01 | Oak | so, working then |
| 18:01 | oh i did not mean to tell you go to bed | |
| 18:01 | was just wondering | |
| 18:02 | jcamins | Oak: just commenting. ;) |
| 18:03 | Oak | uh oh. :) okay |
| 18:03 | miguelxercode left #koha | |
| 18:03 | cait | lol |
| 18:03 | not working, not time for bed :) | |
| 18:03 | Oak | good times! |
| 18:06 | cait | hehe yes |
| 18:07 | * Oak | listening to http://www.youtube.com/watch?v=lhsE6Jhmo6c in low volume |
| 18:07 | Oak | good |
| 18:08 | cait try that song for at least till 1.5 minute... you might like it | |
| 18:10 | cait | it's nice |
| 18:10 | Oak | :) |
| 18:22 | bryce joined #koha | |
| 18:23 | bryceh joined #koha | |
| 18:25 | oleonard | sekjal: I added another comment to 5725 with a question for paul_p |
| 18:25 | sekjal | oleonard: just read... good question |
| 18:26 | bryceh | anyone here using create_koc_db.pl to create a db for offline circulation? |
| 18:29 | sekjal | bryceh: yes, I've done that a few times |
| 18:30 | jcamins | The packages need to have an option for creating koc databases. |
| 18:30 | bryceh | how did you deal with getting the files onto the library machine from the server? i know it's probably more of a sys admin question. |
| 18:33 | i have the files creating fine and they work. i'm just wondering if anyone has come up with an easy way to pull them onto a windows xp machine nightly. i'm looking at setting up an ftp server and possible a dos batch file, but thought i would ask if someone had a better solution first. | |
| 18:38 | sekjal | bryceh: putting them in a password-protected, web-accessible directory on the Koha server allows the library to pull them down at their leisure (but that's still a manual process) |
| 18:38 | something like Dropbox would work; it has a Linux command-line interface that can work with a little persistence | |
| 18:38 | druthb would be able to address that more thoroughly than I, as she has set it up before | |
| 18:38 | you may also consider something like rsync (though I don't know how compatible that is with Windows) | |
| 18:40 | bryceh | I was actually wondering about Dropbox. I just wasn't sure about Dropbox and Linux. Maybe I will investigate that a bit. |
| 18:41 | ropuch | Dropbox is really cool |
| 18:41 | Oak | so is Wuala |
| 18:42 | bryceh | Have you used Dropbox with Linux? |
| 18:42 | ropuch | Don;t know Wuala, but any software working like user friendly rsync is cool [; |
| 18:42 | Oak | http://www.wuala.com/ |
| 18:42 | ropuch | bryceh: yup |
| 18:43 | rangi | ubuntuone |
| 18:43 | wizzyrea | do the package backup routines only save a certain number? |
| 18:43 | ropuch | I have my Projects/Documents folders symlinked to Dropbox folder |
| 18:43 | rangi | anything you put in dropbox you should encrypt |
| 18:43 | with strong encryption | |
| 18:43 | the same with ubuntuone etc | |
| 18:43 | except dropbox has a history of crappy security | |
| 18:43 | sekjal | yes, this db will contain patron information, so security must be considered |
| 18:44 | adminacct joined #koha | |
| 18:44 | adminacct joined #koha | |
| 18:44 | ropuch | I use db only for some non-personal data |
| 18:44 | rangi | yeah for stuff you dont mind others getting, its fine |
| 18:44 | same with googledocs etc | |
| 18:45 | stuff you'd stick up on a noticeboard at the grocery store :-) | |
| 18:45 | bryceh | so maybe rsync and keep it internal. |
| 18:45 | rangi | ropuch: the other thing to consider for nzers |
| 18:45 | cait | rangi++ |
| 18:45 | rangi | is your jurisdiction privacy laws no longer apply |
| 18:46 | anything you put up there, can get turned over to the fbi, without your consent etc, or a nz police warrant | |
| 18:46 | things to remember about the 'cloud' | |
| 18:46 | ropuch | Yup |
| 18:46 | bryceh | thanks rangi, good advice |
| 18:47 | jcamins | rangi: libsysguy needs advice on how to share the merge conflict-resolved hourly loans branch. |
| 18:47 | I thought you'd use rebase -i, but you'd know better. | |
| 18:47 | rangi | hmm |
| 18:47 | id do the merge | |
| 18:47 | fix the conflict | |
| 18:47 | and push that fixed branch, to gitorious | |
| 18:47 | and do a pull request | |
| 18:48 | ropuch | I remeber a guy uisng some version control system to have some directory synced |
| 18:48 | jcamins | libsysguy: rangi says to push the branch to gitorious after you've merged it. |
| 18:48 | rangi | hehe |
| 18:48 | or any public git repo is fine | |
| 18:48 | ropuch: yeah there is sparkleshare | |
| 18:48 | jcamins | libsysguy: this is much easier than my suggestion. |
| 18:49 | * jcamins | hopes that libsysguy has a highlight window. |
| 18:49 | rangi | http://sparkleshare.org/ |
| 18:49 | ropuch | I remeber trying bazaar in pre-dropbox era to sync my conf files on multiple linux boxes |
| 18:50 | wizzyrea | soo looking at the script for koha-dump- it will keep infinite backups? |
| 18:50 | rangi | it will |
| 18:50 | bu you dont run it by itself | |
| 18:50 | you run it by | |
| 18:50 | koha-run-backups | |
| 18:50 | wizzyrea | hm interesting i don't think that one's on the wiki |
| 18:50 | rangi | which takes --days as a conf option |
| 18:50 | 2 by default | |
| 18:50 | wizzyrea | oic! |
| 18:51 | * jcamins | needs to send a patch in for koha-run-backups |
| 18:51 | wizzyrea | ok ty, and that one isn't documented in the wiki |
| 18:51 | rangi | it has inline help |
| 18:52 | maybe cutting and paste that into the wiki | |
| 18:52 | wizzyrea | check. |
| 18:52 | rangi | ropuch: for plain backups of stuff, obnam is cool too |
| 18:52 | ropuch | Huh, I'm trying tu bulk update marc records - my idea is to fetch marc blog from biblioitems, do some perl-fu on it usuing MARC::Record/Batch and then isnert it back. Problem is I get "Unrecognized character \xE2 in column" when trying to manipulate the record. |
| 18:52 | rangi | http://braawi.org/obnam/ |
| 18:52 | jcamins | Right now koha-run-backups always runs all of the backups. |
| 18:53 | rangi | well all the enabled ones |
| 18:53 | for name in $(koha-list --enabled | |
| 18:53 | jcamins | Right. |
| 18:53 | Except for demo. | |
| 18:53 | rangi | yep |
| 18:53 | jcamins | Well, I want to have the option to A) backup demo, and B) backup different sets at different times. |
| 18:54 | rangi | yep, as long as you didnt change the default behaviour |
| 18:54 | but did that with switches | |
| 18:54 | jcamins | 12am EST != night in other places. |
| 18:54 | Yeah, it's koha-run-backups --instances="name,name2,name3" | |
| 18:54 | rangi | right, and without it does all |
| 18:54 | yeah that'd get accepted id imagine | |
| 18:55 | jcamins | Yeah, except for demo. So I can include --instances="demo" and have it work. |
| 18:55 | clrh joined #koha | |
| 18:55 | wizzyrea | oo, that script should also look for an existing backup with the same date in /var/spool |
| 18:56 | and tack a postfix on it if it finds one. | |
| 19:19 | slef | boom |
| 19:27 | rhcl | boomerang |
| 19:45 | Callender joined #koha | |
| 19:48 | clrh joined #koha | |
| 19:50 | rhcl | got an error when trying to upgrade from v3.04.05 to v3.05.0x. git wants me to commit or stash changes--how can I just force and overwrite without bothering with stash? it doesn't want to overwrite apt-get-debian-lenny.sh |
| 19:50 | rangi | why not just run git stash |
| 19:51 | moves them out fo the way for you | |
| 19:51 | rhcl | oh, allright |
| 20:20 | sekjal | hey, everyone, LDAP authentication is broken |
| 20:20 | * sekjal | facepalms |
| 20:20 | wizzyrea | O.o |
| 20:21 | rangi | hmm in master? cos it works in 3.4 |
| 20:21 | sekjal | rangi: since bug 5995 was patched |
| 20:21 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5995 blocker, PATCH-Sent, ---, matthias.meusburger, ASSIGNED , Glitch with checkauth |
| 20:21 | rangi | ahh |
| 20:21 | ill revert | |
| 20:22 | sekjal | wait |
| 20:22 | I can patch | |
| 20:22 | I know the problem | |
| 20:22 | rangi | hmm ok |
| 20:22 | :) | |
| 20:22 | sekjal | basically, checkpw_ldap returns cardnumber |
| 20:22 | cait | sekjal++ :) and don't worry about it |
| 20:22 | nengard left #koha | |
| 20:22 | * rangi | gets revert happy near release |
| 20:22 | rangi | but a patch works just as well |
| 20:23 | sekjal | but which is passed back through checkpw as cardnumber |
| 20:23 | but checkpw's return value is used as USERID | |
| 20:23 | rangi | ahhh |
| 20:23 | that;d do it | |
| 20:23 | sekjal | so unless the two are equal, fail |
| 20:23 | rangi | yeah |
| 20:23 | i wonder how i didnt catch that | |
| 20:23 | sekjal | or, if you have a password in the database different than the LDAP password |
| 20:23 | and you login with that | |
| 20:23 | rangi | ahh yeah |
| 20:24 | that might be whats happening, since we have clients running 3.4.5 | |
| 20:24 | and LDAP | |
| 20:25 | its been in their sinice 3.4.1 apparently | |
| 20:26 | there | |
| 20:27 | wizzyrea | they're |
| 20:27 | rangi | theaaaaeeezzzzre |
| 20:27 | * wizzyrea | is being funny, not snarky |
| 20:27 | rangi | ill be the judge of that! |
| 20:28 | wizzyrea | O.O |
| 20:28 | rangi | hehe |
| 20:28 | sekjal | okay, so I'm modifying checkpw_ldap to return cardnumber AND userid |
| 20:28 | either the existing local id if it's found, or the userid provided if not | |
| 20:28 | rangi | cool |
| 20:29 | sekjal | then modifying checkpw to make use of that, and pass it along (in the same form CAS is using) |
| 20:29 | then modifying the call to checkpw to set the userid off the returned userid, instead of the cardnumber. | |
| 20:29 | rangi | that sounds perfect to me |
| 20:31 | rhcl | @seen joann |
| 20:31 | huginn | rhcl: joann was last seen in #koha 23 weeks, 1 day, 15 hours, 22 minutes, and 13 seconds ago: <joann> night all |
| 20:32 | cait | rchl: try jransom |
| 20:32 | @seen jransom | |
| 20:32 | huginn | cait: jransom was last seen in #koha 2 days, 16 hours, 17 minutes, and 5 seconds ago: <jransom> ethian: my visa took weeks to get |
| 20:32 | sekjal | okay, so I think this will universally return the same three values for LDAP, CAS, and DB authentication: 1 (for 'authenticated'), cardnumber and userid |
| 20:33 | rangi | cool |
| 20:33 | sekjal | argh, no, it's bigger than taht |
| 20:33 | huginn | New commit(s) needsignoff: [Bug 7033] Make all strings translatable in marc21_field_007.tt <http://bugs.koha-community.org[…]w_bug.cgi?id=7033> |
| 20:33 | sekjal | i"ve got to get EVERY instance of checkpw to make use of the proper return values |
| 20:33 | rhcl | rangi: do I remember seeing a NZ site built on Kete but with a lot of audio (verbal recollections of history???) |
| 20:33 | sekjal | there are such in installer/InstallAuth.pm and opac/sco/sco-main.pl |
| 20:33 | rangi | hmmm |
| 20:34 | adminacct | guys... i tried to pull in the 3.4.5 .deb packages from the koha debian repo... onto a fresh Ubuntu 10.04 install... 'apt-get install koha'.. but failed that it depends on koha-common ... any clue what could have gone wrong? |
| 20:34 | rangi | a grep should find all instances sekjal |
| 20:34 | id just install koha-common anyway not the main koha | |
| 20:34 | did you read the instructions on the wiki? | |
| 20:34 | wizzyrea | http://wiki.koha-community.org[…]ing_Koha_packages |
| 20:35 | rangi | just the main one is better wizzyrea |
| 20:35 | wizzyrea | not if you're using ubuntu :P |
| 20:35 | I just did it this week. | |
| 20:35 | rangi | yeah but thats lucid |
| 20:35 | 10.10 has all but one in the multiverse | |
| 20:35 | wizzyrea | ok fair enough |
| 20:35 | jcamins | adminacct said he was on 10.04. |
| 20:36 | rangi | ah yeah sorry didnt read right |
| 20:36 | then that link will be good | |
| 20:36 | but short story is, dont use the koha package just use the koha-common one | |
| 20:37 | sekjal | no, I'm okay |
| 20:37 | the existing calls to checkpw call for cardnumber first | |
| 20:37 | rangi | rhcl: nope cant recall one |
| 20:37 | sekjal | so the returned userid value will just fall off |
| 20:37 | no modification needed | |
| 20:39 | indradg | rangi, koha-common complains about the 5 or 6 perl deps that prolly miss their candidate numbers or something |
| 20:39 | jcamins | indradg: that's why you have to follow the instructions on that wiki page. |
| 20:39 | wizzyrea | ^^ |
| 20:40 | i swear, it works | |
| 20:40 | rangi | or use a real os like debian :-) |
| 20:40 | wizzyrea | i did it 2 days ago, 0 issues. |
| 20:40 | jcamins | It does, I did it a few weeks ago. |
| 20:40 | rangi | there is a ppa for natty too |
| 20:41 | ill make one for onematapeah or whatever 11.10 is too at some point | |
| 20:41 | jcamins | rangi: 10.04 is the most recent LTS still, I think. |
| 20:41 | indradg | blimey!!!!! |
| 20:41 | wizzyrea | oneiric ocelot |
| 20:41 | rhcl | rangi: tnx |
| 20:41 | jcamins | Wait, no, came out yesterday. |
| 20:41 | wizzyrea | or something |
| 20:42 | JesseM left #koha | |
| 20:42 | jcamins | Actually, 11.10 isn't an LTS after all. |
| 20:42 | sekjal | rangi: patch written and sent |
| 20:42 | rangi | thanks sekjal |
| 20:42 | indradg | jcamins, rangi wizzyrea .... mea culpa!!! I was trying something else... and forgot that I had missed a crucial step :P |
| 20:42 | wizzyrea | :) all ok |
| 20:42 | rangi | will try to get it pushed before i fly to vancouver |
| 20:42 | indradg | figured it and fixed it! thanks guys! |
| 20:43 | jcamins | I was looking forward to a new LTS. |
| 20:43 | One which didn't require special cases for installing Koha. | |
| 20:43 | Oh well. | |
| 20:43 | huginn | New commit(s) needsignoff: [Bug 5995] Glitch with checkauth <http://bugs.koha-community.org[…]w_bug.cgi?id=5995> |
| 20:44 | Soupermanito joined #koha | |
| 20:48 | rangi | jcamins: i could do a ppa for lucid |
| 20:48 | if enough ppl asked | |
| 20:48 | or if one asked and bribed me | |
| 20:48 | :) | |
| 20:48 | jcamins | rangi: hmmm... you take chocolate? |
| 20:48 | rangi | i do :) |
| 20:49 | wizzyrea | jcamins: there's prolly still time to ship it to canada ^.^ |
| 20:49 | jcamins | I was just thinking that. ;) |
| 20:49 | bg | swiss miss chocolate |
| 20:49 | rangi | hehe |
| 20:49 | bg remembers | |
| 20:50 | jcamins | Swiss Miss... as in the hot chocolate mix? |
| 20:50 | rangi | thats right |
| 20:50 | with marshmallows | |
| 20:50 | for laurel | |
| 20:51 | one of the things she misses from the US | |
| 20:51 | bg | of course with marshmallows |
| 20:51 | rhcl | The sugar-free version I tried several times was too weak and flavorless. |
| 20:51 | * jcamins | takes a note. |
| 20:51 | rangi | sugar free??? |
| 20:51 | what the hell is the point? | |
| 20:51 | wahanui | it has been said that the point is not that the koha-community write a page about there software and the PTFS people write a page about there's. the point is that we have useful, informative content about the software and it's history and that anything controversial is closely referenced |
| 20:51 | rangi | :) |
| 20:51 | jcamins | rhcl: "let's have sweets, minus the sweetness"? |
| 20:52 | rangi | lol |
| 20:52 | wahanui++ | |
| 20:52 | bg | lol |
| 20:52 | heh | |
| 20:52 | wizzyrea | and goldfish crackers |
| 20:52 | cait | what is swiss midd with marshmellows? |
| 20:53 | I get it's sweet :) | |
| 20:53 | rangi | its a hot chocolate mix |
| 20:53 | for drinking | |
| 20:53 | cait | oh |
| 20:53 | rangi | you add milk (or hot water) |
| 20:53 | cait | what happens to the marshmellows |
| 20:53 | ? | |
| 20:53 | wizzyrea | they melt |
| 20:54 | cait | ooh |
| 20:54 | jcamins | rangi++ |
| 20:55 | rangi | its good! |
| 20:55 | you'd like it i think cait | |
| 20:55 | cait | sure sounds like it :) |
| 20:56 | * jcamins | makes his hot chocolate from cocoa powder, sugar, marshmallows, cardamom, vanilla, and occasionally some other variety of alcohol, too. |
| 20:57 | jcamins | It's a lot more work. |
| 20:58 | wizzyrea | i like to make the mix with dry milk |
| 20:59 | adding cardamom is a nice flair tho | |
| 20:59 | sekjal | have a good weekend, all! I'm out |
| 20:59 | jcamins | wizzyrea: a mix is an _excellent_ idea. |
| 20:59 | I should make some some time. | |
| 21:00 | wizzyrea | i use the alton brown recipe |
| 21:00 | it's always yummy | |
| 21:00 | you could even do something like | |
| 21:00 | make the mix | |
| 21:00 | and instead of putting vanilla in it | |
| 21:00 | tuck a vanilla bean in with the mix | |
| 21:00 | jcamins | Ooooh. |
| 21:00 | This is a good idea! | |
| 21:01 | I even have a couple of vanilla beans begging me to find a use for them. | |
| 21:01 | wizzyrea | hehe |
| 21:01 | rangi | ok |
| 21:01 | i vote we spend some time at kohacon | |
| 21:01 | with a foodie/drinkie session | |
| 21:01 | jcamins | (can anyone else tell I'm feeling the Fridayness?) |
| 21:02 | rangi | at LCA |
| 21:02 | they did a a big shared meal one night | |
| 21:02 | was a cool idea, but you need a hostel that has a nice big kitchen | |
| 21:02 | liw | I see rangi has been pushing all sorts of vices: hot chocolate, marshmellows, obnam... :) |
| 21:03 | cait | :) |
| 21:03 | rangi: i think it's a great idea | |
| 21:03 | rangi | hehe |
| 21:04 | ahh liw, for whom sugar free hot chocolate actually makes sense | |
| 21:04 | if liw comes to kohacon he can show us some nice places to eat i bet | |
| 21:06 | liw | Holyrood 9A (great hamburgers). David Bann (great, if pricey vegetarian). I'll mention those now, next year I'll have forgotten. Make notes. |
| 21:06 | * liw | is not a foodie, alas |
| 21:06 | wizzyrea | it's totally logged. |
| 21:06 | * jcamins | never went to either of those places. |
| 21:06 | didn't eat out all that much, though. | |
| 21:08 | rangi | liw: are you still in canada? |
| 21:09 | liw | rangi, nah, came back on Wednesday, and moved to Manchester today (Friday) |
| 21:09 | bg | heya liw |
| 21:09 | liw | greetings, bg |
| 21:10 | rangi | bummer i go to canada tomorrow |
| 21:10 | other side admittedly | |
| 21:10 | ohh cool, in manchester now | |
| 21:13 | jcamins | sql report library? |
| 21:13 | wahanui | sql report library is probably at http://wiki.koha-community.org[…]L_Reports_Library |
| 21:14 | jcamins | (faster than Google) |
| 21:14 | cait | wahanui botsnack cookie |
| 21:14 | wahanui | :) |
| 21:20 | trea joined #koha | |
| 21:21 | * jcamins | calls it a day a bit early. |
| 21:22 | rangi | cya jcamins |
| 21:23 | jcamins | Wish us luck with the landlord. |
| 21:23 | wizzyrea | good luck |
| 21:23 | rangi | good luck |
| 21:23 | jcamins | Thanks. |
| 21:40 | miguelxercode joined #koha | |
| 21:41 | NateC joined #koha | |
| 21:42 | NateC joined #koha | |
| 21:43 | rhcl left #koha | |
| 21:43 | Johnindy_ joined #koha | |
| 22:37 | Soupermanito joined #koha | |
| 22:37 | bryceh_ joined #koha | |
| 22:49 | adnc joined #koha | |
| 23:00 | rangi | @wunder vancouver bc |
| 23:00 | huginn | rangi: The current temperature in Vancouver, British Columbia is 12.0°C (3:00 PM PDT on October 14, 2011). Conditions: Partly Cloudy. Humidity: 77%. Dew Point: 8.0°C. Pressure: 30.03 in 1017 hPa (Falling). |
| 23:00 | chobbs joined #koha | |
| 23:06 | chobbs | Anyone want to hazard a guess as to why my koha database is getting hammered by "admin commands"? I restarted the server 20 minutes ago and so far it's seen over 400k commands :/ |
| 23:06 | Right now mysqladmin status shows over 300 queries/second | |
| 23:07 | rangi | what are the actual commands? |
| 23:07 | and what are the apache logs telling you | |
| 23:07 | chobbs | I'm nopt sure how to identify them :( |
| 23:07 | rangi | well id check the apache logs first |
| 23:08 | chobbs | I am doing an update of patrons right now, but there are only 13,000 of them. |
| 23:08 | rangi | see if something is hammering the opac or intranet |
| 23:08 | chobbs | the apache logs are only showing my import job |
| 23:08 | rangi | well yeah that makes sense |
| 23:08 | that does a lot of different queries | |
| 23:08 | 300 queries/sec is not bad | |
| 23:09 | chobbs | 100/patron? Because that's about where it's at this point. |
| 23:09 | rangi | Uptime: 26088390 Threads: 2 Questions: 2778051423 Slow queries: 878 Opens: 81352 Flush tables: 1 Open tables: 300 Queries per second avg: 106.486 |
| 23:09 | chobbs | Hmmmm. OK, maybe I won;t panic about that :) |
| 23:09 | rangi | yeah i wouldnt worry |
| 23:10 | chobbs | I've been trying to figure out freezes all week, and this is the firt chance I've had to really start getting into it. |
| 23:10 | rangi | if something was hiting apache |
| 23:10 | then id suspect that | |
| 23:10 | but if you are running a bulk import its probably just it | |
| 23:10 | log | |
| 23:10 | open a mysql promp | |
| 23:10 | mysql -uusername -p databasename | |
| 23:10 | run | |
| 23:10 | chobbs | OK. in that case, where might I be looking for the cause of regular 10 minute freeszes? |
| 23:11 | rangi | show processlist |
| 23:11 | 10 min freezes? | |
| 23:11 | id suspect oom | |
| 23:11 | or broken disk | |
| 23:11 | chobbs | Yup. Everything locks up, and 10 minutes later everything is happy. |
| 23:11 | Soupermanito joined #koha | |
| 23:11 | chobbs | avg load on server shoots up to 100+ |
| 23:11 | rangi | sounds like you are going OOM |
| 23:11 | and hitting swap | |
| 23:12 | chobbs | you'd think, but I don't see evidence of it. |
| 23:12 | rangi | you know what load is eh? |
| 23:12 | chobbs | even now I'm only using 12% of 9G |
| 23:12 | Soupermanito joined #koha | |
| 23:12 | rangi | the average number of jobs queued |
| 23:12 | so if its not ram | |
| 23:12 | IO is the next suspect | |
| 23:12 | what does the cpu do? | |
| 23:13 | is the cpu(s) running at 100% | |
| 23:13 | chobbs | apache and mysqld fight to see who gets to hit 100% next :) |
| 23:13 | rangi | its not someone running a bunch of broken reports? |
| 23:14 | theres a lot it could be, but i would check the processlist | |
| 23:14 | in mysql | |
| 23:14 | chobbs | I doubt it. We've pretty unsophisticated users - they don't use much on reports. I suppose I could do more work on parsing the apache logs before a break and see what's being called up. |
| 23:14 | rangi | see if its some queries locking the tables |
| 23:14 | also maybe turn on mysql slow logging | |
| 23:14 | chobbs | i'll try that. show processlist |
| 23:15 | rangi | thats the one |
| 23:15 | show full processlist too | |
| 23:15 | chobbs | I actually have slow queries being logged. |
| 23:15 | rangi | right, you could check if there are some dodgy ones in there |
| 23:16 | chobbs | SHOW COLUMNS FROM borrowers; that's one I wouldn't expect to be slow |
| 23:16 | not sure why that one was even logged - Query_time: 0.000049 | |
| 23:17 | rangi | it might have got jammed behine one |
| 23:17 | that was locking tables | |
| 23:18 | chobbs | I was overcommitting my ram, so I've lowered the number of max_connections to avoid that as a possibility. |
| 23:19 | and max_user_connections | |
| 23:19 | rangi | right |
| 23:19 | maybe install iotop too | |
| 23:19 | and see if its getting io bound | |
| 23:19 | trick is finding the pattern | |
| 23:20 | chobbs | only pattern so far has been a consistent time of day, ~8:15am |
| 23:20 | rangi | hmmm |
| 23:20 | interesting | |
| 23:20 | wahanui | interesting is sometimes bad or sometimes good |
| 23:20 | chobbs | lol |
| 23:20 | rangi | cronjob run then? |
| 23:20 | chobbs | nope, checked that |
| 23:20 | rangi | thats really oddd |
| 23:21 | does it happen everyday? | |
| 23:21 | chobbs | that might point to a user casued problem. |
| 23:21 | 4/5 days this week | |
| 23:21 | rangi | even weekends? |
| 23:21 | hmmm | |
| 23:21 | chobbs | no, weekdays only |
| 23:21 | rangi | ahhh |
| 23:21 | that is feeling tlike a report | |
| 23:21 | chobbs | to my knowledge (no one compains on weekend) |
| 23:21 | rangi | maybe its something they do as part of morning routine |
| 23:21 | check all overdues or something? | |
| 23:21 | chobbs | yeah, I think you might be right. |
| 23:22 | I need to figure out how to filter my apache logs to find it | |
| 23:23 | I get a 10 minute break in my apache logs whenever this happens. | |
| 23:23 | rangi | ahh yeah |
| 23:23 | system jams | |
| 23:24 | and it wont get logged until it completes | |
| 23:24 | chobbs | so should I be looking after the break then? |
| 23:24 | rangi | if its something they wait for at the broweser |
| 23:24 | id look before and after | |
| 23:24 | chobbs | because I've been looking prior to the break |
| 23:24 | rangi | yeah id check after too |
| 23:24 | druthb joined #koha | |
| 23:24 | rangi | because the access log logs things when they finish or timeout or whatever |
| 23:24 | druthb | o/ |
| 23:25 | rangi | heya druthb |
| 23:25 | druthb | hi, rangi. |
| 23:25 | chobbs | any idea what "internal dummy connection" means? |
| 23:25 | cait | hi druthb |
| 23:25 | druthb | hi, cait! :D |
| 23:25 | rangi | hmmm |
| 23:25 | nope | |
| 23:25 | not ringing a bell | |
| 23:26 | chobbs | http://wiki.apache.org/httpd/I[…]alDummyConnection |
| 23:26 | goog le to the rescue :) | |
| 23:26 | rangi | :) |
| 23:29 | chobbs | hmm. I'm seeing nothing but sco, returns.pl, and circulaiton.pl before and after the break :( |
| 23:32 | actually, I'm seeing some 504s several minutes before the break on opac-search.pl | |
| 23:32 | melia left #koha | |
| 23:32 | chobbs | that seems to be the start of the cascade |
| 23:33 | rangi | hmm |
| 23:33 | its an odd one | |
| 23:34 | 504 is gateway timeout | |
| 23:34 | are you proxying somewhere? | |
| 23:35 | chobbs | no, there's no proxy involved here |
| 23:36 | rangi | i wonder where the 504's are coming from |
| 23:36 | weird | |
| 23:36 | chobbs | they're coming from apache on the koha server. is it proxying for itself? |
| 23:36 | rangi | maybe ask, 'what do you do round 8.15 each morning' |
| 23:36 | no | |
| 23:42 | chobbs | well, I guess I'll see if the changes I made today help on monday. |
| 23:42 | rangi, thanks for talking it through with me! | |
| 23:43 | rangi | no problem |
| 23:43 | how you figure it out | |
| 23:43 | hope even | |
| 23:49 | cait left #koha |
← Previous day | Today | Next day → | Search | Index