Time Nick Message
21:35 rickw hello russ
21:35 rickw mysql question in relation to koha 2.2.7
21:36 rickw i understand that the 'return' keyword became a reserved word in the SQL language for mysql at some point
21:36 rickw do you know exactly which mysql version this occurred in>
21:41 mason ver 5.0 -> http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
21:45 rickw thanks, mason
21:45 rickw now the big decision : do I fossick around for mysql 4.0 in some archive (mysql.com no longer offers mysql 4!)
21:46 rickw or do i bite the bullet and use mysql 5.0 and patch the Koha sources to remove the return keyword
21:46 chris its more than that
21:46 chris but its not that hard
21:47 chris we have clients running koha and mysql 5
21:47 chris its detailed here
21:47 chris http://blog.katipo.co.nz/?p=18
21:51 rickw i also need to install Koha/2.0.0 for regression testing purposes
21:51 rickw i suppose it would run fine with mysql 5, and the sourcecode changes would be simialr
21:51 rickw (although it does kinda invalidate the regression tests!)
21:53 rickw hmmm ... blog.katipo.nz is not answering :(
21:54 chris weird works fine
21:54 mason me too...
21:57 rickw h5 ... i think my dsl modem needs a reset
22:00 rickw okay, got the blog
22:00 rickw thanks!
22:01 rickw at http://lists.katipo.co.nz/pipermail/koha/2006/010269.html chris mentions
22:01 rickw `return` char(4) default NULL
22:01 rickw surely those are quotes, not forward ticks
22:02 rickw oops, back ticks
22:02 chris no not quotes
22:02 rickw now, i thought I saw somewhere else before Xmas a much longer list of source changes when adapting to 5.0
22:02 rickw so mysql uses backticks to turn rsvd words into plain words?
22:03 chris yes
22:03 rickw okay
22:03 chris http://dev.mysql.com/doc/refman/5.0/en/identifiers.html
22:04 rickw ah, re: more soruce code changes, my bad
22:04 rickw the lengthy one was the joins.
22:04 rickw okay, ready to rock
22:04 rickw what i've got here, chris, is a test box from Irma Birchall running Deb Etch
22:05 rickw i've insatlled linux-vserver on it and will be running two koha instances, each in its own VPS
22:05 rickw (I ditched Xen as being overkill for Irma's needs)
22:05 rickw any suggestion as to which version of mysql 5 ... leading edge, latest stable?
22:05 chris latest stable
22:06 rickw of course i want to use deb apt-get and stay in line with updates
22:06 rickw i see these packeages in apt-cache:
22:07 rickw mysql-client-5.0 mysql-server-5.0
22:07 chris yep those will do
22:07 rickw is that all I need?
22:07 rickw regarding database, that is :)
22:08 rickw i'm jusst getting to know Koha now
22:08 rickw it looks like mod_perl (or some precompile and caching of perl code) is not being used
22:08 rickw just plain old cgi + scripts
22:08 rickw i suppose that is fine if the Koha instance is not under high demand
22:09 rickw i'll have to find out Irma's usgae requirements (I think it is a few hundred hits per day, not per minute!)
22:10 chris yeah, its fine under lot more busy sites than that
22:10 chris you can run it under mod_perl if you want too
22:10 rickw okay thanks for your ehlp
22:10 rickw i'm going to install koha/2.2.7 for a start
22:11 rickw once that works, i'll dig up a 2.0.0 and install that
22:11 rickw cheers
22:16 rickw `/quit
00:05 rickw hello again
00:05 rickw i am reading: http://www.kohadocs.org/Installing_Koha_on_Debian_sarge.html
00:05 rickw and religiously following the install
00:05 rickw i am at this stage: 3.1.5. Installing the MARC::Record module
00:05 rickw whch mentions:
00:05 rickw We have to install the MARC::Record module manually from SourceForge now as the CPAN version of MARC::Record isn't up-to-date.
00:06 rickw anyone know if this is still necessary or has CPAN been updated withthe correct MARC::Record module ?
00:06 mason hiya, i have just done this (last week?)
00:07 mason and im pretty sure i grabbed the one from cpan
00:07 chris i still think its lagging behind
00:07 chris whats the version on CPAN and whats the version on sourceforge?
00:07 mason 0.51?
00:08 mason on both?
00:09 rickw i'll have a look
00:09 mason 1.36 on cpan, march 2004...
00:09 rickw what version should I aim for? the sourceforge i presume
00:09 rickw urgh
00:09 rickw okay
00:09 rickw i'll use the cvs method
00:09 rickw (have to install cvs now!)
00:09 chris http://sourceforge.net/project/showfiles.php?group_id=1254
00:09 rickw thanks
00:09 chris just download from there
00:09 rickw perhaps cvs not nececssary
00:10 chris cvs probably a bit bleeding edge
00:10 rickw cvs could be dangerous ... might have an unstabel version committed
00:10 rickw unless stable version are tagged
00:10 rickw oops!
00:11 chris for your use, the CPAN one would probably be fine, they dont actually use MARC at EESI
00:11 chris the newer version handles importing from MARC files better
00:11 chris but, best to just put it on, in case they do decide in the future to use marc
00:11 rickw i may as well do the whole thing right
00:11 rickw http://downloads.sourceforge.net/marcpm/MARC-Record-2.0.tar.gz?modtime=1116612765&big_mirror=0
00:12 rickw i'll give it a whirl
00:12 chris cool
00:13 rch_ hi mason - you have a minute?
00:13 mason hey ryan
00:13 mason whats up?
00:14 rch_ was just talking to chris about holidays / rel_2_2
00:14 mason uhuh
00:14 rch_ wondering how much is involved in the work you did, and committing it ?
00:14 mason not too much, i think
00:15 mason i was planning to do that over the next few days
00:15 rch_ ah, great.
00:15 rch_ we're looking to fix up a few things in dev_week...
00:15 rch_ so we can merge from 2_2 ...
00:16 mason thats great news
00:16 rch_ did that come from rel_3 or the other way 'round?
00:16 mason yep, i grabbed it from rel3
00:17 rch_ cool... and this is only issuing - no relation to fines stuff, right?
00:20 mason right, there looked to be only a small change in issuebook(), in Circ2.pm
00:22 rch_ okay, great... this, i think will make the fines work that needs to be done for dev_week much simpler.
00:22 mason that calls a new sub in Calendar.pm, called addDate(), to check if the returndate is a holiday or not.
00:22 mason sorry, a bit of lag there
00:23 mason so, yep, only issebook() seems to use call the new holidays code in rel3
00:25 rickw more fun with instllation
00:25 rch_ it is working well? last time I played with the calendar in rel_3, it acted a little buggy.
00:25 rickw perl -MCPAN -e 'install Net::Z3950'
00:25 rickw whines that it cannot find yaz
00:26 rickw i installed the deb pkg libyaz2
00:26 rickw since libyaz has vanished
00:26 rickw was I bad?
00:26 mason ryan: ive only tested it briefly, but it seems to be doing what i expected
00:26 chris maybe :) all the hard bits with the install come down to these third party modules unfortunately
00:27 rch_ rickw: do you have indexdata's repo in your apt-sources?
00:27 rickw nope
00:27 rickw maybe that would help
00:27 rickw i see this:
00:27 rickw Package libyaz is not available, but is referred to by another package.
00:27 rickw This may mean that the package is missing, has been obsoleted, or
00:27 rickw is only available from another source
00:27 rickw However the following packages replace it:
00:27 rickw libyaz2
00:28 rickw i guess i should uninstall libyaz2 and concetrate on libyaz
00:28 rickw rch_: where is indexdata's repo?
00:30 mason http://ftp.indexdata.dk/pub/debian/dists/etch/
00:30 rch_ rickw: maybe you just need libyaz-dev ?
00:30 rickw i would love to grab it
00:30 chris yeah that would have the header files
00:31 chris its in the indexdata's repo
00:31 rickw my apt refuses to give it to me
00:31 rickw ah, sorry, i now see indexdata above
00:31 rickw thanks will try it out
00:32 rickw i'm still learning apt
00:32 rickw i threw this into my /etc/apt/sources.list:
00:33 rickw deb http://ftp.indexdata.dk/pub/debian/dists/etch/ etch libyaz
00:33 rickw but npoe
00:33 rickw no go
00:33 mason try this
00:33 mason eb http://ftp.indexdata.dk/debian indexdata/etch released
00:33 mason deb-src http://ftp.indexdata.dk/debian indexdata/etch released
00:33 rickw okay
00:33 rickw thanks
00:33 mason s/eb/deb
00:34 rickw W: Couldn't stat source package list http://ftp.indexdata.dk indexdata/etch/released Packages
00:34 rickw is it indexdata or is it me?
00:35 rickw ah, does one ahve to apt-get update after altering the sources.list ?
00:35 mason yep
00:36 rickw and apt-get upgrade ?
00:36 mason no, not that
00:36 rickw okay .. got yaz
00:36 rch_ mason: thx... let me know, if you would, if you'll not get to commit this week.
00:36 rickw thanks !
00:37 mason ryan, ill commit some later tonite
00:37 rch_ mason++ :)
00:38 mason no probs, i spent ages doing the same thing last week, so its fresh in my mind :)
00:38 mason though id try save you the pain
00:38 rickw this is fun: Unable to call script 'yaz-config': is YAZ installed? at Makefile.PL line 12.
00:39 rickw i have installed libyaz and got yaz 2 ... urg
00:39 rickw lib: /usr/lib/libyaz.so.2.0.1
00:40 rickw i've got this in ousrces.list:
00:40 rickw deb http://ftp.indexdata.dk/debian indexdata/etch released
00:40 rickw deb http://ftp.au.debian.org/debian etch main
00:40 mason try this, dpkg -l|grep -i yaz
00:41 rickw ah ...looks like indexdata isusing yaz version 2 as well:
00:41 rickw Get:2 http://ftp.indexdata.dk indexdata/etch/released libyaz 2.1.46-1 [412kB]
00:41 rickw ...
00:41 rickw dpkg -l|grep -i yaz
00:41 rickw ii libyaz 2.1.46-1 The YAZ Z39.50 toolkit (runtime files)
00:41 rickw rc libyaz2 2.1.18-2 The YAZ Z39.50 toolkit (runtime files)
00:41 rickw ii yaz-doc 2.1.46-1 The YAZ Z39.50 toolkit (documentation)
00:41 chris do you have yaz itself installed
00:41 rickw just the libs above and docs
00:41 rickw is there more?
00:42 chris i think yaz-config is part of yaz
00:42 chris sudo apt-get install yaz
00:42 chris see if youre yaz-config errror goes away after that
00:42 rickw orkee dorkee
00:42 mason oh, ive just got the same 3 yaz opackages on my dev box too
00:43 rickw Get:1 http://ftp.indexdata.dk indexdata/etch/released yaz 2.1.46-1 [84.9kB]
00:43 rickw okay
00:43 mason yaz-config lives in libyaz-dev
00:44 rickw but Net::Z3950 still wines
00:44 rickw so i need the dev version of the lib?
00:44 chris hmmm
00:44 mason i had a similar prob with that too..., try this
00:44 mason sudo perl -MCPAN -e 'install Net::Z3950::ZOOM'
00:45 chris ill leave it to mason, i havent done an install in a while
00:45 mason i did a google on my Net::Z3950 error and found a fix from someone
00:47 rickw mason: looks like ::ZOOM installs. thanks.
00:47 mason me too
02:23 rickw i tried to install what CPAN recommends: XML::SAX::Expat
02:23 rickw but that tries to install XML::Parser
02:23 rickw which needs the expat parser ... which needs XML::Parser ... and around it goes :(
02:24 rickw i wonder if i (a) scrap all the XML stuff I have now installed (it is a dog's breakfast)
02:24 rickw and just install XML::Parser using expat ... would Koha be happy?
02:24 rickw or will it be looking for XML::Simple in the scripts?
02:25 rickw ah:
02:25 rickw XML::Simple is required: /Install.pm: unless (eval {require XML::Simple}) { push @missing,"XML::Simple" };
02:47 rickw okay ... had to install libexpat1-dev followed by XML::SAX::Expat followed by XML::Simple
05:08 btoumi hi all