IRC log for #koha, 2009-11-16

All times shown according to UTC.

Time S Nick Message
00:00 chris busy, too much to do
00:00 chris but otherwise ok
00:01 pianohacker well, at least you're not bored
00:01 chris :)
00:01 chris gonna duck out and grab somethign to eat, bbiab
00:31 chris why the hell is someone trying to install 2.2.8 ?????
00:34 * chris asks as much
00:35 pianohacker Not even .2.9, but 2.8
00:35 pianohacker ah well
00:35 chris yeah
00:35 chris thats the problem with having them all in download.koha.org
00:36 chris have them somewhere sure, but you should really only have the current stable ones in the main download area
00:36 chris imho
00:37 pianohacker not like we really have any _power_ over that
00:38 chris :(
00:40 pianohacker well, anyway. I'm more bitter than usual
00:40 richard someone asked me where they could grab a 2 version the other week - they had hosed their installation and wanted to replace it exactly
00:40 * pianohacker goes back to working on circ, because it makes sense!
00:40 richard couldn't convince them that it wasn't the brightest thing to do
00:42 chris at least you tried :)
00:46 mason joined #koha
02:32 chris_n2 g'evening
02:50 pianohacker hi, chris_n2
02:50 chris_n2 how's it going pianohacker?
02:51 pianohacker alright
02:51 pianohacker working on circ
02:53 pianohacker chris_n2: what are you up to ?
02:53 chris_n2 reading no-good news
02:56 pianohacker uh-oh?
02:57 chris_n2 just my general appraisal of the news in general
02:58 chris_n2 "no news is good news" works two ways you know
02:58 pianohacker ah. it's rarely uplifting, is it?
02:58 pianohacker why is my ? key trying to take over my keyboard?
03:00 chris_n2 heh
03:22 Amit joined #koha
03:23 Amit hi chris, brendan, chris_n2, richard
03:23 Amit good morning #koha
03:23 chris_n2 howdy Amit
03:23 chris_n2 hope things are well on your side of the big ball
03:23 Amit chris_n2: Everything is fine here what about u?
03:24 chris_n2 fine here too; getting ready to shut down for the night
04:18 pianohacker good night
04:18 pianohacker left #koha
04:22 chris_n2 g'night as well
04:25 greenmang0 joined #koha
04:49 richard left #koha
04:52 anasha joined #koha
05:07 brendan hi Amit
06:11 anasha left #koha
06:50 Ropuch Good morning
07:01 chris http://of2minds.net/reflections/?p=41  <-- really good writeup about the sirsi dynix FUD
07:09 anasha joined #koha
07:10 Ropuch http://www.skytopia.com/projec[…]l/mandelbulb.html
07:10 magnusenger joined #koha
07:10 Ropuch Really good pics of mandelbrot set in 3d
07:11 chris cool
07:11 chris heya magnusenger, how'd the conference go?
07:13 magnusenger hi chris! it went very well, i think! sounds like we will see some more Koha-libraries in Norway in the near future! ;-)
07:13 magnusenger nengard & nicomo did a great job!
07:29 nicomo joined #koha
07:32 chris excellent
07:34 CGI420 joined #koha
07:34 CGI420 hi I am nithin
07:34 CGI420 i need a help
07:34 CGI420 when I tried to install the perl module zoom
07:35 CGI420 i am getting error : /usr/bin/ld: cannot find -lxslt
07:35 CGI420 pls help me to sovle this problem
07:35 CGI420 cause I cant proced with my koha installtions
07:36 CGI420 pls help me any one ?
07:38 CGI420 left #koha
07:38 zico joined #koha
07:38 CGI420 joined #koha
07:39 CGI420 usr/bin/ld: cannot find -lxslt collect2: ld returned 1 exit status
07:39 CGI420 plsd help me to solve
07:39 nicomo left #koha
07:39 CGI420 perl zoom module error
07:40 CGI420 hi amith
07:40 nicomo joined #koha
07:40 CGI420 pls help me
07:40 CGI420 usr/bin/ld: cannot find -lxslt collect2: ld returned 1 exit status
07:45 chris sounds like you are missing the xslt library
07:46 chris what version of linux are you using, and how are trying to install zoom
07:46 zico hi
07:47 zico i am here with label printing drop down menu problem again! :)
07:47 CGI420 hello
07:47 CGI420 pls help me to solve this problem'
07:47 CGI420 yes
07:47 zico Piotr Wejman gave me the search.tmpl of koha 3.0.4
07:48 Ropuch Yup
07:48 zico nd... i pasted that in my  koha/intranet/htdocs/intranet​-tmpl/prog/en/modules/labels/
07:48 Ropuch It was me
07:48 zico oh Ropuch ... :)
07:48 zico thnx man
07:48 zico i can see the drop down menu now
07:48 zico but... it cannot search anything
07:48 Ropuch It was not a big deal - i just send one email  ;>
07:49 CGI420 zoom 1.25
07:49 zico i mean.. if i tries to search with date ... or barcode... it don`t bring any result
07:49 CGI420 wil sme server 7.4
07:50 Ropuch zico: you can try replace intranet/cgi-bin/labels/label-item-search.pl but I'm not sure it will work
07:51 Ropuch Upgrading to 3.0.4 seems to be the proper way ;>
07:51 CGI420 how to install xslt library
07:52 CGI420 chris pls help
07:52 Ropuch CGI420: you didn't answer the chris question: what linux version are you using and how trying to install zoom
07:52 paul_p joined #koha
07:53 Ropuch Morning, paul_p
07:53 CGI420 SME Server 7.4
07:53 paul_p hello #koha, good morning
07:53 Ropuch CGI420: sory, i 've overlooked this
07:53 CGI420 using the command make, make test, make install
07:54 CGI420 any rpm for xlst
07:54 CGI420 pls chris help me
07:57 zico Ropuch, nope! it don`t work :)
07:57 Ropuch CGI420: http://dag.wieers.com/rpm/packages/perl-XML-XSLT/
07:58 Ropuch There's some xslt-perl rpms for CentOS
07:59 CGI420 i will try
08:03 chris its not the perl one ropuch its the main xslt dev libs
08:03 chris i dont know SME Server at all
08:03 chris in debian it would be apt-get install libxslt-dev
08:04 * chris cant always answer right away as i have a family at home who demand my attention also :)
08:05 chris zico: as chris nighswonger said its been fixed for 3.0.4, you can either try to find all the patches or upgrade to that (its probably a .pm change as well)
08:06 * chris wanders off again
08:06 Kivutar joined #koha
08:27 hdl left #koha
08:27 hdl joined #koha
08:30 CGI420 left #koha
08:34 nahuel joined #koha
08:40 francharb joined #koha
08:46 kf joined #koha
08:47 kf good morning #koha
08:47 |Lupin| joined #koha
08:48 |Lupin| good day all
08:48 kf hi lupin
08:56 |Lupin| guten morgen kf :)
08:56 kf :)
08:56 francharb left #koha
08:59 |Lupin| till later, everybody, have to go now
08:59 |Lupin| bye
08:59 |Lupin| left #koha
10:13 zico left #koha
10:13 chris_n left #koha
10:13 paul_p @seen gmcharlt
10:13 munin paul_p: gmcharlt was last seen in #koha 5 days, 17 hours, 37 minutes, and 43 seconds ago: <gmcharlt> Nate: GPL v2 or later
10:14 chris_n joined #koha
12:08 nicomo left #koha
12:30 Amit left #koha
12:35 jwagner joined #koha
12:44 jwagner paul_p, online?
12:44 paul_p yep. 'morning jwagner
12:44 jwagner Bonjour.
12:45 jwagner Question for you -- does the new acquisitions code obey Independent Branches?  If that's on, can libraries see each others' funds/orders?
12:49 heupink joined #koha
12:51 jdavidb joined #koha
12:54 paul_p jwagner: for funds, I think so. For orders, not sure, but I don't think so (or, if it works, it's by mistake). This part should probably be improved
12:55 heupink Hi all. I'm installing koha on debian, and noticed something in the docs that I think is wrong:
12:55 jwagner OK, thanks -- that's promising news
12:55 jwagner paul_p, sorry, they can still see each others' funds?
12:56 heupink it says: "ln -s /etc/koha/koha-httpd.conf /etc/apache2/sites-available/koha"
12:56 heupink shouldn't this be "ln -s /etc/koha/koha-httpd.conf /etc/apache2/sites-available/koha.CONF"?
12:56 jdavidb Could be, heupink, but it doesn't have to be.
12:56 paul_p yes but no : when you create a fund, you can limit it to a branch or not. If you don't limit, then anyone can see it. If you limit, then it's only for your library.
12:57 jwagner paul_p, thanks!  That's what I needed to know.
12:57 jdavidb The second parameter can be whatever you want, as long as it's in sites-available.  That, of course, is what your'e going to feed to a2ensite.
12:57 heupink because from apache configuration, it tries to load all .conf files, not just ALL files under /sitesenabled
12:57 heupink but it should end on .conf, otherwise apache doesn't try to load it, right..?
12:57 jdavidb If you named it koha.conf, you'd need to do a2ensite koha.conf
12:58 jdavidb It loads everything under /etc/apache2/conf.   It specificially does *not* load everything under /etc/apache2/sites-available.
12:58 jdavidb a2ensite creates a link from the sites-available to the sites-enabled, and that one, also, loads *all* files, not just .conf.
12:59 heupink hmm. it didn't seem to work when i tried it, and it did work when using koha.conf. Strange.
12:59 heupink Ok then, I'll take a look at it again then.
12:59 jdavidb If it works for you, roll with it.  I've done it nearly sixty times now, as documented, on both etch and lenny.
13:00 heupink (I come from suse, where things are a bit different)
13:00 heupink ok, thanks!
13:00 jdavidb Glad I could help.
13:01 greenmang0 left #koha
13:22 nicomo joined #koha
13:30 chris_n2 left #koha
13:39 gmcharlt joined #koha
13:39 chris_n wb gmcharlt
13:39 chris_n g'morning #koha
13:41 owen joined #koha
13:41 gmcharlt good morning all
13:43 owen Hi gmcharlt, #koha
13:43 CGI097 joined #koha
13:43 CGI097 is now known as Eric_
13:43 Eric_ is now known as Eric_T
13:45 chris_n gmcharlt: I have koha running fine now on win32 (2+ years later)
13:45 Eric_T Bonjour / Hello
13:45 chris_n hi Eric_T
13:47 Eric_T I'm looking for help regarding zebra indexation
13:49 chris_n Eric_T: feel free to ask your question, someone here may have the answer :-)
13:49 Eric_T I installed Koha 3.0.4 and imported 1000 "notices"
13:50 paul_p Eric_T: are u french ? (notice is the french term)
13:50 paul_p ( in english, it's biblio ;-) )
13:50 Eric_T I think now i have to build the zebra index (Oui français Paul)
13:51 paul_p Eric_T: misc/migration_tools/rebuild_zebra
13:51 gmcharlt chris_n++
13:51 paul_p Eric_T: we have a french channel on freenode #koha-fr. He's very quiet, but just FYI.
13:51 Eric_T Donc en français, je patauge un peu au niveau de zebra. La recherche ne fonctionne pas. Si j'ai bien compris je dois contruire l'index avec un rebuild_zebra.pl
13:52 chris_n gmcharlt: with the January 2010 Strawberry release, Koha on win32 should be nearly as straight forward as on *nix
13:52 Eric_T Ok but I can't connect on 6667 port... didn' find any web interface for irc.freenod
13:53 paul_p Eric_T: :(((( welcome here, anyway. For tech questions, you'll get more answers !
13:53 paul_p Eric_T: yes, you must rebuild_zebra
13:53 paul_p (which requires PERL5LIB and KOHA_CONF to be defined on your shell)
13:54 chris_n gmcharlt: I did find an issue when "round tripping" marc records from one Koha to another
13:54 hdl hi gmcharlt
13:54 gmcharlt hi hdl
13:54 chris_n gmcharlt: when importing records exported from a Koha installation, the isbn and issn fields are too long, especially when the bib has multiple items attached
13:55 gmcharlt chris_n: too long?  in what way/
13:55 chris_n I ended up having to make those fields in the biblioitems table mediumtext types and remove the indexes
13:56 chris_n gmcharlt: the 020 fields are concatenated and then inserted into the isbn field of biblioitems
13:56 chris_n the isbn field is varchar(30) currently
13:56 Eric_T So when I try to rebuild the (many) errors are [warn] Index 'tpubdate' not found in attset(s) , 'Modified-code' not found in attset(s), etc etc...
13:57 chris_n gmcharlt: a bib with 13 items fails to insert
13:57 gmcharlt odd - mysql auto-truncates if you try to insert a string that's too long into a varchar
13:58 chris_n gmcharlt: I thought so, but very clearly these items failed to insert with DBD throwing an error
13:58 hdl Eric_T: those are warnings only
13:59 chris_n I suppose there might be another plausible explanation, but I have not spent a lot of time on it
14:00 chris_n I plan on doing the installation again from scratch and will spend more time debugging it then
14:00 Eric_T Ok I forget to export KOHA_CONF, now warnings are different. So I pregress... thanks !
14:00 gmcharlt chris_n: I wouldn't be surprised if the behavior is controlled by a setting, possibly in DBD::mysql, which just happens to have a different default value
14:00 gmcharlt in Strawberry
14:00 chris_n ahh.... hadn't thought of that, but it very well could be
14:01 heupink Hi, I'm trying to authenticate with ldap, by using the bind as user option ( <auth_by_bind>1</auth_by_bind>)
14:01 chris_n DBD::mysql is a core module with Strawberry so differences could be there
14:02 heupink But I don't understand where tell koha in what form the bind should be (like: uid=from_login,ou=YY,dc=YY)
14:03 heupink Koha takes userid from the user of course, but the rest to perform the bind with.
14:04 heupink Hope someone here has an idea..?
14:12 chris_n heupink: you might want to post the the list as there are some there who have worked with the koha ldap stuff
14:13 heupink i just thought I'd ask here first. :-)
14:13 heupink thanks.
14:20 jwagner I have a new holds-related bug, but I'm not quite sure how best to fix it.  Any ideas?  See Bug 3785.
14:21 jwagner Where'd munin go?  Anyway, see http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=3785
14:22 gmcharlt @bug 3785
14:22 munin gmcharlt: Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=3785 normal, P3, ---, gmcharlt@gmail.com, NEW, New Install, no maxreserves setting, OPAC holds fail
14:22 heupink left #koha
14:25 collum joined #koha
14:26 heupink joined #koha
14:33 rhcl joined #koha
14:36 Nate joined #koha
14:41 moodaepo joined #koha
15:10 Ropuch Hm, I added &order=biblio.title to basket showing url: it throwed 'ERROR: Illegal sort requested by "biblio.title".', but the items got sorted according to title anyway
15:30 heupink @chris_n: I found out why it didnt work, and I'm writing a wiki page now.
15:30 munin heupink: Error: "chris_n:" is not a valid command.
15:31 chris_n heupink: cool
15:31 chris_n wiki_pages++
15:31 chris_n heupink++ # for taking time to write one
15:31 heupink I already wrote the ldap wiki page for 2.x series, and am now adding stuff for 3.x series,
15:31 heupink .
15:42 wizzyrea gmcharlt: question, is the holds targeting immediate? example: staff catalogs an item, accidentally gives it a non restricted hold itype, clicks save. Staff member then realizes that the item should have a restricted (local hold, for example) itype and changes it. Is it too late? Has that item already become a target of the holds picking system?
15:43 gmcharlt wizzyrea: no, it shouldn't be that fast
15:43 gmcharlt as there is an intermediate cronjob
15:43 owen gmcharlt: the holdsqueue job?
15:43 gmcharlt yes
15:44 wizzyrea that is a different script than the one that generates the pick list, or no?
15:44 gmcharlt same one
15:44 gmcharlt at least, it generates the 'holds queue' version of the pick list
15:45 wizzyrea right, we call the holds queue the pick list (sirsi holdover. Sigh.)
15:45 wizzyrea ok, thanks
15:45 wizzyrea :)
15:57 wizzyrea gmcharlt: one more question
15:58 wizzyrea if the mistakenly assigned item is scanned (checked in) is the hold assigned?
15:58 wizzyrea (with it's erroneous itype)
16:00 gmcharlt yes, at that point it could be captured
16:05 wizzyrea okies, ty
16:05 wizzyrea that was my impression, I just wanted to make sure
16:13 owen @wunder 66044
16:13 munin owen: The current temperature in Channel 6 Downtown, Lawrence, Kansas is 2.9�C (10:12 AM CST on November 16, 2009). Conditions: Overcast. Humidity: 91%. Dew Point: 2.0�C. Windchill: 3.0�C. Pressure: 30.06 in 1017.8 hPa (Rising). Winter Weather Advisory in effect until 6 am CST Tuesday...
16:13 owen Ouch!
16:14 owen @wunder 45764
16:14 munin owen: An error has occurred and has been logged. Please contact this bot's administrator for more information.
16:14 owen @wunder 45701
16:14 munin owen: The current temperature in Athens, Ohio is 13.0�C (10:55 AM EST on November 16, 2009). Conditions: Clear. Humidity: 67%. Dew Point: 7.0�C. Pressure: 30.09 in 1019 hPa (Steady).
16:14 Eric_T left #koha
16:15 kf @wunder konstanz
16:15 munin kf: The current temperature in Konstanz, Germany is 12.0�C (5:00 PM CET on November 16, 2009). Conditions: Mostly Cloudy. Humidity: 87%. Dew Point: 10.0�C. Pressure: 29.93 in 1013 hPa (Rising).
16:17 magnusenger @wunder bodo, norway
16:17 munin magnusenger: The current temperature in Bodo, Norway is 8.0�C (4:50 PM CET on November 16, 2009). Conditions: Mostly Cloudy. Humidity: 62%. Dew Point: 1.0�C. Windchill: 4.0�C. Pressure: 29.74 in 1007 hPa (Steady).
16:18 paul_p @wunder Marseille, France
16:18 munin paul_p: The current temperature in Marseille, France is 18.0�C (5:00 PM CET on November 16, 2009). Conditions: Scattered Clouds. Humidity: 77%. Dew Point: 14.0�C. Pressure: 29.95 in 1014 hPa (Steady).
16:18 paul_p hehe... I win :D (18°C )
16:18 jdavidb @wunder Bethesda, md
16:18 munin jdavidb: The current temperature in WRC-Tenlytown, Washington, District of Columbia is 18.3�C (10:30 AM EST on November 16, 2009). Conditions: Scattered Clouds. Humidity: 74%. Dew Point: 14.0�C. Pressure: 30.18 in 1021.9 hPa (Falling).
16:19 jdavidb 18.3.  :P
16:19 owen No offense jdavidb, Marseille still wins ;)
16:19 * jdavidb pouts a little.
16:19 paul_p jdavidb: lol
16:20 magnusenger heh, i'm not the coldest!
16:20 nicomo @wunder Lyon, France
16:20 munin nicomo: The current temperature in Lyon, France is 18.0�C (5:00 PM CET on November 16, 2009). Conditions: Clear. Humidity: 59%. Dew Point: 10.0�C. Pressure: 29.89 in 1012 hPa (Steady).
16:20 magnusenger @wunder bergen, norway
16:20 munin magnusenger: The current temperature in Olsvik, Bergen, Norway is 8.3�C (5:19 PM CET on November 16, 2009). Conditions: Clear. Humidity: 51%. Dew Point: -1.0�C. Windchill: 7.0�C. Pressure: 29.59 in 1001.9 hPa (Steady).
16:20 nicomo not bad
16:21 magnusenger :-)
16:21 magnusenger [Bergen | Bodø] + 10 = Lyon :-)
16:22 zico joined #koha
16:22 zico hi
16:22 jdavidb Hm...Tenleytown is kinda the high ground in northwest DC.  Wonder what it's like down in Foggy Bottom?
16:23 zico i hv just installed koha-3.0.4.. but when i go for http://127.0.1.1:8080/  ... it shows me the error "production mode - trapped fatal error"
16:23 wizzyrea yea, the weather here is frightful
16:23 wizzyrea and I have no fire to make it delightful
16:24 * wizzyrea goes off to look for a youtube vid of a fireplace
16:24 zico is there anyone who can help me with "production mode - trapped fatal error" ??
16:25 owen zico: You'll have to look in your error logs for more information
16:25 wizzyrea zico: I'm pretty sure there has been discussion of that on the list, lemme get the link
16:25 wizzyrea error logs are a good suggestion as well
16:27 zico nahuel: owen
16:28 kf time to leave - bye #koha :)
16:28 kf left #koha
16:28 nahuel zico, ?
16:28 zico owen: the log shows me this: "[Tue Nov 17 04:24:24 2009] [error] [client 127.0.1.1] File does not exist: /usr/share/koha/intranet/htdocs/favicon.ico [Tue Nov 17 04:24:27 2009] [error] [client 127.0.1.1] File does not exist: /usr/share/koha/intranet/htdocs/favicon.ico"
16:28 zico :(
16:28 nahuel don't take care about this
16:28 zico nahuel: sorry man!
16:28 wizzyrea http://old.nabble.com/forum/Se[…]+error+production
16:28 wizzyrea is that the apache log or the koha log?
16:30 zico wizzyrea: that`s koha log
16:32 * chris_n hands wizzyrea his soap-stone wood stove
16:32 chris_n just don't drop it on your foot ;-)
16:33 wizzyrea I'll try not to :)
16:33 wizzyrea chris_n thanks, that's very warm
16:35 chris_n lol
16:37 Kivutar left #koha
16:44 chris_n lunch, bbiab
16:50 zico left #koha
17:00 owen is now known as owen-away
17:08 anasha left #koha
17:20 brendan left #koha
17:28 heupink Hi again! To set a fixed category code for all new users, should "<categorycode is="ALL"></categorycode>" in koha-xml.conf (with ldap) work..?
17:28 heupink (to set the code to "ALL"
17:31 heupink Because I'm getting this error: "Cannot add or update a child row: a foreign key constraint fails (`koha3/borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) at /usr/share/koha/lib/C4/Members.pm line 730"
17:32 heupink But category code ALL is defined in the database.
17:47 brendan joined #koha
17:55 brendan morning All
17:58 wizzyrea omg you should see the snow here
17:58 wizzyrea it's beautiful
17:58 wizzyrea huge flakes
17:58 brendan @wunder 93117
17:58 munin brendan: The current temperature in Northwest Goleta, Goleta, California is 15.2�C (9:55 AM PST on November 16, 2009). Conditions: Clear. Humidity: 52%. Dew Point: 6.0�C. Pressure: 30.17 in 1021.6 hPa (Rising).
18:00 owen-away is now known as owen
18:03 brendan Sorry wizzyrea -- I don't see any snow outside
18:03 wizzyrea dude, you're in california
18:03 wizzyrea ;)
18:03 brendan :)
18:03 * jdavidb isn't in California, and doesn't see snow, either.
18:04 wizzyrea brendan, I just sent you a friend request so you can see my huge flakes :P
18:05 brendan huge flakes - heh ;)
18:06 jdavidb Imma tell your bosses you talk about 'em like that, wizzyrea.
18:06 wizzyrea LOL
18:07 wizzyrea if they were in the pic then we might have grounds for that
18:07 magnusenger left #koha
18:09 joetho joined #koha
18:23 owen left #koha
18:40 juan-xercode joined #koha
18:43 juan-xercode left #koha
18:52 chris @wunder wellington, nz
18:52 munin chris: The current temperature in Wellington, New Zealand is 12.0�C (7:00 AM NZDT on November 17, 2009). Conditions: Clear. Humidity: 47%. Dew Point: 1.0�C. Pressure: 29.62 in 1003 hPa (Rising).
18:52 chris gonna be a nice day
18:53 brendan morning chris
18:55 jwagner Can anyone think of a reason why sites would want ISBD view hidden in staff mode but available in OPAC?  XSLT doesn't obey the viewISBD syspref, which is in the Staff group of sysprefs, but I don't see any reason to create an OPAC syspref.
18:56 chris i can think of no reason
18:57 chris but now its time to catch my bus
19:01 rhcl @seen nengard
19:01 munin rhcl: nengard was last seen in #koha 1 week, 3 days, 2 hours, 20 minutes, and 51 seconds ago: <nengard> I'm working with melanie on the problem i mentioned above
19:02 brendan nengard is in Italy at the moment
19:02 owen joined #koha
19:03 rhcl Italy? Oh, OK
19:03 brendan rhcl nengard should be back next week
19:03 rhcl Who might be the POC for the installation directions for debian lenny?
19:04 jdavidb rhcl:  I've done it a bunch, would be glad to help.
19:04 rhcl I think there are a couple of things that need clarification...
19:04 jdavidb Probably more than a couple.
19:05 rhcl for example, when configuring zebra there is the line "Option 2: run the Zebra processes as daemons, and add to startup process:".
19:05 rhcl What is specifically ment by "startup process". I think that should be defined better.
19:05 jdavidb yup.  "running zebra" is one of the sections that needs some love, IMO."
19:06 rhcl Needs to be shot and replaced with a giraffe.
19:06 brendan rhcl -- what does "startup process" mean to you?
19:06 rhcl Is there anything I can do to assist with the docs here?
19:06 jdavidb The little section of code starting at line 210 "Zebra Server" tells how to, and that's what we do exclusively, here.
19:07 brendan those doc's are part of git tree
19:07 brendan so you could make some changes and submit a patch for that
19:08 jdavidb I'm with Brendan.  If you find something that needs better wording, just do it.  Submit it as a patch, and get ++ a lot.
19:08 rhcl OK, but when we did "Option 2", following the directions pretty exactly, nothing actually started the zebra process. We had to go back to Option 1 to start the daemon, which then worked fine.
19:09 jdavidb That's why that section needs some love...structurally, it has some issues.
19:09 jdavidb just so you know, I'm working on a big rewrite of INSTALL.debian-lenny for the Squeeze release.
19:09 brendan line 223 tells you to start the server
19:09 rhcl The other thing is that in the instructions it mentions "${SCRIPT_DIR}, but never tells how to actually set it.
19:10 rhcl OK, that sounds good. How can I feed you my input, and/or otherwise assist?
19:10 brendan hmm....  line 207 -- explains {SCRIPT_DIR}
19:10 brendan http://git.koha.org/cgi-bin/gi[…]4c190b52b;hb=HEAD
19:10 rhcl OK, I can't see the line numbers and just have a printout at this computer.
19:11 brendan ok -- try that link I just pasted
19:11 rhcl Yea, that looks good, we were just using the install directions that came with the distro 3.0.4_fixed (or whatever)
19:12 brendan ah ok...  I usually just use the git.koha.org versions
19:12 brendan also nice to browse code if you wanted to
19:12 rhcl and I see the file at that link has feedback instructions :)
19:13 brendan :)
19:22 heupink left #koha
19:23 Austin``1 joined #koha
19:24 Austin``1 left #koha
19:37 brendan @wunder 93117
19:37 munin brendan: The current temperature in Northwest Goleta, Goleta, California is 17.4�C (11:35 AM PST on November 16, 2009). Conditions: Clear. Humidity: 44%. Dew Point: 5.0�C. Pressure: 30.14 in 1020.5 hPa (Falling).
19:40 wizzyrea @wunder 66047
19:40 munin wizzyrea: The current temperature in Lawrence Live-Courtesy of the Khoury's, Lawrence, Kansas is 1.6�C (1:38 PM CST on November 16, 2009). Conditions: Light Rain. Humidity: 87%. Dew Point: -0.0�C. Windchill: 2.0�C. Pressure: 29.94 in 1013.8 hPa (Rising). Winter Weather Advisory in effect until 6 am CST Tuesday...
19:40 wizzyrea I win. :)
19:40 brendan is this golf?
19:40 brendan if not -- then I think I win
19:40 wizzyrea oh, this is the misery index
19:40 wizzyrea it's more like golf
19:40 wizzyrea >.> at least in weather terms
19:40 brendan ok -- you win by a wide margin :)
19:44 wizzyrea can anyone tell me, 3M self-check machines can use a PIN, is that equiv. to the OPAC password?
19:44 * wizzyrea resists the urge to hunt down atz
19:45 chris id fire him an email wizzyrea
19:46 chris he'll be able to answer fast
19:46 chris the rest of us would need to go read the code
19:46 wizzyrea yea, that's what I was thinking
19:46 jwagner owen and others, I've had a request from a couple of my sites to highlight the shelving location in the staff & OPAC display.  Right now it just immediately follows the library branch name, and if you have a wordy name the shelving location gets lost.  I'm applying one of the existing span classes to it ("term" which makes it yellow highlighted).  Would that be of general use?
19:46 wizzyrea k I will do that.
19:47 owen jwagner: It should have its own span. "term" is very specific.
19:47 richard joined #koha
19:47 richard hi
19:48 chris hiya richard
19:48 richard hey chris
19:48 brendan morning richard
19:48 jwagner owen, I was kind of hoping to avoid creating a new span, and "term" looked more usable than, say, "lost" -- any suggestions which other class might be better?
19:49 owen Honestly, I wouldn't suggest anything but a new class name.
19:50 * jwagner whimpers
19:50 * jdavidb suggests chocolate for jwagner
19:50 jwagner OK, if this is something that would be of general use, I'll try to figure it out.  If not, I'll stick to this for my site :-)
19:51 jwagner (jdavidb, caramels work too....)
19:51 owen I'd say it is potentially of general use
19:52 owen I don't know how other libraries use shelving location--we don't use it at all
19:52 * owen is waiting for a transfers-like interface for setting shelving location
19:53 jwagner They also asked for the shelving location to go on a separate line.  There are a few cases where I think putting a <BR> in the template code might cause problems.  We have a single library site (single branch mode on, so it doesn't display library name) which doesn't use shelving locations.  I'll have to look at that a bit more.
19:53 chris owen: like the bulk item edits interface?
19:53 owen jwagner: Then what you need is to add "display:block" to the <span>'s CSS
19:53 chris owen: http://librarian.koha.catalyst[…]tools/batchMod.pl
19:54 jdavidb <  TMPL_IF shelving_location is present> <BR><span foo><TMPL_VAR> </span> </TMPL_IF>  ?
19:55 owen jdavidb: No, it should go in the CSS
19:57 owen <span class="shelvingloc"><TMPL_VAR></span> ; .shelvingdoc { display: block }
19:57 jdavidb Why choose one over the other, owen?
19:57 jwagner I've set up a span in the css, copying the term one, then called it in the tmpl.  Not sure I've got it right yet, but...
19:57 owen jdavidb: Adding the <BR> to the HTML means that it is forced onto a new line for any and all users. Doing it in the CSS means that libraries can choose.
19:58 jdavidb Ah, by merely monkeying with the CSS.  I see.
19:59 owen chris: I was picturing an interface just like transfers, only instead of setting a branch you set a shelving location.
20:00 chris i think since we have a way to do bulk modifications on items, probably can just do that for shelving locations too
20:02 * jdavidb gets out his Dark Arts of CSS book.  Probably oughta read it some mroe.
20:02 brendan mroe sounds so morose
20:03 jdavidb If there wasn't already a "less" command, I'd lobby for that function to be done by mroe.
20:06 hdl jwagner: chris about ISBD for OPAC and intranet : There is the problem of links between intranet and opac which are different owed to the fact that authorities/detail.pl and catalogue/detail.pl refers to different scripts and opac has only one directory
20:14 jwagner hdl, does that mean the XSLT shouldn't use the staff viewISBD syspref?
20:20 chris anyone know of any libraries who are using the Koha Opac as a discovery layer, while using their old LMS in the background?
20:21 hdl chris yes.
20:22 chris cool, do you have any details?
20:22 Nate left #koha
20:22 hdl mmm you had better ask paul for details.
20:22 Nate joined #koha
20:22 chris in part of my RFI response, they talk about discovery layer, im saying Koha doesnt need one, in fact other libraries have used Koha as discovery layer for their old LMS
20:22 chris i wonder if he is still awake
20:22 * chris is racing a deadline
20:23 * chris emails
20:23 hdl he sure is awake, but should not be near his computer atm
20:23 chris yeah
20:23 chris ill email
20:26 rhcl Right now we have to login to our koha server and start zebrasrv, using >/usr/bin/zebrasrv -f /etc/koha/koha0conf.xml, each time manually (after a reboot). How should this be started automatically without a usr login?
20:26 chris yes
20:26 chris are you running debian rhcl ?
20:27 rhcl yes, lenny and 3.0.4_fixed
20:27 chris ok look at the INSTALL.debian-lenny
20:28 brendan http://git.koha.org/cgi-bin/gi[…]4c190b52b;hb=HEAD
20:28 rhcl Yea, I've got the directions here, and have been over them 1000 times, and nothing addresses this that I see.
20:28 chris yes it does :)
20:28 jwagner owen, I got the css stuff figured out, I think.  How about a nice tasteful green for the shelving location? Blue is kind of overworked, and red is better suited to "pay attention!" things like Lost.
20:28 pastebot "chris" at 192.168.15.101 pasted "setting up start up processes" (12 lines) at http://paste.workbuffer.org/59
20:29 owen jwagner: Maybe we should leave the color alone and leave that up to each location?
20:29 rhcl The install directions specifically show this as part of the "Option 1, command line", which is exactly how we are starting it. Even with setting up Option 2, and double checking, we have to login and run zebrasrv by hand.
20:30 chris im pasting directly from the file
20:30 jwagner owen, I need to set a color for my sites.  I can submit the patch with or without a color, I guess.
20:30 pastebot "chris" at 192.168.15.101 pasted "Option 1: run the Zebra proces" (29 lines) at http://paste.workbuffer.org/60
20:30 owen jwagner: Then you can use OpacUserCSS to give them their color
20:32 chris rhcl: if you did all of option 2, and its not starting, then you might not have the daemon package installed, or you koha-zebra-ctl.sh script isnt configured right
20:36 brendan rhcl, you could check to see what is listed for a username and group in koha-zebra-ctl.sh
20:37 |Lupin| joined #koha
20:38 |Lupin| hi there
20:40 jdavidb left #koha
20:40 brendan bbiab
20:47 hdl hi |logbot_backup
20:47 hdl hi |Lupin|
20:51 jwagner left #koha
20:51 |Lupin| hey hdl :)
20:52 |Lupin| wow irssi is clever: lu<tab> completes correctly
21:13 |Lupin| anybody knowshow to do a universal or existential quantification in mysql pls ?
21:13 |Lupin| expressing something like "there exists at least one row in the table such that ..." in a where clause ?
21:17 Ropuch select * from table where exist (select blabla)
21:18 Ropuch http://dev.mysql.com/doc/refma[…]s-subqueries.html
21:18 Ropuch |Lupin|: is taht what you need?
21:19 |Lupin| Ropuch: I'll check but it looks like that, yes ! thanks !
21:19 Ropuch Np, googling things out is my my job ;>
21:20 |Lupin| Ropuch: are you familiar enough with mysql to tell how one could regularly lookup a table and update another one ? is that doable inpure mysql ?
21:20 |Lupin| Ropuch: I tried but was not very successfull... tried googling I mean
21:20 Ropuch I can handle signle querry only in sql
21:20 Ropuch But
21:22 Ropuch If you tell me what you are trying to do, I can ask some ppl [;
21:22 collum left #koha
21:22 |Lupin| Ropuch: I am trying to create some kind of dynamic virtual shelves for my librarian
21:23 |Lupin| Ropuch: doing it in Perl is an easy and acceptable fallback
21:23 |Lupin| Ropuch: I was just wondering how far I could go in pure SQL
21:26 Ropuch Describe what you the sql to do
21:28 |Lupin| Ropuch: basically find out all the biblonumbers who have an item with a certain ccode and no item with another ccode
21:31 Ropuch I think it's doable
21:31 Ropuch Well, I'm sure it is
21:32 |Lupin| Ropuch: so am I, thanks for helping
21:32 nicomo left #koha
21:34 Ropuch ;>
21:35 pianohacker joined #koha
21:35 pianohacker Good afternoon
21:37 hdl |Lupin|: you could update a given virtualshelves content with : DELETE FROM virtualshelvescontent where shelfnumber=...
21:38 wizzyrea ph, hello
21:39 |Lupin| hdl: yeah delete and then insert select the required things...
21:39 hdl |Lupin|: INSERT INTO virtualshelfcontents (shelfnumber, biblionumber) SELECT theshelfnumberyouneed,biblionumber from biblio
21:39 |Lupin| hdl: the question ismore: is there a way in the db to have actions performed regularly, like a cron job but inside the db ?
21:40 pianohacker hi wizzy
21:40 hdl |Lupin|: i would use a shell cronjob for that.
21:40 |Lupin| hdl: anyway, thanks for havign shown, it confirms what I wanted to do can work
21:40 hdl But you could look at http://dev.mysql.com/doc/refma[…]/en/triggers.html
21:41 |Lupin| hdl: you mean a script that would pass the whole query to mysql ? yeah, why not !
21:43 |Lupin| hdl: yeah triggers are even nicr cause it's completely dynamic and ran exactl when it's needed, so that's cool! and I didn't know them so curlutally speaking it's great... so, thanks a lot !!
21:44 hdl ties you with mysql... But well...
21:45 chris postgres has triggers
21:45 |Lupin| hdl: well that's a temporary thing, so that's fine, and the benefit of having a real-time update of the shelf content is worth the price in the situation I think
21:49 hdl chris is the syntax between mysql and postgresql the same ?
21:51 chris not sure, ive never tried triggers in mysql
21:58 |Lupin| OLD and NEW are MySQL extensions to triggers.
21:58 |Lupin| so that's one thing to avoid for portability
22:03 Nate left #koha
22:04 wizzyrea question: is there a max length for the OPAC password?
22:04 wizzyrea erm... 1s I may be able to help myself on that one
22:06 |Lupin| wizzyrea: desc borrowers should tell you
22:06 |Lupin| wizzyrea: (it's a mysql statement)
22:07 pianohacker |Lupin|: not in this case, since it's hashed
22:07 pianohacker There shouldn't actually be a max that you're likely to hit
22:09 wizzyrea `password` varchar(30) default NULL,
22:09 wizzyrea wouldn't that mean 30?
22:09 owen But that's the md5'ed length, isn't it?
22:09 pianohacker wizzyrea: no; the password is hashed using MD5, and the hash is always the same length
22:09 wizzyrea Ahhhhh
22:10 wizzyrea makes sense
22:10 wizzyrea well it's a good thing I asked, thanks ph
22:10 Nate joined #koha
22:10 pianohacker tho we _really_ ought to be moving towards using sha-256, given the known collision attacks against MD5
22:10 pianohacker </geekery>
22:10 pianohacker wizzyrea: np
22:10 |Lupin| oops
22:10 |Lupin| sorry wizzyrea to have been confusing
22:11 owen wizzyrea: Are you going to run right out and try to overload the password length?
22:11 wizzyrea well, I can do my best I suppose ;)
22:11 wizzyrea one of my libraries asked
22:11 pianohacker hehe, a particularly long passphrase might come close
22:11 wizzyrea define "particularly long"
22:11 wizzyrea like, pi to the 10000th digit?
22:12 pianohacker ooh
22:12 pianohacker finally, an actual practical use for memorizing pi
22:12 wizzyrea lulz
22:12 brendan more like a prime number with 10 million digits
22:12 brendan chris_n is into that kind of stuff
22:12 pianohacker brendan: though that falls into the category of an unintentional DOS
22:13 wizzyrea I always like it when a question I ask incites geekery well beyond the original question
22:13 brendan heh
22:13 brendan yeah I'd say there are some geeks in this channel
22:13 pianohacker just a few
22:14 * owen looks accusingly at everyone else
22:14 pianohacker bah, go collision attack the front of a moving car
22:15 wizzyrea LOL someone quote add that
22:15 wizzyrea my quote add capability is somehow broken
22:15 brendan @quote add pianohacker bah, go collision attack the front of a moving car
22:15 munin brendan: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command).
22:15 wizzyrea @quote get 23
22:15 munin wizzyrea: Quote #23: "<gmcharlt> /msg munin register nick password" (added by wizzyrea_ at 12:25 PM, August 06, 2009)
22:15 wizzyrea :)
22:17 brendan @quote add pianohacker bah, go collision attack the front of a moving car
22:17 munin brendan: The operation succeeded.  Quote #47 added.
22:17 wizzyrea gerg, I keep getting pulled off of my task by koha questions. Not that I mind particularly, but it does make getting things done rather difficult :/
22:18 * pianohacker hopes owen didn't take his rather droll joke literally
22:18 joetho @wunder fort scott, ks
22:18 munin joetho: The current temperature in DEAN\'S WEATHER STATION, PRESCOTT, Kansas is 4.7�C (3:43 PM CST on November 16, 2009). Conditions: Light Rain. Humidity: 97%. Dew Point: 4.0�C. Windchill: 2.0�C. Pressure: 29.95 in 1014.1 hPa (Rising).
22:18 wizzyrea that's like, geek speak for "go play in traffic"
22:18 wizzyrea ;)
22:19 owen Sorry pianohacker, I'm working the circ desk. Can't run out into traffic for another 45 min or so.
22:19 pianohacker Hehe
22:19 * wizzyrea will go kill owen herself if he goes to play in traffic and gets hurt.
22:19 wizzyrea who will design the koha interface?
22:19 pianohacker We need your css, owen!
22:19 owen I hear folks are getting very good results from monkeys these days.
22:20 wizzyrea doh
22:20 wizzyrea not exactly the answer I was looking for
22:21 * owen tries to think of a good interface disaster to blame on monkeys
22:21 wizzyrea well there's the edit items table...
22:21 wizzyrea ok, this is seriously a beef of mine
22:22 wizzyrea why put the fields that are not the most often used at the left of the table?
22:22 wizzyrea and the barcode (used all the time) on the right?
22:22 owen In fact I was thinking of doing a blog post on interface peeves
22:22 owen In fact I think the table isn't designed at all, I think it's just dumped.
22:22 wizzyrea ooh, I'm sure we can come up with some for you
22:22 wizzyrea 1. alphabetization!
22:23 wizzyrea 2. logged in branch should always get preference
22:23 wizzyrea (in drop downs, both)
22:24 wizzyrea 3. the edit items table should be optimized for usefulness, with commonly used columns like barcode and home/holding branch not on the part you can't see and have to scroll for.
22:24 owen Yeah, edit items table is in subfield order.
22:24 pianohacker There's a lot of tiny, in-many-places interface tweaks that our retarded templating system makes very difficult
22:25 pianohacker yup, that's entirely based on the MARC framework
22:25 owen pianohacker: what kind of improvements would we get from an alternate templating system?
22:25 pianohacker owen: mainly the option to do _some_ post-processing of the data
22:26 pianohacker nothing too insane, but it would remove the need for the .pl to handle little things like logged-in branch first
22:28 owen I wonder if we could add an option to frameworks to control display of subfields in the add item interface?
22:28 owen (...bringing up another interface disaster...)
22:28 wizzyrea owen++ that would roxxor my soxxors
22:29 pianohacker owen: A cute little Reorder button that brought up a drag-and-drop display?
22:29 owen Not that I'm smart enough to make it happen...
22:29 |Lupin| hmm
22:29 |Lupin| when one follows the instructions given in the INSTALL files
22:29 |Lupin| shouldn't the koha user have all the priviledges over the koha db ?
22:31 wizzyrea ph: i like that. See the WP widget interface
22:31 wizzyrea dk if you're familiar
22:31 wizzyrea (though I think we've talked about that before_
22:31 |Lupin| I just tried to add a trigger and mysql said the SUPER privilege is required to do that...
22:32 chris yes that would be right, because you dont want an ordinary user able to do, would be an easy way to get hacked
22:32 owen Even if we didn't get as far as enabling reordering, perhaps we could add functionality to the "hidden" constraint in the subfield editor
22:32 pianohacker wizzyrea: I think I have seen that
22:32 pianohacker owen: I've wanted to redo hidden for a long time
22:32 pianohacker dropdown at least, preferably checkboxes
22:33 owen ..although the "hidden" field is for all tags, and this would only be relevant to 952 (or whatever it is in UNIMARC)
22:33 |Lupin| owen: 995
22:34 chris yeah can we kill those numbers
22:35 chris with the hidden thing
22:35 chris what are we indexdata
22:35 owen Not sure if it's too impractical (or messy) to add functionality that works for only one tag's subfields.
22:36 pianohacker chris: the far worse part is that the hidden field is allllmost a bitmask, but not quite
22:36 chris everytime i read 1 => !OPAC Intranet Editor Collapsed
22:36 chris i want to kill someone
22:37 pianohacker That's the only help page I've ever needed to refer to more than once
22:37 chris exactly
22:37 pianohacker I think I'd send an updatedatabase and tweaks to make it an actual bitmask, then fix the interface
22:37 chris that works
22:38 * pianohacker adds it to Koha to-do list, notes that at this rate it'll get done sometime in 2012
22:38 chris heh
22:38 chris i hear that
22:38 owen Just in time for the **AAAHH** <crushed by a falling national monument>
22:39 wizzyrea lol owen
22:39 wizzyrea yay, 400k download speed here. Jebus, what happened to our ISP. Criminy
22:40 pianohacker owen: They sure don't make statues of liberty like they used to
22:40 owen wizzyrea: They're busy torrenting the new Dr. Who special.
22:40 chris did you see that totally screwed up the dates for that?
22:40 chris misread the mayan calendar
22:40 wizzyrea probably.
22:40 owen chris: Was it supposed to happen last week instead?
22:41 richard is now known as rich-away
22:41 pianohacker bleh. I generally oppose torrenting, but the release schedule for dr. who episodes in the US is truly ridiculous
22:42 chris 2020 or soething
22:42 Nate left #koha
22:44 owen chris: It'll be time for a re-make by then
22:44 chris heh
22:45 mason heya folks..
22:45 wizzyrea hi mason
22:45 |Lupin| k, time to go to bed, til soon everybody, bye
22:45 brendan heya mason
22:45 |Lupin| left #koha
22:48 wizzyrea I'm out, ttyl :)
22:49 owen No, wizzyrea, 12 more minutes of productivity!
22:49 wizzyrea can't... do... it...
22:49 pianohacker just enough time for a patch!
22:49 wizzyrea i'm like the thirsty person in the desert... belly crawling towards the end of day oasis
22:51 mason .. with a bunch of kids, waiting to ride you like a horsey -  when to get there ;)
22:51 mason s/to/you/
22:51 joetho left #koha
22:51 wizzyrea lol masosn
22:51 wizzyrea mason*
22:51 wizzyrea dangit owen, now I feel guilty
22:52 * owen absolves wizzyrea
22:57 * owen thinks, Let's see a monkey do that!
22:59 owen left #koha
23:25 brendan ah the channel goes quiet after wizzyrea and owen leave :)
23:25 chris heh
23:54 kr1shnan joined #koha

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