02:09:15 Any reason why this doesn;t work? 02:09:18 openacs-4=> select acs_permission__grant_permsission ( 02:09:18 openacs-4(> 2480, 02:09:18 openacs-4(> acs__magic_object_id('the_public'), 02:09:18 openacs-4(> 'general_comments_create' 02:09:18 openacs-4(> ); 02:09:34 I am getting one of these: ERROR: Function 'acs_permission__grant_permsissi(int4, int4, unknown)' does not exist 02:09:34 Unable to identify a function that satisfies the given argument types 02:09:34 You may need to add explicit typecasts 02:09:34 openacs-4=> 02:10:04 Why is 'general_comments_create' type unknown? 02:10:20 The function def is (int,int,varchar) 02:10:49 docwolf has joined #openacs 02:11:07 try casting 'general_comments_create'::varchar 02:11:14 upon passing 02:11:55 thanks! 02:12:37 Ok that doesn't work either. Hmmmm 02:12:37 Thank me when you get it working :) 02:12:41 See? 02:12:52 Rightm but that means the function doesn;t exist. 02:13:07 I wonder why. That one HAS to be there I got it all installed. 02:13:12 does acs__magic_object_id('the_public') return an int? 02:13:50 yes. I tried -1 also in place of that for fun. 02:15:00 Aha mine is truncated to acs__permision_grant_permissi 02:15:11 openacs-4=# select proname, pronargs, proargtypes from pg_proc where proname like 'acs_permission%'; 02:15:11 proname | pronargs | proargtypes 02:15:11 ---------------------------------+----------+------------- 02:15:11 acs_permission__grant_permissio | 3 | 23 23 1043 02:15:11 acs_permission__permission_p | 3 | 23 23 1043 02:15:11 acs_permission__revoke_permissi | 3 | 23 23 1043 02:15:13 acs_permissions_lock_tr | 0 | 02:15:21 the function is acs__permission__grant_permissio 02:15:35 Doesn't matter. PG will truncate for you when you call it. 02:15:59 yeah but its truncating it differently than the function name. 02:16:08 No it isn't 02:16:14 hmmmm 02:16:33 argh! I spelled it wrong like 20 times. 02:16:39 thnaks! 02:16:46 did it work? 02:17:24 yes. 02:17:41 but it doesn;t work in my pl/pgsql function. 02:26:11 anyone knows how to use ON DELETE CASCADE? 02:26:35 sorry, no. 02:32:30 docwolf has quit 02:57:57 anything wrong with this? 02:58:01 -- Copy permissions from the parent: 02:58:01 for v_permission_row in 02:58:01 select grantee_id,privilege from acs_permissions 02:58:01 where object_id = p_parent_id 02:58:01 loop 02:58:01 perform acs_permission__grant_permission( 02:58:03 v_folder_id, -- object_id 02:58:06 v_permission_row.grantee_id, -- grantee_id 02:58:08 v_permission_row.privilege -- privilege 02:58:10 ); 02:58:12 end loop; 02:58:14 oops 03:00:47 Is v_permission_row declared as a RECORD? 03:02:24 its defined as acs_permissionsOWTYPE 03:02:35 hey my disapperad 03:02:38 argh! 03:02:43 % 03:02:58 well the % and R fell off rowtype 03:24:20 rbm: practical postgresql has a pretty good chapter on pl/pgsql. 03:24:57 well time for me to go 03:25:00 davb has quit 04:03:55 hazmat has joined #openacs 04:33:26 hazmat has quit 05:32:34 hazmat has joined #openacs 05:48:16 ns_soap in is cvs at sf nssoap.sf.net 05:48:28 s/in is / is in 06:26:55 rafa has left #openacs 08:17:33 jerryasher has joined #openacs 08:17:39 jerryasher has quit 08:43:46 jerryasher has joined #openacs 08:44:34 Where's the place to swap aD rumors? 08:57:40 Or are they so yesterday's news that no one cares anymore? 09:15:45 jerryasher has quit 09:45:35 rzolf has joined #openacs 10:28:44 rzolf has quit 10:36:39 ola has joined #openacs 10:54:25 ola has quit 11:03:28 ola has joined #openacs 11:32:18 ola has quit 12:16:04 Spork has quit 13:09:24 davb has joined #openacs 13:31:38 markd2 has joined #openacs 13:37:40 markd2 has quit 13:40:09 markd2 has joined #openacs 14:13:10 vinod has joined #openacs 14:13:18 Hi vinod, markd2 14:13:25 happy birthday markd2 !!!!!!!!!!! 14:13:31 hey dave! 14:22:53 :-) 14:23:15 I'm still 6 years younger than my main social group up here 14:23:18 but I'm catching up! 14:24:09 heh 14:26:02 that's my trick, too - age is relative, so always hang out with old people :-) 14:27:16 that's why you like hanging around with me, right? 14:27:54 hey.... no... not at all... you're older than me?? I had *no* idea 14:28:00 * vinod has innocent look on face 14:28:36 :-) 14:29:56 vinod: what do you use for a FOR IN LOOP in pl/pgsql ROWTYPE or RECORD? I always have a problem when I use ROWTYPE. 14:30:16 heh 14:30:20 PERFORMER 14:30:57 davb: use ROWTYPE if the row that you're getting is exactly like the row in the db, otherwise use RECORD 14:31:16 * vinod can't think of a way to use PERFORM here 14:31:32 What do you mean by EXACTLY. Does it have to contain all the same columns? 14:31:38 yep, i think so 14:31:47 OK, so if a couple a missing, use RECORD? 14:32:09 yep 14:32:32 OK. I don't think PL/SQL works like that. 14:33:07 no, i think you're right. i remember banging my head against that a while back 14:33:28 ola has joined #openacs 14:33:33 vinod is correct (of course) 14:33:57 hi all! 14:34:10 Right, but I think it works in Oracle with ROWTYPE. All the original code uses that. Does oracle have RECORD? 14:34:17 hey ola! 14:34:35 hi ola 14:34:51 That should be in the Postgresql docs somewhere. 14:36:18 YEAH! I got a different error message. 14:36:41 b 14:38:33 c 14:38:45 c++ 14:39:37 * markd2 loves C and C++ 14:39:50 they make me feel more manly when I get something working 14:40:08 Real men program in assembly 14:40:25 real men cat > app-name and enter the bytes 14:40:44 hehe 14:41:02 now thats fun. 14:41:05 markd2 should start an internet-university teaching real-man tricks 14:41:14 He-Man tricks 14:41:17 i'd enroll 14:41:20 :-) 14:41:23 * markd2 shouts "by the power of Numbskull!" 14:41:30 Masters of the Universe! 14:41:51 did you ever watch Thundercats? 14:42:08 Ok. How do you guys roll your server error logs? 14:42:14 i think by accident - i was a He-Man fan 14:42:20 ah 14:42:23 I found some outtakes 14:42:25 http://www.claws-and-paws.com/thundercats/index.shtml#outtakes 14:42:29 davb: i use logrotate 14:43:11 seriously, how do I add code to the openacs.org tree? 14:43:15 yeah its a debian package 14:43:31 cvs add , cvs commit 14:43:48 I checked out acs-core as "olah", now what? 14:44:19 markd2: these outtakes are great 14:44:36 shall I log in to their server? 14:44:40 Nope. 14:45:03 Well, actually depends on how your CVS is setup. My CVS environment is setup to use OpenACS.org as the server 14:45:05 etc... 14:45:12 So I don't have to login. 14:45:25 ok. I copied my package to /packages 14:45:29 when you do add or commit it should ask for your password. 14:45:37 davb: mine is too 14:45:42 ok 14:45:59 ola: you'll have to check out the mp3 package from openacs first 14:46:12 vinod: I did that. 14:46:16 right, then replace it with your new files. 14:46:19 oh, ok 14:46:45 ola: did someone create the package under the new name? 14:46:45 Spork has joined #openacs 14:46:50 vinod: NO I didn't, sorry.. 14:46:53 in the CVS tree? 14:46:55 Hey all 14:47:02 hey Spork 14:47:06 heh Spork 14:47:16 s/heh/hey 14:47:24 Hola ola, privet vinod 14:47:26 hey logrotate is already installed. 14:47:30 hi spork 14:47:33 * Spork needs some greeting that rhymes with vinod 14:47:36 hey dave 14:48:01 davb: isn't debian great? 14:48:04 GEM has joined #openacs 14:48:13 Hi GEM! 14:48:13 GEM! 14:48:13 spork: just call him; Mr PERFORM. 14:48:18 hola 14:48:39 Hey davb and vinod! How's life? 14:49:25 * Spork sporks GEM for not saying hi to spork 14:49:27 Just finishing up static-pages. 14:49:57 Hiya Psychephylax 14:50:06 Hey mark 14:50:21 * Spork sticks a "Hello $1!" on his forehead 14:50:26 davb: when I've replaced it with the new files, should I remove the CVS dirs? 14:50:31 sorry, Spork! Hi to you, too! 14:50:43 hi chump! long time no see! 14:50:49 * Spork points to the sign on his head 14:51:17 GEM: life is good. how bout with you? 14:51:17 Label GEM not found. 14:51:18 no. just do a cvs add for any new files (XQL etc...) and then cvs commit 14:51:27 it will update the tree. 14:51:51 if your other directory has a CVS directory in it, don't copy that over. 14:52:27 Not too bad, thanks, Vinod. my mortgage has been sold again. I forget if I've talked in this channel since I got married, though...that is good stuff 14:52:27 davb: ok. thanks. I'll try. 14:52:54 congrats GEM! 14:55:27 I must leave. see y'all later 14:55:34 ola has quit 14:55:58 yes we are. it's just a very long driveway 14:57:37 anyone use VNC here? 15:02:16 nope 15:07:11 talli has joined #openacs 15:07:20 Hi talli 15:07:29 hey guys 15:08:11 is markd here? 15:08:38 he was 15:08:46 yep! 15:08:53 * Spork pokes markd with his extra pointy 'ork 15:08:54 * markd2 is lurking 15:08:59 or a lurking horror. not sure which 15:09:18 i'm here too, talli 15:10:59 watch out for the library. I didn't think it was snowing that hard yet 15:15:50 vinod, did i ask for you? 15:15:55 go back to your sewing 15:16:06 that little sew-and-sew 15:16:24 markd, this is a very dangerous question, but... 15:16:48 how hard would it be to port the OpenACS to sybase given the query dispatcher? how different is it from oracle and PG? 15:16:51 * markd2 hears the scary music in the background 15:17:05 hmmm 15:17:11 I won't be easy I bet 15:17:21 oracle and sybase have pretty radically different concepts over locks and transactions 15:18:02 ok. 15:18:04 * vinod goes back to his sewing 15:18:11 is that a showstopper? 15:18:46 it'll mean some work and some tuning 15:18:59 ok, thanks 15:19:00 go to a book store, find Thomas Kyte's "Oracle one-on-one" book by Wrox press 15:19:02 another q... 15:19:09 read the chapter that talks about transactions 15:19:14 it compares oracle and sybase 15:19:20 ok, cool. thanks 15:19:29 do you know if AOLserver runs on AIX? 15:19:39 AOL never did a port 15:19:48 there ma ybe someone out thre that's done it 15:19:56 get the source and look for AIX 15:20:04 ok 15:20:04 if there aren't any, then nobody ported and submitted the diffs 15:20:13 would it be hard? 15:20:50 i'm talking to a guy who apparently has an NT and AIX setup 15:21:18 the ideal situation is probably get some little server running Linux, AOLserver and the OPenACS code that connects to AIX 15:21:49 but i would like to advise him one way or the other 15:23:10 maybe i'll just tell him to use ACS Java which will solve all of his problems 15:23:16 that runs anywhere! 15:23:47 I'd a imagine an AIX port would be hard 15:24:01 ok, cool 15:24:01 thanks 15:54:12 argh, the referential integrity weirdness in postgresql gets me again. 16:12:34 how can I get EMACS to re-read the error log? 16:13:24 without closing and ropening a buffer. 16:26:05 ola has joined #openacs 16:27:47 you can re-open it 16:27:50 and M-x revert-file 16:27:52 I open a shell in emacs and do a tail -f 16:27:52 no need to re-load it :-) 16:28:01 vinod has quit 16:28:04 talli has quit 16:28:04 rbm has quit 16:28:04 Spork has quit 16:29:46 thanks markd2 16:31:39 oops. if you drop/create a function thats called by other functions you have to drop/create them all in postgresql 16:31:54 bummer 16:32:17 when it creates the function it references the OID of the other functions in there. 16:32:46 it just gets tricky when you do it 3 or 4 levels deep. 16:32:57 thats why I end up dropdb/createdb alot. 16:35:05 it's sometimes enough to do /i "path-to-drop-script" in psql 16:35:45 my drop script is broken. I have to fix it. Has to do with dropping columns 16:39:49 markd2 has quit 16:40:24 ack. my content_item__new hacked function need to be rehacked. 16:51:28 rbm has joined #openacs 16:51:28 Spork has joined #openacs 16:57:46 davb: if it makes you feel better create or replace function (retaining oid) is coming 16:58:35 COOL! 17:24:06 * rbm moos 17:24:14 mooo 17:27:36 doh! I think I'll just stop breathing...: 17:27:39 **** Access denied: Insufficient Karma (olah|openacs-4/packages/mp3jukebox) 17:27:40 cvs server: Pre-commit check failed 17:30:12 what does puts do again? 17:30:18 arg 17:30:21 * Spork pauses 17:31:37 never mind 17:31:46 I have my big book of TCL/TK goodies with me today 17:32:09 I do want to know how to append to something 17:35:01 tcl is such an easy language, easy to forget that is:) 17:35:30 lol 17:37:46 it also doesn't like my formatting 17:37:52 * Spork curses out the white spaces 17:38:32 how would I group something so it expands but doesn't care about whitespaces? 17:40:56 read Tcl for web nerds. 17:41:09 Again. It explains pretty well how to get the brackets in the right place. 17:42:18 ola that's not your fault. 17:42:21 Email DonB 17:42:32 He is the Karma distributor. 17:42:47 heh 17:42:48 Spork append is append. 17:42:57 lappend adds another item to a list. 17:43:06 append varname "stuff" 17:45:10 davb: mp3jukebox has been renamed mp3-jukebox, so DonB told me I only have commit rights on that. 17:45:43 aha. 17:46:48 but when I do: "cvs co mp3-jukebox" I'm getting this: 17:46:56 cvs server: cannot find module `mp3-jukebox' - ignored 17:46:58 cvs [checkout aborted]: cannot expand modules 17:47:03 heh 17:47:05 what fun. 17:47:07 but... 17:47:15 ola: I can check the server for you, hang on, let me ssh in there 17:47:33 rbm: great! 17:47:37 its not in the SDM repository. 17:47:42 yeah, rbm is handy to have around. 17:47:51 :) 17:48:09 I still see it as mp3jukebox 17:48:24 when I do: cvs add mp3-jukebox it gives me this: 17:48:26 cvs [add aborted]: there is a version in mp3-jukebox already 17:48:45 Hmmm. Who renamed this to mp3-jukebox? 17:49:48 DonB told me I only have commit rights on mp3-jukebox so I'd have to rename... 17:50:17 Yeah, I see you only have rights to mp3-jukebox, but there's no mp3-jukebox dir created. 17:50:24 I think you have to create it. 17:50:42 create a mp3-jukebox dir, than copy all the files you have in, and commit them. 17:51:05 I could do it for you, but then it'd take the fun out of your hands :) 17:52:16 I did, cd /web/openacs4/packages followed by "cvs add mp3-jukebox", with that directory existing!! 17:52:31 didn't work... 17:53:55 I *was* able to "cvs add" other files under mp3jukebox, though. 17:53:56 hmm 17:54:08 Why was it renamed anyways? 17:54:21 but then I did a check-out first 17:54:26 all-the-names-are-going-to-be-the-same-format 17:54:32 Oh, I see 17:54:36 :) 17:54:42 :-) 17:54:42 Let me add this darn thing 17:55:14 sure. may be the best thing to do... 17:57:03 rbm: you will only add an empty dir, right? 17:57:48 yeah 18:02:47 ola, try now 18:03:00 I have to eat now. brb 18:03:16 rbm: thank you! 18:05:56 markd2 has joined #openacs 18:14:02 rbm: insufficient Karma again. 18:18:26 I am getting a Cannot pass more than 16 arguments to a function error. No mention of where this function call is though... 18:23:01 jerryasher has joined #openacs 18:23:16 hi jerry 18:23:23 Hi Dave! 18:23:40 I heard a rumor that aD was closing down various offices. Anyone know more about this? 18:23:49 (Anyone care about aD anymore?) 18:27:53 hi jerry. 18:28:05 daveb: do you have verbose on? 18:28:12 I suspect so. 18:28:15 * davb checks 18:29:10 yeah, they are all on. I think its in a function, but the function. It shows the SQL for calling the function which is NOT over 16 18:29:12 brb 18:29:24 abbaJ has joined #openacs 18:29:32 davb has quit 18:31:57 jerry: of course we care about aD, just not their license. 18:33:04 Ah, well it's just not clear anymore that anyone would care about aD. 18:33:18 Aside from gossip that is, they appear increasingly irrelevant. 18:33:24 * markd2 doesn't care 18:35:03 if you do return without any arguments it doesn't do anything right? 18:35:33 it just halts. 18:35:54 hmm 18:35:58 ok 18:36:01 I don't get this then 18:36:10 ok 18:36:29 in Tcl? return returns an empty string from the proc 18:36:30 I need to retrieve an error 18:36:51 in scotty tcl there's a %E that has the error 18:37:09 I e-mailed Vlad (the person who wrote the nssnmp module) and he said he catches them directly 18:37:27 He sent me a sniplet of code (as if he thinks I know exactly what it does): 18:37:36 Usually i catch errors directly: 18:37:36 if [catch { 18:37:36 ns_snmp walk $fd [ns_mib oid ifTable] var { 18:37:36 set oid [lindex $var 0] 18:37:36 ... 18:37:37 } 18:37:39 } errmsg] { 18:37:41 ns_log Error SNMP: $errmsg 18:37:43 return -1 18:37:45 } 18:37:57 it looks like his program exits with a -1 code 18:38:04 I need mine to keep running 18:38:22 so I did errmsg] { 18:38:23 } 18:38:27 * rbm returns 18:38:36 but it's returning the session id 18:38:56 ola: insufficient karma? 18:39:19 please insert 25 dogma to continue 18:39:21 ola: are you sure it's a copy of CVS checked out via SSH and your olah user? 18:39:21 rbm: yessir. 18:40:39 yes to both questions? 18:41:13 rbm: I think so. I have: export CVS_RSH=ssh andexport CVSROOT=olah@openacs.org:/cvsroot 18:41:57 rbm: do I need :ext:olah@openacs.org:/cvsroot 18:42:03 ? 18:43:12 no. But did you checkout that way? Some people were trying to commit stuff on their anonimously-checked out cvs copies 18:44:00 oh, wait! maybe I need to check-out the empty "mp3-jukebox" ? 18:44:31 Well, you need to update your cvs 18:44:38 cvs update -PAd is what I do. 18:45:24 ok. lemme try... 18:51:37 davb has joined #openacs 18:53:24 rbm: I'm in /web/openacs4/packages when I issue: "cvs commit". after I add a message the commit is rejected. 18:54:46