00:01:42 <rbm> denshi: No, I just had to reboot my machine and forgot to bring it up
00:01:57 <rbm> I'll bring it back when I get home
01:20:48 <rbm> davb: you here?
01:21:39 <davb> yes i am
01:23:53 <rbm> I found out what I needed :)
01:23:58 <davb> ok
01:27:22 <davb> good night, and good luck :)
01:27:23 <davb> davb has quit ("Client Exiting")
01:27:51 <rbm> WAIT!
01:27:55 <rbm> arg!
01:28:06 <rbm> What's the equivalent of timestamp in oracle 8.0.5?
03:25:01 <denshi> rbm: did you find the answer?
04:00:30 <talli> people still alive?
04:12:52 <rbm> YEAH!!@$(!@$&)!@$&)!*$)@!$*)!)$!!!!!
04:13:12 <rbm> I got this freaking populating-pdfs-with-data-from-the-database thing working!
04:13:13 <talli> uh oh
04:13:21 <talli> wow
04:13:22 <rbm> *finally*
04:13:23 <talli> that's great
04:13:25 <rbm> dammit!
04:13:31 <talli> what was so hard about it?
04:13:32 <rbm> That took _way_ too long
04:13:41 <talli> is it a reporting problem?
04:13:43 <rbm> Acrobat is to sissy
04:13:47 <rbm> s/to/too/
04:14:11 <talli> what kind of data populate the pdf?
04:14:17 <rbm> Took me over one hour to figure out that my last hurdle was *one* remaining "\
04:14:19 <rbm> Took me over one hour to figure out that my last hurdle was *one* remaining "\n"
04:14:27 <rbm> talli: any data
04:14:40 <talli> are you building reports?
04:14:51 <rbm> YEs
04:15:04 <talli> cool
04:15:44 <rbm> But they are going to submit the PDF form data back to my AOLserver, so it is inserted in the database
04:16:08 <rbm> (I give them part of the data pre-populated, they fill the rest, and submit)
04:16:44 <rbm> I'm tired... begin at work for 15 hours
04:16:50 <rbm> bb tomorrow
04:16:52 <rbm> 'nite all
07:05:20 <jim> jim (~jim@12.155.172.152) has joined #openacs
07:27:10 <jim> tst
11:44:44 <davb> davb (~chatzilla@rrcs-nys-24-97-22-204.biz.rr.com) has joined #openacs
11:44:57 <davb> hello
12:02:29 <Inquizitophylax> Inquizitophylax has quit (Read error: 110 (Connection timed out))
12:13:44 <talli> hey everyone
12:21:15 <abbaJ> abbaJ has quit (Read error: 104 (Connection reset by peer))
12:24:22 <davb> hi
12:27:09 <Spork> Spork (~nblyumbe@bosco.eng.cv.net) has joined #openacs
12:27:11 <Spork> Hey
12:45:46 <denshi> * denshi yodels at the rising sun
12:47:05 <Spork> heh
12:49:13 <davb> * davb works on favicon.ico for openacs.org
12:52:24 <denshi> that's not an anagram!
13:39:04 <Spork> hmmm
13:39:12 <Spork> * Spork pokes jim
14:03:13 <davb> i am almost done, and the icon is starting to look pretty good.
14:25:19 <davb> try 24.58.162.82:8001 for a sample of the icon
14:26:18 <davb> hmmm doesn't work in IE
14:26:21 <davb> weird.
14:28:37 <davb> it works as a favorites icon, but doesn't show up in the location bar in IE 6.
14:30:25 <davb> hmm. anyone have ie 5 or 5.5 to test it?
14:33:12 <davb> aha, its fixed.
14:38:33 <markd2> markd2 (~Snak@h166-102-041-160.ip.alltel.net) has joined #openacs
14:48:11 <denshi> gitdown!
14:48:34 <denshi> davb, you have some crazy referrer logs
14:55:23 <davb> i told ya
14:55:30 <davb> its the chump log.
14:58:04 <denshi> it's a riot, is what it is
14:58:13 <davb> heh
14:58:19 <denshi> can you post the complete query list, instead of the top 20?
14:58:36 <davb> Maybe, i'll have to see what webalizer can do.
14:59:31 <markd2> set allSearchStr to yes
14:59:54 <markd2> I love seeing the whole query list
15:01:25 <davb> ok. i will see if I can rerun the reports.
15:02:49 <davb> it didn't recognize that one.
15:04:07 <markd2> I'm using 2.01 I think
15:04:28 <markd2> yeah, 2.01-01
15:04:31 <markd2> er, -09
15:05:37 <davb> 2.01.10 is installing now
15:05:50 <davb> according to man webalizer, that is valid. is it case sensitive?
15:06:00 <Spork> hmmm
15:06:05 <Spork> where's paje?
15:06:20 <markd2> davb: I dunno
15:06:29 <markd2> I've got the pre-canned config file that I've tweaked
15:06:33 <markd2> It has in there (exactly)
15:06:34 <davb> ok :)
15:06:37 <markd2> AllSearchStr    yes
15:06:49 <Spork> nobody around but mark and dave and I ;(
15:06:53 <Spork> * Spork cries
15:06:56 <markd2>   http://borkware.com/reports/borkware.conf if ya want a peek
15:07:31 <davb> i had allSearchStr, apparently it IS case sensitive.
15:08:50 <Spork> :)
15:09:25 <markd2> whoa.  Someone found borkware with a search term of "you've got a big problem buddy! you need more args!!!
15:09:25 <markd2> "
15:09:33 <markd2> no idea where they would have gotten that in the first place
15:10:01 <davb> nm :)
15:10:10 <davb> allsearch str is not the same as allsearchstr
15:10:49 <markd2> heh
15:11:49 <davb> ok, go for it. they are in there now.
15:13:14 <markd2> can I see?
15:13:27 <lilo> [GlobalNotice] http://www.affero.com
15:13:48 <lilo> [GlobalNotice] Just take a look if you get a chance.
15:13:54 <davb> sure. www.thedesignexperience.org/webalizer/reports/
15:15:20 <davb> i added allreferrers too.
15:16:26 <davb> so did anyone look at the icon?
15:16:29 <markd2> woo hoo! I'm a referrer!
15:16:36 <davb> yep. thanks :)
15:16:56 <markd2> wow.  god kills a kitten is a popular search
15:21:19 <talli> heyguys
15:21:40 <davb> hiya talli
15:21:49 <talli> hey davb
15:22:07 <vinod> vinod (~vinod@66-108-0-75.nyc.rr.com) has joined #openacs
15:22:08 <talli> guys, at one we're having an importnat meeting in #momentum
15:22:13 <talli> it would be great if you could make it
15:22:17 <talli> not you vinod
15:22:29 <vinod> * vinod never gets to go to the fun meetings :(
15:22:42 <davb> fun you can go, just not important
15:23:15 <markd2> heh
15:23:16 <vinod> haha
15:42:16 <abbaJ> abbaJ (~jabba@adsl-65-65-97-179.dsl.austtx.swbell.net) has joined #openacs
15:42:19 <talli> rbm: you around?
15:54:11 <markd2> markd2 has quit ("wheeeee")
15:56:41 <rbm> talli: what's up?
16:04:58 <rbm> I think I'll start running paje off the openacs.org box. It'd go down less often
16:08:03 <davb> rbm: can you install the favicon.ico over at openacs.org?
16:08:25 <rbm> davb: I could. What do I have to do?
16:08:54 <davb> hang on
16:12:53 <rbm> * rbm hangs on
16:13:59 <davb> ok i have returned :)
16:14:08 <davb> i will provide a file called favicon.ico
16:14:12 <paje> paje (~paje@208.184.248.88) has joined #openacs
16:14:19 <davb> it goes in the root openacs/www or whatever.
16:14:22 <rbm> hello paje
16:14:30 <rbm> paje: status
16:14:30 <paje> Since Fri Jun 28 12:56:24 2002, there have been 0 modifications and 0 questions.  I have been awake for 18 seconds this session, and currently reference 18 factoids. Addressing is in optional mode.
16:14:45 <davb> then we need a piece of HTML added to the head section of the HTML files. so that might be a pain for openacs 3.2.x
16:14:49 <rbm> paje is now running off of the oacs.org box
16:15:15 <davb> cool.
16:15:43 <rbm> paje: problem?
16:15:44 <paje> wish i knew, rbm
16:15:46 <rbm> AHH!
16:15:52 <rbm> HE lost all the factoids?
16:16:02 <rbm> paje: who are you?
16:16:02 <paje> i guess i am now running off of the oacs.org box
16:16:05 <rbm> crap
16:16:15 <paje> paje has quit (Client Quit)
16:16:47 <talli> hey guys, momentum meeting is on
16:17:15 <rbm> hey talli
16:17:32 <talli> hey rbm
16:17:41 <talli> have you seen rjr/duster/ray around?
16:19:20 <rbm> rjr is on #soy on fslc.usu.edu, but at this time to the day, he's probably asleep
16:19:52 <rbm> just posted this to #soy:
16:19:53 <rbm> If anyone is interested in that calendar server project, there's a meeting going on at #momentum at opn
16:20:10 <talli> ah, cool
16:20:12 <talli> thanks
16:21:36 <talli> where's markd2?
16:22:21 <rbm> somewhere in the past
16:22:25 <rbm> :) sorry
16:22:34 <rbm> So this is the big meeting for momentum?
16:22:46 <paje> paje (~paje@208.184.248.88) has joined #openacs
16:22:55 <rbm> paje: who are you?
16:22:55 <paje> rbm: bugger all, i dunno
16:22:57 <rbm> crap
16:23:00 <paje> paje has quit (Client Quit)
16:23:33 <paje> paje (~paje@208.184.248.88) has joined #openacs
16:23:35 <rbm> paje: who are you?
16:23:35 <paje> wish i knew, rbm
16:23:39 <paje> paje has quit (Client Quit)
16:24:03 <Spork> paje, where is rbm 
16:24:50 <Spork> paje, seen rbm 
16:27:16 <rbm> I don't know why paje forgets everything if I move him to a different server
16:27:26 <talli> rbm: there are some missing people
16:28:05 <talli> but the guy who wrote libical is in there, as are some people from OEOne who developed the mozilla calendar and released it and there was supposed to be a rep from OpenOFfice groupware as well as a rep from Postgresql.org
16:28:24 <talli> so not a big meeting as much as an important one
16:29:04 <rbm> cool. 
16:43:09 <vinod_> vinod_ (~vinod@66-108-0-75.nyc.rr.com) has joined #openacs
16:43:20 <rbm> limphnode!
16:51:54 <Spork> sweet
16:52:03 <Spork> I got my 8$ disbursement check 
16:52:06 <Spork> I'm rich now!
16:54:25 <davb> woohoo!
16:54:38 <rbm> disbursement
16:54:39 <rbm> ?
16:54:55 <rbm> * rbm is still tired from yesterday's 15-hour work session
16:54:59 <Spork> Hmmm
16:55:14 <Spork> where's paje, I need to know what area code 914 is
16:57:18 <Inquizitophylax> Inquizitophylax (proxy@ool-18baa8de.dyn.optonline.net) has joined #openacs
16:57:26 <Inquizitophylax> hmmm
16:58:36 <davb> 914 is westchester county
16:58:47 <Spork> yeah I looked that up on some website :)
16:59:05 <Inquizitophylax> Did you really?
16:59:09 <Spork> Yes, yes I did
16:59:14 <Inquizitophylax> That's very interesting
16:59:14 <davb> heh
16:59:25 <Spork> Maybe you need some mental help?
16:59:29 <Inquizitophylax> Certainly
16:59:43 <Inquizitophylax> * Inquizitophylax bites davb
16:59:43 <Spork> * Spork bites davb
17:00:13 <vinod> vinod has quit (Read error: 110 (Connection timed out))
17:00:25 <Spork> July 25 I get a 50$ check
17:00:26 <Spork> woo
17:00:32 <Spork> * Spork goes to do some more work
17:00:38 <Inquizitophylax> * Inquizitophylax follows quietly
17:34:56 <denshi> I believe the best query in davb's referrer logs is "naked vinod"
17:35:11 <davb> oh my
17:35:48 <denshi> that one is *so* not my fault
17:37:05 <davb> sure, likely story
17:37:28 <davb> vinod_ : what's up with that? some second career you are not telling us about?
17:38:08 <davb> uh, not that I _really_ want to hear about it?
17:39:02 <vinod_> vinod_ is now known as vinod
17:39:37 <vinod> then how come you ordered a months-subscription to Naked Vinod (tm)?
17:39:48 <davb> aigh!
17:41:19 <davb> also see: http://blogspace.com/openacs/chatlogs/2002-02-11.txt for more about that subject...
17:42:31 <vinod> haha
17:42:45 <vinod> so, once again, i can blame it on talli 
17:42:54 <davb> I should have known.
17:42:58 <denshi> man.  we're turning into a bunch of porn starts
17:43:04 <denshi> s/starts/stars/
17:43:31 <davb> you are #2 and #10 on the first page of search results
17:43:52 <davb> I am glad the logs are not on my server also :)
17:45:14 <denshi> man, freshmeat.net can kick out a mess of referrals on the quick
17:51:00 <vinod> http://freshmeat.net/projects/mod_scheme/?topic_id=49%2C92
17:51:00 <oacs-chump> B: http://freshmeat.net/projects/mod_scheme/?topic_id=49%2C92 from vinod
17:51:14 <vinod> B:| denshi and scheme in an unholy alliance
17:51:14 <oacs-chump> titled item B
17:53:14 <davb> also ns_scheme for the truly adventurous
17:54:27 <vinod> and i just found toddbrandlabs.com for the first time
17:55:36 <davb> OK. here is a question. I added a new column to cr_revisions called searchable_p. it defaults to NULL. I designed the triggers to index anything that searchable P is se to NULL or TRUE.
17:55:50 <davb> would it be better to default to TRUE?
17:56:06 <davb> or is it good to have an "unspecified" option?
17:57:06 <davb> now that I think about it. leaving it NULL is more compatible with existing systems. If you add that column and the new triggers, it works exactly the same as before.
17:57:09 <denshi> uh oh.. navy.mil in the logs
17:58:10 <davb> I guess I should include an upgrade script.
18:00:02 <Spork> hmmm
18:00:06 <Spork> I want my camera back
18:00:11 <Spork> I do...I really really do
18:01:33 <vinod> davb: just food for thought. if i were to write a query to find all searchable content, intuitively, i would think 'where searchable_p = true' would find it
18:02:20 <Spork> naked vinod?
18:02:25 <Spork> You guys are odd :)
18:02:32 <vinod> not now Spork 
18:02:38 <vinod> fully clothed at the moment
18:02:51 <Spork> * Spork wanders off looking at the ground...Nothing to see..nothing to see..move along everyone
18:04:22 <davb> vinod: that is true. I guess if I set the coulmn default to TRUE and an application never touched it, it would have the same result.
18:05:26 <davb> ummm, duh
18:05:33 <vinod> newbie question: when you alter a table and add a column with a default, all the old rows get that default - right?
18:05:53 <davb> it is default TRUE in my sample content-create.sql. i just forgot to set the default when i did alter table on my test install.
18:06:00 <davb> vinod: i think so :)
18:06:06 <davb> lets find out...
18:06:19 <vinod> :-) my sql is rusty
18:07:32 <davb> hmmm.
18:08:31 <davb> ok. first: ERROR:  Adding columns with defaults is not implemented.
18:08:39 <vinod> doh!
18:08:40 <davb> Add the column, then use ALTER TABLE SET DEFAULT.
18:10:37 <davb> no, set default does not seem to add the default value to existing columns
18:11:09 <davb> so its a 3 step process.
18:11:12 <vinod> so then, we'd have to do an update on the entire table
18:11:13 <davb> alter table add column
18:11:18 <davb> alter table set default
18:11:20 <davb> update
18:11:22 <davb> yes :)
18:13:05 <denshi> okay, I need to go down to campus and use all my dark powers to destroy the registrar
18:13:17 <davb> excellent!
18:13:31 <vinod> * vinod lends his puny dark powers to denshi, just in case
18:14:12 <denshi> * denshi packs vinod's dark powers in with the rest.  The dark powers-case gibbers madly when exposed to the sun.
18:14:43 <vinod> lol
18:28:05 <davb> ok that works just as well.
18:28:16 <davb> and makes the triggers simpler.
18:29:00 <davb> i think I will post to the bboard to see if anyone has a better idea.
18:41:30 <ctpat3r> ctpat3r (~ctpat3r@129.252.42.9) has joined #openacs
18:42:22 <ctpat3r> having trouble installing oracle 8.1.7 on linux, GUI installer never loads, can someone help? thanks
18:43:24 <davb> read this: http://www.suse.com/en/support/oracle/db/817_71.html
18:43:55 <davb> hmmm. that might not help.
18:45:12 <ctpat3r> i'm on rh7.3
18:45:33 <ctpat3r> followed openacs.org instructions
18:46:45 <davb> ok.
18:47:32 <ctpat3r> after doing ./runInstaller I get Initializing Java Virtual Mahine from ../stage/Compon.....jre. Please wait...
18:48:02 <ctpat3r> then nothing happens ever, although the jre process is taking up over 50% of cpu
18:48:14 <davb> ok something strange is happening.
18:48:31 <davb> not too many redhat users in the channel.
18:49:25 <ctpat3r> I'm considering going back to the old trusty Debian, but that would be a major pain to reinstall
18:50:41 <davb> do you have another JRE installed?
18:50:56 <davb> note: i am just winging it here, i use debian :)
18:51:31 <ctpat3r> you mean jdk?
18:51:54 <ctpat3r> i didn't initially, but then installed jdk118_v3
18:52:16 <ctpat3r> i can remove it easily (just un-symlink it) but with or without, I get the same result
18:52:57 <ctpat3r> i don't have another jre, i don't think
18:54:16 <davb> i don't think it reallly matters :)
18:54:21 <davb> just guessing.
18:54:29 <talli> talli has quit (Remote closed the connection)
18:55:54 <ctpat3r> oracle9i wouldn't work, i suppose
18:56:08 <ctpat3r> with openacs 4.5, that is
18:56:09 <davb> not with OpenACS 4. we have to rename some functions.
18:56:31 <davb> everything called foo.delete in pl/sql will break because delete is a reserved keyword.
18:56:44 <ctpat3r> ok
18:57:38 <ctpat3r> i guess i'll try postgress now
18:57:48 <davb> do you need oracle?
18:58:22 <ctpat3r> i'd like to learn oracle, more than postgress, and I'll be working on oracle here at work (on win32)
18:58:43 <ctpat3r> so i could get two birds that way, but i don't mind postgress
18:58:52 <davb> i see.
18:58:54 <ctpat3r> the more rdbms's i know the better (2 so far) :)
18:59:04 <davb> install on lnux is generally not super fun.
18:59:09 <davb> of oracle that is.
18:59:21 <ctpat3r> it's a recent port, i understand
18:59:45 <ctpat3r> of oracle to linux, i mean
18:59:49 <davb> since 8.1.5 i think.
19:00:12 <davb> i don't have a problem installing on debian.
19:00:21 <davb> but i suspect that is just luck :)
19:00:57 <davb> try this: http://www.orafaq.com/msgboard/linux/messages/35.htm
19:01:10 <davb> someone also mentioned a similar problem in the openacs bboard.
19:01:53 <davb> also this mentions swap space: http://www.computing.net/linux/wwwboard/forum/4518.html
19:01:57 <davb> how much swap do you have?
19:04:38 <arjun> arjun (~arjun@p66-186.acedsl.com) has joined #openacs
19:05:24 <davb> also is it a P4? there seems to be a bug with p4's but it does not specifically mention linux.
19:05:40 <ctpat3r> yey!!
19:05:45 <ctpat3r> it worked!!!
19:05:59 <ctpat3r> LD_ASSUME_KERNEL=2.2.5 did it
19:06:13 <davb> oh yeah. that is for redhat installs also :)
19:06:16 <davb> hi arjun
19:06:39 <ctpat3r> that's so much, davb
19:06:44 <ctpat3r> thanks, i mean
19:06:46 <arjun> hey davb
19:06:48 <davb> no probken,
19:06:56 <davb> no problem that is.
19:07:17 <arjun> ahh the old LD_ASSUME_KERNEL hack!
19:07:43 <ctpat3r> arjun, do you know how exactly it works? i'm just curious
19:08:18 <arjun> not really, just the oracle installer is fubar if you don't set it.
19:08:43 <ctpat3r> that's not in the openacs docs, i don't think. might be a useful thing to add, maybe
19:08:46 <davb> if that isn't in the install doc. add a comment.
19:09:27 <arjun> hmm, i thought that it was .. it should be in there in bold type
19:10:29 <ctpat3r> ooops, sorry, i didn't realize there were comments attached. it is there. damn
19:11:01 <davb> the comments, if they are correct, should be added back into the document.
19:11:15 <davb> maybe at the top there should be a link to see the comments.
19:12:29 <ctpat3r> the comment says: 1) install the compat-glibc, ...etc
19:12:35 <ctpat3r> i didn't have to do that to start the installer
19:12:48 <ctpat3r> doesn't mean i won't have problems later :)
19:13:03 <davb> you need to do that after running root.sh
19:13:27 <davb> you definitely have to do it before creating a database.
19:14:37 <ctpat3r> ok
19:15:13 <davb> time for me to go. I'll be back later
19:15:21 <davb> davb has quit ("ChatZilla 0.8.7 [Mozilla rv:1.0.0/20020530]")
19:37:43 <ctpat3r> ctpat3r has quit ("Client Exiting")
19:59:31 <ctpat3r> ctpat3r (~ctpat3r@129.252.42.9) has joined #openacs
20:35:03 <denshi> vinod: our dark powers defeated the UT registrar
21:28:12 <ctpat3r> ctpat3r has quit ("Client Exiting")
21:44:40 <vinod> vinod has quit (Read error: 110 (Connection timed out))
21:49:45 <abbaJ> abbaJ has quit (Remote closed the connection)
22:07:52 <arjun> arjun has left #openacs
22:08:54 <talli> talli (~chatzilla@pool-162-83-238-204.ny5030.east.verizon.net) has joined #openacs
22:27:36 <talli> talli has quit (Remote closed the connection)
22:34:32 <talli> talli (~chatzilla@pool-162-83-238-204.ny5030.east.verizon.net) has joined #openacs
22:46:43 <talli> talli has quit (Remote closed the connection)
23:15:25 <Inquizitophylax> Anyone awake?
23:19:30 <denshi> I'm battling it out with the registrar, so yes, I'm awake
23:58:03 <talli> talli (~chatzilla@pool-162-83-238-204.ny5030.east.verizon.net) has joined #openacs