00:51:06 <loggy> loggy has joined #openacs
00:51:06 <benford.openprojects.net> topic is: Welcome to the OpenACS Helpline | http://www.openacs.org/
00:51:06 <benford.openprojects.net> Users on #openacs: loggy wtem rbm andyn AaronSw GEM_ chump netgod KarlL shagster_ abbaJ 
00:51:07 <ChanServ> This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog
01:46:40 <davb> davb has joined #openacs
02:05:49 <davb> davb has quit
02:28:17 <KarlL> locate CmdWrite
02:28:21 <KarlL> oops, sorry
03:28:56 <talli> talli has joined #openacs
03:29:01 <talli> evening?
03:35:58 <AaronSw> evening
03:36:50 <talli> hey
03:37:48 <talli> aaron, you have any experience with debian?
03:38:00 <AaronSw> nope, not really. :-/
03:38:07 <AaronSw> no luck in #debian?
03:38:16 <talli> i'm trying
03:38:23 <talli> but it's like spitting in a hurricane
03:38:32 <AaronSw> Heh
03:40:51 <talli> talli has quit
04:29:27 <wtem> wtem has quit
04:54:51 <rbm> rbm has quit
04:55:12 <rbm> rbm has joined #openacs
04:58:21 <talli> talli has joined #openacs
05:06:06 <talli> anybody home?
05:24:28 <KarlL> yo
05:29:02 <chump> chump has quit
05:40:57 <chump> chump has joined #openacs
05:41:45 <KarlL> date
05:51:21 <rbm> rbm has quit
05:51:23 <rbm> rbm has joined #openacs
05:55:58 <rbm> rbm has quit
05:59:08 <talli> talli has quit
06:26:26 <wtem> wtem has joined #openacs
07:15:56 <andyn> andyn has quit
07:52:56 <rbm> rbm has joined #openacs
08:43:50 <netgod> netgod has quit
08:44:39 <ola> ola has joined #openacs
08:47:01 <netgod> netgod has joined #openacs
08:58:54 <djg> djg has joined #openacs
08:59:15 <djg> djg has quit
13:00:47 <davb> davb has joined #openacs
13:52:04 <davb> Should we setup an OpenACS 4 IRC installfest? Perhaps after release? 
14:05:13 <Psychephylax> Psychephylax has joined #openacs
14:05:19 <Psychephylax> Mornings
14:06:13 <davb> Hi
14:08:53 <Psychephylax> :)
14:11:09 <Psychephylax> I wish windows had virtual desktops
14:18:35 <davb> You can get it. There are shareware and commercial add-ons.
14:22:34 <Psychephylax> heh
14:22:34 <davb> Or sometimes even the video card software supports it.
14:22:53 <davb> Actually thas just one huge destop, not seperate ones though...
14:24:16 <Psychephylax> heh
14:24:22 <Psychephylax> you mean high resolution?
14:24:50 <davb> Well on mine you can specify a desktop of a larger size than the screen resolution. Then you can scroll around to see the whole thing.
14:28:03 <Psychephylax> That's not the same
14:37:54 <Psychephylax> hmmm
14:38:06 <Psychephylax> * Psychephylax is trying to figure out how to develop ADP/TCL pages
14:39:25 <davb> The tcl page does all the work, sets up variables that are used
14:39:27 <davb> in the adp page.
14:40:21 <Psychephylax> ight
14:40:23 <davb> Don't put HTML code in the tcl variables though.. Use templates
14:40:24 <Psychephylax> r+
14:40:44 <Psychephylax> Perhaps I should first go design the look of my pages first
14:40:51 <davb> ETP is a great package. I am lerning so much. It is very well designed.
14:40:59 <Psychephylax> ETP?
14:41:11 <davb> Not really. You can change it anytime you want. Figure out what should be on the page.
14:41:15 <davb> Edit This Page
14:41:46 <Psychephylax> What package is that in
14:42:04 <davb> It's new. I don't know if its in the CVS yet.
14:42:10 <davb> http://etp.museatech.net
14:42:11 <chump> A: http://etp.museatech.net from davb
14:42:25 <Psychephylax> oh
14:42:26 <davb> A:|Edit this Page package for OpenACS 4/Postgresql
14:42:26 <chump> titled item A
14:43:12 <davb> It hasn't been ported to Oracle yet.
14:43:32 <Psychephylax> d'oh
14:45:29 <Psychephylax> ok
14:45:33 <Psychephylax> here's a question for ya guys
14:45:52 <Psychephylax> My thing has to go out and do some SNMP querying
14:45:59 <davb> Would be really easy to port. It mostly uses built-in functions, tables, etc...
14:46:07 <davb> Whats an SNMP?
14:46:19 <Psychephylax> Simple Network Management Protocol
14:46:50 <Psychephylax> We have a tcl script that does the SNMP querying and stuff...but it's in an older version of TCL
14:47:00 <Psychephylax> It's standalone though
14:47:09 <davb> Aha. Should work. It is mostly backwards compatible
14:47:21 <davb> You should be able to roll it into AOLserver.
14:47:33 <Psychephylax> well, TCL yes....but it uses Scotty which is the TCL libraries deal 
14:47:37 <Psychephylax> It's changed
14:47:59 <Psychephylax> http://wwwhome.cs.utwente.nl/~schoenw/scotty/
14:47:59 <chump> B: http://wwwhome.cs.utwente.nl/~schoenw/scotty/ from Psychephylax
14:48:01 <davb> Well you could run it as a CGI.
14:48:07 <davb> or exec it
14:48:39 <ola> ola has quit
14:48:42 <Psychephylax> B:| TCL Extensions for Network Management applications
14:48:42 <chump> titled item B
14:48:52 <Psychephylax> B: If you develop network management applications
14:48:53 <chump> commented item B
14:48:59 <Psychephylax> Well
14:49:05 <Psychephylax> Right now, since this is more of a demo
14:49:24 <Psychephylax> I would like to either CGI or exec it...but...it's on a different server :/
14:49:57 <davb> AHA!
14:50:11 <Psychephylax> precisely
14:50:13 <davb> OK. Well sounds like you need an RPC protocal.
14:50:21 <davb> Say like XMLRPC or SOAP or something.
14:50:28 <Psychephylax> plus
14:50:34 <Psychephylax> the script returns a full html page
14:50:34 <ola> ola has joined #openacs
14:50:45 <davb> Oh, that sucks. Need to change the script.
14:50:51 <Psychephylax> yes 
14:51:06 <Psychephylax> But it might be easier for me to just write a new one
14:51:15 <Psychephylax> which integrates into a *tcl page
14:51:40 <davb> Can you run that on the OpenACS server? Does it have to run on the other machine?
14:51:53 <Psychephylax> I can run it on the OpenACS server
14:52:26 <davb> Oh, so that would be easier. Just modify the script to run in AOLserver, or external and just return the results
14:53:04 <davb> AHA scotty is not a tcl script. It is a new version of Tcl interpreter.
14:53:14 <Psychephylax> eh?
14:53:19 <Psychephylax> yeah
14:53:31 <Psychephylax> It's not actually a new version...it's an add-on as far as I understand it
14:54:00 <davb> Scotty if the interpreter, not tcl. I bet it could be made into an AOLserver C module though.
14:54:04 <davb> That would be cool.
14:54:40 <davb> well for you anyway. I can't imagine I'd ever use it.
14:55:01 <Psychephylax> heh
14:55:22 <Psychephylax> dont' need this too complex
14:55:26 <Psychephylax> I just need a workable demo
14:55:55 <davb> Yeah so just exec it. I am not sure how safe that is, or how many copies you need running at one time.
14:56:10 <Psychephylax> Well, right now it doesn't matter
14:56:19 <Psychephylax> later on it would most-likely be worked into a tcl/adp page
14:59:50 <Psychephylax> what's the admin thing for checking to see if the user is of type site-wide admin?
15:00:41 <davb> No clue. 
15:00:48 <Psychephylax> ok, lemme ask you a general question
15:00:57 <Psychephylax> Say, my sql registers 6 different types of users
15:01:24 <davb> Ok.
15:01:27 <Psychephylax> admin, super_user, user, maintainer...etc
15:01:48 <davb> yes...
15:02:10 <Psychephylax> Now, since each one has different permissions with regards of using the system...users can't do much but run a query and get a history but a maintainer can create users of user type but not admins...etc
15:04:11 <Psychephylax> In a tcl/adp page I can check to see what user type the person is and direct them to different pages...correct?
15:04:11 <Psychephylax> like in index.adp/tcl I can see if he's an admin and send him to the admin pages
15:04:11 <Psychephylax> or if he's a regular user just to the page that allows for query/history function?
15:04:11 <davb> Sure. 
15:04:11 <Psychephylax> ok then
15:04:14 <Psychephylax> and I can make subfolders like admin, super_user, maintainer....and stick tcl/adp in that?
15:04:41 <davb> Sure...but not is not how it's usually done...
15:04:48 <davb> look at the other packages.
15:04:48 <shagster_> shagster_ has quit
15:05:13 <davb> You might want a custom proc for your package that checks for those
15:05:16 <davb> permission types
15:05:41 <Psychephylax> well, permission checking I don't mind much for
15:05:49 <Psychephylax> it's the separation of pages that I would prefer
15:06:21 <davb> Well, it will work either way.
15:06:47 <shagster_> shagster_ has joined #openacs
15:06:55 <Psychephylax> ok
15:06:57 <Psychephylax> easier for me
15:07:04 <Psychephylax> because I can make user/admin to start off with
15:07:08 <Psychephylax> then add the other types of users
15:07:51 <davb> read the templating system docs. It explains how to create a tcl/adp pair of pages.
15:08:01 <davb> It doesn't discuss permissions though.
15:12:33 <Psychephylax> I read
15:23:51 <Psychephylax> hmmmm
15:27:55 <Psychephylax> are forms any different with adp/tcl?
15:29:55 <davb> read that templating doc. I think they are pretty much the same. 
15:30:37 <Psychephylax> ok
15:32:12 <davb> Forms
15:32:12 <davb> There is nothing special about building forms; just use the <form> tag as always. All HTML tags can be used in the ADP file (template). 
15:32:22 <davb> (from the doc)
15:36:23 <Psychephylax> cool
15:36:39 <ola> ola has quit
15:38:03 <ola> ola has joined #openacs
15:41:00 <Psychephylax> hmmm
15:41:04 <Psychephylax> need to see my pages in action 
16:01:09 <davb> davb has quit
16:01:27 <davb> davb has joined #openacs
16:20:28 <Psychephylax> * Psychephylax puts out a cookie for Vinod
16:27:04 <davb> If I want to categorize a content_item which may have multiple content_revisions, should I attach the categorized to the item or the revision?
16:30:01 <Psychephylax> i say revision
16:30:05 <Psychephylax> but what do I know
16:35:22 <Psychephylax> I'm too confused :(
16:35:39 <Psychephylax> * Psychephylax goes to draw things in his notebook in hopes of stumbling upon a solution to his dilemma
16:54:05 <Psychephylax> hard...
16:56:50 <davb> What are you trying to do? The whole tcl/adp web interface for your application?
16:57:08 <Psychephylax> yes
16:57:25 <Psychephylax> Plus, I'm not sure how to make it all visible yet...lol
16:57:29 <Psychephylax> Mmmm...coding blindly
16:57:48 <davb> Fun. You should check out the workflow package and ticket-tracker.
16:57:48 <Psychephylax> * Psychephylax feels that warm gooey phrase "You're fired" in his belly
16:58:04 <davb> Keep spitting out code.. eventually some will work. Thats what i do.
16:58:17 <Psychephylax> well
16:58:21 <Psychephylax> It makes sense to me now
16:58:33 <Psychephylax> I'd like to be able to actually see it though
16:58:38 <davb> Cool.
16:58:42 <Psychephylax> I think tcl pages is what has to be done
16:58:48 <Psychephylax> plus
16:58:50 <davb> Just add one page at a time. 
16:59:01 <davb> Add, then edit, delete, assign, whatever. 
16:59:05 <Psychephylax> I'm not quiet sure how to have some variables shared between pages
16:59:16 <Psychephylax> without creating a new db table of course
16:59:18 <davb> You need to pass then in the URL.
16:59:22 <Psychephylax> ok
16:59:48 <Psychephylax> * Psychephylax is looking at http://developer.arsdigita.com/doc/templates.html
17:00:20 <davb> ETP does it like this ><a href="etp-edit?name=@pa.name@&attribute=@page_\
17:00:20 <davb> attributes.name@">edit</a>
17:00:40 <Psychephylax> yeah, that's how Vinod did it
17:00:46 <davb> it builds the links to the next page/function like that.
17:01:03 <davb> ad_page_contract gets the variables out of the URL.
17:01:05 <Psychephylax> i gotta think of the formatting and all
17:01:22 <Psychephylax> man
17:01:23 <davb> Yeah. that you do.
17:01:34 <Psychephylax> having a job of 6-7 people is not fun at all
17:01:43 <davb> Just make it a big long list of stuff. Then change it around later.
17:01:56 <davb> Get all the information in there first.
17:01:59 <Psychephylax> * Psychephylax is playing dba, coder, designer,tester
17:02:09 <davb> yeah its fun!
17:02:13 <Psychephylax> Oh yeah! lOads!
17:02:35 <davb> * davb goes to lunch
17:02:42 <Psychephylax> so adp_page_contract
17:02:54 <Psychephylax> is a contract between the tcl and adp page as to what the tcl page supplies to adp?
17:03:22 <Psychephylax> lunch sounds good
17:11:30 <irc.openprojects.net> Disconnected from irc.openprojects.net (ERROR :Closing Link: loggy[xcdfddb76.ip.ggn.net] by benford.openprojects.net (Ping timeout for loggy[xcdfddb76.ip.ggn.net]))
17:11:41 <loggy> loggy has joined #openacs
17:11:41 <niven.openprojects.net> topic is: Welcome to the OpenACS Helpline | http://www.openacs.org/
17:11:41 <niven.openprojects.net> Users on #openacs: loggy davb ola shagster_ Psychephylax netgod rbm wtem chump AaronSw GEM_ KarlL abbaJ 
17:11:41 <ChanServ> This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog
17:15:22 <til> til has joined #openacs
17:24:44 <davb> sounds right
17:39:35 <markd2> markd2 has joined #openacs
17:58:50 <look> look has joined #openacs
18:00:29 <look> hey everyone. I asked this over in #postgresql, but its really dead. I'm looking for a good ISP to host a website with postgresql for a not very tech savvy small business. 
18:00:43 <look> Any suggestions?
18:00:46 <davb> Tough question.
18:00:57 <markd2> markd2 has quit
18:01:29 <look> Yeah...google search is worthless because there are so many. Is there a list anywhere?
18:02:19 <davb> hang on...
18:02:33 <look> Hub.org is one that I've found, but they are a .org, and that really confuses me...
18:04:41 <davb> Just a name I think.
18:05:00 <davb> Are they looking for a low cost provider?
18:05:11 <look> Well, it depends.
18:05:37 <davb> Aha. Most of the places I am aware of offer ACS/OpenACS hosting. 
18:05:46 <davb> but they just need postgresql?
18:05:47 <look> I want a mailing list and postgres and a scripting language. The site is not very high traffic, but they are looking to become more popular (of course)
18:05:57 <davb> Right.
18:06:11 <davb> Most of the OpenACS places are around $150/month
18:06:21 <look> I haven't thought much about openacs. It might be a good fit, though. I'm going to have to write a lot of crap myself...
18:06:49 <john> john has joined #openacs
18:06:54 <look> That price is more than they are paying now, but doable
18:07:12 <davb> Right. 
18:07:24 <davb> here are some
18:07:34 <davb> http://www.furfly.net
18:07:34 <chump> C: http://www.furfly.net from davb
18:07:51 <davb> C: http://www.museatech.net
18:07:51 <chump> commented item C
18:08:01 <davb> C: http://www.zill.net
18:08:02 <chump> commented item C
18:08:10 <AaronSw> Hey look.
18:08:24 <davb> Ok.
18:08:35 <davb> C: Some OpenACS hosting providers
18:08:35 <chump> commented item C
18:08:39 <look> thanks davb
18:08:45 <look> Hi Aaron.
18:08:49 <davb> hub.org is probably the least costly.
18:08:54 <look> hub.org does look nice
18:10:11 <davb> C: http://www.thinking-minds.com
18:10:11 <chump> commented item C
18:11:26 <look> Has anyone heard anything about hub.org? I'm also a little concerned with response time and such because they're in canada.
18:12:19 <davb> I am not aware of their reputation
18:13:07 <look> Furfly is with Exodus, huh. didn't they go out of business?
18:13:41 <AaronSw> LOL!
18:18:00 <look> hub.org seems to have an impressive little setup
18:19:04 <davb> OK, so say I have a list of categories attached to a content_item. Should I pass around the keyword_ids for the categories, or the actual category names?
18:21:27 <look> well, thanks for your help, davb. I'll have to think about using openacs. The question for me is: is it worth more short term work for a better long term payoff (when I'm not likely to be involved anymore)? 
18:22:18 <AaronSw> What project is this, look?
18:24:20 <look> I'm doing some consulting for a small business (Midwest Musical Imports; http://www.mmimports.com). They're trying to streamline their catalog updating process. It's stored in Peachtree accounting software right now. I need to write a script to update it on their website.
18:24:54 <look> Their current host only has MySQL (and terrible service). Updating the inventory list without transactions would be a nightmare.
18:25:41 <AaronSw> Hmm...
18:26:25 <look> A new accounting sytem would be ideal, but would cost them a fortune.
18:27:24 <look> Honestly, why doesn't peachtree just use postgresql as the database backend for their accounting software? It has terrible locking issues and can't support more than 5 users at a time. 
18:28:44 <davb> Do they take orders on the web site? 
18:30:59 <look> not really. They take orders...but they don't have a shopping cart and (sigh) the orders are simply emailed to them for processing.
18:31:05 <Psychephylax> w
18:31:08 <Psychephylax> d'oh
18:31:19 <look> uh huh. bad news.
18:31:54 <look> And actually, online ordering is something with which I have NO experience
18:35:17 <davb> Should I use foreach with a call to db_exec_plsql inside the loop or pass a list to db_exec_plsql and loop through inside the db?
18:36:11 <davb> if that is even possible...
18:38:32 <Psychephylax> What are you trying to do?
18:39:19 <davb> I have a list of keywords to assign to a content_item. I need to run content_item__keyword_assign for each keyword.
18:39:28 <davb> which is a pl/pgsql function.
18:39:36 <Psychephylax> do it as an external loop
18:40:19 <Psychephylax> it would be simpler but probably less efficient if you did a loop in pl/pgsql
18:40:31 <Psychephylax> there is a lost comma in there
18:42:06 <davb> Perhaps I will just make it work, then fool with it if its too slow.
18:42:15 <Psychephylax> :)
18:44:36 <Psychephylax> ok
18:44:44 <Psychephylax> * Psychephylax codes some adp
18:53:00 <Psychephylax> * Psychephylax realizes he has no idea what exactly he's doing
18:56:55 <Psychephylax> hmmm
18:57:17 <Psychephylax> i wonder how I can determine if the user wants to run a query or retrieve a history
18:57:32 <Psychephylax> I mean in the target...Since i'm using a form
18:59:31 <davb> have two different tcl pages that do whatever you need.
18:59:44 <Psychephylax> hmm
18:59:54 <Psychephylax> How do I determine which one to call though?
19:00:02 <Psychephylax> Like I wanna have a text entry field
19:00:06 <Psychephylax> and 2 radio buttons
19:00:13 <Psychephylax> one is for query and another one for history
19:00:26 <davb> Have two submit buttons or links. 
19:00:42 <Psychephylax> ewww
19:00:54 <Psychephylax> I was hoping the target could sort it out
19:00:59 <davb> Sure.
19:01:14 <davb> the radio buttons control the value of one variable right? 
19:01:29 <davb> Check the value when you get to the target page and run whatever code/query is necessary.
19:01:32 <Psychephylax> I think so
19:02:06 <davb> Or have one big switchboard tcl page that figure it out and redirects to the correct page. That sounds like a mess though...
19:02:09 <Psychephylax> * Psychephylax goes to read his webmonkey
19:02:50 <Psychephylax> the way I was thinking is like this:
19:03:16 <Psychephylax> --> entry point to sub-site --> check user leve and show him his allowable links
19:03:24 <Psychephylax> If user --> user.tcl/adp
19:03:44 <Psychephylax> in user: form with entry for mac, query or history of mac
19:04:11 <Psychephylax> if user --> super_user --> add user, history, query
19:04:25 <Psychephylax> hmmm
19:04:47 <Psychephylax> I wanna make this simple.so they don't have to through 30 screens to run a query or fetch a history
19:04:54 <davb> right.
19:06:05 <Psychephylax> but I also don't want to replicate adp/tcl code
19:06:26 <Psychephylax> since everyone can always run a query I want them to be able to use one single query.tcl/adp
19:06:39 <Psychephylax> hmmmm
19:07:00 <Psychephylax> i could make it one huge nasty page with hidden elements unless user is of type x
19:07:15 <Psychephylax> but that's just poor programming style
19:07:45 <Psychephylax> aha
19:07:55 <Psychephylax> I can just make a single target but have diff views
19:09:53 <look> look has left #openacs
19:09:57 <Psychephylax> * Psychephylax goes back to the drawing board
19:10:56 <netgod> netgod has left #openacs
19:23:36 <GEM_> GEM_ has quit
19:25:17 <wtem> wtem has quit
19:31:13 <Psychephylax> umm
19:31:21 <Psychephylax> Anyone fetch the latest cvs from oacs4?
19:31:36 <Psychephylax> is it now missing the navigational table from the right hand side?
19:33:41 <ola> hi. on the index page, you mean?
19:34:03 <davb> It is there on my copy from last week.
19:34:11 <Psychephylax> yeah
19:35:17 <davb> * davb checks
19:35:38 <ola> I noticed that the table disappeared when I was logging in on NN.
19:36:15 <ola> I changed align right to align left and it started working...
19:36:45 <Psychephylax> hmmm
19:36:49 <Psychephylax> i didn't modify anything
19:38:37 <davb> mine is still there...
19:38:48 <davb> i did cvs update though...
19:39:11 <ola> another NN4 bug?
19:39:31 <markd2> markd2 has joined #openacs
19:39:39 <davb> what browser Psychephylax?
19:39:40 <davb> Hi markd2
19:39:47 <markd2> greetings
19:40:04 <Psychephylax> * Psychephylax bows down to Oracle
19:40:14 <Psychephylax> any prophecies for me today?
19:41:08 <davb> ls
19:41:10 <davb> oops
19:41:10 <Psychephylax> ok
19:41:17 <Psychephylax> hehehe
19:41:23 <Psychephylax> Ok, I installed my package
19:41:26 <Psychephylax> how do I access it?
19:41:43 <davb> site map
19:41:49 <davb> mount it
19:41:58 <Psychephylax> * Psychephylax asks someone to translate
19:42:10 <davb> Go to yourserver/admin/
19:42:14 <davb> Click on site map
19:42:34 <davb> new sub folder
19:42:46 <davb> give it a name. thats the URL
19:42:51 <davb> new application
19:42:57 <davb> pick your package as the application/.
19:42:59 <davb> go to the URL
19:43:37 <Psychephylax> mmmm
19:44:11 <Psychephylax> ok then
19:44:22 <Psychephylax> I got that
19:44:35 <Psychephylax> how come it's not loading my index.adp
19:44:42 <davb> Error message??
19:44:49 <Psychephylax> nope
19:44:54 <Psychephylax> it just shows a directory listing
19:44:57 <davb> check the server log...
19:45:03 <davb> weird.
19:45:12 <davb> it does that when it can't find the file.
19:45:38 <davb> your index.adp is under packages/yourpackage/www/ ?
19:45:53 <Psychephylax> Directory listing of /web/oacs/www/
19:45:58 <Psychephylax> probably  not
19:45:59 <Psychephylax> hold on
19:46:17 <davb> Package web pages go in the package directory www/
19:47:42 <Psychephylax> yay
19:47:50 <Psychephylax> http://167.206.9.143:8080/snmp/
19:47:50 <chump> D: http://167.206.9.143:8080/snmp/ from Psychephylax
19:47:55 <Psychephylax> grrrr
19:48:45 <davb> put a space in front or anything if you don't want it chumped.
19:48:59 <Psychephylax> * Psychephylax chokes chump 
19:49:59 <ola> psyche: do you have an accompanying index.tcl?
19:49:59 <Psychephylax> muahahaha
19:50:35 <Psychephylax> it was missing a master.adp
19:50:38 <Psychephylax> I got that fixed
19:53:13 <Psychephylax> I forgot my html too 
19:53:14 <Psychephylax> lol
19:56:37 <Psychephylax> w00t
19:56:54 <Psychephylax> It  knows the difference between admin and users :D
19:58:35 <Psychephylax> now to fix the query page :D
19:59:22 <Psychephylax>  4:06PM  up 55 days,  6:03, 2 users, load averages: 0.00, 0.00, 0.00
19:59:24 <Psychephylax> :)
19:59:43 <Psychephylax> fitty five days
19:59:53 <markd2> * markd2 has a server machine with a 422 day uptime
20:00:11 <Psychephylax> dang
20:00:25 <Psychephylax> is it on a UPS?
20:04:23 <markd2> it's out at Exodus
20:04:33 <markd2> they've got backup power and lots of good stuff like that
20:04:53 <markd2> badgertronics has been up for 7
20:04:59 <markd2> der, 71
20:05:07 <markd2> unfortunately 71 days ago I had hardware problems :-(
20:05:22 <Psychephylax> heh
20:05:36 <Psychephylax> * Psychephylax celebrates
20:05:43 <Psychephylax> He has 2 adp pages and some sql stuff
20:07:28 <markd2> woo hoo!
20:08:53 <Psychephylax> Indeed
20:10:04 <Psychephylax> not too shabby
20:11:17 <Psychephylax> ok
20:11:40 <Psychephylax> now I gotta figure out how to do the actual snmp stuph so I have something to write to the database
20:25:23 <Psychephylax> Psychephylax has quit
20:26:56 <Psychephylax> Psychephylax has joined #openacs
20:26:58 <Psychephylax> doh
20:27:07 <Psychephylax> not smart swapping intranets midconnection :/
20:27:58 <markd2> oops
20:32:01 <davb> * davb goes home
20:32:03 <davb> davb has quit
20:33:25 <Psychephylax> lucky bastige
20:33:28 <Psychephylax> it's only 4:30
20:33:36 <Psychephylax> Man
20:33:40 <markd2> * markd2 is already home
20:33:41 <Psychephylax> Mondays and Fridays should be half-days
20:33:56 <Psychephylax> but we get paid for full
20:38:42 <markd2> in that case you'll need to join a union
20:38:46 <Psychephylax> aha!
20:38:52 <Psychephylax> ok
20:39:01 <Psychephylax> who said they had the table on the right?
20:39:15 <Psychephylax> I think it's browser dependent
20:39:24 <Psychephylax> I see it in IE but not in Netscape
20:54:39 <markd2> make sure your tables are all closed
20:54:46 <markd2> IE will render unclosed tables, but netscrape won't
20:56:33 <Psychephylax> heh
20:56:39 <Psychephylax> I didn't write the index page
20:56:46 <Psychephylax> but maybe that's a bug Don should look into :)
20:57:44 <Psychephylax> hmmm
20:57:49 <Psychephylax> this is the hard part
20:57:59 <Psychephylax> I have to now actually use the SNMP script and have it return values
21:01:09 <gilbertw> gilbertw has joined #openacs
21:01:41 <Psychephylax> hey Gilbert
21:02:13 <Psychephylax> anyone wanna help me brainstorm this problem? :(
21:02:37 <gilbertw> hi
21:03:01 <Psychephylax> hewwo
21:04:33 <markd2> which problem?
21:05:42 <Psychephylax> Well
21:06:02 <Psychephylax> I'm to the step where I need to get values from the modem/ubr
21:06:07 <Psychephylax> We have a script
21:06:18 <Psychephylax> it's in tcl...an older version and it's stand-alone
21:06:23 <Psychephylax> and on a different server
21:06:33 <Psychephylax> as far as I understand it, my alternatives:
21:07:06 <Psychephylax> 1. Re-write the TCL script for newer interpreter and build it into a *adp/tcl page
21:07:29 <Psychephylax> 2. Http request the page, parse it using regexps for values I need and get them that way
21:07:56 <Psychephylax> 3. Fix up the tcl script to run on the OACS host and exec it
21:08:35 <markd2> how often will you be execing it?
21:08:35 <Psychephylax> Often
21:08:35 <Psychephylax> Maybe not right now (development) but later (production)
21:08:35 <markd2> how often is often?  dozens of times a second?  or a couple times a minute?
21:08:51 <john> john has quit
21:08:59 <Psychephylax> Well....with 400,000 customers making tech support calls I would guess a dozen times a minute or so
21:09:13 <markd2> do you need to get fresh values each time, or can you cache values?
21:09:21 <Psychephylax> fresh values
21:09:26 <Psychephylax> each query is for a different modem
21:09:47 <markd2> if it really is that intensive, #1 is your best option
21:09:53 <Psychephylax> i gotta get about 30 diff values, store them in the db and dump them to the screen
21:10:10 <Psychephylax> That's what I figured
21:10:24 <Psychephylax> this is for a demo right now though
21:10:38 <markd2> is the stuff that script bangs capable of that traffic volume?
21:11:07 <Psychephylax> I would sure hope so :) we power ~400,000 cable modems with Sun and Cisco :P
21:11:22 <markd2> cool
21:11:22 <Psychephylax> mmmm...NY Metro Area...*drool*
21:11:36 <Psychephylax> Yeah, we handle OptimumOnline for NY,NJ,CT
21:11:40 <Psychephylax> hell
21:11:45 <look> look has joined #openacs
21:11:46 <Psychephylax> we ARE OptimumOnline :)
21:12:19 <Psychephylax> So you're saying that re-writing the script into a tcl/adp page would be the best...k
21:12:29 <markd2> lemme know when you run a line out to Leechburg, PA
21:12:35 <markd2> s/Leechburg/middle-of-nowhere/
21:13:34 <Psychephylax> lol
21:13:50 <Psychephylax> We don't even do half of the boroughs of NYC
21:13:52 <Psychephylax> Like Bronx
21:13:59 <Psychephylax> But hey, you never know
21:14:02 <markd2> you located up in that area?
21:15:46 <Psychephylax> No
21:15:49 <Psychephylax> I'm on Long Island
21:16:01 <Psychephylax> by the Hamptons I guess
21:16:14 <markd2> for some reason i thought you were in Utah with some of the other weirdos
21:16:36 <Psychephylax> how hard would it be to exec the script in a tcl/adp page?
21:16:44 <Psychephylax> heh...Utah is too far for me
21:16:47 <markd2> easy
21:16:56 <markd2> set reusult [exec /path/to/script arg1 arg2 arg3]
21:17:35 <Psychephylax> hmmm
21:17:42 <Psychephylax> ok
21:17:46 <Psychephylax> elaborate on this a bit
21:17:52 <Psychephylax> the script runs and returns what?
21:18:06 <Psychephylax> I have something like 20 parameters that it gets and I need most of them for now
21:18:24 <markd2> whatever the script writes to standard out
21:18:39 <ola> ola has quit
21:18:43 <Psychephylax> hmmmm
21:18:45 <markd2> you can do like [exec /bin/ls -lat /tmp]
21:18:52 <Psychephylax> hang on
21:19:04 <markd2> so whatever you get returned on the command line running the commad is what you'd get from exec
21:19:05 <Psychephylax> I bet you scotty is not installed on the oracle box
21:19:12 <markd2> scotty?
21:19:23 <Psychephylax> the SNMP interpreter for Tcl
21:19:42 <markd2> ah  
21:20:16 <ola> ola has joined #openacs
21:20:20 <Psychephylax> yeah
21:20:47 <Psychephylax> I think I will use exec with a cleaned up script for the demo and rewrite it into adp/tcl for the production copy
21:20:54 <markd2> qool
21:21:59 <Psychephylax> technically, I can even do it blindly and just feed it stuff from a regression test file
21:22:12 <Psychephylax> but seeing my stuff in action is more rewarding :-D
21:24:50 <markd2> yep
21:24:54 <markd2> when's your deadline for this stuff?
21:25:00 <Psychephylax> I don't know :)
21:25:05 <Psychephylax> Demo soon though
21:25:26 <Psychephylax> I suspect my next problem will be this:
21:26:15 <Psychephylax> Running a history lookup will have to generate a page of old runs but if each run is like a full html page it would probably be best to just make a page with query id's and dates as links 
21:29:39 <ola> ola has quit
21:32:06 <ola> ola has joined #openacs
21:32:50 <ola> ola has quit
21:37:28 <look> look has left #openacs
21:48:46 <markd2> markd2 has quit
21:49:19 <Psychephylax> going home time
21:50:02 <Psychephylax> Psychephylax has quit
21:57:30 <gilbertw> gilbertw has quit
22:25:41 <davb> davb has joined #OpenACS
22:44:12 <til> til has quit
23:12:10 <davb> davb has quit
23:48:00 <davb> davb has joined #OpenACS
23:53:40 <davb> davb has quit
23:55:05 <Psychephylax> Psychephylax has joined #openacs