Time  Nick      Message
15:30 slef      hi all.  hdl, kados - are you there?
15:32 slef      hdl - can we please use DBI to load the SQL into the databases?  The installer doesn't seem to work on *BSD again.
15:33 hdl       slef : It thought it was already the case.....
15:33 slef      hdl: nafaict
15:34 slef      qx($strcmd <$datadir/kohastructure.sql 2>&1 1>/dev/null);
15:34 slef      under
15:34 slef          elsif ( $op && $op eq 'importdatastructure' ) {
15:35 slef      According to the commit log for 73613b712bbe945143a17f267b1597d2d705543f you reversed the change
15:36 slef      Can anyone tell me how to access the channel logs?  I can't figure out newlogbot and http://irc.koha.org/ redirects to "Bob & Jo Blog"
15:40 hdl       It has been a long time.. I havenot used ircbot
15:40 hdl       What do you want to read ?
15:41 slef      I want to see if you described *what* the error was in here ;-)
15:41 slef      As I'm getting "sh: line 1: -u: command not found" all over the place :-(
15:42 hdl       slef : is there some minor changes to command line we could add ?
15:42 hdl       -u is for user ?
15:42 hdl       slef : can you tell me what options are taken for mysql command on *BSD ?
15:43 slef      I don't think that's the problem. I'm pretty sure this is non-portability of qx() and backticks.
15:43 slef      man perlop
15:44 [K]       *** join #koha@FreeNode: zsh n=zsh@196.201.208.129
15:44 slef      "How that string gets evaluated is entirely subject to the command interpreter on your system."
15:44 slef      The mysql options are the same.
15:48 owen      slef: http://koha.org/cgi-bin/logs.pl
15:49 slef      owen: ta
15:49 owen      I'm not sure why the web site just says "You can view the logs of #koha using logbot" instead of linking to that page
15:50 slef      especially as I can't see how to view the logs using newlogbot
15:50 slef      me either
15:51 slef      about that?
15:51 owen      Yes
15:52 slef      cool, thansk
15:53 hdl       slef : the error I told about was the fact that last line was empty and when trying to do dbh->do() it threw an error.
15:54 hdl       I realized that but had no time to make a correct test or map for that.
15:54 slef      so filter out blank lines?
15:54 hdl       And using qx worked for my system.
15:55 hdl       slef : probably but not only.
15:55 slef      yeah, there are a few other things to beware
15:55 hdl       slef : I think we should filter comment lines.
15:55 hdl       + blank lines
15:55 slef      but we know qx doesn't work since 1.2!  web installer was a great chance to change it
15:56 hdl       + some other lines.
15:57 hdl       maybe designing a filter would allow us to use command lines.
15:57 hdl       + would allow $ and ! in passwords.
15:58 hdl       I went to the quickest solution. Not the best one.
16:00 hdl       maybe we could ask fbcit if he sees some problems using DBI. (fbcit did postgresql adaptations.)
16:03 slef      wrapping it in sh -c "" doesn't work
16:04 slef      same error
16:06 slef                      $error = system("sh","-c","$strcmd < $file 2>&1 1>/dev/null");
16:06 slef      might have worked... checking
16:07 slef      no, it didn't
16:15 slef      Table 'koha.class_sort_rules' doesn't exist
16:17 slef      hrm, it's in kohastructure.sql
16:19 slef      ah, a different kohastructure.sql
16:20 slef      looks like I unpacked over an older copy :-/
16:21 hdl       slef ?
16:21 hdl       If there is no other solution, I will stick to DBI
16:21 slef      I don't know another solution - shall I put it out on list?
16:26 hdl       Do you think of other cases to filter ?
16:26 slef      it may be better to filter out everything except what we think is a command
16:29 gmcharlt  slef, hdl: perhaps use something like IPC::Cmd?
16:30 slef      gmcharlt: is that perl core?
16:31 gmcharlt  slef: no, but IPC::Open3 is. which might be another approach
16:32 gmcharlt  IPC::Open3 allows running a process and attacing to STDIN and STDERR, apparently without any (or less, anyway) dependency on sh
16:33 slef      another possibility is DBIx::File2do
16:33 slef      but v0.001 or whatever is a bit scary
16:35 hdl       adding a new dependency would be risky in my opinion.
16:35 gmcharlt  slef: I just check its source; doesn't look like it strips out comments or anything else that $dbh->do might choke on
16:36 hdl       I think I shall stick to DBI and filtering.
16:38 slef      gmcharlt: have you used open3 before
16:38 slef      ?
16:38 gmcharlt  yeah, a few months ago
16:38 gmcharlt  alas, I'm leaving for the airport soon, and won't have time today to work on it
16:38 slef      we'd need to read the sql and print it to $wtr?
16:40 gmcharlt  slef: yep, but without having to try to munge it
16:41 slef      open3 seems to work on Darwin
16:43 slef      hdl: want me to try coding this?
16:44 hdl       yes. And send me your code
16:44 slef      hdl@biblibre?
16:55 slef      hdl: what address?
16:55 hdl       sent in private channel
16:55 slef      ok, seen it
16:55 slef      bbl
17:58 atz       does independent branches affect itemtypes?
18:17 Brooke    howdy
18:20 atz       greets, Brooke
18:20 Brooke    :)
18:23 kados     hey Brooke
18:23 kados     Brooke: have you tried out the alpha yet?
18:24 Brooke    not yet
18:24 kados     please do, we need your feedback prior to Feb 1, the date of the Beta :-)
18:34 [K]       *** join #koha@FreeNode: maktrix n=mak@59.152.90.138
18:46 chris     morning
18:50 hdl       hi chris
19:02 owen-away Hi chris, kados
19:05 [K]       <maktrix@FreeNode> hello all :)
19:06 kados     hi maktrix
19:06 [K]       <maktrix@FreeNode> I guess I forgot about me :), I'm from Bangladesh
19:07 [K]       <maktrix@FreeNode> I was wondering if I can learn thing about koha
19:07 [K]       <maktrix@FreeNode> I think there are lots of option to implement koha in my country. So, if you can tell me where to start
19:08 kados     maktrix: perhaps you can start with http://kohadocs.org ?
19:08 kados     maktrix: and also try out the new Alpha of 3.0?
19:08 [K]       <maktrix@FreeNode> where can I find koha features...
19:09 kados     maktrix: and if you want to translate koha into your language you can post a message to koha-translate
19:09 [K]       <maktrix@FreeNode> I hope koha is Unicode enabled, so I can use Bengali for book names
19:09 kados     maktrix: yes, it is
19:09 [K]       <maktrix@FreeNode> How many strings in koha to localize 100%
19:10 owen      atz, you're exactly right about the manual re-entry of patron details from opac-userupdate. It's pretty low-tech
19:10 kados     maktrix: about 6,000 I believe
19:10 [K]       <maktrix@FreeNode> [K]: thanks
19:11 [K]       <maktrix@FreeNode> [K]: nobody around #koha-translate :)
19:11 atz       yeah... we cache and process purchase requests, comments... but not patron data.
19:12 atz       is there an option to "just allow them to edit their own basic data" ?
19:12 atz       i.e., unmediated
19:13 owen      Not at present
19:13 owen      I suppose the assumption is that you don't want the patron to delete their phone number just because they don't want to take the library's calls anymore
19:13 atz       I saw a request to disallow any edit req's
19:13 atz       i.e., running off of LDAP, disallow ANY edit to patron data (by patrons or staff)
19:14 atz       so we'll be revisiting this from a couple angles
19:14 owen      Because under LDAP patron details would be stored outside the system?
19:14 atz       right
19:14 atz       but it isn't usually absolute
19:14 atz       i.e., certain fields (like password) would map out
19:14 atz       but the rest be local
19:17 atz       in the requestors case, he wanted basically everything on moremember to be from LDAP, therefore not (currently) editable
19:17 atz       someday we might actually entertain writing back to LDAP
19:19 chris     heh, i wrote that back at about 2am december 31 1999
19:19 owen      It'd be pretty simple to alter the editability of form fields in memberentry based on a check for LDAP authentication, as long as there was a standard map of LDAP-related fields
19:19 chris     cos koha needed to go live on the 3rd, and we didnt have a way fo a patron to update info
19:19 chris     suprised its lasted this long :-)
19:20 kados     heh
19:25 owen      atz, did you see kados' comments on bug 1597?
19:28 kados     and I'll further note that whoever works on that should also add a OPAC-based registration form
19:31 atz       good thought, kados
19:32 owen      At NPL we discussed an OPAC-based registration system, and thought that such a system should allow the patrons to enter all their registration details and then present ID to the librarian to get their account activated
19:32 owen      I'm not sure how other libraries handle it
19:32 atz       that sounds exactly right
19:33 atz       create a disabled account
19:33 atz       librarians "renew" or otherwise auth it
19:33 owen      I'd like to see some way for patrons with an existing account but no password to be able to register a password online, but I'm not sure how you'd do that securely
19:34 atz       yeah, that one is dicey
19:34 owen      An emailed password-registration link would work for those patrons with email
19:35 kados     surely there are standard perl modules for handling that kin of thing
19:35 atz       yeah, the email would be fine
19:35 kados     or we can rip off from another perl project like RT
19:35 atz       kados: the Indian dudes have me psyched.
19:36 atz       and the potential for more norwegian hackers
19:36 atz       :)
19:36 kados     *nod*
19:37 kados     norway++
19:38 atz       so opac-userupdate is doubly-lame: it doesn't do what we'd want, and it doesn't even do what *it* wants.
19:42 kados     owen: got a sec?
19:43 atz       owen: reported bug 1761 on "Check All" function
19:43 kados     owen: I could use your help with an issue I'm having with the 'more' button styling (for the language switcher)
19:49 owen      kados: here I am
19:56 atz       hrm... we seem to have copies: changelanguage.pl and opac/changelanguage.pl
19:57 kados     atz: yea ... that's somewhat intentional, eh? one for the opac and all
19:58 kados     atz: really, we need to have two cookies too, kohaopaclanguage shoudln't be ued for the staff client
19:58 atz       not sure... it's identical files
19:58 kados     yea, but how do you call changelanguage in the staff client from the opac? and vice versa?
19:59 kados     without doing something naughty that is apache-specific or paltform-specifc
19:59 kados     also, some people run their opac on a separate box
19:59 atz       symlink would be fine
19:59 kados     symlink is platform-specific
19:59 atz       or just pull in the whole thing to C4 module
20:00 kados     yea, that could work
20:00 atz       (not platform-specific enough to disqualify it, imho)
20:00 kados     make a ChangeLangauge function
20:00 atz       basically all it does is call the function anyway, and the function itself is printing a redirect
20:00 kados     yep
20:01 kados     atz: you can put tha ton your list of stuff to re-factor post-3.0 :-)
20:01 atz       (which i don't really like, since it doesn't exit afterwards, but if we're going that way)
20:36 rex       I am trying to install Koha 2.2.9 on Mac OSX 10.4.1 and cannot get CPAN to install MARC::File::XML
20:37 rex       I last tried to do this in early November and am just now getting back to working on it. Any reccomendations?
20:37 chris     try the 3.0 alpha :-)
20:38 rex       I was thinking about it
20:38 chris     which wont actually help with the MARC::File;:XML problem
20:38 chris     hmm
20:38 rex       yeah that's why I was only thinking about it.
20:38 chris     lemme try it on my macbook
20:38 chris     2 secs
20:38 atz       download the tarball from the website and try it?
20:39 rex       hmmm
20:39 masonj    morning #koha
20:39 chris     right cpan is downloading it now
20:39 rex       think I've tried that.
20:40 chris     so MARC::Charset has errors on make test
20:40 chris     and without that i cant get MARC::File::XML on
20:41 chris     ahh missing Class::Accessor
20:41 rex       I think I've installed Charset and Accessor
20:42 chris     yep, charset is installing now
20:42 chris     ill soon be stuck at the same point as you :)
20:42 rex       lol
20:43 kados     we really need to get these perl modules packaged up for debian
20:43 kados     it's a pain to install them from cpan
20:43 rex       like 2 months ago someone from this channel sent me a script which they used to facilitate this, but I am ashamed to say that I have no memory of what it is supposed to do or what I was supposed to do with it.
20:44 kados     heh
20:44 kados     rex: you trying to install the alpha?
20:44 rex       no 2.2.9
20:44 kados     ahh
20:44 chris     debian wont help poor rex on his mac :-)
20:44 kados     rex: better off with the alpha really
20:44 kados     rex: it's more stable than 2.2.9 IMO
20:44 chris     yeah
20:44 rex       well I'm willing to open another can of worms if thats what people reccomend
20:44 kados     oh, I think there's a guide to OSX
20:44 rex       there is
20:44 rex       for 2.2.9 at least
20:44 kados     yea, most of the dependencies are the same
20:44 rex       its just that there were so few worms left in this can.
20:45 kados     it's the dependencies that are hard
20:45 kados     particularly perl and zebra/yaz
20:45 kados     we need a koha.dmg :-)
20:45 kados     that has everything packaged up together
20:46 chris     oh hey it installed
20:46 rex       lol I figure out how to get the thing to work first!
20:46 chris     Writing /opt/local/lib/perl5/site_perl/5.8.8/darwin-2level/auto/MARC-XML/.packlist
20:46 chris     Appending installation info to /opt/local/lib/perl5/5.8.8/darwin-2level/perllocal.pod
20:46 chris       /usr/bin/make install  -- OK
20:46 chris     whats the error you are getting rex?
20:47 rex       well the bottom of the error message is:
20:47 rex       make: *** [test_dynamic] Error 255
20:47 rex         KADOS/MARC-XML-0.88.tar.gz
20:47 rex         /usr/bin/make test -- NOT OK
20:47 rex       /hint// To get more information about failing tests, try:
20:47 rex         reports KADOS/MARC-XML-0.88.tar.gz
20:47 rex       Running make install
20:47 rex         make test had returned bad status, won't install without force
20:47 kados     bummer ...
20:47 rex       but the broken bit up at the top appears to be
20:48 rex        KADOS/MARC-XML-0.88.tar.gz
20:48 rex         /usr/bin/make -- OK
20:48 rex       Running make test
20:48 rex       PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
20:48 rex       t/batch........NOK 1/23
20:48 rex       #   Failed test 'use MARC::File::XML;'
20:48 rex       #   at t/batch.t line 4.
20:48 rex       #     Tried to use 'MARC::File::XML'.
20:48 rex       #     Error:  Unable to provide required features
20:48 rex       # Compilation failed in require at (eval 3) line 2.
20:48 rex       # BEGIN failed--compilation aborted at t/batch.t line 4.
20:48 rex       Can't call method "parse_string" on unblessed reference at /Users/library_admin/.cpan/build/MARC-XML-0.88-h3LdaI/blib/lib/MARC/File/XML.pm line 448.
20:48 rex       # Looks like you planned 23 tests but only ran 3.
20:48 rex       (sorry for spamming the channel w/that)
20:48 kados     hmmm
20:48 kados     no worries ...
20:48 kados     so where does parse_string live?
20:49 kados     do you have MARC::Charset installed?
20:49 rex       believe so
20:49 kados     there's one other dependency too IIRC
20:49 rex       accessor
20:49 kados     yea, that's it
20:49 rex       my log says I installed them both on 5 nov
20:49 kados     and that's installed too?
20:49 kados     hmmm
20:49 kados     how about LibXML?
20:49 rex       I might have been fooling myself tho
20:50 kados     if you grab koha 3.0 alpha from download.koha.org
20:50 kados     you can use some of the utilities in there to test your perl installation
20:50 rex       perhaps I will just give 3 a go
20:50 rex       if I run into the same dependcy problems it sounds like the troubleshooting will at least be easier
20:51 kados     you'll still have this dependency issue to get around
20:51 rex       and I'll have to install Zebra sounds like. At get it to like the version of apache on this box.
20:51 kados     apache should be fine
20:51 kados     nothing apache-specific in koha
20:52 rex       right I'll give that a shot then.
20:52 kados     rex++ let us know how it goes
20:52 rex       thanks for your help all -- I may need more of it in a bit :)
21:02 hdl       atz around ?
21:07 atz       yep
21:07 atz       what's up/?
21:11 hdl       just sent you an email about partial date support.
21:11 hdl       I was wondering if C4::Dates allowed dates as 1952-12-00 ?
21:15 hdl       i just tested it : it seems NOT.
21:15 hdl       atz : This is kind of a problem for me.
21:16 hdl       Some folks asked me to allow partial date support.
21:17 atz       00 date is invalid format
21:17 hdl       Becaus when you retro catalogue serials, they found it quite nonesense to give it a precise publication date or a precise reception date.
21:17 kados     what is the convention 'in the world' for such a partial date?
21:18 hdl       those people told me :
21:18 atz       hdl: i would just say use the first of the month
21:19 atz       it would be invalid in the database anyway, since the mysql fields are type=date
21:19 hdl       setting day to 00 enables us to say : we donot know which day it was published BUT
21:19 hdl       mysql allow 1957-12-00
21:19 atz       that would require a separate database field type and all the code to match
21:20 hdl       BUT it was issued in december.
21:20 atz       oh?  let me check that out...
21:20 hdl       I am sure of it. it even allow 0000-00-00
21:21 hdl       (I have plenty of them in my bases)
21:21 atz       right...
22:30 [K]       *** part FreeNode!#koha: maktrix n=mak@59.152.90.138
03:13 CGI246    how do I add an item to koha library?
03:15 kados     CGI246: what version?
03:17 CGI246    2.2.9
03:24 CGI246    how do i add or transfer an item to koha library version 2.2.9
03:25 kados     use the cataloging module
03:25 kados     CGI246: read kohadocs.org/usersguide
03:35 CGI246    thank you!!
05:01 [K]       *** join #koha@FreeNode: zsh n=zsh@196.201.208.129
08:37 hdl_mrs   hello
08:46 chris     hi hdl
08:47 chris     mrs = marseille?
08:48 paul      yep, hdl is with me today
08:48 paul      hello chris
08:49 chris     cool
08:49 chris     hi paul
08:51 paul      chris : some minor patches in your mailbox.
08:52 chris     cool, ill go look
08:54 chris     lol
08:54 chris     i did the same patch earlier today
08:54 chris     moving a misplaced * to fix a bug in issuingrules
08:55 paul      :-)
08:55 chris     great minds think alike :)
08:56 paul      we say the same thing (almost) in french : "les grands esprits se rencontrent"
08:56 paul      did you validate hdl patch "important Commit for UNIMARC items" ?
08:56 paul      do you know if kados looked at it ? (should be harlmess for your but a must-have for us)
08:56 chris     yep its in joshua's queue now
08:57 chris     so when he wakes up in a few hours he will see it :)
09:48 kados     hiya vikas
10:37 paul      hi kados. good morning ?  or going to bed soon ?