00:44:48 adler (~adler@reva.sixgirls.org) has joined #openacs 00:44:55 cheers 00:56:21 til has quit (Ping timeout: 183 seconds) 01:02:21 adler has quit ("BitchX: now Y2K compatible!") 01:12:46 davb (dave@alb-24-58-160-135.nycap.rr.com) has joined #openacs 01:31:59 markd2 (~Snak@166.102.30.120) has joined #openacs 01:38:46 * markd2 hides beind a fern 01:42:46 Hi markd2 01:43:01 http://www.leglamps.com 01:43:02 B: http://www.leglamps.com from davb 01:43:10 B:|www.leglamps.com 01:43:10 titled item B 01:43:31 B: if you can't figure out what it is from the URL, you don't need to know 01:43:31 commented item B 01:47:07 heh. Fra-Geee-lay 01:47:18 I like the mailbox 01:48:02 I also like the list of keywords at the bottom 01:48:08 foot fetish, leg fetish, mailboxes 01:48:27 that is ...... "curious" 01:48:41 I guess they would find what they were looking for though 01:49:50 at least it didn'th ave things like "amputee midget women" or something 01:52:09 http://www.davessurplus.com/leg_lamp.htm 01:52:09 * markd2 runs memtest-86 on his home linux box 01:52:09 C: http://www.davessurplus.com/leg_lamp.htm from davb 01:52:12 it's been randomly locking up 01:52:17 fun! 01:52:22 * markd2 detects a pattern in davb's links 01:52:32 C:| Build your Own Leg Lamp 01:52:33 titled item C 01:52:37 thats it. 01:52:56 My machine locks up in Windows, but Linux is super stable. 01:55:02 it's also running one processor short (since the cpu fan went out on one of the processors 01:55:09 ouch. 02:03:36 oy. http://entertainment.news.com.au/common/story_page/0,4459,3383815%5E10431%5E%5Enbv,00.html 02:05:34 that is too much... 02:06:59 time to defrag the disk, back in 3 days 02:07:04 davb has quit () 02:07:05 heh 02:35:34 markd2 has quit ("Bork") 09:07:24 chump has quit (zahn.openprojects.net irc.openprojects.net) 09:07:27 Psychephylax has quit (zahn.openprojects.net irc.openprojects.net) 09:09:47 chump (~chump@alb-24-58-160-41.nycap.rr.com) has joined #openacs 09:09:48 Psychephylax (proxy@ool-18baa98f.dyn.optonline.net) has joined #openacs 09:35:25 Psychephylax has quit (zahn.openprojects.net irc.openprojects.net) 09:35:26 chump has quit (zahn.openprojects.net irc.openprojects.net) 09:36:16 chump (~chump@alb-24-58-160-41.nycap.rr.com) has joined #openacs 09:36:16 Psychephylax (proxy@ool-18baa98f.dyn.optonline.net) has joined #openacs 10:01:44 til (tils@port-212-202-128-205.reverse.qsc.de) has joined #openacs 10:56:17 til has quit (Remote closed the connection) 11:11:08 Psychephylax has quit (zahn.openprojects.net irc.openprojects.net) 11:11:08 chump has quit (zahn.openprojects.net irc.openprojects.net) 11:11:18 chump (~chump@alb-24-58-160-41.nycap.rr.com) has joined #openacs 11:11:18 Psychephylax (proxy@ool-18baa98f.dyn.optonline.net) has joined #openacs 12:46:41 ola (~ola@as3-1-3.mal.s.bonet.se) has joined #openacs 13:45:48 davb (~dave@208.136.23.203) has joined #openacs 13:56:05 Good morning Dave. 13:56:10 Hello. 13:56:49 I just fixed my car before the yearly inspection... 13:59:08 thats good. 13:59:18 ouch. I got all greasy:-) 13:59:37 heh. 14:00:00 Did you injure yourself? I have a history of sustaining some sort of injury every time I fix something. 14:00:02 :) 14:03:16 I didn't get a chance to look at static-pages last night, I had to run scandisk on my windows partition. 14:04:16 as a matter of fact, I did not get injured. I'm quite amazed because I too usually get a trophee or two;-) 14:04:38 np. take your time. 14:14:05 cool. I set sort_mem to 6000 and shared_buffers to 400 in postgresql.conf and did a vacuum analyze. reloading /admin/site-map now takes less than half the time it used to take. 14:14:18 cool. 14:14:29 I think we need a doc on how to tune postgresql. 14:14:50 dunno which operation had effect though. (doh!) 14:15:09 for sure! 14:15:12 heh 14:15:22 only change one thing at a time :) 14:16:07 do you know what the defaults are for those? 14:18:43 shared-_buffers 128 in debian is the default 14:19:00 sort_mem defaults to 512k 14:21:36 shared_buffers is 2*max_connections, witch is 32 by default in the 7.1.3 source version, so 64kB. I can't remember what sort_mem was:-)...probably less than 100 14:25:51 I am vacuuming my live databases. I don't think I ever did it before. 14:26:08 Don recomended something like 2000 for both about two years ago, for a dev system and probably much more for a real site. 14:26:44 you should do it every night;-) 14:27:04 I don't do it either... 14:27:24 2000 for sort_mem is 2 gigs (its in kilobytes) :) 14:27:53 no kidding? 14:27:54 hardly anything ever gets inserted in those dbs anyway. 14:27:57 ola: yes. 14:28:25 oh yeah, that would be 6 gigs with your settings... 14:28:50 the shared_buffers are 8192 bytes each. 14:30:10 ok. maybe I should read some kind of giude.. 14:30:19 I only have 512 MB 14:31:51 on debian I read /usr/share/doc/postgresql/README.postgresql.conf I had to un-gzip it. 14:32:23 wait 2000 is 2 megs, not 2 gigs, my math sucks. 14:32:25 :) 14:40:39 oh. my shared_buffers are 4000. not 400. (4000x16k=64MB). sort_mem is 6000 (6000x1k=6MB per backend) :-) 14:41:12 is a "backend" a database or a postmaster? 14:41:16 postmaster 14:41:22 aha. 14:41:31 are the shared_buffers shared across the postmasters? 14:41:57 I'm not sure... 14:42:35 davb has changed the topic to: Welcome to the fiddling with Postgresql.conf channel http://openacs.org 14:43:51 hehehe 14:44:02 if I am running nsvhr can I leave the address blank in the slave AOLservers? With a dynamic IP I don;t want to have to restart the servers if the IP address changes. 14:44:45 uhoh, my OpenACS is broken :( 14:44:52 I can't test the site map speed. time to CVS update 14:46:09 I have set my slave addresses to 127.0.0.1 and that works well. 14:46:15 looks like I have to reinstall the db. 14:46:19 cool 14:46:33 reinstall? 14:46:45 127.0.0.1 cool :) 14:46:54 :-) 14:48:52 is psyche in a different time zone from you or is he just a sleepy bastard? :-) 14:49:50 sleepy. 14:55:11 davb, are you using a local cvs for your sites? 14:55:11 its on my list of things to do :) 14:55:54 When I convert to OpenACS 4 that is my plan to develop in CVS on one machine and then send it over to the production server. 14:55:57 it's a drag when a new version of ACS comes out and you have to merge with your personal changes... 14:56:10 Yes. That is the tricky part. You need to use the vendor tags etc... 14:56:33 I think you should do another import 14:56:40 Basically you want to wait for a release from OpenACS, then start with that. 14:56:46 and then merge somehow 14:57:19 well, I wanna start to work on my sites sometime :-) 14:57:27 What I was doing is check out the OpenACS code into a directory. Then import that into my personal repository. 14:57:36 with a vendor tag liek OpenACS-thedate 14:57:56 then you cvs update the checkout directory and merge it into your personal repository. 14:58:19 you check out the code from the peronsal repository onto the production server after testing. 14:58:35 or something like that. That is the gist that I got from Ron Hendersons guide. 14:59:02 Or that is the simplified version when you only have 1 developer. WHen you have a whole bunch its more complicated. 14:59:54 my install keeps stalling at the Package installation. I think th eCVS is still broken. 15:01:18 I actually us cvs myself but I have never tried to merge with a new ACS release yet... I use one reository per site and co TWO working copies, dev and prod (not staging). 15:01:25 s/us/use 15:01:55 right. 15:02:12 ok. I should be doing it like you. 15:02:50 if you merge the OpenACS.org code with your repository with a vendor tag, you can go back to a previous release when the new code breaks your system. 15:03:15 that is why you need to use the tags so when you have a working copy you tag it so you can get back if you need to :) 15:04:03 this is great. I learn more just rambling on into this IRC channel then I do just thinking about it. 15:04:07 just ignore me :) 15:05:31 so if I co code from openacs.org to a separate directory like you say, how do I merge? do I import the cvs-updated dir and THEN merge or what? 15:05:57 cool dave, I feel in the same way! 15:07:59 its probably in Ron's doc if I read it again for the n:th time;-) 15:08:59 that is where i got it from. I think you do an import with a vendor release tag. 15:09:04 Have you read the CVS book also? 15:09:16 what book? 15:09:30 guess not. 15:09:37 http://cvsbook.red-bean.com/ 15:09:43 A: http://cvsbook.red-bean.com/ from davb 15:09:48 A:| The CVS Book 15:09:49 titled item A 15:09:56 A: the free chapters 15:09:57 commented item A 15:10:53 thanks, dave! in DocBook, what else;-) 15:12:15 np 15:13:35 hmmm.. I have this firewall but I still can't relax and stop thinking about security. 15:14:04 Sean Y and Jon G gave some cool tips in a recent thread. 15:15:24 like not ever using the root account and stuff like that... 15:16:00 those are good tips. 15:16:27 that is why I am leaning towards hosting with someone else. 15:16:36 of course THEY have to be good at security. 15:16:41 heh 15:16:57 but its worth it to pay someone else. 15:17:04 at least you have someone to yell at:-) 15:17:17 right 15:23:45 noone ever responded to my TclDAV email :( unless it was lost in the internet when my IP address changed... 15:24:37 what's TclDAV and where did you send it? 15:26:38 dave: I have never installed oracle. how long would it take me to install it on RH7.2, do you think? 15:28:28 a couple of hours... I am not sure if you need to install the compatibility libraries but I think you do. 15:29:16 TclDAV was an alleged implementation of WebDAV in Tcl. But the web site is not where the links all point to. I sent am email to the alleged creator. 15:29:22 oh, it's that quick. 15:29:37 Not too bad as long as you have plenty of RAM. 15:29:44 and a fairly speed hard drive. 15:29:47 ok 15:29:54 If it works of course. 15:29:59 heh 15:30:12 I usually got 90% done then it would fail on linking something and I would have to start all over. 15:31:25 check this out: http://www.learninglinux.com/article.php?sid=44 15:32:01 its RedHat 7.1/Oracle 8.1.7 install guide. looks very good. 15:32:35 hmmm where is chump, he's very slow today. 15:32:41 * davb pokes chump 15:35:05 chump has quit (Remote closed the connection) 15:35:08 chump (~chump@alb-24-58-160-41.nycap.rr.com) has joined #openacs 15:35:14 * davb pokes chump with daemontools 15:35:18 http://www.learninglinux.com/article.php?sid=44 15:35:18 B: http://www.learninglinux.com/article.php?sid=44 from davb 15:35:27 B:|Installing Oracle 8.1.7 on RedHat 7.1 15:35:28 titled item B 15:39:49 cool. I actually installed Oracle 8.1.5 once on Windows from a cd-rom i got with an Oracle book I bought when I was on vacation in Sri Lanka. 15:42:18 davb: are you running qmail with daemontools? 15:42:28 no. 15:42:51 I never saw a doc for it. They all just say put it in init.d 15:43:07 strange. 15:43:09 its never crashed. 15:44:02 it used ucspi-tcp and tcpserver though... 15:44:08 I'm going to try it with daemontools and see if it works 15:44:18 ok 15:46:11 http://smarden.org/pape/Debian/qmail/qmail-run.html 15:46:12 C: http://smarden.org/pape/Debian/qmail/qmail-run.html from davb 15:46:23 C:|qmail-run debian package for qmail with daemontools 15:46:24 titled item C 15:47:38 aha! so it CAN be done. cool. 15:47:50 and from the man himself: 15:47:51 http://cr.yp.to/qmail/faq/admin.html#supervise 15:47:52 D: http://cr.yp.to/qmail/faq/admin.html#supervise from davb 15:48:02 D:|Qmail with daemontools from DJB 15:48:02 titled item D 15:48:46 D: akong with alot of other great qmail info 15:48:47 commented item D 16:09:33 davb has quit (Ping timeout: 181 seconds) 16:48:48 davb (~dave@208.136.23.203) has joined #openacs 16:49:06 here is the error: 16:49:07 [11/Dec/2001:12:10:52][955.5125][-conn1-] Error: Error sourcing /web/openacs-4/\ 16:49:07 packages/acs-bootstrap-installer/installer/packages-install.tcl: 16:49:07 psql:acs-install.sql:247: ERROR: apm_packages_package_key_fk referential integ\ 16:49:07 rity violation - key referenced from apm_packages not found in apm_package_type\ 16:49:07 s 16:49:08 psql:acs-install.sql:254: ERROR: ExecAppend: Fail to add null value in not nul\ 16:49:10 l attribute object_id 16:49:23 I think I'll wait into later, then post on the bboard if its not fixed. 17:08:57 pat (~pat@dsl081-210-063.nyc2.dsl.speakeasy.net) has joined #openacs 17:11:37 hi guys. I'm following Vinod's brief guide to installing Openacs4, but for a fresh install, not an update. 17:12:11 so there are a bunch of differences, which i'm trying to document and put back into the docs. 17:12:50 ok. 17:12:52 cool. 17:12:54 rightnow, I'm trying to createlang, but I keep getting command not found. I have LD_LIBRARY_PATH set 17:13:14 to /usr/local/pgsql/lib, which is where plpgsql.so is, but no luck 17:13:19 its in the postgresql binary directory. 17:13:21 I'm doing it as root. ANy ideas 17:13:25 where is postgresql installed? 17:13:38 try running it as the postgres user. 17:13:53 well, I'm not entirely sure, but I think /usr/local/pgsql. 17:13:56 on debian its in /usr/lib/postgresql/bin 17:14:04 try usr/local/pgsql/bin 17:14:29 if I cd to usr/local/pgsql/bin, it still doesn't work as root 17:14:41 the postgres user should have the pgsql/bin in its path. 17:14:51 ./createlang? 17:15:13 if its not in PATH that should work if its the right directory. 17:15:30 good catch dave, that's it. I'm still a linux newbie and I forget that all the time. thanks 17:15:50 no problem. I think its easiest to be the postgres user when you set that up. 17:16:08 One thing I want to clear up in the docs is how these different users should be set up, namely nsadmin and postgres 17:16:13 how did you install postgresql? source or some sort of package. 17:16:36 source, following vinod and the basic postgres install docs. I'm on debian woody 17:16:51 Ok. 17:16:54 for instance, why should nsadmin own the /web directory? 17:17:10 AOLserver runs as nsadmin. 17:17:15 I could use rules of thumb for when I should be which user 17:17:29 I am not sure it necessarily needs to own it, but it needs to be able to read and write to it. 17:17:43 nsadmin almost 100% of the time. 17:17:52 do you do a lot of dev work logged in as nsadmin? 17:18:49 this plpgsql wasn't in the original doc, it was a comment. Why is it so important? Other than openacs won't run without it 17:19:16 Usually its installed I think. 17:19:29 so you shouldn't have to create it seperately. 17:19:51 I always develop as nsadmin. 17:19:52 ok, so I was just being redundant in createlang'ing again? 17:20:09 thanks, good to know. 17:20:11 I think it would give a message if it was already created. 17:20:20 oh 17:20:23 Did you createlang on template1 or the openacs db? 17:20:28 openacs 17:20:39 if you do it on template1 it will be created on all databases. 17:20:46 that way you don't have to remember. 17:20:53 sounds like a good idea 17:21:27 thanks for the help. I noticed philg posting the other day about how it's the little things that trip learners up. 17:21:40 he's so right. 17:21:53 yes. If you look at the bboard statistics I have hundreds of posts asking these type of questions :) 17:22:12 I'll send my notes back to Vinod and Roberto, and maybe have a second document for starting from scratch 17:22:18 great! 17:22:23 asssuming I'm ultimately successful! 17:22:45 Good luck. We will try to help if you have any more questions. 17:22:54 thanks again 17:23:12 no problem. 17:26:19 pat: do createlang -l dbname to see what languages are in that db 17:26:26 ie. createlang -l template1 17:51:32 thanks dave. I still have to go to the /usr/local/pgsql/bin dir to make this happen. I set LD_LIBRARY_PATH correctly, 17:51:56 I think. Which PATH should I modify? /etc/profile? or something specific to the nsadminuser 17:52:21 but when I run your command, i get plpgsql correctly installed on both template1 and openacs 17:54:18 pat: try to set PGDATA to /usr/local/pgsql/bin in /etc/profile ... 17:55:57 not PGDATA 17:55:58 ack 17:56:12 that is the location of the database. 17:56:21 I set PATH in .bash_profile 17:57:01 sorry I'm tired:-( 17:58:45 :) 17:58:47 no problem. 17:59:03 I am not sure nsadmin is allowed to run createlang etc... 18:01:28 pat: sorry if I am giving you too much information :) 18:29:11 that's never going to be a problem, dave. i really appreciate all the help I can get 18:48:48 ola has quit ("changing universes") 19:09:27 talli (~talli@xcdfddb76.ip.ggn.net) has joined #openacs 19:09:33 hey guys 19:09:42 who is this pat fellow? 19:10:13 davb, have you seen rbm around these parts lately? 19:12:06 nope. 19:12:20 when was the last time you saw him? 19:12:22 pat is working on some potential new docs. 19:12:30 A week or more ago. 19:13:22 pat is? do you believe him? 19:13:44 He is attempting to udpate vinod Brief install guide. 19:13:49 Its a start. 19:13:55 don't trust that dude! 19:13:58 ok. 19:14:19 :) 19:14:22 (btw, pat is my partner at musea. i'm allowed to spread gossip about him) 19:14:29 Cool. 19:14:44 I suspected as much. 19:14:51 Did you ever get a roadmap for the docs? 19:14:59 I haven't seen vinod recently either. 19:19:48 Ok. 19:46:16 * talli is away (Auto-away on idle) after 30min idle [msglog:on] 19:53:39 talli has quit () 19:57:32 markd2 (~markd2@r-41.127.alltel.net) has joined #openacs 19:57:47 * markd2 fiddles with tradition 20:04:25 hi markd2 20:04:42 davb has changed the topic to: OpenACS Helpline http://openacs.org 20:16:56 Empolyer Type code in out new database for a Village: EVIL 20:18:34 employer that is :) 20:18:52 heh 20:19:01 that for the MS and AOLs of the world? 20:20:28 we deal with public employers so no, but it is still amusing. 20:47:43 wow. 20:47:44 http://stacks.msnbc.com/local/AZREP/M124729.asp 20:47:44 E: http://stacks.msnbc.com/local/AZREP/M124729.asp from markd2 20:47:58 hmmm.. and psychephylax hasn't been too active today 20:48:02 there must be a connection! 20:50:58 spooky 21:01:47 http://crazyapplerumor.blogspot.com/ 21:01:47 F: http://crazyapplerumor.blogspot.com/ from davb 21:01:56 F:|Crazy Apple Rumors Site 21:01:56 titled item F 21:02:08 F:"Crazy Apple Rumors Site is dedicated to the fabrication of Apple rumors that defy verifiability, grammatical convention or any basis in reality. " 21:02:09 commented item F 21:06:05 http://crazyapplerumor.blogspot.com/2001_12_09_crazyapplerumor_archive.html#7817638 21:06:06 G: http://crazyapplerumor.blogspot.com/2001_12_09_crazyapplerumor_archive.html#7817638 from davb 21:06:13 G:|Jobs, Beard Part Ways 21:06:14 titled item G 21:28:33 bartt has quit (Ping timeout: 181 seconds) 21:39:01 davb has quit () 21:48:19 markd2 has quit ("Bork") 21:51:17 markd2 (~Snak@r-41.127.alltel.net) has joined #openacs 22:00:32 talli (~talli@xcdfddb76.ip.ggn.net) has joined #openacs 22:00:45 hey guys 22:00:51 was davb here anytime recently? 22:03:33 yes 22:03:42 he ducked out maybe 20 minutes ago? 22:04:42 ok, cool. did he say whether he would be back by any chance? 22:04:49 not that I saw 22:06:06 thanks 22:30:38 hi folks, I'm installing OpenACS with Vinod's Brief guide, but from scratch instead of an update 22:31:08 Vinod has put his briefs in a guide? 22:31:13 hopefully he washed them this time 22:31:30 I had to set up cvs on my debian woody box, but when I try to login I get an error 22:31:49 what kind of error? 22:31:51 cvslogin: failed to open /home/nsadmin/.cvspass for reading: no suc file or directory 22:32:00 I haven't done openacs4, but i've used the aD acs4 22:32:18 I created a cvs group and added nsadmin to it. my cvs repository is at /usr/local/cvs 22:32:34 thing is I've got no experience with cvs really. 22:33:13 does nsadmin have to be initalized somehow as a cvs user? 22:33:21 nope 22:33:27 what user are you running cvs as? 22:33:37 nsadmin 22:33:40 try root? 22:33:45 hope 22:33:46 er, nope :-) 22:33:54 try the cheesy thing of "touch /hom/ensadmin/.cvspass" 22:34:03 and see if the existence of the fill will make it happy 22:34:52 well, there is no file .cvspass. I don't know what it's supposed to do. 22:35:04 woo 22:35:16 I think it's were cvs looks for a password if there's not one supplied 22:35:18 Mark...you need to teach me everything you know about Relational Database theory 22:35:21 oh wow, that worked. what the heck is touch anyway? 22:35:30 talli you need to get me a job 22:35:38 I don't care if it's cheesy, that's magic 22:35:39 chump you keep track of all the links 22:35:42 touch 'officially' changes the modification date of a file to be "now" 22:35:46 and loggy, you log the channel 22:35:54 if the file doesn't exist, touch creates an empty one 22:35:57 heh 22:36:04 psychephylax wades in and kicks some robot butt 22:36:07 * talli is away (Auto-away on idle) after 30min idle [msglog:on] 22:36:16 pat : here's my cheesy writings on cvs : http://badgertronics.com/writings/cvs/ 22:36:31 Alternatively, touch can also be used to touch foreign objects and sometimes gets you sued for sexual harassement 22:36:43 So be careful where you point that `finger` 22:36:44 only after you 'unzip' first 22:36:58 heh 22:37:06 thanks mark. Dave was a big help earlier. I'm tryig to fillin the gaps in vinods article as I stumble through this install 22:37:16 I'm more of a 'tar' and feather man myself 22:37:20 give vinod some feedback when you're done 22:37:24 He's an awesome guy 22:37:28 and won't flame you for suggestions 22:37:32 Vinod is sure is an awesome guy 22:37:53 one of the few (only?) folks here I've met in person 22:38:01 yup, I'm marking up his doc. his is aimed at an upgrade of openacs, and I'm using it to start from a fresh install 22:38:18 I've got a feeling most folks will be doing fresh installs 22:38:19 so I think it could be just an addendum or fork of his doc 22:38:30 or "fresh" installs if Psychephylax does them 22:38:34 right, but they probably won't have to deal with cvs 22:38:36 Spork? Someone mention a Spork? 22:38:55 is psyhephylax a robot? 22:39:01 yes 22:39:03 I'm a robot 22:39:13 impressive 22:39:17 They call me Dr. Roboto 22:39:34 domo origato 22:39:40 he's only a robot because he's still in college 22:39:43