00:00:25 <denshi> i'm not all here right now.. I'm busy following the badgerblog links.
00:01:56 <markd2> heh
00:02:02 <markd2> it's paje's karma keeping
00:05:30 <denshi> i was unaware paje kept karma.  I thought paje just kept the corrupting influence of talli close to its young bot heart.
00:12:55 <jim> could someone perform the following test on their openacs-4.5, with oracle if you have it, and with pg-7.1.3 and 7.2: create a user, delete the user, create again. error? still in database?
00:17:01 <denshi> denshi has quit ("denshi has no reason")
00:36:13 <markd2> markd2 has quit ("Bork")
00:37:38 <markd2> markd2 (~Snak@r-41.118.alltel.net) has joined #openacs
00:46:33 <jim> deleting users bad juju, oacs-45 + pg-7.1.3 and 7.2.
01:44:50 <til> markd2: you still there? forcehostp is in 4.x but doesnt work, afaik
01:55:09 <markd2> thanks
01:55:20 <markd2> I did the cheesy thing and wrote a filter
02:09:32 <til> anyone installed dotlrn already? i'm having trouble with the dependencies
02:12:42 <til> seems to boil down to profile-provider requires acs-service-contract of version >= 4.2, but asc is installed already
02:27:46 <til> aargh - forcing the install produces a load of errors
02:32:05 <markd2> :-(
02:35:21 <til> oh i see - i accidentially selected to install portal, which apparently conflicts with some tablenames in dotlrn
02:39:32 <til> so - has anyone the drop-recreate-tablespace script for oracle handy?
02:57:41 <jim> til: I wrote one in perl...
02:58:10 <jim> one sec
02:58:44 <til> cool
03:00:56 <jim> foundit
03:01:52 <jim> got uudecode?
03:04:48 <jim> begin 644 tblspace-create.perl
03:04:48 <jim> M(R$O=7-R+V)I;B]P97)L"@II9B@D(T%21U8@*R`Q("$](#(I"GL*("`@('!R
03:04:48 <jim> M:6YT(%-41$524B`B=7-A9V4Z('1B;'-P86-E+6-R96%T92YP97)L(#QS97)V
03:04:48 <jim> M:6-E3F%M93X@/&1B4&%S<W=D/EQN(CL*("`@(&5X:70@,3L*?0H*)'-E<G9I
03:04:48 <jim> M8V5?;F%M92`]("1!4D=66S!=.PHD9&%T86)A<V5?<&%S<W=O<F0@/2`D05)'
03:04:48 <oacs-chump> Label M not found.
03:04:49 <oacs-chump> Label M not found.
03:05:04 <jim> hmm, that's not the best way
03:05:24 <jim> I should mail it to you
03:05:31 <jim> what's your email address
03:09:35 <jim> til: what's your email address?
03:15:12 <til> oops, sorry, is was away
03:21:39 <til> jim?
03:21:46 <jim> ahh
03:23:35 <jim> sent.
03:23:45 <jim> got uudecode?
03:24:40 <til> got you mail. uuencode ... hmm, give me a hint
03:25:15 <jim> save content in a file, call it tbl.uu maybe
03:25:25 <jim> then uudecode tbl.uu
03:25:41 <jim> or if you don't have uudecode, I'll resend
03:25:46 <jim> plain text
03:26:06 <til> i have uudecode, just using it for the first time
03:27:07 <jim> ok
03:27:43 <jim> if you need to release/distribute it, let me know, I intended to GPL it anyway
03:27:57 <jim> I'll respond by sending it to you again
03:28:38 <til> i think this should be on the openacs.org site
03:28:51 <til> at least i did not find anything similar on the web easily
03:31:24 <jim> one sec
03:31:40 <til> so this is to be piped into sqlplus or what?
03:32:04 <jim> well, notice it's really two scripts
03:32:24 <jim> I've never actually -piped- it... 
03:32:34 <markd2> * markd2 just smokes it
03:32:40 <jim> I cutnpasted the lines individually
03:33:14 <til> i see
03:33:36 <jim> could probably add a getopt-style option parser to it
03:36:42 <til> couldnt you make it execute sqlplus directly? that'd be ubercool
03:40:20 <jim> umm :) yes, I suppose I could do that, but then I'd have to be the one to be ubercareful :)
03:40:57 <til> but then i would have someone to blame ;)
03:41:04 <jim> hah :)
03:41:16 <jim> I should really send this replacement to you :)
03:42:02 <til> maybe you also want to add the line "drop tablespace service_name including contents ;"
03:44:03 <jim> that's an idea... lemme go back and read from the source of where I got the script
03:44:29 <til> drop user cascade did not delete it
03:44:41 <jim> hmm, so yeah
03:44:50 <jim> would have to add something like that/
03:48:20 <davb> davb (dave@alb-24-58-162-46.nycap.rr.com) has joined #openacs
03:55:06 <davb> * davb watches The Matrix
03:55:15 <jim> til: I want to put that in in this next version, could you test to see if I got it right?
03:55:16 <markd2> whoa
03:55:20 <markd2> * markd2 listens to the soundtrack
03:56:07 <til> jim: sure
04:00:15 <jim> sent.
04:01:57 <Psychephylax> :)
04:02:00 <Psychephylax> Matrix is a good movie
04:03:11 <markd2> what's kind of frightening was how many bands on the soundtrack I had other albums for.
04:04:30 <davb> I need to get the soundtrack.
04:04:55 <davb> I need to reinstall oracle :(
04:05:15 <markd2> get the soundtrack first
04:05:24 <markd2> then crank it up when you reinstall oracle
04:05:31 <markd2> why do you need to reinstall oracle?
04:05:50 <davb> I deleted something I shouldn't have...
04:05:56 <markd2> oops
04:06:10 <davb> I blame vinod...
04:06:21 <markd2> I blame vinod too, just on general principles
04:06:31 <davb> right.
04:06:32 <davb> brb
04:06:34 <davb> davb has quit ("Client Exiting")
04:06:36 <jim> til: did it go?
04:06:52 <til> jim: syntax error at newtbl.txt line 68, near "print"
04:07:17 <davb> davb (oracle@alb-24-58-162-46.nycap.rr.com) has joined #openacs
04:07:17 <til> but apart from that it should be ok, since that's the same command that i used to drop the tablespace
04:09:49 <jim> sent...
04:20:48 <talli> talli (~talli@ip64-75-147-40.dial.maui.net) has joined #openacs
04:20:58 <talli> talli has quit (Client Quit)
04:21:24 <talli> talli (~talli@ip64-75-147-40.dial.maui.net) has joined #openacs
04:24:31 <til> jim: i am not sure if the order of drop user and drop tablespace matters. i only tried to drop the user first, so you might want to swap the two statements to be safe
04:25:15 <jim> hmm, ok... but does it work in that order?
04:25:26 <jim> err, the opposite order even
04:26:18 <til> don't know
04:27:30 <til> i mean - it works with drop user first and then drop tablespace
04:27:58 <jim> I was considering putting the user drop first... ok, let me check the order it creates in... 
04:28:21 <markd2> I'd drop the user first.  just seems cleaner
04:28:32 <markd2> clear out the user and all the crap, then the tablespace (if necessary)
04:29:00 <markd2> rather than nuke the tablespace which will get rid of most of the users stuff, and then finsih off the user which will also get rid of the user's stuff if they put things into other tablespaces.
04:29:24 <jim> ok, it creates the tablespace first then the user... it would make sense to drop the user first
04:29:45 <markd2> it'll work either way
04:29:48 <markd2> make it a preference :-)
04:29:54 <jim> sheesh :)
04:31:44 <jim> tils: sent...
04:31:52 <jim> anyone else want this? :)
04:32:16 <davb> me please.
04:32:59 <til> what's the point of uuencode btw?
04:33:17 <jim> avoiding the mail doing anything to it
04:33:37 <markd2> the uuencode keeps mailers from mangling the code
04:33:44 <jim> like if I forget and have a From at the beginning of a line or such
04:34:14 <markd2> or if the mailer is "helpful" and changes all your '=' to '=3D'
04:34:37 <jim> hey, that -is- helpful! I get free clown smileys!
04:34:51 <markd2> LOL
04:34:55 <markd2> k:-O
04:34:59 <markd2> oh my god!  there's an axe in my head!
04:35:23 <jim> or an aKs
04:36:05 <jim> if you were Adam Sandler, the next thing you'd say would be "Gimme some CANDY!"
04:37:04 <jim> sent to dave@thedesignexperience.org
04:38:35 <jim> (note, not a replacement for doing that 3-hour database create extravaganza... you have to do that... but at least with the table space and user, you can just drop and recreate in seconds without having to go thru the 3 hours -again-...
04:38:47 <jim> (yes... I did that...)
04:39:07 <markd2> heh
04:39:34 <jim> at least this way you'll only have to do it -once- :)
04:47:49 <davb> any idea what this means, where I should look?
04:47:50 <davb> ORA-00205: error in identifying controlfile, check alert log for more info
04:48:04 <davb> when I do startup I get that message
04:48:12 <davb> oracle that is. :)
04:48:56 <markd2> *Cause:  The system could not find a controlfile of the specified name and
04:48:57 <markd2>         size.
04:48:57 <markd2> *Action: Check that ALL controlfiles are online and that they are the same
04:48:57 <markd2>         files that the system created at cold start time.
04:49:09 <markd2> so check your startup parameter file
04:49:20 <markd2> and make sure that the control files referenced there actually exist
04:49:45 <markd2> $ORACLE_HOME/../../admin/ora8/pfile 
04:50:11 <davb> thanks alot!
04:50:20 <markd2> also look in the alert log ($ORACLE_HOME/../../admin/ora8/bdump/alert_ora8.log
04:50:31 <markd2> that might tell you exactly whihc control file it's worried about
04:51:40 <davb> aha, no control files...
04:51:54 <davb> at least not where it is looking for them.
04:56:53 <davb> is there a way to make new control files?
04:57:43 <markd2> if you have an existing one, you can make a copy
04:57:46 <markd2> or restore them from backup
04:57:53 <davb> ah...
04:57:55 <davb> darn
04:57:59 <markd2> I'm pretty sure to make brand-spaking new controlfiles requires creating the database
04:58:10 <davb> which I can't do, becasue there are not control files.
04:58:18 <markd2> the controlfiles have all the goodness like the datafiles used, their current transaction id number, etc
04:58:24 <markd2> kinda important stuff :-)
04:58:32 <markd2> if you're just trying to start oracle so you can create a new database
04:58:46 <markd2> you can start 'nomount'. which will just get the instance running (SGA, some background processes)
04:58:52 <markd2> but doesn't need control files
04:58:56 <davb> cool.
04:59:06 <davb> I was paranoid because last time, my database creation failed.
04:59:43 <markd2> if you're truly masochistic / curious, you can have dbassist just generate shell scripts that will create the database and load it up with all the default good stuff
04:59:48 <markd2> and then edit / run those by hand
04:59:58 <davb> yeah, that is the openacs way. :)
05:00:03 <markd2> takes some of the mystery out of things too
05:00:56 <davb> davb has quit (Remote closed the connection)
05:06:25 <jim> markd2: that's what the acs oracle install instructions say to do, isnt' it?
05:07:55 <davb> davb (oracle@alb-24-58-162-46.nycap.rr.com) has joined #openacs
05:08:00 <davb> yeah its working.
05:08:07 <davb> I have i idea how I made it work...
05:08:47 <markd2> heh
05:08:55 <markd2> jim: dunno.  i haven't read 'em in a long time
05:09:25 <jim> davb: btw, sent...
05:13:18 <davb> thanks jim
05:21:04 <til> * til finally installs dotlrn
05:21:15 <markd2> markd2 has quit ("wheeeee")
05:22:26 <til> does the apm system have the possibility to mark conflicts between packages? portal and new-portal cannot be installed at the same time
05:24:05 <til> aargh, errors loading dotlrn-create.sql
05:24:19 <jim> what is dotlrn?
05:24:48 <til> dotlrn.openforce.org
05:28:19 <jim> jim has quit (Remote closed the connection)
05:33:23 <davb> til, did you remove all the unused packages from your install?
05:33:45 <davb> I am installing oracle now to see what I can see :)
05:34:23 <jim> jim (~jim@12-233-187-5.client.attbi.com) has joined #openacs
05:34:50 <til> davb: well, i wiped out the tablespace and created a new one, that should suffice ;)
05:35:19 <til> and then i only installed the oacs packages that are listed in the install guide as necessary to checkout from cvs
05:35:50 <davb> ok
05:36:06 <davb> uhoh... ORA-29515: exit called from Java code with status 0
05:36:21 <davb> seems to still be going though...
05:36:40 <jim> oracle error... sun is successful... must beat up...
05:37:03 <jim> seriously, isn't a zero exit an indicator of success?
05:41:09 <davb> could be...
05:41:17 <davb> I think I'll just let it go for awhile
05:58:02 <Psychephylax> Psychephylax has quit ("Killed by frash (Requested by panasync)")
07:31:22 <talli> talli has quit ("Client Exiting")
11:51:27 <davb> tada
11:51:36 <davb> darn, I should have timed it
11:51:40 <davb> brb
11:51:42 <davb> davb has quit ("Client Exiting")
13:44:37 <davb> davb (dave@alb-24-58-162-46.nycap.rr.com) has joined #openacs
16:50:20 <denshi> denshi (toddg@linux128.ma.utexas.edu) has joined #openacs
16:53:38 <denshi> denshi has quit (Client Quit)
17:01:36 <markd2> markd2 (~Snak@r-41.156.alltel.net) has joined #openacs
17:52:14 <davb> * davb tests jim's tablespace script
18:00:04 <markd2> * markd2 wonders why his badgertronics user and tablespace just got dropped
18:02:06 <davb> oops... 
18:02:14 <davb> :)
18:38:40 <davb> this seems bad: Acs-content-repository not installed.
18:38:40 <davb> Error:
18:38:40 <davb> couldn't execute "/ora8/m01/app/oracle/product/8.1.7/bin/loadjava": no such file or directory
18:38:40 <davb> *
18:39:18 <markd2> wow
18:39:25 <davb> I looked, its there. 
18:39:32 <davb> maybe the path is broken...
18:39:39 <markd2> it's a shell script
18:39:53 <markd2> so that 'no such file or directory' could mean that something in the script isn't being found
18:39:56 <markd2> I bet you're right about the path
18:39:58 <davb> ah, ksh is missing (not installed)
18:40:28 <markd2> on my system ksh is a symlink to sh is a symlink to bash
18:40:38 <davb> yes, now mine is too.
18:40:46 <markd2> and bash is a symlink to ksh
18:40:57 <markd2> (so that's why it takes so long to start up)
18:41:10 <davb> oh... :)
19:37:36 <davb> time to test that script again... 
19:38:44 <markd2> I've got backups now
19:38:46 <markd2> do your worst!
19:59:10 <davb> actually the script is just dropping the user with cascade. so the tablespace is still there, much easier.
20:45:52 <rbm> rbm (rmello@fslc.usu.edu) has joined #openacs
20:45:54 <rbm> ooom
20:54:55 <markd2> hiya
20:55:46 <rbm> how goes it markd2?
20:57:22 <markd2> going good
20:57:28 <rbm> Excellent
20:57:32 <markd2> did Paje get returned home?
20:58:06 <rbm> He's not here?
20:58:17 <rbm> Hmmm, guess not. Don't know why he disconnected.
20:58:24 <markd2> paje, spank davb
20:58:33 <paje> paje (~paje@slxwy.dorms.usu.edu) has joined #openacs
20:58:37 <markd2> yay!
20:58:42 <markd2> paje, spank davb
20:58:43 <paje> markd2: sorry...
21:00:19 <markd2> rbm++
21:04:08 <rbm> markd2: :)
21:10:24 <davb> hey!
21:10:49 <rbm> hay davb
21:10:54 <davb> I got openacs 4.5 intsalled finally on oracle.
21:11:05 <davb> next to install dotlrn...
21:14:47 <markd2> http://dailynews.yahoo.com/h/kgtv/20020329/lo/1140963_1.html
21:14:47 <oacs-chump> A: http://dailynews.yahoo.com/h/kgtv/20020329/lo/1140963_1.html from markd2
21:14:54 <markd2> A:|Peeps are one tough mutha's
21:14:54 <oacs-chump> titled item A
21:20:37 <rbm> "mutha's"?
21:21:01 <markd2> * markd2 tries to gitdown, gitfunky in da' hood
21:43:24 <lilo> [Global Notice] Hi all.  In about a half hour we'll be attempting our first major upgrade of the holiday weekend.  This will involving upgrading a central hub and will probably affect nearly everybody on the network.  We'll notify you as it gets closer
22:07:54 <lilo> [Global Notice] Hi all.  We're about 5 minutes away from the upgrade of a major hub.  Nearly everybody will be affected.  Apologies in advance for the join storm.
22:11:00 <davb> brb
22:11:02 <davb> davb has quit ("Client Exiting")
22:12:21 <k2pts> k2pts (~nkd@213.149.180.151) has joined #openacs
22:12:41 <lilo> [Global Notice] Okay, here it goes.  Hopefully see you on the other side. 8)
22:12:48 <markd2> markd2 has quit (zahn.openprojects.net irc.openprojects.net)
22:12:48 <paje> paje has quit (zahn.openprojects.net irc.openprojects.net)
22:12:48 <GEM_> GEM_ has quit (zahn.openprojects.net irc.openprojects.net)
22:12:48 <shagster> shagster has quit (zahn.openprojects.net irc.openprojects.net)
22:12:48 <tontsa> tontsa has quit (zahn.openprojects.net irc.openprojects.net)
22:12:48 <k2pts> k2pts has left #openacs
22:13:22 <paje> paje (~paje@slxwy.dorms.usu.edu) has joined #openacs
22:14:15 <davb> davb (dave@alb-24-58-162-46.nycap.rr.com) has joined #openacs
22:14:59 <til> til has quit (zahn.openprojects.net irc.openprojects.net)
22:15:12 <irc.openprojects.net> Disconnected from irc.openprojects.net (Connection reset by peer)
22:19:27 <oacs-logger> oacs-logger (nobody@xd84b5c5a.ip.ggn.net) has joined #openacs
22:19:27 <carter.openprojects.net> Users on #openacs: oacs-logger 
22:19:27 <ChanServ> [#openacs] This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog
22:20:13 <oacs-chump> oacs-chump (~oacs-chum@alb-24-58-160-41.nycap.rr.com) has joined #openacs
22:22:18 <markd2> markd2 (~Snak@r-41.156.alltel.net) has joined #openacs
22:23:21 <tontsa> tontsa (tontsa@livingfor.net) has joined #openacs
22:25:45 <lilo> [Global Notice] Hi all.  So, clearly the conversion was not as smooth as we'd hoped.  Problems occurred with the un-upgraded servers.  We're in the process of getting the core servers back and will be cutting the rest over in the next few minutes.
22:27:27 <davb> davb (dave@alb-24-58-162-46.nycap.rr.com) has joined #openacs
22:27:30 <davb> http://lart.badf00d.org/
22:27:31 <oacs-chump> B: http://lart.badf00d.org/ from davb
22:29:55 <lilo> [Global Notice] Hi all.  Our initial upgrade, announced earlier, did not go as smoothly as we'd hoped.  Un-upgraded servers had compatibility issues.  We've upgraded  the core servers and will work on adding back the others.  Apologies for the difficulties.
22:32:39 <markd2> markd2 has quit ("wheeeee")
22:33:26 <carter.openprojects.net> *** Notice -- TS for #openacs changed from 1017613167 to 1008460192
22:33:26 <til> til (til@port-212-202-128-197.reverse.qsc.de) has joined #OpenACS
22:33:26 <sterling.openprojects.net> sterling.openprojects.net has changed the topic to: OpenACS 4.5 Beta available: http://openacs.org || Waiting For DotLRN (Godot)
22:33:28 <til> til has quit (carter.openprojects.net irc.openprojects.net)
22:38:27 <davb> davb has quit ("Client Exiting")
22:41:25 <talli> talli (~talli@ip64-75-147-36.dial.maui.net) has joined #openacs
22:41:48 <talli> talli has quit (Client Quit)
22:44:06 <talli> talli (~talli@ip64-75-147-36.dial.maui.net) has joined #openacs
22:46:02 <davb> davb (dave@alb-24-58-162-46.nycap.rr.com) has joined #openacs
22:46:08 <davb> hi talli
22:46:09 <talli> yo davb
22:46:17 <talli> i don't think i've ever seen this channel so empty
22:46:26 <davb> server problem I think :)
22:46:45 <talli> ah, of course
22:47:55 <davb> not that it was super busy today.
22:48:11 <davb> I am installing dotlrn again. 
22:48:37 <rbm> rbm (rmello@fslc.usu.edu) has joined #openacs
22:50:54 <talli> come to the darkside and i'll tell you more
22:51:08 <paje> paje (~paje@slxwy.dorms.usu.edu) has joined #openacs
22:51:19 <talli> whoops. wrong window
23:00:48 <lilo> [Global Notice] Hi all.  As mentioned earlier, the hub upgrade allowed us to discover some incompatibilities with the old code.  Most of the servers are back and several more should be straggling in over the next few minutes.  The new code is up and so far it looks fine.  Apologies for the inconvenience.
23:08:04 <talli> haha
23:08:15 <talli> good one
23:26:15 <rbm> http://www.brasileiro.net/roberto/bin/linuxcola.png <-- linuxcola with babytux
23:26:15 <oacs-chump> C: http://www.brasileiro.net/roberto/bin/linuxcola.png from rbm
23:26:23 <rbm> C: LinuxCola with BabyTux
23:26:23 <oacs-chump> commented item C
23:29:39 <davb> I think I screwed up my dotlrn install...missing procs. darn.
23:33:38 <lilo> [Global Notice] Hi all.  The upgrade is complete.  In the process of upgrading we discovered an unfortunate incompatibility with the old release code, and a new maintenance release has been put out, somewhat belatedly, to make othernet upgrades a bit smoother.  Apologies for the difficulties and things appear very stable at this point.
23:45:56 <rbm> in C a fool wouldn't use bool. in python or jython use whats obvious myso
23:46:01 <rbm> argh
23:46:03 <rbm> in C a fool wouldn't use bool. in python or jython use whats obvious myson