Time  Nick         Message
22:55 SzosszeNET   found thanks :)
22:55 tweetbot`    [off] twitter: @kohails: "#kohails  Costume Masks in the collection http://t.co/lzXCKasE"
22:52 SzosszeNET   or where it is
22:52 SzosszeNET   DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_groupkoha`.`borrowers`, CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`))
22:52 SzosszeNET   what is the branchcode on koha GUI?
22:29 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8659 normal, P5 - low, ---, pelletiermaxime, Pushed to Stable , Inactive funds in neworderempty not disabled in IE/Opera
22:29 jenkins_koha maxime.pelletier: Bug 8659 Remove and readd the inactive funds in javascript to make it work in all browsers
22:29 jenkins_koha Project Koha_3.8.x build #188: SUCCESS in 37 min: http://jenkins.koha-community.org/job/Koha_3.8.x/188/
22:23 * rangi      heads out
22:21 rangi        http://perldoc.koha-community.org/C4/Auth_with_ldap.html#KOHA_CONF_and_field_mapping
22:20 rangi        The <mapping> subelements establish the relationship between mysql fields and LDAP attributes. The element name is the column in mysql, with the "is" characteristic set to the LDAP attribute name. Optionally, any content between the element tags is taken as the default value. In this example, the default categorycode is "PT" (for patron).
22:20 rangi        from the man
22:19 rangi        you have just a mix up in your config
22:19 rangi        and employeetype is the AD field
22:19 rangi        where PFRSTAFF is your default
22:19 rangi        you need something like that
22:19 rangi        <categorycode is="employeetype" >PFRSTAFF</categorycode>
22:18 drojf        and you said you have 'user' in the ldap config
22:18 drojf        you can only set the categorycode in caps
22:18 drojf        BUT
22:18 drojf        yes
22:17 SzosszeNET   and here code is the categorycode
22:17 SzosszeNET   Home › Administration › Patron categories
22:17 SzosszeNET   just to clear out
22:16 SzosszeNET   indeed
22:16 drojf        but then it would not say its empty i guess
22:15 drojf        maybe caps some place and not the other?
22:15 drojf        it sounds like you dont have set that categorycode in koha administration, at least not exactly like in your ldap config
22:12 SzosszeNET   I think not supposed to be in the mapping...
22:11 SzosszeNET   so the question how do I set the default categorycode?
22:11 drojf        oh
22:11 drojf        not really
22:11 SzosszeNET   kind of crazy
22:11 drojf        ah i see
22:11 SzosszeNET   so I'm authenticating with a to be patron which does not exist yet :)
22:10 SzosszeNET   and where I am - as I told I authenticate against AD - first time. What happens as I found I authenticte and koha creates my login on first logon
22:10 drojf        ok so much for my ideas, go on having fun ;)
22:09 SzosszeNET   that's the category code - but the mapping is not used/accepted as it is...I think
22:09 drojf        also, is "user" your categorycode or the description of that code?
22:08 SzosszeNET   yes
22:07 drojf        does that make sense?
22:07 drojf        you have a database user (the one in koha-conf.xml) that you use to login for the first time and do database upgrades after updates. that is not a full patron or staff member. in case you are trying to authenticate an existing patron that should probably be tried with one you entered yourself
22:03 SzosszeNET   <drojf>: are you using a real patron or your database user? please clarify :)
22:02 SzosszeNET   <categorycode is="user"/>
22:02 SzosszeNET   yes, and also already created a category in koha "user"
22:02 drojf        are you using a real patron or your database user?
22:01 drojf        do you have categorycode in your mapping?
22:01 SzosszeNET   but the process stops as :DBD::mysql::st execute failed: Column 'categorycode' cannot be null at /usr/share/koha/lib//C4/SQLHelper.pm line 184, <DATA> line 522. AddMember failed at /usr/share/koha/lib//C4/Auth_with_ldap.pm line 178, <DATA> line 522.
22:01 SzosszeNET   now as ldap does resolve and authenticate koha is supposed to store the user in mysql
22:00 SzosszeNET   I mean
22:00 SzosszeNET   it's koha+ldap
22:00 SzosszeNET   it's working
22:00 SzosszeNET   it's not LDAP anymore
22:00 SzosszeNET   :D
21:59 drojf        not that i know anything about ldap
21:58 drojf        SzosszeNET: that somehow sounds like the OU jcamins_away mentioned
21:51 jenkins_koha Starting build #188 for job Koha_3.8.x (previous build: SUCCESS)
21:51 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8702 normal, P5 - low, ---, fridolyn.somers, Pushed to Stable , System preferences search does not allow accented letters
21:51 jenkins_koha fridolyn.somers: Bug 8702: System preferences search does not allow accented letters
21:51 jenkins_koha Project Koha_3.8.x build #187: SUCCESS in 38 min: http://jenkins.koha-community.org/job/Koha_3.8.x/187/
21:39 SzosszeNET   Think is in pair with this : opac-user.pl: DBD::mysql::st execute failed: Column 'categorycode' cannot be null at /usr/share/koha/lib/C4/SQLHelper.pm line 184, <DATA> line 522.,
21:33 SzosszeNET   but "AddMember failed at /usr/share/koha/lib/C4/Auth_with_ldap.pm line 169."
21:33 SzosszeNET   :D
21:33 SzosszeNET   got it work
21:13 jenkins_koha Starting build #187 for job Koha_3.8.x (previous build: SUCCESS)
21:09 SzosszeNET   \o/
21:09 SzosszeNET   would be interested :D
21:08 drojf        +1 for pi cluster
21:08 drojf        rambutan: right? plack is witchcraft
21:08 jcamins      Both are important.
21:08 rambutan     Koha Pi Cluster, anyone?
21:08 jcamins      And how you did not fix the problem.
21:08 jcamins      Yes, definitely be sure to note down how you fix the problem.
21:08 SzosszeNET   :) bind-by-auth was enabled
21:08 rambutan     drojf: well, that's actually impressive
21:07 drojf        whatever you do, feel free to fill lots of wiki pages and blog posts with what you find out, i might have to do ldap configuration one day
21:07 jcamins      Yes, it is past 5pm on a Friday for me, why do you ask?
21:06 jcamins      Or re-envision it in an edgy and unconventional gothic setting.
21:06 jcamins      Or disable it.
21:06 jcamins      And you need to enable auth-by-bind.
21:06 jcamins      *with
21:06 jcamins      Suggestion B is that it's trying to bind by the wrong user.
21:05 SzosszeNET   ;)
21:05 jcamins      SzosszeNET: I warned you I didn't know what I was talking about. ;)
21:04 drojf        rambutan: i would put it on a second pi if i had one ;)
21:04 drojf        rambutan: same machine
21:04 SzosszeNET   jcamins as the credentials are not ok I think my user if found now...
21:04 rambutan     drojf: yea, it's slow, but not really unreasonable. Surely MySql is running on a different machine, right?
21:03 * jcamins    speculates wildly that the problem is probably with the OU, then points out that he doesn't generally configure LDAP.
21:02 SzosszeNET   however the pw is supposed to be ok...
21:02 SzosszeNET   hmmm, hope almost there : LDAP bind failed as kohauser mag: LDAP error #49: LDAP_INVALID_CREDENTIALS
20:57 cait         :)
20:57 jcamins      Ah.
20:57 drojf        technische hochschule. technical university?
20:56 cait         maybe a bit too slow to make a good impresssion :)
20:56 drojf        lol
20:56 drojf        hm she's cait, not kf
20:55 jcamins      TH?
20:55 drojf        kf: a raspberry pi for every participant in the workshop? we would not have to deal with VMs then ;) i guess the TH could afford to give them out for free
20:52 rambutan     drojf: will take a look
20:52 wahanui      somebody said progress was good
20:52 jcamins      SzosszeNET: progress!
20:52 SzosszeNET   yeah! :D
20:52 SzosszeNET   finally it talks to me :D
20:52 SzosszeNET   F***meeee!!!!!!!!!!!! " 22:48:12 2012] [error] [client 10.42.1.7] [Fri Sep 28 22:48:12 2012] opac-user.pl: LDAP error #32: LDAP_NO_SUCH_OBJECT,"
20:52 drojf        you could probably feel the speed better if you had seen how it works without plack
20:51 SzosszeNET   yep :)
20:51 drojf        i think there are servers in production with that speed ;)
20:50 SzosszeNET   but not that bad
20:50 SzosszeNET   indeed khm...slightly slow :D
20:50 drojf        :)
20:49 SzosszeNET   drojf first I'll be happy if I can run it on a vmware host :D
20:48 jcamins      Do nai feed them or they will follow you home.
20:48 drojf        long even
20:48 drojf        ah, that person i stopped reading emails of log ago
20:47 drojf        we have trolls?
20:47 drojf        [off] rambutan SzosszeNET if you'd like to try, that's koha 3.8.5 on the raspberry pi. searching the opac is not really fast, staff client works quite ok for that small machine i would say. opac http://85.179.13.203:5000/cgi-bin/koha/opac-main.pl | staff client http://85.179.13.203:5001/cgi-bin/koha/mainpage.pl username/password 'test'
20:42 jcamins      cait: is going to have a borked up system either way, since he wouldn't fix it when I told him to.
20:42 cait         but the library...
20:41 cait         :(
20:41 jcamins      If I thought he might listen, I'd tell him how to fix it, but I know he wouldn't follow the instructions I gave him.
20:41 rangi        yep, every reply gives him another opportunity to spread FUD
20:40 jcamins      I'm past trying on that.
20:39 rangi        you'll see the message on the mailing list
20:39 cait         there were so mny
20:39 wahanui      somebody said which one was 3.6.x?
20:39 cait         which one?
20:39 rangi        gah tcohen fed the troll
20:37 SzosszeNET   recently was made 240mb possible
20:37 rambutan     BOINC performs best with a good GPU, but requires the modules be written specifically for the GPU
20:37 SzosszeNET   that was true :)
20:37 drojf        maybe we will see that one day. we have 240mb ram now too, when i started they said more than 224 is not possible
20:36 SzosszeNET   but that's a quite powerfull beast...
20:36 SzosszeNET   shame, the gpu cannot be utilized
20:35 drojf        (btw double the speed for standard koha means it is still painfully slow)
20:35 SzosszeNET   indeed interesting - shame I'm still not a developer and just explorering koha :)
20:35 drojf        but the older benchmarks were master at that time, the overclocked ones were 3.84 and 3.8.5, that might make a difference
20:34 drojf        SzosszeNET: the one where i made benchmarks was not overclocked. i have benchmarks with overclocking too (1000mhz), its doubles the speed for standard koha, but it does not do much for the plack version
20:34 rambutan     Interesting (10x faster).
20:33 SzosszeNET   :)
20:33 jcamins      SzosszeNET: drojf insists it ran nice and fast.
20:32 SzosszeNET   and was still slow overclocked?
20:32 drojf        rambutan: if you have some time, try it with plack, it works quite ok. i made some tests a while ago, its about 10x faster than without http://abunchofthings.net/blog/koha-on-a-raspberry-pi-staff/
20:32 jcamins      SzosszeNET: drojf used to do all his development on his Raspberry pi.
20:32 rambutan     Originally my idea was to buy about a dozen and set up a BOINC cluster.
20:31 SzosszeNET   not overvolt just overclock , also giving all ram to CPU and taking away almost everything from GPU is also not a bad idea ;)
20:30 rambutan     no, and honestly, I've been busy with SA stuff so I haven't had time to play with them much. I know my tech assistant uses his as an ssh access server at home.
20:30 jcamins      SzosszeNET: switch to that user so you can set the environment variables and run the script you were trying to run.
20:30 SzosszeNET   ?
20:30 SzosszeNET   rambutan did you overclock it
20:29 drojf        rambutan: tried plack?
20:29 rambutan     drojf: I and my tech have a couple of our personal RPIs here. I was thinking about using them for OPACs in the library, but really they are too slow based on our testing.
20:29 SzosszeNET   that's true, but what should I do with it? :D
20:28 jcamins      I don't know exactly, but you'll be able to tell by looking in /etc/passwd
20:28 jcamins      SzosszeNET: groupkoha-koha or something like that.
20:28 SzosszeNET   oh, and the user? :$
20:28 drojf        so the pi will just be a normal koha server ;)
20:27 jcamins      Heh. Probably not too great.
20:27 drojf        i have a feeling that having a lot of files be written and changed all the time was not too great for the sd card
20:27 drojf        jcamins: this time its on a vm on my laptop ;)
20:26 drojf        or maybe i forget about something brilliant i coded and will never remember lol
20:26 jcamins      drojf: this time I recommend against bricking your Raspberry Pi. :P
20:25 drojf        no i think i will give copying the whole folder a try and otherwise just work with a clean git. at least i have a working git again
20:25 jcamins      We should have a koha-shell utility.
20:25 SzosszeNET   okay, thanks
20:23 jcamins      In that case I suggest not worrying about it. :)
20:23 drojf        some drafts may be lost, some enhancements to my patches that i would probably not have used anyway.
20:23 drojf        oh
20:23 jcamins      drojf: you were cut off after "some drafts may be lost, some enha..."
20:22 jcamins      SzosszeNET: it's also on the wiki, but I just figured out how to get that information out of wahanui.
20:22 jcamins      (and export PERL5LIB=/usr/lib/koha
20:22 SzosszeNET   checked on the wiki... :S
20:22 SzosszeNET   grrr...
20:22 drojf        jcamins: i'm looking into that. what git fsck says and all, but somehow having "corruption" wirtten everywhere is a little scary. there seem to be some ways to crawl through bits and pieces of git. and there was not actually lots of unique stuff in it. most was stuff from k-c.org i tested so it does not matter, some was my own but i think most of that is on the bug tracker. i have not been working on any huge projects, some drafts may be lost, some enha
20:21 jcamins      It'll be something like export KOHA_CONF=/etc/koha/sites/groupkoha/koha-conf.xml
20:21 jcamins      ^^ SzosszeNET: take a look in there for an example of setting KOHA_CONF and PERL5LIB
20:21 wahanui      i think install.debian is at git.koha-community.org/gitweb/?p=koha.git;a=blob;f=INSTALL.debian
20:21 jcamins      install.debian?
20:20 cait         drojf: heh
20:18 jcamins      Doesn't matter if the branches that are upstream are recoverable.
20:18 jcamins      drojf: maybe some of the branches that weren't from git.k-c.org will be recoverable?
20:16 * drojf      is referring to the proposal of course, not really calling cait annoying
20:16 drojf        say even
20:16 drojf        i did not day annoying object ;)
20:15 drojf        lol cait, i talk about my git operation ;)
20:15 drojf        but well, i got the segmentation fault in the middle of trying to git me a 3.8.5, so that was not completely unexpected
20:15 cait         hope you didn't talk about me
20:14 cait         drojf: fatal object? :)
20:13 drojf        i try to get the whole folder over anyway
20:13 drojf        i tried it already
20:13 jcamins      Darn.
20:13 drojf        doesnt work
20:13 * jcamins    has never used it.
20:13 jcamins      --full?
20:13 jcamins      git fsck?
20:13 drojf        it's all completely b0rked
20:12 jcamins      drojf: uh-oh.
20:12 drojf        "fatal: object abde5352a48aef47f0e459160d9d6e91a9b39df4 is corrupted"--
20:12 drojf        cait++
20:11 jcamins      cait++
20:11 drojf        oh look, we have a possible future QA manager :)
20:09 jcamins      \o/
20:08 cait         it's done
20:08 jcamins      Switch to the system user and set KOHA_CONF and PERL5LIB.
20:08 SzosszeNET   what am I supposed to do? :)
20:08 SzosszeNET   so...searched the wiki, but not sure...
20:06 jcamins      I mean, they have different naming schemes.
20:05 SzosszeNET   that's true
20:05 jcamins      Sorry, MySQL user and system user are different.
20:05 jcamins      No, groupkoha-koha
20:05 jcamins      (koha_groupkoha)
20:05 libsysguy    ^^
20:05 jcamins      And by running as the correct user.
20:05 libsysguy    looks like you need to export KOHA_CONF
20:05 jcamins      You need to set KOHA_CONF and PERL5LIB.
20:04 SzosszeNET   I know ;)
20:04 SzosszeNET   /usr/share/koha/opac/cgi-bin/opac/opac-user.pl userid=mag@domain.be password=secretcode >junk Can't locate C4/Auth.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at /usr/share/koha/opac/cgi-bin/opac/opac-user.pl l
20:03 jcamins      SzosszeNET: that's the blog post that libsysguy wrote.
20:03 SzosszeNET   jcamins libsysguy! :D https://www.facebook.com/note.php?note_id=10150321097398209
19:35 rambutan     humm, that bit is interesting actually (CA hosting)
19:34 tweetbot`    [off] twitter: @kohails: "#kohails  ByWater Solutions Offers Canadian Based Koha Hosting Services http://t.co/EqZ6YPaA"
19:30 SzosszeNET   I'm no programmer...
19:30 jcamins      If you're not comfortable with Perl, you could end up with an even worse situation very quickly. :(
19:29 * jcamins    can't really recommend that, though.
19:29 jcamins      SzosszeNET: you could try setting $C4::Debug::debug = 1; in C4/Auth_with_ldap.pm, I guess.
19:29 SzosszeNET   *almost
19:29 SzosszeNET   as I found should be logged to the "opac-error.log" but that's empty
19:28 SzosszeNET   the strange stuff why is a bad login attempt not logged? :D at all
19:27 SzosszeNET   hmm http://lists.katipo.co.nz/public/koha/2009-May/018547.html this also does not help...
19:08 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8210 enhancement, P5 - low, ---, jcamins, Pushed to Master , Headings in OPAC bib details should link to authority record
19:08 jcamins      bug 8210.
19:08 jcamins      The other is...
19:08 jcamins      There are two.
19:08 nengard      thanks
19:08 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5888 enhancement, P5 - low, ---, julian.maurice, Needs Signoff , opac-detail subject/author links improvements
19:08 jcamins      nengard: bug 5888 and...
19:08 nengard      jcamins (or anyone) what patch added the little magnifying classes in the opac next to authority fields?
19:07 * SzosszeNET is just a half crazy M$ - debian admin hybrid...
19:06 SzosszeNET   :D
19:06 libsysguy    but I'm a (self proclaimed) developer :p
19:06 libsysguy    usually its the fastest for me
19:05 * jcamins    has never had a use for debug mode. I guess adding warnings the way libsysguy usually does is the only way to go.
19:05 bag          hello
19:04 SzosszeNET   this cannot be true
19:04 SzosszeNET   grr...
19:04 SzosszeNET   no change...
19:04 huginn       rambutan: bag was last seen in #koha 20 hours, 43 minutes, and 24 seconds ago: <bag> ah 145 tables seems better :)
19:04 rambutan     @seen bag
19:03 SzosszeNET   tried with stop than start (apache)
19:02 jcamins      However, after that thought I'm out of ideas.
19:02 jcamins      I have a vague recollection that you have to shut down Apache entirely in order to restart a virtual host using HTTPS.
19:02 SzosszeNET   no change...
19:00 SzosszeNET   oh
19:00 jcamins      SzosszeNET: like so: SetEnv KOHA_DEBUG "1"
19:00 SzosszeNET   jcamins quotes? where? )
18:59 SzosszeNET   the error log just contains : [Fri Sep 28 19:53:46 2012] [notice] caught SIGTERM, shutting down [Fri Sep 28 19:53:47 2012] [notice] Apache/2.2.16 (Debian) mod_ssl/2.2.16 OpenSSL/0.9.8o configured -- resuming normal operations [Fri Sep 28 19:54:32 2012] [notice] caught SIGTERM, shutting down [Fri Sep 28 19:54:33 2012] [notice] Apache/2.2.16 (Debian) mod_ssl/2.
18:59 * jcamins    is just guessing.
18:59 jcamins      SzosszeNET: try putting the 1 in quotes.
18:59 SzosszeNET   and apache logs clean
18:58 SzosszeNET   I've restarted apache :D
18:57 libsysguy    I had one weird case where it piped to there
18:57 libsysguy    have you looked at the apache logs yet?
18:57 mtj          SzosszeNET, restart apache...
18:57 SzosszeNET   sure, both for opac+intra
18:57 jcamins      And you restarted Apache?
18:57 SzosszeNET   looks like this, but the log files don't contain more data
18:57 jcamins      You'll need to add that line in two places.
18:57 jcamins      Right.
18:56 SzosszeNET   hmm, /etc/apache2/sites-enabled/groupkoha :  ServerAlias groupkoha    SetEnv KOHA_CONF "/etc/koha/sites/groupkoha/koha-conf.xml"    SetEnv KOHA_DEBUG 1
18:54 tweetbot`    [off] twitter: @ByWaterSolution: "ByWater Solutions Offers Canadian Based Koha Hosting Services http://t.co/qtmwhdLz #kohails"
18:54 * libsysguy  crack whip in oleonards general direction
18:54 libsysguy    yeah wherever $debug is
18:54 oleonard_    There, semi-regular afternoon git connectivity blackout over. Back to work.
18:54 jcamins      Well, some information.
18:53 jcamins      Looks like it will.
18:53 jcamins      We don't know if setting debug will actually provide any useful information, though.
18:53 libsysguy    its sad I know
18:53 libsysguy    those are the only ways I really know how to trouble shoot it
18:52 libsysguy    so SzosszeNET you can try what jcamins said or you can start adding print STDERR's in Auth_with_ldap.pm
18:52 jcamins      That's weird.
18:52 jcamins      Oh.
18:52 oleonard_    No, it's just a random afternoon thing
18:52 jcamins      oleonard_: ohhh, filling in at the library with the absurd firewall?
18:51 SzosszeNET   :D
18:51 libsysguy    have it your way jcamins :p
18:51 libsysguy    fine
18:51 libsysguy    :p
18:51 jcamins      libsysguy: if you are able to test LDAP without the web server, yes.
18:50 libsysguy    export KOHA_DEBUG=1;
18:50 libsysguy    or could you export it
18:50 jcamins      (in your Apache config file)
18:50 jcamins      SetEnv KOHA_DEBUG 1
18:50 jcamins      The only way I ever knew to change logs was to set KOHA_DEBUG in the environment.
18:50 cait         but not sure if it does something actually
18:49 libsysguy    grr
18:49 SzosszeNET   libsysguy grep -r "LDAP" /var/log - nothing :)
18:49 cait         maybe it#s still there
18:49 cait         I never tested it
18:49 libsysguy    maybe I'll write that after khall finishes the logger
18:49 cait         jcamins: there used to be a syspref
18:49 libsysguy    that would be nice wouldn't there
18:49 jcamins      I was getting excited when you said there was one, 'cause that'd be great.
18:49 libsysguy    anyway
18:49 libsysguy    i could have sworn
18:49 SzosszeNET   :D
18:49 jcamins      libsysguy: I don't recall there ever being a way to change log verbosity.
18:49 SzosszeNET   3.08.05.000
18:49 * libsysguy  looks at the other devels glaringly
18:48 libsysguy    yeah i think there used to be…who changed that
18:48 libsysguy    SzosszeNET: maybe try: grep -r "LDAP" /var/log
18:48 SzosszeNET   anyway " Home › Administration › System preferences > Logging preferences" there is no verbose logging option (koha 3.8)
18:48 jcamins      oleonard: why do you have a semi-regular afternoon git blackout?
18:47 wahanui      i heard nothing was a requirement, we have guidelines though
18:47 SzosszeNET   and nothing...
18:47 * oleonard   is tired of his semi-regular afternoon git connectivity blackout
18:47 SzosszeNET   # less /var/log/koha/groupkoha/* | grep LDAP # less /var/log/koha/groupkoha/* | grep ldap
18:45 libsysguy    SzosszeNET: i suppose you could grep the logs folder for "LDAP"
18:45 SzosszeNET   :D
18:45 libsysguy    oh bot u so silly
18:45 libsysguy    heh
18:45 wahanui      libsysguy: sorry...
18:45 libsysguy    wahanui: this time its bad :'(
18:44 wahanui      hmmm... interesting is sometimes good and sometimes bad
18:44 libsysguy    interesting
18:44 libsysguy    hmm
18:44 SzosszeNET   you too :)
18:44 mtompset     Good day. :)
18:44 SzosszeNET   everything else is on log
18:44 SzosszeNET   AuthoritiesLog is only "don't log"
18:43 * libsysguy  cheats and uses the search for log
18:43 libsysguy    yup
18:43 SzosszeNET   Home › Administration › System preferences > Logging preferences
18:43 libsysguy    Koha Administration -> Logs
18:42 SzosszeNET   I think opac :)
18:42 libsysguy    from the koha staff page
18:42 libsysguy    oh
18:42 SzosszeNET   but again, where I enable verbose for logging? :)
18:42 libsysguy    oh….well hell
18:42 libsysguy    so I can never remember if they go into koha-error_log or koha-opac-error_log
18:42 SzosszeNET   just told that 4 file only
18:41 SzosszeNET   :) I know where my logs are ;)
18:41 libsysguy    i was about to suggest running find :p
18:41 libsysguy    ah
18:41 SzosszeNET   they are at /var/log/koha
18:41 * libsysguy  takes that as a no :p
18:40 libsysguy    anybody else know where logs are on a standard install?
18:39 SzosszeNET   those 4 log files do exist :)
18:39 SzosszeNET   intranet-error.log  zebra-error.log opac-error.log      zebra-output.log
18:39 * libsysguy  is not too familiar with production installs
18:38 libsysguy    i think
18:38 libsysguy    and you can find those in.../var/logs/koha_error-log
18:38 libsysguy    that should turn on logging for everything
18:38 libsysguy    yeah so in the koha sysprefs set your logs to verbose
18:38 libsysguy    and typically that means that the connection is refused or the principal name is malformed
18:38 SzosszeNET   libsysguy but with that I could debug (or have some idea) what is wrong with my ldap binding
18:37 libsysguy    the only reason it would fail at the point you're at would be if the bind failed
18:37 SzosszeNET   jcamins  enjoy
18:37 * jcamins    goes to eat some lunch.
18:36 libsysguy    it depends on how verbose the logs are set to log in your system preferences
18:36 jcamins      SzosszeNET: not be default. Your logs would be massive.
18:36 SzosszeNET   my logs are almost empty :)
18:36 SzosszeNET   on the orther hand also wondering should not koha log missed login attempts?
18:34 SzosszeNET   if I join the host to AD users should be able to log in to the host - if they can log in the host knows who they are so could learn them koha - kerberos
18:34 libsysguy    how so?
18:33 SzosszeNET   is not it possible to twist around this
18:33 SzosszeNET   I'm just wondering
18:33 libsysguy    heh
18:33 SzosszeNET   tried it but...I just don't have nerves to it
18:32 libsysguy    and requires some troubleshooting
18:32 SzosszeNET   to bad I'm not a programmer mind...
18:32 libsysguy    ldap is almost always 100% a pain in the ass
18:32 libsysguy    :)
18:32 libsysguy    exactly
18:32 SzosszeNET   ahm, so basic debugging...
18:32 libsysguy    so you can enter: print STDERR "LDAP bind failed as kohauser $principal_name: ". description($res);
18:31 libsysguy    well when I am troubleshooting these setups for work I typically start by adding some print statements around where I think the problem is occuring
18:31 SzosszeNET   still the world did not end :D
18:31 SzosszeNET   I could open it ;)
18:30 libsysguy    :p
18:30 libsysguy    then I don't trust you to open Auth_with_ldap.pm
18:30 libsysguy    heh damn
18:30 SzosszeNET   none at all :)
18:29 libsysguy    how perl savvy are you SzosszeNET
18:28 libsysguy    okay
18:28 libsysguy    but the user you're testing with is there
18:28 SzosszeNET   but normal users are in that OU
18:27 SzosszeNET   well, almost, the technical ones are not there
18:27 SzosszeNET   yes
18:27 libsysguy    all all your users reside in the OU "Domain"
18:26 libsysguy    ok so looking at this, you're users are allowed to bind and the bind is supposed to occur using the distinguished name
18:26 SzosszeNET   good questions...
18:24 SzosszeNET   libsysguy : http://pastie.org/4857001
18:24 nengard      okay still no checkboxes in the staff client
18:24 nengard      poo
18:24 nengard      i was on the opac
18:24 nengard      oh damn ?
18:23 oleonard     (demo/demo)
18:23 oleonard     nengard: http://head.bibkat.no:8080/cgi-bin/koha/catalogue/search.pl?q=au:%22Lessig,%20Lawrence.%22
18:22 libsysguy    and does your AD setup bind on the DN or can it bind on the sAMAccount name
18:22 nengard      let me try one more time
18:22 nengard      yes
18:22 oleonard     nengard: The same search, with the quotes, and the URI::Escape version 3.30?
18:22 libsysguy    ok SzosszeNET, so you have an ADLDAP setup.  do you have auth_by_bind enabled
18:22 nengard      unfortunatly I don't know which one it was
18:21 nengard      so you were on the right track
18:21 nengard      yes, i think it was one of the modules I updated today
18:21 oleonard     nengard: The search that was broken before is working now?
18:21 SzosszeNET   if that answers your question
18:21 nengard      I did not update the one you said, but a test today shows that the search is doing the right thing
18:20 nengard      there were several modules that were optional that I was missing that I installed this morning
18:20 SzosszeNET   won't go into details sorry the easy way an M$ active directory domain on windows server 2003, but the operation level is 2000
18:20 oleonard     Okay nengard, I didn't understand what you said. You don't think it was the module why?
18:19 libsysguy    im sorry, I don't follow
18:18 SzosszeNET   here I did go on easy way
18:18 SzosszeNET   huhuuu :D
18:18 libsysguy    what type of LDAP setup do you have?
18:17 libsysguy    that is the file that actually does the ldap bits of authentication
18:17 SzosszeNET   libsysguy could you give some hint regarding Auth_with_ldap.pm? :)
18:09 oleonard     Hang on, afk.
18:08 drojf        rofl
18:08 wahanui      one of those is entirely extraneous.
18:08 nengard      one of those
18:08 libsysguy    I always have to go in and add my own output to Auth_with_ldap.pm
18:08 nengard      it works now and i updated a bunch of other modules today
18:08 nengard      oleonard i don't think that was the module!
18:08 libsysguy    you will probably have a hard time trouble shooting
18:07 libsysguy    sorry SzosszeNET I stepped away
18:07 nengard      okay, how do i update it using cpan? I think that's what i used to install it
18:06 oleonard     I don't know what the solution is, but I'm curious whether upgrading fixes the problem for you.
18:06 nengard      and how do i update it using cpan?
18:06 nengard      do we need to update something on the about page to make it clear that the newer version is required?
18:05 nengard      hmmm
18:05 oleonard     But there is a newer version, since I have 3.31
18:05 nengard      so it's the right version isn't it?
18:05 nengard      not highlighted in red or yellow
18:05 nengard      URI::Escape 	3.30
18:04 oleonard     I did so via the about page
18:03 oleonard     nengard: did you check your installation's version of URI::Escape?
18:00 SzosszeNET   okay, but those do not contain anything releated to login attempts...
17:59 jcamins      I think.
17:59 jcamins      SzosszeNET: the log files will be in /var/log/koha/
17:59 SzosszeNET   libsysguy any other hint? These files do not exist in my config ~/koha-dev/var/log...
17:38 SzosszeNET   ... have deb install
17:36 libsysguy    http://bywatersolutions.com/2012/07/09/koha-ldap/
17:36 libsysguy    yup
17:36 jcamins      drojf: the files outside .git are going to be a heck of a lot smaller than files in .git, though.
17:35 jcamins      drojf: then, once it's finished copying, do a git checkout [branchname]
17:35 drojf        jcamins: makes sense
17:35 jcamins      SzosszeNET: libsysguy did a blog post about configuring Koha with LDAP.
17:35 jcamins      Copy the .git folder in there.
17:35 jcamins      drojf: create a new empty kohaclone directory.
17:35 jcamins      drojf: better idea.
17:34 jcamins      SzosszeNET: I don't know much about the LDAP configuration. Other than that it's very finicky.
17:34 drojf        i think i will try at least. i cannot untar my archive of the old folder for some reason, if i have to transfer it unpacked that will take a while
17:33 SzosszeNET   how could I debug active directory ldap? I mean it's set, koha runs, but cannot login with my ad user
17:33 jcamins      Maybe.
17:33 jcamins      I suppose you might be able to restore normalcy by doing a git reset --hard after the copy.
17:33 jcamins      If you copy over .git, it will not know what you currently have checked out.
17:32 drojf        jcamins: i was afraid you would say that
17:32 drojf        or maybe i'm sane for once, make a copy of the machine before i do anything else so i can actually use something
17:32 jcamins      You should be copying the entire repo over, not just kohaclone/.git
17:32 jcamins      Ummm...
17:31 drojf        so let's break it with my old .git folder ^^
17:31 jcamins      Yay!
17:31 drojf        looks all good now
17:26 jcamins      oleonard: well, I guess that means the staff client *does* work without javascript.
17:25 jcamins      Heh.
17:24 drojf        it is working quite well for that error on my side ;)
17:24 drojf        it will be in a minute, i assume
17:23 jcamins      drojf: so it's working?
17:23 drojf        oops. seems i confused virtual machines at some point, this one has the fixed koha-conf.xml but the apache-shared-*.conf files are not fixed. my bad
17:12 jcamins      (not that I had any other ideas)
17:07 jcamins      Don't see how it could be a browser thing.
17:07 drojf        i'll try a differerent browser maybe
17:06 drojf        that's interesting
17:06 drojf        i see them too
17:05 jcamins      Odd. I see those files.
17:05 drojf        yes
17:05 oleonard     drojf: In master?
17:04 drojf        $("#header_search > ul").tabs is not a function
17:04 drojf        "NetworkError: 404 Not Found - http://192.168.1.25:8080/intranet-tmpl/prog/en/lib/jquery/jquery-ui.js"
17:04 drojf        "NetworkError: 404 Not Found - http://192.168.1.25:8080/intranet-tmpl/prog/en/lib/jquery/jquery-ui.css"
17:04 drojf        missing jquery-things
17:04 jcamins      Maybe if you click it it will tell you what the errors are?
17:03 drojf        firebug indicates a red "2" which is probably not good. now to find out where it tells me what that means
17:00 jcamins      Perhaps Paul pushed something incompatible with 8726 right before it?
17:00 jcamins      drojf: any javascript errors?
17:00 drojf        its ctrl-refresh here but that does not help. funny
16:58 jcamins      Not a Shift-refresh, though.
16:57 jcamins      Possibly a Ctrl-refresh.
16:57 drojf        yes i think i have seen it before and it was easy to get rid of
16:57 mtompset     I hate stale CSS!
16:57 jcamins      That happens to me all the time when switching between 3.6.x and master, and it's always solved by an Alt-refresh to force a reload of the CSS and Javascript.
16:56 jcamins      That's very odd.
16:56 drojf        3.8 and 3.10 actually. refreshing, clearing cache, deleting cookies… did not work.
16:52 jcamins      You switched beetween 3.6.x and 3.10.x.
16:52 jcamins      drojf: Alt-refresh.
16:51 drojf        i see four search bars instead of a tab control on the staff client mainpage from git that i just checked out. is that the code or an error in my koha-conf.xml?
16:50 cait         ah good
16:50 jcamins      Well, at some point after waking up.
16:50 jcamins      cait: when rangi wakes up he'll run updatedatabase.
16:50 cait         and back to unstable :(
16:49 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8726 enhancement, P5 - low, ---, jcamins, Pushed to Master , Did you mean? plugin for broader/narrower/related terms
16:49 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7351 enhancement, P3, ---, christophe.croullebois, Pushed to Master , ability to edit a range of holidays
16:49 jenkins_koha * jcamins: Bug 8726: add CSS to CCSR theme
16:49 jenkins_koha * jonathan.druart: Bug 8726: Followup FIX save didyoumean syspref
16:49 jenkins_koha * jcamins: Bug 8726 follow-up: fix QA issues
16:49 jenkins_koha * jcamins: Bug 8726: ExplodedTerms suggestion plugin (jQueryUI)
16:49 jenkins_koha * jcamins: Bug 8726: ExplodedTerms suggestion plugin (functionality)
16:49 jenkins_koha * christophe.croullebois: Bug 7351 : feature that allows to delete a range of dates
16:49 jenkins_koha Project Koha_master build #857: UNSTABLE in 1 hr 6 min: http://jenkins.koha-community.org/job/Koha_master/857/
16:46 SzosszeNET   thanks :)
16:45 jcamins      SzosszeNET: no, /etc/koha/koha-conf.xml is equivalent to /etc/koha/sites/groupkoha/koha-conf.xml.
16:44 oleonard     ...leading to a JS error in the ByWater demo, leading to the symptoms of the bug.
16:44 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8686 major, P5 - low, ---, oleonard, NEW , author search in staff missing checkboxes and menu
16:44 oleonard     Could Bug 8686 be caused by an older version of URI::Escape? Mine is 3.31, ByWater's demo has 3.30. The escaped output of a variable appear different for each
16:43 SzosszeNET   does /etc/koha/koha-conf.xml stand for /etc/koha/koha-conf-site.xml.in ? I don't have the first file just the second
16:41 SzosszeNET   let's see ad auth :)
16:41 SzosszeNET   than 443 and 8443 :)
16:41 SzosszeNET   okay
16:40 jcamins      You can't easily run Koha out of a subfolder.
16:40 jcamins      That's for a subdomain.
16:40 jcamins      No.
16:39 SzosszeNET   kidding "INTRASUFFIX="admin"  # For administration interface URL: Suffix to be added to the instance name. " from /etc/koha/koha-conf-sites.conf isn't for this?
16:38 jcamins      SzosszeNET: I do not think that's easily achievable.
16:38 * cait       waves
16:37 SzosszeNET   on apache2 it's quite clear that OPAC is on port 443 from now, but how do I archive to put Intranet as well to 443, but /admin ie?
16:36 SzosszeNET   :) Italy ;)
16:34 jcamins      Fun fact: at some point Isengard was ruled by a man named Luigi. I don't know if he was from Numenor or Gondor. :)
16:25 SzosszeNET   anyway no problem, I'm already playing with the apache conf ;)
16:25 SzosszeNET   yep, but created the file based on the install tutorial, than went for the db init, but I don't feel that file was used to with my implementation it's not neccesary - however cannot explain why :D
16:23 jcamins      Ever since you started talking to me, though, there hasn't been any point in editing that file. You already created the instance.
16:23 jcamins      Which may be your problem.
16:22 jcamins      It's always worked for me. Though the file is actually /etc/koha/koha-sites.conf.
16:22 SzosszeNET   probably I need to calm down I do what I hate - read admins manual :D
16:21 SzosszeNET   okay, but what's in there was not used at all :D
16:21 jcamins      Once you've created an instance, you need to edit the Apache site file.
16:21 jcamins      That's just for creating new instances.
16:20 SzosszeNET   hmm just realized that /etc/koha/koha-conf-sites.conf - what I put in it does not matter? :D
16:19 oleonard     You'd think by now I'd recognize commit 77b64098, the black hole of template commits.
15:58 oleonard     ...among other omniscients.
15:58 SzosszeNET   :)
15:57 * oleonard   wants to be template-omniscient
15:57 jcamins      oleonard: me too.
15:57 oleonard     Guh, I hate running across a dumb change to the template and finding out it happened 3 years ago and I just didn't notice
15:56 SzosszeNET   oh no, the disable of the default site did solve my issue ;)
15:55 jcamins      In that case, it sounds like there's an extra period or something in the site file. You can just open that up and edit it.
15:55 SzosszeNET   I do ;) I accessed fqdn:8080
15:53 jcamins      The easy solution is to run `sudo a2dissite default` and `sudo apache2ctl restart`
15:53 jcamins      SzosszeNET: probably you don't have DNS set up yet?
15:53 SzosszeNET   hmm, so port 8080 works, but 80 just gives "It works" but there should be opac, no?
15:43 mtompset     Shoot... I think we need to update the ubuntu .packages files. They don't have unzip.
15:43 jcamins      Well, darn. There goes that theory.
15:43 oleonard     jcamins: Off, same as in the ByWater demo
15:42 jenkins_koha Starting build #857 for job Koha_master (previous build: FIXED)
15:42 * mtompset   nods.
15:42 jcamins      oleonard: do you have UseICU turned on or off?
15:41 jcamins      Only in a sample cron script.
15:41 mtompset     ./misc/cronjobs/social_data/update_social_data.pl
15:41 mtompset     It's referenced in the code.
15:40 jcamins      mtompset: that's something else.
15:40 mtompset     bunzip2?
15:40 mtompset     There it is... unzip.
15:39 jcamins      mtompset: just unzip, I think.
15:39 mtompset     both, or just one of them?
15:39 SzosszeNET   :D
15:38 * oleonard   visited Bratislava, stayed at a YMCA which had a movie theater on the ground floor
15:38 jcamins      mtompset: yes.
15:38 mtompset     jcamins: Did you mention the other day that zip or unzip were required from some functionality in Koha?
15:37 jcamins      My wife really likes Tallinn, too.
15:37 SzosszeNET   they are also lovely if speaking about capitals
15:37 jcamins      We'd like to take a trip to Bratislava and Vienna.
15:37 SzosszeNET   Vienna
15:36 SzosszeNET   well, check Bratislava
15:35 SzosszeNET   :D
15:35 jcamins      I don't drink whiskey, but I studied in Edinburgh and it's my second-favorite city in the world (after Budapest, obviously;).
15:35 SzosszeNET   how small the world is huh? :)
15:35 SzosszeNET   cause of the Scotch? :D
15:35 mtompset     And while we're all talking about nationalities and locations. I'm a Canadian in the Philippines. :P
15:34 * jcamins    loves Scotland!
15:34 SzosszeNET   I live in Scotland ;)
15:34 jcamins      New Jersey... about an hour and a half from New York, where we live now.
15:33 SzosszeNET   and might I ask where are you from?
15:33 SzosszeNET   wow :)
15:33 jcamins      Nope. She's from rural Virginia, actually.
15:33 SzosszeNET   :D
15:33 SzosszeNET   hmm and she's not Hungarian?
15:32 SzosszeNET   I'm not distracted :)
15:32 * jcamins    met his wife in Budapest.
15:32 SzosszeNET   :D
15:32 mtompset     got to love morphological differences which hide the phonological reality.
15:32 jcamins      Anyway, I didn't mean to distract you from Koha. :)
15:31 jcamins      :)
15:31 huginn       New commit(s) kohagit: Bug 8726: add CSS to CCSR theme <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=eb6effd2c2eaf26c5aff80cb1f45e75a5fcf426f> / Bug 8726: Followup FIX save didyoumean syspref <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b5659f64255d8801f2afbcde6d172c493ac4e683> / Bug 8726 follow-up: fix QA issues <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=52f54eec1da5e60f3e211844c2336e6
15:31 jcamins      SzosszeNET: I think I need to practice if I want to say "sasszem" without switching it to "saszsem"
15:31 mtompset     That's not as hard, because you started with the same sound.
15:30 SzosszeNET   ie sasszem where sas+szem (eagle+eye)
15:30 SzosszeNET   anyway that case s an sz are pronounced separately
15:29 SzosszeNET   hmm :) well Hungarian langue likes joining existing words, but ie English does not really like it - so interesing thingking ;)
15:28 mtompset     considering the word started with sz.
15:28 mtompset     That's a tongue twister too.
15:28 jcamins      It's good. Now I know that 'ssz' in Hungarian is pronounced 'szsz'! :)
15:28 mtompset     What if it were really ssz and not sz-sz?
15:28 SzosszeNET   hiss ;)
15:27 SzosszeNET   sorry for it :)
15:27 SzosszeNET   the normal letter is sz, but if its doubled would be szsz, but our beutiful grammar tells that it's not correct form, it should be written as ssz
15:27 * jcamins    kept on trying to say it "Szos'sze" and getting his tongue tangled up.
15:26 SzosszeNET   the ssz is a double sound
15:26 SzosszeNET   oh, yes :)
15:25 SzosszeNET   and of course tell to translator to pronounce :)
15:25 reiveune     bye
15:25 jcamins      I don't speak any Hungarian, alas. Well, other than "Koszonom."
15:25 SzosszeNET   quite robot, but if you set google translate to hungarian it's almost :)
15:24 SzosszeNET   hmm like the s in sea?
15:24 SzosszeNET   Jcamins yes Hungarian ;)
15:23 * jcamins    figured it out, never mind.
15:20 jcamins      Much easier.
15:17 mtompset     the koha_ prefix makes scripting for db's easier. :)
15:17 jcamins      How do you pronounce your nick? It looks like Hungarian, in which case 'sz' would be pronounced like /s/ in English, but the "ssz" is throwing me off.
15:15 SzosszeNET   okay
15:15 SzosszeNET   :D
15:15 SzosszeNET   I mean groupkoha user is quite right for me :)
15:15 jcamins      SzosszeNET: you could, by simply changing koha-conf.xml, but don't.
15:14 SzosszeNET   and is there any possibility to get rid of the koha_ prefix? :)
15:14 SzosszeNET   so I'll reinstall anyway
15:14 SzosszeNET   anyway I'm playing with koha at the moment and explorering it
15:14 SzosszeNET   okay
15:13 jcamins      Usually.
15:13 jcamins      SzosszeNET: I run a script to create the DB and stick the password into my /etc/koha/passwd file, then use --use-db.
15:11 SzosszeNET   than what would be than the good way for remote db setup?
15:09 SzosszeNET   hmm
15:09 jcamins      But then usually I don't use koha-create directly to create databases on remote servers.
15:08 jcamins      SzosszeNET: I'm not sure what exactly happened... usually that just works for me.
15:07 SzosszeNET   not a complaint, just want to know about koha :)
15:07 SzosszeNET   now I changed the /koha-conf.xml to use the db user I created and seems ok ;)
15:07 SzosszeNET   also to the db - and seems can't work with them with modification...
15:06 jcamins      Right.
15:06 SzosszeNET   koha creates koha_ prefixed ones
15:06 SzosszeNET   don't understand something : define my host,user under /etc/mysql
15:06 jcamins      SzosszeNET: are you able to login using mysql from the command line on the Koha server?
15:05 SzosszeNET   jcamins : grr...
15:05 jcamins      SzosszeNET: these things bear repeating... you'd be surprised how many people make that mistake.
15:04 jcamins      SJeffery: nope, you just won't get the data from the new 3xx fields showing up.
15:04 SzosszeNET   not stupid just noob to koha :D
15:04 jcamins      So, uh, you're going to change those passwords now, right?
15:04 SJeffery     Will importing RDA records actually break anything or cause any weird display issues?
15:04 jcamins      Okay, you figured that out. :)
15:03 SzosszeNET   under serverinfo found in the xml :  <user>koha_groupkoha</user>  <pass>geidochi</pass>
15:03 * jcamins    thinks he didn't.
15:03 jcamins      SzosszeNET: did I tell you that you have to make sure to set the password to match the *last* password in that file?
15:02 SzosszeNET   jcamins : nope...
15:02 * jcamins    is generally the one dealing with MARC21 standard issues, and I'm not getting a whole lot of interest in RDA yet.
15:01 jcamins      SJeffery: unfortunately, that is pretty much accurate.
15:00 SJeffery     So what is the word on Koha RDA records support? From the RFC on the wiki and the lack of tickets it seems as though there is zero support?
14:58 jcamins      Most likely all you need to do is set the password for 'koha_groupkoha'@'%' to match the automatically generated password in /etc/koha/sites/groupkoha/koha-conf.xml
14:58 SzosszeNET   is it?
14:58 jcamins      Right.
14:58 SzosszeNET   brilliant :)
14:57 SzosszeNET   "Access denied for user 'koha_groupkoha'@'groupkoha01.domain.group' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 758."
14:57 jcamins      Okay, so you are further along than I realized.
14:57 SzosszeNET   and wow, now I have "Software error:" on port 8080 :)
14:56 SzosszeNET   and it did call that db created the users
14:56 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8843 normal, P5 - low, ---, oleonard, Needs Signoff , Cannot export bibliographic records by call number
14:56 oleonard     Bug 8843
14:55 SzosszeNET   defined in /etc/mysql/koha-common.cnf
14:54 jcamins      SzosszeNET: I thought you said you had MySQL on a different server?
14:54 jcamins      In that case, I suggest that you use HTTP for the configuration.
14:54 SzosszeNET   have to sql errors : ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for
14:54 SzosszeNET   issued koha-create --use-db groupkoha
14:53 SzosszeNET   strange, just reverted to a minimal setup snapshot
14:53 SzosszeNET   that's the last task for me :) First I want to make koha work
14:53 SzosszeNET   no, I don't have certificate yet
14:52 jcamins      But you already have a certificate, I presume, so you can just enable HTTPS and carry on.
14:50 jcamins      The instructions walk you through doing a standard install using HTTP. Setting up HTTPS is a site-specific thing.
14:50 jcamins      Right, it's listening on 443, but you have to set up the virtual host to actually use that port.
14:50 SzosszeNET   the web installer is supposed to run on 8080 right?
14:49 SzosszeNET   accoring to /etc/apache2/ports.conf  it does listen on 443
14:48 jcamins      And you'll need to edit the Apache config file to adjust it to use HTTPS.
14:47 jcamins      SzosszeNET: you have to run through the web installer to initialize the database.
14:47 SzosszeNET   well, nor the db is populated (it's empty) :) An nothing on port 8080 or 443 (wish to run it on https)
14:46 jcamins      Okay, where did you run into problems?
14:44 SzosszeNET   however in my case http://wiki.koha-community.org/wiki/Install_Koha_3.6_on_Debian_squeeze_using_a_separate_MySQL_server was also needed
14:44 SzosszeNET   sure :)
14:44 jcamins      Are you following those instructions?
14:44 jcamins      Those are the best instructions to follow.
14:43 jcamins      There we go.
14:43 wahanui      somebody said packages was at http://wiki.koha-community.org/wiki/Debian
14:43 jcamins      packages?
14:43 wahanui      i heard debian was what most people use and there are good manuals and even packages for that
14:43 jcamins      debian?
14:43 SzosszeNET   could someone point me the right direction?
14:43 jcamins      Not that I know where that bug might be.
14:43 SzosszeNET   Hi guys, sorry I'm totally new to Koha and want to install it to debian (with separate mysql), but seems I'm lost an looping...
14:41 jcamins      Exporting records using *biblionumber* range worked.
14:40 jcamins      Didn't I file a bug about that?
14:40 jcamins      wait.
14:40 jcamins      ummm...
14:40 jcamins      The last time I tested was...
14:40 jcamins      oleonard: I believe you.
14:40 oleonard     I contend that exporting records using a call number range does *not* work.
14:37 wahanui      hmmm... manual is at http://www.koha-community.org/documentation
14:37 jcamins      manual?
14:33 mtompset     good
14:33 wahanui      packages is at http://wiki.koha-community.org/wiki/Debian
14:33 mtompset     but packages?
14:33 mtompset     But packages is good. :)
14:33 mtompset     Still working on the git/tarball instructions.
14:32 wahanui      ubuntu instructions are at http://wiki.koha-community.org/wiki/Ubuntu
14:32 mtompset     ubuntu instructions?
14:32 wahanui      ubuntu is probably a debian-based OS and Koha has shiny new ubuntu intructions.
14:32 mtompset     ubuntu?
14:31 mtompset     what?
14:31 wahanui      mtompset: wish i knew
14:31 mtompset     wahanui: what is a bugger?
14:31 wahanui      oleonard: bugger all, i dunno
14:31 oleonard     wahanui: How do you spell acccommmodate?
14:31 oleonard     Does wahanui do spell check too?
14:30 jcamins      mtompset: yes. wahanui is providing me with the links that I want to put in an e-mail.
14:30 mtompset     Is there a method to your madness, jcamins?
14:29 wahanui      well, install.debian is at git.koha-community.org/gitweb/?p=koha.git;a=blob;f=INSTALL.debian
14:29 jcamins      install.debian?
14:29 wahanui      i think git is http://wiki.koha-community.org/wiki/Version_Control_Using_Git
14:29 jcamins      git?
14:26 wahanui      somebody said jquery library was found at http://wiki.koha-community.org/wiki/JQuery_Library
14:26 jcamins      jquery library?
14:26 oleonard     Hm, okay.
14:26 jcamins      oleonard: it did when I was playing with the export functionality.
14:25 wahanui      it has been said that packages is at http://wiki.koha-community.org/wiki/Debian
14:25 jcamins      packages?
14:25 oleonard     It doesn't for me
14:25 oleonard     does exporting records using a call number range not work?
14:22 mtompset     If you read this Paul, you have a reputation. Sorry.
14:22 * mtompset   laughs, "Paul."
14:22 * jcamins    knows someone who could probably manage. :P
14:21 mtompset     Won't accidentally forget to copy it.
14:21 mtompset     Yes, but a script is still in the DB, if you swap it to a new machine.
14:21 jcamins      I put a script on the wiki which requires different code between 3.8 and 3.10.
14:20 jcamins      And where it's not perfect, it's still not too bad.
14:20 waylon       gone.
14:20 waylon       will havta talk to you guys about it later, yup
14:20 jcamins      Yup.
14:20 * mtompset   coughs, "Paul."
14:19 jcamins      A lot better than template modifications, though.
14:18 jcamins      Mostly.
14:17 mtompset     They advantage of jquery is... it will upgrade nicely in the future. ;)
14:17 oleonard     This community is awesomely international.
14:17 waylon       laters all.
14:17 waylon       and it pays to take it carefully.
14:17 waylon       yea... long road ahead of me.
14:17 oleonard     Ah, thanks :)
14:16 wahanui      well, waylon is the 33rd developer of Koha, currently working for Mandumah.com, a digital library archive. Hes currently porting koha 3.0 modifications to Koha 3.10.
14:16 waylon       waylon?
14:16 waylon       www.mandumah.com
14:16 oleonard     mandumah?
14:16 waylon       night all!
14:16 waylon       okay, sleep time.
14:15 * waylon     hopes that the designer doesn't make my life a living hell.
14:15 waylon       and yea, i guess i could overwrite using jquery, the dropdown, hooking in the multi, for mandumah's templates.
14:14 jcamins      Yes.
14:14 waylon       right. advanced search then.
14:13 jcamins      Adding another would be a bit much.
14:13 jcamins      waylon: but regular dropdown controls allow only a single choice. Also, we already have that.
14:13 waylon       ah
14:13 mtompset     Yes, but multiple choice in the masthead is not something most people would do.
14:13 waylon       the options there for it syspref.. and the template already shows it.
14:12 jcamins      If you needed it for Mamduha (sp?), you could jQuery it into existence.
14:12 waylon       jcamins, thought a dropdown already exists in the masthead?
14:12 jcamins      It's not something that would be used very frequently at all.
14:12 oleonard     waylon: Yeah, at this point I would still say that the main search bar should not include any more-complex controls.
14:12 jcamins      waylon: I think a dropdown in the masthead would be unnecessary complexity.
14:10 tcohen       mtompset: will make the script to print the full command the user should execute as mtj suggested on the email
14:10 waylon       multibranch mode adds ability to search more than one specific branch at a time. Allows users to be assigned multiple branches. And with the new security option im adding, only those assigned branches.
14:09 nengard      got it
14:08 jcamins      "If your authority records include 5xx fields with linked references to broader and/or narrower terms..."
14:08 oleonard     I don't know how you define "multibranch mode"
14:08 nengard      jcamins - where exactly? or just in general?
14:08 waylon       if its multibranch mode (which im adding) why not dropdown a multibranch selector?
14:07 oleonard     (to be perfectly redundant :P )
14:07 jcamins      nengard: perhaps you could say "... with linked broader and narrower see also references."
14:07 oleonard     Yes, and adding more complexity to that, in the form of some kind of multi-branch selection widget, would make it more complex
14:07 waylon       oleonard, hmm? the main search bar already includes a branch dropdown.
14:06 tcohen       the difference is that it cannot choose one or the other arch and proposes not to install :-D
14:06 oleonard     waylon: Because the main search bar (in my opinion) should remain simple
14:05 tcohen       mtompset, it appears to have a similar problem
14:05 waylon       oleonard, why do you say that?
14:03 mtompset     attempt a sudo aptitude install
14:03 tcohen       yes, thats what I was trying
14:03 mtompset     instead of sudo dselect...
14:03 mtompset     Yes, I think it does.
13:59 mtompset     does aptitude use the dpkg --set-selections?
13:59 mtompset     Hmmm....
13:57 tcohen       Read the pre-last comment http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=664893
13:56 mtompset     which doesn't solve our problem now.
13:56 mtompset     Hopefully, they'll have fixed this problem when Wheezy comes out.
13:56 mtompset     Well, here's the thing... Debian is going multiarch with Wheezy.
13:51 tcohen       unmaintained softwar ein the archive is not worth it"
13:51 tcohen       a very long time, probably until someone decides that keeping an
13:51 tcohen       *maintain* dselect, so I suspect this bug report to remain opened for
13:51 tcohen       D'oh: "Unfortunately, there doesn't seem to be many people wanting to
13:49 tcohen       maybe it will be the same amount of time this discussion will take
13:49 tcohen       i'll try to see what can be done on the dselect front
13:49 mtompset     Perhaps we should create a documentation page on dealing with multiarch?
13:47 mtompset     Yes, I saw the bug. :(
13:47 tcohen       there's a bug on that
13:47 mtompset     the location of the multiarch files and how it is done will change.
13:47 tcohen       yes, dselect prefers foreign architecture over native
13:46 mtompset     From what I've been googling around...
13:46 mtompset     The problem is this multiarch stuff is in flux.
13:46 tcohen       yes...
13:46 mtompset     and I assume dpkg --print-architecture says amd64?
13:45 tcohen       yes
13:45 mtompset     if you rename the file, the dselect stuff works, right?
13:44 tcohen       dpkg.cfg.d/multiarch: foreign-architecture i386
13:44 tcohen       yes, it has multiarch enabled
13:43 mtompset     Have you looked in /etc/dpkg/dpkg.conf.d?
13:43 mtompset     I'm curious...
13:43 tcohen       hi mtompset
13:42 mtompset     Greetings, tcohen.
13:41 tcohen       we can leave it like it is now too
13:40 tcohen       mtj, what do u want me to do for that dselect issue?
13:36 kf           and now I am gone :)
13:36 kf           oleonard++
13:36 oleonard     If someone implements multi-branch search options please do it on the advanced search page and not the main search bar
13:31 drojf        uuh exciting :)
13:31 drojf        ah, there it is :) thanks
13:31 drojf        .
13:30 kf           drojf: left you a message
13:24 huginn       kf: The operation succeeded.
13:24 kf           @later tell drojf I sent a school library in berlin to the koha users list where your entry is...
13:13 nengard      nevermind
13:10 nengard      can someone test to see if opachiddenitems is working in master ?  it doesn't appear to be working for me
13:10 mtompset     a problem encountered by tcohen, and ranted about by slef. ;)
13:09 mtompset     No... the dselect installing i386 libraries on an amd64 OS.
13:09 waylon       jquiery isn't multi-arch?
13:09 mtompset     Hmmm.... I have a gut feeling that isn't quite right. But since I am trying to hunt for multi-arch solutions... I can't help.
13:08 waylon       sounds good?
13:07 waylon       dropdown checkbox list yes?
13:06 waylon       yup
13:06 mtompset     DropDown's are only single choice (as far as I know), but lists can multi-choice. This means the dropdown would probably need jQuery to give the appearance of multiselect. ;)
13:05 nengard      I don't know why it's the way it is
13:05 nengard      and so would a lot of libraries
13:05 nengard      I'd love multi-choice
13:02 waylon       ?
13:02 waylon       kf nengard... current branch options in searches, are searching one branch only, or all. Why not instead, a multichoice dropdown? would have to be jQuery right/
12:32 kf           yeah I agree
12:32 kf           ah right
12:32 kf           it's crazy busy here today
12:32 kf           yep I think I do agree with the updatedatabase thing :)
12:31 paul_p       kf= it does, and you agree with my proposal ;-)
12:27 kf           hope it makes more sense now
12:26 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5335 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , More granular VAT
12:26 wahanui      i guess bug 5335 is guilty I think
12:26 kf           bug 5335
12:26 kf           paul_p: I tried to explain myself on 5535
12:26 kf           yay
12:26 paul_p       yeah ! jenkins back to stable !
12:17 mtompset     I'm reading the Changes for DateTime... Don't we use DateTime::Event::Recurrence?
12:11 nengard      jcamins I also finished the hierarchy bit for authorities: http://manual.koha-community.org/3.10/en/administration.html#AuthDisplayHierarchy
12:10 huginn       nengard: The operation succeeded.
12:10 nengard      @later tell mveron the age restriction info is in the manual if you want to review that I wrote it up right: http://manual.koha-community.org/3.10/en/administration.html#AgeRestrictionMarker
12:06 kf           phased out means it's not gone yet
12:05 kf           well
12:05 mtompset     Not fully.
12:05 kf           mtompset: I think that is because it's phased out
12:02 mtompset     It doesn't use DateTime.
12:01 mtompset     (3.8.5)
12:01 mtompset     Oh yuck... I just read C4::Dates.pm
11:56 mtompset     Yes, vaguely.
11:56 slef         but I think that was a simple pre-overloading DateTime version used on that server
11:55 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8738 major, P5 - low, ---, koha-bugs, Signed Off , DateTime object being compared to a date string in circulation
11:55 slef         mtompset: bug 8738 ?
11:51 mtompset     "Fixed bug RT#47929 which caused the XS Stash to die mysteriously when calling code that used string evaluation (e.g. DateTime)." -- This sounds related to a patch I saw, but fixed Koha, not DateTime.
11:43 magnuse      and in the irc logs for that matter :-)
11:42 mtompset     Ah.
11:42 magnuse      like we have in result lists in the opac, and lots of other places
11:42 jcamins_away mtompset: rows alternating white and gray. It's called zebra-striping.
11:41 mtompset     Any one know what jcamins_away meant by "zebra-striping tables"? http://irc.koha-community.org/irclog/koha/2012-09-25#i_1087692
11:40 kf           but you fixed it
11:39 mtompset     What was that quote about using the sharpened bones to do something?
11:37 kf           crazy day
11:36 slef         kf: it's 1330, not had lunch yet?
11:36 kf           no lunch for me again
11:36 kf           wah
11:36 slef         magnuse: oh, so saluting like that is just a joke to you?  That's sort of inappropriate.  Next you'll be making jokes about kitten kebabs on amputated limbs!
11:35 * magnuse    is definitely not right wing :-)
11:35 slef         :)
11:34 druthb       :P
11:33 magnuse      oops?
11:33 slef         druthb is left-wing saluting, magnuse is right-wing?
11:33 magnuse      \o
11:32 druthb       o/
11:32 magnuse      slef: true
11:32 slef         Yeah, but there's stuff that's easier to change than gov.no, like who you buy from.
11:31 magnuse      well maybe not "only", but not far from it
11:30 magnuse      yup
11:30 mtompset     because the norwegian government only uses Windows machines?
11:29 magnuse      mtompset: all levels of norwegian government are paying them a ton of money each year, out of my tax money
11:29 mtompset     magnuse: how so?
11:24 kf           jcamins_away: ping me when you are around?
11:17 * magnuse    is indirectly paying ms lots already...
11:17 slef         magnuse: your current registrar is a Microsoft Gold Partner
11:16 magnuse      slef: how does that work?
11:15 slef         magnuse: well, if you like paying Microsoft indirectly...
11:14 magnuse      slef: you can try, but for now i will stick with the comfort of the one i have :-)
11:13 slef         magnuse: can I interest you in transferring to a friendly registrar? ;)
11:10 mtompset     Overheating issues?
11:09 drojf        the other with 3.8.5 is working nicely ;)
11:09 drojf        more blew up the sd-card really
11:07 mtompset     But drojf, you blew up your git. ;)
11:07 mtompset     As long as it isn't no.koha ;)
11:06 * magnuse    renews koha.no
11:04 drojf        maybe i should instead go and get a raspberry pi for everybody
11:04 drojf        ah i see. don't really know yet
11:03 mtompset     because early November for me is bad.
11:03 mtompset     when would this be?
11:03 drojf        thanks, that might be helpful, i may get back to you about that
11:01 mtompset     If you make it, and put it somewhere where I can sftp it or get it somehow, I can give it a whirl.
11:00 drojf        would still not have a windows to try then, but yes, i hope to know what they will be bringing
11:00 mtompset     Can't you get participants to tell you in advance?
10:59 drojf        :/
10:59 drojf        i suppose all people that would want to use a prebuilt vm would have windows. i dont have one to try that though
10:59 drojf        thats another problem, i would not know what hosts other people bring. uah.
10:59 mtompset     windows as host is a different monster.
10:58 drojf        yes
10:58 mtompset     Oh, debian as host?
10:58 drojf        4.1.18_debian somethingsomething
10:57 wahanui      which version is, like, recommended
10:57 mtompset     which version?
10:57 drojf        works with wifi fine here. also worked in ediburgh in the guest house, but not at the university
10:57 mtompset     WITHOUT...
10:57 mtompset     What if you have someone with a wired connection?
10:57 mtompset     But you can only do that on a wired connection.
10:56 drojf        i think anything besides network bridge is not feasible for a workshop. i don't really want to deal with vb there
10:55 mtompset     (of the virtualbox software)
10:55 mtompset     The IP address for the host-only interface would get messed up on an upgrade.
10:54 mtompset     Oh, which reminds me of another typical problem I encountered.
10:53 drojf        meh that virtualbox networking needs reading i guess. *put on pile of things to do later*
10:53 mtompset     as I was saying... though, if someone is doing a git install, it would be nice to support 10.04 LTS
10:52 mtompset     (without CPAN)
10:51 mtompset     That makes debian git installs possible again. ;)
10:51 magnuse      \o/
10:50 drojf        yee-ha!
10:50 mtompset     Sweet! my patch made it in. :)
10:50 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5335 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , More granular VAT
10:50 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8659 normal, P5 - low, ---, pelletiermaxime, Pushed to Master , Inactive funds in neworderempty not disabled in IE/Opera
10:50 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8702 normal, P5 - low, ---, fridolyn.somers, Pushed to Master , System preferences search does not allow accented letters
10:50 jenkins_koha * Paul Poulain: Bug 5335 follow-up fixing template
10:50 jenkins_koha * Paul Poulain: Bug 5335 follow-up fix test
10:50 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8780 major, P1 - high, ---, mtompset, Pushed to Master , Lower dependency version for DateTime::TimeZone
10:50 jenkins_koha * maxime.pelletier: Bug 8659 Remove and readd the inactive funds in javascript to make it work in all browsers
10:50 jenkins_koha * fridolyn.somers: Bug 8702: System preferences search does not allow accented letters
10:50 jenkins_koha * mtompset: Bug 8780 - Lower dependency version for DateTime::TimeZone
10:50 jenkins_koha Project Koha_master build #856: FIXED in 1 hr 7 min: http://jenkins.koha-community.org/job/Koha_master/856/
10:50 mtompset     Though, if someone is using git....
10:50 jenkins_koha Yippie, build fixed!
10:49 mtompset     But if someone is going to install packages, the instructions tell them to use 12.04
10:49 drojf        in that case it would probably be fair to thik about it ;)
10:49 mtompset     3 years for DESKTOP editions.
10:49 drojf        yes i just read
10:49 mtompset     It's 5 years for SERVER editions.
10:48 drojf        -1 for supporting 10.04. i would rather concentrate on future LTS versions on top of 12.04. it is 3 years LTS, right? or 5? in that case i would reconsider
10:47 mtompset     HTTP::OAI Locale::Currency::Format PDF::API2::Simple Text::CSV::Encoded DateTime DateTime::TimeZone Template
10:46 mtompset     BTW, in order to support Ubuntu 10.04, we'd need 7 perl libraries.
10:46 drojf        i guess they worked hard on their reputation
10:44 mtompset     I guess talking about LL here is like politics and religion in a generic public conversation.
10:43 waylon       ah... not important i guess.
10:43 waylon       head devel liblime?
10:42 waylon       whos the guy who signed all the liblime commits?
10:42 mtompset     Yikes!
10:42 wahanui      liblime is no brandcuffs
10:42 waylon       wahanui, liblime?
10:42 drojf        ouch
10:42 waylon       wow.
10:41 waylon       wahanui, ptfs?
10:40 mtompset     I can feel the LL love.
10:40 drojf        love it :D
10:39 kf           drojf: what about bibliorange?
10:38 kf           drojf: don't joke about things like this... serious business.
10:36 mtompset     Now we just have to wait for Google to forever keep that on record.
10:35 mtompset     Yes, Paul, I mean you.
10:35 mtompset     I was thinking Paul might read it and try something stupid.
10:35 mtompset     Bah... Forget this... I'm going to go on record with this.
10:34 mtompset     [off] I was thinking Paul might read it and try something stupid.
10:32 mtompset     As seen in our latest posting from a gentleman who was reading a CentOS thread regarding Zebra.
10:32 mtompset     Yes, well, some people obviously try everything before they ask for help.
10:17 * slef       chuckles as he spots an old mail from mtompset with "PLEASE DON'T JUST TRY THIS BECAUSE YOU HAVE A PROBLEM. This is the WRONG solution."
09:52 mtompset     At least your poor health hasn't drained your humour. :)
09:52 slef         biblioubliette - releases a fork and then "throws it over the wall" as abandonware, claiming it's open source really.
09:51 drojf        see, that are things i think about when i cannot sleep ;)
09:51 mtompset     drojf: You're hilarious.
09:51 * mtompset   laughs.
09:50 drojf        kf: what about biblimette or bibliomette as a name for a future company? maybe with a nice german closed source fork ;)
09:49 mtompset     slef++ # for being a paranoid security freak. :)
09:49 drojf        heh that reminds me
09:46 slef         I love being mailshotted with job adverts, too.
09:45 slef         [off] "PTFS, a privately owned, Maryland-based company providing digital archiving and library solutions, as well as professional services including digitization, library staffing, and integration services" - yeah, they're really into FOSS aren't they? Emphasised it in that description, didn't they?
09:44 magnuse      fingers crossed!
09:43 drojf        go jenkins_koha
09:43 jenkins_koha Starting build #856 for job Koha_master (previous build: STILL UNSTABLE -- last SUCCESS #853 6 days 23 hr ago)
09:36 huginn       New commit(s) kohagit: Bug 5335 follow-up fixing template <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8e7df043013f161566c074e97f31b203f373c68d> / Bug 5335 follow-up fix test <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=bee6c8136ff9ec81a7cde1e497e01d527f259de5> / Bug 8659 Remove and readd the inactive funds in javascript to make it work in all... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdif
09:35 mtompset     checking email now, slef.
09:34 slef         some ideas for possible ways out near the end, though
09:34 * slef       replies to mtompset with a pretty rant
09:33 * mtompset   says a little prayer for jenkins' build.
09:30 paul_p       keep finger crossed, jenkins should be happy with this push...
09:30 drojf        i will go with haveing the ip and 80 for opac, 8080 for staff client to avoid any further networking stuff that would be special for each one. if there should really be sysadmins of libraries that work on their own servers, they will know what to do with a little explanation
09:28 mtompset     The IT Department of the organization should be able to makes sense of the instructions and get it working for their library colleagues.
09:27 mtompset     So sadly, the instructions are best aimed at someone with intermediate computer experience.
09:27 mtompset     Trying to explain networking to someone with no networking experience is impossible to do.
09:26 mtompset     The problem is... it will be called library.framisdooby.org
09:26 mtompset     If you actually only do what are in the text boxes, you will get a working system.
09:26 drojf        makes sense
09:26 mtompset     I tried to make the Ubuntu instructions as simple as possible.
09:25 drojf        out of the scope of what i plan to do, but would be good for those with zero linux knowledge
09:24 mtompset     These would be identical for packages under Debian.
09:23 mtompset     http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Uninstall_Instructions
09:23 tweetbot`    [off] twitter: @paul_poulain: "@samuel_v2 #kohails va bien (c'est le hashtag à utiliser). Et BibLibre aussi, on est "un peu" surbookés..."
09:23 mtompset     http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Upgrade_Instructions
09:23 mtompset     That's really the only difference between an ubuntu and debian install. Though, I have details a few more pieces, which I thought were lacking in the Debian Guide.
09:22 drojf        a yes this exactly *adds bookmark* thanks
09:21 mtompset     http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_MySQL_Security_Tweak
09:20 mtompset     Yes, the security tweak section.
09:20 drojf        i think there was some crazy mysql stuff that i should tell people though
09:19 drojf        mtompset: i had to use the debian instructions actually because that is what i would be using at the workshop, also supporting ubuntu only if it works with them. i have seen that the ubuntu page got much smaller though, have not looked at it yet
09:19 mtompset     or was this a based on your experience install, drojf?
09:18 * mtompset   waves at Oak_
09:18 Oak_         mtompset :)
09:18 magnuse      Oak_
09:18 Oak_         magnuse
09:18 Oak_         hello kf :)
09:18 mtompset     when did you follow the instructions?
09:17 drojf        installation with packages on ubuntu 12.04 worked nicely btw, not that it would surprise anyone, but i never tried it myself
09:16 mtompset     more sleep is always good when you aren't on your top game.
09:16 mtompset     Good idea.
09:16 drojf        more sleep would probably be enough, somehow that does not work. i avoided coming back here around 3 or 4 am this time though ;)
09:15 mtompset     I'm working on the tarball/git instructions for ubuntu right now.
09:15 mtompset     sorry to hear that. Hope you feel better quickly.
09:14 drojf        still feel flu_ish and weird, just got up (11am), not really functional
09:14 mtompset     NAT = updates, host only = data entry.
09:14 mtompset     Otherwise you can't do updates.
09:14 mtompset     nat is fine, but you need to complement it with a host only.
09:14 drojf        also i have not played with nat really
09:13 drojf        mtompset: a lot of debians and an ubuntu. the koha git thing needs some work so i can finally use it again though
09:13 mtompset     By the way, "Ah that spammer" nice way to leave the channel. ;)
09:12 mtompset     base install... DOH.
09:12 drojf        hi mtompset and kf :)
09:12 kf           hi drojf
09:12 mtompset     As I was working on my VM's. I was wondering if you had your base isntall of a Debian VM set up now. :)
09:11 mtompset     drojf: i was just thinking about you. ;)
09:11 drojf        good day #koha
09:08 mtompset     on Windows. ;)
09:08 mtompset     My poor netbook... straining at 90% physical memory use for two 512 Koha VMs.
09:06 kf           Oak: Oak
09:03 mtompset     Greetings again, Oak
09:03 kf           hi magnuse
09:02 magnuse      Oak
09:02 magnuse      hiya kf
09:00 kf           hi mtompset
09:00 kf           hi mtom
09:00 mtompset     Greetings, kf.
08:59 kf           good morning #koha
08:59 mtompset_    Nope... this isn't it. ;)
08:58 mtompset     mostly due to bad instructions on the internet, because people don't spend the effort to find the official channels.
08:58 mtompset     any script we provide (/usr/sbin) could be mailicious replaced on a "mirror" site.
08:57 waylon       man in the middle attack of koha?
08:35 mtompset     slef: By the way, I do agree that we need to be worried about a man in the middle attack, but we already have the potential for that in our existing scripts.
08:33 mtompset     Not me today. :)
08:32 slef         mtompset: oh, I thought you were playing yoyos.
08:31 mtompset     I quit and rejoined, just to see if it was me at irc.oftc.net
08:30 slef         one
08:30 slef         or maybe on server went down
08:30 slef         over half an hour ago
08:30 slef         yeah between synthon.oftc.net and graviton
08:29 mtompset     I think there was a server split or something for irc.
08:29 paul_p       hello #koha
08:29 mtompset     Bonjour, paul_p.
07:47 mtompset     Git and tarball still need cleaning up a bit.
07:47 mtompset     Packages is good.
07:47 mtompset     Working on cleaning up my split instructions.
07:46 mtompset     That has been stalled.
07:46 huginn       04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=459 enhancement, P4, ---, mtompset, In Discussion , No uninstall script
07:46 Oak          :)
07:46 wahanui      mtompset is working on the ultimate koha uninstall script for fun. Bug 459. Old school, baby!
07:46 Oak          mtompset
07:46 Oak          magnuse
07:45 mtompset     Good enough.
07:45 wahanui      ubuntu instructions are at http://wiki.koha-community.org/wiki/Ubuntu
07:45 mtompset     ubuntu instructions?
07:45 wahanui      ubuntu is a debian-based OS and Koha has shiny new ubuntu intructions.
07:45 mtompset     ubuntu?
07:42 mtompset     ubuntu?
07:41 mtompset     ubuntu has current instructions at: http://wiki.koha-community.org/wiki/Ubuntu
07:40 wahanui      mtompset: I forgot ubuntu
07:40 mtompset     wahanui forget ubuntu
07:40 wahanui      ubuntu is, like, installed. or getting into integrating websites into the desktop, e.g. grooveshark showing up on the sound menu, and things like that. It's an interesting idea. I have the beta installed and it's still quirky, but a great idea
07:40 mtompset     ubuntu?
07:40 mtompset     http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages
07:28 mtompset     Well, now to clean up the tarball/git instructions for Ubuntu, because the packages version isn't getting any tidier as far as I can tell.
07:15 tweetbot`    [off] twitter: @IrmaLibraries: "#kohails Libraries, schools... Great non-toxic waterproof mats for children’s reading spaces $90 (180x90x5) EcoViva AUS http://t.co/j0jsOG1j"
06:58 magnuse      Oak
06:58 mtompset     Oak!
06:58 * Oak        waves
06:57 mtompset     Hi, sophie_m. :)
06:57 sophie_m     hi mtompset :-)
06:57 mtompset     salut. :)
06:57 reiveune     ?
06:56 mtompset     reiveune++
06:53 mtompset     I suppose greetings to everyone at biblibre are in order. ;)
06:51 alex_a       bonjour mtompset
06:48 mtompset     Bonjour, alex_a. :)
06:48 alex_a       bonjour
06:46 magnuse      yeah, only the best is good enough :-)
06:46 waylon       still koha.:)
06:45 waylon       new websites not entirely done i see.
06:44 waylon       http://www.tetakere.org.nz/
06:41 * mtompset   smiles, "Salut. I like that."
06:41 reiveune     salut mtompset :)
06:41 mtompset     Bonjour, reiveune. :)
06:36 reiveune     hello
06:26 magnuse      it's just the building that is called te takere, i think
06:26 magnuse      yeah, havn't heard anything else
06:25 waylon       ah, ill never remember the name. Still Levin public library right? still part ot the HLT network?
06:16 magnuse      yay! http://tetakere.blogspot.no/2012/09/welcome-to-te-takeretanga-o-kura-hau-po.html
06:15 * mtompset   can dream of a problemless world.
06:15 mtompset     Or, people arent' having any problems. :0
06:14 mtompset     NZ is off by 4 hours... That doesn't explain their afternoon. ;)
06:13 cait         no but already friday evening in nz for example
06:13 mtompset     Ah, must be a long weekend for people then, because there's no holiday here today.
06:08 cait         yeah, few people have weekend already now
06:08 cait         mtompset:
06:08 magnuse      good thing you are here then :-)
06:08 cait         morning mt
06:07 mtompset     well, almost 4 hours.
06:07 mtompset     It's been pretty quiet for 4 hours.
06:07 magnuse      hiya mtompset
06:07 mtompset     Greetings, magnuse and cait.
06:06 cait         hiya :)
06:06 * magnuse    waves
06:03 magnuse      kia ora #koha!
02:28 libsysguy    anyway I think I am going to rent a movie on Vudu and vege out for a bit
02:28 libsysguy    date/time**
02:28 libsysguy    right, or you know, push the due dat forward or backward
02:27 mtompset     oh, so a library that closes for 2 hours, but you needed to return your item during those two closed hours? ;)
02:26 libsysguy    not logical ones, but pragmatic ones
02:26 libsysguy    if you don't assume 24 hours you run into all sorts of interesting problems of how to charge people
02:26 libsysguy    :p
02:25 libsysguy    mtompset, the other issue I have with it is the functionality I am adding for hourly closures
02:25 libsysguy    that ian and I found when we first tried fixing hourly loans
02:25 libsysguy    there is a problem with conversion on delta_hours
02:23 mtompset     I think the 24 hour assumption is reasonable. Not perfect, but reasonable.
02:22 mtompset     Actually, if you have something checked out on day x, and it needs to be returned in 5 hours, but the library closed just before you returned it and the library is closed on day x+1, do you charge hourly for the hours the library isn't open, even though the library is closed that day?
02:17 mtompset     Why delta_ms?
02:15 mtompset     Isn't there a delta_hours?
02:13 libsysguy    and it assumes 24 hours
02:13 libsysguy    yeah
02:12 mtompset     And that hours_between function is UUUUUUUGLY.
02:11 mtompset     So the days_between and hours_between are what you were talking about for 2 functions, right?
02:11 mtompset     Yes, I scrolled down and was reading that.
02:09 libsysguy    line 167
02:09 libsysguy    http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=Koha/Calendar.pm;h=2a2e062e3e47e2415c619132e997624875925c13;hb=HEAD
02:09 libsysguy    the way we do it now it poo
02:09 mtompset     Yes, I understand.
02:09 libsysguy    i have been looking for alternatives
02:08 libsysguy    but for fear of introducing something like that
02:08 libsysguy    I saw that
02:07 mtompset     Hmmm... have you ever heard of Time::Business?
02:01 libsysguy    now HW would definitely never show up here
02:01 mtompset     developers! developers! developers! ;)
02:01 libsysguy    [off] nobody say his name more than 3 times
02:00 * mtompset   laughs harder.
02:00 waylon       [off] Postwhat?
02:00 mtompset     [off] Yes, yes, that is true.
01:59 * mtompset   laughs.
01:59 mtompset     Actually, what do you mean you can't convert between all the units?
01:59 libsysguy    [off] but thanks to mbalmer none of us can forget about postgres
01:58 mtompset     That happens.
01:58 libsysguy    I have forgotten about yum
01:58 libsysguy    I think i have been using debian based systems for so long
01:58 libsysguy    its a draw-ish for me
01:58 libsysguy    hmm
01:56 mtompset     I still like things about yum more than apt-get.
01:55 libsysguy    i used to be a centosian
01:55 libsysguy    you nailed it mtompset
01:55 libsysguy    :p
01:55 mtompset     You vile Debianist you, libsysguy. :P
01:54 libsysguy    I demand datetime
01:54 libsysguy    yayyy...
01:54 libsysguy    heh
01:52 mtompset     which is already part of the reason only 12.04 ubuntu works.
01:51 mtompset     Oh, and by the way... version 0.77 of date time requires a newer version of perl...
01:49 libsysguy    how retarded is that
01:49 libsysguy    notice you can't convert between all units
01:49 libsysguy    http://search.cpan.org/~drolsky/DateTime-0.77/lib/DateTime/Duration.pm#$dur->in_units(_..._)
01:49 libsysguy    ok so here is the real pinch
01:49 mtompset     I'd write a third with the extra parameter, and then replace the 2 with calls to the new fangled function.
01:47 mtompset     EEEEEW!
01:47 libsysguy    my thoughts exactly
01:47 libsysguy    yeah...
01:47 mtompset     2 functions?!
01:47 libsysguy    so I was trying to add some set logic and combine them
01:47 libsysguy    one for hours and one for days
01:47 libsysguy    well the issue is there are 2 functions
01:47 mtompset     So if it isn't called with the "return these units" parameter, it defaults.
01:46 mtompset     I'd say... if there is a duration difference function already, then adding a third parameter which defaults to the current behaviour shouldn't be a problem.
01:45 libsysguy    :p
01:45 libsysguy    exactly…too long have patrons been getting away with that free 45 minutes
01:45 mtompset     Ah.... true pro-rated granularity.
01:45 libsysguy    (maybe)
01:44 libsysguy    you are charged from 6:15 pm to 8 am when they open
01:44 libsysguy    and you return the book the next day
01:44 libsysguy    say a library closes at 6:15
01:44 libsysguy    well I was actually thinking ahead for fines
01:44 libsysguy    or just return the DT duration object
01:43 mtompset     Some library only has on site reading in 15 minute intervals? ;)
01:43 libsysguy    would it be best to take an option to my "duration" function to speify the units to return
01:43 libsysguy    however I would like to extend that to all units
01:43 libsysguy    as it currently stands when computing the difference between 2 dates  you are limited to hours and days
01:42 libsysguy    I have a general question about the calendar
01:41 mtompset     Greetings, #koha.
01:30 libsysguy    for the record, I think that datetime::duration objects are dumb
01:28 waylon       wait.. pqf?
01:25 waylon       .. oh of course!
01:24 jcamins_away waylon: if you don't sort at all, it may default to being in order by biblionumber. But the only way to be sure is pqf.
01:07 waylon       to sort_by biblionumber, what do i put in the sort_by param?
01:05 waylon       hiya all