← 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