00:28:43 loggy has joined #openacs 00:28:43 topic is: OpenACS: Free web toolkit | http://openacs.org 00:28:43 Users on #openacs: loggy markd2 rbm AaronSw davb abbaJ GEM shagster chump 00:28:43 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 00:37:49 davb has quit 01:47:39 talli has joined #openacs 01:47:50 heeeellloooo everybody 01:47:59 good day for SF Bay Area sports... 01:48:45 niners won in OT, raiders won in the 4th, oakland a's wins on a walkoff homer in the 12 and barry bonds hits 3 homers 01:49:20 anyway, just bragging. you all can go back to coding now... 01:51:18 talli has quit 02:07:22 sports. bah. 02:48:08 vinod has joined #openacs 02:49:34 "Helloooooo Nurse!" 02:50:16 LOL 02:50:26 nurse? is that me? 02:50:36 only when you wear that Outfit 02:50:40 what's up anord? 02:50:51 markd2: quit looking up my skirt 02:50:56 err 02:51:15 sorry 02:51:19 vinod: HAve you ever watched Animaniacs? 02:51:39 rbm: nope, sorry. i'm one of the few cable-less americans 02:51:40 CAFEBABE has joined #openacs 02:51:41 He's a giant chicken! really! 02:52:01 That's where that line comes from 02:52:36 ahhh... i'll have to get cable someday :-) 02:53:22 hey markd2 - loved your conversation with the monkey. made me laugh out loud (the nurses here think i'm crazy, always laughing at my computer) 02:54:46 heh 02:54:50 that monkey rules 02:55:05 and sooooo cute too! 02:55:08 it's funny, i followed the link from your site and the only recipe i read was the queso dip 02:55:32 the rice crispy treat thing looks pretty dangerous 02:55:39 if yu're a small terrycloth monkey sitting on the side of the pan 02:56:16 haha - i know, i was getting scared as he was stirring that cheese dip 02:57:07 can you imagine yourself 02:57:12 standing on a swimming pool diving board 02:57:22 stirring up an olymic-sized pool of bubblign queso? 02:57:31 I know I have not such courage 02:57:38 mmmm... cheese.... 02:57:43 * vinod is a cheeshead, remember? 02:57:58 AaronSw is now known as AaronSw` 02:58:34 yum cheese 02:58:42 AaronSw` is now known as AaronSw 03:04:48 markd2 has quit 03:06:59 CAFEBABE has quit 03:15:47 CAFEBABE has joined #openacs 03:25:40 CAFEBABE has quit 03:26:17 CAFEBABE has joined #openacs 03:43:51 vinod has quit 04:20:47 abbaJ has quit 04:25:41 abbaJ has joined #openacs 06:04:21 KarlL has joined #openacs 06:14:37 kaoruAngel-coding has joined #openacs 06:17:00 kaoruAngel-coding has left #openacs 06:25:25 PascalS has joined #openacs 06:25:30 hiya 07:01:16 CAFEBABE has quit 08:43:22 rzolf has joined #openacs 09:04:25 rzolf has quit 11:24:03 PascalS has quit 12:00:45 til has joined #openacs 12:21:42 rbm has quit 12:21:45 rbm has joined #openacs 12:33:37 markd2 has joined #openacs 12:44:34 zzzirk has joined #openacs 13:01:25 davb has joined #openacs 13:07:19 Anyone have a link to Problem Set 0 for ACS? It was written by someone who attended a bootcamp and thought of some stuff it would be good to learn before trying to install ACS. I tried google, but the link I found is bad. 13:13:06 chump has quit 13:14:07 chump has joined #openacs 13:15:06 charles has joined #openacs 13:54:03 Psychephylax has joined #openacs 13:54:57 i hate mondays 13:55:04 I want to kill people already and it's not even 10 14:00:08 Woah. Thanks for joining us... 14:01:28 no problem 14:01:31 you guys are pretty safe 14:01:56 Anyone know how to reset the db in oracle for OACS? 14:02:06 I just cvsed up the source and want to re-do the db 14:02:23 hang on... 14:02:37 k 14:03:13 I can email you a little instructions I got from vinod. 14:03:22 sure 14:03:29 nickb@cv.net 14:04:33 rm -rf $ORACLE_HOME 14:04:34 :-) 14:04:39 til has quit 14:05:14 Deleting directories, please wait... 14:05:30 Mark, you're serious? 14:05:42 nope 14:05:46 ok 14:05:49 Don't joke like that :P 14:05:57 my boss wouldn't be pleased having to reinstall Oracle 14:06:17 it's easy after you've done it a couple dozen times 14:06:17 KarlL has quit 14:06:38 it actually shold be rm -rf $ORACLE_BASE :-) 14:06:47 find / -type f -exec gzip {} \; -print 14:06:59 KarlL has joined #openacs 14:07:00 there's a sysadmin over on #wplug that actually tried that 14:07:15 k 14:07:18 two questions 14:07:31 I think it got mailed 14:07:36 Is this a text / sql that both accomplish thesame thing? 14:08:01 No you have to actually read it. Go into SQL/PLUS type in the commands with the correct pathnames 14:08:08 k 14:08:23 It could easily be a script, but noone got around to it yet. 14:09:08 heh 14:09:17 What kind of permissions do I need 14:09:53 I'd imagine dba 14:10:05 heh 14:10:27 is it select user_names from ? 14:10:34 to find out all the names in the db 14:10:43 select user_name from dba_users; 14:10:49 (it might be username. I forget if it needs the underbar) 14:10:56 describe dba_users if you have no joy 14:11:48 ORA-04043: object SYS.DBA_USERS does not exist 14:11:58 well, i guess this solves MY dillemma 14:12:19 * Psychephylax writes an email to his boss 14:15:42 this might be a dumb question 14:15:51 but is there a command to clear the screen in oracle? 14:16:00 like clear for unix or cls for windows? 14:16:21 oracle doesn't ahve a screen... 14:16:24 just whatever shell you're using 14:16:33 well whatever the heck it's printing to 14:16:56 quit it, then do clear 14:17:05 heh 14:17:08 zzzirk has quit 14:17:13 ok so I was doing it right I guess 14:17:16 I usually run my shell inside of emacs which doesn't have a concept - you can just delete the text you're tired of seeing 14:17:20 host;clear;exit works fine too 14:17:29 til has joined #openacs 14:17:54 is there some sort of a flag in OACS that will trigger a new db initialization? 14:19:51 zzzirk has joined #openacs 14:22:01 Dave, regarding this how-to you e-mailed me 14:22:15 does it end after "exit to shell" or is the second part necessary as well 14:23:44 nm 14:23:53 I figured it out...that's the stuff that sets up the tablespace back up 14:25:05 Right. 14:25:40 The bootstrap installer can tell if that database is installed. When you got to the "home page" if its not, it will offer to install it. 14:25:52 s/database/datamodel 14:26:44 "The ArsDigita Community System ported to PostgreSQL. OpenACS (Open ArsDigita Community System) is an advanced toolkit for building scalable, community- oriented web applications. If you're thinking of building an enterprise-level web application, OpenACS is a solid, proven foundation that will give you a 3-6 month headstart. 14:26:58 ? 14:27:04 Thats a quote from the ACS/pg adovogato project page. 14:27:18 I think its a great one paragraph description of OpenACS 14:27:35 heh 14:27:50 I wonder if thats from Openacs.org anywhere... 14:28:17 dave, the tablespace already has to exist for OpenACS to be able to install the datamodel, right? 14:28:21 aha, its right on the home page. Shows you how often I read taht. 14:28:23 Yes. 14:28:30 you create the tablespace first. 14:28:34 ok 14:28:40 now, what happens if i just drop a few tables 14:29:13 I can drop tables in the tablespace, so is there something that boot-strapper checks for before it goes recreating the datamodel? 14:29:19 it will probably work. I am sure it checks for the existence of a certain OpenACS feature in there. 14:29:36 here comes the DBA 14:51:47 ok 14:52:02 After a brief conference I have determined I lack many priveleges 14:52:06 time to go bug my boss about it 14:52:09 * Psychephylax is away: bugging boss 14:53:29 * Psychephylax is back (gone 00:01:20) 14:53:31 not there 14:53:58 I think I'm gonna write that script you guys said didn't exist 14:55:14 mmkay 14:57:27 cool! 14:57:53 Checkout the oracle database creation scripts that dbassist spits out for reference. 14:57:54 Yeah 14:58:08 I'm looking at my complete reference book 14:58:27 And I'm using variables so you don't have modify the tablespace in 4 different places 14:59:55 Great! 15:00:04 yeah 15:00:05 I think so 15:01:33 ok 15:01:44 if I store a variable in Oracle like a path to a file 15:02:04 if I host out, can I still use the variable or does it have to be an actual path? 15:03:54 no idea. 15:05:16 k 15:05:31 and is it: 15:05:33 define 15:05:34 variables 15:05:36 end; 15:05:36 ? 15:11:49 what sort of script are you writing? 15:13:46 to drop the user,tablespace 15:13:50 then to recreate it 15:14:09 and wht is this: create user openacs4 identified by dbopenacs4 default 15:14:25 that creates a user 15:14:32 yeah i got that much 15:14:35 who's dbopenacs4 15:14:42 the user name 15:14:43 that's the password 15:14:51 oh 15:14:52 * markd2 suggests www.oradoc.com 15:15:44 switching computers... 15:15:44 markd2 has quit 15:42:02 * Psychephylax whispers...I think he's trying to avoid me 15:53:25 We have the older version up and that's what we've been messing with. I've got 4 checked out from CVS and kind of halfway going. I was scared off a little by the pre-alpha designation, but it looks like it has a lot more in the way of generalized permissions management and stuff that we probably need. 15:53:57 Sure. Have you read ACS Permissions Tediously Explained? 15:54:41 I looked through it last night but have not studied it carefully. 15:55:13 woohooo 15:55:19 It explains very well the power and functionality of the permission system. I haven't used it myself. 15:55:21 My script works...I think 15:55:37 Psychephylax: cool. Can you comment on the permissions system? 15:55:47 Dave do you want it now, or do you want me to test it more? 15:55:57 Ummm, I'll try but it's very foggy to me 15:55:59 KarlL: I really recommend you read all the documentation that comes with OpenACS 4. 15:56:19 Psychephylax: I'll take it. I can test it. I'll let you know if it breaks anything. 15:56:52 The permissions system is built into openacs to provide centralized permissions control to any existing and add-on modules (if the are properly introduced to openacs via sql) 15:57:12 some of the things can be done without programming stuff into it..and others must be programmed into it 15:57:23 ok dave, I'll send it in a second 15:59:04 charles has quit 15:59:42 OK, I'll take it on (reading all the OpenACS 4 docs). It's a little daunting. 15:59:58 yeah it is.. 16:01:11 Start out reading the parts you think apply to your project. Then branch out. Unfortunately it's all we have right now. 16:01:36 It's not quite as bad as it looks. Everything is tied together so reading one doc usually makes another clear. 16:01:56 heh...Dave, that is quiet true 16:02:04 however, there is no single entry point into the mess :P 16:02:20 There's no clear "page 1" of the documentation 16:03:05 Right. I started on the content repository and CMS, which is not really the best place to start. 16:03:26 The key is understanding the acs_objects system that everything else is built upon. 16:03:51 I don't quiet understand it yet anyways 16:04:41 dave, you got the email? 16:05:00 me either, I just know thats the key. 16:05:04 lol 16:05:59 Looks good. I'll test it later. 16:06:13 Thanks, guys. 16:06:23 yeah 16:06:29 no problem Karl 16:06:54 davb: I designed it to be run from a crontab job or from the console 16:07:05 hmmm 16:07:06 Psychephylax: interesting. 16:07:11 yeah 16:07:32 KarlL: no problem. Hopefully we can get docs that make everything clear. It is easier to use a package than to build one. 16:07:59 I think I'm going to expand on it a bit and make it cvs the new source tree before or after it does the db stuff 16:08:25 then you can just plug it into cron and have it run every sunday or so 16:08:54 Yeah, make sure you turn it off on the production site though! 16:09:00 heh 16:11:49 wow 16:11:58 this is my record uptime so far: 12:17PM up 48 days, 2:14, 1 user, load averages: 1.00, 1.00, 1.00 16:15:38 Where did Mark run off to? 16:16:07 markd2 has joined #openacs 16:16:21 jeez 16:16:28 you got ESP or something? 16:16:35 Where did Mark run off to? 16:16:35 --> markd2 (markd2@r-41.33.alltel.net) has joined #openacs 16:16:35 jeez 16:16:35 you got ESP or something? 16:16:38 Do you recommend using the OpenNSD fork of AOLserver with OpenACS-4? 16:16:58 No. Use the arsdigita 3.3+ad13 version. 16:17:03 heh 16:17:23 * markd2 could feel a disturbance in the Force 16:17:29 :) 16:17:41 Mark, do you want a copy of my l33t db drop/recreate script? 16:17:58 nah. but thanks 16:18:12 mkay 16:18:21 I just do 'drop user acs4 including contents' then 'create user acs4 blah blah blha', 16:19:04 You obviouslyhave the blahs memorized. I can never remember if its blah blah blah or blah blah blah blah 16:19:17 I've done it so many times it's reflex 16:19:33 create user davb identified by dave default tablesapce users temporary tablespace temp quota unlimited on users; 16:19:46 grant create session, resource, connect, plustrace to davb 16:21:15 heh 16:25:15 You guys feel zero compelling need to move to java, right? 16:25:52 java will be used where it makes sense, 16:26:00 but a whole-hog porting to Java isn't in our cards 16:26:04 (openacs wise) 16:26:28 thanks markd2! 16:33:38 i really need to understand why oracle is complaining 16:35:20 what's the error? 16:35:49 They don't look like errors 16:36:11 they look like left over junk from my previous script run causing name collisions 16:36:28 SQL> @@snmp-create.sql 16:36:29 declare 16:36:29 * 16:36:29 ERROR at line 1: 16:36:29 ORA-00001: unique constraint (MYOPENACS.ACS_OBJECT_TYPES_PK) violated 16:36:29 ORA-06512: at "MYOPENACS.ACS_OBJECT_TYPE", line 28 16:36:31 ORA-06512: at line 4 16:36:33 No errors. 16:36:35 create table incidents ( 16:36:37 * 16:36:39 ERROR at line 1: 16:36:41 ORA-00955: name is already used by an existing object 16:37:01 the 955 means you already ahve a talbe by that name 16:37:17 the 00001/6512 I've mentioned before 16:37:29 the acs_objects_type table is complainig about a primary key violation 16:37:43 you're trying to insert a second row with one primary key 16:38:05 yeah I did have a table of the same name 16:38:16 What is the primary key violation business? 16:38:29 do you know what a primary key is? 16:38:47 In which table? 16:38:51 my tables or OACS tables? 16:38:55 any table 16:38:58 yeah 16:39:04 then you have your answer 16:39:10 a primary key *UNIQUELY* identifies each row 16:39:16 right 16:39:25 if you try to use the SAME primary key twice, you'll get a complaint 16:39:27 so is it saying I have two instances of something 16:39:35 k 16:39:40 but I don't have any data 16:39:42 yes 16:39:44 so how can it be violating that? 16:40:06 ohhhhh 16:40:08 lemme guess 16:40:19 if i say it has to be not null but i make it null in the body of the function 16:40:41 definition not matching body would error on that? wouldn't it... 16:41:16 nulls have nothing to do with it 16:41:43 look at the code where you're getting that error. 16:42:58 blasted xemacs without x.... 16:43:06 * Psychephylax looks for line number enabling deal 16:49:20 well, I figured that out 16:49:24 but not how to make it stick 16:52:59 ummm 16:53:11 Line one just says "declare" how can THAT be wrong? lol 16:53:36 sounds like you've been trough customs 16:53:53 heh 16:54:18 i think I know the problem 16:54:29 When you create a table with constraints 16:54:37 the constraints are stored in a diff table - correct? 16:54:47 So when I drop my table the constraints still stay there 16:54:54 which causes the conflict...? 16:55:20 no 16:55:24 So is the proper way to drop a table with declared constraits to do it like this: drop table blah cascade? 16:55:29 when you drop a table, the constraints go with it 16:55:35 oh 16:55:45 unless ther are foreign key constraints that refernece that table 16:56:03 e.g. table1 (blah integer primary key); table2 (blah referneces(table1); 16:56:09 ow. my head hurts. I have been reading the cms-list. 16:56:10 if you try to drop table1, it'll complain 16:57:08 lemme see I think H ave that 16:58:34 d'oh 16:59:00 I can almost make a 50$ bet that OACS probably already used incident somewhere on it's own 16:59:10 and my object called incidents is clobbering the existing one 16:59:33 ticket-tracker? 16:59:40 that'd be my first guess 16:59:44 Why aren't you using that BTW? 16:59:48 or extending it. 16:59:59 I've taken to prefixing my stuff with md_ just to elimate namespace collisions like that 17:00:04 * davb ducks 17:00:08 ticket-tracker 17:00:10 ? 17:00:28 its a good idea to make up a prefix for the package name or something that isn't already used. 17:00:48 * Psychephylax dashes to the ticket-tracker package evilishly looking at dave for not telling him sooner 17:00:59 heh 17:01:01 Hey I just thought of it. 17:01:17 I thought you looked already, sorry. :( 17:02:55 check the status page, see who worked on it... (let's blame someone who's not here) 17:03:10 there is also a ticket-tracker-lite 17:06:13 brb 17:07:12 * davb goes to lunch... 17:08:09 back 17:08:18 lol 17:08:20 Vinod worked on it 17:13:45 * Psychephylax concentrates his ESP powers and tries to contact Vinod 17:31:57 hmm 17:32:03 I looked at the ticket-tracker 17:32:08 call him up at home. he likes that 17:32:09 I don't see what it's primary function is 17:32:12 lol 17:32:16 Where does he live? 17:33:47 bahstan 17:34:22 Where the hell is bahstan? 17:34:56 Bahstan, Mass. 17:35:11 oh 17:35:20 I thought that was like a diff country 17:35:21 lol 17:35:33 * rbm stumbles into the channel 17:35:34 Outer Vinodville 17:35:39 m� 17:35:52 howdy markd2 17:36:20 Hey Roberto 17:36:27 hey psyche 17:38:02 Ok I know I asked this before but I don't think I ever got a good question 17:38:21 is there a place where there's like a paragraph description of all the available packages for OACS? 17:38:52 Summary:This is a sample workflow application, only for demonstration purposes. 17:38:58 is not very explicit 17:39:08 I don't think there is one. 17:39:12 not yet. 17:39:22 But if you visit the ACS repository, you should get the discription 17:39:28 The ticket tracker is a general purpose tool for managing and 17:39:28 resolving issues. 17:39:41 is openacs going to be taking over the acs repository? 17:40:07 Psychephylax: did you read the stuff in packages/ticket-tracker/www/doc ? 17:40:42 ok 17:41:47 this might be a dumb question but how do I look at the html/xml pages in that folder though a browser? 17:42:03 Aside from moving them somewhere I have access to and looking at them this way 17:42:07 I go to the folder and type lynx index.html 17:42:09 i'd rather not go into windows 17:42:16 lynx is not installed :( 17:42:34 install the package and go to myserver/doc 17:42:42 k 17:43:27 Man, I wish I had this project assigned to me like last spring 17:43:31 I would have helped you all summer long 17:43:39 with documentation and junk 17:44:05 ok it doesn't show up in there 17:44:28 markd2: Yes, at some point, at least the Tcl version 17:44:30 but it is installed 17:45:44 did you restart? 17:45:55