01:38:59 <davb> davb has left #OpenACS
01:39:12 <davb> davb has joined #openacs
01:41:38 <davb> davb has quit
01:41:38 <davb> davb has joined #openacs
01:56:03 <docwolf> docwolf has joined #openacs
01:56:13 <docwolf> yo
01:56:18 <davb> hi
01:56:51 <rbm> yo yo yo
01:56:58 <docwolf> how goes it?
01:57:00 <rbm> 'sup doc?
01:57:24 <rbm> Trying to get some work for the second job done, then have to study for a test, and try to get some OpenACS stuff done.
01:57:47 <rbm> Guess I can't play racquetball tonight :(
01:57:54 <rbm> How's the ex-ad mailing list?
01:59:41 <docwolf> ha
02:00:25 <docwolf> ugh.  i hosed my laptop badly tonight
02:00:31 <docwolf> by installing linux
02:00:51 <docwolf> destroyed the boot sector.
02:00:59 <docwolf> linux works, windows no longer does
02:01:20 <davb> ack. 
02:01:39 <docwolf> i am doomed.
02:01:59 <docwolf> i guess i'll just mount the windows partition, copy the data off
02:02:02 <rbm> Not really.
02:02:03 <docwolf> then blast it
02:02:13 <rbm> fdisk /mbr
02:02:18 <rbm> Which windows?
02:02:20 <docwolf> win2k
02:02:47 <docwolf> it's really annoying
02:02:49 <rbm> make a linux boot disk, then boot into dos with a floppy and do fdisk /mbrl
02:02:56 <docwolf> because when i installed it
02:02:59 <rbm> I meant "mbr"
02:03:00 <docwolf> i told it to make & use a boot disk
02:03:04 <docwolf> not to screw with my HD
02:03:11 <docwolf> .. and it did anyway.  
02:03:15 <docwolf> RedHat 7.1
02:03:16 <rbm> Is that Mandrake?
02:03:18 <rbm> Oh
02:03:19 <davb> ick.
02:03:39 <rbm> I haven't installed RH since its pre-7.0 days, so I don't know how the installer is doing.
02:03:43 <docwolf> i may have to drop the folks at redhat a line
02:03:50 <docwolf> b/c this is a critical failure
02:03:59 <docwolf> and a major turn-off to newbies who might be trying linux for the first time
02:04:07 <rbm> * rbm gets out his duck tape for docwolf's enter key
02:04:15 <docwolf> they should post UBER-WARNINGS about the boot sector and the consequences of changing it.
02:04:20 <docwolf> sorry, roberto. nervous tick :-)
02:04:30 <rbm> * rbm hands docwolf some Prozac :)
02:05:01 <davb> That is why I unplugged my windows drive and installed linux on another drive.
02:05:10 <davb> Of course thats not really an option in the laptop
02:07:22 <docwolf> yeah.  shame on RedHat. No wonder mandrake is pulling ahead.
02:07:41 <rbm> on the dumb-user side.
02:07:44 <docwolf> i guess i'll try the fdisk trick. what's the worst that could happen?
02:08:25 <rbm> You could be unable to access both partitions.
02:08:37 <rbm> But if you make a linux boot floppy as I explained, then no danger at all.
02:08:43 <rbm> mkbootdisk on RH
02:08:48 <docwolf> right. i'm booting off a floppy.
02:09:11 <davb> http://www.uoguelph.ca/~jomstead/
02:09:11 <chump> E: http://www.uoguelph.ca/~jomstead/ from davb
02:09:11 <rbm> You don't have a Win2k rescue disk?
02:09:21 <davb> E:| Dual Boot RedHat and Win2K
02:09:21 <chump> titled item E
02:09:34 <docwolf> nope.  i never made one.
02:10:18 <docwolf> since it looks like i'm going to be stuck in linuxland for a while... what's the best IRC client?
02:10:31 <rbm> Depends on what you're looking for.
02:10:48 <rbm> graphical? console? lots of bells-whistles?
02:11:10 <docwolf> nothing too fancy. I'm using KDE.  Sound effects would be nice.
02:11:23 <rbm> There's a KDE one, KVirc I think.
02:12:02 <docwolf> whoa... It came pre-installed.  looks mega.
02:12:21 <docwolf> docwolf has quit
02:12:53 <rbm> ?!?!?
02:14:52 <docwolf> docwolf has joined #openacs
02:15:19 <docwolf> this KVIrc is a serious-looking client
02:18:22 <rbm> Yeah. I think it's written in Perl
02:24:56 <docwolf> OK, i have everything i need, i think.  StarOffice 6 is working, mozilla works.  IRC & AIM work.   Now, just need to find a good email client.   Any recommendations?
02:25:03 <docwolf> anything that looks/acts like eudora?
02:27:15 <davb> I use mutt. its a text email client.
02:27:36 <docwolf> the old-skool solution, eh? :-)
02:27:39 <rbm> Hmmm. Mozilla Mail, Netscape Mail, (mutt rocks, but it doesn't like Eudora, thank goodness), Evolution, KMail
02:28:04 <docwolf> is evolution ready? it looked like a promising eudora/outlook knockoff
02:28:14 <docwolf> when i tried it a long, long time ago..... but it wasn't close to being finished.
02:28:33 <rbm> docwolf: I think this Red Hat problem will help you get rid of the claws of evil.
02:28:53 <docwolf> hehe.. rbm: so true.  It just takes a little push...
02:29:07 <docwolf> but it seems to me that there are now some legit replacements to all the major classes of windows apps.
02:29:26 <rbm>  /msg davb I'm glad docwolf didn't notice I trashed his Win2k partition
02:29:36 <rbm> Ooops :-)
02:29:39 <docwolf> :-)
02:30:11 <rbm> I installed Evolution th other (since it's so hard to do in Debian). It looks pretty cool, and it was pretty fast.
02:30:19 <rbm> I couldn't get it sync with my Visor though.
02:30:40 <rbm> So I've been using jpilot. It's nice too.
02:30:55 <wtem> wtem has joined #openacs
02:36:24 <docwolf> cool
02:43:30 <davb> evolution is on beta 5. It's scheduled for 1.0 release Oct 29 but they are about 2 weeks behind right now.
02:45:23 <davb> * davb dparts
02:45:27 <davb> davb has quit
03:14:00 <Spork> :)
04:24:34 <rbm> quiet....
04:29:42 <docwolf> docwolf has quit
05:26:58 <rbm> * rbm hits the sack. 'nite all
05:59:37 <wtem> wtem has quit
09:21:53 <ola> ola has joined #openacs
12:44:41 <markd2> markd2 has joined #openacs
13:06:51 <davb> davb has joined #openacs
13:07:38 <markd2> markd2 has quit
13:18:33 <markd2> markd2 has joined #openacs
13:27:22 <markd2> markd2 has quit
13:31:47 <markd2> markd2 has joined #openacs
13:32:10 <markd2> * markd2 is done rebooting for now
13:34:49 <davb> heh
13:54:04 <rbm> morning all
13:55:10 <ola> hi all!
13:56:45 <davb> Welcome!
13:59:49 <ola> I am about to commit some files to openacs.org
14:00:07 <ola> shall I follow Pascals doc in new-file storage?
14:00:59 <davb> Sure. That's what I did.
14:01:10 <davb> DId you cvs add any new files?
14:01:11 <ola> ok. thanks.
14:01:37 <ola> not yet, but I will.
14:01:53 <ola> why?
14:02:52 <davb> just reminding you....
14:03:38 <ola> ok. thanks. 
14:26:42 <wtem> wtem has joined #openacs
14:27:48 <ola> weird. my newly checked-out openacs-core installs but dies after the intallation killed the aolserver processes!?
14:28:21 <davb> hmmm
14:28:26 <davb> it won't restart?
14:28:54 <ola> the server restarts but I get this 
14:29:17 <ola> "the document contained no data"
14:29:54 <davb> That is weird. What's the log say?
14:30:07 <ola> .. after I filled in the admin-stuff form
14:30:37 <ola> it says this:
14:30:41 <ola> [16/Oct/2001:18:28:20][22723.4101][-conn0-] Error: tclop: invalid return code from filter proc 'Query did not return any rows.': must be filter_ok, filter_return, or filter_break
14:31:02 <markd2> looks like a filter has an uncaught error
14:31:54 <ola> yes. I wonder if the tree is corrupt.
14:32:27 <ola> sounds most unlikely...
14:37:27 <wtem> wtem has quit
14:38:01 <wtem> wtem has joined #openacs
14:41:34 <wtem> wtem has quit
14:47:49 <davb> ola: I installed from a fresh checkout, no problems. I can access site map and apm.
14:51:25 <kwatson> kwatson has joined #openacs
14:51:27 <ola> ok thanks. did you do it just now? openacs.org appears to be down.
14:52:05 <davb> yeah about 10 mins ago.
14:52:13 <davb> Hello kwatson
14:52:47 <ola> above.net may have problems
14:52:48 <kwatson> hi
14:53:00 <kwatson> what is this channel?
14:55:19 <davb> It is the home for developers of OpenACS http://openacs.org
14:55:36 <davb> ola: its ok for me.
14:55:39 <ola> toys for adults.
14:55:45 <davb> heh
14:56:07 <davb> OpenACS is a free web toolkit for building complex interactive web sites/applications
14:56:29 <davb> I think I put too many "web"s in there.
14:57:00 <ola> davb: really? I ran traceroute ant it came to a halt after above.net somewhere.
14:57:02 <markd2> davb is cookoo for webs
14:57:12 <ola> s/ant/and
14:57:14 <davb> Oh yeah and we have markd2
14:57:22 <markd2> openacs.org is loading for me
14:57:30 <markd2> * markd2 works for cookies
15:00:35 <ola> argh! nothing goes the way I plan.
15:00:53 <davb> welcome to #openacs
15:00:59 <ola> hehe
15:00:59 <davb> :)
15:10:19 <kwatson> kwatson has left #openacs
15:25:44 <ola> davb: can I ask you a question?
15:26:09 <davb> sure.
15:26:22 <vinod> vinod has joined #openacs
15:26:36 <ola> hi vinod!
15:26:49 <vinod> hey ola!
15:26:52 <ola> davb: if I have a piece of code like this:
15:26:56 <davb> Hi vinod
15:27:06 <vinod> hey dave!
15:27:08 <ola>     db_transaction {
15:27:08 <ola> set mp3_id [db_exec_plsql add_mp3 ""]
15:27:09 <ola> db_dml update_mp3_info ""
15:27:26 <ola> can I have the update statement in just the -postgresql.xql file and leave out that sql in -oracle.xql?
15:27:45 <ola> so it doesn't perform the update under Oracle...
15:29:21 <davb> I am not sure how db_transaction works... 
15:29:40 <vinod> ola: i don't think that will work
15:29:58 <ola> bummer
15:30:02 <vinod> if there's no query in -oracle.xql, the QD will default to whatever is in the tcl file
15:30:27 <vinod> so, it will freak out with the blank query (i think)
15:30:41 <ola> aha.
15:30:45 <vinod> maybe not, though - i haven't tested that
15:32:43 <davb> Can't you add the update_mp3_info SQL into the add_mp3 plsql?
15:33:02 <markd2> PERFORMER is in the haüs
15:33:10 <ola> no. too many parameters.
15:33:46 <ola> yeah! Mr PERFORM! - thats Vinod.
15:34:07 <davb> Like this: 
15:34:10 <davb> begin
15:34:19 <davb> PERFORM mp3__new (stuff);
15:34:24 <vinod> haha
15:34:32 <davb> PERFORM moremp3__new (other stuff);
15:34:33 <davb> end;
15:34:44 <davb> or something like that.
15:34:49 <vinod> davb: sorry for interrupting your PERFORMance
15:34:55 <ola> heh
15:37:11 <ola> davb: I'm not sure. I'm dased and confused..
15:38:37 <ola> thing is I'd like to avoid backporting to oracle. that's basically it.
15:39:08 <davb> Right.
15:39:35 <davb> Ok. So you need the same Tcl code and different SQL.
15:39:40 <ola> overloading would solve that but Don said it was "butt ugly"
15:39:44 <davb> What does the Tcl look like now?
15:40:30 <ola> well
15:41:34 <markd2> not quite as butt ugly
15:41:34 <ola> Tcl looks like the transaction above.
15:41:41 <ola> hehe
15:41:50 <davb> Ok.
15:42:15 <davb> So it references a query in the XQL file called add mp3.
15:42:52 <ola> ok. mp3.new takes 26 params
15:43:14 <davb> Right. Does the oracle query just call mp3.new?
15:43:25 <ola> I modifyed mp3__new so it only takes a few params
15:43:37 <ola> davb: yes
15:43:47 <davb> Ok. So hmmm...
15:44:30 <ola> my thinking was that I could do an update after db_exec_plsql "blah"
15:44:36 <davb> Right. Did you make another function. 
15:44:39 <davb> ?
15:44:48 <vinod> vinod has quit
15:44:48 <ola> only for PG though.
15:44:55 <davb> Or are you just doing an insert with the additional parameters?
15:45:18 <davb> So in the Oracle XQL file will be :
15:45:21 <ola> I didn't make a new function
15:45:21 <davb> begin
15:45:29 <davb> mp3.new(params);
15:45:31 <davb> end;
15:45:35 <ola> just update after the function call
15:45:40 <davb> in postgresql would be:
15:45:43 <davb> begin
15:45:49 <davb> mp3__new(params);
15:45:57 <davb> insert into mp3_mp3s etc....;
15:45:59 <davb> end;
15:46:24 <docwolf> docwolf has joined #openacs
15:46:32 <docwolf> thank you, roberto
15:46:36 <docwolf> fdisk /mbr
15:46:56 <docwolf> (of course, finding a boot disk was another story...)
15:47:24 <ola> davb: ok. that might work.
15:48:45 <ola> davb: I think it does.. thanks!
15:49:05 <davb> great!
15:49:26 <davb> Now I am battling static-pages. Apparently it never worked with folders that existed underneath www
15:50:03 <ola> physical folders, you mean?
15:50:34 <rbm> moo
15:51:03 <davb> Yeah. when it searches them, it dies.
15:51:09 <ola> hi rbm!
15:51:10 <davb> Hi rbm
15:51:30 <davb> Whats the postgresql/SQL92 convention for current date?
15:51:47 <ola> current_timestamp
15:51:56 <rbm> what's up?
15:52:06 <rbm> for date, current_date I think
15:52:13 <rbm> timestamp is time and date
15:52:23 <ola> aha.
15:52:49 <davb> For the creation_date field in OpenACS should I use just date for timestamp?
15:53:35 <davb> s/for/or
15:53:37 <rbm> No, for timestamp you should use the "timestamp" type :)
15:53:41 <rbm> ah :)
15:53:52 <rbm> I think timestamp is better in this case.
15:53:58 <rbm> s/better/more complete/
15:54:07 <rbm> * rbm eats some very good, home-made, jewish bread
15:55:39 <ola> rbm: I didn't know you knew how to bake
15:56:46 <rbm> ola: I know how to bake some things, but not this bread. My neighbor, who is Jewish (very nice fellow), brought it to us.
16:03:02 <davb> does v_permission_row.privilege need to be quoted here:
16:03:04 <davb>                                 perform acs_permission__grant_permission(
16:03:04 <davb>                                         v_folder_id,                    -- obje\ct_id
16:03:04 <davb>                                         v_permission_row.grantee_id,    -- gran\tee_id
16:03:05 <davb>                                         v_permission_row.privilege      -- priv\
16:03:05 <davb> ilege
16:03:29 <markd2> heh.  domo arigato Mister Roberto.
16:03:55 <rbm> domo arigato gozai mazda
16:04:08 <rbm> markd2: Why the japanese? :)
16:04:23 <markd2> I've got the old Styx song on my 80's playlist
16:04:37 <rbm> davb: I don't understand the question
16:06:41 <rbm> I Hate slashsh**
16:06:59 <davb> Right now that call is passing general_comments_create as the value of v_permission_row.privilege.
16:07:08 <rbm> So MyCrapSQL 4.0.0 _ALPHA_ is released. SO WHAT?
16:07:19 <davb> If a variable is a string does it need quotes around it?
16:07:23 <rbm> Now we're going to announce alpha releases??!!?!?
16:07:38 <davb> postgresql is says can't parse "general_comments_create"
16:07:40 <rbm> davb: no
16:07:49 <davb> Ok. So its something else.
16:07:51 <rbm> Only if you're quoting a litteral string
16:08:08 <davb> ok. thanks
16:14:50 <davb> ola: I got a whole bunch of these in my log
16:14:50 <davb>  Error: tclop: invalid return code \
16:14:50 <davb> from filter proc 'Query did not return any rows.': must be filter_ok, filter_re\
16:14:50 <davb> turn, or filter_break
16:14:50 <davb> [16/Oct/2001:12:08:57][19293.14342][-conn7-] Notice: Querying '
16:14:51 <davb>         select node_id
16:14:53 <davb>         from host_node_map
16:14:55 <davb>         where host = 'www';'
16:16:31 <ola> davb: now what did I tell you! the tree is corrupt!!
16:16:47 <davb> Yeah, but server is serving pages, etc AOK. Weird.
16:17:12 <davb> This is the problem I am having with acs_permssion__grant_permission:
16:17:13 <davb>  Error: Ns_PgExec: result status: 7\
16:17:13 <davb>  message: ERROR:  pg_atoi: error in "general_comments_create": can't parse "gen\
16:17:13 <davb> eral_comments_create"
16:19:47 <davb> I think those things are related to this thread on openacs.org: http://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0002wj&topic_id=14&topic=
16:19:47 <davb> +OpenACS%204%2e0%20Testing
16:19:52 <davb> oops.
16:20:04 <vinod> vinod has joined #openacs
16:20:09 <davb>  http://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0002wj&topic_id=14&topic=OpenACS%204%2e0%20Testing
16:38:11 <vinod> vinod has quit
16:51:21 <davb> http://tclsoap.sourceforge.net/TclSOAP.html
16:51:21 <chump> A: http://tclsoap.sourceforge.net/TclSOAP.html from davb
16:51:25 <til> til has joined #openacs
16:51:30 <davb> A:| SOAP and XMLRPC in Tcl
16:51:30 <chump> titled item A
16:51:48 <davb> A: This uses the standard HTTP package for Tcl and TclDOM 2.0
16:51:48 <chump> commented item A
16:52:35 <ola> davb: the insert Gilbert suggests works.
16:52:53 <davb> Excellent.
16:58:36 <davb> A: MIT License
16:58:36 <chump> commented item A
17:08:35 <talli> talli has joined #openacs
17:08:41 <talli> hey guys
17:09:22 <markd2> hey Talli
17:09:39 <ola> hi talli
17:10:23 <talli> how is everybody today?
17:12:13 <rbm> 'sup talli?
17:14:00 <ola> ola has quit
17:15:27 <ola> ola has joined #openacs
17:27:18 <hazmat> goodmorning
17:28:27 <hazmat> anyone know anything about nssoap.sf.net
17:28:49 <hazmat> hazmat is now known as rastafool
17:29:40 <rbm> rastafool: haven't heard of it. What is it?
17:30:51 <rastafool> its soap for aolserver, it got mentioned on the aolserver list  a month ago, i thought it would be useful for the openacs, but i don't see any releases:(
17:31:04 <rbm> oh
17:31:24 <rbm> davb just posted a link to tclsoap.sourceforge.net
17:33:03 <rastafool> hmm... that could work, i'm looking for something that create soap interfaces for some acs-service contracts. time to read the source
17:33:18 <rastafool> s/that/that can
17:33:59 <rastafool> rbm: thanks
17:34:06 <rastafool> rastafool has quit
17:35:56 <ola> ola has quit
17:39:28 <davb> hi talli
17:43:30 <rbm> anyone knows if it's possible to have AOL as ISP being a Linux user?
17:44:04 <markd2> only if they've moved to PPP like they've been planning
17:44:06 <talli> i think there was something on slashdot about that
17:44:22 <rbm> Oh, so they don't even use PPP?
17:45:25 <markd2> for the longest time it's been "P3", a proprietary protocol
17:46:09 <rbm> Didn't someone reverse engineer that protocol?
17:46:20 <markd2> P3?  probably not
17:47:41 <rbm> I think it was on /.
17:49:13 <markd2> I searched for "P3" on slashdot and got nothing
17:50:48 <rbm> look in the AOL topic
17:50:50 <davb> I sent a mail to the nssoap developers. Hopefully I can find out whats going on. It would be great to have an AOLserver module.
17:52:05 <talli> where is nssoap development going on?
17:52:19 <rbm> http://slashdot.org/article.pl?sid=01/10/09/1826205&mode=thread
17:52:19 <chump> B: http://slashdot.org/article.pl?sid=01/10/09/1826205&mode=thread from rbm
17:52:27 <rbm> B:| AOL Protocol Revealed
17:52:28 <chump> titled item B
17:52:30 <davb> http://nssoap.sf.net
17:52:30 <chump> C: http://nssoap.sf.net from davb
17:52:46 <davb> C:| NSSOAP AOLserver modules project
17:52:46 <chump> titled item C
17:53:02 <talli> where is there any info on AOLserver4, btw?
17:53:07 <talli> i can't find it anywhere
17:56:47 <davb> probably the best place to find out is the mailing list.
18:07:45 <talli> damn mailing lists
18:16:50 <talli> talli has quit
18:29:42 <davb> Cool. lightning fast response on nssoap.
18:31:02 <davb> Its just a port of TclSOAP. Not bad at all.
18:39:50 <lethedrinker> lethedrinker has joined #openacs