Time  Nick    Message
12:03 indradg kados, hi
12:04 indradg kados, I was reading old chat transcripts
12:04 kados   in indradg
12:04 kados   come across anything interesting? ;-)
12:04 indradg u had a marc_word table corruption?
12:04 kados   right ... I see you've got one too
12:04 indradg yep!
12:05 indradg my 2.2.1 update went awry
12:05 indradg currently rolled back to 2.0.0 :(
12:05 kados   huh ... have you tried REPAIR TABLE marc_word?
12:05 kados   (might take a while)
12:06 indradg not yet... located the problem just before leaving from office today
12:06 indradg will try it tomorrow
12:06 kados   indradg: you'll want to read over the manual: http://dev.mysql.com/doc/mysql/en/repair-table.html
12:06 indradg kados, already reading it :)
12:06 kados   ;-)
12:07 indradg after paul told me that searching is different between 2.0 and 2.2 :)
12:08 indradg the affected table had some 35k rows
12:12 owen    'morning all
12:15 indradg owen, morning! though its actually nearly 10 PM here in india :)
12:16 owen    Good time for hacking (if you're single or your kids are all in bed)
12:16 indradg heh!
12:16 indradg true! thank god for singlehood! ;)
12:24 kados   morning owen
12:24 owen    Hi kados
17:10 rach    yay regula will translate the page of instructions for me :-)
17:10 rosa    excellent
17:11 owen    The french instructions?
17:11 rosa    yep
17:13 owen    Yeah, I pored over those a little myself.
17:13 rach    she says she'll give it a go at the weekend
17:32 owen    It's not often I manage to crash Firefox
17:33 rosa    I had a visitor in the library yesterday using our public internet, very anxious becaue there was no IE
17:34 owen    I'd be very anxious if I *had* to use IE
20:40 karl    mary had a little lamb...
20:42 karl    is Chris in here?
20:43 chris   yep im here
20:43 karl    ah
20:43 karl    wuz wondering if I was going to have to send a penquin in after you...
20:44 karl    ;-)
20:44 karl    ok so where to start...
20:44 karl    you go first
20:44 chris   so what are the current problems ur having?
20:45 karl    8-D
20:45 karl    well, there is a bunch of data in the database
20:45 karl    that I think is "test data" from the install
20:45 chris   cool
20:45 karl    I cant get it into koha
20:45 karl    actually, I can
20:46 karl    I have two listings biblios in there
20:46 karl    one for Old Yeller
20:46 karl    but, when I try to do an opac search it doesnt bring it up
20:46 karl    lemme start it up brb
20:47 karl    ok the admin interface is up
20:48 karl    search for Old Yeller nothing found
20:48 chris   right if you do a title search for yeller .. you get no results?
20:48 karl    right
20:49 chris   and is there anything in the koha-error_log ?
20:49 karl    tried word search for "yeller" no results
20:49 karl    leme check
20:50 karl    yah there are entries
20:50 kados   karl: have you populated marc_word ?
20:50 kados   hiya all ;-)
20:50 karl    hellow
20:50 karl    marc_word....is that a database table?
20:51 karl    Q : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1
20:51 karl     where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=bibl
20:51 karl    ioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.word  like 'yeller')
20:51 karl     order by biblio.title at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line
20:51 karl     271.
20:51 kados   sorry ... I meant stopwords :-/
20:51 chris   right so thats looks ok, no error anymore
20:51 karl    yeah I have one in there, think I put "and" in it lemme look
20:52 chris   what happens if tyou try a title search?
20:52 karl    I think this is it:
20:52 karl    Q2 : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m
20:52 karl    1,marc_word as m2 where biblio.biblionumber=marc_biblio.biblionumber and biblio.
20:52 karl    biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.bib
20:52 karl    id=m2.bibid) and ((m1.word  like 'Old' and m1.tagsubfield in ('245a'))and (m2.wo
20:52 karl    rd like 'Yeller' and m2.tagsubfield in('245a'))) order by biblio.title term is
20:52 karl     Old Yeller            at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line
20:52 karl     268.
20:53 kados   here's a working and fairly complete stopwords table:
20:53 kados   kados.org/stopwords.sql
20:53 kados   you could import it with:
20:53 karl    do I need that???????
20:54 kados   mysql -uroot -pyourrootpassword Koha < stopwords.sql
20:54 karl    ok
20:56 chris   i dont think its the stopwords problem anymore kados
20:56 chris   as its not erroring
20:56 chris   just not returning a result
20:57 chris   what happens when you cut and paste that sql, into mysql karl ?
20:57 karl    ok I did it, I was getting the stopwords error until I figured out where to enter it
20:57 karl    just finished it
20:57 karl    same result
20:57 karl    nothing found on "yeller"
20:58 chris   right
20:58 chris   what does
20:59 karl    if I search for it in the "add biblio" window, it comes up with it
20:59 chris   select * from biblio;
20:59 chris   get ya?
20:59 karl    hangon
21:00 karl    lots
21:00 karl    returns 502 rows
21:00 karl    so there is stuff in there, thats how I knew there was
21:01 kados   how about select count(*) from marc_word ?
21:02 karl    4
21:02 kados   there's your problem
21:02 karl    8-o
21:02 kados   if it's not in marc_word it's not going to show up in a search
21:02 karl    ok.......
21:02 kados   did you link koha2 marc?
21:02 kados   in preferences?
21:02 karl    think so
21:03 chris   what about select * from marc_word where word like 'Yeller';
21:03 karl    hummm dont see it here
21:04 karl    in system preferences?
21:04 chris   yeah kados is right, if its not in marc_word .. the search wont work
21:04 kados   karl how did you import your data?
21:04 karl    found it
21:05 karl    no I didnt
21:05 karl    I dont see anything here about koha2marc
21:05 kados   where did you get the data then?
21:05 karl    there is "links Koha-MARCDB
21:06 karl    and MARC chedk
21:06 karl    marc check says config ok
21:06 kados   right ... did you setup links Koha - MARCDB?
21:07 karl    I didnt do anything in that screen
21:07 karl    there are fields with tags and subfileds identified
21:07 karl    like "title  245 a Title"
21:08 kados   right
21:08 kados   hmmm ...
21:08 kados   so where did the data come from?
21:08 karl    I really dont know.  I think this was sample data imported during install, I did try to install the sample data but I dont think it worked
21:08 karl    its not my data I know that
21:09 kados   where did you find the sample data?
21:09 karl    yeah there is a sampledata set in there
21:09 karl    it came with teh install, lemme look
21:10 kados   not sampledata-1.2 eh?
21:11 karl    yeah
21:11 kados   if so you may need to run updatedatabase
21:11 karl    that was in the 2.2.0 package
21:11 karl    whs that
21:11 karl    that a script?
21:11 kados   1.2 data shouldn't be in 2.2 release ;-)
21:11 kados   yep
21:11 karl    well it wuz
21:11 kados   misc/updater I think
21:11 karl    ok
21:12 karl    lemme run it
21:12 karl    -su-2.05b# ./updatedatabase
21:12 karl    Can't locate C4/Context.pm in @INC (@INC contains: /usr/local/lib/perl5/site_perl/5.8.6/mach /usr/local/lib/perl5/site_perl/5.8.6 /usr/local/lib/perl5/site_perl /usr/local/lib/perl5/5.8.6/BSDPAN /usr/local/lib/perl5/5.8.6/mach /usr/local/lib/perl5/5.8.6 .) at ./updatedatabase line 22.
21:12 karl    BEGIN failed--compilation aborted at ./updatedatabase line 22.
21:12 kados   perl -I /usr/local/koha/intranet/modules updatedatabase
21:13 kados   ;-)
21:13 karl    ok
21:13 karl    try it again?
21:13 kados   did it run?
21:13 karl    -su-2.05b# perl -I /usr/local/koha/intranet/modules updatedatabase
21:13 karl    connected to your DB. Checking & modifying it
21:13 karl      Alter z3950random in marc_breeding
21:13 karl      Alter bookfundid in aqbookfund
21:13 kados   cool
21:13 karl      Alter aqbudgetid in aqbudget
21:14 karl      Alter id in z3950servers
21:14 karl    Checking for data required in table userflags...
21:14 karl    Checking for data required in table systempreferences..
21:14 kados   when it finishes give your search anothe try
21:14 karl    now, look for old yeller?
21:14 kados   yep
21:14 karl    k
21:14 karl    arrgh
21:14 chris   there is the other rebuildnonmarc as well
21:14 kados   no luck eh?
21:15 karl    not found
21:15 kados   I'm not sure if 1.2 can upgrade to 2.2 withought upgrading to 2.0
21:15 kados   (I'm fairly certain paul said that once)
21:15 karl    Ive upgraded to 2.2.1
21:15 kados   right ... same applies
21:15 chris   from 2.0 tho right
21:15 kados   you'd have to downgrade to 2.0
21:15 kados   run updatedatabase
21:15 kados   then upgrade to 2.2
21:15 kados   and run it again ;-)
21:16 kados   course ... you'll have to scrap the current data
21:16 karl    well I went from 2.2.0 -> 2.2.1
21:16 kados   since it's already munged by 2.2 updatedatabse ;-)
21:16 karl    or what ever is current
21:16 kados   right
21:16 karl    I mean stable
21:16 chris   so you never had a 1.2 install?
21:16 karl    no
21:16 chris   cool
21:16 karl    installed this a month ago
21:16 karl    fighting with it ever since
21:17 chris   id try adding a new title now
21:17 kados   he was grabbing that 1.2 data in the release (shouldn't be there)
21:17 karl    oh, was that data from ver 1.2???
21:17 karl    the sampledata
21:17 kados   yep
21:17 karl    ok
21:17 chris   using the acquisitions module, and see if it puts anything in marc_word
21:17 karl    k
21:17 chris   and if it does, then you should be able to search on it
21:18 kados   yep ... I could also give you some marc if you want to try bulkmarcimport (actually you can get it for yourself):
21:18 karl    where in the acquistion
21:18 karl    only place to enter anything is "supplier name"
21:18 kados   http://koha.liblime.com/cgi-bin/koha/export/marc.pl
21:18 kados   user:circ pass:liblime
21:19 karl    well, it has the bulkmarcimport script
21:19 kados   grab biblios 100-500 ... it'll give you a marc.pl file you can import with bulkmarcimport
21:19 karl    but dont have that working either 8-(
21:19 kados   it should work with this data ... I've tested it
21:19 karl    k
21:19 chris   ahh karl
21:19 chris   go to systempreferences
21:20 chris   and change acquisitions to simple
21:20 kados   that too ;-)
21:20 karl    ok done
21:20 chris   now if you go to acquisitions
21:21 chris   you should get somewhere you can add stuff
21:21 karl    ...it comes up with the catalog screen
21:21 chris   really?
21:21 karl    and I come up with old yeller
21:21 karl    yes
21:22 chris   there isnt an option to add a new biblio?
21:22 karl    well, it has the marc biblio management screen
21:22 karl    to add a new biblio/item.
21:22 chris   right
21:22 karl    isbn and title
21:22 chris   try adding something there
21:23 karl    did old yeller it found it
21:23 chris   yeah it will
21:23 chris   but we want to add something using hte marc biblio management
21:23 karl    well, I have 2800 isbns...
21:24 kados   here's some data:
21:24 karl    1400 of which are valid
21:24 kados   title: cryptonomicon
21:24 kados   author: neal stephenson
21:24 kados   isbn:0060512806
21:24 karl    what screen
21:24 karl    catalog?
21:24 kados   yea
21:24 chris   choose add new biblio/item
21:25 karl    you mean add new biblio at the bottom?
21:25 chris   yes
21:25 karl    and this hairy form comes up
21:26 chris   right
21:26 chris   just fill in the title
21:26 chris   245 a
21:26 chris   and then the item stuff
21:27 karl    whoa hang on
21:28 karl    well I got the "5" in after "24 and put the title in "standard number or code" window
21:28 karl    is that what you wanted
21:29 chris   umm no
21:29 karl    oh
21:29 karl    8-D
21:29 karl    lets start over
21:30 karl    ok I see
21:30 karl    so just put the title there and click add biblio...?
21:31 chris   yeah you could add in the isbn as well (i think its on that screen) or anything else you wanted to add
21:31 karl    lemme add isbm
21:31 chris   this is on the big hairy form page
21:31 chris   right?
21:32 chris   http://koha.kauri.katipo.co.nz/cgi-bin/koha/acqui.simple/addbiblio.pl ur on a page with a url like this?
21:32 karl    ok I got a big red window:  duplicate suspected with cryptonomicon you must either blah lbah lbah
21:34 karl    ok I am at that login
21:34 karl    koha login cardnumber pw teal screen
21:34 chris   nooo
21:34 chris   hehe
21:34 karl    8-(
21:34 chris   i meant the page you are at, will have a url like that
21:34 chris   except with your hostname
21:34 karl    http://enterprise:8080/cgi-bin/koha/acqui.simple/addbiblio.pl?isbn=
21:34 chris   excellent
21:35 karl    ok shall I edit this???
21:35 karl    go to edit items
21:35 chris   umm sure, give it a try
21:35 karl    well it gave me a screen with a bunch of drop downs
21:36 karl    ok its where to put the listing the branch and holding branch
21:36 chris   ahhh
21:36 chris   actually go back
21:36 karl    also listsl price and some other stuff
21:36 chris   we want to add a new one
21:36 karl    ok where to
21:36 chris   start from acquisitions again
21:36 karl    k
21:36 chris   choose add new biblio
21:37 chris   make up a title, and add it in the title field :)
21:37 chris   something like karls test book
21:37 karl    ok nothing found for "I, Robot"
21:38 chris   cool
21:38 chris   so youre at the big hairy form?
21:38 karl    nyeah
21:38 karl    yeah
21:38 chris   and youve entered i, robot in the title field (of 245a) and then youve clicked add bibliographic record and go to items?
21:39 karl    uh
21:40 karl    uh, where is "add bibliographic record" and "go to items" in this window
21:40 karl    other than, the add biblio button
21:40 chris   ahh just click on that
21:40 karl    arrgh
21:40 chris   i must be using a different theme .. no matter, the add biblio should work
21:40 karl    came up wit the same error about the cyrptomonicon dupe
21:41 chris   hmm
21:41 chris   do you get a check here to confirm its not a duplicate ?
21:42 karl    yeah I am going to check that box
21:42 chris   cool check that, and hit add biblio again
21:42 karl    and click add biblio
21:42 karl    ok I am back to the "marc biblio 504" screen
21:43 karl    nothing under existing but the drop downs under new item
21:43 chris   so it has stuff like
21:43 chris   home branch
21:43 karl    says home branch
21:43 karl    yeah
21:43 chris   holding branch etc
21:43 karl    yeah
21:43 chris   and those are blank?
21:43 karl    yeah
21:43 chris   ahh,... so you never set up any branches?
21:43 karl    there is one called "test"
21:43 chris   cool, select test for both of them
21:44 chris   whack 123456 into the barcode
21:44 karl    ok
21:44 chris   and click add item
21:44 karl    ok........
21:44 chris   right
21:44 chris   now in mysql
21:44 chris   if you do a
21:44 chris   select * from marc_word;
21:45 chris   is i, robot in there ?
21:45 karl    I have both
21:45 chris   yay
21:45 karl    cryptomonicon and I robot
21:45 chris   what happens if you go to the catalog now
21:46 karl    opac?
21:46 chris   either the opac
21:46 chris   or the catalog on the admin side
21:46 karl    found it
21:46 karl    I robot
21:46 chris   sweet
21:46 karl    coool
21:46 chris   so it looks like its all working, just the data was from 1.2 .. so didnt have the neccessary marc info
21:47 karl    humm
21:47 karl    ok
21:47 karl    ...
21:47 karl    complex program
21:47 chris   yep
21:48 chris   sometimes more complex than it needs to be
21:48 karl    ok I've got 2800 records I need to suck into this
21:48 karl    somehow
21:48 chris   are they in a MARC format?
21:48 karl    well, that is a problem
21:48 chris   cos if they are, then its easy
21:48 karl    you see, the data is from LHOnline
21:48 karl    which uses the old btrieve database
21:48 chris   if they are in some other format, it gets a bit tricky
21:49 karl    I was able to dump them into a text file
21:49 chris   did you see phill hardstaffs email to the list?
21:49 karl    and mike revey aka perl guru wrote a script
21:49 karl    to suck out the isbns
21:49 karl    and using his yaz script fed them up to the LoC
21:49 chris   right
21:49 karl    but alas only half were valid
21:49 chris   yeah thats the problem
21:50 karl    now, our little library uses dewey decimal
21:50 chris   Marcedit might be the way to go
21:50 chris   yep, so do lots of libraries using Koha
21:50 karl    I dont know if that is a standard form or locally assigned system
21:50 karl    marcedit, is that the windoze program?
21:51 chris   not sure, but it will convert a text file, to MARC
21:51 karl    humm
21:51 chris   ive never used it, but others have successfully
21:51 karl    humm
21:51 karl    yeah I think this is it
21:51 karl    http://oregonstate.edu/~reeset/marcedit/html/
21:52 karl    I did install it on my win2k install
21:52 karl    looked complicated
21:52 kados   it's a real bummer that isbns aren't more reliable
21:52 kados   what we need is some kind of isbn translator database
21:52 karl    y
21:53 karl    did you guys see themarch linux journal?
21:53 kados   no
21:53 karl    page 42 about radio new zealand
21:53 kados   hehe
21:53 karl    pretty good rant about propritary databases
21:54 kados   karl if you want to play with MARC data feel free to grab some from my site
21:54 karl    ok where is it
21:54 karl    somwhere up there....
21:54 kados   http://koha.liblime.com/cgi-bin/koha/export/marc.pl
21:55 kados   user: circ, password: liblime
21:55 kados   also ... for what it's worth feel free to poke around that intranet as much as you want ... I've got a cron job that restores the db every week
21:55 karl    humm hwere is the marc data
21:56 kados   so you'll need to export it ... say records 300 - 500
21:56 kados   you're here?
21:56 kados   http://koha.liblime.com/cgi-bin/koha/export/marc.pl
21:56 karl    yah
21:56 karl    im in the program
21:56 kados   so put 300 in the first field and 500 in the second and hit 'export'
21:56 karl    ohh ok
21:57 kados   then you'll get a file called 'marc.pl'
21:57 kados   you can import that with bulkmarcimport
21:57 karl    ok
21:57 karl    I'll try it thanks
21:57 kados   np
21:58 karl    chris, I've been wondering if this program might be too complex for my church...
21:59 karl    one thing I want to do, and the library ladies would like, is to put it up on our web page so anyone can search it
21:59 karl    but, may not work out that way
21:59 karl    I could setup a standalone box
21:59 karl    in the library
21:59 karl    saw another program havent looked into it further tho
22:00 karl    openbiblio you ever look at it?
22:00 chris   yeah i think it was a fork from koha
22:00 karl    but, it may not prevent my central problem which is data import
22:01 chris   data import is always the hardest bit
22:01 karl    I've told the people at the church that is key no matter what program they settle on
22:01 karl    I do_have the manuals to LHOnline,
22:01 chris   im 99% sure that koha is the most feature rich opensource ILS
22:01 karl    and it does have how the data fields are setup
22:02 karl    yeah no doubt!!!
22:02 chris   what it needs (and all projects do) is more documentation
22:02 karl    no kidding
22:02 karl    maybe not more, just_better
22:02 karl    I'd be interested in helping there (if I can figure out how it works)
22:04 karl    I am going to try kados data, see what happens
22:06 karl    arggh
22:06 karl    -su-2.05b# ./bulkauthimport.pl ../../../marc.pl
22:06 karl    Can't locate C4/Context.pm in @INC (@INC contains: /usr/local/lib/perl5/site_perl/5.8.6/mach /usr/local/lib/perl5/site_perl/5.8.6 /usr/local/lib/perl5/site_perl /usr/local/lib/perl5/5.8.6/BSDPAN /usr/local/lib/perl5/5.8.6/mach /usr/local/lib/perl5/5.8.6 .) at ./bulkauthimport.pl line 10.
22:06 karl    BEGIN failed--compilation aborted at ./bulkauthimport.pl line 10.
22:07 karl    got that before
22:07 karl    when runnign this script
22:07 chris   ull need the -I bit
22:08 chris   like for the upgrade database
22:08 karl    oh
22:08 chris   its cos perl cant find the modules unless you tell it where it is
22:09 karl    humm this time didnt run
22:09 chris   i think you need to pass in some options
22:09 chris   it should tell ya
22:09 karl    -su-2.05b# perl -I /usr/local/koha/intranet/modules updatedatabase
22:09 karl    Can't open perl script "updatedatabase": No such file or directory
22:10 chris   no ... u dont want to run updatedatabase :-)
22:10 karl    oh upgrade
22:11 chris   perl -I /usr/local/koha/intranet/modules bulkmarcimport.pl -file /path/to/the/file
22:11 chris   arent you wanting to run bulkmarcimport ?
22:11 chris   ie import the records?
22:11 karl    yah
22:11 chris   so that
22:12 chris   so you should have a file you downloaded from joshuas server
22:12 karl    yah...
22:12 chris   perl -I /usr/local/koha/intranet/modules bulkmarcimport.pl -file /path/to/that/file
22:12 karl    -su-2.05b# perl -I /usr/local/koha/intranet/modules bulkmarcimport.pl -file /home/kdagee/marc.pl
22:12 karl    Can't open perl script "bulkmarcimport.pl": No such file or directory
22:13 chris   well u will need to find that script
22:13 chris   and be in the directory with it
22:13 karl    i know where it is
22:13 karl    bulkmarcimport.pl or upgrade?
22:14 chris   bulkmarcimport.pl
22:16 karl    arrrgh
22:16 karl    -su-2.05b# ./bulkauthimport.pl ../../../marc.pl
22:16 karl    Can't locate C4/Context.pm in @INC (@INC contains: /usr/local/lib/perl5/site_perl/5.8.6/mach /usr/local/lib/perl5/site_perl/5.8.6 /usr/local/lib/perl5/site_perl /usr/local/lib/perl5/5.8.6/BSDPAN /usr/local/lib/perl5/5.8.6/mach /usr/local/lib/perl5/5.8.6 .) at ./bulkauthimport.pl line 10.
22:16 karl    BEGIN failed--compilation aborted at ./bulkauthimport.pl line 10.
22:17 chris   right
22:17 chris   that wont work
22:17 chris   u need that command i put in
22:17 chris   perl -I /usr/local/koha/intranet/modules bulkmarcimport.pl -file /path/to/that/file
22:17 kados   it's bulkmarcimport not bulkauthimport
22:17 chris   perl -I /usr/local/koha/intranet/modules bulkmarcimport.pl -file ../../../marc.pl
22:17 kados   it's in migration_tools I think
22:17 karl    arrgh...
22:20 karl    gotta change the perms on bulkmarcimport.pl
22:20 karl    -rw-r--r--  1 501  100  4494 Jan  3 07:23 bulkmarcimport.pl
22:20 chris   thats fine
22:20 chris   as long as u use
22:20 chris   perl -I /usr/local/koha/intranet/modules bulkmarcimport.pl -file ../../../marc.pl
22:20 chris   u just cant go ./bulkmarcimport.pl
22:21 karl    not in that directory tho
22:21 karl    -su-2.05b# locate bulkmarcimport.pl
22:21 karl    /usr/home/kdagee/koha-2.2.0/scripts/misc/migration_tools/bulkmarcimport.pl
22:21 karl    /usr/home/kdagee/koha-2.2.1/scripts/misc/migration_tools/bulkmarcimport.pl
22:21 karl    /usr/local/koha/intranet/scripts/misc/migration_tools/bulkmarcimport.pl
22:21 karl    /usr/local/koha/intranet/scripts200503291957/misc/migration_tools/bulkmarcimport
22:21 chris   yep so go
22:21 chris   cd /usr/local/koha/intranet/scripts/misc/migration_tools/
22:21 chris   perl -I /usr/local/koha/intranet/modules bulkmarcimport.pl -file /where/ever/marc.pl
22:23 karl    -su-2.05b# perl -I /usr/local/koha/intranet/modules bulkmarcimport.pl -file /home/kdagee/marc.pl
22:23 karl    0 MARC record done in 0.00359296798706055 seconds
22:23 karl    think it worked
22:23 karl    or, did it.........
22:23 chris   looks like 0
22:23 karl    yah
22:23 karl    humm
22:24 chris   try
22:24 chris   -n 1 at the end
22:24 karl    theres nothing in the file
22:25 karl    lemme get another one
22:25 chris   right
22:25 karl    zee-row
22:26 chris   so it looks like your net getting records exported
22:26 chris   not
22:26 chris   if that file is blank
22:26 karl    heh
22:26 karl    fun eh
22:26 chris   try just 1 to 10
22:26 karl    k
22:26 chris   instead of 300 to 500
22:27 chris   see if we get anything out
22:27 chris   if not, might have to wait till kados is back, and see whats up with his server
22:27 karl    nada
22:27 karl    yah
22:28 kados   leave both blank
22:28 karl    k...
22:28 kados   that'll get you about 3000 or so
22:28 karl    its cranking now
22:29 kados   ahh ... I remember now ... the biblios start at 3000 or something ... /me puts it on his 'to fix' list
22:29 karl    about 2 meg so far
22:29 kados   sorry about that ...
22:29 karl    heh
22:29 karl    np
22:29 karl    ok done lemme try
22:29 karl    oh yeah
22:29 karl    shit
22:30 karl    giving me "access denied"
22:30 kados   what is?
22:30 karl    the script
22:30 karl    DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 336.
22:30 karl    -su-2.05b# perl -I /usr/local/koha/intranet/modules bulkmarcimport.pl -file /home/kdagee/marc.pl
22:31 kados   hmmm
22:31 karl    gave me
22:31 karl    DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 336
22:31 kados   right
22:31 kados   this could be tricky
22:31 karl    im logged into the db as kohaadmin
22:31 karl    arrgh
22:31 karl    (in another term window
22:32 kados   so check /etc/koha.conf
22:32 kados   is that the right password for kohaadmin?
22:32 karl    yea it is
22:33 karl    yup
22:33 karl    that what I use
22:33 kados   strange
22:33 karl    to log into the db
22:33 kados   how many times have you installed Koha on this machine?
22:33 karl    log out of the db?
22:33 karl    twice
22:33 kados   naw ...
22:33 kados   ok
22:33 karl    once, the inital
22:33 karl    then, the upgrade last night
22:34 kados   hmmm, upgrade shouldn't count
22:34 kados   does that DBD error say "using password=Yes" or something like that?
22:35 karl    no
22:35 chris   i know the problem
22:35 chris   its the lock_tables buy
22:35 chris   bug
22:35 karl    in mysql?
22:35 kados   ahh
22:35 chris   yeah, heres the problem
22:35 chris   old versions of mysql dont have a lock_tables priv
22:35 chris   so koha doesnt set it
22:36 kados   nice catch chris
22:36 chris   but new versions do
22:36 karl    humm, this is 4.0.24 I thing
22:36 karl    k
22:36 chris   so do you know ur way around mysql privileges?
22:36 chris   mysql -uroot -ppassword mysql
22:36 karl    log out as kohaadmin?
22:36 chris   yeah
22:36 karl    k
22:37 chris   then do a select * from db;
22:37 chris   ull see the kohaadmin user has a N in the lock_table privs column
22:37 chris   is that right?
22:37 karl    hang on
22:38 karl    ok im in
22:39 karl    yeah I think I see it
22:39 chris   cool
22:39 karl    so change that?
22:39 karl    humm
22:39 chris   yep
22:39 karl    oh my...
22:39 chris   update db set lock_table_privs = 'Y' where user='kohaadmin';
22:39 chris   oughta do it
22:40 karl    gave an error column name rong
22:40 chris   ahh well whatever the column is called :-)
22:40 karl    I see what it should be
22:41 karl    mysql> update db set lock_table_privs = 'Y' where user='kohaadmin';
22:41 karl    ERROR 1054: Unknown column 'lock_table_privs' in 'field list'
22:41 karl    mysql> update db set lock_tables_privs = 'Y' where user='kohaadmin';
22:41 karl    ERROR 1054: Unknown column 'lock_tables_privs' in 'field list'
22:41 karl    mysql> update db set Lock_Tables_privs = 'Y' where user='kohaadmin';
22:41 karl    ERROR 1054: Unknown column 'Lock_Tables_privs' in 'field list'
22:41 karl    oh I se
22:41 karl    hang on
22:41 karl    ok did it
22:41 chris   cool
22:41 chris   quit;
22:41 chris   then
22:42 chris   mysqladmin -uroot -ppassword reload
22:42 chris   that tells it to reload its permissions
22:42 chris   and then try running bulkmarcimport again
22:42 karl    k
22:43 karl    ok its running
22:43 chris   excellent
22:43 karl    heh
22:43 chris   it will probably take a little while
22:43 karl    yup
22:44 karl    still grinding..
22:44 chris   yeah, 3000 records will take quite a while
22:45 chris   depending on the speed of your cpu
22:45 karl    and whatever else I have running, have folding@home crunching too
22:46 chris   right
22:46 chris   you could background that process
22:46 chris   and run
22:46 chris   mysqladmin -uroot -ppassword status
22:46 chris   to see how mysql is getting along ;)
22:47 karl    bash-2.05b$ mysqladmin -u kdagee -p status
22:47 karl    Enter password:
22:47 karl    Uptime: 21927  Threads: 2  Questions: 268615  Slow queries: 0  Opens: 289  Flush tables: 1  Open tables: 59  Queries per second avg: 12.250
22:47 chris   rocking along
22:47 karl    lemme kill fah
22:48 karl    Uptime: 21927  Threads: 2  Questions: 268615  Slow queries: 0  Opens: 289  Flush tables: 1  Open tables: 59  Queries per second avg: 12.250
22:48 karl    Uptime: 22030  Threads: 2  Questions: 359621  Slow queries: 0  Opens: 289  Flush tables: 1  Open tables: 59  Queries per second avg: 16.32
22:49 chris   thats a bit faster now
22:49 karl    Uptime: 22099  Threads: 2  Questions: 414381  Slow queries: 0  Opens: 289  Flush tables: 1  Open tables: 59  Queries per second avg: 18.751
22:51 karl    done...
22:51 karl    2645 MARC record done in 476.40714097023 seconds
22:51 chris   sweet
22:51 karl    now what.....
22:51 chris   now you should have a pile of records in your database
22:52 chris   if you jump in the opac
22:52 chris   and try a few searches
22:52 chris   fish ... that almost always works in every library
22:52 chris   ppl always seem to have a book with fish in the title :-)
22:52 karl    ah
22:52 chris   but thats essentially how youd get your data in
22:52 karl    alll kindsa things here.........
22:52 chris   if you can get it to marc
22:53 chris   then u can just run that script to load it all in
22:53 karl    getting it to marc is the secret
22:53 chris   yep
22:53 chris   hopefully marcedit can do that
22:53 karl    hummmmmmmmm
22:53 karl    have to look at it closely
22:53 indradg hi all... g'morning!]
22:53 karl    see if i can figr it out
22:54 karl    g'day
22:54 karl    going to save this chat and print it out
22:54 karl    lots of good info
22:54 karl    thanks much
22:54 karl    to you and kados
22:55 karl    8-)
22:56 chris   no problem
22:56 karl    I'm sure I'll have other questions.....
22:56 chris   have u seen koha.org/irc/
22:56 chris   http://koha.org/irc/
22:56 karl    no
22:57 karl    what is it
22:57 chris   its the log of this channel
22:57 karl    ah
22:57 karl    cool
22:57 karl    lemme ask ths
22:57 karl    one of the things I am dealing with is our tech committee chair
22:57 karl    he's a die-hard microsoft guy
22:57 chris   you can mark this chat and save it on there too
22:57 karl    co
22:57 karl    not hot about open source and linux
22:58 chris   right
22:58 karl    but, guess what, dude?
22:58 karl    our church web site runs on linux and apache!
22:58 karl    8-D
22:58 chris   :)
22:58 karl    I've got to find out if the hosting service has mysql available
22:58 karl    sounds like a mom and pop
22:59 chris   right
22:59 karl    anyway, he's concerned about security....if someone hacks the database
22:59 karl    and it blows up
22:59 chris   hes a die hard m$ guy .. and hes concerned about security ... how can that be? :-)
22:59 karl    I said, look, the web site is running on linux and apache, it can be hacked, defaced, etc
22:59 karl    heh
22:59 karl    I said, you have to restore that, too
23:00 karl    he said
23:00 indradg oxymoron ;)
23:00 karl    well, all we have to do is push a magic button and its all restored....
23:00 karl    8-D
23:00 karl    8-D
23:00 karl    8-D
23:00 chris   what id do, is mysqldump the database nightly
23:00 karl    sheesh
23:00 karl    right
23:00 chris   and scp it to another machine
23:00 karl    I told him backups, man
23:00 chris   yeah
23:01 karl    I can setup a cron job for that
23:01 chris   yep
23:03 karl    well thanks again I am going to play with this some see what is there how it owrks
23:03 karl    ;-)
23:03 karl    g'night all
05:57 hdl     hi
09:43 hdl     paul ?
09:43 paul    vivi
09:43 hdl     on peut se voir ?
09:56 hdl     paul : il semblerait que le blinddetail.pl ait un problème chez moi. Je voudrais avoir confirmation.
09:56 hdl     Je crée une notice.
10:09 kados   hi all
10:09 kados   paul around?
10:09 paul    (on web conf with hdl, b back soon)
10:10 kados   in release 2.2 and 2.2.1 there was data sample for 1.2 ... could we remove that in future versions ... and maybe include data for 2.2.x?
10:10 kados   it's confusing for newbies
10:26 paul    removing sample-1.2 is easy.
10:26 paul    adding sample for 2.2.2 is harder (except if you want something in french ;-) )
10:36 kados   maybe I can contribute some
10:37 kados   what would be the best format?
10:53 paul    kados : a mysqldump.
10:58 kados   k