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 INTERNATIONAL BANKING IS FUN! 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 <firstname.lastname@example.org> 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 3.06.02.000, 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 220.127.116.11 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 18.104.22.168 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 22.214.171.124 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, 126.96.36.199 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 188.8.131.52 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"