IRC log of openacs on 2002-06-28

Timestamps are in UTC.

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