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?