Time  Nick          Message
00:00 jcamins       I signed off on a patch to fix it.
00:00 eythian       well, I haven't looked too closely. Just found that the packages don't install it, and they're based of the deps list.
00:00 eythian       Maybe it was fixed since this version.
00:01 rangi         hmm could be, i think its a non requirement, but recommended dependency? maybe?
00:02 * rangi       runs koha_perl_deps.pl -a to check
00:02 rangi         Gravatar::URL                                 1.05              1.03                    No
00:02 rangi         yeah no required dependency
00:02 eythian       ah right
00:03 eythian       if it's not there, avatars just don't work, that's about it. Should have a note on the syspref that it'll need to be installed.
00:04 rangi         yeah, that's a good idea
00:04 rangi         and it could be a recommended debian dependency eh?
00:05 jcamins       Just another 30.
00:06 eythian       rangi: yeah
00:06 eythian       I need to revamp the dependency creating script a bit.
00:06 eythian       Make it easier to deal with things like that.
00:36 roygbivovac   hey eythian, upgrade on test went fine
00:37 roygbivovac   do you reckon we need to take a snapshot of production before upgrading prod?
00:39 jcamins       Yes.
00:47 jcamins       eythian: should 7885 be cherry-picked to 3.6.x?
00:47 jcamins       I think it should.
00:47 jcamins       But I'm not 100% sure.
00:48 jcamins       Actually, it will only impact new installations.
00:48 jcamins       I'm sure.
01:01 eythian       roygbivovac: it's always a good idea to copy the database off somewhere, although I would expect it to be totally safe.
01:02 eythian       jcamins: doesn't really matter, it'll mostly affect new things, but it's not a terribly important thing either.
01:05 jcamins       Done!
01:05 eythian       http://www.stgraber.org/2012/05/04/lxc-in-ubuntu-12-04-lts/ <-- this could be handy as a lighter weight alternative to using VMs for dev stuff.
01:05 jcamins       Hopefully I even got the messages on the last ones right.
01:06 * jcamins     tests 3.6-testing.
01:06 jcamins       Cross your fingers, everyone.
01:07 jcamins       Oh, drat.
01:07 * rangi       crosses his fingers
01:07 jcamins       It's on the wrong database.
01:08 rangi         heh
01:08 jcamins       Maybe it'll pass the tests anyway.
01:10 jcamins       Seems unlikely, but we'll find out.
01:14 jcamins       Well, it's still going on the unit tests.
01:36 mtj           i haz a question about...
01:36 mtj           bug 6679
01:36 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6679 minor, P1 - high, ---, chris, Needs Signoff , Fixing code so it passes basic Perl::Critic tests
01:37 rangi         yep?
01:37 wahanui       yep.
01:38 mtj           these perlcritic errors i patched this morning... would they be accepted? - or refused?
01:39 mtj           for errors like ... "Subroutine prototypes used at line XXX, column 1.  See page 194 of PBP.  (Severity: 5)"
01:39 rangi         yeah
01:39 rangi         prototypes dont work how people think they do, the way we are trying to use them is wrong
01:39 mtj           and ... "return" statement with explicit "undef" at line XXX, column 26.  See page 199 of PBP.  (Severity: 5)"
01:39 rangi         yep
01:39 mtj           good idea? or just a waste of my time? , etc...  :p
01:40 rangi         good idea
01:40 rangi         thats what that bug is for
01:40 rangi         http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6677&action=edit
01:40 rangi         was pushed by paul_p
01:40 mtj           ok.... just checking...  before i do a bunch more patches :)
01:41 rangi         the aim is to get every script passing at least gentle mode of perl critic
01:41 rangi         i try a do a dir at a time
01:41 mtj           aah, yep - those type of patches have been accepted already... cool :)
01:42 mtj           and for C4/* ... a .pm file - at a time
01:44 mtj           perlcritic  is an awesome tool
01:44 rangi         it is
01:44 rangi         did you read that link in that patch i pasted?
01:44 rangi         http://www.modernperlbooks.com/mt/2009/08/the-problem-with-prototypes.html
01:45 mtj           yep - i read it 6 months ago, for the first time
01:45 rangi         :)
01:46 rangi         its a nice write up, chromatic is pretty awesome
01:46 mtj           ... after seeing the perlcritic  errors in koha ,prolly
01:50 rangi         yeah i think thats when i read it
01:57 mtj           rangi:  i came up with a nice way of finding the failing-est files in koha - from perlcritic...
01:58 mtj           $ perlcritic --count ./kohaclone.git   | sort -rn -t: +1 -2
01:58 mtj           i started at the top, and worked down, etc...
01:58 rangi         ahh nice trick
01:58 rangi         good idea
01:59 mtj           mason@xen1:~/g/head$  perlcritic --count ./C4   | sort -rn -t: +1 -2
01:59 mtj           C4/Tags.pm: 49
01:59 mtj           C4/Letters.pm: 19
01:59 mtj           C4/ImportExportFramework.pm: 15
01:59 mtj           ...
02:00 mtj           bbiab
02:02 chris_n       what a ride its been this evening :-P
02:03 rangi         chris_n: in a bad way?
02:03 rangi         not out on a ducati ? :)
02:04 chris_n       no, just dsl bounces due to sever weather :-)
02:04 rangi         ahh thats way less fun
02:04 chris_n       severe even
02:04 rangi         altho a ducati ride in severe weather wouldnt be fun
02:05 chris_n       this dsl is way over 10 km
02:05 chris_n       and has lots of grounding issues
02:05 rangi         ahhh, pretty fragile then
02:05 chris_n       so when it rains....
02:05 rangi         yeah
02:05 chris_n       here we go :-)
02:08 chris_n       jcamins++ # lots of bug wrangling/rmaint'ing today
02:09 * chris_n     wishes he had a ducati... with the current price of gas
02:09 rangi         whats it in the US now?
02:10 chris_n       ~$3.75/gal
02:10 rangi         2.21 nzd for octane 91 here /litre
02:11 rangi         2.21 * 3.785
02:11 wahanui       8.36485
02:11 chris_n       ouch
02:11 jcamins       Ugh.
02:11 jcamins       Ran out of disk space.
02:11 rangi         thats nzd
02:11 chris_n       ~5.80 usd
02:11 rangi         yeah :(
02:11 * chris_n     feels a bit better
02:11 rangi         hehe
02:12 chris_n       just replaced an O2 sensor in our van and gained back ~3mpg
02:12 chris_n       so that's good too
02:12 rangi         nice
02:12 chris_n       its all the other idiots on the road that keeps me from getting a bike
02:12 chris_n       :)
02:13 rangi         :)
02:17 jcamins       Okay, found more disk space.
02:18 rangi         it's on the floor
02:19 jcamins_away  rangi: my external hard drive? Nah, I'd prefer not to try and mount /var on my VM to an network drive.
02:21 rangi         jcamins_away: it was a tv advertisement here
02:22 rangi         but unfortunately not on youtube
02:22 * ibeardslee  can't even remember what it was advertising
02:23 rangi         sky tv
02:23 jcamins_away  rangi: oh. As it happens, I have a network hard drive on the floor.
02:23 rangi         'where's the remote?' 'ON THE FLOOR!'
02:24 rangi         i cant find it at all
02:24 rangi         but i found the annoying fresh up ad
02:24 rangi         https://www.youtube.com/watch?v=e1DL_evNMpc&feature=related
02:27 ibeardslee    .. !?! .. https://www.facebook.com/pages/Those-who-miss-that-Sky-TV-On-the-floor-ad/110027425680769
02:27 ibeardslee    no ad there though
02:28 ibeardslee    just flabbergasted that people would go that far
02:29 rangi         heh
03:46 Amit_Gupta    heya bag
04:28 francharb     good morning
04:30 rangi         hi francharb
04:42 francharb     hi rangi
05:33 Amit_Gupta    heya ciat
05:36 eythian       @later tell wizzyrea 3.8.1 packages uploading now
05:36 huginn`       eythian: The operation succeeded.
05:52 cait          hi eythian :)
05:52 eythian       hello
06:20 magnuse       kia ora #koha!
06:23 magnuse       ata marie rangi
06:41 reiveune      bonjour
06:41 magnuse       kia ora!
06:41 magnuse       jcamins++ for epic bug wrangling!
06:46 * magnuse     hands rangi the duct tape
06:46 rangi         sorry about that
06:46 rangi         but do a whois on me now
06:48 magnuse       just "/whois rangi"?
06:48 rangi         yep
06:48 magnuse       doesn't seem to work in xchat...
06:48 rangi         it might put it in another window
06:48 magnuse       but you are @bugs.kc.org
06:49 rangi         ahh been that for a while
06:49 rangi         its
06:49 rangi         is using a secure connectio
06:49 rangi         n
06:49 rangi         ssl to my bip, and ssl from it to oftc
06:50 magnuse       yay
06:50 * magnuse     wanders off in search of breakfast
06:58 paul_p_       good morning #koha
06:58 rangi         hi paul_p_
06:58 paul_p_       (and just for the record : gaz price in France = 1.40-1.45€/liter)
07:06 Oak           Ahoy me hearties
07:07 Oak           magnuse
07:07 Oak           \o/ i win
07:07 Oak           Guten morgen cait
07:17 cait          hi Oak :)
07:17 Oak           :)
07:25 cait          hi #koha :)
07:30 magnuse       hiya cait and Oak and hdl and bshum and everyone else
07:31 bag           heya cait and magnuse
07:31 bag           :)
07:31 bag           cait++
07:31 bag           magnuse++
07:31 bag           #just cause
07:31 magnuse       hehe thanks :-)
07:31 magnuse       don't think i deserve it, though...
07:31 bag           you always do
07:32 bag           @karma magnuse
07:32 huginn`       bag: Karma for "magnuse" has been increased 163 times and decreased 0 times for a total karma of 163.
07:32 bag           @karma bag
07:32 huginn`       bag: Karma for "bag" has been increased 1 time and decreased 0 times for a total karma of 1.
07:32 magnuse       w00t
07:32 bag           see magnuse ;)
07:32 bag           proof is there ;)
07:32 bag           @karma brendan
07:32 huginn`       bag: Karma for "brendan" has been increased 28 times and decreased 0 times for a total karma of 28.
07:32 bag           yay brendan should always be ahead of bag
07:33 magnuse       hm, feels like i ought to sign off on a patch now, to justify that ++
07:33 bag           bug 5911
07:33 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5911 enhancement, PATCH-Sent (DO NOT USE), ---, srdjan, Needs Signoff , Transport Cost Matrix of transporting an item between branches
07:33 bag           there you go ;)
07:33 bag           well you asked right?
07:33 magnuse       i have no idea what a Transport Cost Matrix is, though...
07:34 magnuse       i sort of did, yes
07:34 bag           think more holds complexity
07:34 bag           :D
07:34 magnuse       heh
08:06 rangi         magnuse: bug 4330 has a ton of easy ones to signoff
08:06 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4330 normal, P3, ---, chris, Needs Signoff , Copyright statements out of date
08:08 magnuse       rangi: yay. but i already started doing some paid work... will remember it for later though
08:09 rangi         :)
08:21 cait          paul_p: around?
08:22 paul_p        cait yes (but not really available for a few minuts)
08:22 rangi         i have a question for anyone who knows
08:22 rangi         how many libraries are running koha + solr now?
08:22 cait          paul_p: ah, only thought you would know some nice examples for big academic koha users :)
08:22 rangi         3 ?
08:22 rangi         cait: lyon 3
08:23 paul_p        rangi = StEtienne University, Limoges University, Limoges Public Library, Institut Télecom = 4
08:24 rangi         thank you
08:24 paul_p        cait the largest academic Koha user we have in France is AixMarseille (1.2M items, 70k patrons)
08:24 cait          ah, thank you
08:24 cait          I thought it was aix marseille, but not sue
08:24 cait          and thank you for the numbers :)
08:24 paul_p        there are 9 universities using Koha, from the largest to the smallest :
08:25 rangi         arent all 3 in marseille using koha now?
08:25 rangi         or is that really one, but 3 campuses?
08:25 paul_p        rangi = since january 2012, 1st, there's only 1 university in Marseille !
08:25 rangi         ohhhh
08:25 rangi         did they all merge?
08:25 bag           heya paul_p
08:25 cait          which is why they are so big :)
08:25 paul_p        (with 3 main campuses, and something like 10 small)
08:25 rangi         cool
08:26 rangi         is the main campus the one we had dev week at?
08:26 paul_p        rangi yep: http://www.univ-amu.fr/
08:26 rangi         cool
08:26 paul_p        rangi = not at all. the dev week was at a tiny campus
08:27 rangi         oh, seemed pretty big to me :)
08:27 paul_p        rangi in fact, it was big, but only the building we were was university. all the rest was companies / other schools / ...
08:27 rangi         ahh
08:27 rangi         that makes sense now
08:27 * rangi       remembers the cafeteria fondly
08:28 slef          oooh this upsets huginn
08:28 slef          @query Template process failed: file error - /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/help/.tt: not found
08:28 huginn`       slef: 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=Template%20process%20failed%3A%20file%20error%20-%20/usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/help/.tt%3A%20not%20found could not be retrieved: InvalidBugId
08:28 bag           yup coffee is key ;)
08:28 rangi         bag: it was the nice bottles of wine you could get with the delicious lunch :)
08:29 rangi         i also remember going to a rugby cafe in marseille, with thd, hdl, laurel and russel
08:29 paul_p        ( there's only 1 rugby cafe in Marseille, as it's a soccer city ;-) )
08:29 rangi         where the owner tried to get russel to come play for his team in the weekend, and we all wore silly hats
08:29 bag           HA
08:30 bag           silly hats rule
08:30 rangi         i think it was moroccan style food too .. can you remember hdl?
08:30 rangi         it was yum whatever it was
08:30 paul_p        rangi = did I told you that my 1st son is playing rugby ? 2nd lines, or number 9. he has the regional yearly tournament semi-final on saturday !
08:30 * bag         always thinks of myself as a hat fashion guy
08:31 hdl           rangi: can't remember...
08:31 bag           well paul_p good luck to your son
08:31 Oak           food! i am hungry.
08:32 rangi         ooohhhh very cool!
08:33 rangi         http://photos.bigballofwax.co.nz/gallery2/main.php?g2_itemId=9684
08:34 paul_p        rangi http://www.facebook.com/photo.php?fbid=10150695747708967&set=a.396716418966.176727.191344518966&type=3&theater (my son is just on the left of the captain, with the red shirt)
08:35 rangi         tall for a 9 :) but id expect tall with you as his father :)
08:35 bag           oh man rangi that picture is awesome
08:36 rangi         paul_p: that ground looks hard!
08:36 bag           I can't tell height in paul_p picture… I'm sure he's going to be as tall
08:37 paul_p        bag Simon (my son) is just a few cm less tall than I'm. and he weights 85kg (only muscle almost)
08:37 paul_p        rangi yep, the ground is hard.
08:37 rangi         im picking lock in a few years
08:37 bag           HA I'm always wrong with pictures and height (cause I'm a hobbit ;) )
08:38 bag           paul_p: is quite a bunch of cm's taller than me
08:38 paul_p        bag I confirm ;-)
08:40 magnuse       kia ora stuartyeates
08:40 stuartyeates  hi magnuse
08:41 bag           paul_p: I have not had a chance to say yet - but great job with 3.8   it is really beautiful…   (excellent job as RM)  :D
08:41 magnuse       yeah paul_p++
08:41 paul_p        bag thx.
08:41 bag           it gets me really really excited to see 3.10 ;)
08:41 paul_p        (in fact I'm happy, but also very frustrated by all the things i'd like to do but can't)
08:42 bag           paul_p: agreed - I see so much great code out there :)
08:42 rangi         yep
08:42 rangi         paul_p++
08:43 paul_p        rangi = why this ++ because i'm frustrated ? ( ps: :D and ;-) )
08:44 magnuse       being frustrated and still doing great things deserves a ++ :-)
08:44 cait          I think we all are frustrated sometimes about all the things we want to do but don't find time for
08:44 cait          so many gread ideas, not enough time
08:45 bag           OR so many great patches out there - but so little time to test :(
08:45 magnuse       too true
08:45 cait          or so many bugs waiting for a patch...
08:45 cait          it's something we can only change together
08:45 bag           too true (thanks magnuse)
08:45 magnuse       bag: any progress on the edi thing?
08:46 bag           I've installed the patches on master
08:46 paul_p        cait++
08:46 bag           and I'm working on getting a "broader" base of vendors to test against
08:47 paul_p        (and that was the meaning of a recent mail on koha-devel: we can change it together only)
08:47 bag           but so far "I would sign off" on the patch
08:47 magnuse       bag: great!
08:47 rangi         paul_p: hehe yeah, cos i know that frustration, and because 3.8.0 was pretty solid
08:47 cait          bag: we need a follow up
08:47 cait          you saw my comments?
08:47 paul_p        bag = not sure I understand what you mean by "I'm working on getting a "broader" base of vendors to test against"
08:48 magnuse       paul_p: for the edi enh, i think
08:48 * slef        places another order for stuff for kohacon, again after the quote expires because of sponsorship slower-than-hoped, hopes he gets away without price increase again
08:48 bag           cait: I saw your commets - great!
08:48 cait          :(
08:48 cait          slef: still no new sponsors?
08:48 bag           paul_p: I am worried that the code only works for a certain set of EDIfact
08:49 slef          cait: some new sponsors... which is why I can order this now.
08:50 rangi         slef: did you get my form submission?
08:50 bag           paul_p: with some help from atz  -- we've figured out this " LIN is not segment_group 27 in every version"   so that would need to be granulized
08:51 cait          rangi++ for donating to kohacon
08:51 paul_p        bag = I have no knowledge of EDIFACT to this "segment_group" message is chinese to me :D :D
08:51 bag           HAHAHA
08:51 slef          cait: basically we're now at the point where the basic conference will happen and every X pounds means we can add something else that people like at a conference, like better conference pack, better internet access and so on
08:51 paul_p        hey, it's quite rare that we have ppl from NZ and US and Europe at the same time on this channel !
08:51 slef          rangi: reply with you now
08:51 rangi         cool thanks :)
08:51 slef          rangi: no thank you :)
08:52 bag           paul_p: you can spend months reading EDIfact documentation - and it's different for every group (vendor)
08:52 cait          slef: what is missing that you would still like to do/get?
08:52 bag           oh good question cait
08:54 * magnuse     reads through the list of kohacon sponsors
08:55 slef          cait: I'm wondering about notepads and pens for the conference pack, I'm still not clear on what internet and refreshments we have there but mle and Andrea know more, at least one cultural/social event, transporting some more equipment to Edinburgh but we can do without that if we must.... I think there is probably more that has been suggested and I'm forgetting.
08:55 bag           ah yup - we were really late - just submitted tonight
08:55 rangi         i have a huge pile of pens and pads from conferences
08:55 rangi         i never use them
08:55 rangi         fwiw
08:55 slef          oh yeah we might go with take-it-if-you-need-it on the desk
08:55 cait          rangi: and I safe my pad from kohacon for special occasions and meetings :)
08:56 rangi         slef: thats not a bad idea at all
08:56 cait          slef: but think the pads and pens I would  not worry somuch about
08:56 slef          like I say, the basic event will happen, but there's lots of stuff some people would really like
08:56 magnuse       drop the pens and paper and say you are being environmentally friendly
08:56 paul_p        magnuse++ for this idea !!!
08:56 cait          but still bad we have to think about such things
08:57 cait          I mean it's not a big amount really that was to be raised for kohacon :(
08:57 slef          magnuse: pads will be small... ideally I'd like a load of the cardboard pens but they're even more expensive than plastic (crazy!)
08:57 magnuse       slef: yeah, that sux!
08:58 slef          I think we're going to raise £3000ish now, which leaves the hosts putting about the same amount in between us, which isn't too bad.
09:04 rangi         9 days
09:05 rangi         until eythian and I started flying
09:05 mib_am69mf    hi i want to know the latest version of koha on windows
09:05 magnuse       how long will the journey be?
09:06 slef          28h?
09:07 rangi         mib_am69mf: there hasnt been a version released in a long time
09:07 slef          chris_n has an identity crisis
09:07 mib_am69mf    can u sovle one problem of mine
09:07 mib_am69mf    ?
09:08 rangi         magnuse: leave here at 8.40pm sunday june 3 nz time, arrive in edinburgh 8.25pm monday june 4 uk time
09:08 slef          NZ is UK+13 I think.
09:08 slef          mib_am69mf: meta-question
09:08 wahanui       just ask, don't ask if you can ask and if the right people are not here, they won't answer or you can use huginn's @later to leave a message
09:09 rangi         so 36ish hours
09:09 magnuse       sounds familiar ;-)
09:09 rangi         in planes and airports
09:09 mib_am69mf    wt is the problem in koha229 that is able to extract value from my sql but it unable to insert and update value from user interface
09:10 slef          rangi: ow 36? Air NZ? Stopovers?
09:10 rangi         wlg->akl->singapore->heathrow->edinburgh
09:11 hdl           mib_am69mf: hi, please, just ask, don't ask to ask.
09:11 hdl           mib_am69mf: hadn't seen your question.
09:11 rangi         mib_am69mf: hmm i dont know, other than the fact 2.2.9 is really really really old
09:12 mib_am69mf    i already asked
09:12 bag           heya hdl
09:12 hdl           hi bag
09:13 hdl           mib_am69mf: would require some more logs to see what is happening.
09:13 rangi         slef: 11 hours to singapore, 13 sing to london ... 1 hour to akl, 1.5 lhr to edinburgh .. the rest is all in airports
09:13 hdl           mib_am69mf: it may come from :
09:13 bag           hdl you always take the best pictures http://photos.bigballofwax.co.nz/gallery2/main.php?g2_itemId=9684
09:13 hdl           db structure.
09:13 hdl           or mysql access
09:13 hdl           or something else.
09:13 rangi         oh, yes good thought hdl
09:14 rangi         it might be mysql user permissions
09:14 mib_am69mf    i am using the default user name passwod koha/koha
09:14 hdl           mib_am69mf: we would need some more information from apache logs
09:14 mib_am69mf    kk
09:16 hdl           mib_am69mf: upgrading to 3.8 could be also helpful... though  quite painful... but worth the pain.
09:16 slef          rangi: guess it beats my 12h to akl :)
09:17 mib_am69mf    i will but i want it do on windows
09:20 slef          mib_am69mf: you will probably need to do it yourself, maybe doing some archaeology on http://bugs.koha-community.org to find old 2.2.9 bugs, or find a support company that will support Koha on windows (not the co-op)
09:21 hdl           mib_am69mf: windows  ?
09:21 wahanui       it has been said that windows is a poor fit for free software like Koha. Some of the thing's we use heavily are not easily available at the moment. No-one's funded Koha 3.x for Windows and I'm not sure who'd be willing to work on it. You are probably best off using a liveCD for testing, then commissioning a GNU/Linux server.
09:22 hdl           mib_am69mf: consider exporting your records and use http://www.sigb.net/download/index.php
09:27 mib_am69mf    thanks for ur suggestion i will do it
09:33 rangi         magnuse: i see you are backing the git-annex-assistant too :)
09:33 magnuse       rangi: yup, sounds like a cool project!
09:33 rangi         yep
09:37 magnuse       and quite modest, moneywise
09:38 rangi         yes, it really is
09:38 magnuse       sounds like a lot has been done already, though, and this is just to fund the last stretch
09:38 rangi         yup, i already use git-annex
09:39 magnuse       cool
09:39 magnuse       i need to check it out, i guess ;-)
09:39 rangi         :)
09:44 magnuse       installed!
09:45 rangi         hehe
09:48 rangi         http://git-annex.branchable.com/tips/using_box.com_as_a_special_remote/  <-- i use that
10:14 magnuse       rangi: cool (not an android user, though)
10:15 rangi         yep, i dont use it on my phone
10:15 rangi         i just downloaded the app to get 50gig :)
10:15 rangi         use it on my laptop and workstation, with davfs
10:36 slef          argh, paypal just limited our account again... mjkaye to the rescue
10:58 magnuse       paypal--
11:00 slef          arrrrrrrrrrrrrrrrrrrrrrrrgh
11:00 slef          "We'll review your details and will be in touch if we have any questions."
11:00 slef          so all the donations sat in Paypal are inaccessible for an unknown period of time
11:01 slef          They're blaming the EU regulations, but I've been through those regulations in the past, to get another bank to stop arsing around, and so I'm 99% sure this isn't required.
11:02 slef          Paypal-- - screwing community projects over since 1999.
11:02 slef          Let me check whether we can even receive donations.
11:03 slef          Well... we can...
11:03 slef          We just can't pay any suppliers from Paypal, transfer to our bank account or close the account.
11:05 slef          I think we'll be OK. There's something like £2000 now stuck at Paypal but I'm pretty sure that the balance for the room hire doesn't need paying until next week and that's about £2000.
11:06 slef          wahanui: international banking?
11:06 wahanui       bugger all, i dunno, slef
11:06 slef          hehe
11:22 Amit_Gupta    heya slef
11:23 slef          hi Amit_Gupta
11:49 mj            Hi!
11:50 mj            Quick question: Is it safe to remove the patron passwords from mysql, if you are using ldap authentication?
11:50 mj            in our system, users can login with their new *AND OLD* password
11:50 mj            (previous password)
12:20 mtj           mj, you might have your ldap set up wrong, too?
12:21 mtj           i have set up only i ldap system
12:22 mtj           in my case, the ldap server *updated* the koha password - so they both always matched each other
12:23 mtj           ...thats all i can remember (twas 2 years ago?)
12:23 mtj           but short answer is... 'yes' ! :)
12:24 mtj           (after you make a backup, and test on a dev system, of course)
12:29 Amit_Gupta    heya slef
12:52 mj            yes: they match here too. But it seems that FIRST koha tries the local password?
12:52 chris_n       slef: identity crises come with foul weather around here ;-)
12:52 mj            So it seems... and if that matches: authentication succeedes.
12:53 jcamins       mj: yes, that's the way LDAP authentication works.
12:53 jcamins       (in Koha)
12:53 mj            So, if I change the ldap password, but the user types the OLD password, he/she still get's in.
12:53 mj            (using the local koha/mysql) password
12:53 jcamins       Right.
12:53 mj            Not so nice.
12:54 mj            In other software I have seen a 'flush authentication cache' button.
12:54 mj            Would be nice to have.
12:54 mj            What I did now:
12:54 jcamins       Ooh, that's a neat idea!
12:54 mj            UPDATE borrowers SET password = '';
12:55 mj            perhaps I should file an enhancement request?
12:55 jcamins       Sounds like a good idea to me.
12:57 mj            We do that in bugzilla?
12:57 jcamins       Yup.
12:58 jcamins       No guarantee anyone will implement it, but it's a cool idea.
12:58 huginn`       New commit(s) kohagit: Bug 7977 follow-up DBRev number <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=0754c2f7cff6856ca418cff4fa4a336aa0620856> / Bug 7977 follow-up, fixing UC breaking coding guidelines <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=28d3693adc7eada6eda1c9700c102e83ef345a9d> / add edit_quotes to es-ES/mandatory/userpermissions.sql <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h
12:58 chris_n       is there really no sync of the user's password between the LDAP server and the local Koha db?
12:58 jcamins       And someone may see it, think it's a great idea, and decide to implement it. :)
12:58 jcamins       chris_n: there is, but it's lazy.
12:58 chris_n       ahh
12:58 chris_n       lazyness--
12:58 jcamins       To avoid unnecessary round-trips, we authenticate against what we have first.
12:59 jcamins       chris_n++ # release note generator
12:59 chris_n       tnx
12:59 chris_n       it looks like rangi is using it too
12:59 mj            chris_n: the sync happens, but if we change the password in ldap, koha still has the previous password.
13:00 chris_n       right
13:00 mj            and if the user types the previous password, he gets in
13:00 chris_n       mj: change it at the LDAP server, right?
13:00 wahanui       chris_n: that doesn't look right
13:00 mj            Yep.
13:00 * chris_n     tosses wahanui more fudge
13:01 chris_n       maybe a syspref to select the order of precedence when authenticating a user would be nice
13:01 mj            so, where can I file an enhancement request for a 'flush authentication cache' button in the staff interface..?
13:01 chris_n       bugs?
13:01 wahanui       bugs is, like, found at http://bugs.koha-community.org. Please fix any bugs you find. :) or reporting them is helpful, too
13:01 mj            that could be a solution too
13:02 jenkins_koha  Starting build #732 for job Koha_master (previous build: SUCCESS)
13:02 chris_n       sort of like pam configurations, etc
13:04 chris_n       paul_p: thanks!
13:04 paul_p        chris_n yw ;-)
13:05 chris_n       with a few simple modifications QOTD could become tip-of-the-day for the staff client, as jcamins pointed out some time back
13:06 jcamins       Hm.
13:06 jcamins       I need translations.
13:06 jcamins       fredericd: about?
13:07 * oleonard    develops a tip-of-the-day feature which shames librarians who use Internet Explorer
13:07 * oleonard    includes a switch to re-route messages to sysadmins who insist the librarians use IE
13:08 jenkins_koha  Project Koha_master build #732: FAILURE in 6 min 23 sec: http://jenkins.koha-community.org/job/Koha_master/732/
13:08 jenkins_koha  * kyle: Bug 7757 - Edit basket vendor after it has been created
13:08 jenkins_koha  * paul.poulain: [PATCH 1/1] Bug 7757 - Followup - Move IF outside of html tag
13:08 jenkins_koha  * cnighswonger: Bug 7977: Upgrading DataTables library to 1.9.1
13:08 jenkins_koha  * cnighswonger: Bug 7977: Updating datatables.css to reflect changes from v1.8.1 to v1.9.1
13:08 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7757 enhancement, P3, ---, kyle, Pushed to Master , Edit basket vendor after it has been created
13:08 jenkins_koha  * cnighswonger: Bug 7977: Adding jEditable minified version
13:08 jenkins_koha  * cnighswonger: Bug 7977: Adding DateTime::Format::MySQL as a core dependency
13:08 jenkins_koha  * cnighswonger: Bug 7977: Quote-of-the-day (QOTD) Feature for OPAC
13:08 jenkins_koha  * cnighswonger: Bug 7977: QOTD uploader to enable uploading csv files containing quotes
13:08 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7977 enhancement, P5 - low, ---, cnighswonger, Pushed to Master , Add a "Quote-of-the-day" feature to the OPAC homepage
13:08 jenkins_koha  * cnighswonger: Bug 7977: Further UI work on the QOTD uploader
13:08 jenkins_koha  * cnighswonger: Bug 7977: Further UI work on the QOTD editor
13:08 jenkins_koha  * cnighswonger: Bug 7977: Fixing captialization on the tools main page
13:08 jenkins_koha  * cnighswonger: Bug 7977: Fixing quote sample data timestamps
13:08 jenkins_koha  * cnighswonger: Bug 7977: Adding Daily Quotes Tests to Koha.t test suite; also fixing sort order on quote selection SQL
13:08 jenkins_koha  * cnighswonger: Bug 7977: Adding Koha standard help files for QOTD feature
13:08 jenkins_koha  * cnighswonger: Bug 7977: Followup patch addressing items pointed out by Jonathan Druart
13:08 jenkins_koha  * cnighswonger: Bug 7977: Removing unused code from quotes_ajax.pl
13:08 jenkins_koha  * cnighswonger: Bug 7977: Fixing a bug which results in quote fields being incorrectly offset when saving uploaded quotes
13:08 jenkins_koha  * cnighswonger: Bug 7977: Improving upload result message display
13:08 jenkins_koha  * cnighswonger: Making source a text field rather than a varchar to avoid potential length limitations
13:08 jenkins_koha  * cnighswonger: Fixing a typo in the quotes-upload help file and hardcoded css
13:08 jenkins_koha  * mtj: add edit_quotes to es-ES/mandatory/userpermissions.sql
13:08 jenkins_koha  * paul.poulain: Bug 7977 follow-up, fixing UC breaking coding guidelines
13:08 jenkins_koha  * paul.poulain: Bug 7977 follow-up DBRev number
13:09 chris_n       paul_p: we'll need to add the sample quotes to the test data on jenkins_koha
13:10 chris_n       oleonard: I'll sign off on that one ;-)
13:10 jcamins       chris_n: do I just ask fredericd for the translation files?
13:11 chris_n       jcamins: yes... I usually fire off an email which seems to be faster
13:11 jcamins       chris_n: okay.
13:11 jcamins       Thanks.
13:11 paul_p        yikes ! ok 31 - Open translated user permissions file installer/data/mysql/es-ES/mandatory/userpermissions.sql
13:11 paul_p        ok 32 - Found 47 perms !
13:11 paul_p        there was a follow-up for this file !!!
13:11 * paul_p      fixes that immediatly
13:12 chris_n       he'll create a branch for it from whence you may cherry-pick at your leisure
13:12 jcamins       I guess I should include Samuel in the e-mail.
13:13 jcamins       Do we know his e-mail address?
13:13 chris_n       paul_p: and add the new dep to jenkins as well ;-)
13:13 chris_n       Samuel?
13:13 jcamins       Hm. He's not listed anymore never mind.
13:13 jcamins       I thought someone named Samuel volunteered to be Translation Manager.
13:14 paul_p        mmm...     add edit_quotes to es-ES/mandatory/userpermissions.sql
13:14 paul_p
13:14 paul_p        Signed-off-by: Mason James <mtj@kohaaloha.com>
13:14 paul_p        ... should be OK. /me investigates
13:14 paul_p        chris_n = it's chris_c that manages most of jenkins
13:15 chris_n       paul_p: mtj's patch is self-signed.. he added it when he QA'd
13:15 * chris_n     cannot vouch that it works correctly
13:16 chris_n       @later tell rangi we need to add DateTime::Format::MySQL to jenkins as well as the sample quote data
13:16 huginn`       chris_n: The operation succeeded.
13:16 jcamins       paul_p: I don't see any problem. It says "ok 32 - found 47 permissions!"
13:16 jcamins       Right?
13:16 paul_p        perl xt/permissions.t works fine for me...
13:16 paul_p        jcamins I have 50
13:16 paul_p        ok 31 - Open translated user permissions file installer/data/mysql/es-ES/mandatory/userpermissions.sql
13:16 paul_p        ok 32 - Found 50 perms
13:16 paul_p        ok 33 - No user permissions to add
13:16 paul_p        ok 34 - No user permissions to delete
13:16 paul_p        1..34
13:17 jcamins       paul_p: oh, that's weird. I wonder why it said it was okay, then.
13:17 jcamins       Oh, because it's tests 33 and 34 that could be problems.
13:18 chris_n       broken test?
13:18 paul_p        @later tell chris_c about jenkins complain, it's related to bug 7977, but I don't understand why it complain, the test work on my laptop...
13:18 huginn`       paul_p: The operation succeeded.
13:18 chris_n       you mean rangi?
13:18 paul_p        @later tell rangi about jenkins complain, it's related to bug 7977, but I don't understand why it complain, the test work on my laptop...
13:18 huginn`       paul_p: The operation succeeded.
13:18 paul_p        chris_n right ;-)
13:18 * chris_n     hands paul_p coffee
13:18 chris_n       or tea
13:19 chris_n       or whatever you like ;-)
13:19 mj            wahanui, chris_n: I have filed an enhancement request here: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8148
13:19 wahanui       mj: excuse me?
13:19 huginn`       04Bug 8148: enhancement, P5 - low, ---, gmcharlt, NEW , ldap authentication should FAIL if ldap contains NEW password, and user types the PREVIOUS password
13:20 * chris_n     thinks its because jenkins does not have the new core dep and so it croaks during testing
13:20 chris_n       hence:
13:20 chris_n       #   Failed test 'use C4::Message;'
13:20 chris_n       #   at t/00-load.t line 32.
13:20 chris_n       #     Tried to use 'C4::Message'.
13:20 chris_n       #     Error:  Can't locate DateTime/Format/MySQL.pm in @INC (@INC contains: /home/jenkins/jobs/Koha_master/workspace/blib/arch /home/jenkins/jobs/Koha_master/workspace/blib/lib <http://jenkins.koha-community.org/job/Koha_master/ws/> /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at <http://jenkins.koha-community.org/job/
13:20 paul_p        chris_n maybe, but in this case, the message is at the very least very unclear !
13:20 chris_n       Koha_master/ws/C4/Koha.pm> line 30.
13:20 chris_n       mj: great!
13:21 paul_p        http://jenkins.koha-community.org/job/Koha_master/lastUnstableBuild/testReport/junit/%28root%29/xt_permissions_t/No_user_permissions_to_add__230_/
13:21 chris_n       mj++ # for filing a bug
13:22 mj            Sorry wahanui, I'm new to irc, I typed the wrong username, I meant jcamins
13:24 chris_n       mj: wahanui is a bot... feel free to ignore his opinions :-)
13:25 mj            ow. well, as I said: new to irc....
13:25 mj            thank for informing me :-)
13:25 jcamins       wahanui: change yourself into a person
13:25 wahanui       jcamins: that doesn't look right
13:26 chris_n       paul_p: Bailout called.  Further testing stopped:  ***** PROBLEMS LOADING FILE 'C4::Message'
13:26 chris_n       # Tests were run but no plan was declared and done_testing() was not seen.
13:26 chris_n       FAILED--Further testing stopped: ***** PROBLEMS LOADING FILE 'C4::Message'
13:26 chris_n       I think that's it
13:26 chris_n       due to the missing dep
13:27 paul_p        OK
13:27 chris_n       jenkins can really spew at times
13:36 oleonard      talljoy around?
13:36 talljoy       yup
13:36 oleonard      Can you describe the contents of the 775 tag causing problems in Bug 8144?
13:36 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8144 critical, P1 - high, ---, oleonard, ASSIGNED , 775 tag in the MARC record causes display issue
13:37 oleonard      I want to make sure I'm testing with the right data
13:37 talljoy       sure  thing.  let me go grab it
13:38 talljoy       =775  1\$aJane's fighting ships$x0075-3025$fenk   is what they had.  but I tested this with only the 775$a field
13:39 jcamins       Wow. Don't see $f often!
13:39 chris_n       up late mtj or early?
13:39 oleonard      Thanks talljoy, I guess I'm seeing the same thing then.
13:39 talljoy       museum library.  crazy cataloging
13:39 talljoy       and lots of authority work jcamins.  you'd love it.
13:39 jcamins       talljoy: that's the kind of library I work with.
13:40 talljoy       yeah.  it's neat stuff.  but sometimes what they need is a bit beyond what Koha can do
13:40 oleonard      Hm, so I guess we have rounded toolbar buttons now in the staff client.
13:43 oleonard      jcamins: How are your XSLT skills? That 775 bug has me stumped.
13:43 jcamins       oleonard: they're not bad.
13:44 oleonard      the same problem happens in both the OPAC and the staff client if you get a chance to take a look.
13:44 jcamins       Did I write that?
13:45 jcamins       Please tell me I didn't write that.
13:45 jcamins       Nope. Wasn't me.
13:46 jcamins       oleonard: talljoy: I'm going to speculate on your web browser of choice...
13:46 jcamins       Firefox?
13:46 wahanui       i guess Firefox is so much better for maximep's use case of opening hundreds of tabs in tab groups. Chrome couldn't do that
13:46 oleonard      Yes
13:47 talljoy       yup firefox
13:47 talljoy       was first seen in Opera tho
13:47 jcamins       Probably also doesn't handle XHTML properly.
13:47 oleonard      Looks the same to me in Chrome
13:48 jcamins       Hmmm... are we marking that page XHTML?
13:48 nengard       leaving the US for the UK tomorrow!!!!
13:48 nengard       :)
13:48 jcamins       We are.
13:48 jcamins       Eh.
13:48 jcamins       Easy enough to fix, anyway.
13:48 jcamins       It's now on my to-do list.
13:49 jcamins       oleonard: actually, I'm putting it back on you're to-do list.
13:49 jcamins       I need to make breakfast.
13:50 jcamins       On line 733, see the with-param?
13:50 oleonard      Yes
13:51 jcamins       Instead of just being 't' it should be 'a_t'
13:51 jcamins       That's an underscore.
13:52 chris_n       don't want rangi to age too fast ;-)
13:52 oleonard      Okay, that fixes the markup problem and outputs the contents of 775$a to the screen. But the term isn't added to the href
13:53 oleonard      jcamins: Something on line 729?
13:55 * oleonard    can wait if jcamins has to bake some crumpets
13:55 maximep       :S
14:00 Barrc         Hello all -  I got a strange one, koha, some bibs show twice (that is the exact same bib number) on staff and OPAC. Rebuilding the indexes sorts out the problem but it reappears after a while and an only a full reindex resolves. Anyone any ideas?
14:01 hdl           Barrc: multiple Local-number definition in your etc/zebradb/marcflavour/biblios/record.abs
14:01 paul_p        Barrc yes, me. how much do you give me for the answer ?
14:01 hdl           may lead to that.
14:01 paul_p        hdl gave the answer for free :D
14:02 hdl           And God knows paul_p is much more open to Grace than I
14:03 paul_p        this usually happens when Local-number is defined for 2 fields in your record.abs. In this case, zebra make mistake when updating (ie= it searches on Local-number #2, while it had previously stored the record with identifier from Local-number #1)
14:03 paul_p        so, zebra think it's not a modification, but a new record. And you get 2 !
14:03 paul_p        HTH
14:03 Barrc         Thanks guys - I will look at that. Pay for play, a IRC first!
14:03 Barrc         It does!. thanks!
14:03 hdl           Insert Coins...
14:03 paul_p        Barrc = you can pay with some signoff (http://bugs.koha-community.org/bugzilla3/buglist.cgi?cmdtype=dorem&remaction=run&namedcmd=Needs%20Signoff&sharer_id=1)
14:04 hdl           Same player shoot again
14:04 * paul_p      has to leave for an hour (meeting with a doctor ;-) )
14:08 jcamins       oleonard: the best thing to do is copy the f773 code from the 773 section, and change it to f775 and use that.
14:08 huginn`       New commit(s) kohagit: Bug 7112 - Having two prices in 020$c causes basket creation to fail from staged... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=285f06e394cd270b978e63173b6cdcb1a0746320> / Bug 8135 : Fix installer to copy services/ dir <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e9c0f206ac35250663ddc59f902d35e89085ef54> / Bug 8128 - [SIGNED-OFF]Followup - Change default value for cache_expiry <http
14:09 jcamins       Hm. I couldn't find the second patch for bug 7318 in master.
14:09 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7318 major, P5 - low, ---, gmcharlt, Passed QA , Filtering Patron Card Creator by Category Code Does Nothing
14:09 jcamins       I wonder why.
14:17 Barrc         hdl: There is no multiple local-number definition in the record.abs - any other ideas?
14:17 jenkins_koha  Starting build #733 for job Koha_master (previous build: FAILURE -- last SUCCESS #731 1 day 16 hr ago)
14:17 jcamins       Barrc: duplicate 999s.
14:17 drojf         hi #koha
14:18 Barrc         no identical, differnt subfields.
14:18 hdl           are your values number only and unique ?
14:19 chris_n       jcmains: there is one patch to fix the controller code and another to fix the view
14:19 * chris_n     whips out his mvc lingo
14:19 Barrc         melm 999$c      Local-Number:n,Local-Number:w,Local-Number:s
14:19 Barrc         melm 999$d      biblioitemnumber:n,biblioitemnumber:w,biblioitemnumber:s
14:19 chris_n       jcamins: http://bugs.koha-community.org/bugzilla3/attachment.cgi?bugid=7318&action=viewall
14:19 chris_n       looks like one may have been obsoleted by accident...
14:20 jcamins       chris_n: no, I obsoleted the one that was already pushed.
14:20 chris_n       opps
14:20 chris_n       :-)
14:20 jcamins       Barrc: I mean your records have two 999 fields.
14:20 huginn`       New commit(s) needsignoff: [Bug 7127] Templates must be valid XHTML <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7127>
14:21 Barrc         Of course; sorry. Yes. I am not with it today. That is the problem - back to the cataloguer so! Thanks, I really should have spotted that.
14:23 chris_n       jcamins: it appears to have been squashed into a single patch
14:23 chris_n       http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=cef7c1b40b403c4bcf0c02b13b60d704e4c8cd83
14:23 jenkins_koha  Project Koha_master build #733: STILL FAILING in 6 min 10 sec: http://jenkins.koha-community.org/job/Koha_master/733/
14:23 jenkins_koha  * julian.maurice: Bug 7178 follow-up: Fix check_additem when UniqueItemFields is empty
14:23 jenkins_koha  * julian.maurice: Bug 7178 follow-up: Do not fill items table with "(undefined)"
14:23 jenkins_koha  * srdjan: bug_7398: Replaced OPACDisplayRequestPriority syspref with OPACShowHoldQueueDetails
14:23 jenkins_koha  * paul.poulain: Bug 7398 follow-up DBRev number
14:23 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7178 enhancement, P5 - low, ---, julian.maurice, Pushed to Master , Improve order item creation
14:23 jenkins_koha  * kyle: Bug 8128 - can't seem to run new sql reports
14:23 jenkins_koha  * kyle: Bug 8128 - [SIGNED-OFF]Followup - Change default value for cache_expiry
14:23 jenkins_koha  * Chris Cormack: Bug 8135 : Fix installer to copy services/ dir
14:23 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7398 enhancement, P5 - low, ---, srdjan, Pushed to Master , Show number of holds on a biblio in the OPAC details
14:23 jenkins_koha  * kyle: Bug 7112 - Having two prices in 020$c causes basket creation to fail from staged marc import
14:23 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8128 blocker, P5 - low, ---, kyle.m.hall, Pushed to Master , can't seem to run new sql reports
14:23 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8135 critical, P1 - high, ---, chris, Pushed to Master , Services Directory and itemrecorddisplay.pl File Missing After Install
14:23 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7112 major, P3, ---, kyle.m.hall, Pushed to Master , Having two prices in 020$c causes basket creation to fail from staged marc import
14:23 jwagner       Barrc, But 6657
14:23 chris_n       note that the changes from the remaining patch are in that commit as well
14:23 jwagner       Bug 6657
14:23 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6657 major, P5 - low, ---, gmcharlt, NEW , Making 999 visible in framework duplicates 999 entry and affects index
14:23 chris_n       jcamins: i'd just cherry-pick that commit and be done
14:24 jcamins       chris_n: you mean apply it off the bug?
14:24 jcamins       That makes sense.
14:24 chris_n       no
14:24 chris_n       I'd revert the first patch and grab the whole commit from master
14:24 jcamins       I didn't cherry pick either patch yet, because I couldn't find the second, and was confused by that.
14:24 chris_n       ahh
14:24 chris_n       in that case I'd just grab it from master
14:25 jcamins       I guess perhaps they could've been squashed together.
14:25 Barrc         jwanger: Thanks, i did search for bugs but the query I used wasn't exact enough.
14:25 chris_n       jcamins: probably by whoever committed them to master
14:25 oleonard      Whoa, since when does huginn` prompt about needs signoff again? That's great.
14:25 chris_n       jcamins: bad practice, that... imho :-)
14:28 chris_n       weirdness abounds... the commit to master is also missing rangi's sign-off
14:29 jcamins       Perhaps I'll just use git-bz to get the two patches.
15:04 reiveune      bye
15:12 magnuse       sorry for the bz spam...
15:13 jcamins       magnuse: if you're closing bugs, you are forgiven.
15:13 magnuse       sorry, i'm not
15:13 jcamins       Aww.
15:13 magnuse       just trying to get an overview of all bugs related to deleting records
15:14 jcamins       Ah.
15:41 paul_p        i'm back
16:00 jcamins       Woohoo!
16:00 jcamins       I think I managed to set up an apt repo!
16:01 * oleonard    gives jcamins a special-edition DVD of "Repo Man" to celebrate
16:06 magnus_afk    jcamins: feel like sharing your discoveries? on the wiki for example?
16:07 jcamins       magnus_afk: it's very easy. Shamelessly crib off of someone else's files.
16:09 jcamins       I guess now I should set up GPG for package signing.
16:10 liw           should I cover setting up an apt repo in the kohacon debian packaging tutorial?
16:11 liw           jcamins, did you use reprepro?
16:11 jcamins       liw: I think that would be very useful.
16:11 jcamins       I did.
16:11 jcamins       Well, am.
16:12 jcamins       :)
16:13 jcamins       Bah.
16:13 jcamins       I forgot the VMs don't have much entropy.
16:19 oleonard      Hi zioha
16:19 chris_n       lunch....
16:19 wahanui       i guess lunch is a good idea :)
16:19 chris_n       as Pooh says
16:20 zioha         hi oleonard
16:49 jcamins       liw: can you suggest anywhere I might find a very basic introduction to gpg-agent and/or debsign?
16:50 jcamins       (specifically, whatever I need to know to sign my packages and apt repo)
16:50 jcamins       It's kind of confusing.
16:51 liw           jcamins, if you use any modern Linux desktop, you should have a gpg agent running (possibly seahorse for gnome); add "use-agent" to your gpg config file, and it will be used
16:51 liw           to sign an upload, "debsign *.changes" should work
16:51 jcamins       Oh, is that what gpg-agent means?
16:51 jcamins       Thanks.
16:52 wizzyrea      liw++
16:52 liw           for signing an apt repo with reprepro, create a key and then add "SignWith: CAFEF00D" to your conf/distributions file for each distro (replace with your own keyid, of course)
16:52 jcamins       Based on the tutorial I was reading, I thought there was a special (separate) gpg-agent program for reprepro.
16:52 liw           ah no, should be the sam eone
16:56 jcamins       Hm. It keeps on giving me a "bad passphrase" error, but never asks for a passphrase.
16:56 jcamins       Oh, I think I found the problem.
16:59 * jcamins     found another problem, too.
17:02 jcamins       Woohoo!
17:02 jcamins       It worked!
17:02 jcamins       Now I have to figure out how to remove the gpg I created wrong.
17:02 * chris_n     needs some of what jcamins had for lunch
17:02 jcamins       chris_n: what?
17:02 * wizzyrea    suspects he had "the joy of discovery" for lunch
17:02 oleonard      Success juice?
17:02 jcamins       lol
17:02 chris_n       whatever caused you to find all of those problems
17:03 jcamins       chris_n: finding *problems* is easy.
17:03 jcamins       It's finding solutions that's more difficult.
17:03 wizzyrea      not with liw around :)
17:03 jcamins       True.
17:03 oleonard      Felix Felicis
17:03 jcamins       liw++
17:03 jcamins       Okay, I guess this extra gpg key isn't hurting anything.
17:03 liw           correct, it shouldn't matter
17:04 liw           gpg --delete-key and gpg --delete-secret-key are there for removing keys, if you want to, though I'm not sure I've ever used them
17:05 jcamins       Oh... I think maybe I got this backwards and that's why that key wasn't working...
17:05 jcamins       The key id I put after SignWith: ... should that be the public key or the private key?
17:06 liw           the key id is the same
17:07 wizzyrea      http://www.cnx-software.com/2012/05/17/74-usd-allwinner-a10-android-4-0-mini-pc-usbhdmi-stick/
17:07 wizzyrea      had to share, that's pretty wicked.
17:08 jcamins       It is?
17:08 jcamins       Uh-oh. I think I'm doing something wrong.
17:08 jcamins       When I generated a key, I ended up with a "pub" line and a "sub" line.
17:09 * jcamins     figures it out.
17:09 jcamins       Maybe.
17:10 liw           pub is the public key, sub is a sub-key
17:10 liw           you only need to care about the if for the public key
17:11 jcamins       Thanks.
17:11 liw           well, technically pub is the public part of the main key, and sub is the public part of the sub-key
17:11 * jcamins     adds and deletes a package from the repo repeatedly.
17:11 liw           if you do "gpg --list-secret-keys" you'll see sec and ssb instead of pub and sub
17:12 jcamins       Is it better to use debsign or dpkg-sign?
17:13 liw           debsign
17:13 liw           I don't even seem to have a dpkg-sign :)
17:13 jcamins       Okay.
17:14 jcamins       Thanks. :)
17:21 sekjal        just had the displeasure of searching our Aleph OPAC for a generic term.
17:21 sekjal        seems that, the larger the result set for your query, the longer it takes to return anything.
17:21 jcamins       sekjal: that favored poetry journal, "The"?
17:22 sekjal        was trying "physics" and "theory", at a few dozen thousand each.  results in 30-45 seconds (the first time)
17:22 sekjal        searched 'the' on a Koha install... 355576 results in 4 seconds
17:23 jcamins       Wow that's depressing.
17:23 sekjal        yeah
17:23 jcamins       As is the rain.
17:23 sekjal        I think Aleph does all it's indexing in the DB
17:24 sekjal        so it needs insane amounts of diskspace, and it's still slower than mud
17:24 sekjal        say what you will about Zebra, at least it's FAST
17:32 jcamins       liw: why would I use dput?
17:33 liw           jcamins, it makes it easier to upload the right files to the repo: you give it the changes file and it finds the right files to upload from that (and also checks that you haven't forgotten to sign)
17:34 jcamins       Gotcha.
17:39 Oak           night.
17:56 jcamins       liw: how does dput know which distribution I want to upload the file to?
17:57 liw           jcamins, dput doesn't care, it just puts the files in the right place; reprepro gets it from the Distribution: header in the .changes file, and it gets put there by dpkg-genchanges and that gets it from debian/changelog
17:57 jcamins       Hm.
17:58 jcamins       I guess that means I have to change it in debian/changelog.
17:59 liw           you can change the .changes file before signing it with debsign, but it's generally better to change debian/chanelog
17:59 jcamins       I guess I also have to figure out what goes in conf/incoming
17:59 jcamins       Yay!
17:59 jcamins       I figured that out!
18:01 liw           jcamins, excellent .)
18:01 jcamins       Except for the changelog bit.
18:01 jcamins       I mean, I now understand where it needs to be changed, but I don't know exactly how to change it.
18:03 jcamins       I think eythian must have some sort of script to do that.
18:04 jcamins       Ah, build-git-snapshot does it.
18:04 liw           I use the dch tool and a text editor to maintain my debian/changelog, plus scripts like biuld-git-snapshot when it needs to happen automatically
18:07 jcamins       I think it's going to take a bit of time for me to get this fully automated.
18:08 * magnus_afk  whispers something almost inaudible about documentation and the wiki, then wanders off
18:08 jcamins       Well, since I forgot about the translations until too late, the release won't be until tomorrow morning anyway.
18:09 jcamins       magnus_away: once I figure out how to do everything, I'll put it on the wiki.
18:09 jcamins       The reason I haven't automated it yet is I'm not yet sure it works.
18:22 wizzyrea      What do you all think of the ability to add user entered titles to lists in the OPAC?
18:22 wizzyrea      And what i mean is, the user types in the title/author of the book
18:23 wizzyrea      in the list, the title would be linked to a search for those terms
18:23 wizzyrea      (since it's not linked to a specific item)
18:23 jcamins       I think that would be very useful.
18:23 wizzyrea      the idea being that users could keep lists of things that are, for example, not published yet, and not in the catalog
18:24 oleonard      Or for maintaining complete lists of things like award-winners which the library may not have all of
18:24 wizzyrea      also a good use for it
18:25 jcamins       Also useful for something like Hamlet.
18:25 jcamins       On a summer reading list
18:25 wizzyrea      so I should uh, file an enh bug for that then >.>
18:26 oleonard      Naw, sounds pointless :P
18:26 * oleonard    kicks over a trash can for emphasis
18:26 jcamins       If you have a big highschool class, pointing them all to the same edition of Hamlet is pointless.
18:26 wizzyrea      lol
18:27 jcamins       You'll end up with an absurd waiting list.
18:27 wizzyrea      that's why you get mulitple copies of the same edition
18:27 wizzyrea      or frbrize your results :P
18:27 wizzyrea      isn't ferber the cry it out guy.
18:28 jcamins       wizzyrea: multiple copies, yes, but if you're not having the students read any of the scholarly apparatus, they could read any of the fifty editions that were purchased over the last century and a half.
18:28 wizzyrea      sure sure :)
18:28 jcamins       And the FRBRized display would be perfect, but we don't have a details view that uses it, do we?
18:28 wizzyrea      don't we? I thought we did.
18:28 wizzyrea      using OCLC
18:29 jcamins       I haven't really used xISBN at all.
18:29 jcamins       I didn't think it consolidated results on the details page, though.
18:30 wizzyrea      not under the "editions" tab?
18:30 jcamins       Right, you have to click through, yes?
18:30 jcamins       I'm thinking "I want a copy of Hamlet that is available now."
18:31 jcamins       With a search, you have a nice green "Copies available for loan" on a particular edition, if there are copies available.
18:31 jcamins       I will turn on xISBN and see what I see. Hold on while I switch databases.
18:31 wizzyrea      http://catalog.nexpresslibrary.org/cgi-bin/koha/opac-detail.pl?biblionumber=55804
18:31 wizzyrea      no need
18:31 wizzyrea      :))
18:31 jcamins       Oh, you have it on.
18:31 jcamins       Excellent!
18:32 jcamins       Yeah, that's exactly what I was picturing.
18:32 jcamins       You have a CSS issue.
18:32 jcamins       It doesn't tell you which of those other editions has a copy available.
18:32 wizzyrea      right, might be able to add it though
18:32 jcamins       When you click on a tab, it loses its border.
18:33 jcamins       That'd also be very snazzy. :)
18:33 jcamins       Very, very snazzy.
18:33 jcamins       Exceedingly snazzy.
18:33 wizzyrea      mmm no it doesn't the border is light light grey
18:33 jcamins       You're right.
18:33 jcamins       At an angle of 5 degrees it has a border.
18:34 wizzyrea      could possibly be improved though.
18:34 jcamins       No border is visible past fifteen degrees. :)
18:36 * jcamins     mutters imprecations about memcached.
18:37 jcamins       We need a "flush cache" button somewhere.
18:39 jcamins       What's the Related tab from? LT?
18:40 wizzyrea      amazon I think
18:40 oleonard      But amazon content is broken?
18:40 wizzyrea      sometimes?
18:40 wizzyrea      reviews definitely are
18:40 oleonard      Only covers work now
18:40 oleonard      The API changed and no one updated Koha to match
18:40 wizzyrea      sometimes we get a related
18:41 wizzyrea      and we get title notes
18:41 oleonard      Not from Amazon you don't
18:41 jcamins       Where do you get the title notes from?
18:41 wizzyrea      au contraire, i'm looking at one
18:41 oleonard      ?!
18:41 wizzyrea      http://catalog.nexpresslibrary.org/cgi-bin/koha/opac-detail.pl?biblionumber=55804
18:41 jcamins       'Cause those title notes are pretty impressive.
18:42 * wizzyrea    is almost positive those are coming from amazon
18:42 jcamins       Ohhh.
18:42 jcamins       Syndetics.
18:42 jcamins       No.
18:42 wizzyrea      no syndetics in our catalog
18:43 jcamins       LTFL?
18:43 jcamins       Huh.
18:43 jcamins       Amazon.
18:44 jcamins       I didn't think that worked.
18:44 jcamins       Those are nice.
18:44 jcamins       Maybe I need to enable that.
18:47 oleonard      Why not for this book? http://catalog.nexpresslibrary.org/cgi-bin/koha/opac-detail.pl?biblionumber=126609
18:47 * oleonard    looked for a record in both our catalogs
18:48 * wizzyrea    doesn't know
18:50 jcamins       Gnomes.
18:50 jcamins       Or elves.
18:50 wizzyrea      it's not in the MARC
18:50 wizzyrea      for hamlet
18:50 jcamins       No, definitely not in the MARC.
18:51 wizzyrea      but you know there's nothing in the preferences about title notes from amazon
18:51 wizzyrea      period
18:51 jcamins       It's just AmazonEnabled.
18:52 wizzyrea      yup, sho nuff.
18:52 wizzyrea      I just turned it off and the title notes disappeared (it's back now)
18:54 oleonard      Not back on this one: http://catalog.nexpresslibrary.org/cgi-bin/koha/opac-detail.pl?biblionumber=55804
18:55 wizzyrea      oh, it's, weirdly
18:55 wizzyrea      reviews
18:58 wizzyrea      oleonard: should be back on now
18:59 wizzyrea      also, oleonard - on this one too: http://catalog.nexpresslibrary.org/cgi-bin/koha/opac-detail.pl?biblionumber=126609
19:00 wizzyrea      so if you turn off reviews, you lose title notes
19:00 wizzyrea      that seems… not right.
19:00 jcamins       wizzyrea: well, it's retrieving editorial reviews from Amazon, so that does make a certain amount of sense.
19:37 gonzalo       hello :D
19:38 gonzalo       i have any question :C
19:39 jcamins       gonzalo: ask your question, and if anyone can answer, they will.
19:40 * jcamins     posts a patch for bug 6557
19:40 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6557 normal, P3, ---, jcamins, Needs Signoff , biblioitems.totalissues unused
19:40 jcamins       nengard: you might like that one. :)
19:40 nengard       a patch?????
19:40 wahanui       rumour has it a patch is pretty old now, good luck
19:41 nengard       jcamins++
19:41 jcamins       nengard: well, three, actually.
19:41 nengard       catching up on emails (including bug emails) now before heaing to uk tomorrow
19:41 nengard       will get to that one soon
19:41 jcamins       :)
19:41 jcamins       Are you flying into EDI?
19:44 nengard       no
19:44 nengard       Manchester
19:44 nengard       and staying with friends near there for a week
19:44 nengard       (ish)
19:44 jcamins       Nifty. I was on a train that went through Manchester.
19:45 jcamins       That's all the time I spent there, though.
19:46 rangi         Morning
19:46 jcamins       Morning.
19:46 wahanui       morning is a state of mind. or whenever the cat wants breakfast.
19:47 wizzyrea      mornin
19:48 rangi         Hmm
19:48 * rangi       will fix Jenkins at work
19:50 rangi         chilts: u in town today?
19:55 gonzalo       the users save in database u other file?
19:56 slef          was about to ask how nengard was getting to EDI but then remember the car hire question
19:56 jcamins       nengard: remember they drive on the wrong side of the road! ;)
19:56 slef          shouldn't need a GPS for MAN-EDI: M6, A74, A702 from memory.
19:56 nengard       i've driven in england before
19:56 nengard       and NZ
19:56 nengard       :)
19:56 slef          I will drive in the US for the first time later this year.
19:57 mbalmer       RFID and SIP2 will be my topics.  sigh.
19:57 nengard       slef, i'm driving around buxton and ? i forget the other town and then to York and then New Castle area and then EDI
19:57 nengard       slef where you going/coming?
19:57 mbalmer       topics for the Koha Highland Gamn
19:57 slef          It will be my first time driving on the right and my first time in ages, if ever, in an automatic.
19:57 mbalmer       Games, that is.
19:57 slef          mbalmer: sorry to upset you, but Edinburgh is on the coast, not the highlands ;-)
19:58 mbalmer       heh, I know...
19:58 slef          nengard: Atlanta to Miami
19:58 rangi         I can't imagine drivers in the UK could be as insane as nz
19:58 slef          rangi: hahahahahahaahah
19:58 slef          I've been driving far too much lately, what with the coast-to-coast move.
19:59 slef          I've now a very dim view of other drivers.
19:59 slef          The best time to drive is when no bugger else is around.
19:59 rangi         The US driving was a breeze compared to here
19:59 gonzalo       what is the table for save users
19:59 gonzalo       ?
19:59 rangi         Borrowers
19:59 slef          rangi: you have challenging roads in NZ :) but it is pretty quiet
19:59 rangi         True
20:00 nengard       slef driving down there will be fine
20:00 nengard       it's going north from there that you have the crazies (like me) :)
20:00 gonzalo       i need the change password
20:00 gonzalo       but for database
20:00 slef          rangi: most of the UK is much much busier :-/
20:00 jcamins       gonzalo: for changing users' password, you need to use Koha.
20:00 rangi         I'll take the bus
20:01 jcamins       The database password is managed by MySQL, so you just have to change it using MySQL, and then adjust the koha-conf.xml configuration file.
20:01 chris_n       heya rangi, slef
20:01 rangi         Heya Chris_n
20:01 slef          rangi: bus is good for short journeys, or where there is no rail.
20:02 slef          wow... if you blank your user-agent, wikipedia refuses to talk to you
20:02 rangi         Yep, I have the edi bus app on my phone
20:02 gonzalo       jcamins: what is the table for save users?
20:04 chris_n       a cool irc feature would be a hint when you hover over a username giving that user's current TOD
20:04 jcamins       gonzalo: borrowers, but knowing that is not going to help.
20:04 jcamins       First question?
20:04 wahanui       "What are you trying to do?"  "What is the goal?" or "What problem are you experiencing?"
20:04 rangi         Conveniently the bus from my hotel to the uni goes close to nengard's hotel
20:04 nengard       :)
20:04 jcamins       rangi: where are you staying?
20:04 nengard       convenient for me :) cause I'm staying away from buses if I can
20:04 slef          chris_n: Time Of Death?
20:05 rangi         The cairn hotel
20:05 chris_n       ouch!
20:05 chris_n       time of day... hopefully :)
20:05 slef          chris_n: have I been watching too many policiers?
20:05 nengard       hehe
20:05 chris_n       lol
20:05 slef          chris_n: /ctcp NICKNAME time
20:05 jcamins       rangi: wow, way up Leith Walk.
20:05 chris_n       ahh... cool
20:06 rangi         Will be wrong for me
20:06 slef          yeah it's consensual too
20:06 rangi         Cos I am relaying
20:06 jcamins       Okay, not that far.
20:06 rangi         Thru bugs
20:06 chris_n       ahh
20:06 rangi         9 mins on bus apparently
20:07 rangi         With a little walk either end
20:08 jcamins       9 minutes? Huh. I would've thought it would be a bit longer.
20:09 * jcamins     rarely went north of Princes Street.
20:09 rangi         I take timetables with a grain of salt
20:10 rangi         :)
20:10 rangi         Oh yeah
20:10 rangi         There is tipping in UK eh?
20:11 jcamins       Yeah, though not so generous as in the US.
20:12 gonzalo       i need change password for admin user
20:12 gonzalo       how do ?
20:12 slef          jcamins: 10% for good service IIRC
20:12 rangi         I never remember who u are supposed to tip
20:12 rangi         Taxis eh?
20:12 oleonard      Web developers
20:12 rangi         Heh
20:12 jcamins       gonzalo: if for the database administrator user, you have to change the password using mysqladmin (or the like).
20:13 slef          oleonard: no, you bitch and whine at them.
20:13 rangi         By kind to your mother
20:13 slef          oleonard: same as everywhere.
20:13 rangi         There's ur tip
20:13 * oleonard    is back from hearing a sales pitch on Freeding and Freegal
20:13 gonzalo       jcamins: i need change password for koha user no for database
20:13 slef          rangi: restaurant waiters/waitresses, taxis, hotel chambermaid...
20:13 rangi         Same thing
20:14 rangi         Ahhh
20:14 jcamins       gonzalo: then you have to log into Koha with your database user and change the user's password.
20:14 slef          rangi: tour guides are inconsistent I think
20:14 rangi         Yeah
20:14 slef          "Visitors from The US and Canada are seen as very generous tippers and even a bit of a soft touch by some" http://wikitravel.org/en/United_Kingdom
20:14 rangi         Ok my stop brb
20:15 rangi         Nzers as stingy
20:15 slef          only because you can't cope with the £
20:15 gonzalo       jcamins: but what is the table users ?
20:15 slef          hehehe I love these tips
20:15 slef          "Don't tap money on the bar surface to attract the barman's attention."
20:16 jcamins       gonzalo: I'm sorry, I don't think I can help.
20:16 gonzalo       ok thanks :d
20:16 slef          "In the male toilets, especially in big pubs or clubs, don't try to strike up conversation or make prolonged eye contact."
20:16 jcamins       gonzalo: user information is stored in the borrowers table, but I think you're looking for something else that I don't know the answer to.
20:16 wizzyrea      nzers are stingy because they don't tip because people there make a living wage, or so the cultural advice claims.
20:17 wizzyrea      wait that sentence made no sense.
20:17 jcamins       Nope.
20:17 wizzyrea      clearly I am too hungry and tired to speak.
20:17 slef          ooh good idea... dinnertime
20:17 jcamins       wizzyrea: you should have some spanakopita.
20:17 jcamins       Or cookies.
20:17 wahanui       Cookies are delicious delicacies
20:17 jcamins       Or both!
20:17 slef          aaaaah coookies!
20:17 slef          don't talk to me about cookies!
20:17 wizzyrea      nzers aren't stingy, they just don't tip because people make a living wage.
20:17 jcamins       slef: have a biscuit.
20:17 wizzyrea      don't need tips to pad their wages.
20:17 jcamins       slef: better?
20:18 gonzalo       What is the table that stores the users of koha?
20:18 wizzyrea      borrowers
20:18 slef          supposedly the cookie law is being enforced from Friday
20:18 slef          so I've been discovering which sites still are sending cookies without asking permission
20:18 slef          and trying to fix them
20:19 * oleonard    is back to wondering how wizzyrea can have Amazon title notes and he can't
20:20 oleonard      http://catalog.nexpresslibrary.org/cgi-bin/koha/opac-detail.pl?biblionumber=285498
20:20 oleonard      http://search.myacpl.org/cgi-bin/koha/opac-detail.pl?biblionumber=58601
20:20 wizzyrea      3.6.4?
20:20 wahanui       3.6.4 is the current stable version
20:21 slef          rangi: I think up to 10% tip in restaurants, maybe similar in taxis but maximum a few pounds, a small note in hotels... and all only if the service was good.
20:21 wizzyrea      oleonard: what version do you have?
20:21 oleonard      3.6.1
20:21 jcamins       oleonard: maybe it was fixed between 3.6.1 and 3.6.4?
20:21 * oleonard    wonders how wizzyrea rated an upgrade and he didn't
20:22 rangi         slef: thank you :)
20:22 slef          "Most cities have designated cycle-lanes although they are routinely ignored by drivers" :)
20:22 oleonard      Who has worked on the Amazon API at all in the last 3 or 4 years? No one that I know of.
20:22 jcamins       oleonard: good question.
20:22 wizzyrea      I had the friendly people at bywater do it for me
20:23 rangi         oleonard: i gave up when they kept changing it
20:23 rangi         woot git-annex-assistant passed 100%!
20:25 francharb_afk http://wikitravel.org/en/United_Kingdom : I love the eat section -> Fish and chips ... Curry  ... Children...
20:25 jcamins       oleonard: maybe some of the ...
20:25 francharb_afk is it common to eat children in the uk?
20:25 jcamins       francharb_afk: I recommend against eating that last.
20:25 jcamins       :D
20:25 francharb_afk ;)
20:26 slef          francharb_afk: I like children. But I couldn't eat a whole one.
20:26 jcamins       oleonard: anyway, maybe it was some of the ISBN cleaning stuff?
20:26 ASUSunDevil   hey all, I was here a couple days ago asking questions about installing Koha 3.8, I have decided to go with Ubuntu 12.04 LTS server. I'm set now to start the install process, and was wondering if this guide is appropriate for doing this install (even thought it's for 3.4): http://wiki.koha-community.org/wiki/Koha_on_Lucid_using_Koha_packages . Also the guide seems to be for an olde vesion of
20:26 ASUSunDevil   Ubuntu as well. Or is there a good document to follow for the installation on this platform using packages?
20:27 rangi         ASUSunDevil: use the one for debian, it will work fine for 12.04
20:27 rangi         lemme get it for you
20:27 slef          ASUSunDevil: the INSTALL or INSTALL.debian files in the download should be OK.
20:27 rangi         packages?
20:27 wahanui       i think packages is at http://wiki.koha-community.org/wiki/Debian
20:27 slef          or that
20:27 rangi         http://wiki.koha-community.org/wiki/Koha_3.8_on_Debian_Squeeze
20:27 ASUSunDevil   awesome...thank you!
20:27 rangi         if you want to do some testing
20:28 rangi         https://code.launchpad.net/~chris-bigballofwax/+archive/3.8.x-dailybuild
20:28 slef          http://wiki.koha-community.org/wiki/Category:Debian_Packages
20:28 francharb_afk "Urinating in public is now against the law"
20:28 francharb_afk now?
20:28 wahanui       i think now is good time with holidays coming up
20:29 francharb_afk was it that common?
20:29 francharb_afk ;)
20:29 ASUSunDevil   I was running 3.4, but was having some issues, and it was suggested to me to upgrade to 3.8, since Ubuntu and Debian seem to be the standard distros used, I wanted to keep it standard. I'l follow the debian document... thanks again!
20:29 jcamins       rangi: ooh, can you have periods and numbers in distribution names?
20:29 slef          francharb_afk: still is...
20:29 francharb_afk I live in france, the no public toilet country
20:29 rangi         ASUSunDevil: there are packages for precise there, in that ppa, but its my daily build of 3.8.x so tracks ahead of the release slightly
20:29 slef          francharb_afk: mostly after pubs close on Fri and Sat
20:29 slef          francharb_afk: hey, bestiality only became illegal here in 1994!
20:30 sekjal        night, #koha
20:30 slef          bye
20:30 francharb_afk slef, guess it's the same here...
20:30 oleonard      night, #koha
20:30 jcamins       Smoking in pubs is illegal in Edinburgh.
20:30 francharb_afk ++
20:30 slef          smoking in any indoor space is illegal I think?
20:30 slef          in all of UK
20:31 francharb_afk smoking should be illegal anyway
20:31 francharb_afk ;)
20:31 jcamins       slef: I don't know, but I was first there, pubs were so smoky I couldn't bring myself to go to them with friends.
20:31 slef          exception of some hotel rooms (enquire when booking)
20:31 jcamins       *when I was first there
20:31 jcamins       When I went back, all pubs were smoke free, which meant that pub-based socialization was possible.
20:32 slef          jcamins: yeah, it's much better, except that you cannot smoke a kipper for breakfast while on your night out.
20:32 francharb_afk slef, by the way, I've got a workshop proposal for the hackfest. is it still ok to propose it?
20:33 jcamins       Wow. School is out.
20:33 francharb_afk alice cooper?
20:33 francharb_afk ;)
20:33 slef          francharb_afk: maybe. Look at the schedule on the wiki. I can't remember.
20:33 francharb_afk oki
20:34 francharb_afk slef, it's more about feature testing that coding...
20:34 slef          "exchange your Scottish notes for Bank of England notes before you leave the country."
20:34 rangi         http://jenkins.koha-community.org/job/Koha_master/733/
20:34 rangi         heh, we broke even on checkstyle
20:34 slef          francharb_afk: sorry I must pass out now
20:34 rangi         fixed 40, broke 40
20:35 francharb_afk well, I will send something on the koha list to see if anybody is interesting!
20:35 francharb_afk and i need to sleep too
20:35 francharb_afk I started this morning at 6:30 and it's 22:30...
20:35 francharb_afk lol
20:36 francharb_afk it's insane
20:36 francharb_afk night all
20:36 rangi         night francharb_afk
20:36 kathryn       morning
20:37 rangi         chris_n: sample quote data
20:38 rangi         oh nvm
20:38 rangi         found it
20:39 ASUSunDevil   rangi: following the debain squeeze install for Ubuntu 12.04, I issued the apt-get install koha-common and I get a complaint about linnet-z3950-zoom-perl, idzebra-2.0 and yaz not being installed. Is there a way I can get apt-get to install these dependencies?
20:40 rangi         interesting, those are not in precise?
20:40 rangi         do you have multiverse selected?
20:40 jcamins       ASUSunDevil: lib-net-z3950-zoom-perl?
20:40 ASUSunDevil   sorry, yes lib-net-z39050-zoom-perl
20:41 wizzyrea      ASUSunDevil: I think there are instructions on the wiki for ubuntu
20:41 jcamins       ASUSunDevil: okay, just checking it wasn't a typo in the package.
20:41 rangi         https://launchpad.net/ubuntu/precise/+package/libnet-z3950-zoom-perl
20:41 rangi         its in precise
20:42 rangi         check your sources.list
20:42 jcamins       You need to enable "universe."
20:42 rangi         http://packages.ubuntu.com/precise/libnet-z3950-zoom-perl  <-- its in the universer
20:42 rangi         -r
20:43 ASUSunDevil   these are all enabled in sources.list:
20:43 ASUSunDevil   deb http://us.archive.ubuntu.com/ubuntu/ precise universe
20:43 ASUSunDevil   deb-src http://us.archive.ubuntu.com/ubuntu/ precise universe
20:43 ASUSunDevil   deb http://us.archive.ubuntu.com/ubuntu/ precise-updates universe
20:43 ASUSunDevil   deb-src http://us.archive.ubuntu.com/ubuntu/ precise-updates universe
20:43 ASUSunDevil   do I just need to add the one for lib-net... ?
20:44 rangi         no its in the universe, can you cut and paste the exact error?
20:44 jcamins       According to the website, it's included in the first.
20:44 * rangi       tests on a precise vm
20:45 jenkins_koha  Starting build #734 for job Koha_master (previous build: STILL FAILING -- last SUCCESS #731 1 day 22 hr ago)
20:45 ASUSunDevil   after I enter the "apt-get install koha-common", I get:
20:45 ASUSunDevil   Reading package lists... Done
20:45 ASUSunDevil   Building dependency tree
20:45 ASUSunDevil   Reading state information... Done
20:45 ASUSunDevil   Some packages could not be installed. This may mean that you have
20:45 ASUSunDevil   requested an impossible situation or if you are using the unstable
20:45 ASUSunDevil   distribution that some required packages have not yet been created
20:45 ASUSunDevil   or been moved out of Incoming.
20:45 ASUSunDevil   The following information may help to resolve the situation:
20:45 ASUSunDevil   The following packages have unmet dependencies:
20:45 ASUSunDevil   koha-common : Depends: libnet-z3950-zoom-perl but it is not going to be installed
20:45 ASUSunDevil   Depends: idzebra-2.0 but it is not going to be installed
20:45 ASUSunDevil   Depends: yaz but it is not going to be installed
20:45 ASUSunDevil   E: Unable to correct problems, you have held broken packages.
20:45 ASUSunDevil   koha@spllib:~$
20:45 rangi         weird, all three are in the universe
20:46 pastebot      "rangi" at pasted "apt-cache policy idzebra-2.0 i" (8 lines) at http://paste.koha-community.org/409
20:47 rangi         what happens if you just apt-get install idzebra-2.0
20:47 ASUSunDevil   oh, and something else, this is on an i386 machine, not an amd64 install
20:47 ASUSunDevil   let me try that command
20:48 rangi         http://packages.ubuntu.com/precise/libnet-z3950-zoom-perl  <-- says for i386 and amd64
20:48 wizzyrea      ASUSunDevil: http://wiki.koha-community.org/wiki/Koha_on_Lucid_using_Koha_packages
20:48 wizzyrea      it has you add the sources from indexdata
20:48 jcamins       ASUSunDevil: how much memory in the machine?
20:49 jcamins       wizzyrea: but that's only for 10.04.
20:49 jcamins       I haven't needed to do that since 10.10 came out.
20:49 rangi         wizzyrea: yeah, don't do that for 12.04
20:49 ASUSunDevil   If I issue the apt-get for just idzebra, I get:
20:49 ASUSunDevil   Reading package lists... Done
20:49 ASUSunDevil   Building dependency tree
20:49 ASUSunDevil   Reading state information... Done
20:49 ASUSunDevil   Some packages could not be installed. This may mean that you have
20:49 ASUSunDevil   requested an impossible situation or if you are using the unstable
20:49 ASUSunDevil   distribution that some required packages have not yet been created
20:49 ASUSunDevil   or been moved out of Incoming.
20:49 ASUSunDevil   The following information may help to resolve the situation:
20:49 ASUSunDevil   The following packages have unmet dependencies:
20:49 ASUSunDevil   idzebra-2.0 : Depends: idzebra-2.0-utils (= 2.0.50-1indexdata) but it is not going to be installed
20:49 ASUSunDevil   Depends: libidzebra-2.0-modules but it is not going to be installed
20:49 ASUSunDevil   E: Unable to correct problems, you have held broken packages.
20:49 wizzyrea      i haven't done it on 12 yet
20:49 jcamins       wizzyrea: don't be offended!
20:49 wizzyrea      i'm not!
20:49 rangi         theres something mucked up in your ubuntu
20:50 jcamins       wizzyrea: :)
20:50 rangi         but im not sure what
20:50 wizzyrea      my colloquy, ever since I got lion (curses!) goes funky sometimes
20:50 rangi         ive got a fix for that too wizzyrea  :)
20:50 ASUSunDevil   hmm, fresh install, haven't really done anything but setup network and enabled a basic firewall using ufw...
20:50 wizzyrea      me too ^.^
20:50 wizzyrea      I call it "a hammer"
20:50 rangi         yeah, all those packages are in precise tho, in the universe so it seems weird
20:51 wizzyrea      I call it "a hammer"
20:51 rangi         wizzyrea: i was gonna go with debian .. but that works too
20:51 jcamins       rangi: not that version, though.
20:51 jcamins       rangi: maybe ASUSunDevil somehow managed to get sid packages?
20:51 jcamins       Not sid.
20:51 jcamins       Whatever the Ubuntu equivalent is.
20:51 rangi         quantal
20:51 * wizzyrea    grumbles
20:51 jcamins       That's the one.
20:51 jcamins       Quantal?
20:52 ASUSunDevil   hmm, I'm going to reboot again just to be sure
20:52 rangi         dont do that
20:52 rangi         its not windows :)
20:52 ASUSunDevil   lol
20:52 jcamins       ASUSunDevil: how much RAM do you have? My rule of thumb is that there is no reason to use i386 anymore.
20:53 rangi         can you do
20:53 ASUSunDevil   I have 2gb on this machine, it's just a test machine, and it's just a 32bit machine....
20:53 rangi         apt-cache-policy  idzebra-2.0
20:53 jcamins       ASUSunDevil: well, if it only supports i386, that's a good reason.
20:53 jcamins       :)
20:55 ASUSunDevil   hmm, apt-cache-policy: command not found
20:55 rangi         sorrry typo
20:55 rangi         apt-cache policy idzebra-2.0
20:56 ASUSunDevil   koha@spllib:~$ apt-cache policy idzebra-2.0
20:56 ASUSunDevil   idzebra-2.0:
20:56 ASUSunDevil   Installed: (none)
20:56 ASUSunDevil   Candidate: 2.0.50-1indexdata
20:56 ASUSunDevil   Version table:
20:56 ASUSunDevil   2.0.50-1indexdata 0
20:56 ASUSunDevil   500 http://ftp.indexdata.dk/ubuntu/ lucid/main i386 Packages
20:56 ASUSunDevil   2.0.49-1indexdata 0
20:56 ASUSunDevil   500 http://ftp.indexdata.dk/ubuntu/ lucid/main i386 Packages
20:56 ASUSunDevil   2.0.48-1indexdata 0
20:56 ASUSunDevil   500 http://ftp.indexdata.dk/ubuntu/ lucid/main i386 Packages
20:56 ASUSunDevil   2.0.47-1indexdata 0
20:56 ASUSunDevil   500 http://ftp.indexdata.dk/ubuntu/ lucid/main i386 Packages
20:56 rangi         ah ha!!!
20:56 ASUSunDevil   2.0.45-1indexdata 0
20:56 ASUSunDevil   500 http://ftp.indexdata.dk/ubuntu/ lucid/main i386 Packages
20:56 ASUSunDevil   2.0.44-3 0
20:56 ASUSunDevil   500 http://us.archive.ubuntu.com/ubuntu/ precise/universe i386 Packages
20:56 ASUSunDevil   2.0.44-1indexdata 0
20:56 ASUSunDevil   500 http://ftp.indexdata.dk/ubuntu/ lucid/main i386 Packages
20:56 rangi         you did did at the indexdata stuff
20:56 ASUSunDevil   koha@spllib:~$
20:56 rangi         get rid of that !
20:56 rangi         and do an apt-get update stuff again
20:57 ASUSunDevil   oh, so get rid of: #Index Data (Zebra) sources
20:57 ASUSunDevil   deb http://ftp.indexdata.dk/ubuntu lucid main
20:57 ASUSunDevil   deb-src http://ftp.indexdata.dk/ubuntu lucid main
20:57 ASUSunDevil   #Koha .deb packages (Koha-community)
20:57 ASUSunDevil   deb http://debian.koha-community.org/koha squeeze-dev main
20:57 rangi         yes those 2 lucid lines
20:57 rangi         burn with fire
20:57 rangi         :)
20:57 ASUSunDevil   leave the squeeze line?
20:57 rangi         yes but not squeeze-dev
20:57 rangi         just squeeze
20:58 rangi         squeeze-dev will get you packages built from master
20:58 jcamins       Sorry folks, 3.6.5 is going to be one day late.
20:58 rangi         squeeze is the stable branch .. 3.8.1
20:58 ASUSunDevil   ok, let me try that...
20:59 rangi         you must have tried following the lucid instructions
20:59 jcamins       rangi: liw: could I have apt distributions called '3.6.x' and '3.6-testing'?
20:59 ASUSunDevil   originally I did, yes
20:59 jcamins       I'm afraid to try it because I got the repo working.
20:59 liw           jcamins, I don't see why not
20:59 jcamins       Woohoo!
21:00 jcamins       I will try.
21:00 ASUSunDevil   so, the only thing i have in sources.list is:
21:00 ASUSunDevil   #Index Data (Zebra) sources
21:00 ASUSunDevil   deb http://debian.koha-community.org/koha squeeze main
21:00 rangi         jcamins: we have staging and production distros
21:00 ASUSunDevil   other than the defaults, is that correct?
21:00 rangi         so yeah, cant see why not
21:00 rangi         looks correct me ASUSunDevil
21:00 rangi         try an apt-get update
21:01 rangi         then check the apt-cache policy again
21:01 rangi         and if it says from precise this time, give the install another go
21:02 ASUSunDevil   ok, let me try that really quick
21:11 ASUSunDevil   ok, install is looking good, had something mucked up with my network settings after my reboot, but I got that fixed. It looks like the install via apt-get is working now...
21:12 jcamins       Yay! 3.6.x works fine as a distribution code.
21:16 rangi         sweet
21:31 jcamins       If I push . to @INC, will child processes inherit that?
21:31 rangi         i think so
21:32 jenkins_koha  Starting build #25 for job Koha_3.8.x (previous build: SUCCESS)
21:45 jenkins_koha  Yippie, build fixed!
21:45 jenkins_koha  Project Koha_master build #734: FIXED in 1 hr 0 min: http://jenkins.koha-community.org/job/Koha_master/734/
21:48 rangi         yay!
22:21 chilts        rangi: yeah, on the way in now
22:21 rangi         wanna meet for lunch?
22:21 chilts        yeah, sounds good
22:21 rangi         excellent
22:21 chilts        name a time and place and I'll be there
22:22 ASUSunDevil   rangi: ok, install via apt-get worked just fine, but now I'm having issues with the rest of the configuration/install... On the document: http://wiki.koha-community.org/wiki/Koha_3.8_on_Debian_Squeeze I am athe quickstart portion, but I'm not sure what I need to put in these areas...can you walk me through it to get the site running?
22:22 rangi         chilts: where's your office at?
22:22 jcamins       rangi: when did you create that page?
22:22 * jcamins     looks at thie history.
22:23 jcamins       It's good to have it updated to the current version.
22:23 rangi         that was eythian
22:23 jcamins       eythian++
22:24 chilts        rangi: top of Willis St, so I'm accessible down your side of Willis
22:24 rangi         oh excellent
22:24 rangi         bristol at 12.30 ?
22:24 chilts        top being the State Tower side ... but yeah, Bristol sounds good
22:25 rangi         excellent, see you then
22:25 chilts        I went to Bristol with Urvesh last week, but you probably never worked with him
22:25 chilts        saw TimW last week too :)
22:25 chilts        tell you more later
22:25 rangi         cool :)
22:25 rangi         ASUSunDevil: what bit is confusing you?
22:25 rangi         heres what mine looks like
22:27 ASUSunDevil   well, for the koha-sites.conf file, I tried to put in some defaults the way I thought they should be, but it didn't seem to work. After completing the rest, I couldn't pull the site up in a browser. By the way, being this is a server, there is no X installed, so I am trying to access the site from a different compuer...
22:27 pastebot      "rangi" at pasted "koha-sites.conf" (4 lines) at http://paste.koha-community.org/410
22:28 rangi         http://paste.koha-community.org/  <-- can you paste yours in here
22:28 ASUSunDevil   sure, give me a second...
22:30 jenkins_koha  Project Koha_3.8.x build #25: SUCCESS in 57 min: http://jenkins.koha-community.org/job/Koha_3.8.x/25/
22:30 jenkins_koha  * julian.maurice: Bug 7178 follow-up: Fix check_additem when UniqueItemFields is empty
22:30 jenkins_koha  * julian.maurice: Bug 7178 follow-up: Do not fill items table with "(undefined)"
22:30 jenkins_koha  * Chris Cormack: Bug 8135 : Fix installer to copy services/ dir
22:30 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7178 normal, P5 - low, ---, julian.maurice, Pushed to Stable , Improve order item creation
22:30 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8135 critical, P1 - high, ---, chris, Pushed to Stable , Services Directory and itemrecorddisplay.pl File Missing After Install
22:30 jenkins_koha  Starting build #26 for job Koha_3.8.x (previous build: SUCCESS)
22:30 pastebot      "ASUSunDevil" at pasted "koha-sites.conf" (10 lines) at http://paste.koha-community.org/411
22:30 rangi         id remove the defaultsql line
22:31 rangi         only needed if you're pre-populating from another Koha database
22:31 ASUSunDevil   ok, remove the whole line?
22:31 rangi         other than that it looks ok
22:31 rangi         yep or comment it out with a # at the start
22:32 ASUSunDevil   ok, commented it out. I want to admin site on the 8080 port and the public (opac) site on the 80 port, so those settings are ok?
22:33 rangi         yep
22:33 ASUSunDevil   ok, then the next thing I do is issue the a2enmod rewrite, it tells me that is already enabled, so am I good on that?
22:33 rangi         yup
22:34 ASUSunDevil   MySQL is already installed, so I can ignore that. I am not running a remote mysql server, so I skip the /etc/koha/passwrd file step, right?
22:36 rangi         yep
22:37 rangi         can you do me a quick check
22:37 ASUSunDevil   ok, so now, I do the sudo koha-create --create-db biblio command, and I get:
22:37 ASUSunDevil   koha@spllib:~$ sudo koha-create --create-db biblio
22:37 ASUSunDevil   cat: /etc/koha/passwd: No such file or directory
22:37 ASUSunDevil   sed: -e expression #7, char 144: unterminated `s' command
22:37 ASUSunDevil   sure, what check?
22:38 rangi         look in /etc/mysql is there a koha-common.cnf file ?
22:38 ASUSunDevil   yes, it is a symlink to debian.cnf
22:38 rangi         cool
22:39 rangi         in that case it does seem that you now need the /etc/koha/passwd file
22:40 ASUSunDevil   ok, so in that file, what is the instancename supposed to be?
22:40 rangi         whateever you are planning to pass to koha-create .. looks like you want to call your koha site biblio
22:40 rangi         so biblio
22:41 ASUSunDevil   whatabout the database name then, isn't that the same thing?
22:41 rangi         it is
22:41 ASUSunDevil   ok
22:41 rangi         so you are making biblio.la.asu.edu
22:41 rangi         by calling that koha-create command
22:41 rangi         make sense?
22:42 ASUSunDevil   oh, ok, actually I want it to be called spllib.la.asu.edu
22:42 rangi         then spllib is your instancename, and pass that to koha-create too
22:42 rangi         you can have multiple instances on one machine, using the packages
22:42 rangi         all using the same code base, but different databases
22:43 ASUSunDevil   so the first part and the last part in that /etc/koha/passwd is the same thing, in my case, right?
22:43 rangi         hmm?
22:43 rangi         ah yeas
22:43 ASUSunDevil   ok, cool
22:43 rangi         i think so
22:45 ASUSunDevil   ok, so I ran the koha-create again, and I got:
22:45 ASUSunDevil   koha@spllib:~$ sudo koha-create --create-db spllib
22:45 ASUSunDevil   sed: -e expression #7, char 144: unterminated `s' command
22:47 rangi         hmm no idea then, jcamins/ eythian  any ideas?
22:47 ASUSunDevil   oh, I figured it out, there was a missing
22:47 ASUSunDevil   "
22:47 ASUSunDevil   in my sites file
22:47 rangi         ahhh
22:47 rangi         that would do it
22:48 ASUSunDevil   ok, I did that command and I get: user spllib-koha already exits
22:48 ASUSunDevil   this might be becuase I tried this a few times before coming back here...is there anything I need to do?
22:48 rangi         can you do a mysqlshow -uroot -p
22:49 rangi         and see if it created the db
22:49 ASUSunDevil   +--------------------+
22:49 ASUSunDevil   |     Databases      |
22:49 ASUSunDevil   +--------------------+
22:49 ASUSunDevil   | information_schema |
22:49 ASUSunDevil   | koha_biblio        |
22:49 ASUSunDevil   | mysql              |
22:49 ASUSunDevil   | performance_schema |
22:49 ASUSunDevil   | spllib             |
22:49 ASUSunDevil   | test               |
22:49 ASUSunDevil   +--------------------+
22:49 ASUSunDevil   looks like it did
22:49 rangi         cool
22:49 rangi         try apache2ctl restart
22:49 rangi         and then hit the site, and see if you get the web based installer
22:50 ASUSunDevil   ok, just restared...I just get the default website "It Works!" on spl.la.asu.edu and if I try the :8080 port, nothing....
22:51 ASUSunDevil   this is where I was at when I came back....not sure where to go from here
22:51 rangi         check /etc/apache2/sites-enabled
22:52 rangi         is there a splib file in there ?
22:52 ASUSunDevil   oh, looks like the old one is still there, all that's in there is:
22:52 ASUSunDevil   " ============================================================================
22:52 ASUSunDevil   " Netrw Directory Listing                                        (netrw v143)
22:52 ASUSunDevil   "   /etc/apache2/sites-enabled
22:52 ASUSunDevil   "   Sorted by      name
22:52 ASUSunDevil   "   Sort sequence: [\/]$,\<core\%(\.\d\+\)\=\>,\.h$,\.c$,\.cpp$,\~\=\*$,*,\.o$,\.obj$,\.info$,\.swp$,\.bak$,\~$
22:52 ASUSunDevil   "   Quick Help: <F1>:help  -:go up dir  D:delete  R:rename  s:sort-by  x:exec
22:52 ASUSunDevil   " ============================================================================
22:52 ASUSunDevil   ../
22:52 ASUSunDevil   koha@
22:52 ASUSunDevil   .swp
22:52 rangi         eeek
22:52 rangi         use the paste :)
22:53 rangi         ok, this may or may not work
22:53 ASUSunDevil   do I change the @koha to @spllib?
22:53 rangi         koha-remove spllib
22:53 ASUSunDevil   ok
22:53 rangi         you dont, that will never work
22:53 rangi         hopefully it removes it, and then you can do a koha-create again
22:54 ASUSunDevil   ok, did it, I got:
22:54 ASUSunDevil   koha@spllib:~$ sudo koha-remove spllib
22:54 ASUSunDevil   Removing Koha instance spllib
22:54 ASUSunDevil   ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'koha_spllib'@'%'
22:54 ASUSunDevil   koha@spllib:~$
22:54 rangi         try the create again now
22:55 ASUSunDevil   ok, did it and got the "User spllib-koha already exists"
22:55 rangi         dang, that typo got us in a bit of a mess
22:55 rangi         try this
22:56 rangi         sudo userdel spllib-koha
22:56 ASUSunDevil   ok, done
22:56 rangi         mysqladmin -uroot -p drop spllib
22:56 rangi         and try the koha-create again
22:57 ASUSunDevil   ok, done
22:58 ASUSunDevil   should I try the koha-create command again?
22:58 rangi         yes
22:59 ASUSunDevil   I have a question fist, the /etc/koha/passwd file, are those directives for a new account, or the info in place for a new account that will be created?
23:00 rangi         the latter, afaik, ive never used it, and we may not need it, it might have been a red herring, since the missing " was the actual problem
23:02 ASUSunDevil   ok, I'm gonna try it with that info, the normal user I setup "koha" is the account I am using and the user that should be setup on he database...
23:02 rangi         give it a go, see what happens
23:03 ASUSunDevil   ok, I got he following:
23:03 ASUSunDevil   koha@spllib:~$ sudo koha-create --create-db spllib
23:03 ASUSunDevil   Koha instance is empty, no staff user created.
23:03 ASUSunDevil   Enabling site spllib.
23:03 ASUSunDevil   To activate the new configuration, you need to run:
23:03 wahanui       i already had it that way, ASUSunDevil.
23:03 ASUSunDevil   service apache2 reload
23:03 ASUSunDevil   * Restarting web server apache2
23:03 ASUSunDevil   ... waiting    ...done.
23:03 ASUSunDevil   Starting Zebra server for spllib
23:03 ASUSunDevil   koha@spllib:~$
23:03 ASUSunDevil   does that look like a success?
23:04 rangi         sure does
23:05 rangi         check /etc/apache2/sites-enabled now
23:05 ASUSunDevil   hmm, I restarted apache, but still cannot access the site....
23:05 rangi         you have your dns set up eh
23:06 rangi         so that spllib.la.asu.edu resolves to that box eh?
23:06 ASUSunDevil   yeah, he host name is just spllib, everything is responding normally. I just want the host to be the url people visit for the public site. then for the admin, the hostname on 8080
23:06 ASUSunDevil   yep
23:06 ASUSunDevil   I can ping it from other systems just fine
23:07 rangi         check your /etc/apache2/ports.conf
23:07 rangi         do you have a Listen 8080
23:07 rangi         line in there
23:07 rangi         (after the Listen 80)
23:08 rangi         you need to tell apache to listen on port 8080 if you want it to :)
23:08 ASUSunDevil   yeah, I listen on 80 and 8080 (in that order) also, the first two lines are NameVitualHost for those two ports as well.
23:09 rangi         on the server what does
23:09 rangi         host spllib.la.asu.edu
23:09 rangi         resolve to
23:09 rangi         http://spllib.la.asu.edu/
23:09 rangi         cos i get your koha page
23:09 ASUSunDevil   resloves to the ip address,
23:10 rangi         and it looks like 8080 is being blocked at a firewall or something
23:10 ASUSunDevil   oh, wait, ok, it must have had the old page cached...I get it now too, but with a "software error"
23:10 rangi         yep
23:10 rangi         try this
23:11 rangi         a2dissite koha
23:11 rangi         (get rid of that old koha one in there its answering when the splib one should be)
23:11 ASUSunDevil   ok, did tha then rean service apache2 reload
23:11 rangi         cool now its
23:12 rangi         koha'@'localhost'
23:12 rangi         thats right
23:12 rangi         so yeah we just have to figure out why cant hit 8080
23:12 rangi         but i think its between your server and the world
23:12 rangi         can you try this on the server
23:12 rangi         telnet 8080
23:13 rangi         (you might have to apt-get install telnet)
23:13 ASUSunDevil   I just opened up the port on the firewall, so now I can hit the site, but there's an error there too
23:13 rangi         right ok, so lets do a koha-remove splib
23:14 rangi         i think we have an error in our mysql permissions
23:14 rangi         probably crept in when we still had the typo
23:14 rangi         so lets get back to a clean slate if we can
23:14 rangi         then do the create again
23:14 rangi         and we should be all good
23:15 ASUSunDevil   hmm, yeah, when I did that command I got:
23:15 ASUSunDevil   Removing Koha instance spllib
23:15 ASUSunDevil   ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'koha_spllib'@'%'
23:15 rangi         did it clean out the rest ?
23:15 rangi         no db?
23:16 rangi         no site in sites-enabled?
23:16 ASUSunDevil   the koha_biblio db and spllib db are still in mysql
23:16 ASUSunDevil   should I try removing those?
23:17 rangi         yeah and do the userdel like before too
23:17 rangi         then mysql -uroot -p mysql
23:17 rangi         select * from users;
23:18 rangi         wanna find out what users are hanging around in mysql
23:20 ASUSunDevil   lets see...the root user is there, debian-sys-maint, koha-koha, and koha
23:21 rangi         oh cool so the koha user is there
23:21 rangi         lets try drop user 'koha-koha'@'%';
23:21 ASUSunDevil   well, the main system account I created was koha too, I wanted it all to use that user....if possible.
23:21 rangi         yep but lets clean it out first
23:22 jenkins_koha  Project Koha_3.8.x build #26: SUCCESS in 52 min: http://jenkins.koha-community.org/job/Koha_3.8.x/26/
23:22 jenkins_koha  kyle: Bug 7112 - Having two prices in 020$c causes basket creation to fail from staged marc import
23:22 huginn`       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7112 major, P3, ---, kyle.m.hall, Pushed to Stable , Having two prices in 020$c causes basket creation to fail from staged marc import
23:22 rangi         and drop user 'koha'@'%';
23:22 rangi         so just root and debian-sys-maint left
23:22 rangi         ?
23:22 rangi         so pristine
23:22 rangi         and then quit out of mysql
23:23 ASUSunDevil   ok, all are gone except for root, debain-sys-maint and koha now
23:23 ASUSunDevil   should I remove the koha user too?
23:23 rangi         please get rid of koha too
23:23 rangi         yes please
23:23 ASUSunDevil   ok
23:23 ASUSunDevil   ok, all gone
23:23 rangi         cool, lets try our koha-create again
23:25 ASUSunDevil   hmm, trying to do a userdel on spllib-koha and it tells me that user is currently logged in....is that somehow linked to the koha user account I am using?
23:25 jcamins       Yep.
23:26 jcamins       Log out as the koha user, and log back in as your regular user.
23:27 ASUSunDevil   ok, well, when I try the create again, sudo koha-create --create-db spllib, I get: spllib-koha already exists. The koha user is my regualr account, it was the account I created when i installed the system. It's the only account on the system.
23:27 jcamins       Oh.
23:27 rangi         can you do this
23:27 ASUSunDevil   so I need to do something different. Oh, and thank you all so much for the help!
23:27 rangi         /etc/init.d/koha-common stop
23:27 rangi         /etc/init.d/apache2 stop
23:28 rangi         then try your userdel again
23:28 rangi         its probably running zebra and/or apache as that user
23:29 ASUSunDevil   ah ha, that worked, ok, that user is not removed.
23:30 ASUSunDevil   do I start those services up again?
23:30 rangi         not or now  ?
23:30 ASUSunDevil   sorry, now removed
23:30 rangi         nope, you'll want to do koha-create again first
23:30 rangi         that will start them automagically for you
23:30 * jcamins     pretends that it's Friday in the States, too.
23:31 rangi         and hopefully we will now be trying to connect to the db with the right user and password :)
23:33 ASUSunDevil   ok, did the koha-create, got: mkdir: cannot create directory 'var/log/koha/spllib: file exists' do I need to remove that directory and start over again?
23:33 rangi         hmm, try the koha-remove .. its a darn mess when it half runs (both it and koha-remove)
23:35 jcamins       Here's a suggestion: download the new koha-remove that won't quit in the middle, and use that.
23:36 * rangi       has to do some work work now, but i think we are really close and i think you probably had it going before just firewall was blocking 8080
23:38 jcamins       I do that.
23:38 jcamins       http://git.koha-community.org/gitweb/?p=koha.git;a=blob_plain;f=debian/scripts/koha-remove;hb=HEAD
23:51 eythian       jcamins: you'll be happy to know I found a bug with the easyanalytics stuff while demoing it today :)
23:51 eythian       (If you "analyse item", then change the framework, the 773 info disappears.)
23:51 rangi         and yet the client still gave you chocolates!
23:51 eythian       indeed :)
23:51 jcamins       eythian: excellent!
23:52 jcamins       eythian: oh, yeah, there's a bug for that.
23:52 jcamins       Somewhere.
23:52 eythian       jcamins: ah right
23:52 jcamins       Can't find it right now.
23:53 eythian       jcamins: let me know if you find it.
23:55 rangi         @quote get 205
23:55 huginn`       rangi: Quote #205: "Theres a bug for that" (added by chrisc at 11:54 PM, May 24, 2012)
23:55 rangi         hmm i should fix the punctuation
23:56 rangi         @quote get 205
23:56 huginn`       rangi: Error: There is no Quote with id #205 in my database for #koha.
23:56 rangi         @quote get 206
23:56 huginn`       rangi: Quote #206: "There's a bug for that" (added by chrisc at 11:55 PM, May 24, 2012)
23:56 rangi         @quote random
23:56 huginn`       rangi: Quote #13: "<atz> ricardo: ask and ye shall receive.... eventually, ye shall stop asking." (added by gmcharlt at 08:31 PM, July 09, 2009)
23:59 ASUSunDevil   jcamins/rangi: Ok I cleaned everything out, log dir, sql entries, users, etc.. I did a koha-create and all looked good, no errors, went to the site and get some errors again, looking similar to the errors I got not too long ago: http://spllib.la.asu.edu/
23:59 ASUSunDevil   sql permissions??
23:59 eythian       the packages don't ever try to access a database called "koha"