00:01:52 ola has quit (ircII EPIC4-1.0 -- Are we there yet?) 00:16:45 gilbertw has quit () 00:29:38 tdxdave: hmm. I've never seen it. I've just seen people using it 01:49:14 vinod (vinod@d43.dial-2.cmb.ma.ultra.net) has joined #openacs 01:57:26 here is a good one. 01:57:42 If I define a variable as a OWTPPE and use a FOR loop 01:57:55 %rowtype that is 01:58:19 if the select in the for does not return all the columns in the row i get an error message: 01:58:27 acs-4,ERROR: query didn't return correct # of attributes for v_permission_row 01:58:27 ): 01:59:48 I just use record instead and that works ok. 02:01:38 vinod: thanks that is what I needed. 02:01:57 tdxdave: no problem 02:01:57 So basically I am just screwing up my functions, that is the problem. :) 02:04:24 I cheated by creating variables for the values and defaulting them to the value I wanted it to be. 02:10:17 hmmm... i think the %ROWTYPE should work 02:10:43 my select says 02:10:57 SELECT grantee_id,privilige from acs_permissions 02:11:53 i just tried this and it works: 02:11:55 create function vk_test() 02:11:56 returns integer as ' 02:11:56 declare 02:11:56 users_rec users%ROWTYPE; 02:11:56 begin 02:11:56 for users_rec in select user_id from users where user_id < 3000 02:11:58 loop 02:12:00 raise notice ''user_id=%'',users_rec.user_id; 02:12:02 end loop; 02:12:04 return 0; 02:12:06 end;' language 'plpgsql'; 02:12:17 Which postgresql do you have? 02:12:59 openacs4=# select version(); 02:12:59 version 02:12:59 --------------------------------------------------------------- 02:12:59 PostgreSQL 7.1.2 on i586-pc-linux-gnu, compiled by GCC 2.95.4 02:13:18 i am using 7.1.0 because of debian package problems. 02:13:58 yeah -aolserver and pg are the only 2 non-debian apps that i compile myself (and the kernel) 02:15:39 maybe I will just compile it. I hate to break my debian streak. Even daemontools has a debian pacakge. 02:18:14 * tdxdave is reloading the datamodel 02:24:21 cool, my patches seemed to have worked. 02:24:35 Now I have to send them to DanW (scary) :) 02:26:11 haha - patching the core - now you're a real man ;-) 02:26:29 lol 02:26:38 (not really family is sleeping) 02:28:05 ssssssshhhhh. 02:36:59 vinod has quit (Ping timeout for vinod[d43.dial-2.cmb.ma.ultra.net]) 02:38:57 patches emailed to Dan 02:39:05 * tdxdave crosses his fingers 02:41:04 deadman is now known as wikimadness 02:41:24 wikimadness: interesting moniker 02:42:27 is that like reefer madness? 02:44:45 anyone know what empty_blob() does? 02:49:05 Please welcome Niven.OpenProjects.Net! Based in Phoenix, Arizona! 02:53:11 vinod (vinod@d221.dial-4.cmb.ma.ultra.net) has joined #openacs 02:55:27 vinod: do you have any idea how to replace content_repository blob stuff with text? 02:55:46 (aren;t you lucky you came back! :) 02:58:24 so you basically want to create a content_item that contains text instead of a blob, right? 02:58:38 yes. static-pages are all text. 02:59:55 i think some of the content_item__new's are for binary content and some are for text 03:00:23 look at the third content_item__new in packages/acs-content-repository/sql/postgresql/content-item.sql 03:00:35 ok. 03:22:34 Thats good, but for some reason static-pages creates the items first, then adds the content after 03:22:59 I think I can greatly simplify the code by switiching to text 03:25:23 yeah - i think aD's content-repository was blob only (text was put in blobs), so the item was created and then the blob was put in 03:26:01 since the CR is now text/blob/file, i would simplify if I was just using text 03:28:17 Cool, thanks for listening. Its handy to have someone to talk about this stuff to. 03:35:34 well thanks again goodnight everyone 03:35:37 tdxdave has left channel 04:06:01 vinod has quit (forward.openprojects.net niven.openprojects.net) 04:14:04 wikimadness has quit (Ping timeout for wikimadness[CBL-kthangavelu-a.hs.earthlink.net]) 04:21:25 gilbertw (gilwong@adsl-63-197-20-211.dsl.snfc21.pacbell.net) has joined #openacs 04:49:58 vinod (vinod@d221.dial-4.cmb.ma.ultra.net) has joined #openacs 04:54:45 bbaquiran (brianb@210.16.70.2) has joined #openacs 05:08:06 wikimadness (ender@CBL-kthangavelu-a.hs.earthlink.net) has joined #openacs 05:12:35 wikimadness has quit (Ping timeout for wikimadness[CBL-kthangavelu-a.hs.earthlink.net]) 05:15:53 wikimadness (ender@CBL-kthangavelu-a.hs.earthlink.net) has joined #openacs 05:26:01 gilbertw has quit () 06:25:07 mee?? 06:25:15 s/mee/moo/ 06:26:46 good afternoon 06:31:12 howdy 06:32:25 afternoos? 06:32:31 bbaquiran: where are you? 06:32:38 * rbm sends a huge message no openacs.org 06:32:48 hey vinod. what's up? Working? 06:33:27 well, got back from work and had an urge to work on openacs and now it's 2:30 in the morning 06:33:31 doh! 06:34:19 nice post roberto - i agree with you 06:37:23 vinod: thanks 06:37:36 I never thought managing an open source project would be this hard 06:37:43 geesh :) 06:38:28 i know - i'm having a blast and it's amazing that everyone's not having as much fun as i am :) 06:39:35 I know!! 06:40:29 See, all this management crap, and having to spend time just to calm the community down, and stop attempts to have "steering committes", etc. just takes time off the fun stuff: getting things to work 06:41:05 If everyone would just listen to Don saying "let's do what's important NOW, and worry about other things later", it'd me much easier for everyone, and much more productive too 06:41:43 i think part of the issue is that people just want to see something happening, so once a beta is out, non-porters will be able to focus their energies better 06:41:43 Don is not trying to be an asshole. He's not. But he speaks out when necessary. Jerry has been out with this committee and search stuff for weeks. 06:42:20 i know - i've met Don - he's a great guy 06:45:32 hey rbm, remember how you suggested that someone put together a html page that linked to a bunch of porting info? 06:46:06 yeah 06:46:22 well, i did - it's pretty rough- you wannit? 06:46:37 It should also like to things like your installation guide 06:46:42 YES!!!! 06:46:53 i love the enthusiasm :-) 06:47:00 should i just email it to ya? 06:47:04 * rbm jumps and dances 06:47:08 or dcc 06:47:09 lol 06:47:20 * rbm jumps some more 06:47:23 what's dcc? 06:47:36 haha - don't hurt yourself :-) 06:47:36 Direct Client Connection (or something like that). 06:47:44 oh, how do i do that? 06:47:52 You do: /dcc send rbm /path/to/myfile.html 06:48:59 DARN! 06:49:09 I forgot to turn off my firewall 06:49:15 vinod: send it again please 06:50:30 Ehh??/ 06:50:38 vinod: are you behind a firewall? 06:51:02 gee, I turn my back all and all of a sudden everyone starts typing 06:51:07 oh yeah 06:51:13 i'll just email it 06:51:25 Ok 06:51:31 rbm, I'm in the Philippines 06:51:31 * rbm turns his firewall back on 06:51:44 bbaquiran: There are a lot of people here who have been to the philipines 06:53:09 on holiday? 06:53:50 In Utah 06:56:41 vinod: excellent! Thanks! 06:57:21 rbm: no problem - it was basically a brain dump, so it might need some polishing 06:57:56 gotta hit the sack - promised myself i would be in bed by 3:00 AM 06:57:58 :-) 06:58:07 talk to y'all manana 06:58:07 heh 06:58:08 later 06:58:14 vinod has left channel 06:58:29 rbm: are you referring to the Mormon missionaries sent here? 07:00:00 yep 07:00:24 I even learned a philipino word the other day. But can't spell it :) 07:01:12 what was the word supposed to mean? 07:08:09 Hmmm. I don't remember eeither :) 07:08:18 time for bed (past time actually{) 07:08:19 later. 08:46:29 bbaquiran has quit () 09:27:25 ola (ola@as3-1-3.mal.s.bonet.se) has joined #openacs 10:05:06 ola has quit (ircII EPIC4-1.0 -- Are we there yet?) 11:31:20 SteveW (swoodcock@194.72.81.226) has joined #openacs 12:14:11 shagster has quit (Read error to shagster[207.166.201.55]: Connection reset by peer) 12:44:52 tdxdave (dave@208.136.23.204) has joined #openacs 13:16:42 bbaquiran (bpb@202.8.232.47) has joined #openacs 13:25:27 AaronSw has left channel 13:25:30 AaronSw (Snak@c930384-a.hlndpk1.il.home.com) has joined #openacs 13:27:47 loggy (openacs-lo@v123-1.ARSDigita.seg.NET) has joined #openacs 13:27:47 Users on #openacs: loggy @AaronSw bbaquiran tdxdave SteveW wikimadness GEM rbm 13:27:47 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ 13:27:51 AaronSw has left channel 13:27:52 AaronSw (Snak@c930384-a.hlndpk1.il.home.com) has joined #openacs 13:39:30 bbaquiran has quit (Client Exiting) 14:11:29 markd2 (markd2@166.102.41.165) has joined #openacs 14:12:45 shagster (mkovach@207.166.201.55) has joined #openacs 14:42:37 * tdxdave is having debian troubles 14:46:34 moo 14:46:41 what's up tdxdave? 14:50:28 I installed the new apt-get and now I have a bunch or broken packages. I was going to try to install postgresql 7.1.2 again. 14:50:47 I think I will have to update the entire system to unstable to make it happen. 14:51:44 I am reading the dselect documentation right now 14:57:04 ola (ola@as3-1-3.mal.s.bonet.se) has joined #openacs 14:57:06 hmmm. I don't know if apt 0.5 will work with something other than unstable 14:57:21 why did you install the new apt if you're not running unstable? 14:57:54 bbaquiran (bpb@202.8.232.47) has joined #openacs 14:58:33 I don't have any trouble running unstable. I run it on many computers, some of them important. I just am careful when doing upgrades. 14:58:53 s/I just am/I am just/ 15:01:14 mainly I have no idea what I am doing. So I just wing it. Eventually I will figure it out. 15:01:33 As long as I don't commit anything to the OpenACS tree while I am doing it, I am OK. 15:02:04 I think perhaps I should backup and install a proper debian system. 15:04:06 markd2 has left channel 15:05:04 tdxdave: Are you in Progeny? 15:05:28 well, yes and no. I started with it, but I don't know how much is left. 15:05:46 tdxdave: Is this a critical system? 15:05:51 I need about 10 computers so I can experiment with different things on them. 15:05:54 if not, just upgrade to unstable. 15:06:06 Its not crtical, except my OpenACS work is on it. 15:06:08 But then, I have critical systems running unstable. 15:06:28 tdxdave: can you make a backup of the OpenACS work before upgrading to unstable? 15:06:39 Should I just select unstable in sources.list and comment out everything else? 15:07:00 pretty much 15:07:19 You can leave the progeny lines too. APT will grab the most up-to-date packages 15:07:28 As long as it doesn't format my harddrive, I'll be ok. 15:07:39 then do an apt-get update, and apt-get dist-upgrade 15:08:25 cool, i will give it a shot. worst case, I have to install a spare HD and backup my files. 15:08:32 * rbm goes study. bbl 15:13:35 shagster has quit (Ping timeout for shagster[207.166.201.55]) 15:35:44 vinod (vinod@d209.dial-6.cmb.ma.ultra.net) has joined #openacs 15:36:03 markd2 (markd@166.102.41.165) has joined #openacs 16:05:23 markd2 has quit (Bork) 16:32:19 SteveW has quit (Read error to SteveW[194.72.81.226]: EOF from client) 16:50:47 bbaquiran has quit (Client Exiting) 17:01:22 vinod has quit (ircII EPIC4-1.0.1 -- Are we there yet?) 17:02:17 derfy (derfy@fcy-5.soho.enteract.com) has joined #openacs 17:10:38 shagster (mkovach@207.166.201.55) has joined #openacs 17:57:24 gilbertw (gilwong@atlrel2.hp.com) has joined #openacs 18:03:02 gilbertw has quit () 18:10:00 rbm_ (roberto@slxwy.dorms.usu.edu) has joined #openacs 18:11:59 rbm has quit (Ping timeout for rbm[slxwy.dorms.usu.edu]) 18:29:06 rbm_ has quit (changing universes) 18:29:16 rbm (roberto@slxwy.dorms.usu.edu) has joined #openacs 18:30:02 * tdxdave thinks this system could possibly be more broken, but is still surprisingly functional still. 18:41:05 cool, my machine has limped back to its previously functionality and I still cannot install postgresl 7.1.2 18:41:24 I downloaded the .debs and it is saying there are some unmet dependencies. 19:00:24 aha 19:00:41 postgresql 7.1.2 is only available in non-us version, that I can find. 19:00:46 (debian package this is) 19:01:14 it requires libssl0.9.6 which is apparently different from libssl096 and conflickts with openssl0.9.6 19:10:55 I think I will wait until I am not accessing this machine via SSH to fool with the openssl libraries 19:26:52 vinod (vinod@d242.dial-5.cmb.ma.ultra.net) has joined #openacs 19:30:30 hi vinod 19:33:07 hey dave! 19:33:19 what's new? 19:36:00 i downloaded 284 mb of debian testing and I still can't install postgresql 7.1.2 but everything else is good. 19:37:22 ouch - it would take me 2 years to download 284 mb at my bandwith :) 19:37:25 also it changed my editor in mutt 19:37:44 it took about 2 hours. 19:37:52 showoff! 19:38:18 I am getting totally ripped off for that service too. THere is only 1 DSL provider where I am now. 19:38:29 editor in mutt is set in .muttrc: set editor="emacsclient" 19:38:50 who is your DSL provide? 19:38:51 But I am paying for 384k and they don't have anything to throttle it so I get 768 (shhhh) 19:39:15 logical.net - who resells someone elses service. Not covad. 19:39:27 i'll be quiet - but loggy see's all :-) 19:39:50 why won't pg install? 19:40:22 It is only in non-us and it uses a different libssl and gets confused. I guess I will just compile it the old fashioned way 19:43:15 ahhh - you're a core-hacker now - just compile it :) 19:43:25 it takes a while, tho 19:47:23 so... have any of you ever gotten marriage proposals through your website? 19:47:30 :-) 19:47:37 not yet! 19:47:51 just you wait aaron - got my first one today :) 19:48:11 it starts: Hallo Mister Vinod Doctor, 19:48:21 and it goes downhill from there 19:55:12 I just wanted to stay 100% debian. 19:56:03 yeah - i know - debian's pg was just too out of date when i started with openacs 19:56:09 and i've just never gone back 19:57:34 <^lilo> [ServerNotice] Hi all. We're going to rehub you. Please bear with us for a moment or two. 19:57:40 does anyone remember an aD api-browser that automatically syntax-colored sql files? 19:58:04 GEM has quit (niven.openprojects.net farmer.openprojects.net) 19:58:04 ola has quit (niven.openprojects.net farmer.openprojects.net) 19:58:04 derfy has quit (niven.openprojects.net farmer.openprojects.net) 19:58:04 rbm has quit (niven.openprojects.net farmer.openprojects.net) 19:58:04 vinod has quit (niven.openprojects.net farmer.openprojects.net) 19:58:04 tdxdave has quit (niven.openprojects.net farmer.openprojects.net) 19:58:04 wikimadness has quit (niven.openprojects.net farmer.openprojects.net) 19:58:04 AaronSw has quit (niven.openprojects.net farmer.openprojects.net) 19:58:04 shagster has quit (niven.openprojects.net farmer.openprojects.net) 19:59:11 loggy (openacs-lo@v123-1.ARSDigita.seg.NET) has joined #openacs 19:59:11 topic is: Welcome OpenACS Developers - http://openacs.org/ 19:59:11 Users on #openacs: loggy vinod rbm shagster derfy @AaronSw tdxdave wikimadness GEM 19:59:12 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ 20:11:14 derfy has quit (Leaving) 20:13:06 vinod: thats not what comes with OpenACS 4 huh? 20:14:23 openacs4's displays the sql, but just in plain black on white 20:14:43 must've been acs 3 then 20:14:48 i seem to remember seeing one that colored the keywords, but i can't remember if it was 3.x or 4.x 20:14:58 yeah, i remember it too. 20:15:02 that's pretty nifty if it works. 20:16:16 i wanted to print out a couple datamodels and i just got this nifty color printer, so... :) 20:17:41 if you print that data model it will change. its a rule. 20:17:50 aha, her it is 20:17:53 err here it is: http://cvs.arsdigita.com/cgi-bin/cvsweb.pl/acs3x/www/doc/sql/display-sql.tcl?rev=3.6&content-type=text/x-cvsweb-markup 20:17:56 actually, i want to change it 20:18:06 awesome! thanks aaron 20:18:12 no problem 20:18:56 i've been trying to help jon merge acs-notifications into acs-mail but trying to understand acs-mail while switching emacs buffers is killin me 20:19:13 I can imagine. 20:19:20 You just need a bigger monitor. 20:19:26 or two. ;-) 20:19:43 dual monitors rock! 20:20:09 hey, i just got a color printer - one step at a time :) 20:20:35 dual monitors??? the laptop is heavy enough as it is 20:21:04 * tdxdave is looking up how to setup two monitors with linux 20:21:57 My big monitor and small laptop can be faintly seen in http://swartzfam.com/aaron/doorknob.jpg 20:22:26 thats cool 20:22:52 downloading... 20:23:05 almost there... 20:23:21 almost there... 20:23:25 :-) 20:23:25 * tdxdave is wrestling the 15 inch sony trinitron from his wife to setup dual monitors... 20:23:36 aaronsw: cool! 20:23:59 it took me forever to get that photo to come out. 20:24:09 with the new camera? 20:24:14 yep. 20:24:24 people look at you a bit strange when you keep staring at your doorknob 20:24:30 lol 20:25:28 The real-life doorknob has much higher resolution, though. 20:29:00 * tdxdave is shopping for a matrox g450 dual 20:29:54 " a feature-rich, future-proof business accelerator " 20:30:04 * AaronSw wonderes what a business accelerator does 20:30:32 you lose money twice as fast... 20:30:52 dual head 450 with 16mb ram is $77 20:30:58 Quite popular with dot-com's I'd bet. 20:31:28 gilbertw (gilwong@atlrel1.hp.com) has joined #openacs 20:31:48 dot-com special accelerator works at 10x 20:34:05 according to the postgresql packager, it will stay in non-us due to the need for libssl which is not available in the us? 20:36:48 howcome I can compile it, weird. (postgresql) 20:37:21 i think it has to with libssl not being freely available from a us server. 20:37:57 if it's on a us server, the us gov't places restrictions on who can download it 20:38:14 if it's on a foreign server, it's not subject to those regulations 20:38:19 (i think) 20:39:37 ok, its probably a debian thing. 20:40:18 yeah - you're american, so you can download it. but others wouldn't be able to if it was on us servers 20:40:29 so they put it on non-us.debian.org and anyone can download it 20:40:46 OK, but it is conflicting with my Openssl installation. 20:41:15 So it is our (us) fault because we restrict the "export" of encryption technology. 20:41:38 i think that's it - of course, i'm no expert 20:42:29 Sounds right. I'll have to clear up the openssl problem at home. 20:49:19 going home to pack 20:49:24 tdxdave has quit () 20:50:57 steveW (steve@host213-122-2-90.btinternet.com) has joined #openacs 21:01:08 Does anyone know offhand how OpenACS implements bind variables? 21:01:31 It's done with TCL trickery I think 21:01:36 Hang on 21:04:40 Nope, it's done in the driver... There's TCL bind var stuff for db_exec_plpgsql 21:05:42 Cool, thanks a lot. 21:06:23 Do you know what file that's in? 21:09:14 Which one? The driver's postgres.c, the TCL is in packages/acs-tcl/tcl/00-database-procs-postgresql.tcl 21:09:26 Ahh, right -- thanks. 21:09:38 * AaronSw is getting a bit rusty already! 21:11:04 proc db_bind_var_substitution 21:20:05 As far as I can remember it subs things like :object_id in the sql with '$object_id' and PG does the type conversion 21:44:46 tdxdave (tdxdave@ip-204-97-175-41.dsl.logical.net) has joined #OpenACS 21:47:44 vinod has quit (Ping timeout for vinod[d242.dial-5.cmb.ma.ultra.net]) 21:55:54 cool postgresql 7.1.2 install is working, but now I have to resinstall ssh 22:03:29 vinod (vinod@d69.dial-5.cmb.ma.ultra.net) has joined #openacs 22:04:01 * rbm is moving. 22:04:04 moving sucks 22:04:19 argh. libssl that works with postgresql 7.1.2 does not work with ssh 22:04:39 rbm: tdxdave is moving to new house. house is cool, moving still sucks. 22:05:01 * vinod just moved to new apt 22:05:05 moving sucks 22:05:43 debian is cool it upgrades postgresql to 7.1.2 while openacs-4 was running 22:06:50 I'm just moving to another apartment. Rent will be free, so that's cool. It's just half a block away. Still on campus. But the other apt is much nicer :-) 22:07:05 tdxdave: Thank the debian PG maintainer :) 22:07:54 vinod: here's what Don said in regards to your page: 22:07:57 "This is FAN-BLEEPING-TASTIC! Vinod's a stud. Yes, I'd love to see 22:08:02 it linked to the index page." 22:08:08 heheh 22:08:44 vinod has quit (Ping timeout for vinod[d69.dial-5.cmb.ma.ultra.net]) 22:08:50 * tdxdave is downloading ssh from non-us to see if that works 22:09:49 cool that worked. 22:10:20 rbm: I downloaded 285mb of testing today. very fun :) 22:10:42 hehe 22:10:44 I still can't make apt-get get stuff from non-us though. I had to download them and run dpkg. 22:11:03 tdxdave: should've gone all the way to unstable. Then you could get Emacs 21, which kicks serious butt 22:11:18 tdxdave: eh? why? 22:12:53 ben is my hero. 22:13:02 Any particular reason? 22:13:10 He's just brilliant. Same for Don and Dan. 22:13:28 yes. it just takes time to get all that stuff in your brain. 22:13:31 _and_ he's a nice guy. 22:15:57 They are all very helpful. I asked Dan about that ecommerce stuff and he ported that view with the outer joins. It was amazing. 22:18:44 Dan is the man. He rocks. 22:20:24 ok who wants to subsidize the new video card so I can run dual monitors. I guarantee it will double my porting speed :) 22:20:29 truck is here. off to carry boxes. 22:20:32 yes. Dan, Ben and Don are way too smart. 22:20:35 tdxdave: Get one for me too. 22:20:43 bbl 22:21:20 tdxdave: ever try the matrox dual head gfx cards? Good stuff. 22:23:10 steveW has quit (Client Exiting) 22:46:28 gilbertw has quit () 23:08:56 markd2 (markd@r-41.76.alltel.net) has joined #openacs