IRC log for #koha, 2012-05-24

All times shown according to UTC.

Time S 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 -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:07 cjh joined #koha
00:08 roygbivovac joined #koha
00:27 BobB_ joined #koha
00:36 roygbivovac hey eythian, upgrade on test went fine
00:37 cjh joined #koha
00:37 roygbivovac do you reckon we need to take a snapshot of production before upgrading prod?
00:39 jcamins Yes.
00:41 Irma joined #koha
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[…]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` Bug[…]w_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[…]=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[…]h-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:51 melia left #koha
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/ 49
01:59 mtj C4/ 19
01:59 mtj C4/ 15
01:59 mtj ...
02:00 mtj bbiab
02:01 kyleh_ joined #koha
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:16 kyleh joined #koha
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[…]c&feature=related
02:27 ibeardslee .. !?! ..[…]d/110027425680769
02:27 ibeardslee no ad there though
02:28 ibeardslee just flabbergasted that people would go that far
02:29 rangi heh
03:36 Irma joined #koha
03:46 Amit_Gupta joined #koha
03:46 Amit_Gupta heya bag
04:28 francharb joined #koha
04:28 paul_p_ joined #koha
04:28 francharb good morning
04:29 Joubu1 joined #koha
04:30 rangi hi francharb
04:42 francharb hi rangi
04:43 paul_p__ joined #koha
04:44 Joubu joined #koha
04:57 cait-m joined #koha
04:58 paul_p_ joined #koha
04:59 Joubu1 joined #koha
05:18 cait joined #koha
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
05:55 laurence joined #koha
06:09 rangi joined #koha
06:16 rangi joined #koha
06:20 magnuse kia ora #koha!
06:22 rangi joined #koha
06:23 magnuse ata marie rangi
06:36 rangi joined #koha
06:40 laurence left #koha
06:41 rangi joined #koha
06:41 reiveune joined #koha
06:41 reiveune bonjour
06:41 magnuse kia ora!
06:41 magnuse jcamins++ for epic bug wrangling!
06:42 rangi joined #koha
06:44 rangi joined #koha
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:47 Guillaume joined #koha
06:48 gaetan_B joined #koha
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
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)
06:59 asaurat joined #koha
07:01 hdl joined #koha
07:06 Oak joined #koha
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:21 hdl joined #koha
07:22 bshum joined #koha
07:25 cait hi #koha :)
07:30 magnuse hiya cait and Oak and hdl and bshum and everyone else
07:31 alex_a joined #koha
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` Bug[…]w_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` Bug[…]w_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:
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 hdl joined #koha
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/intr​anet-tmpl/prog/en/modules/help/.tt: not found
08:28 huginn` slef: Bug[…]%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[…]hp?g2_itemId=9684
08:34 paul_p rangi[…]66&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:38 stuartyeates joined #koha
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 mib_am69mf joined #koha
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 vfernandes joined #koha
09:06 slef 28h?
09:07 chris_n` joined #koha
09:07 rangi mib_am69mf: there hasnt been a version released in a long time
09:07 laurence joined #koha
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[…]hp?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:18 ASUSunDevil joined #koha
09:20 slef mib_am69mf: you will probably need to do it yourself, maybe doing some archaeology on 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
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[…]a_special_remote/  <-- i use that
09:50 clrh_ joined #koha
10:00 Oak joined #koha
10:01 Oak joined #koha
10:10 cait-m joined #koha
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:04 vfernandes joined #koha
11:05 slef I think we'll be OK. There's something like £2000 now stuck at Paypal but I'm pretty sure that the balance for the room hire doesn't need paying until next week and that's about £2000.
11:06 slef wahanui: international banking?
11:06 wahanui bugger all, i dunno, slef
11:06 slef hehe
11:22 Amit_Gupta heya slef
11:23 slef hi Amit_Gupta
11:29 NateC joined #koha
11:49 mj joined #koha
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)
11:51 jwagner joined #koha
11:53 nengard joined #koha
11:57 Joubu joined #koha
12:05 zioha joined #koha
12:08 ZAHID joined #koha
12:14 zioha joined #koha
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:33 oleonard joined #koha
12:35 ZAHID joined #koha
12:46 talljoy joined #koha
12:51 Irma joined #koha
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 <[…]4fa4a336aa0620856> / Bug 7977 follow-up, fixing UC breaking coding guidelines <[…]00c102e83ef345a9d> / add edit_quotes to es-ES/mandatory/userpermissions.sql <[…]it;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 ago43 joined #koha
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 wahanui joined #koha
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 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 cait-m joined #koha
13:06 Joubu joined #koha
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 sekjal joined #koha
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.[…]/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` Bug[…]w_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` Bug[…]w_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
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 <>
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:[…]w_bug.cgi?id=8148
13:19 wahanui mj: excuse me?
13:19 huginn` Bug 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/ in @INC (@INC contains: /home/jenkins/jobs/Koha_master/workspace/blib/arch /home/jenkins/jobs/Koha_master/workspace/blib/lib <http://jenkins.koha-community.[…]b/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 <
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/> line 30.
13:20 chris_n mj: great!
13:21 paul_p http://jenkins.koha-community.[…]ons_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:25 wahanui joined #koha
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:30 Oak joined #koha
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` Bug[…]w_bug.cgi?id=8144 critical, P1 - high, ---, oleonard, ASSIGNED , 775 tag in the MARC record causes display issue
13:36 maximep joined #koha
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 vfernandes joined #koha
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 Topic for #koha is now Koha 3.8.1 and 3.6.4 Now Available | Koha Community Website - | General IRC meeting, 13 June 2012 at 18:00 UTC+0
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
13:55 Barrc joined #koha
14:00 Barrc Hello all -  I got a strange one, koha, some bibs show twice (that is the exact same bib number) on staff and OPAC. Rebuilding the indexes sorts out the problem but it reappears after a while and an only a full reindex resolves. Anyone any ideas?
14:01 hdl Barrc: multiple Local-number definition in your etc/zebradb/marcflavour/biblios/record.abs
14:01 paul_p Barrc yes, me. how much do you give me for the answer ?
14:01 hdl may lead to that.
14:01 paul_p hdl gave the answer for free :D
14:02 hdl And God knows paul_p is much more open to Grace than I
14:03 paul_p this usually happens when Local-number is defined for 2 fields in your record.abs. In this case, zebra make mistake when updating (ie= it searches on Local-number #2, while it had previously stored the record with identifier from Local-number #1)
14:03 paul_p so, zebra think it's not a modification, but a new record. And you get 2 !
14:03 paul_p HTH
14:03 Barrc Thanks guys - I will look at that. Pay for play, a IRC first!
14:03 Barrc It does!. thanks!
14:03 hdl Insert Coins...
14:03 paul_p Barrc = you can pay with some signoff ([…]noff&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... <[…]73b6cdcb1a0746320> / Bug 8135 : Fix installer to copy services/ dir <[…]f902d35e89085ef54> / 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` Bug[…]w_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 joined #koha
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,biblioite​mnumber:w,biblioitemnumber:s
14:19 chris_n jcamins:[…]18&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 <[…]w_bug.cgi?id=7127>
14:20 wizzyrea joined #koha
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[…]13b60d704e4c8cd83
14:23 jenkins_koha Project Koha_master build #733: STILL FAILING in 6 min 10 sec: http://jenkins.koha-community.[…]/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` Bug[…]w_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` Bug[…]w_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` Bug[…]w_bug.cgi?id=8128 blocker, P5 - low, ---, kyle.m.hall, Pushed to Master , can't seem to run new sql reports
14:23 huginn` Bug[…]w_bug.cgi?id=8135 critical, P1 - high, ---, chris, Pushed to Master , Services Directory and File Missing After Install
14:23 huginn` Bug[…]w_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` Bug[…]w_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.
14:40 mj joined #koha
14:58 nengard left #koha
15:04 reiveune bye
15:04 reiveune left #koha
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:19 asaurat left #koha
15:32 collum joined #koha
15:36 melia joined #koha
15:41 paul_p i'm back
15:43 vfernandes joined #koha
15:55 adnc joined #koha
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:03 libsysguy joined #koha
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:14 laurence left #koha
16:14 zioha joined #koha
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:27 Oak joined #koha
16:28 trea joined #koha
16:43 nengard joined #koha
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[…]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:17 adnc joined #koha
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:07 trea left #koha
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 Callender joined #koha
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[…]iblionumber=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[…]iblionumber=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[…]blionumber=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[…]iblionumber=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[…]blionumber=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:04 cait joined #koha
19:15 cait left #koha
19:34 mbalmer joined #koha
19:37 gonzalo joined #koha
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` Bug[…]w_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"
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 nengard_ joined #koha
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[…]blionumber=285498
20:20 oleonard[…]iblionumber=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:23 ASUSunDevil joined #koha
20:25 francharb_afk : 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):[…]ing_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
20:27 slef or that
20:27 rangi[…]on_Debian_Squeeze
20:27 ASUSunDevil awesome...thank you!
20:27 rangi if you want to do some testing
20:28 rangi[…]/3.8.x-dailybuild
20:28 slef[…]y: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 sekjal left #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:32 kathryn joined #koha
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.[…]/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[…]t-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[…]t-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 precise universe
20:43 ASUSunDevil deb-src precise universe
20:43 ASUSunDevil deb precise-updates universe
20:43 ASUSunDevil deb-src precise-updates universe
20:43 ASUSunDevil do I just need to add the one for lib-net... ?
20:44 rangi no its in the universe, can you cut and paste the exact error?
20:44 jcamins According to the website, it's included in the first.
20:44 * rangi tests on a precise vm
20:45 jenkins_koha Starting build #734 for job Koha_master (previous build: STILL FAILING -- last SUCCESS #731 1 day 22 hr ago)
20:45 ASUSunDevil after I enter the "apt-get install koha-common", I get:
20:45 ASUSunDevil Reading package lists... Done
20:45 ASUSunDevil Building dependency tree
20:45 ASUSunDevil Reading state information... Done
20:45 ASUSunDevil Some packages could not be installed. This may mean that you have
20:45 ASUSunDevil requested an impossible situation or if you are using the unstable
20:45 ASUSunDevil distribution that some required packages have not yet been created
20:45 ASUSunDevil or been moved out of Incoming.
20:45 ASUSunDevil The following information may help to resolve the situation:
20:45 ASUSunDevil The following packages have unmet dependencies:
20:45 ASUSunDevil koha-common : Depends: libnet-z3950-zoom-perl but it is not going to be installed
20:45 ASUSunDevil Depends: idzebra-2.0 but it is not going to be installed
20:45 ASUSunDevil Depends: yaz but it is not going to be installed
20:45 ASUSunDevil E: Unable to correct problems, you have held broken packages.
20:45 ASUSunDevil koha@spllib:~$
20:45 rangi weird, all three are in the universe
20:46 pastebot "rangi" at pasted "apt-cache policy idzebra-2.0 i" (8 lines) at
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[…]t-z3950-zoom-perl  <-- says for i386 and amd64
20:48 wizzyrea ASUSunDevil:[…]ing_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 left #koha
20:49 wizzyrea joined #koha
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 wizzyrea left #koha
20:51 rangi quantal
20:51 wizzyrea joined #koha
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 lucid/main i386 Packages
20:56 ASUSunDevil 2.0.49-1indexdata 0
20:56 ASUSunDevil 500 lucid/main i386 Packages
20:56 ASUSunDevil 2.0.48-1indexdata 0
20:56 ASUSunDevil 500 lucid/main i386 Packages
20:56 ASUSunDevil 2.0.47-1indexdata 0
20:56 ASUSunDevil 500 lucid/main i386 Packages
20:56 rangi ah ha!!!
20:56 ASUSunDevil 2.0.45-1indexdata 0
20:56 ASUSunDevil 500 lucid/main i386 Packages
20:56 ASUSunDevil 2.0.44-3 0
20:56 ASUSunDevil 500 precise/universe i386 Packages
20:56 ASUSunDevil 2.0.44-1indexdata 0
20:56 ASUSunDevil 500 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 lucid main
20:57 ASUSunDevil deb-src lucid main
20:57 ASUSunDevil #Koha .deb packages (Koha-community)
20:57 ASUSunDevil deb 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 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:23 Guillaume joined #koha
21:27 Guillaume left #koha
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:36 ago43 joined #koha
21:40 nengard left #koha
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.[…]/Koha_master/734/
21:48 rangi yay!
21:58 maximep left #koha
22:21 chilts rangi: yeah, on the way in now
22:21 SJeffery joined #koha
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:[…]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:25 cait joined #koha
22:27 ASUSunDevil well, for the koha-sites.conf file, I tried to put in some defaults the way I thought they should be, but it didn't seem to work. After completing the rest, I couldn't pull the site up in a browser. By the way, being this is a server, there is no X installed, so I am trying to access the site from a different compuer...
22:27 pastebot "rangi" at pasted "koha-sites.conf" (4 lines) at
22:28 rangi  <-- 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.[…]ob/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` Bug[…]w_bug.cgi?id=7178 normal, P5 - low, ---, julian.maurice, Pushed to Stable , Improve order item creation
22:30 huginn` Bug[…]w_bug.cgi?id=8135 critical, P1 - high, ---, chris, Pushed to Stable , Services Directory and File Missing After Install
22:30 jenkins_koha Starting build #26 for job Koha_3.8.x (previous build: SUCCESS)
22:30 pastebot "ASUSunDevil" at pasted "koha-sites.conf" (10 lines) at
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
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
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 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 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 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
23:09 rangi resolve to
23:09 rangi
23:09 rangi cos i get your koha page
23:09 ASUSunDevil resloves to the ip address,
23:10 rangi and it looks like 8080 is being blocked at a firewall or something
23:10 papa joined #koha
23:10 ASUSunDevil oh, wait, ok, it must have had the old page cached...I get it now too, but with a "software error"
23:10 rangi yep
23:10 rangi try this
23:11 rangi a2dissite koha
23:11 rangi (get rid of that old koha one in there its answering when the splib one should be)
23:11 ASUSunDevil ok, did tha then rean service apache2 reload
23:11 rangi cool now its
23:12 rangi koha'@'localhost'
23:12 rangi thats right
23:12 rangi so yeah we just have to figure out why cant hit 8080
23:12 rangi but i think its between your server and the world
23:12 rangi can you try this on the server
23:12 rangi telnet 8080
23:13 rangi (you might have to apt-get install telnet)
23:13 ASUSunDevil I just opened up the port on the firewall, so now I can hit the site, but there's an error there too
23:13 rangi right ok, so lets do a koha-remove splib
23:14 rangi i think we have an error in our mysql permissions
23:14 rangi probably crept in when we still had the typo
23:14 rangi so lets get back to a clean slate if we can
23:14 rangi then do the create again
23:14 rangi and we should be all good
23:15 ASUSunDevil hmm, yeah, when I did that command I got:
23:15 ASUSunDevil Removing Koha instance spllib
23:15 ASUSunDevil ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'koha_spllib'@'%'
23:15 rangi did it clean out the rest ?
23:15 rangi no db?
23:16 rangi no site in sites-enabled?
23:16 ASUSunDevil the koha_biblio db and spllib db are still in mysql
23:16 ASUSunDevil should I try removing those?
23:17 rangi yeah and do the userdel like before too
23:17 rangi then mysql -uroot -p mysql
23:17 rangi select * from users;
23:18 rangi wanna find out what users are hanging around in mysql
23:20 ASUSunDevil lets see...the root user is there, debian-sys-maint, koha-koha, and koha
23:20 cait left #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.[…]ob/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` Bug[…]w_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 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[…]ha-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:56 NateC joined #koha
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:
23:59 ASUSunDevil sql permissions??
23:59 eythian the packages don't ever try to access a database called "koha"

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