IRC log for #koha, 2011-08-30

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
00:19 druthb joined #koha
00:21 druthb o/
00:36 meliameggs_ left #koha
00:57 lastnode hi, im trying to sue koha-create --create-db mydb on debian
00:58 and i get "does not exist"
01:10 anyone?
01:16 eythian lastnode: what version?
01:16 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 3.2 i think?
01:16 eythian lastnode: can you check, they were updated yesterday.
01:16 apt-cache policy koha-common
01:17 do you have a file: /etc/koha/koha-sites.conf?
01:18 lastnode eythian: yes
01:18 i even loaded it via --config
01:19 eythian try --configfile
01:19 lastnode yea
01:19 sorry, i meant i sued taht flag
01:19 *used
01:19 eythian OK
01:19 * eythian looks
01:19 eythian so, you have 3.4.4?
01:19 lastnode then it asked me to checkif /etc/mysql/koha-common.cnf existed
01:19 so i touched it
01:19 and now it asys
01:20 cannot connect to mysql server through
01:20 socket /var/runmysqld/mysqld.sock (2)
01:20 eythian do you have the mysql server running?
01:20 (do you have it installed?)
01:20 lastnode http://wiki.koha-community.org[…]ueeze#Quick_Start
01:20 im following this guide
01:20 because it was debian
01:20 on ubuntu i followed a different guide where i had to run myusql manually
01:21 this guide doestn say anything of the sort
01:21 mysql-common the package is isntalled though
01:21 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:21 so, install mysql-server
01:22 btw the koha-common.cnf file should be:
01:22 $ ls -l /etc/mysql/koha-common.cnf
01:22 lrwxrwxrwx 1 root root 26 Dec 21  2010 /etc/mysql/koha-common.cnf -> /etc/koha/mykoha-mysql.cnf
01:22 oh wait
01:22 wrong server
01:22 lastnode wont the koha-common  package dependon mysql?
01:22 eythian lrwxrwxrwx 1 root root   10 Apr 28 16:30 koha-common.cnf -> debian.cnf
01:23 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[…]ueeze#Quick_Start
01:24 not that i can find
01:24 unless ive missed it
01:24 anyway yeah, getting mysql now
01:24 eythian hit refresh, it'll be there
01:25 lastnode like a boss, eythian
01:25 eythian :)
01:26 lastnode im trying to demo koha today for the prinicipal
01:26 /librarian
01:26 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 bring up nothing
01:26 bc of US based isbn
01:26 is tehr some way i acan connect o a britishlibrary
01:26 via z.39?
01:26 or indian?
01:26 eythian yeah, you can
01:27 you just need to find their details
01:27 lastnode ok
01:27 sec, just settign this up
01:27 im inside a vm bc i dont want to keep booting into ubuntu
01:27 and to be honest, i wouldnt run koha on ubuntu anyway
01:27 not for production
01:27 bc in 12 months whenthat EOLs ill have to upgrade
01:27 eythian No, we recommend debian
01:27 lastnode whereas with ubuntu i can install and upgrade next when i retire
01:28 *debian
01:28 eythian heh
01:28 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:28 *ubuntu has been pretty bad
01:28 eythian Yeah, me too
01:29 http://www.bl.uk/bibliographic[…]onfiguration.html <-- british library Z39.50 info
01:29 but google will find you plenty more
01:29 * eythian has to go have lunch
01:30 lastnode eythian: now that it says apache is running etc.
01:30 http://kohadmin should take me to admin right
01:40 http://127.0.0.1:8080 wont take me to teh admins creen
01:40 i even added listen 8080 to /etc/apache2/ports.conf
01:53 eythian: just ping when ur back, mate
01:53 imma brb
02:00 chris_n` joined #koha
02:23 Soupermanito joined #koha
02:29 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:01 seneca joined #koha
03:02 seneca Anyone having any trouble with 3.5 and staff client access permissions?
03:04 from what I can tell, granting "catalogue" permissions to a patron no longer allows them to log in to the staff client
03:12 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 But I don't think it's catalogue
03:17 it's the one that says that it gives access to the staff interface.
03:17 seneca the docs say that's "catalogue"
03:17 libsysguy1 joined #koha
03:18 seneca and the description of that permissions is (Librarian Interface)
03:18 which seems to point to that permission being the one I want, but it isn't working
03:19 bshum joined #koha
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:19 yeah, I'm pretty sure it worked for us before the 3.5 upgrade earlier this summer
03:19 eythian but, it was a little while
03:19 ago
03:19 right
03:20 Does superlibrarian still work?
03:20 seneca but we're just now needing to add new staff
03:20 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:21 so, basically, I guess my problem is that koha is ignoring the user permissions
03:22 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:22 seneca yeah
03:22 eythian Not sure, I haven't heard of it, though it might be in someone's git repo.
03:22 seneca I wonder how ugly downgrading via git is
03:23 eythian You just need to change branches to v3.04.04
03:23 rangi i can add staff and login to my koha running master
03:23 seneca it's a vm, so I'll just snapshot it before in case anything hoses itself
03:23 rangi <meta name="generator" content="Koha 3.0500006" /> <!-- leave this for stats -->
03:23 seneca is 3.4 master?
03:23 rangi and http://catalog.nexpresslibrary.org/
03:23 no 3.5 is
03:24 seneca hmm
03:24 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:24 there has not been a bug for logging in
03:24 in ages
03:25 (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 rather than a login, per se
03:25 or the existing staff wouldn't be able to log in
03:25 rangi well if superlibrarian cant login
03:25 we'd have heard
03:25 eythian but maybe not if you just can't create new ones.
03:25 seneca it's not only new users, though
03:25 eythian oh right
03:26 I misunderstood above then
03:26 seneca it is ignoring permissions for even old users we'd like to turn into staff accounts
03:26 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:26 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:27 seneca yes, permissions are save
03:27 d
03:27 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 hold on for data...
03:28 * rangi is home with the flu
03:28 * libsysguy1 offers rangi theraflu
03:28 * rangi head is pretty fuzzy still, just have to write an email then back to sleep
03:29 seneca ooooo, interesting
03:30 removing "catalogue" from a currently working staffer blocks their staff client login
03:30 let me see if putting it back returns their logins
03:30 and it does!
03:31 so... the problem gets more specific
03:32 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 that would make sense to me
03:32 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:33 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:34 libsysguy1 yeah I'm wondering if you can check to see if that is getting set correctly
03:34 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:36 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:40 one borrowernumber has "edit_catalogue"
03:41 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 oh
03:42 edit_catalogue is a different permission in the gui
03:42 hold on
03:43 eythian well, there's also userflags, and I'm not sure how that relates
03:43 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 according to userflags
03:46 but I don't see any borrowernumber in user_permissions that has bit 2
03:47 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:48 seneca I don't understand the question
03:49 eythian are they using a real login, or the database login, which will always log you in as a superlibrarian
03:49 seneca they have their own personal user account
03:50 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:51 eythian oh, right
03:52 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:52 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:53 rangi SELECT borrowernumber, firstname, surname, flags, borrowers.branchcode,                branches.branchname    as branchname,
03:54 thats where its getting the permissions
03:54 FROM borrowers
03:55 seneca hmm
03:55 "Flags?
03:56 eythian userpermissions must then track the sub-permissions.
03:56 user_permissions
03:56 rangi my $all_perms = get_all_subpermissions();
03:56 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:57 "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 however
03:59 rangi and get_all_subpermissions gets the stuff from permissions and userflags
03:59 seneca is the flag column in BORROWERS a cumulative bitcount?
03:59 rangi yes
04:00 seneca ok
04:00 so a value of 4 would be...
04:00 rangi no idea
04:00 seneca haha
04:01 libsysguy1 left #koha
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 ah yes, eythian is right
04:01 indradg joined #koha
04:01 eythian (I'd expect)
04:01 seneca oh
04:01 so my user's flag of 4 means that the third bit is marked?
04:02 1,2,4?
04:02 eythian yeah
04:02 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 but I still can't log in ;)
04:03 rangi wrong password?
04:03 seneca nope
04:04 we use ldap and I can log in to the OPAC just fine
04:04 but not the staff client
04:04 rangi theres something up with your db/setup then
04:04 seneca drat.
04:05 eythian there's not some ldap flag that is require too, maybe? (I wouldn't think so)
04:06 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 we're only pulling a few fields from ldap
04:07 names and card numbers
04:08 it's like there's some other switch besides the "catalogue" flag
04:08 but I don't know it if there is, and it's not in any docs
04:09 I really appreciate you guys spending so much time on my problem, though
04:09 rangi i dont know of any other switch
04:10 eythian Yeah, I don't think there is.
04:10 seneca well, it's WAY past my bedtime
04:11 so I'm going to go sleep on it
04:11 if you have any epiphanies, bryan.lakatos@mvschool.com
04:11 :)
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 the ones that cant login
04:11 seneca is that patron,s taff, etc?
04:11 patron, staff, I mean
04:11 rangi its whatever you want it to be
04:12 but the value in the categorycode column
04:12 seneca well, right
04:12 rangi in borrowers table
04:12 will need to be valid
04:12 ie match one of the categories you have defined
04:12 seneca seems like it
04:13 I have the categorycode of PT
04:13 which I believe is patron, as the gui shows
04:13 but where are those categories defined in the staff client?
04:13 rangi in admin
04:13 borrower categories or the like
04:13 seneca oh, geez, under "patron categories" perhaps? ;)
04:13 rangi :)
04:14 seneca yeah, PT = patron
04:14 eythian > <input type="hidden" value="HASH(0x4c99140)" name="tab">
04:14 hmm
04:14 rangi the only thing i would try is making one a staff, (if you havent already)
04:14 ok, back to lseep i go
04:14 seneca yeah, I've tried that, unfortunately
04:14 feel better!
04:15 is there anywhere that you can block a user category from accessing the staff client?
04:15 or require a certain category for staff client access?
04:15 maybe a new setting in 3.5?
04:15 eythian nothing I'm aware of
04:16 seneca man, I always have the strangest problems...
04:16 ethian, you're using 3.4, right?
04:16 eythian yeah
04:17 seneca I guess I can try a downgrade...
04:17 always leary of that
04:17 er leery
04:17 eythian well, take a backup first then :)
04:17 seneca yeah
04:17 yay for vms
04:18 ok, thanks for the help
04:18 there's my email up there if you remember anything else
04:18 Oak joined #koha
04:18 seneca and again, I really appreciate your help!
04:18 eythian sweet as
04:19 seneca one day I'll know enough about koha to return some of these favors...
04:19 ciao
04:21 Oak hello #koha :)
04:21 hello Mr. Robin
04:23 eythian hi :)
04:23 Oak :)
05:09 francharb joined #koha
05:09 francharb morning everyone
05:13 Oak Bonjour francharb :)
05:13 francharb hi Oak
05:59 alex_a joined #koha
05:59 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:16 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[…]w_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 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 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:28 magnuse eythian++
06:29 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:32 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 oh well, maybe it flew out...
06:37 eythian just keep saying that to yourself
06:37 magnuse yup
06:38 hdl joined #koha
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 joined #koha
06:38 reiveune hello
06:39 eythian they'd stop chasing flies.
06:39 magnuse bonjour biblibre
06:39 eythian: hm, maybe...
06:42 cait joined #koha
06:42 cait magnuse++
06:42 magnuse gbsd email?
06:42 cait yep
06:43 although there could be a lot of other good reasons :)
06:43 magnuse nah
06:46 cait :)
06:48 hdl hi all
06:48 Irma joined #koha
06:56 julian joined #koha
07:00 magnuse hiya Irma and julian
07:00 julian hello magnuse
07:01 reiveune joined #koha
07:02 sophie_m joined #koha
07:03 sophie_m hi #koha
08:09 kf joined #koha
08:09 kf hi #koha
08:52 reiveune ?
09:09 kf hi reiveune
09:09 reiveune hi kf
10:33 Guillaume1 joined #koha
10:38 BobB joined #koha
11:17 Brooke joined #koha
11:17 Brooke 0/
11:25 indradg joined #koha
11:32 druthb joined #koha
11:34 jwagner joined #koha
11:37 chris_n joined #koha
12:15 oleonard joined #koha
12:18 JesseM joined #koha
12:46 tcohen joined #koha
12:47 trea joined #koha
12:48 jcamins_away chris_n: how are things by you?
12:49 oleonard Congrats on the new job trea
12:49 trea thx owen
12:59 NateC joined #koha
13:14 Guillaume1 joined #koha
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[…]w_bug.cgi?id=5806>
13:30 trea i know! :D
13:31 sekjal joined #koha
13:32 oleonard Sounds like a ByWater customer is using/going to use the IndependantBranches option?
13:32 kf hi trea, oleonard and sekjal
13:32 sekjal oleonard:  a few of our partners do
13:32 hi, kf
13:33 trea hi kf
13:33 pelletiermaxime joined #koha
13:33 kf hi pelletiermaxime
13:33 oleonard sekjal: I'm happy to see it get some attention.
13:34 pelletiermaxime good morning =)
13:44 sekjal oleonard:  in the medium-long term, it'll need to be split into multiple preferences.  IndependentPatrons, IndependentCataloging, IndependentOPAC, etc
13:45 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:46 trea joined #koha
13:48 kf sekjal: it would be nice if you could group branches and have flags for opac visibility
13:48 would make it possible to have invisible internal departments
13:49 sekjal kf:  agreed.
13:49 I'd like see the Branch Groups functionality do a little more
13:49 kf jwagner?
13:50 jwagner Hi there
13:50 kf hi
13:50 about bug 5806 - I see you changed it back to needs sign-off
13:50 huginn 04Bug http://bugs.koha-community.org[…]w_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 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 sorry then!
13:50 misread the bugzilla mail
13:50 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 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:53 melia joined #koha
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 no, doesn't look like that
13:58 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 not quite the same
13:59 line 2880 seems to be unique
14:01 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:01 anything else you want me to add?
14:01 since I'm sending this anyway :P
14:02 kf hm
14:02 something wrong with the frameworks perhaps?
14:02 wizzyrea i'll ask if he's using a translation
14:02 good pt
14:02 kf oh translation is a good point too
14:03 libsysguy joined #koha
14:04 sekjal wizzyrea:  it's in the _AddBiblioNoZebra subroutine
14:04 wizzyrea ooooooo
14:04 I bet he's running nozebra
14:04 maybe?
14:04 libsysguy does anybody know how series searching works?
14:04 kf upgrading from a nozebra installation
14:04 ...?
14:04 wizzyrea that could be too
14:04 kf you can't select nozebra now
14:04 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 in which field came the series information?
14:05 libsysguy 490a
14:05 kf and can you search for it using the keyword index?
14:06 libsysguy yes I can
14:06 but i can't limit by series
14:06 kf but not from series?
14:06 limit means using the special search option series?
14:06 libsysguy keyword search http://catalog.uttyler.edu/cgi[…]h.pl?q=STAT%21Ref
14:06 limit my series http://catalog.uttyler.edu/cgi[…]medical%20library.
14:07 kf hm doesn't open for me :(
14:07 libsysguy 0_0
14:07 either link?
14:07 kf looooading...
14:07 no timeout yet
14:07 wizzyrea same here
14:07 libsysguy weird
14:08 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:08 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 just curious
14:09 it shouldn't have any effect
14:09 wizzyrea um, kansas.
14:10 ^.^
14:10 tha intarwebs.
14:10 kf wizzyrea: good mail :) shoudl save that and use as template!
14:10 germany!
14:10 :)
14:10 need an ip address?
14:10 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 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[…]w_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:13 libsysguy interesting idea
14:13 wizzyrea not sure I understand your logic there, but ok
14:14 :)
14:15 jcamins wizzyrea: wizzyrea Zebra is finicky? ;)
14:15 wizzyrea no no, about the dns server.
14:16 zebra *is* finicky
14:16 jcamins Oh.
14:17 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 the pitfalls of a giant blanketing firewall
14:21 ok those links should be fixed now
14:22 wizzyrea it's pretty :)
14:22 kf looks better
14:22 libsysguy haha better than a blank page
14:22 kf nice layout :)
14:22 libsysguy in another life i did a lot of web devel
14:23 thanks :)
14:23 kf Davis&rsquo;s drug guide for nurses    ?
14:24 libsysguy haha yeah...
14:25 looks like a smart quote got in there
14:25 kf http://catalog.uttyler.edu/cgi[…]medical%20library. this link works
14:25 so it could be a problem with the ! I think
14:25 jcamins: around?
14:25 jcamins I am.
14:25 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[…].pl?q=se:STAT!Ref
14:26 jcamins You shouldn't.
14:26 kf libsysguy: weird!
14:26 libsysguy totally
14:26 and I did a full reindex last night
14:26 jcamins Unless there is more punctuation... <! or !- for example, might cause problems.
14:26 libsysguy so I know it can't be that
14:27 kf libsysguy: how does the 490 field look like?
14:27 I can't see it in the marc view
14:27 jcamins Resend the link that doesn't work?
14:28 libsysguy http://catalog.uttyler.edu/cgi[…]medical%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 Good point.
14:30 libsysguy http://catalog.uttyler.edu/cgi[…]medical%20library.
14:30 fails
14:30 jcamins Okay, what's the entity for an exclamation mark?
14:31 kf probably you need to define one
14:31 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 Sorry, I've been working with a lot of XML recently.
14:31 I mean "not an entity at all." ;)
14:32 libsysguy %21
14:32 jcamins Wait.
14:33 We've seen this before.
14:33 It's Zebra.
14:33 kf zebra!
14:33 libsysguy cursed Zebra
14:33 * kf giggles
14:33 libsysguy Dun dun DUUU
14:33 jcamins It's using the wrong index.
14:33 kf se,phr?
14:34 jcamins Right, due to unexplained peculiarities, that index is not entirely functional.
14:34 adnc joined #koha
14:34 * libsysguy scratches head
14:34 jcamins wrdl works.
14:35 kf hm
14:35 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 things like https://hfjs.bsz-bw.de/cgi-bin[…]r%20Sprachenkunde work nicely
14:35 jcamins Yeah, it has to do with the length of the index.
14:35 kf oh!
14:35 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:36 and jcamins++
14:36 jcamins So you can fix this by mucking around with record.abs.
14:36 adnc kf, by editing what?
14:36 libsysguy so technically there is a syspref for it lo
14:37 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:37 kf adnc: do you want to remove or change it?
14:37 adnc remove
14:37 kf ah, that should be quite easy
14:38 even using css
14:38 pastebot "libsysguy" at 129.114.242.85 pasted "JS for opac auth" (4 lines) at http://paste.koha-community.org/21
14:38 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 jcamins++
14:39 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[…]w_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:41 libsysguy oh...that code i sent was for the js
14:41 kf libsysguy makes it possible to have your own text
14:42 and my trick removes the exsting text
14:42 libsysguy right :)
14:42 kf hm
14:42 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:43 adnc wonderfull
14:43 thanks
14:43 kf so it works for you?
14:44 ah, works now for me to, cache probably
14:44 adnc kf, yes sure. I just set the css id #nologininstructions
14:44 to display none
14:44 kf :)
14:45 oleonard Sorry, was afk. Someone talking to me?
14:45 wizzyrea it was me :)
14:46 I was looking at your fix for bug 2534
14:46 huginn 04Bug http://bugs.koha-community.org[…]w_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:46 wizzyrea right
14:46 correct
14:48 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 There may be two.
14:50 libsysguy melm 490$a      Title-series:w,Title-series:p
14:50 melm 490$9      Koha-Auth-Number
14:50 jcamins Right.
14:50 libsysguy oh and melm 490        Title,Title-series
14:50 jcamins First of all, you're aware that 490 isn't the right field for limits in general, right?
14:50 libsysguy thats the only bits I have
14:51 i am not...
14:51 but I could be
14:51 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 ah
14:51 jcamins kf: facets = limits.
14:51 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[…]w_bug.cgi?id=6817> / [Bug 5630] CAS improvements <http://bugs.koha-community.org[…]w_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:52 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:52 libsysguy oh man...ok im holding on to me seat
14:54 wizzyrea sekjal++ it's totally to do with nozebra
14:54 (the harbottle question)
14:54 he's currently running nozebra
14:55 jcamins libsysguy: so, here's the fix:
14:55 melm 490$a    Title-series:w,Title-series:p,Title:w
14:55 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:55 wizzyrea yea
14:55 i'm sending it
14:55 jcamins Reindex.
14:55 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:57 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:58 wizzyrea hehe
14:59 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
14:59 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 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[…]w_bug.cgi?id=6292>
15:02 kf sophie_m: hi sophie_m - is there a problem with bug 6292?
15:02 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6292 critical, PATCH-Sent, ---, chris, ASSIGNED , Overdue notices have a bug when multiple overdues exist
15:02 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:03 libsysguy oh so its not just a weird obscure problem that I was having
15:03 excellent
15:04 wizzyrea it's a weird obscure problem you were having that you can fix :)
15:04 so no one else has it ^.^
15:04 reiveune bye
15:04 kf yep
15:04 wizzyrea bye
15:04 reiveune left #koha
15:04 sekjal NoZebra is still a valid configuration, I believe.  or, at least, I think that it should be
15:04 kf sophie_m: I see the new patch :)
15:04 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 libsysguy: magic
15:06 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:06 wizzyrea jcamins?
15:06 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 lol
15:07 @quote add <libsysguy> jcamins is the wizard that forges queries in the deep fires of zebra
15:07 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-cli[…]/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 sekjal++
15:09 bye all
15:09 wizzyrea bye kf
15:09 libsysguy bye kf
15:10 kf left #koha
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 but it still needs to be integrated
15:12 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 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:14 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 which is that when you scroll horizontally
15:17 you lose the add item field labels
15:17 (without the menu/sidebar there)
15:18 we're actually going to send your options off to some of our catalogers :)
15:18 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 libsysguy: did my change fix it?
15:21 libsysguy well I can't know until i reindex
15:21 and I can't do that until tonight
15:21 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 oleonard, made a huge difference
15:22 jcamins libsysguy: just use rebuild_zebra.pl -b -x -v
15:22 oleonard I narrowed the sidebar and gave the whole section some padding on the top
15:22 jcamins libsysguy: you may still want to wait, so the server isn't under so much load.
15:22 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 err
15:23 jcamins libsysguy: no, it does it with -z every 5 minutes.
15:23 libsysguy well it does a...yeah
15:23 that
15:23 lol
15:24 its still going to take awhile to dump all those records
15:25 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 the moredetail.pl page is a little redundant, but the additem page doesn't show the history
15:36 what if the additem table included the history info, and that view was the only items view?
15:36 i told you it was crazy
15:37 something like 2 rows for each item - the stuff that's there now, and a 2nd row for history
15:37 perhaps expandable?
15:38 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:39 wizzyrea right, and in some cases it's the only way that stuff WORKS
15:40 as in the case of lost
15:40 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 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:45 But it's a nifty idea.
15:45 wizzyrea yea, it used to work :(
15:46 and supposedly it's native to git now, but for the life of me I can't make it work again.
15:46 oh well.
15:46 Guillaume1 left #koha
15:58 rhcl joined #koha
16:03 Johnindy joined #koha
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 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:06 * jcamins gets very worked up about this kind of thing.
16:06 huginn New commit(s) needsignoff: [Bug 6271] GetItemIssue(s) : renewals in both items and issues tables <http://bugs.koha-community.org[…]w_bug.cgi?id=6271>
16:07 * jcamins considers that justified.
16:14 sophie_m left #koha
17:32 libsysguy sekjal: you around?
17:34 Oak joined #koha
17:34 sekjal libsysguy:  yes
17:34 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 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:35 libsysguy ok cool thanks
17:36 cait joined #koha
17:36 sekjal libsysguy:  look at some of the existing RFCs to get an idea on formatting and sections to include
17:36 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:37 cait hi liz
17:37 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 hm not sure i understand it
17:38 can you explain?
17:39 oh, you were talking to libsysguy?
17:39 libsysguy umm i don't think so but maybe...were you wizzyrea
17:39 wizzyrea nah, I was talking to whoever is listening
17:40 libsysguy hehe
17:40 wizzyrea well, for example
17:40 the overdue report
17:40 on the main circ screen
17:40 you must have "reports"
17:40 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:40 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:41 libsysguy now i've confused myself
17:42 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:42 libsysguy ahhh
17:43 well in that case I am unsure
17:43 wizzyrea I think what I'm saying is the following
17:43 of all the items listed on that page
17:43 should the circulation permission cover all of them?
17:43 apparently not
17:44 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:44 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:46 cait hm
17:46 good question
17:47 moving them might be inconvenient
17:47 do we need more granular permissions? like having a circ_reports perm?
17:47 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 that's a good question
17:48 cait rewrite of circulation?
17:48 libsysguy I would like to check out that branch and look at it
17:48 but i don't know where it is
17:48 wizzyrea oh biblibre's circ rewrite?
17:49 libsysguy yeah
17:49 man biblibre is on the ball with the new stuff
17:49 wizzyrea it's difficult to test sometimes
17:49 that's actually old stuff
17:50 old-new stuff
17:50 libsysguy i was just looking at their solr implementation
17:50 cait yeah, the problem is the tesitng
17:50 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 it would be better if they did it in smaller patches
17:51 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:51 libsysguy I wonder if it could be an installation choice
17:52 zebra or solr
17:52 wizzyrea that's thte idea
17:52 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 (in their current implementation)
17:52 libsysguy right
17:52 but i can understand their frustration with zebra
17:52 wizzyrea who can't ;)
17:52 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:53 jcamins libsysguy: that wouldn't work in places like Afghanistan.
17:53 libsysguy true
17:54 what about nozebra
17:54 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:54 jcamins It sure is!
17:55 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 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:56 or, perhaps he's on RedHat
17:57 wizzyrea if that's meant to be sarcastic, that's the best curse ever.
17:58 who runs anything with a 5gb HD?!
17:58 he runs it from a live booting USB thumb drive.
17:58 that must be it.
17:58 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[…]w_bug.cgi?id=6351>
18:00 wizzyrea oo
18:02 cait hehe
18:02 hm, this bug sounds familiar - thought ruth fixed it
18:02 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:03 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 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 sekjal: could you do qa on some of the template processing things?
18:05 it needs more work still
18:05 sekjal cait:  bug number?
18:05 cait but easy to read patches
18:05 I always search for translation processing, give me a sec
18:06 bug 6458
18:06 huginn 04Bug http://bugs.koha-community.org[…]w_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:06 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 cait: mmm.
18:07 cait and it's too late already, because it's in the oven now :)
18:07 jcamins Pie?
18:07 cait no, only the pumpkin without any dough
18:08 as kind of potato replacement
18:09 wizzyrea ok, someone who has figured out how to obsolete patches from the git bz
18:09 how do you do it?
18:10 cait that sounds like a pumpkin souffle, but no eggs?
18:10 you could also make pumpkin custard
18:10 nom
18:10 you're right though, you can use squash pretty much anywhere you'd use sweet potato
18:11 sekjal cait: I'm not seeing exactly what those patches do differently... (looking at http://bugs.koha-community.org[…]ment.cgi?id=5125)
18:13 ah
18:13 template directives in HTML tags
18:13 cait removing directives from within the html tag
18:13 yep
18:13 sekjal gotcha
18:13 cait it seems a smart thing to do, but it's not
18:13 causing me trouble
18:13 or everyone not using en
18:13 sekjal I'll look for that, then, and start passing them through QA
18:13 cait nice :)
18:14 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 bug 6747
18:14 huginn 04Bug http://bugs.koha-community.org[…]w_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:16 thought i'd start doing that, where I list what was tested in case it's not enough.
18:16 then someone can be like well she didn't test that, maybe I will
18:17 cait wizzyrea++ :)
18:17 bug 6351
18:17 huginn 04Bug http://bugs.koha-community.org[…]w_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:17 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 :)
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)
18:48 libsysguy left #koha
19:19 nengard joined #koha
19:35 Agent_Dani Whenever I see "Puppet Labs" my mind reads "Muppet Labs."
19:35 Wrong window...
19:35 * wizzyrea loves this game
19:35 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 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:44 Agent_Dani It is.
19:45 I'm familiar with Puppet as we use it at $job.
19:47 hdl joined #koha
19:55 seneca joined #koha
19:56 wizzyrea rhcl: http://www.crh.noaa.gov/news/d[…]id=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:00 crop damage
20:00 wind flattened, then hail thrashed
20:02 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 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:03 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:05 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 which permission?
20:07 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:07 wizzyrea editcatalogue
20:07 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 well, regardless, it doesn't matter.
20:09 making the account a superlibrarian doesn't allow staff client logins either
20:09 warning, I'm using 3.5
20:09 wizzyrea my test user, with the only permission of "catalogue" gives access to look
20:09 mine is on master
20:09 (3.5)
20:09 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 looking in the db, it appears that the permissions are getting set correctly in the flags column
20:10 yeah, this is an established library
20:11 cait night all
20:11 cait left #koha
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 patron/account
20:12 seneca patron
20:12 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:13 wizzyrea when you try to add the permissions?
20:14 rhcl sekjal: sent request for access
20:14 seneca no errors
20:14 and like I said, it's being reflected correctly in the db
20:14 wizzyrea right
20:14 so
20:14 sekjal rhcl:  access granted
20:14 wizzyrea did they make you clear your cache/cookies/history?
20:14 in your browser?
20:14 rhcl sekjal: disregard
20:14 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 yeah
20:15 chrome and firefox
20:15 wizzyrea :) yep that's sane
20:16 seneca crud - I just saw the time
20:16 I'll be back on in a bit...
20:16 sorry!
20:16 and thanks!
20:23 hdl joined #koha
20:25 wizzyrea i hate it when I just get curious about a problem, and then the person disappears. :)
20:27 well I did not know that
20:27 you can search for a patron based on username.
20:27 hawt
20:53 francharb left #koha
21:36 pelletiermaxime left #koha
22:24 NateC joined #koha
22:40 seneca joined #koha
22:41 seneca good evening (for those of you in the EST)
22:47 melia joined #koha
22:51 seneca so, I have this problem...
22:51 anyone running 3.5?
22:51 (I know it's not "stable")
22:52 but I'm trying to track down a bug
22:52 mtj i have a 3.5 about...
22:52 if 3.5 == master
22:52 seneca if you grant "catalogue" permissions to a user/patron, can they log into the staff client?
22:52 I think it does
22:53 I have a 3.5 installation that is acting VERY strange
22:53 melia left #koha
22:53 seneca we've been using koha for over a year now
22:53 with several users who have staff client access
22:54 this summer I upgraded to 3.5 via git
22:54 and just yesterday we added an account for a new staffer but could not grant them staff client privileges
22:54 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 that's what I thought
22:55 that's not the only weird thing, though
22:56 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:56 they were able to log in!
22:57 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:57 so we cannot now grant staff client perm to any user that did not have it prior to the upgrade
22:58 though we can take it away and return it to any user that DID have it prior to the upgrade
22:58 tell me that's not strange
22:58 it's like there's some other switch somewhere I don't know about...
22:58 all users are "patron" type
22:59 mtj yeah, sounds a bit weird
22:59 seneca heh
22:59 rangi, eythian and I were working on it last night, but couldn't figure it out
22:59 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 yeah, I know
23:00 ...
23:00 jcamins Very weird.
23:00 seneca I had read that many others were running production 3.5 and figured it was mostly safe
23:00 I'm very impressed with 3.5, it's very slick
23:01 this is the only bug I've found
23:03 mtj seneca:  my head koha is currently a little busted...
23:04 just updating it now, before i look at yr bug
23:04 seneca I appreciate it
23:06 mtj i started a big deb5-> deb6+raid+xen upgrade on my dev box, last friday...
23:06 seneca how'd it go?
23:07 mtj ... and ive only just got the xens booting successfully about 30 mins ago :p
23:07 truly epic
23:07 seneca hehe
23:07 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 I'm pretty linux knowledgable
23:08 not to toot my own horn
23:09 mtj broken grub, grub2, initramfs, non mounting raids, and then non booting xens
23:09 seneca geez
23:09 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 congrats
23:13 mtj yep, and i now know a whole bunch about debugging non-booting systems, so it was an ok experience :)
23:13 seneca there you go
23:14 "If you get something right, you know something; if you get something wrong, you learn something."
23:24 mtj seneca: its works as expected on my master
23:25 seneca drat
23:25 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:28 that's what I've figured out
23:28 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 and that is beign set correctly
23:29 being
23:29 mtj hmm, its '0' for me..
23:30 seneca that should be "superlibrarian"
23:30 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:31 seneca yeah, I think it's a bitmask
23:31 ok
23:31 yeah
23:31 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 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 hi again eythian
23:32 I was mis-thinking
23:32 eythian hi
23:32 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:33 mtj well, on *my* master its catalogue
23:33 seneca weird
23:34 eythian that is weird. I would not expect that.
23:34 seneca yeah
23:34 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:35 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:36 BobB joined #koha
23:36 eythian I'd think that if you unset everything, it'd end up being 0
23:36 null probably just means never set.
23:36 hmm
23:36 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:37 mtj oops, its 4 , not  0 for catalogue :/
23:37 sorry folks
23:38 seneca ok, verified that "0" is no flags set, "NULL" is no flags ever set
23:38 hehe
23:38 no prob
23:38 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 ... 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:39 eythian so, one of those is a superlibrarian, the other is a regular user
23:39 mtj so check yr userflags table ;)
23:40 seneca yeah
23:40 "catalogue" is the 3rd bit, so a mask of 4 is correct
23:40 but it's not working for me
23:41 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:41 seneca it doesn't matter what perms I set, users who have never had staff client access can't get in
23:42 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:42 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:44 eythian > Error: You do not have permission to access this page.
23:44 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 but I'm looking...
23:45 eythian I don't think it logs those things to the error log
23:45 because they're not software errors
23:46 mtj correct eythian :)
23:46 seneca yeah, I'm not seeing anything related
23:46 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 (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:47 mind if I c/p your code from above, eythian?
23:48 eythian of course you can :)
23:48 but you'll need to adjust it to suit where you are in the code
23:49 seneca hmm...
23:49 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 <form action="/cgi-bin/koha/mainpage.pl" method="post" name="loginform" id="loginform">
23:50 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 cas or ldap auth, or restricted IP's etc
23:51 seneca well, I'm using ldap
23:51 for user auth
23:51 and it's working...
23:52 mtj hmmm, but you are experiencing some problems too? ;)
23:52 seneca well, I am
23:52 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:54 mtj sure, thats expected, i think...
23:55 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 it's always just a user/passwd
23:55 right?
23:55 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 so ldap is working...
23:56 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 and with a fresh syspref table from git
23:57 eythian it's worth a shot.
23:57 Well, I'd do one at a time
23:57 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...
23:59 mtj eythian: i'd do one at a time too ;)
23:59 seneca indeed ;)

← Previous day | Today | Next day → | Search | Index

koha1