IRC log for #koha, 2007-01-16

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

All times shown according to UTC.

Time Nick Message
21:35 rickw hello russ
21:35 mysql question in relation to koha 2.2.7
21:36 i understand that the 'return' keyword became a reserved word in the SQL language for mysql at some point
21:36 do you know exactly which mysql version this occurred in>
21:41 mason ver 5.0 -> http://dev.mysql.com/doc/refma[…]served-words.html
21:45 rickw thanks, mason
21:45 now the big decision : do I fossick around for mysql 4.0 in some archive (mysql.com no longer offers mysql 4!)
21:46 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 but its not that hard
21:47 we have clients running koha and mysql 5
21:47 its detailed here
21:47 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 i suppose it would run fine with mysql 5, and the sourcecode changes would be simialr
21:51 (although it does kinda invalidate the regression tests!)
21:53 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 okay, got the blog
22:00 thanks!
22:01 at http://lists.katipo.co.nz/pipe[…]/2006/010269.html chris mentions
22:01 `return` char(4) default NULL
22:01 surely those are quotes, not forward ticks
22:02 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 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/refma[…]/identifiers.html
22:04 rickw ah, re: more soruce code changes, my bad
22:04 the lengthy one was the joins.
22:04 okay, ready to rock
22:04 what i've got here, chris, is a test box from Irma Birchall running Deb Etch
22:05 i've insatlled linux-vserver on it and will be running two koha instances, each in its own VPS
22:05 (I ditched Xen as being overkill for Irma's needs)
22:05 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 i see these packeages in apt-cache:
22:07 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 regarding database, that is :)
22:08 i'm jusst getting to know Koha now
22:08 it looks like mod_perl (or some precompile and caching of perl code) is not being used
22:08 just plain old cgi + scripts
22:08 i suppose that is fine if the Koha instance is not under high demand
22:09 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 you can run it under mod_perl if you want too
22:10 rickw okay thanks for your ehlp
22:10 i'm going to install koha/2.2.7 for a start
22:11 once that works, i'll dig up a 2.0.0 and install that
22:11 cheers
22:16 `/quit
00:05 hello again
00:05 i am reading: http://www.kohadocs.org/Instal[…]Debian_sarge.html
00:05 and religiously following the install
00:05 i am at this stage: 3.1.5. Installing the MARC::Record module
00:05 whch mentions:
00:05 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 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 and im pretty sure i grabbed the one from cpan
00:07 chris i still think its lagging behind
00:07 whats the version on CPAN and whats the version on sourceforge?
00:07 mason 0.51?
00:08 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 urgh
00:09 okay
00:09 i'll use the cvs method
00:09 (have to install cvs now!)
00:09 chris http://sourceforge.net/project[…]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 unless stable version are tagged
00:10 oops!
00:11 chris for your use, the CPAN one would probably be fine, they dont actually use MARC at EESI
00:11 the newer version handles importing from MARC files better
00:11 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 http://downloads.sourceforge.n[…]2765&big_mirror=0
00:12 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 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 i was planning to do that over the next few days
00:15 rch_ ah, great.
00:15 we're looking to fix up a few things in dev_week...
00:15 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 sorry, a bit of lag there
00:23 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 whines that it cannot find yaz
00:26 i installed the deb pkg libyaz2
00:26 since libyaz has vanished
00:26 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 maybe that would help
00:27 i see this:
00:27 Package libyaz is not available, but is referred to by another package.
00:27 This may mean that the package is missing, has been obsoleted, or
00:27 is only available from another source
00:27 However the following packages replace it:
00:27  libyaz2
00:28 i guess i should uninstall libyaz2 and concetrate on libyaz
00:28 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 its in the indexdata's repo
00:31 rickw my apt refuses to give it to me
00:31 ah, sorry, i now see indexdata above
00:31 thanks will try it out
00:32 i'm still learning apt
00:32 i threw this into my /etc/apt/sources.list:
00:33 deb http://ftp.indexdata.dk/pub/debian/dists/etch/ etch libyaz
00:33 but npoe
00:33 no go
00:33 mason try this
00:33 eb http://ftp.indexdata.dk/debian indexdata/etch released
00:33 deb-src http://ftp.indexdata.dk/debian indexdata/etch released
00:33 rickw okay
00:33 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 is it indexdata or is it me?
00:35 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 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 i have installed libyaz and got yaz 2 ... urg
00:39 lib: /usr/lib/libyaz.so.2.0.1
00:40 i've got this in ousrces.list:
00:40 deb http://ftp.indexdata.dk/debian indexdata/etch released
00:40 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 Get:2 http://ftp.indexdata.dk indexdata/etch/released libyaz 2.1.46-1 [412kB]
00:41 ...
00:41 dpkg -l|grep -i yaz
00:41 ii  libyaz                 2.1.46-1                        The YAZ Z39.50 toolkit (runtime files)
00:41 rc  libyaz2                2.1.18-2                        The YAZ Z39.50 toolkit (runtime files)
00:41 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 is there more?
00:42 chris i think yaz-config is part of yaz
00:42 sudo apt-get install yaz
00:42 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 okay
00:43 mason yaz-config lives in libyaz-dev
00:44 rickw but Net::Z3950 still wines
00:44 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 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 but that tries to install XML::Parser
02:23 which needs the expat parser ... which needs XML::Parser ... and around it goes :(
02:24 i wonder if i (a) scrap all the XML stuff I have now installed (it is a dog's breakfast)
02:24 and just install XML::Parser using expat ... would Koha be happy?
02:24 or will it be looking for XML::Simple in the scripts?
02:25 ah:
02:25 XML::Simple is required: /Install.pm:   unless (eval {require XML::Simple})   { push @missing,"XML::Simple" };
02:47 okay ... had to install libexpat1-dev followed by XML::SAX::Expat followed by XML::Simple
05:08 btoumi hi all

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

koha1