IRC log for #koha, 2005-04-01

All times shown according to UTC.

Time S 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[…]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-bi[…]ha/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[…]mple/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[…]ddbiblio.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-bi[…]ha/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-bi[…]ha/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/m​isc/migration_tools/bulkmarcimport.pl
22:21 karl /usr/home/kdagee/koha-2.2.1/scripts/m​isc/migration_tools/bulkmarcimport.pl
22:21 karl /usr/local/koha/intranet/scripts/mis​c/migration_tools/bulkmarcimport.pl
22:21 karl /usr/local/koha/intranet/scripts20050329​1957/misc/migration_tools/bulkmarcimport
22:21 chris yep so go
22:21 chris cd /usr/local/koha/intranet/sc​ripts/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

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary