localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 336.localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 336home crunching too← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 12:03 | indradg | kados, hi |
| 12:04 | kados, I was reading old chat transcripts | |
| 12:04 | kados | in indradg |
| 12:04 | 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 | my 2.2.1 update went awry | |
| 12:05 | currently rolled back to 2.0.0 :( | |
| 12:05 | kados | huh ... have you tried REPAIR TABLE marc_word? |
| 12:05 | (might take a while) | |
| 12:06 | indradg | not yet... located the problem just before leaving from office today |
| 12:06 | 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 | 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 | 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 | is Chris in here? | |
| 20:43 | chris | yep im here |
| 20:43 | karl | ah |
| 20:43 | wuz wondering if I was going to have to send a penquin in after you... | |
| 20:44 | ;-) | |
| 20:44 | ok so where to start... | |
| 20:44 | you go first | |
| 20:44 | chris | so what are the current problems ur having? |
| 20:45 | karl | 8-D |
| 20:45 | well, there is a bunch of data in the database | |
| 20:45 | that I think is "test data" from the install | |
| 20:45 | chris | cool |
| 20:45 | karl | I cant get it into koha |
| 20:45 | actually, I can | |
| 20:46 | I have two listings biblios in there | |
| 20:46 | one for Old Yeller | |
| 20:46 | but, when I try to do an opac search it doesnt bring it up | |
| 20:46 | lemme start it up brb | |
| 20:47 | ok the admin interface is up | |
| 20:48 | 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 | leme check | |
| 20:50 | yah there are entries | |
| 20:50 | kados | karl: have you populated marc_word ? |
| 20:50 | hiya all ;-) | |
| 20:50 | karl | hellow |
| 20:50 | marc_word....is that a database table? | |
| 20:51 | Q : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1 | |
| 20:51 | where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=bibl | |
| 20:51 | ioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.word like 'yeller') | |
| 20:51 | order by biblio.title at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line | |
| 20:51 | 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 | Q2 : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m | |
| 20:52 | 1,marc_word as m2 where biblio.biblionumber=marc_biblio.biblionumber and biblio. | |
| 20:52 | biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.bib | |
| 20:52 | id=m2.bibid) and ((m1.word like 'Old' and m1.tagsubfield in ('245a'))and (m2.wo | |
| 20:52 | rd like 'Yeller' and m2.tagsubfield in('245a'))) order by biblio.title term is | |
| 20:52 | Old Yeller at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line | |
| 20:52 | 268. | |
| 20:53 | kados | here's a working and fairly complete stopwords table: |
| 20:53 | kados.org/stopwords.sql | |
| 20:53 | 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 | as its not erroring | |
| 20:56 | just not returning a result | |
| 20:57 | 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 | just finished it | |
| 20:57 | same result | |
| 20:57 | nothing found on "yeller" | |
| 20:58 | chris | right |
| 20:58 | 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 | get ya? | |
| 20:59 | karl | hangon |
| 21:00 | lots | |
| 21:00 | returns 502 rows | |
| 21:00 | 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 | 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 | 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 | no I didnt | |
| 21:05 | 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 | and MARC chedk | |
| 21:06 | 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 | there are fields with tags and subfileds identified | |
| 21:07 | like "title 245 a Title" | |
| 21:08 | kados | right |
| 21:08 | hmmm ... | |
| 21:08 | 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 | 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 | 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 | whs that | |
| 21:11 | that a script? | |
| 21:11 | kados | 1.2 data shouldn't be in 2.2 release ;-) |
| 21:11 | yep | |
| 21:11 | karl | well it wuz |
| 21:11 | kados | misc/updater I think |
| 21:11 | karl | ok |
| 21:12 | lemme run it | |
| 21:12 | -su-2.05b# ./updatedatabase | |
| 21:12 | 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 | BEGIN failed--compilation aborted at ./updatedatabase line 22. | |
| 21:12 | kados | perl -I /usr/local/koha/intranet/modules updatedatabase |
| 21:13 | ;-) | |
| 21:13 | karl | ok |
| 21:13 | 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 | connected to your DB. Checking & modifying it | |
| 21:13 | Alter z3950random in marc_breeding | |
| 21:13 | Alter bookfundid in aqbookfund | |
| 21:13 | kados | cool |
| 21:13 | karl | Alter aqbudgetid in aqbudget |
| 21:14 | Alter id in z3950servers | |
| 21:14 | Checking for data required in table userflags... | |
| 21:14 | 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 | 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 | (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 | run updatedatabase | |
| 21:15 | then upgrade to 2.2 | |
| 21:15 | and run it again ;-) | |
| 21:16 | 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 | 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 | 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 | only place to enter anything is "supplier name" | |
| 21:18 | kados | http://koha.liblime.com/cgi-bi[…]ha/export/marc.pl |
| 21:18 | 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 | go to systempreferences | |
| 21:20 | 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 | 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 | 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 | 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 | 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 | author: neal stephenson | |
| 21:24 | isbn:0060512806 | |
| 21:24 | karl | what screen |
| 21:24 | 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 | just fill in the title | |
| 21:26 | 245 a | |
| 21:26 | and then the item stuff | |
| 21:27 | karl | whoa hang on |
| 21:28 | well I got the "5" in after "24 and put the title in "standard number or code" window | |
| 21:28 | is that what you wanted | |
| 21:29 | chris | umm no |
| 21:29 | karl | oh |
| 21:29 | 8-D | |
| 21:29 | lets start over | |
| 21:30 | ok I see | |
| 21:30 | 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 | right? | |
| 21:32 | 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 | ok I am at that login | |
| 21:34 | koha login cardnumber pw teal screen | |
| 21:34 | chris | nooo |
| 21:34 | hehe | |
| 21:34 | karl | 8-( |
| 21:34 | chris | i meant the page you are at, will have a url like that |
| 21:34 | 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 | 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 | ok its where to put the listing the branch and holding branch | |
| 21:36 | chris | ahhh |
| 21:36 | 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 | make up a title, and add it in the title field :) | |
| 21:37 | something like karls test book | |
| 21:37 | karl | ok nothing found for "I, Robot" |
| 21:38 | chris | cool |
| 21:38 | so youre at the big hairy form? | |
| 21:38 | karl | nyeah |
| 21:38 | 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 | uh, where is "add bibliographic record" and "go to items" in this window | |
| 21:40 | 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 | 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 | ok I am back to the "marc biblio 504" screen | |
| 21:43 | nothing under existing but the drop downs under new item | |
| 21:43 | chris | so it has stuff like |
| 21:43 | home branch | |
| 21:43 | karl | says home branch |
| 21:43 | 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 | 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 | now in mysql | |
| 21:44 | if you do a | |
| 21:44 | select * from marc_word; | |
| 21:45 | 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 | or the catalog on the admin side | |
| 21:46 | karl | found it |
| 21:46 | 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 | ok | |
| 21:47 | ... | |
| 21:47 | complex program | |
| 21:47 | chris | yep |
| 21:48 | 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 | 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 | 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 | to suck out the isbns | |
| 21:49 | 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 | 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 | 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 | yeah I think this is it | |
| 21:51 | http://oregonstate.edu/~reeset/marcedit/html/ | |
| 21:52 | I did install it on my win2k install | |
| 21:52 | looked complicated | |
| 21:52 | kados | it's a real bummer that isbns aren't more reliable |
| 21:52 | what we need is some kind of isbn translator database | |
| 21:52 | karl | y |
| 21:53 | 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 | somwhere up there.... | |
| 21:54 | kados | http://koha.liblime.com/cgi-bi[…]ha/export/marc.pl |
| 21:55 | user: circ, password: liblime | |
| 21:55 | 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 | you're here? | |
| 21:56 | http://koha.liblime.com/cgi-bi[…]ha/export/marc.pl | |
| 21:56 | karl | yah |
| 21:56 | 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 | you can import that with bulkmarcimport | |
| 21:57 | karl | ok |
| 21:57 | 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 | 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 | but, may not work out that way | |
| 21:59 | I could setup a standalone box | |
| 21:59 | in the library | |
| 21:59 | saw another program havent looked into it further tho | |
| 22:00 | 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 | 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 | yeah no doubt!!! | |
| 22:02 | chris | what it needs (and all projects do) is more documentation |
| 22:02 | karl | no kidding |
| 22:02 | maybe not more, just_better | |
| 22:02 | I'd be interested in helping there (if I can figure out how it works) | |
| 22:04 | I am going to try kados data, see what happens | |
| 22:06 | arggh | |
| 22:06 | -su-2.05b# ./bulkauthimport.pl ../../../marc.pl | |
| 22:06 | 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 | BEGIN failed--compilation aborted at ./bulkauthimport.pl line 10. | |
| 22:07 | got that before | |
| 22:07 | when runnign this script | |
| 22:07 | chris | ull need the -I bit |
| 22:08 | 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 | it should tell ya | |
| 22:09 | karl | -su-2.05b# perl -I /usr/local/koha/intranet/modules updatedatabase |
| 22:09 | 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 | arent you wanting to run bulkmarcimport ? | |
| 22:11 | ie import the records? | |
| 22:11 | karl | yah |
| 22:11 | chris | so that |
| 22:12 | 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 | 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 | and be in the directory with it | |
| 22:13 | karl | i know where it is |
| 22:13 | bulkmarcimport.pl or upgrade? | |
| 22:14 | chris | bulkmarcimport.pl |
| 22:16 | karl | arrrgh |
| 22:16 | -su-2.05b# ./bulkauthimport.pl ../../../marc.pl | |
| 22:16 | 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 | BEGIN failed--compilation aborted at ./bulkauthimport.pl line 10. | |
| 22:17 | chris | right |
| 22:17 | that wont work | |
| 22:17 | u need that command i put in | |
| 22:17 | 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 | gotta change the perms on bulkmarcimport.pl | |
| 22:20 | -rw-r--r-- 1 501 100 4494 Jan 3 07:23 bulkmarcimport.pl | |
| 22:20 | chris | thats fine |
| 22:20 | as long as u use | |
| 22:20 | perl -I /usr/local/koha/intranet/modules bulkmarcimport.pl -file ../../../marc.pl | |
| 22:20 | u just cant go ./bulkmarcimport.pl | |
| 22:21 | karl | not in that directory tho |
| 22:21 | -su-2.05b# locate bulkmarcimport.pl | |
| 22:21 | /usr/home/kdagee/koha-2.2.0/scripts/misc/migration_tools/bulkmarcimport.pl | |
| 22:21 | /usr/home/kdagee/koha-2.2.1/scripts/misc/migration_tools/bulkmarcimport.pl | |
| 22:21 | /usr/local/koha/intranet/scripts/misc/migration_tools/bulkmarcimport.pl | |
| 22:21 | /usr/local/koha/intranet/scripts200503291957/misc/migration_tools/bulkmarcimport | |
| 22:21 | chris | yep so go |
| 22:21 | cd /usr/local/koha/intranet/scripts/misc/migration_tools/ | |
| 22:21 | 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 | 0 MARC record done in 0.00359296798706055 seconds | |
| 22:23 | think it worked | |
| 22:23 | or, did it......... | |
| 22:23 | chris | looks like 0 |
| 22:23 | karl | yah |
| 22:23 | humm | |
| 22:24 | chris | try |
| 22:24 | -n 1 at the end | |
| 22:24 | karl | theres nothing in the file |
| 22:25 | 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 | not | |
| 22:26 | if that file is blank | |
| 22:26 | karl | heh |
| 22:26 | fun eh | |
| 22:26 | chris | try just 1 to 10 |
| 22:26 | karl | k |
| 22:26 | chris | instead of 300 to 500 |
| 22:27 | see if we get anything out | |
| 22:27 | if not, might have to wait till kados is back, and see whats up with his server | |
| 22:27 | karl | nada |
| 22:27 | 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 | np | |
| 22:29 | ok done lemme try | |
| 22:29 | oh yeah | |
| 22:29 | shit | |
| 22:30 | giving me "access denied" | |
| 22:30 | kados | what is? |
| 22:30 | karl | the script |
| 22:30 | DBD::mysql::db do failed: Access denied for user: 'kohaadminlocalhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 336. |
|
| 22:30 | -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 | DBD::mysql::db do failed: Access denied for user: 'kohaadminlocalhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 336 |
|
| 22:31 | kados | right |
| 22:31 | this could be tricky | |
| 22:31 | karl | im logged into the db as kohaadmin |
| 22:31 | arrgh | |
| 22:31 | (in another term window | |
| 22:32 | kados | so check /etc/koha.conf |
| 22:32 | is that the right password for kohaadmin? | |
| 22:32 | karl | yea it is |
| 22:33 | yup | |
| 22:33 | 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 | twice | |
| 22:33 | kados | naw ... |
| 22:33 | ok | |
| 22:33 | karl | once, the inital |
| 22:33 | then, the upgrade last night | |
| 22:34 | kados | hmmm, upgrade shouldn't count |
| 22:34 | 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 | its the lock_tables buy | |
| 22:35 | bug | |
| 22:35 | karl | in mysql? |
| 22:35 | kados | ahh |
| 22:35 | chris | yeah, heres the problem |
| 22:35 | old versions of mysql dont have a lock_tables priv | |
| 22:35 | 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 | k | |
| 22:36 | chris | so do you know ur way around mysql privileges? |
| 22:36 | 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 | ull see the kohaadmin user has a N in the lock_table privs column | |
| 22:37 | is that right? | |
| 22:37 | karl | hang on |
| 22:38 | ok im in | |
| 22:39 | yeah I think I see it | |
| 22:39 | chris | cool |
| 22:39 | karl | so change that? |
| 22:39 | 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 | 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 | mysql> update db set lock_table_privs = 'Y' where user='kohaadmin'; | |
| 22:41 | ERROR 1054: Unknown column 'lock_table_privs' in 'field list' | |
| 22:41 | mysql> update db set lock_tables_privs = 'Y' where user='kohaadmin'; | |
| 22:41 | ERROR 1054: Unknown column 'lock_tables_privs' in 'field list' | |
| 22:41 | mysql> update db set Lock_Tables_privs = 'Y' where user='kohaadmin'; | |
| 22:41 | ERROR 1054: Unknown column 'Lock_Tables_privs' in 'field list' | |
| 22:41 | oh I se | |
| 22:41 | hang on | |
| 22:41 | ok did it | |
| 22:41 | chris | cool |
| 22:41 | quit; | |
| 22:41 | then | |
| 22:42 | mysqladmin -uroot -ppassword reload | |
| 22:42 | that tells it to reload its permissions | |
| 22:42 | and then try running bulkmarcimport again | |
| 22:42 | karl | k |
| 22:43 | 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 | still grinding.. | |
| 22:44 | chris | yeah, 3000 records will take quite a while |
| 22:45 | depending on the speed of your cpu | |
| 22:45 | karl | and whatever else I have running, have foldinghome crunching too |
| 22:46 | chris | right |
| 22:46 | you could background that process | |
| 22:46 | and run | |
| 22:46 | mysqladmin -uroot -ppassword status | |
| 22:46 | to see how mysql is getting along ;) | |
| 22:47 | karl | bash-2.05b$ mysqladmin -u kdagee -p status |
| 22:47 | Enter password: | |
| 22:47 | 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 | 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 | 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 | done... | |
| 22:51 | 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 | if you jump in the opac | |
| 22:52 | and try a few searches | |
| 22:52 | fish ... that almost always works in every library | |
| 22:52 | 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 | 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 | hopefully marcedit can do that | |
| 22:53 | karl | hummmmmmmmm |
| 22:53 | 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 | g'day | |
| 22:54 | going to save this chat and print it out | |
| 22:54 | lots of good info | |
| 22:54 | thanks much | |
| 22:54 | to you and kados | |
| 22:55 | 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 | http://koha.org/irc/ | |
| 22:56 | karl | no |
| 22:57 | what is it | |
| 22:57 | chris | its the log of this channel |
| 22:57 | karl | ah |
| 22:57 | cool | |
| 22:57 | lemme ask ths | |
| 22:57 | one of the things I am dealing with is our tech committee chair | |
| 22:57 | 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 | not hot about open source and linux | |
| 22:58 | chris | right |
| 22:58 | karl | but, guess what, dude? |
| 22:58 | our church web site runs on linux and apache! | |
| 22:58 | 8-D | |
| 22:58 | chris | :) |
| 22:58 | karl | I've got to find out if the hosting service has mysql available |
| 22:58 | 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 | 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 | heh | |
| 22:59 | I said, you have to restore that, too | |
| 23:00 | 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 | 8-D | |
| 23:00 | 8-D | |
| 23:00 | 8-D | |
| 23:00 | chris | what id do, is mysqldump the database nightly |
| 23:00 | karl | sheesh |
| 23:00 | 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 | ;-) | |
| 23:03 | g'night all | |
| 05:57 | hdl | hi |
| 09:43 | paul ? | |
| 09:43 | paul | vivi |
| 09:43 | hdl | on peut se voir ? |
| 09:56 | paul : il semblerait que le blinddetail.pl ait un problème chez moi. Je voudrais avoir confirmation. | |
| 09:56 | Je crée une notice. | |
| 10:09 | kados | hi all |
| 10:09 | 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 | it's confusing for newbies | |
| 10:26 | paul | removing sample-1.2 is easy. |
| 10:26 | 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 | what would be the best format? | |
| 10:53 | paul | kados : a mysqldump. |
| 10:58 | kados | k |
← Previous day | Today | Next day → | Search | Index
