Time Nick Message
19:05 ambrose|w we have really weird issuing rules here
19:02 kados (s/\/var\/www/\your www dir/
19:02 kados chris if we moved it to /var/www it wouldn't be a problem at all eh?
19:02 ambrose|w oh, i see it now, in /tmp here
19:01 kados ambrose|w: mine is in /usr/tmp chris's is in /tmp
19:01 ambrose|w where is the session log supposed to be? or is this a cvs thing?
19:00 chris that you can live with
19:00 chris its just finding a compromise
19:00 chris there is always a security vs functionality tradeoff
19:00 chris ie even with access you cant do much
18:59 chris i think selinux is designed more for a box where you dont have trusted users on it
18:59 kados right
18:58 chris but you could just do away with it
18:58 kados selinux and Koha are a tough match
18:57 chris its a useful log to see who logged in to koha etc
18:56 kados you wouldn't :-)
18:55 chris how would you do that? without access on the box?
18:55 kados well a symlink to /var/www/index.html
18:55 kados that's what I was wondering
18:55 chris cant see how ud exploit it
18:54 kados ahh
18:54 chris its never read from
18:54 chris its just a log
18:54 kados can we move that to /var/www
18:54 kados ok ... so that's a potential exploit eh?
18:54 chris yeah goes to /tmp
18:53 kados do you have a sessionlog line in Auth.pm?
18:52 kados hmmm
18:52 chris i dont even have a /usr/tmp :)
18:51 chris no idea
18:51 kados chris ... so the sessionlog created in /usr/tmp ... is that critical to Koha?
18:30 ambrose|w i'll fix it in cvs (just one file i think) as soon as i get back home
18:28 ambrose|w i think HTML Mason requires the "http-equiv" header, and the xml files currently do not have this tag
18:27 ambrose|w just a note that non-iso8859-1 support in 2.2 is currently broken for the "css" theme
18:26 kados wow ... everyone is here today :-)
18:26 kados hi ambrose|w
18:26 ambrose|w hello everyone
18:25 kados he's going to change the selinux policy to allow it
18:25 kados I was just talking to colin about some selinux probs I'm having with perl not having permissions to access /usr/tmp
18:24 kados looks like perl might
18:23 chris not that im aware of, it could tho for some of the new stuff, like the ldap things or something
18:20 kados when I do find / -inum 866790 I get /usr/tmp listed
18:18 kados chris does Koha use /usr/tmp for anything?
18:14 JYL57 Or should I have to delete the impacted notices and reimport after ?!
18:14 JYL57 Is it a "mysql way" to clean up that mess ?!
18:14 JYL57 and I 've lost all accents in the loaded notices
18:13 JYL57 someone has imported in the reservoir from a windows PC
18:10 JYL57 Wow, lots of people here !
17:44 kados pinning might not be possible with yum but I'm not sure
17:42 kados it might be faster too (as of FC3 ... FC2's yum was a dog)
17:42 chris sweet
17:42 kados well I can't think of anything I can do with apt I havn't been able to do with yum
17:41 chris thats a big call :)
17:41 kados yum might be better than apt-get
17:41 kados you'd like yum too (FC thing)
17:41 kados it's pretty neat
17:41 chris ive neve played with selinux .. i should sometime i guess
17:40 chris well, i did a lot of work on the original koha, theres a lot more work done by others in 2.2 than by me .. thats the great thing about free software :)
17:40 kados getting selinux working with a cvs repo turns out to be quite a challenge
17:40 chris heya kados
17:39 kados hey chris
17:39 kados garth: just so you know chris wrote Koha ;-)
17:18 chris http://www.saas.nsw.edu.au/koha_wiki/index.php?page=KohaUsers when u get a chance you could add your details to here if you like :)
17:18 garth Appreciate the assist, thanks again
17:17 chris cool
17:17 garth Thanks, I'll report back how it goes
17:17 chris no worries, good luck
17:15 garth Thanks man, that saves me big time
17:15 garth ok, I'll do that right now.
17:15 chris ive done 1.2.x to 2.0.x successfully many times
17:14 chris then upgrade again to 2.2.2
17:14 chris then upgrade that to 2.0.2
17:14 garth right
17:14 chris take a copy of the database, and everything in /usr/local/koha .. plus /etc/koha.conf etc and set it up on a new machine
17:13 chris garth: the safest way, and most likely to succeed way is
17:13 owen I'm not sure of the reason, but Paul made it pretty clear that you couldn't upgrade directly from 1.2 to 2.2
17:11 garth Hey guys, I was out. From what I read 1.2 => 2.2 cannot be done via updatedatabase? Is this a correct understanding?
17:06 tim Yeah. I know just enough perl to get started, but not enough to finish.
17:05 kados congrats ... formats will probably be a bit harder
17:05 tim Yup. They're showing up now.
17:04 kados what's the status? looks like you got subtitles working eh?
17:04 tim No problem.
17:04 kados sorry tim ... I stepped away fr a minute
17:03 tim Oh yeah. That was using MARC::Batch. Trying to fix the field befor I import into Koha.
16:50 tim replace ang with and, then replace any other typos with whatever they should be.
16:47 tim ang if I read the record in and $field852_6 holds the format from the old system. How do I write it back so $format{$field852_6} will replace the old 852_6 field?
16:45 tim ...);
16:45 tim 'oldformat2' => 'ITEM2'.
16:45 tim 'oldformat' => 'ITEM',
16:45 tim my %format = (
16:45 tim So if I have a hash like:
16:42 owen That's how we handle it, with item types.
16:41 tim I'm thinking item types would be the same as formats in our current system. Telling if it's a book, book on tape, video....
16:40 tim Moving on to formats. :)
16:34 tim Thanks for the help. Subtitles seem to be working now.
16:24 tim I still get the framework error.
16:23 tim Just a small test batch for now.
16:23 tim bulkmarcimport.pl
16:22 kados how did you get your data in the database in the firstplace (on the test box)?
16:22 kados ok ... updatedatabase should get your framework code in there ...
16:21 kados whew! :-)
16:21 tim this thing's way too far from ready to go.
16:21 tim No I didn't. And yes I am.
16:20 kados and please tell me you're doing this on a test machine ;-)
16:20 kados tim did you run updatedatabase?
16:18 tim DBD::mysql::st execute failed: Column 'frameworkcode' cannot be null at /usr/local/koha/intranet/modules/C4/Biblio.pm line 343.
16:18 tim I'm betting an error for each record.
16:17 tim Do I just run koha2marc.pl or do I add parameters?
16:17 tim Sorry about the short replies. Working the circ desk too.
16:12 tim No. Didn't know about that.
16:00 kados and you ran koha2marc.pl after making the change?
15:57 tim nope
15:57 kados well maybe paul changed the name or maybe stephen mis-remembered it ... does bibliosubtitle.title work?
15:54 tim Any idea what would cause the problem?
15:54 tim I just read on the mailing list that I'm supposed to map subtitles to bibliosubtitle.subtitle, but my setup (version 2.2.0) has bibliosubtitle.title in the Koha links menu.
15:47 owen Almost missed it
15:36 kados http://www.nasa.gov/multimedia/nasatv/index.html
15:36 kados nasa takeoff in <2 min:
13:36 paul that's why we changed the major code ;-)
13:36 paul 1.2 => 2.0 can't be.
13:36 paul 2.0 => 2.2 is automatic
13:35 paul if this case, you have the same problem...
13:35 paul you mean 2.0 ?
13:29 garth Just get them safely to 2.x
13:29 garth After your feedback I'm planning NOT to run koha2marc
13:29 paul yes, but you will have to run koha2marc again
13:28 garth I'll plan on doing that
13:28 garth If I can get them up and running on 2.x I can leave MARC for phase 2
13:28 paul if you have MARC21 lines, then it could work
13:28 paul (or Koha >> parameters >> biblio frameworks)
13:27 paul look in marc_*_structure tables
13:27 garth gotcha
13:27 kados garth: paul is the expert here just so you know ;-)
13:27 garth Should I not try to go koha => MARC?
13:26 paul if you don't have added marc21 parameters
13:26 paul should not work at all...
13:26 kados how's it look?
13:26 garth cool
13:26 kados good ...
13:25 garth ?
13:25 garth How's that sound.
13:25 garth 3. run updatedatabase and koha2marc.pl
13:24 garth 2. install Koha 2.2.0 on the new machine
13:24 garth 1. run mysqldump --add-drop-table -u -p Koha > koha.sql on your current production machine
13:24 garth Here is what I have so far
13:23 garth hi guys, I'm back for about 45 mins
13:17 paul yes & running / testing the koha2marc.pl script
13:16 owen Configuring MARC?
13:16 kados the main problem I think is MARC
13:16 kados well some upgrade scripts need to be written
13:16 kados garth: if you can, keep track of all the steps you take and we can add that to the update/upgrade manual on http://kohadocs.org
13:15 owen I wonder what would have to be done to reduce that time, minus the learning, training, etc?
13:14 kados garth: of course it depends on the size of your system and how many customizations you have ...
13:14 kados garth: I'd give yourself at least a week ... a few days to get it 'running' then a few days to test, find bugs, learn the new features ... then there's the staff training, etc.
13:07 garth I'll be out for the next 3 hrs, but any feedback would be appreciated
13:02 garth so, what do you guys see as a realistic timetable for the upgrade?
13:00 kados interesting link though :-)
13:00 kados oops ... finger slipped
12:59 kados http://cites.boisestate.edu/civ5i2.pdf
12:59 owen Of course we're revamping our templates at the same time, kados
12:59 garth Well :-), I need a challenge
12:59 paul impossible, if you want my opinion
12:59 kados NPL has been working on our upgrade from 2.0 to 2.2 for several weeks ;-)
12:59 kados wow ... that's quite a tight timetable
12:58 garth great , I hope to have it done in the next 5 hours barring interruptions
12:58 paul koha or koha-dev mailing list.
12:58 kados garth: I'll be around all day on IRC
12:58 garth guys, I'm working on the upgrade today, is there an email that I can contact if I hit a snag?
12:55 garth Another question, I have only used 1.2.x so far, but can you delete the z39.50 queries in 2.x?
12:54 owen 'morning all
12:53 garth I will as I have to upgrade them
12:53 kados garth: ok ... so you'll need MARC21
12:53 paul misc/koha2marc.pl
12:53 paul to rebuild the MARC-DB from the non MARC one, you have the script
12:53 kados garth: if you document your upgrade procedures we would love to have them for http://kohadocs.org BTW :-)
12:53 garth I'm in Greenville, SC, USA
12:53 garth By the way, if the updatedb script complains where do I find instructions to manually upgrade?
12:53 paul because in Koha 2.2, all searches are on MARC-DB, and the MARC-DB will be more and more used
12:52 paul garth : wether you have MARC=ON of MARC=OFF, you MUST have a working MARCDB
12:52 kados garth: right ... so are you in the US?
12:52 garth I would like to use marc as that would future proof them
12:51 garth ok, guys I appreciate your help as I'm really time constrained on this project
12:51 kados garth: have you decided whether to use MARC or not?
12:51 kados now ... that would be the fastest way to upgrade ... but if updatedatabase can't handle the upgrade from 1.x to 2.x you might have to do it manually
12:50 kados run updatedatabase (it's in /misc)
12:50 garth right
12:50 kados import your data directly into mysql
12:50 kados install Koha 2.2.0 on the new machine
12:49 kados copy the koha.sql file to your 'new' production machine
12:49 garth so my current situation is 1.2.3 on their "current" production server and a virtual host on their "new" machine
12:49 kados * run mysqldump --add-drop-table -u -p Koha > koha.sql on your current production machine
12:48 garth They have a virtual host that I could use for the install but I have a feeling this is going to be a very mnaual upgrade
12:48 kados download Koha 2.2.0
12:48 kados here's how I would do it:
12:48 kados then when it's ready you could make the change
12:48 garth that's what I'm thinking
12:48 paul because 1.2 => 2.0 has MARC datas !!!
12:48 kados as a test machine
12:47 kados garth: I suppose you could use the 'new' production machine
12:47 garth ok
12:47 paul it's a long process & you may have some pain here
12:47 kados garth: you need a test machine ...
12:47 paul not on prod !!!
12:47 paul (and read carefully release note to see how you can migrate you datas to MARC DB)
12:47 garth I see, on current prod machine update to 2.0.2
12:47 paul you UPDATE to 2.0.2
12:47 paul (DB, sorry)
12:47 paul when it runs like in the prod DN
12:46 garth ok
12:46 paul * you make a copy of 1.2.3 DB AND software
12:46 garth what about all their data
12:46 paul NO
12:46 paul you may have to update manually
12:46 garth So on their new server install 2.0.2
12:46 paul (2.0.0 => 2.2.0 will work, for this i'm sure)
12:46 paul in fact, i'm almost sure it will not work.
12:45 paul (chris was release manager for 1.2.x)
12:45 paul you should ask chris & look into your install
12:45 paul i'm not sure there is the intranetdir in /etc/koha.conf
12:45 paul (note that their may be a problem with updater)
12:45 paul * download 2.2.0 and run koha.updater again.
12:44 paul * download 2.0.2 and run koha.updater
12:44 paul when you have your test server :
12:44 garth in your estimation
12:44 garth What is the best way
12:44 paul probably, but i haven't tested it
12:43 kados paul: could updatedatabase handle an upgrade from 1.x to 2.x?
12:43 paul you must create a test server with a working copy of the 1.2.3
12:43 paul no ! there are many many many new tables.
12:43 paul (even if 1.2.3 => 2.2.0 could work)
12:43 garth Can I simply move the mysql data to the new server or is there more to it
12:43 paul you should do 1.2.3 => 2.0.2 => 2.2.0
12:42 paul and what is your question ?
12:42 garth I have a question, they are running currently 1.2.3 and I would like to move them to 2.2.x on their new server?
12:42 kados hehe
12:42 paul that's what is great with free software : reduce south/north differences
12:41 kados garth: if you like, post your details to the list so we can get you listed on our 'koha users' map
12:41 kados garth: great!
12:40 garth Thanks guys!!
12:40 garth I did an install for a non profit who could not have afforded library software without koha
12:39 kados hi garth
12:39 kados paul: ok ... I'll do some testing then ...
12:39 garth hi folks, I want to thank you for a great product
12:39 paul kados & me at the moment
12:39 paul yes garth, hello
12:39 paul but, probably needs more testing
12:39 garth anybody home?
12:38 paul i've fixed what i've found.
12:38 paul you mean librarians perms ?
12:38 kados paul do you know if the permissions have been fixed in Koha 2.2?
12:37 kados :-)
12:37 paul (error : evening for France ;-) )
12:36 kados morning paul :-)
12:27 paul but wishes a happy day to joshua
12:23 kados paul: and have more than one ssl 'site' running at the same time?
12:23 kados paul: I could use the same IP, and a different port for ssl?