Time  Nick            Message
00:21 druthb          o/
00:58 lastnode        hi, im trying to sue koha-create --create-db mydb on debian
00:58 lastnode        and i get "does not exist"
01:10 lastnode        anyone?
01:16 eythian         lastnode: what version?
01:16 eythian         there was a bug that slipped in that may cause that.
01:16 lastnode        eythian: whatever comes with the debian pacakges from debian.koha-community
01:16 lastnode        3.2 i think?
01:17 eythian         lastnode: can you check, they were updated yesterday.
01:17 eythian         apt-cache policy koha-common
01:17 eythian         do you have a file: /etc/koha/koha-sites.conf?
01:18 lastnode        eythian: yes
01:18 lastnode        i even loaded it via --config
01:19 eythian         try --configfile
01:19 lastnode        yea
01:19 lastnode        sorry, i meant i sued taht flag
01:19 lastnode        *used
01:19 eythian         OK
01:19 * eythian       looks
01:19 eythian         so, you have 3.4.4?
01:20 lastnode        then it asked me to checkif /etc/mysql/koha-common.cnf existed
01:20 lastnode        so i touched it
01:20 lastnode        and now it asys
01:20 lastnode        cannot connect to mysql server through
01:20 lastnode        socket /var/runmysqld/mysqld.sock (2)
01:20 eythian         do you have the mysql server running?
01:20 eythian         (do you have it installed?)
01:20 lastnode        http://wiki.koha-community.org/wiki/Koha_3.4_on_Debian_Squeeze#Quick_Start
01:21 lastnode        im following this guide
01:21 lastnode        because it was debian
01:21 lastnode        on ubuntu i followed a different guide where i had to run myusql manually
01:21 lastnode        this guide doestn say anything of the sort
01:21 lastnode        mysql-common the package is isntalled though
01:22 eythian         yeah, it probably should. Mysql isn't required to be installed because it's quite reasonable to run it from a database server, but most people want it
01:22 eythian         so, install mysql-server
01:22 eythian         btw the koha-common.cnf file should be:
01:22 eythian         $ ls -l /etc/mysql/koha-common.cnf
01:22 eythian         lrwxrwxrwx 1 root root 26 Dec 21  2010 /etc/mysql/koha-common.cnf -> /etc/koha/mykoha-mysql.cnf
01:22 eythian         oh wait
01:22 eythian         wrong server
01:23 lastnode        wont the koha-common  package dependon mysql?
01:23 eythian         lrwxrwxrwx 1 root root   10 Apr 28 16:30 koha-common.cnf -> debian.cnf
01:23 eythian         no, because it doesn't need mysql to be installed to work, if your database is on another server.
01:23 * eythian       does update the docs to mention that though
01:24 lastnode        http://wiki.koha-community.org/wiki/Koha_3.4_on_Debian_Squeeze#Quick_Start
01:24 lastnode        not that i can find
01:24 lastnode        unless ive missed it
01:24 lastnode        anyway yeah, getting mysql now
01:25 eythian         hit refresh, it'll be there
01:26 lastnode        like a boss, eythian
01:26 eythian         :)
01:26 lastnode        im trying to demo koha today for the prinicipal
01:26 lastnode        /librarian
01:26 lastnode        the thing is, we're in sri lanka
01:26 eythian         heh I did that just today for a school
01:26 lastnode        and a lot of the isbn searches i do via z.39
01:26 lastnode        bring up nothing
01:26 lastnode        bc of US based isbn
01:27 lastnode        is tehr some way i acan connect o a britishlibrary
01:27 lastnode        via z.39?
01:27 lastnode        or indian?
01:27 eythian         yeah, you can
01:27 eythian         you just need to find their details
01:27 lastnode        ok
01:27 lastnode        sec, just settign this up
01:27 lastnode        im inside a vm bc i dont want to keep booting into ubuntu
01:27 lastnode        and to be honest, i wouldnt run koha on ubuntu anyway
01:27 lastnode        not for production
01:28 lastnode        bc in 12 months whenthat EOLs ill have to upgrade
01:28 eythian         No, we recommend debian
01:28 lastnode        whereas with ubuntu i can install and upgrade next when i retire
01:28 lastnode        *debian
01:28 eythian         heh
01:28 eythian         well, if you stick to LTS versions, Ubuntu has a longer and more certain cycle than debian
01:28 lastnode        i dunno, every production experience ive had with debian
01:29 lastnode        *ubuntu has been pretty bad
01:29 eythian         Yeah, me too
01:29 eythian         http://www.bl.uk/bibliographic/z3950configuration.html <-- british library Z39.50 info
01:29 eythian         but google will find you plenty more
01:30 * eythian       has to go have lunch
01:30 lastnode        eythian: now that it says apache is running etc.
01:30 lastnode        http://kohadmin should take me to admin right
01:40 lastnode        http://127.0.0.1:8080 wont take me to teh admins creen
01:40 lastnode        i even added listen 8080 to /etc/apache2/ports.conf
01:53 lastnode        eythian: just ping when ur back, mate
01:53 lastnode        imma brb
02:30 eythian         lastnode: you need to have DNS set up (or, for demo uses, edit the hosts file.) The hostnames are set to instance and instance-intra by default, but you can check in the apache config.
03:03 seneca          Anyone having any trouble with 3.5 and staff client access permissions?
03:04 seneca          from what I can tell, granting "catalogue" permissions to a patron no longer allows them to log in to the staff client
03:12 seneca          the documentation for 3.4 makes it seem that in order to grant staff client-type permissions to a user, that user has to be type staff, but doing that seems to make no change.
03:17 eythian         I don't think type matters (at least, last I looked.) It's a particular permission that does it.
03:17 eythian         But I don't think it's catalogue
03:17 eythian         it's the one that says that it gives access to the staff interface.
03:18 seneca          the docs say that's "catalogue"
03:18 seneca          and the description of that permissions is (Librarian Interface)
03:18 seneca          which seems to point to that permission being the one I want, but it isn't working
03:19 eythian         oh, view catalogue. I was confused with editcatalogue.
03:19 seneca          when I try to log in as a user with that permission, it tells me the user does not have permission to log into the staff client
03:19 eythian         Hmm, I've set that, it worked then
03:19 seneca          oh, osrry :)
03:20 seneca          yeah, I'm pretty sure it worked for us before the 3.5 upgrade earlier this summer
03:20 eythian         but, it was a little while
03:20 eythian         ago
03:20 eythian         right
03:20 eythian         Does superlibrarian still work?
03:20 seneca          but we're just now needing to add new staff
03:20 seneca          I don't believe so, but I've tried a lot of things today, so hold on ;)
03:20 eythian         you know that running 3.5 in production is not recommeneded, right?
03:21 seneca          yeah, I do
03:21 eythian         OK cool :)
03:21 seneca          and superlibrarian does not work either
03:22 seneca          so, basically, I guess my problem is that koha is ignoring the user permissions
03:22 seneca          grrr... and 3.6 isn't out until October, eh? ;)
03:22 eythian         I'd make a critical bug on bugs.koha-community.org for it, it's not much good if you can't add staff.
03:22 libsysguy1      speaking of 3.6...anybody got a preview of the catalog revamp yet?
03:22 eythian         Well, even numbers are the stable track, so 3.4 is the recommended one at the moment.
03:23 seneca          yeah
03:23 eythian         Not sure, I haven't heard of it, though it might be in someone's git repo.
03:23 seneca          I wonder how ugly downgrading via git is
03:23 eythian         You just need to change branches to v3.04.04
03:24 rangi           i can add staff and login to my koha running master
03:24 seneca          it's a vm, so I'll just snapshot it before in case anything hoses itself
03:24 rangi           <meta name="generator" content="Koha 3.0500006" /> <!-- leave this for stats -->
03:24 seneca          is 3.4 master?
03:24 rangi           and http://catalog.nexpresslibrary.org/
03:24 rangi           no 3.5 is
03:24 seneca          hmm
03:24 seneca          3.05.00.004 here
03:24 rangi           is running 3.5, they have 40 odd libraries .. im sure i would have heard if they couldnt login :)
03:24 seneca          maybe those last 2 are important ;)
03:24 rangi           dont think so
03:25 rangi           there has not been a bug for logging in
03:25 rangi           in ages
03:25 rangi           (by ages i mean years)
03:25 seneca          hmm
03:25 rangi           its most likely something with your configuration
03:25 eythian         well, it sounds more like a "new users permissions" thing
03:25 eythian         rather than a login, per se
03:25 eythian         or the existing staff wouldn't be able to log in
03:25 rangi           well if superlibrarian cant login
03:25 rangi           we'd have heard
03:26 eythian         but maybe not if you just can't create new ones.
03:26 seneca          it's not only new users, though
03:26 eythian         oh right
03:26 eythian         I misunderstood above then
03:26 seneca          it is ignoring permissions for even old users we'd like to turn into staff accounts
03:27 seneca          I'm afraid to try changing an already-working staff user account, but I'm curious as to whether it will ignore removal of permissions as well
03:27 rangi           so you find a user, and make it superlibrarian? (category shouldnt matter at all) and it cant login?
03:27 seneca          correct
03:27 * rangi         tests
03:27 eythian         OK, so when you go back to the user, have the changed permissions saved?
03:27 libsysguy1      rangi, to sign off on hourly all i need to do is select signed off and add a comment right?
03:27 rangi           yes please
03:28 seneca          yes, permissions are save
03:28 seneca          d
03:28 libsysguy1      ok well that is done :)
03:28 seneca          I've got a currently-working staff member I'm going to try to remove permissions from
03:28 seneca          hold on for data...
03:28 * rangi         is home with the flu
03:29 * libsysguy1    offers rangi theraflu
03:29 * rangi         head is pretty fuzzy still, just have to write an email then back to sleep
03:30 seneca          ooooo, interesting
03:30 seneca          removing "catalogue" from a currently working staffer blocks their staff client login
03:30 seneca          let me see if putting it back returns their logins
03:31 seneca          and it does!
03:31 seneca          so... the problem gets more specific
03:32 seneca          I cannot add accounts to the magic list of staff client users, but accounts that have had it before will work, even if their permissions have been removed and restored...
03:32 eythian         that ... doesn't make sense to me
03:32 seneca          yeah
03:32 eythian         the magic list is determined by who has that permission.
03:32 seneca          me neither ;)
03:32 seneca          that would make sense to me
03:33 libsysguy1      is the flag for that in the db?
03:33 seneca          not sure what you mean, libsysguy1
03:33 libsysguy1      is there a flag in the db that defines who uses the staff client and who doesn't
03:34 libsysguy1      dont**
03:34 eythian         libsysguy1: well, there's the permissions in the database.
03:34 seneca          I'd assume it's that permission field, right eythian?
03:35 libsysguy1      yeah I'm wondering if you can check to see if that is getting set correctly
03:35 seneca          if anyone knows that db location, I can check to make sure it is actually being set in the user's account
03:35 libsysguy1      im on the wrong laptop to check that seneca im sorry :'(
03:35 eythian         I'm not sure, I'm checking
03:35 seneca          hehe
03:37 eythian         ah, the user_permissions table
03:38 seneca          so, a borrowernumber should be listed in there with catalogue permissions? am I understanding correctly?
03:39 eythian         hmm, that's what I'd expect, though the table I'm looking at now is empty.
03:40 seneca          I'm seeing lots of lines in that table
03:41 seneca          one borrowernumber has "edit_catalogue"
03:41 seneca          but more than one user account has the permissions set and can log in successfully
03:41 eythian         I would think the permissions should match the name in the UI, but I've never dug into this area before.
03:41 seneca          though maybe that's not the permission I'm looking for in the db
03:42 seneca          oh
03:42 seneca          edit_catalogue is a different permission in the gui
03:42 seneca          hold on
03:43 eythian         well, there's also userflags, and I'm not sure how that relates
03:43 eythian         ohh
03:43 rangi           im pretty sure thats the actual one
03:43 eythian         userflags is the top-level, and the permissions table goes under that.
03:44 seneca          so "catalogue" is bit 2
03:44 seneca          according to userflags
03:47 seneca          but I don't see any borrowernumber in user_permissions that has bit 2
03:47 seneca          and actually, I don't see the borrowernumber for my head librarian, whose account does work, so I'm thinking user_permissions is the place to be looking :)
03:48 eythian         your head librarian isn't using the database credentials? (which would be frowned upon)
03:49 seneca          I don't understand the question
03:50 eythian         are they using a real login, or the database login, which will always log you in as a superlibrarian
03:50 seneca          they have their own personal user account
03:50 seneca          I thought you were saying that if they weren't using the db admin account it would be frowned upon, which would seem odd to me ;)
03:52 eythian         oh, right
03:52 eythian         Hmm, there's a syspref that is commented out but that seems to be turned on in this database. So I can't turn it off. I don't like that.
03:53 seneca          hmm
03:53 eythian         although the default is to be off, so I don't know how it got there in the first place.
03:54 rangi           SELECT borrowernumber, firstname, surname, flags, borrowers.branchcode,                branches.branchname    as branchname,
03:54 rangi           thats where its getting the permissions
03:54 rangi           FROM borrowers
03:55 seneca          hmm
03:56 seneca          "Flags?
03:56 eythian         userpermissions must then track the sub-permissions.
03:56 eythian         user_permissions
03:56 rangi           my $all_perms = get_all_subpermissions();
03:57 seneca          ah
03:57 pastebot        "rangi" at 203.97.214.51 pasted "if ( $flags ) { foreach my $mo" (11 lines) at http://paste.koha-community.org/18
03:58 pastebot        "rangi" at 203.97.214.51 pasted "if ( $flags ) { foreach my $mo" (22 lines) at http://paste.koha-community.org/19
03:58 rangi           thats how the permissions get set, and pased to the template
03:58 seneca          I think I get it -
03:58 seneca          however
03:59 rangi           and get_all_subpermissions gets the stuff from permissions and userflags
04:00 seneca          is the flag column in BORROWERS a cumulative bitcount?
04:00 rangi           yes
04:00 seneca          ok
04:01 seneca          so a value of 4 would be...
04:01 rangi           no idea
04:01 seneca          haha
04:01 rangi           SELECT flag, code, description                                                    FROM permissions                                                                  JOIN userflags ON (module_bit = bit)
04:01 seneca          in userflags, it seems to be laid out
04:01 eythian         no, it's a bitmask
04:01 rangi           run that, and see
04:01 rangi           ah yes, eythian is right
04:01 eythian         (I'd expect)
04:01 seneca          oh
04:02 seneca          so my user's flag of 4 means that the third bit is marked?
04:02 seneca          1,2,4?
04:02 eythian         yeah
04:03 seneca          and the third bit (bit 2) listed in userflags is "catalogue"
04:03 rangi           yup
04:03 seneca          so the flags column in BORROWERS is correctly showing the permissions the gui is showing
04:03 seneca          but I still can't log in ;)
04:04 rangi           wrong password?
04:04 seneca          nope
04:04 seneca          we use ldap and I can log in to the OPAC just fine
04:04 seneca          but not the staff client
04:04 rangi           theres something up with your db/setup then
04:05 seneca          drat.
04:06 eythian         there's not some ldap flag that is require too, maybe? (I wouldn't think so)
04:06 eythian         but it doesn't make sense that existing users can have their permission turned on and off, but you can't give the permission to users who haven't had it set previously.
04:06 seneca          I agree
04:07 seneca          we're only pulling a few fields from ldap
04:07 seneca          names and card numbers
04:08 seneca          it's like there's some other switch besides the "catalogue" flag
04:08 seneca          but I don't know it if there is, and it's not in any docs
04:09 seneca          I really appreciate you guys spending so much time on my problem, though
04:10 rangi           i dont know of any other switch
04:10 eythian         Yeah, I don't think there is.
04:11 seneca          well, it's WAY past my bedtime
04:11 seneca          so I'm going to go sleep on it
04:11 seneca          if you have any epiphanies, bryan.lakatos@mvschool.com
04:11 seneca          :)
04:11 rangi           do the borrowers have a valid categorycode set?
04:11 seneca          which borrowers?
04:11 rangi           thats the only othe thing i can think of
04:11 rangi           the ones that cant login
04:12 seneca          is that patron,s taff, etc?
04:12 seneca          patron, staff, I mean
04:12 rangi           its whatever you want it to be
04:12 rangi           but the value in the categorycode column
04:12 seneca          well, right
04:12 rangi           in borrowers table
04:12 rangi           will need to be valid
04:12 rangi           ie match one of the categories you have defined
04:13 seneca          seems like it
04:13 seneca          I have the categorycode of PT
04:13 seneca          which I believe is patron, as the gui shows
04:13 seneca          but where are those categories defined in the staff client?
04:13 rangi           in admin
04:14 rangi           borrower categories or the like
04:14 seneca          oh, geez, under "patron categories" perhaps? ;)
04:14 rangi           :)
04:14 seneca          yeah, PT = patron
04:14 eythian         > <input type="hidden" value="HASH(0x4c99140)" name="tab">
04:14 eythian         hmm
04:14 rangi           the only thing i would try is making one a staff, (if you havent already)
04:14 rangi           ok, back to lseep i go
04:14 seneca          yeah, I've tried that, unfortunately
04:15 seneca          feel better!
04:15 seneca          is there anywhere that you can block a user category from accessing the staff client?
04:15 seneca          or require a certain category for staff client access?
04:15 seneca          maybe a new setting in 3.5?
04:16 eythian         nothing I'm aware of
04:16 seneca          man, I always have the strangest problems...
04:17 seneca          ethian, you're using 3.4, right?
04:17 eythian         yeah
04:17 seneca          I guess I can try a downgrade...
04:17 seneca          always leary of that
04:17 seneca          er leery
04:18 eythian         well, take a backup first then :)
04:18 seneca          yeah
04:18 seneca          yay for vms
04:18 seneca          ok, thanks for the help
04:18 seneca          there's my email up there if you remember anything else
04:19 seneca          and again, I really appreciate your help!
04:19 eythian         sweet as
04:19 seneca          one day I'll know enough about koha to return some of these favors...
04:19 seneca          ciao
04:21 Oak             hello #koha :)
04:21 Oak             hello Mr. Robin
04:24 eythian         hi :)
04:24 Oak             :)
05:09 francharb       morning everyone
05:13 Oak             Bonjour francharb :)
05:14 francharb       hi Oak
06:00 alex_a          hello !
06:00 Oak             Bonjour alex_a !!
06:00 alex_a          hi Oak
06:03 Oak             @wunder islamabad
06:03 huginn          Oak: The current temperature in Islamabad, Pakistan is 33.0�C (11:00 AM PKT on August 30, 2011). Conditions: Scattered Clouds. Humidity: 63%. Dew Point: 25.0�C. Pressure: 29.80 in 1009 hPa (Steady).
06:04 Oak             tomorrow is Eid here ... most probably.
06:17 magnuse         kia ora #koha
06:24 eythian         magnuse: for your package deployments, you may want to have a look at bug 6275 - it could be useful
06:24 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6275 enhancement, PATCH-Sent, ---, robin, RESOLVED FIXED, Automated backups of data and config
06:26 magnuse         eythian: yeah, i have been meaning to have a look at that
06:26 eythian         It's in master, but not 3.4
06:26 magnuse         ah, ok
06:26 eythian         but it merges in fine
06:26 magnuse         cool
06:26 magnuse         i'll definitely give it a go, but not sure when i will have the time...
06:27 eythian         fair enough. It works fine, we have it in production. It's just a handy way of producing things you can rsync to off-site storage.
06:27 magnuse         which is really cool, of course!
06:28 magnuse         is it "just" the db, or any other files as well?
06:28 eythian         the db and anything in /etc/koha/sites/<instance>
06:28 magnuse         cool
06:28 eythian         so if you put all your customisations in there, all you need to do is koha-restore to get it back.
06:29 magnuse         eythian++
06:29 magnuse         ah like css and stuff?
06:29 eythian         yeah, if you put them there and symlink them across.
06:29 magnuse         ooh, very cool!
06:29 eythian         although, it would be better to put them in /var/lib/koha/somewhere and include them in the backups, really.
06:31 * magnuse       goes wasp-hunting
06:32 eythian         have ... fun
06:33 magnuse         sorry, there was one flying around me, don't now where it went now...
06:33 eythian         it's flown into your shirt or is sitting on your head. That's what they usually do.
06:33 magnuse         hope not!
06:36 magnuse         oh well, maybe it flew out...
06:37 eythian         just keep saying that to yourself
06:38 magnuse         yup
06:38 magnuse         what worries me most is i have three dogs who like to chase flies, and i don't want to find out haow they'd react to a sting...
06:38 reiveune        hello
06:39 eythian         they'd stop chasing flies.
06:40 magnuse         bonjour biblibre
06:40 magnuse         eythian: hm, maybe...
06:42 cait            magnuse++
06:43 magnuse         gbsd email?
06:43 cait            yep
06:43 cait            although there could be a lot of other good reasons :)
06:44 magnuse         nah
06:46 cait            :)
06:48 hdl             hi all
07:00 magnuse         hiya Irma and julian
07:01 julian          hello magnuse
07:03 sophie_m        hi #koha
08:09 kf              hi #koha
08:52 reiveune        ?
09:09 kf              hi reiveune
09:09 reiveune        hi kf
11:18 Brooke          0/
12:48 jcamins_away    chris_n: how are things by you?
12:49 oleonard        Congrats on the new job trea
12:50 trea            thx owen
13:20 Agent_Dani      \o
13:29 magnuse         oh wow, congrats, trea! how cool is that?!?
13:29 huginn          New commit(s) needsignoff: [Bug 5806] Search results display items for all locations when the SearchMyLibrary first system pref is activated <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5806>
13:30 trea            i know! :D
13:32 oleonard        Sounds like a ByWater customer is using/going to use the IndependantBranches option?
13:33 kf              hi trea, oleonard and sekjal
13:33 sekjal          oleonard:  a few of our partners do
13:33 sekjal          hi, kf
13:33 trea            hi kf
13:34 kf              hi pelletiermaxime
13:34 oleonard        sekjal: I'm happy to see it get some attention.
13:34 pelletiermaxime good morning =)
13:45 sekjal          oleonard:  in the medium-long term, it'll need to be split into multiple preferences.  IndependentPatrons, IndependentCataloging, IndependentOPAC, etc
13:45 sekjal          and I'd like to see singleBranchMode removed, and replaced with a subroutine that just counts the number of configured branches.  If 1, then it's a single branch; else, not
13:48 kf              sekjal: it would be nice if you could group branches and have flags for opac visibility
13:48 kf              would make it possible to have invisible internal departments
13:49 sekjal          kf:  agreed.
13:49 sekjal          I'd like see the Branch Groups functionality do a little more
13:50 kf              jwagner?
13:50 jwagner         Hi there
13:50 kf              hi
13:50 kf              about bug 5806 - I see you changed it back to needs sign-off
13:50 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5806 enhancement, PATCH-Sent, ---, gmcharlt, NEW , Search results display items for all locations when the SearchMyLibrary first system pref is activated
13:50 kf              but I see no patch or code for it
13:50 kf              or note where to find it
13:50 jwagner         I didn't change it, I just added myself as a cc
13:50 kf              oh
13:50 kf              sorry then!
13:50 kf              misread the bugzilla mail
13:51 jwagner         It kept telling me I was colliding with someone, so it may have gotten confused
13:51 kf              ah, I think it was perhaps because you had the bug open when I saved my changes? that it changed back?
13:51 kf              yes, I think that#s the problem :)
13:51 jwagner         Might be.  Two ships colliding in the night, and all that....
13:53 kf              have changed it back :)
13:53 wizzyrea        anybody have any ideas about mr. Harbottle's fatal error (from the list)?
13:54 oleonard        Seems awfully common these days wizzyrea
13:54 wizzyrea        oh oh, is that the problem where he hasn't run the remove_items_from_biblioitems.pl
13:55 wizzyrea        no, doesn't look like that
13:59 oleonard        At least 10 emails to the Koha list in the last 3 months with this same error
13:59 kf              could be an indexing problem too
13:59 wizzyrea        *nod*
13:59 wizzyrea        not quite the same
13:59 wizzyrea        line 2880 seems to be unique
14:01 wizzyrea        I'm going to ask if it's a clean or upgrade, which minor release, if he's reindexed, if he gets results when he searches, etc.
14:02 wizzyrea        anything else you want me to add?
14:02 wizzyrea        since I'm sending this anyway :P
14:02 kf              hm
14:02 kf              something wrong with the frameworks perhaps?
14:02 wizzyrea        i'll ask if he's using a translation
14:02 wizzyrea        good pt
14:03 kf              oh translation is a good point too
14:04 sekjal          wizzyrea:  it's in the _AddBiblioNoZebra subroutine
14:04 wizzyrea        ooooooo
14:04 wizzyrea        I bet he's running nozebra
14:04 wizzyrea        maybe?
14:04 libsysguy       does anybody know how series searching works?
14:04 kf              upgrading from a nozebra installation
14:04 kf              ...?
14:04 wizzyrea        that could be too
14:04 kf              you can't select nozebra now
14:05 wizzyrea        ohsnap! maybe he imported a db with a preference set that he now can't unset
14:05 kf              libsysguy: can you specify your quetion? :)
14:05 libsysguy       I imported a bunch of ebooks and they had series information embeded in teh marc record
14:05 kf              libsysguy: you can not search for series?
14:05 kf              in which field came the series information?
14:06 libsysguy       490a
14:06 kf              and can you search for it using the keyword index?
14:06 libsysguy       yes I can
14:06 libsysguy       but i can't limit by series
14:06 kf              but not from series?
14:06 kf              limit means using the special search option series?
14:06 libsysguy       keyword search http://catalog.uttyler.edu/cgi-bin/koha/opac-search.pl?q=STAT%21Ref
14:07 libsysguy       limit my series http://catalog.uttyler.edu/cgi-bin/koha/opac-search.pl?idx=kw&q=STAT!Ref&sort_by=pubdate_dsc&limit=se:STAT!Ref%20electronic%20medical%20library.
14:07 kf              hm doesn't open for me :(
14:07 libsysguy       0_0
14:07 libsysguy       either link?
14:07 kf              looooading...
14:07 kf              no timeout yet
14:08 wizzyrea        same here
14:08 libsysguy       weird
14:08 libsysguy       is this just as slow? http://catalog.uttyler.edu/
14:08 wizzyrea        yep
14:08 libsysguy       that is very odd
14:08 wizzyrea        (I just tried that)
14:09 wizzyrea        webpage is not available, timeout
14:09 libsysguy       the load is normal
14:09 kf              same here
14:09 libsysguy       where are you accessing it from?
14:09 libsysguy       just curious
14:10 libsysguy       it shouldn't have any effect
14:10 wizzyrea        um, kansas.
14:10 wizzyrea        ^.^
14:10 wizzyrea        tha intarwebs.
14:10 kf              wizzyrea: good mail :) shoudl save that and use as template!
14:10 kf              germany!
14:10 kf              :)
14:10 kf              need an ip address?
14:11 libsysguy       129.114.128.216
14:11 wizzyrea        i can get pings to it both by name and IP
14:11 libsysguy       oddness
14:11 wizzyrea        though that's not the IP the name is returning
14:12 wizzyrea        but I get pings back from that IP too
14:12 huginn          New commit(s) needsignoff: [Bug 6806] Encoding problem with biblio titles in subscription-add.pl <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6806>
14:12 pastebot        "wizzyrea" at 24.124.17.146 pasted "for libsysguy - ping results for catalog.uttyler.org" (3 lines) at http://paste.koha-community.org/20
14:13 libsysguy       oh that is probably the DNS server
14:13 kf              libsysguy: perhaps it's the ! in your link... not related to the access problem, but I wondered if it's broken for other series too?
14:14 libsysguy       interesting idea
14:14 wizzyrea        not sure I understand your logic there, but ok
14:14 wizzyrea        :)
14:15 jcamins         wizzyrea: wizzyrea Zebra is finicky? ;)
14:16 wizzyrea        no no, about the dns server.
14:16 wizzyrea        zebra *is* finicky
14:16 jcamins         Oh.
14:17 jcamins         No idea about the DNS.
14:17 libsysguy       hmm i may have an actual access issue
14:17 kf              libsysguy: I checked the indexing for 490 on current maser - i think it should work
14:20 libsysguy       kk give me one sec to fix the access issue in ASA
14:20 libsysguy       the pitfalls of a giant blanketing firewall
14:22 libsysguy       ok those links should be fixed now
14:22 wizzyrea        it's pretty :)
14:22 kf              looks better
14:23 libsysguy       haha better than a blank page
14:23 kf              nice layout :)
14:23 libsysguy       in another life i did a lot of web devel
14:23 libsysguy       thanks :)
14:23 kf              Davis&rsquo;s drug guide for nurses    ?
14:24 libsysguy       haha yeah...
14:25 libsysguy       looks like a smart quote got in there
14:25 kf              http://catalog.uttyler.edu/cgi-bin/koha/opac-search.pl?q=se:electronic%20medical%20library. this link works
14:25 kf              so it could be a problem with the ! I think
14:26 kf              jcamins: around?
14:26 jcamins         I am.
14:26 jcamins         What's up?
14:26 kf              any idea if you need to escape ! in zebra search urls? :)
14:26 libsysguy       yeah but this works too http://catalog.uttyler.edu/cgi-bin/koha/opac-search.pl?q=se:STAT!Ref
14:26 jcamins         You shouldn't.
14:26 kf              libsysguy: weird!
14:26 libsysguy       totally
14:27 libsysguy       and I did a full reindex last night
14:27 jcamins         Unless there is more punctuation... <! or !- for example, might cause problems.
14:27 libsysguy       so I know it can't be that
14:27 kf              libsysguy: how does the 490 field look like?
14:27 kf              I can't see it in the marc view
14:28 jcamins         Resend the link that doesn't work?
14:28 libsysguy       http://catalog.uttyler.edu/cgi-bin/koha/opac-search.pl?idx=se,wrdl&q=STAT!Ref&sort_by=relevance&limit=se:STAT!Ref%20electronic%20medical%20library.
14:28 kf              =490  0\$aSTAT!Ref electronic medical library.
14:29 jcamins         It's the spaces.
14:29 libsysguy       i knew it
14:29 kf              oh!
14:29 libsysguy       GRR
14:29 kf              but why does eletronic medial library work then?
14:29 libsysguy       oh touche`
14:30 jcamins         Hm.
14:30 jcamins         Good point.
14:30 libsysguy       http://catalog.uttyler.edu/cgi-bin/koha/opac-search.pl?q=se:STAT!Ref%20electronic%20medical%20library.
14:30 libsysguy       fails
14:31 jcamins         Okay, what's the entity for an exclamation mark?
14:31 kf              probably you need to define one
14:31 kf              or.. not sure
14:31 libsysguy       what do you mean entity?
14:31 kf              and it works without the other words
14:31 jcamins         I mean, the urlencoded thing.
14:31 jcamins         Sorry, I've been working with a lot of XML recently.
14:32 jcamins         I mean "not an entity at all." ;)
14:32 libsysguy       %21
14:33 jcamins         Wait.
14:33 jcamins         We've seen this before.
14:33 jcamins         It's Zebra.
14:33 kf              zebra!
14:33 libsysguy       cursed Zebra
14:33 * kf            giggles
14:33 libsysguy       Dun dun DUUU
14:34 jcamins         It's using the wrong index.
14:34 kf              se,phr?
14:34 jcamins         Right, due to unexplained peculiarities, that index is not entirely functional.
14:34 * libsysguy     scratches head
14:35 jcamins         wrdl works.
14:35 kf              hm
14:35 kf              weird
14:35 jcamins         Putting it in quotes works because it forces it to use the working portion of the se,phr index.
14:35 kf              checked in one of my catalogs
14:35 kf              things like https://hfjs.bsz-bw.de/cgi-bin/koha/opac-search.pl?q=se:Bibliothek%20der%20Sprachenkunde work nicely
14:36 jcamins         Yeah, it has to do with the length of the index.
14:36 kf              oh!
14:36 adnc            hello, I've on my koha opac login-page some default text, like: If you don't have a password yet, stop by the circulation desk the next time you're in the library. We'll happily set one up for you.
14:36 kf              so long series titles are having problems and shoter not?
14:36 adnc            which settings controls this?
14:36 jcamins         kf: I think so.
14:36 kf              hi adnc
14:36 adnc            hi kf
14:36 libsysguy       which explains why it works when you shorten it
14:36 kf              there is currently no syspref for, but you can change or remove it by using jquery
14:37 kf              and jcamins++
14:37 jcamins         So you can fix this by mucking around with record.abs.
14:37 adnc            kf, by editing what?
14:37 libsysguy       so technically there is a syspref for it lo
14:37 libsysguy       lol**
14:37 kf              opacuserjs
14:37 libsysguy       actually I think i have the js to fix it
14:37 wizzyrea        oleonard: i'm looking at your most recent patch for 2534
14:37 libsysguy       one moment
14:37 adnc            ok
14:38 kf              adnc: do you want to remove or change it?
14:38 adnc            remove
14:38 kf              ah, that should be quite easy
14:38 kf              even using css
14:39 pastebot        "libsysguy" at 129.114.242.85 pasted "JS for opac auth" (4 lines) at http://paste.koha-community.org/21
14:39 kf              opacusercss #nologininstructions {display:none;}
14:39 libsysguy       there you go adnc
14:39 adnc            thank you very much
14:39 libsysguy       np
14:39 libsysguy       jcamins++
14:40 wizzyrea        I wonder if you could put the sidebar back, but below the table, so that when the table is full width, horizontal scrolling cuts off the sidebar instead of the labels for the item input
14:40 kf              bug 2534
14:40 wizzyrea        otherwise, we like that
14:40 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2534 normal, PATCH-Sent, ---, oleonard, ASSIGNED , Viewing items table on item edit screen requires horizontal scrolling
14:41 adnc            kf, what was that file? I'm using debian and need to search for that file
14:41 kf              no need to change a file
14:41 jcamins         kf: just modify opacusercss.
14:41 kf              system preference opacusercss :)
14:41 adnc            ohh
14:42 libsysguy       oh...that code i sent was for the js
14:42 kf              libsysguy makes it possible to have your own text
14:42 kf              and my trick removes the exsting text
14:42 libsysguy       right :)
14:42 kf              hm
14:43 libsysguy       too bad we can't put the news feed there
14:43 kf              only that it doesn't work for me... checking what's wrong
14:44 adnc            wonderfull
14:44 adnc            thanks
14:44 kf              so it works for you?
14:44 kf              ah, works now for me to, cache probably
14:44 adnc            kf, yes sure. I just set the css id #nologininstructions
14:45 adnc            to display none
14:45 kf              :)
14:45 oleonard        Sorry, was afk. Someone talking to me?
14:46 wizzyrea        it was me :)
14:46 wizzyrea        I was looking at your fix for bug 2534
14:46 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2534 normal, PATCH-Sent, ---, oleonard, ASSIGNED , Viewing items table on item edit screen requires horizontal scrolling
14:46 wizzyrea        I wonder if you could put the sidebar back, but below the table, so that when the table is full width, horizontal scrolling cuts off the sidebar instead of the labels for the item input
14:46 oleonard        Sidebar below the table... on the left of the add item inputs?
14:47 wizzyrea        right
14:47 wizzyrea        correct
14:49 oleonard        I'd be happy to give that a try
14:49 libsysguy       jcamins do you know what it is in record.abs that I need to modify?
14:49 jcamins         libsysguy: what's the line for melm 490... look like?
14:49 jcamins         There may be two.
14:50 libsysguy       melm 490$a      Title-series:w,Title-series:p
14:50 libsysguy       melm 490$9      Koha-Auth-Number
14:50 jcamins         Right.
14:51 libsysguy       oh and melm 490        Title,Title-series
14:51 jcamins         First of all, you're aware that 490 isn't the right field for limits in general, right?
14:51 libsysguy       thats the only bits I have
14:51 libsysguy       i am not...
14:51 libsysguy       but I could be
14:51 libsysguy       lol
14:51 jcamins         Well, limits should probably be based on 830, which is a controlled heading. 490 is text only.
14:51 kf              jcamins: it's the search for series links in the deatil page and the links in facets not working
14:51 kf              ah
14:52 jcamins         kf: facets = limits.
14:52 kf              got it - thx :)
14:52 libsysguy       gotcha
14:52 huginn          New commit(s) needsignoff: [Bug 6817] In overdue.pl, downloading the overdues as a file ignores the filters if the page isn't in english. <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6817> / [Bug 5630] CAS improvements <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5630>
14:52 jcamins         libsysguy: so, I'm going to explain how to fix the 490 issue, because fixing it to work with 830 requires serious reconfiguration.
14:53 jcamins         However, I wanted to make sure you knew, so when your technical services librarians told you it was "broken," you'd know what they meant.
14:53 libsysguy       oh man...ok im holding on to me seat
14:54 wizzyrea        sekjal++ it's totally to do with nozebra
14:54 wizzyrea        (the harbottle question)
14:54 wizzyrea        he's currently running nozebra
14:55 jcamins         libsysguy: so, here's the fix:
14:55 jcamins         melm 490$a    Title-series:w,Title-series:p,Title:w
14:55 jcamins         Keep melm 490$9 as is
14:55 oleonard        offlist reply wizzyrea ?
14:55 jcamins         melm 490    Title-series:w,Title-series:p,Title:w
14:56 wizzyrea        yea
14:56 wizzyrea        i'm sending it
14:56 jcamins         Reindex.
14:56 wahanui         somebody said reindex was a go, and now it is time to sleep.
14:56 wizzyrea        forget reindex
14:56 wahanui         wizzyrea: I forgot reindex
14:56 jcamins         Actually, I think I said that.
14:56 wizzyrea        :)
14:57 oleonard        Too bad, I was about to take wahanui's advice.
14:57 libsysguy       ok i guess I shall wait till tonight...I think I've had enough downtime tonight
14:57 wizzyrea        nap?
14:57 wahanui         nap is the best thing you can do for yourself. Ever.
14:58 libsysguy       today*
14:58 oleonard        wahanui has obviously never had that tossing-and-turning-for-2-hours at bedtime following a good nap
14:58 wahanui         oleonard: huh?
14:59 wizzyrea        hehe
15:00 sekjal          It would be good for the community to have a larger knowledge bank about NoZebra... but it just doesn't come up as often
15:00 kf              libsysguy: if you ahve a dev installation you might need to copy the file from kohaclone to koha-dev
15:00 libsysguy       I actually made the change in Koha-dev
15:00 libsysguy       was that a bad idea
15:02 jcamins         libsysguy: check it works like that, then make the changes in kohaclone.
15:02 huginn          New commit(s) needsignoff: [Bug 6292] Overdue notices have a bug when multiple overdues exist <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6292>
15:03 kf              sophie_m: hi sophie_m - is there a problem with bug 6292?
15:03 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6292 critical, PATCH-Sent, ---, chris, ASSIGNED , Overdue notices have a bug when multiple overdues exist
15:03 wizzyrea        nozebra is deprecated ... right?
15:03 libsysguy       jcamins++
15:03 kf              libsysguy: and after you made the changes in kohaclone - write a patch :)
15:03 wizzyrea        ^^
15:04 libsysguy       oh so its not just a weird obscure problem that I was having
15:04 libsysguy       excellent
15:04 wizzyrea        it's a weird obscure problem you were having that you can fix :)
15:04 wizzyrea        so no one else has it ^.^
15:04 reiveune        bye
15:04 kf              yep
15:04 wizzyrea        bye
15:05 sekjal          NoZebra is still a valid configuration, I believe.  or, at least, I think that it should be
15:05 kf              sophie_m: I see the new patch :)
15:05 libsysguy       so jcamins...how did you come across your zebra knowledge
15:05 sophie_m        kf : yes, one of our customer notices that if a borrower has tow issues with different due_date in the same level of notification, he receives several letters (but the same content)
15:05 wizzyrea        well, if that's true then why have we hidden the pref?
15:05 kf              sophie_m: and there is the thing I missed to check while testing... :( I will try to look at the follow up
15:06 kf              libsysguy: magic
15:06 kf              sekjal: it's not possible to select nozbra for new installations now
15:06 sophie_m        kf, it's very difficult to test every configurations. samples are always poorer than reality
15:06 libsysguy       jcamins is the wizard that forges queries in the deep fires of zebra
15:06 kf              sekjal: but I think it's not totally dead yet
15:07 wizzyrea        jcamins?
15:07 wahanui         i guess jcamins is supposed to be an outstanding cook. or well-traveled and brilliant. or trying to think of a solution, but short of a set of three sysprefs (ShelfBrowserUsesLocation, ShelfBrowserUsesCcode, and ShelfBrowserUsesHomeBranch), I don't really have any ideas. or awesome fixing broken email notifications
15:07 wizzyrea        jcamins is also the wizard that forges queries in the deep fires of zebra
15:07 wahanui         okay, wizzyrea.
15:07 kf              hehe
15:07 wizzyrea        jcamins?
15:07 wahanui         well, jcamins is supposed to be an outstanding cook. or well-traveled and brilliant. or trying to think of a solution, but short of a set of three sysprefs (ShelfBrowserUsesLocation, ShelfBrowserUsesCcode, and ShelfBrowserUsesHomeBranch), I don't really have any ideas. or awesome fixing broken email notifications or the wizard that forges queries in the deep fires of zebra
15:07 libsysguy       lol I love it :)
15:07 wizzyrea        that almost deserves a quote add.
15:07 wizzyrea        lol
15:08 wizzyrea        @quote add <libsysguy> jcamins is the wizard that forges queries in the deep fires of zebra
15:08 huginn          wizzyrea: The operation succeeded.  Quote #150 added.
15:08 jcamins         Time for an early lunch. BRB
15:08 wizzyrea        @quote random
15:08 huginn          wizzyrea: Quote #149: "mtj: DEVELOPERS!!! DEVELOPERS!!! DEVELOPERS!!!" (added by druthb at 01:15 AM, August 26, 2011)
15:08 wizzyrea        rofl.
15:08 libsysguy       lmao
15:08 * wizzyrea      imagines steve ballmer
15:08 libsysguy       oh Ballmer
15:08 sekjal          I'm all for using Zebra over NoZebra, but as we gear up to make use of Solr, we may as well be sure we can support a MySQL-only search setup
15:09 kf              hm
15:09 jcamins         sekjal++ # agreed, and now to lunch!
15:09 kf              ok
15:09 wizzyrea        http://www.spike.com/video-clips/do0v9v/developers-remix
15:09 sekjal          what would be boss:  being able to toggle between the different search methods with a system preference, and not have anything break
15:09 wizzyrea        that would be super boss
15:09 kf              time to leave and deal with the boring distance study book
15:09 kf              sekjal++
15:10 kf              bye all
15:10 wizzyrea        bye kf
15:10 libsysguy       bye kf
15:12 libsysguy       so we might be moving to Solr
15:12 * libsysguy     quivers with excitement
15:12 sekjal          libsysguy:  BibLibre has done extensive work with it
15:12 sekjal          but it still needs to be integrated
15:13 sekjal          and we need to be sure that both Zebra and Solr are equally supported at the choice of the library
15:13 oleonard        wizzyrea: http://screencast.com/t/coDn4Ltn7H6
15:13 sekjal          Solr is much heavier-weight than Zebra, and some smaller installs may not be able to handle it
15:13 libsysguy       i see
15:13 sekjal          but for larger installs, or clusters of smaller ones, it may well make life MUCH better for everyone
15:13 wizzyrea        oleonard++, but what ydo you think?
15:13 libsysguy       well its written in Java so i guess that is expected
15:13 libsysguy       lol
15:13 wizzyrea        I think I like it
15:14 oleonard        wizzyrea: Looks weird to me, but seems like a viable option
15:14 wizzyrea        keeps your "doin' stuff" things together
15:15 wizzyrea        it looks weird to me too, probably because the line on the menu doesn't line up with anything
15:17 libsysguy       wizzyrea: oleonard: you could just move the line to the left and have the tabs jutt out to the right
15:17 wizzyrea        nah, that doesn't solve the problem
15:17 wizzyrea        which is that when you scroll horizontally
15:18 wizzyrea        you lose the add item field labels
15:18 wizzyrea        (without the menu/sidebar there)
15:19 wizzyrea        we're actually going to send your options off to some of our catalogers :)
15:19 wizzyrea        see which they like
15:21 oleonard        Updated: http://screencast.com/t/9OgYo8eyrJE
15:21 libsysguy       catalogers....
15:21 jcamins         libsysguy: I learned about Zebra because things were broken.
15:21 jcamins         libsysguy: did my change fix it?
15:21 libsysguy       well I can't know until i reindex
15:22 libsysguy       and I can't do that until tonight
15:22 jcamins         libsysguy: ah. You don't need to use -r.
15:22 libsysguy       oh...
15:22 wizzyrea        actually, whatever subtle thing you did to that
15:22 wizzyrea        oleonard, made a huge difference
15:22 jcamins         libsysguy: just use rebuild_zebra.pl -b -x -v
15:23 oleonard        I narrowed the sidebar and gave the whole section some padding on the top
15:23 jcamins         libsysguy: you may still want to wait, so the server isn't under so much load.
15:23 wizzyrea        I like that actually
15:23 oleonard        ...which I can do because additem has its own page-specific stylesheet
15:23 wizzyrea        whoot whoot :)
15:23 libsysguy       well it does that anyway every 5 mins
15:23 libsysguy       err
15:23 jcamins         libsysguy: no, it does it with -z every 5 minutes.
15:23 libsysguy       well it does a...yeah
15:23 libsysguy       that
15:24 libsysguy       lol
15:24 libsysguy       its still going to take awhile to dump all those records
15:25 libsysguy       So I should be able to answer your question in about 4 hours
15:33 wizzyrea        oleonard we had a crazy idea
15:35 oleonard        Uh oh.
15:35 wizzyrea        i was carefully reading the bug report for this issue we're thinking about right now
15:35 wizzyrea        the moredetail.pl page is a little redundant, but the additem page doesn't show the history
15:36 wizzyrea        what if the additem table included the history info, and that view was the only items view?
15:36 wizzyrea        i told you it was crazy
15:37 wizzyrea        something like 2 rows for each item - the stuff that's there now, and a 2nd row for history
15:38 wizzyrea        perhaps expandable?
15:39 wizzyrea        and you did that column selector thing for the batch processing interface, could that be used here?
15:39 oleonard        The thing about moredetail.pl is that it's accessible by circ staff, and it's the only way they have to make stuff lost/withdrawn/damaged.
15:40 wizzyrea        right, and in some cases it's the only way that stuff WORKS
15:40 wizzyrea        as in the case of lost
15:41 wizzyrea        I told you it was crazy :)
15:42 * wizzyrea      is annoyed, my git branch autocompletion isn't working.
15:42 jcamins         git has branch autocompletion?
15:42 wizzyrea        it used to!
15:43 jcamins         Where you just hit tab and it autocompletes?
15:43 wizzyrea        I used to be able to git checkout qa-3 <tab> and it would find all the 3's
15:43 wizzyrea        then I could pick
15:45 jcamins         That's pretty nifty.
15:45 * wizzyrea      mutters more
15:45 wizzyrea        *yours* works
15:45 jcamins         I don't think so.
15:46 jcamins         But it's a nifty idea.
15:46 wizzyrea        yea, it used to work :(
15:46 wizzyrea        and supposedly it's native to git now, but for the life of me I can't make it work again.
15:46 wizzyrea        oh well.
16:03 jcamins         [off] I don't give a damn how bad the economic turndown is. Unethical and illegal behavior is unethical and illegal and anyone who preys on the underemployed has a place reserved for them in the eighth circle of hell.
16:04 rhcl            whooa. Looks like I logged on in the middle of something. I need to take cover.
16:05 jcamins         rhcl: nope.
16:05 jcamins         ketchup: just had an exasperating phone call. What I was hoping was an honest mistake was actually an unethical attempt to avoid paying for highly skilled labor.
16:06 ketchup         ic
16:07 * jcamins       gets very worked up about this kind of thing.
16:07 huginn          New commit(s) needsignoff: [Bug 6271] GetItemIssue(s) : renewals in both items and issues tables <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6271>
16:08 * jcamins       considers that justified.
17:33 libsysguy       sekjal: you around?
17:34 sekjal          libsysguy:  yes
17:35 libsysguy       I just wanted to know if there was anything I needed to do for notices
17:35 sekjal          libsysguy:  what do you mean?
17:35 sekjal          for the RFC?
17:35 libsysguy       yes
17:35 sekjal          compile everything on the list that you wish to propose, and put it on the wiki
17:36 libsysguy       ok cool thanks
17:36 sekjal          libsysguy:  look at some of the existing RFCs to get an idea on formatting and sections to include
17:37 libsysguy       yeah I was just reading the page on how to create an RFC
17:37 cait            hi alll
17:37 wizzyrea        whaddup cait :)
17:38 cait            hi liz
17:38 wizzyrea        so what do you think about the idea that "all functions available on the circulation screen should be available to people with circulation permissions"
17:38 cait            13 pages of distance study book read - yay :)
17:38 cait            hm not sure i understand it
17:39 cait            can you explain?
17:39 cait            oh, you were talking to libsysguy?
17:40 libsysguy       umm i don't think so but maybe...were you wizzyrea
17:40 wizzyrea        nah, I was talking to whoever is listening
17:40 libsysguy       hehe
17:40 wizzyrea        well, for example
17:40 wizzyrea        the overdue report
17:40 wizzyrea        on the main circ screen
17:40 wizzyrea        you must have "reports"
17:40 wizzyrea        permisison to run it
17:40 libsysguy       for our points and purposes that wouldn't be a good idea
17:40 wizzyrea        (now I understand that it's a resource hog)
17:41 libsysguy       we have student workers that aren't allowed to access this information
17:41 wizzyrea        well then I contend it shouldn't be there. or should be hidden unless you have the permission.
17:42 libsysguy       now i've confused myself
17:42 libsysguy       so you do or don't want stuff like that around
17:42 wizzyrea        it may be a bug that you can see it at all without the proper permissions
17:43 libsysguy       ahhh
17:43 libsysguy       well in that case I am unsure
17:43 wizzyrea        I think what I'm saying is the following
17:43 wizzyrea        of all the items listed on that page
17:44 wizzyrea        should the circulation permission cover all of them?
17:44 wizzyrea        apparently not
17:45 wizzyrea        which brings up the question: should that report be on that page, or should it be in reports (which is currently the permission required to run it)
17:45 libsysguy       oh I think i understand...maybe it is just an oversight but I think you are right you should have to have permissions for those objects to be rendered
17:47 cait            hm
17:47 cait            good question
17:47 cait            moving them might be inconvenient
17:47 cait            do we need more granular permissions? like having a circ_reports perm?
17:48 wizzyrea        well, did you see the mail to the list from ms. culberson?
17:48 libsysguy       wizzyrea: do you know if this has already been taken into account with the rewrite of circulation
17:48 wizzyrea        I honestly have no idea on that front.
17:48 wizzyrea        that's a good question
17:49 cait            rewrite of circulation?
17:49 libsysguy       I would like to check out that branch and look at it
17:49 libsysguy       but i don't know where it is
17:49 wizzyrea        oh biblibre's circ rewrite?
17:49 libsysguy       yeah
17:49 libsysguy       man biblibre is on the ball with the new stuff
17:50 wizzyrea        it's difficult to test sometimes
17:50 wizzyrea        that's actually old stuff
17:50 wizzyrea        old-new stuff
17:50 libsysguy       i was just looking at their solr implementation
17:50 cait            yeah, the problem is the tesitng
17:51 cait            and that it's been rebased ans squased together several times now
17:51 libsysguy       yeah i can see how there is an issue
17:51 libsysguy       it would be better if they did it in smaller patches
17:51 libsysguy       how many people work for biblibre?
17:51 wizzyrea        and solr is troublesome because we'd want to run alongside zebra, and it currently doesn't (at least it didn't last time I knew)
17:52 libsysguy       I wonder if it could be an installation choice
17:52 libsysguy       zebra or solr
17:52 wizzyrea        that's thte idea
17:52 wizzyrea        it should be, and it's not, currently
17:52 jcamins         It would need to be.
17:52 wizzyrea        it's solr or nothing.
17:52 wizzyrea        (in their current implementation)
17:52 libsysguy       right
17:53 libsysguy       but i can understand their frustration with zebra
17:53 wizzyrea        who can't ;)
17:53 libsysguy       but solr is pretty huge
17:53 jcamins         Exactly.
17:53 libsysguy       too bad smaller libraries can't ban together and get some kind of EC2 instance to share
17:54 jcamins         libsysguy: that wouldn't work in places like Afghanistan.
17:54 libsysguy       true
17:54 libsysguy       what about nozebra
17:54 libsysguy       is that going away?
17:54 jcamins         sekjal was saying it should be made to work again, but right now it's bit-rotted.
17:54 libsysguy       that sounds pretty terrible lol
17:55 jcamins         It sure is!
17:56 sekjal          I'm sure there is a way to get better performance out of a MySQL-only implementation of Koha... somehow...
17:56 wizzyrea        I want to know what kind of hardware this guy on the list is using that he 'can't' run with zebra for 13k records.
17:56 wizzyrea        it's gotta be like a p2 or something.
17:56 libsysguy       punchcards...
17:56 sekjal          wizzyrea:  must be less than 256MB RAM and under 5GB harddrive
17:57 sekjal          or, perhaps he's on RedHat
17:57 wizzyrea        if that's meant to be sarcastic, that's the best curse ever.
17:58 wizzyrea        who runs anything with a 5gb HD?!
17:58 wizzyrea        he runs it from a live booting USB thumb drive.
17:58 wizzyrea        that must be it.
17:59 libsysguy       carrier pigeons for networking
18:00 * jcamins       thinks it's RedHat.
18:00 huginn          New commit(s) needsignoff: [Bug 6351] Cannot delete library-specific circulation rules <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6351>
18:01 wizzyrea        oo
18:02 cait            hehe
18:02 cait            hm, this bug sounds familiar - thought ruth fixed it
18:02 cait            pumpkin, ginger and honey, bad or good plan?
18:02 wizzyrea        oh it's a followup
18:03 libsysguy       speaking of ruth...where is she today
18:03 cait            have seen her earlier
18:04 sekjal          druthb did indeed solve 6351
18:04 libsysguy       oh i must've missed her...darn
18:04 sekjal          but I've reopened it because I've found more to it
18:04 sekjal          her fix stands
18:04 wizzyrea        i'm testing your followup :)
18:04 sekjal          but a couple other template scope issues need to be resolved for some of the other areas
18:05 cait            evil template things, still hiding in there
18:05 cait            sekjal: could you do qa on some of the template processing things?
18:05 cait            it needs more work still
18:06 sekjal          cait:  bug number?
18:06 cait            but easy to read patches
18:06 cait            I always search for translation processing, give me a sec
18:06 cait            bug 6458
18:06 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6458 normal, PATCH-Sent, ---, frederic, ASSIGNED , incorrect parsing result in translation processing
18:06 sekjal          wizzyrea/jcamins:  Mr. Harbottle's indicates he's on Debian
18:07 cait            and one of the patches owen signed off on I have to redo
18:07 wizzyrea        yep :)
18:07 cait            and nobody commented on my recipe idea... so it is probably a bad plan :)
18:07 wizzyrea        recipe idea?
18:07 cait            pumkin ginger and honey
18:07 jcamins         sekjal: huh. Go figure.
18:07 jcamins         cait: mmm.
18:07 cait            and it's too late already, because it's in the oven now :)
18:07 jcamins         Pie?
18:08 cait            no, only the pumpkin without any dough
18:08 cait            as kind of potato replacement
18:09 wizzyrea        ok, someone who has figured out how to obsolete patches from the git bz
18:09 wizzyrea        how do you do it?
18:10 wizzyrea        cait that sounds like a pumpkin souffle, but no eggs?
18:10 wizzyrea        you could also make pumpkin custard
18:10 wizzyrea        nom
18:10 wizzyrea        you're right though, you can use squash pretty much anywhere you'd use sweet potato
18:12 sekjal          cait: I'm not seeing exactly what those patches do differently... (looking at http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5125)
18:13 sekjal          ah
18:13 sekjal          template directives in HTML tags
18:13 cait            removing directives from within the html tag
18:13 cait            yep
18:13 sekjal          gotcha
18:13 cait            it seems a smart thing to do, but it's not
18:13 cait            causing me trouble
18:13 cait            or everyone not using en
18:14 sekjal          I'll look for that, then, and start passing them through QA
18:14 cait            nice :)
18:14 cait            I hope to finish most of them this week
18:14 gmcharlt        chris_n: is 6747 a candidate for backporting to 3.4.x ?
18:14 cait            signing off on owens and doing the rest
18:14 cait            bug 6747
18:14 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6747 minor, PATCH-Sent, ---, m.de.rooy, ASSIGNED , Additional check in opac-export
18:16 sekjal          wizzyrea: thanks for the tests on 6351 followup patch
18:16 wizzyrea        yvw
18:17 wizzyrea        thought i'd start doing that, where I list what was tested in case it's not enough.
18:17 wizzyrea        then someone can be like well she didn't test that, maybe I will
18:17 cait            wizzyrea++ :)
18:17 cait            bug 6351
18:17 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6351 major, PATCH-Sent, ---, ruth, REOPENED , Cannot delete library-specific circulation rules
18:17 wizzyrea        otherwise it's kind of assumed that they tested everything, and no one thinks of everything
18:17 sekjal          wizzyrea:  an excellent practice
18:18 wizzyrea        i have experience, sadly. :/
18:19 cait            we all miss things, I think best bet is to do it like you describe
18:19 cait            :)
18:20 sekjal          anyone object to me pushing this 6351 followup through QA (since I authored)?
18:20 wizzyrea        I don't, afaict it works in all circumstances (on the default library and specific ones)
18:22 sekjal          okay, then, I'm going to pass it.  objections can be noted on the bug report (as always)
19:35 Agent_Dani      Whenever I see "Puppet Labs" my mind reads "Muppet Labs."
19:35 Agent_Dani      Wrong window...
19:35 * wizzyrea      loves this game
19:36 wizzyrea        (that is the "come out with the most unique non-sequitur and frame it as a mistell" game)
19:36 Agent_Dani      hehe!
19:36 Agent_Dani      There was a discussion in another channel about the Puppet configuration management tool...
19:42 jcamins         Agent_Dani: I think chef is something similar.
19:45 Agent_Dani      It is.
19:45 Agent_Dani      I'm familiar with Puppet as we use it at $job.
19:57 wizzyrea        rhcl: http://www.crh.noaa.gov/news/display_cmsstory.php?wfo=top&storyid=72331&source=0
19:59 seneca          ouch
20:00 jwagner         crop circles???
20:00 wizzyrea        nope, storm damage from a really seriously heavy storm we had a few weeks ago
20:01 wizzyrea        crop damage
20:01 wizzyrea        wind flattened, then hail thrashed
20:03 rhcl            wizzyrea: we have rural deposit sites, where the library has a bookshelf or two at businesses or post offices in small towns; books are on a honorary checkout and checkin system.
20:03 rhcl            we have our outreach person do monthly runs to these sites and yesterday just for fun I met him for lunch at a very small town with a small restaurant
20:04 rhcl            the farmers there we talking about all the damage they received, and how the corn had blown down strangely in some parts of their fields, and in other areas not at all
20:05 wizzyrea        oo interesting
20:06 seneca          anyone ever see a problem where koha won't honor staff client permissions granted to users?
20:06 wizzyrea        hmm, can you be specific?
20:06 wizzyrea        which permission?
20:07 wizzyrea        I had a situation just the other day where a user thought that simply creating a "staff" account was enough to confer permission -- but that's not true, you have to assign the permissions in the patron account with more -> set permissions
20:07 seneca          catalogue
20:07 wahanui         hmmm... catalogue is only to view the catalogue
20:07 seneca          aka access to the staff client
20:08 wizzyrea        editcatalogue
20:08 seneca          doesn't catalog grant access to the staff client?
20:08 wizzyrea        let's find out >.>
20:08 seneca          the docs say it is... ;)
20:09 seneca          well, regardless, it doesn't matter.
20:09 seneca          making the account a superlibrarian doesn't allow staff client logins either
20:09 seneca          warning, I'm using 3.5
20:09 wizzyrea        my test user, with the only permission of "catalogue" gives access to look
20:09 wizzyrea        mine is on master
20:09 wizzyrea        (3.5)
20:10 wizzyrea        have you created your libraries?
20:10 seneca          eythian and rangi were helping me late last night (local) and we couldn't figure it out
20:10 seneca          looking in the db, it appears that the permissions are getting set correctly in the flags column
20:10 seneca          yeah, this is an established library
20:11 cait            night all
20:12 rhcl            @seen rangi
20:12 huginn          rhcl: rangi was last seen in #koha 15 hours, 57 minutes, and 31 seconds ago: <rangi> ok, back to lseep i go
20:12 wizzyrea        what are the characteristics of the patron you are trying to assign the permissions to?
20:12 wizzyrea        patron/account
20:12 seneca          patron
20:13 wizzyrea        (they are the same)
20:13 seneca          the account I'm trying to give access is a "patron" as are the already working user accounts
20:13 wizzyrea        and there is no error?
20:13 seneca          though those were given staff client permissions before we upgraded to 3.5
20:14 wizzyrea        when you try to add the permissions?
20:14 rhcl            sekjal: sent request for access
20:14 seneca          no errors
20:14 seneca          and like I said, it's being reflected correctly in the db
20:14 wizzyrea        right
20:14 wizzyrea        so
20:14 sekjal          rhcl:  access granted
20:14 wizzyrea        did they make you clear your cache/cookies/history?
20:14 wizzyrea        in your browser?
20:15 rhcl            sekjal: disregard
20:15 seneca          yeah
20:15 wizzyrea        and you're using a sane browser?
20:15 seneca          I've been testing this from multiple computers
20:15 seneca          yeah
20:15 seneca          chrome and firefox
20:15 wizzyrea        :) yep that's sane
20:16 seneca          crud - I just saw the time
20:16 seneca          I'll be back on in a bit...
20:16 seneca          sorry!
20:16 seneca          and thanks!
20:25 wizzyrea        i hate it when I just get curious about a problem, and then the person disappears. :)
20:27 wizzyrea        well I did not know that
20:28 wizzyrea        you can search for a patron based on username.
20:28 wizzyrea        hawt
22:42 seneca          good evening (for those of you in the EST)
22:51 seneca          so, I have this problem...
22:52 seneca          anyone running 3.5?
22:52 seneca          (I know it's not "stable")
22:52 seneca          but I'm trying to track down a bug
22:52 mtj             i have a 3.5 about...
22:52 mtj             if 3.5 == master
22:53 seneca          if you grant "catalogue" permissions to a user/patron, can they log into the staff client?
22:53 seneca          I think it does
22:53 seneca          I have a 3.5 installation that is acting VERY strange
22:53 seneca          we've been using koha for over a year now
22:54 seneca          with several users who have staff client access
22:54 seneca          this summer I upgraded to 3.5 via git
22:54 seneca          and just yesterday we added an account for a new staffer but could not grant them staff client privileges
22:55 seneca          even selecting "superlibrarian" didn't affect it
22:55 mtj             seneca: they should be able to - thats what the 'catalogue' priv is specifically for
22:55 seneca          attempting to log on gets a "don't have permissions" error
22:55 seneca          that's what I thought
22:56 seneca          that's not the only weird thing, though
22:56 seneca          I removed that perm from a staffer account from last year (pre-upgrade), checked to make sure they couldn't log in, then added it back
22:57 seneca          they were able to log in!
22:57 seneca          I've checked the "flags" column in BORROWERS in the db, and the flags are identical, as are the gui checkboxes that govern the flag column
22:58 seneca          so we cannot now grant staff client perm to any user that did not have it prior to the upgrade
22:58 seneca          though we can take it away and return it to any user that DID have it prior to the upgrade
22:58 seneca          tell me that's not strange
22:58 seneca          it's like there's some other switch somewhere I don't know about...
22:59 seneca          all users are "patron" type
22:59 mtj             yeah, sounds a bit weird
22:59 seneca          heh
22:59 seneca          rangi, eythian and I were working on it last night, but couldn't figure it out
23:00 seneca          I had to bow out for a few hours of sleep
23:00 mtj             but hey... you upgraded your prod system to master ?!?
23:00 seneca          the can't-grant problem affects new users and old users (from pre-upgrade)
23:00 seneca          yeah, I know
23:00 seneca          ...
23:00 jcamins         Very weird.
23:01 seneca          I had read that many others were running production 3.5 and figured it was mostly safe
23:01 seneca          I'm very impressed with 3.5, it's very slick
23:01 seneca          this is the only bug I've found
23:03 mtj             seneca:  my head koha is currently a little busted...
23:05 mtj             just updating it now, before i look at yr bug
23:05 seneca          I appreciate it
23:06 mtj             i started a big deb5-> deb6+raid+xen upgrade on my dev box, last friday...
23:07 seneca          how'd it go?
23:07 mtj             ... and ive only just got the xens booting successfully about 30 mins ago :p
23:07 mtj             truly epic
23:07 seneca          hehe
23:07 seneca          but sounds successful
23:08 mtj             i think i probably encountered all the upgrade problems i could possibly have!
23:08 seneca          well, if I can help in any way, let me know
23:08 seneca          I'm pretty linux knowledgable
23:08 seneca          not to toot my own horn
23:09 mtj             broken grub, grub2, initramfs, non mounting raids, and then non booting xens
23:10 seneca          geez
23:10 seneca          upgrade, not fresh install?
23:10 mtj             buy hey, i had a pretty complex setup... and i worked thru every problem, and fixed them
23:10 seneca          awesome
23:10 seneca          congrats
23:13 mtj             yep, and i now know a whole bunch about debugging non-booting systems, so it was an ok experience :)
23:14 seneca          there you go
23:14 seneca          "If you get something right, you know something; if you get something wrong, you learn something."
23:25 mtj             seneca: its works as expected on my master
23:25 seneca          drat
23:25 seneca          I mean, I'm glad for you ;)
23:28 mtj             so, its basically the borrowers.flags value that controls access
23:28 seneca          yeah
23:29 seneca          that's what I've figured out
23:29 mtj             thats where the user perms are stored
23:29 seneca          and a value of "4" means only the "catalogue" perm is on
23:29 seneca          and that is beign set correctly
23:29 seneca          being
23:30 mtj             hmm, its '0' for me..
23:30 seneca          that should be "superlibrarian"
23:30 seneca          if I understand it correctly
23:31 mtj             super is '1' for me...
23:31 seneca          hmm
23:31 eythian         0 means no flags, it's a bitmask
23:31 mtj             our 'userflags' table is diff.?
23:31 eythian         (at least, I assume it's a bitmask, I haven't looked at the code)
23:32 seneca          yeah, I think it's a bitmask
23:32 seneca          ok
23:32 seneca          yeah
23:32 seneca          I was thinking wrong
23:32 pastebot        "mtj" at 203.97.99.222 pasted "useflags" (46 lines) at http://paste.koha-community.org/22
23:32 seneca          0 is the count of the bit for super
23:32 seneca          but masking that bit would be 1
23:32 eythian         which means the bit in position 0 should be set to 1 for super.
23:32 seneca          yeah
23:32 seneca          hi again eythian
23:33 seneca          I was mis-thinking
23:33 eythian         hi
23:33 wahanui         privet, eythian
23:33 seneca          so, mtj, what is "0"
23:33 eythian         if I were you, I'd put tracing statements in the code. I bet there's some bizarre corner case you're hitting.
23:34 mtj             well, on *my* master its catalogue
23:34 seneca          weird
23:34 eythian         that is weird. I would not expect that.
23:34 seneca          yeah
23:34 seneca          eythian, can I ask what your catalogue mask is?
23:35 eythian         I don't know, I haven't got a master handy. Give me a minute I'll make one.
23:35 mtj             fyi: my userflags table might be trashy - its a dev/test db im looking at here....
23:35 seneca          if you mark an account with catalogue only, what is the flags value?
23:36 seneca          ah, mtj, that might be it
23:36 eythian         mtj: it still shouldn't be zero, no matter what, that has to mean no flags.
23:36 seneca          in my db "NULL" means no flags
23:37 eythian         I'd think that if you unset everything, it'd end up being 0
23:37 eythian         null probably just means never set.
23:37 eythian         hmm
23:37 mtj             well, its 0 for me, and its working as expected... ?
23:37 eythian         odd
23:37 * eythian       will find out soon.
23:37 seneca          hehe
23:38 mtj             oops, its 4 , not  0 for catalogue :/
23:38 mtj             sorry folks
23:38 seneca          ok, verified that "0" is no flags set, "NULL" is no flags ever set
23:38 seneca          hehe
23:38 seneca          no prob
23:38 seneca          glad your db is n't weird ;)
23:39 mtj             seneca: so with a userflag of 4, a user should be able to log in
23:39 mtj             ... if the userflags table is correct
23:39 pastebot        "eythian" at 202.78.240.7 pasted "Initial state of two users" (6 lines) at http://paste.koha-community.org/23
23:40 eythian         so, one of those is a superlibrarian, the other is a regular user
23:40 mtj             so check yr userflags table ;)
23:40 seneca          yeah
23:41 seneca          "catalogue" is the 3rd bit, so a mask of 4 is correct
23:41 seneca          but it's not working for me
23:42 pastebot        "eythian" at 202.78.240.7 pasted "Set user 68 to have catalogue permissions" (6 lines) at http://paste.koha-community.org/24
23:42 seneca          it doesn't matter what perms I set, users who have never had staff client access can't get in
23:42 seneca          same stuff I'm seeing eythian
23:42 eythian         this user can now log in
23:42 seneca          grrr
23:42 mtj             look in your log
23:42 seneca          eythian, what kind of tracers were you referencing?
23:43 seneca          which log?
23:43 mtj             you will probably find a nice db error there
23:43 eythian         basically, chucking print STDERR "Got here and var=$var\n"; in the code and seeing what happens in your apache error log
23:43 mtj             the koha error log
23:44 pastebot        "eythian" at 202.78.240.7 pasted "Remove catalogue permissions" (6 lines) at http://paste.koha-community.org/25
23:45 eythian         > Error: You do not have permission to access this page.
23:45 eythian         exactly like I'd expect
23:45 seneca          that's the error I'm getting on the staff login page, so I'd assume that's the error I'd see in the koha error log
23:45 seneca          but I'm looking...
23:46 eythian         I don't think it logs those things to the error log
23:46 eythian         because they're not software errors
23:46 mtj             correct eythian :)
23:46 seneca          yeah, I'm not seeing anything related
23:47 eythian         that's why I'd put prints in the code, to see what happens when Koha tries to log the user in.
23:47 eythian         (warning: the authorisation code is terribly twisted in places, but for something like this you should be able to figure it out)
23:47 seneca          fun! ;)
23:48 seneca          mind if I c/p your code from above, eythian?
23:48 eythian         of course you can :)
23:48 eythian         but you'll need to adjust it to suit where you are in the code
23:49 seneca          hmm...
23:49 seneca          where would you suggest I start sticking it?;)
23:50 eythian         Probably C4/Auth.pm, but to be sure, this is the login page form:
23:50 eythian         <form action="/cgi-bin/koha/mainpage.pl" method="post" name="loginform" id="loginform">
23:50 eythian         so you could start there and see what it does.
23:50 mtj             seneca: the other long-shot is your koha has a goofy syspref  flicked on
23:50 mtj             cas or ldap auth, or restricted IP's etc
23:51 seneca          well, I'm using ldap
23:51 seneca          for user auth
23:51 seneca          and it's working...
23:52 mtj             hmmm, but you are experiencing some problems too? ;)
23:52 seneca          well, I am
23:53 mtj             so, yeah - its poss. something around your ldap too
23:53 seneca          BUT
23:53 mtj             setup another clone, turn off ldap... is your problem still there? etc...
23:53 seneca          my account, which is the one I'm testing this with, and which cannot log in to the staff client regardless of the perms I set, can log into the OPAC
23:55 mtj             sure, thats expected, i think...
23:55 mtj             ie: there are no perms needed to log into the opac
23:55 seneca          would the staff client login get something different from ldap than OPAC login?
23:55 mtj             just a valid user/pwd
23:55 seneca          there are never perms needed to log into the OPAC, though
23:55 seneca          it's always just a user/passwd
23:55 seneca          right?
23:56 mtj             yep, as i said
23:56 seneca          plus, the error I'm getting is that I don't have perms, not that the user/passwd failed
23:56 seneca          so ldap is working...
23:57 seneca          but for some reason koha isn't caring what's in the flags column
23:57 mtj             i would def. test without ldap - if i were you
23:57 mtj             and with a fresh syspref table from git
23:57 eythian         it's worth a shot.
23:58 eythian         Well, I'd do one at a time
23:58 eythian         turn off ldap, see if that helps.
23:58 seneca          I figured I'd try the tracker first
23:58 eythian         If not, then reset the sysprefs
23:58 seneca          seems easier, but I can't figure out where to put it...