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