00:35:01 loggy (~openacs-l@xcdfddb76.ip.ggn.net) has joined #openacs 00:35:01 topic is: Cross-stitch for web nerds. http://openacs.org 00:35:01 Users on #OpenACS: loggy AaronSw til davb talli beattiek hazmat Psychephylax chump 00:35:01 [#OpenACS] This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 00:35:06 Thanks!! 00:35:14 no prob 00:35:20 perhaps i should make a web interface for you guys ;-) 00:35:27 even better: perhaps you should ;-) 00:35:33 no really I should figure it out one of these days. 00:35:59 I swear it hates me. I have spent a few hours dorking around with it. it just never starts up without any error message. 00:36:12 Heh heh. 00:36:21 it's ok-- it's not exactly hard to kill the process 00:37:11 do you mind sharing your command line :)? 00:37:29 for what? 00:37:39 (sorry, got disconnected) 00:37:54 logger. 00:38:13 perl -w /usr/local/stuff/logger/logger -html -nick logster irc://irc.openprojects.net/swhack Swhack /web/blogspace/www/swhack/chatlogs/ http://blogspace.com/swhack/chatlogs/ 00:38:21 I must figure out this perl script !!!!! 00:38:22 :) 00:38:41 ok. I should be able to make it work with that... 00:38:51 I never used perl -w before... 00:40:06 davb, i'm at packages install and it is taking forever, any idea why? 00:40:18 it does take forever :) 00:40:35 okay good 00:41:28 yeah! an error message!! 00:41:52 Acs-kernel not installed. 00:41:59 that is bad right? 00:42:17 yeah. hmmm any more info? you might have to explore the server error log to get the real reason. 00:42:28 okay 00:42:39 so how is all in openacs land? 00:42:49 going slow 00:42:56 there is always a problem. 00:43:13 The project is moving forward, but the holidays are slowing down the last bits of the release especially the documentation. 00:43:25 hmm 00:43:31 to be expected 00:43:41 yes. 00:43:41 i came in here a while back and it seemed awfully quiet... 00:43:51 well vinod went on vacation on us... 00:44:22 how can I tell if my firewall (ipchains) is blocking port 6667? 00:44:41 actually it can't be... duh chump is on it... 00:44:56 but they both should be able to run right? 00:45:00 or am I dumb? 00:45:02 dav, where is the server log? 00:45:08 yeah, they should both run 00:45:17 beattiek try /usr/lib/aolserver/log 00:45:22 nope.. 00:45:29 that what i hoped 00:45:35 try /var/log/something 00:45:48 that is where it actually belongs anyway :) 00:46:23 any special user have to run logger? 00:46:52 I guess not... 00:47:01 does this look like it? 00:47:11 <---spam eminent---> 00:47:13 [11/Dec/2001:17:05:35][27397.1024][-main-] Error: conf: access(/var/www/homecity/www/errorpage.adp, R_OK) failed: No such file or directory 00:47:13 [11/Dec/2001:17:05:35][27397.1024][-main-] Error: conf: [ns/server/homecity/adp]errorpage reset to NULL 00:47:13 [11/Dec/2001:17:05:35][27397.1024][-main-] Error: conf: access(/var/www/homecity/www/startpage.inc, R_OK) failed: No such file or directory 00:47:13 [11/Dec/2001:17:05:35][27397.1024][-main-] Error: conf: [ns/server/homecity/adp]startpage reset to NULL 00:47:21 beattiek thats it. 00:47:37 hmmm 00:47:44 btw all you have to do it look in the server config file to find out where it is putting it :) (sorry I just though it that) 00:47:53 but I don't know what that error means. 00:48:14 well it means i'm missing two files, right? 00:49:07 wait a sec 00:49:11 those are old errors 00:49:25 11 Dec not 17 Dec 00:50:45 i better be off, c'yas 00:50:46 AaronSw has left #openacs 00:53:05 brb 00:53:15 beattiek: what's your document root set to? 00:53:34 brb 00:53:38 davb has quit () 00:53:45 i'm not sure 00:54:04 /usr/share/doc i think... 00:55:59 there should be a line "ns_param pageroot" somewhere 00:56:37 in the config file 00:56:54 s_param pageroot $pageroot 00:56:57 that? 00:57:21 yeah ... ok, look further up, what is the variable $pageroot being set to? 00:58:04 (cool thing about this config file: you can just execute any tcl code you want, including simplifiyng your life or making it more complicated with variables) 00:58:10 /var/www/${server}/www 00:58:48 so /var/www/homecity/www computed. 01:01:02 and that exists, right? 01:02:24 yes 01:02:27 :P 01:02:50 ok, that would have been too easy ;-) 01:02:57 yeah 01:03:05 but as i mentioned, the files are not there. 01:03:09 some are 01:03:11 do you have a "ns_param startpage" in your config file? 01:03:32 comment that out 01:03:33 no... 01:04:27 i don't have it. 01:04:40 the error was from OACS congiuring modules 01:05:08 and it was not a current one 01:05:16 oh yes, sorry 01:05:22 np 01:05:34 so what's the current error then? 01:05:37 i still haven't located it 01:05:44 thats the current problem 01:06:08 i am running updatedb 01:06:34 you are looking for the error log? 01:06:49 yes 01:07:05 look for "ns_param serverlog" in the config file 01:07:34 that would be the problem 01:08:00 i have this: 01:08:01 ns_param nslog nslog.so 01:08:07 but not that. 01:08:22 nslog is only the access log, the server log is sth different 01:09:47 strange ... where is this config file from? well, just enter a meaningful file location and make sure that is writable for the aolserver process 01:09:50 so ns_param serverlog /var/log/aolserver.log 01:09:57 y 01:10:12 It is a ACS 3 config file 01:12:21 i meant ns_param serverlog /var/log/aolserver 01:13:05 in my config file it includes the filename: "ns_param ServerLog /var/log/aolserver/server.${servername}.log" 01:13:05 should this be under ns_section "ns/server/${server}/module/nslog" 01:13:25 no, here: "ns_section "ns/parameters"" 01:16:50 where did you get the config file from? 01:17:34 i think i took that one from the aolserver source distribution and modified it according to the instructions of the openacs doc 01:17:41 Error: Error sourcing /var/www/homecity/packages/acs-bootstrap-installer/installer/packages-install.tcl: 01:18:08 psql:acs-install.sql:247: ERROR: apm_packages_package_key_fk referential integrity violation - key referenced from apm_packages not found in 01:18:08 apm_package_types 01:18:08 psql:acs-install.sql:254: ERROR: ExecAppend: Fail to add null value in not null attribute object_id 01:20:14 i missed this: env: write error: Broken pipe 01:21:02 is this happening on a freshly created database? 01:22:10 not any more 01:22:17 i mean, it was fresh 01:22:33 then i ran the OACS config. 01:22:44 it had an error and then i did it again 01:22:55 this is the second error 01:24:56 with OACS config you mean pushing the "install" button or whatever it is called? if yes then you should better try to do dropdb and creatdb again 01:25:40 okay 01:25:53 and don't forget to do createlang 01:26:14 if you did not executed it on the template1 db before 01:26:23 ? 01:27:52 well i am installing the data model again 01:27:59 http://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0001YU&topic_id=12&topic=OpenACS%204%2e0%20Design 01:28:00 D: http://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0001YU&topic_id=12&topic=OpenACS%204%2e0%20Design from til 01:31:21 it seems to be doing better now 01:31:37 did you do createlang? 01:31:50 nope 01:32:44 it is working fine, should i do it? 01:33:25 well, at least some time ago it was essential 01:33:40 try how far you get 01:33:52 createlang: 'plpgsql' is already installed in database template1 01:33:58 page 3 or 4 01:34:00 perfect! 01:34:07 OpenACS Installation: Create Administrator 01:34:18 i'm so happy 01:34:34 :-) 01:34:35 one day it may actualy be a web site! 01:37:19 hmm 01:40:01 davb (dave@alb-24-58-160-135.nycap.rr.com) has joined #openacs 01:40:12 hey dave 01:41:05 hi. 01:41:47 i got it working 01:41:50 cool! 01:42:43 was it an error in the server config file? 01:42:54 soon i will be able to take over the world right? (yeah) 01:43:06 right! 01:43:06 that _is_ what the OACS does right? 01:43:11 okay good 01:43:13 talli has quit ("See ya!") 01:43:17 just checking 01:43:40 YOu need the evil module though... and it only runs on oracle :) 01:43:50 damn 01:43:56 thats too expensive 01:44:08 i will settle for the good module for now 01:44:22 damn PGSQL 01:44:24 :P 01:45:21 okay so i still need to install packages 01:58:36 argh is the internet broken or just me? 01:58:46 I can't get to alot of web sites.... 01:59:41 beattiek: how is package install going? 02:06:27 going back to the light side... 02:06:30 davb has quit () 02:09:24 gah 02:09:32 I don't use Unix and it breaks 02:09:34 That's a first 02:10:52 davb (~dave@alb-24-58-160-135.nycap.rr.com) has joined #OpenACS 02:12:04 hmmm dns is OK 02:12:56 ok... 02:15:22 this explains it: Every page made by our software was generated by a program written 02:15:22 in Rtml. We called these programs templates to make them less 02:15:22 frightening, but they were real programs. In fact, they were Lisp 02:15:22 programs. Rtml was a combination of macros and the built-in Lisp 02:15:22 operators. 02:15:38 a quote from the creator of ViaWeb which became Yahoo store. 02:16:34 Eventually we made it our goal 02:16:34 that no one should ever have to use Rtml. 02:16:43 so there is no documentation :( 02:19:39 davb: I havn't started yet, i'm celebrating 02:26:14 excellent. excuse my little rant re: Yahoo Store 02:47:30 til has quit ("Download Gaim [http://gaim.sourceforge.net/]") 02:49:11 talli (talli@lti-4.dialup.access.net) has joined #openacs 02:49:15 talli has quit (Remote closed the connection) 03:06:54 Psychephylax has quit (forward.openprojects.net irc.openprojects.net) 03:10:23 Psychephylax (proxy@ool-18baa98f.dyn.optonline.net) has joined #OpenACS 03:29:03 davb has quit (forward.openprojects.net irc.openprojects.net) 03:29:03 chump has quit (forward.openprojects.net irc.openprojects.net) 03:29:03 Psychephylax has quit (forward.openprojects.net irc.openprojects.net) 03:29:58 Psychephylax (proxy@ool-18baa98f.dyn.optonline.net) has joined #OpenACS 03:29:58 chump (~chump@alb-24-58-160-41.nycap.rr.com) has joined #OpenACS 03:29:58 davb (~dave@alb-24-58-160-135.nycap.rr.com) has joined #OpenACS 03:30:15 [#OpenACS] This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 03:30:18 davb has quit (forward.openprojects.net irc.openprojects.net) 03:30:18 chump has quit (forward.openprojects.net irc.openprojects.net) 03:34:11 davb (~dave@alb-24-58-160-135.nycap.rr.com) has joined #OpenACS 03:34:11 chump (~chump@alb-24-58-160-41.nycap.rr.com) has joined #OpenACS 03:45:12 now to record some CDs 03:45:55 Psychephylax: do you know if I can do CDROM -> CDR direct in linux? 04:09:41 nm 04:09:42 later 04:09:47 davb has quit ("I'm too lame to make a quit message") 05:09:26 chump has quit (Ping timeout: 180 seconds) 05:10:27 chump (~chump@alb-24-58-160-41.nycap.rr.com) has joined #openacs 05:11:39 hmm? 08:26:39 miguel (~miguel25@cancerbero.unileon.es) has joined #openacs 08:29:39 miguel has quit (Ping timeout: 180 seconds) 08:35:46 miguel (~miguel25@cancerbero.unileon.es) has joined #openacs 08:37:10 hi guys!! 08:40:10 miguel has quit (Ping timeout: 180 seconds) 09:08:56 miguel (~miguel25@cancerbero.unileon.es) has joined #openacs 09:10:14 hi guys!!! 09:28:47 miguel has quit (Ping timeout: 180 seconds) 09:32:59 miguel (~miguel25@cancerbero.unileon.es) has joined #openacs 09:36:01 hi guys! 12:16:02 miguel has quit (Ping timeout: 180 seconds) 12:18:54 [#OpenACS] This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 12:31:08 miguel (~miguel25@cancerbero.unileon.es) has joined #openacs 12:35:54 hi guys!!1 13:25:54 miguel has quit () 13:44:15 davb (~dave@208.136.23.203) has joined #openacs 13:56:31 chump has quit (Remote closed the connection) 13:57:17 chump (~chump@alb-24-58-160-41.nycap.rr.com) has joined #openacs 14:08:39 I wonder if only one logger can attend... 15:17:01 davb has quit () 15:29:16 davb (~dave@208.136.23.203) has joined #openacs 15:48:43 miguel (~miguel25@cancerbero.unileon.es) has joined #openacs 15:48:49 hi guys!!! 15:49:29 ola (~ola@as3-1-3.mal.s.bonet.se) has joined #openacs 15:49:42 hi. 15:50:31 hi ola and miguel 15:50:52 davb: I found a bug in static-pages-procs.tcl... 15:51:25 static_pages_regexp needs to escape two backslashes 15:51:59 yipee! 15:52:10 I gotta get you CVS access :) 15:52:15 what? :-) 15:52:22 cool 15:52:31 Its always good when you can fix something. 15:52:47 That is kinda weird, I never messed with those, that is a leftover from aD. 15:53:22 nope. a leftover from ME. :-( 15:53:33 heh 15:53:45 ok, send me a patch for now. 15:53:53 You have an account at Openacs.org for CVS right? 15:54:06 yes I do. 15:54:24 cool. I'll just ask Don to add you to /static-pages 15:55:49 thanks dave. in that case I can commit to cvs myself... 15:56:01 wohoo! 15:56:25 ok. i emailed donb. 15:56:43 oops. I hope he knows your username, I didn't send it :) 15:57:02 lemme know what he says, ok? 15:57:07 np. 15:57:17 he knows it:-) 15:58:37 cool. 16:02:53 You know what strikes me as amazing?? The visual basic editor can do all kinds of fancy stuff, guess what command you are typing etc... but it does not autoindent if, do , etc... 16:03:15 I mean come on, it has all these incredible features, but you have to tab/backspace to line up your code!! 16:03:46 he he he 16:03:59 what did you expect? 16:04:02 once you hit tab, it lines up all lines to that tabstop until you hit tab or backspace again. all the other timesaving features are wasted! 16:04:17 Well, I use emacs, so I exepcted it to work :) silly of me. 16:04:57 try visual c++, you will know something good ;) 16:05:03 (just been ironic ;) ) 16:05:09 lol 16:05:11 heh 16:05:42 I wonder if there is a Visual Basic for Access mode for emacs?? :) 16:07:10 you mean that you want to use emacs for using Access (the dbase) ? 16:07:44 sure why not :) I am sure it could be done. 16:07:52 Just to edit the VB code. 16:08:41 Actually I'd rather not use Access at all, but that is not my choice to make :( 16:08:42 how? i am getting lost, there is any open sourced VB? 16:09:13 woooohoooo 16:09:32 Hola ola! greetings dave :) 16:09:45 hey Psychephylax 16:09:49 miguel nope. 16:09:50 http://lists.debian.org/debian-jr/2001/debian-jr-200105/msg00019.html 16:09:51 A: http://lists.debian.org/debian-jr/2001/debian-jr-200105/msg00019.html from davb 16:10:06 A:|Mailing list post that mentions VB mode for emacs, but the link is broken :( 16:10:07 titled item A 16:11:00 ok didnt know. you mean just editing VB code with emacs and then port it to your windows box (or are u using emacs under windows?) 16:11:34 I have emacs for windows too :) 16:11:35 http://www.tardis.ed.ac.uk/~skx/win/NTEmacsFAQ/NTEmacs-split218.html 16:11:36 B: http://www.tardis.ed.ac.uk/~skx/win/NTEmacsFAQ/NTEmacs-split218.html from davb 16:11:39 ok 16:11:45 B:|Two links to VB mode for emacs!! :) 16:11:46 titled item B 16:12:14 he he he so u just got it!! 16:13:02 I have to go do the modem inventory now 16:13:07 that should take me a while 16:13:07 are you using Visual Basic? why dont you switch over C++ Builder? Its a lot better 16:13:48 Its inside Access. We don't actually own VB. 16:15:14 then you mean Access Basic? 16:15:41 Yeah, its Visual Basic for Applications/Access. 16:16:47 ok 16:16:56 davb has changed the topic to: Topic? What Topic? http://openacs.org 16:17:43 i have used c++ builder for a while and it is quite good, much better than Visual Basic. I have developed some Dbase applications to work with PostgreSQL and works fine 16:18:18 great! 16:18:24 there is a driver for Borland compilers (Delphi, Kylix - Delphi in linux, C++ Builder) to access 16:18:33 PostgreSQL 16:18:44 and it is very easy to use 16:19:04 its powerful as C++ and the use of APIs (which are in C) 16:19:28 and very easy for developing interfaces very fast 16:19:32 sorry for the off-topic 16:20:21 heh np, we are always off topic :) 16:20:33 he he he 16:21:00 i just wanted to give you some tips, maybe you never heard about c++ builder or that you could use it with PG 16:22:31 but some people say that the future will be .NET 16:22:47 i have to read these Xmas something about it, i dont want to get lost 16:24:13 thanks. If you program for windows, you will need to learn .NET 16:24:46 Of course, Python, Tcl, Perl, Ruby, etc... all run on Windows. 16:26:17 I would like to know much about programming with widgets and work with Kylix but if you want to make money in this world you need to know how to program applications in Windows (although you use linux as servers ;) ) 16:27:46 sorry i should have written (much more and not only much) sorry for my english ;) 16:28:03 np at all. 16:28:04 :) 16:29:00 over here people use windows a lot, at least customers, however universities embraced linux 16:29:13 (low budgets) 16:29:37 of course. We have to budget, but they are not interested in non-MS solutions. 16:29:43 s/to/no 16:31:52 who? your company? 16:32:08 I work for a small New York State goverment agency. 16:32:28 I do OpenACS on the side. 16:32:37 He works for the CIA 16:32:44 heh, not even close. 16:33:04 it's more like, if I told you, you would be bored to death. 16:33:21 Actually 16:34:17 not really 16:36:42 We enforce the Taylor law which is the law allowing public employees to unionize, and sets the rules for resolving disputes in bargaining relationships, representation of public employees etc... 16:37:11 ack 16:38:02 i am spanish, so i dont know very much about US laws 16:38:25 thats ok most americans don't know very much about US laws either :) 16:40:20 As I was saying 16:40:32 US laws let employees to unionize? after watching Hoffa i thought that unions in the US have not very much power ;) just kidding 16:40:36 Dave is the guy they send out when the local farmers need to count their sheep 16:40:43 Psychephylax: heh 16:40:45 lol 16:41:38 This is for civil servants. Until 1969 they were not allowed to unionize. Now they can, but it is illegal for them to go on strike, hence the mission of our agency to help resolve disputes. 16:42:23 You mean count the sheep 16:42:36 "Farmer Bob stole my sheep" 16:42:37 and if you are not a civil servant then you can go on strike? 16:42:43 Quick, send out Counter Dave 16:42:48 or unionize? 16:42:53 Basically. 16:43:24 over here, civil servants are the very first ones that go on strike ;) 16:43:38 and the unions are much stronger among them 16:43:41 aha. 16:43:54 http://www.devhood.com/tutorials/tutorial_details.aspx?tutorial_id=19 16:43:55 C: http://www.devhood.com/tutorials/tutorial_details.aspx?tutorial_id=19 from Psychephylax 16:44:01 C:| they stole ACS 16:44:02 titled item C 16:44:07 C: Damn theives 16:44:08 commented item C 16:44:16 in fact, my mother is a teacher (public one) and she is working for a while for a teacher union 16:44:44 Yes we have alot of teachers! 16:45:20 anyway we have a conservative prime minister which means that you can cry out as much as you want but nobody cares in the gov 16:45:47 there is really a big fuss over here in the university, they want to change the law 16:46:38 It is a very big issue. 16:46:55 talli (talli@lti-4.dialup.access.net) has joined #openacs 16:46:59 well, actually they changed without asking the responsibles, teachers and students, never see a teachers agreeing with students for going on a strike, but now... 16:47:04 hey guys 16:47:05 hi talli 16:47:10 C: Hey! He gives credit to the original Psets in the Copyright/Credit section 16:47:10 commented item C 16:47:20 hi talli 16:47:20 have you heard anything out there about that? 16:47:40 that's funny though 16:47:47 Psychephylax: yes 16:48:04 Psychephylax: we need Psets for OpenACS/PG hackers now. 16:48:12 heh 16:48:15 phew, good thing RBM didn't hear me say that. 16:48:15 * Psychephylax wanders off 16:49:12 davb: i am just starting off, but i am finishing off the pset 1 using OACS/PG 16:49:29 writting down the problems I had so far with the differences between PG and Oracle 16:49:37 and because i was using OACS 16:49:37 Excellent. 16:50:04 actually i am working now on the mini-project of pset 1 16:50:46 it took me 8 days to finish off pset1, because the differences that made me to look around in some books (of PG for instance) 16:51:32 my responsible thinks that it is too much 16:51:35 time 16:51:36 a great learning opportunity! :) 16:52:05 That is not too much time to learn a new system, database and finish the problem set I think. 16:52:13 Have you programmed Tcl before? 16:52:16 i knew a bit of linux, postgresql 16:52:19 no, just php 16:52:24 i had to learn first 16:52:49 also it took me two weeks to set up the whole system, thanks that ola helped me out 16:53:09 i just could set up from sources aolserver and PG, but didnt know very much about OACS 16:53:22 and how to debug the errors of Aolserver 16:53:50 I'm sleepy 16:53:59 Psychephylax: its lunchtime! 16:54:09 naptime is later. 16:54:23 I'm just tired from staying up 16:54:28 too late last few days 16:54:29 I hope next week i will have a step-by-step guide (thanks to ola) 16:54:50 that is really great! 16:55:37 i think that even for guys like me that know a little bit, it takes time to figure out how to set up OACS 16:56:05 ITs all the seperate pieces. You have a little problem with each piece. 16:56:15 there were just a few things that i needed to touch actually, but without the guidance of ola, it would have taken me more time 16:56:22 did you have trouble with nsxml? 16:56:34 what is that for? 16:56:43 it is a module for aolserver. 16:56:50 if you installed frm an RPM its included I think. 16:57:01 i tried with rpms but didnt work 16:57:12 and then i tried it from sources and did work 16:57:17 i have a RH 7.2 linux box 16:57:20 are you using 3 or 4? 16:57:25 3 16:57:34 aha. that doesn't use nsxml :) 16:58:07 i downloaded the rpms recommended for RH 6.2 and 7.1 but none of them did work 16:58:18 because rpms suck :) 16:58:46 i rather prefer to compile myself, that way i know a little bit more what I am installing 16:59:41 actually i am quite dissapointed with my "boss", he hasnt help me out and i have to do everything by myself, thanks that i found this channel 17:00:08 miguel: does your "boss" know Psychephylax's boss? 17:00:09 :) 17:00:25 no i dont think so 17:00:28 ;) 17:00:37 may i ask why? 17:00:54 lol 17:01:22 no, i do happen to work in Spain 17:01:28 Hmmm 17:02:06 you mean that your boss insists in he know OACS when he actually doesnt? 17:03:16 mine? 17:03:25 yes yours ;) 17:03:43 He inisists that i use it 17:03:49 he he he 17:04:12 well, i guess your bossī attitude is not very far from mine 17:04:22 yup 17:06:48 the funny thing is that i am learning OACS for no money 17:07:00 heh 17:07:04 me too! 17:07:06 Elaborate on that 17:07:10 and my boss told me that I am being lazy (just because all the problems that I got) and hopefully 17:07:54 and i would not get a grant because of that (the rest of my group are working with Psets with ACS and Oracle) 17:08:21 besides i am working alone, no help at all, and that group they know each other 17:08:33 is this for school or work? 17:09:01 a mix 17:09:26 i am still in college (finishing off my CS degree) 17:09:47 heh 17:09:49 and i have joined a group of "visionaries" that want to set up a company who will work 17:09:50 Sounds like me 17:09:59 with ACS 17:10:04 aha! 17:10:06 :) 17:10:07 I was working on ACS for work while finishing CS 17:10:55 and i am working as intern in a small research institute, my director gave them good references cause last year i got an A grade 17:11:37 heh 17:11:43 I'm working as an intern :) 17:11:53 he he he 17:12:00 my US soul mate ;) 17:12:03 :) 17:12:24 I emailed the VP of one of the divisions asking him for an internship 17:12:28 i got an A grade last year because a project i did working on Apache+SSL+PHP 17:12:38 postgresql 17:12:45 and c++ builder (windows side) 17:12:54 VP? what is that? 17:13:27 Dave? 17:15:20 psychephylax: have you done the psets? 17:15:28 nope 17:15:34 VP = Vice President 17:15:38 and you dave? 17:16:30 I started and did a part of 1 17:16:56 ok psyche, sometimes i got lost with all these...how you call a word like VP that stands for something? 17:17:04 Psychephylax how may I help you. 17:17:20 Dave 17:17:24 I just read Philip's book and then found OpenACS. 17:17:31 why the hell can't I do if { } else { } 17:17:36 So I started fooling around. 17:17:40 And then he counted sheep 17:17:41 you can 17:17:52 if {condition} { 17:17:54 stuff 17:17:56 } else { 17:18:00 more stuff 17:18:00 } 17:18:13 the else HAS to be between } else { all on one line. 17:18:16 Tcl is wacky like that. 17:18:18 Blast ACS and it's white space un-ignorance 17:18:25 not ACS. Tcl 17:18:25 yes dave i have suffered it 17:18:48 I built a little web site, then promptly failed to work on it :) 17:18:57 Same here 17:18:59 Then I started proting on OpenACS 4. 17:19:00 but mine wasn't OPenACS 17:19:50 Then I came to this channel and helped Psychephylax. 17:19:54 I do like emacs though 17:19:55 :) 17:20:03 hehe 17:20:08 he he he 17:20:18 yeah between the 4-5 of us in the channel we have a whole ACS team here 17:20:18 you guys know anything about ns_schedule_proc^? 17:20:28 miguel A little. 17:20:30 I believe 17:20:42 it's used to schedule specific procedures to run at a specific time 17:20:44 Psychephylax: don't forget vinod and rbm... 17:20:51 Right 17:20:58 between 6 or 7 of us here 17:21:00 heh 17:21:03 Mark - Databases 17:21:07 ACS team? you develop code for OACS? 17:21:12 Dave - To smack me around when I make stupid mistakes 17:21:23 Vinod - Tcl/Oracle genius 17:21:32 Talli - he manages us all 17:21:36 miguel: I worked on porting. I am supposed to be building some other modules, but haven't had a change to work on them. 17:21:41 Rbm - provides all the documentation 17:21:59 Me - I make stupid mistakes and ask them to help 17:22:06 dave i want to schedule a tcl script, where i have to execute it? dont know how it works 17:22:10 Ola - we still don't know what he does :) 17:22:23 But it must be important 17:22:48 greenspun is still in MIT and working for Arsdigita? 17:22:51 miguel: ns_schedule_proc usually is run from the tcl library directory. 17:23:02 Still at MIT, not arsDigita. 17:23:04 the private one? 17:23:10 miguel: yes. 17:23:28 let me find an example. 17:23:46 so i just create a tcl file that executes ns_schedule? 17:23:54 YES. 17:24:09 but i can point to a file which is not in the tcl private lib? 17:24:31 No. the proc it calls needs to be in the library also. 17:24:42 ok 17:24:46 thanks dave 17:24:46 Usually in OpenACS the proc is created, then scheduled in the same file at the end. 17:24:49 np, 17:25:10 You could have a tcl page schedule a proc also when it was run. 17:25:30 what? 17:25:51 do you know philip personally? 17:25:55 no. 17:26:31 I planned on attending one of the seminars, but never made it. 17:26:41 I also missed all the OpenACS socials :( 17:26:42 ok 17:27:18 can u explain me a little bit more that thing about a tcl page? 17:27:49 I'll try. 17:28:54 Say for some reason you wanted a web interface to schedule some recurring event on the server. The tcl script attached to that page could call ns_schedule_proc. Its just more common to schedule all those things on server startup. 17:29:49 how can i set it up from a web interface? 17:32:02 Probably with some sort of form that would parse the input and convert it into the proper syntax along with security checking :) 17:33:36 bah 17:33:42 I have to pay 500$ to Sprint PCS 17:34:11 but how can i say to the system to schedule a tcl script? 17:34:41 it can only schedule one proc. 17:35:05 for each ns_schedule_proc anyway, of course that could be an entire script. 17:35:26 I think I am not explaining it well :) 17:35:38 only one proc? 17:35:43 that means that i have to add to the tcl script to execute the code to add? 17:36:01 i mean to add the reference to a new proc in the tcl script 17:36:34 you need to create a proc to run whatvever code you want run, yes. 17:36:46 proc myproc {} { 17:36:49 a bunch of code 17:36:50 } 17:37:04 ns_schedule_proc -thread 3600 myproc 17:37:09 or something like that. 17:37:54 inside myproc you can have any code you want. 17:37:54 and inside myproc i have to add all what i want? that means that i can parse a new proc to execute and just put it in the end of myproc? 17:38:04 by the way can i execute a .tcl script? 17:38:17 you could using source 17:38:27 source "path to tcl script" 17:39:12 I don't think you would want to define a new proc inside the scheduled proc. it would be recreated every time the sheduled proc was run. 17:39:26 so how? 17:39:37 i meant i can execute a tcl script with ns_schedule 17:39:37 maybe I am confused. 17:40:07 grep for 'ns_schedule_proc' in the OpenACS private tcl library. There should be alot of examples in there. 17:40:15 that might explain it better than I can. 17:41:11 brb 17:42:37 miguel has quit (Ping timeout: 180 seconds) 17:46:06 miguel (~miguel25@cancerbero.unileon.es) has joined #openacs 17:47:26 lunchtime 17:47:28 bbl 17:47:31 dave i got disconnected. the net today is a bit crappy 17:47:37 where were we? 17:49:43 dave i go for a coffe, ill be back in 15 minutes 18:18:43 graszew (~rob@pc218.warszawa.sdi.tpnet.pl) has joined #openacs 18:24:41 ola: done 18:24:50 talli has quit (Ping timeout: 180 seconds) 18:24:53 you now have commit acces to static-pages :) 18:44:42 til (tils@port-212-202-128-201.reverse.qsc.de) has joined #openacs 18:44:58 back 18:56:37 ok sorry i am back 19:07:19 :/ 19:13:16 working... I'll be in an out :) 19:21:26 til has quit (Ping timeout: 180 seconds) 19:23:28 me too 19:23:55 talli (~user@xcdfddb76.ip.ggn.net) has joined #openacs 19:26:21 :) 19:43:40 davb has quit (Read error: 104 (Connection reset by peer)) 19:50:52 davb (~dave@208.136.23.203) has joined #openacs 19:53:27 anyone know a quick way to select the next and previous record in a query? 19:53:39 I have entries by date, but not one every day. 19:53:52 I want to select the previous and next day that there was an entry. 19:55:59 hmm? 19:56:19 I am trying to figure out a way to add previous and next links to my weblog. 19:56:29 hold on 19:56:32 ok 19:56:54 * davb should be working, but this is bugging him 19:57:03 wouldn't it be 19:57:49 where date = date - 1 OR date = date + 1 19:58:14 thanks, but there is not necessarily an entry every day :) 19:59:39 hmmm 19:59:42 right 19:59:52 you'd need subqueries then 20:00:00 to select the dates smaller and larger 20:00:08 and take the min(date) and max(date) 20:01:07 like select * from (min(select * from records where date < today))...etc 20:01:15 Mark would help you better 20:01:17 I did this: (two queies) 20:01:50 select entry_id from blog where entry_date < $my_entry_date order by entry_date desc limit 1 20:02:01 and the other one is < 20:03:26 That should work 20:13:55 Did it work? 20:15:09 the query seems to work, the rest of my code still sucks :) 20:18:00 heh 20:18:04 sounds like my databases project 20:22:17 heh 20:22:18 ok guys, i gotta go home 20:22:22 bye! 20:22:29 the problem is I reused the same var name in every query :) 20:22:30 bye! 20:23:10 bye bye 20:23:16 miguel has quit () 20:24:43 Dave? 20:26:09 yes? 20:26:17 It works except on the last day the next link still appears. 20:26:24 Isn't Malaysia like some really technologically advanced nation 20:26:45 so check for NOT EXISTS 20:27:01 well the query should just return 0 rows... 20:27:06 I'll have to look further. 20:27:08 :) 20:27:46 not sure about malaysia, except consumer electronics are manufactured there. 20:27:53 http://net-snmp.sourceforge.net/postcards/postcard.59.html 20:27:53 D: http://net-snmp.sourceforge.net/postcards/postcard.59.html from Psychephylax 20:27:59 D:| Malaysia? 20:27:59 titled item D 20:28:56 LOL!!!! http://net-snmp.sourceforge.net/postcards/postcard.101.html 20:29:03 Psychephylax: there are parts of the US that are like that 20:29:18 they dont' count 20:29:21 :) 20:29:39 oh. 20:32:17 ok now it works for no reason :) 20:32:26 wait no it doesn't 20:39:28 what is the keyword for order by ascending? 20:39:44 ascd 20:39:46 wait 20:39:46 oracle? 20:39:48 hang on 20:39:54 no pg, but I think its standard. 20:41:16 well I tried ascending and descending, it just breaks in the oposite direction :) 20:41:38 I can get the previous day with that query, but using > $entry_date always gives the last entry or the first entry. 20:42:26 asbah 20:42:32 I have to think about it more when I am at home 20:43:17 heh. 20:43:25 I am just thinking in the channel... 20:43:26 :) 20:43:50 you're trying to get a nav thing going right? 20:43:56 yeah 20:43:59 I figured it out. 20:44:07 ? 20:44:13 I have entry_date > $entry_date instead of entry_date > '$entry_date' 20:44:28 in TCL? 20:44:36 nah, thats the SQL query 20:44:48 pg wanted the date in ''s 20:44:49 oh 20:45:16 I fixed the previous query but forgot to fix it on the next query. 20:47:39 thanks. 20:51:06 exit 20:51:09 oops 21:01:44 lol 21:02:00 2001-12-04 Vlad Seryakov vlad@crystalballinc.com 21:02:10 * Compilation problems with Linux and Solaris(Nikolay Blyumberg nickb@cv.net) 21:06:01 I never made anything cool like a CHANGEME log before 21:15:19 excellent! 21:16:10 heh 21:29:31 ok, how can I check if a variable exists in Tcl? 21:29:35 I can;t seem to remember :) 21:30:45 Dave, I have commited the little fix I was whining about ;-) 21:31:01 yeah! 21:31:12 ok ola: what is the command to check if a variable exists? 21:31:12 davb: info exist var 21:31:16 aha! 21:31:20 thanks a million! 21:31:50 np. might be; info exists var 21:32:25 * ola wonders which module to ask for commit rights to next 21:32:39 cool thanks! 21:32:46 I retrofitted my weblog. 21:32:50 did it work? 21:32:54 yes 21:33:01 aha. cool 21:33:04 this is the last work I do on this crappy old site. the code is icky. 21:33:16 But alot of people were visiting so I fixed it up a little. 21:33:33 your just about to move to OpenACS4, aren't you? 21:33:40 yes. 21:34:05 it seems very stable IMHO! 21:34:08 I was going to go before, but I am glad I waited, don rebuilt ALOT of queries. 21:34:21 As soon as the beta release I am going for it. 21:34:30 I have to figure out how to stuff my weblog into ETP. 21:35:19 everything else is getting thrown out. I have to figure out a custom 404 page that gives a serach box/site map kinda thing so I won't feel obligated to fix all the broken links I am creating :) 21:35:34 I think I will go for it tomorrow. I don't have the patience to wait another two weeks:-) 21:35:39 heh 21:36:17 I just don't really have time to work on it all. Plus I want to do it with CVS which means a day or two to get the mechanics of the development/staging/production servers down. 21:36:27 are you keeping the weblog in the db? 21:36:37 heh 21:36:38 yes. 21:36:41 Hola Ola 21:36:51 HOLA Psychephylax! 21:36:53 It will be pretty easy I think. Just create a new ETP page for each day. 21:37:00 Then I can finally SEARCH it :) 21:37:15 and I will migrate chump over to static-pages and that will be searchable too. 21:37:30 and maybe even I will get the logger working and hook that in. 21:37:43 so the IRC logs will be searchable. 21:38:42 talli has left #openacs 21:38:57 cool dave. that sounds like some great plans. I hope you'll find the time (perhaps during the x-mas hollidays;-)) 21:39:51 where do logs get put by aolserver? 21:39:52 good luck! 21:40:06 argh! 21:40:12 in /usr/local/aolserver/log 21:40:13 usually 21:40:22 or /wherever aolserver lives/log 21:41:55 Psychephylax: how is your module doing? was it ever accepted by the boss? 21:42:22 not sure yet 21:42:30 I'm trying tofind out why i cna't query 3Com modems 21:42:37 still working on it, huh? 21:43:11 yep 21:43:16 debugging lots of it 21:43:51 who needs modems anyway when we have dsl? :-P 21:44:39 I still need a DSL modem, I guess... 21:44:55 thats not really a modem 21:45:03 Its all digital. 21:45:07 :) 21:45:36 Cable modems not dialup (I was talking about) 21:47:34 time to go! bye for now! 21:47:37 davb has quit () 21:52:26 a product that does only two thirds of a job is not really a product 22:40:47 markd2 (~Snak@r-41.194.alltel.net) has joined #openacs 22:41:00 markd2 has quit (Remote closed the connection) 22:43:01 ola has quit ("changing universes") 22:43:40 graszew has quit ("using sirc version 2.211+KSIRC/1.1") 22:44:37 markd2 (~Snak@r-41.194.alltel.net) has joined #openacs 22:53:07 hi 22:53:16 * Psychephylax hands Mark a cookie 22:53:26 heya 22:58:24 :) 22:58:24 hi 22:59:33 Oracle pop quiz :) 22:59:36 how do i list the history 22:59:38 I forgot 22:59:45 list the history? 22:59:45 and how do I edit queries in the command line 22:59:53 do "L" for "list" 22:59:55 you gave me the command 22:59:55 that'll show line numbers 23:00:05 you can do the number to "go to' the line number 23:00:13 the slash command "/" executes whatever's in the sql buffer 23:00:39 you mean go to '1' 23:00:41 ? 23:00:46 * markd2 sighs 23:00:48 if you ahve 3 lines 23:00:53 doing "2" will take you to the second line 23:01:01 to edit a line, do c/old-text/new-text/ 23:01:03 c for change 23:01:51 oh 23:02:58 how come it always tells me I have only 1 query in the list 23:04:34 Aha 23:04:36 this is spiffy 23:04:43 * Psychephylax gives mark a cookie 23:06:36 it only has one statement history 23:07:18 well, that doesn't help me 23:07:22 can I make it more than one? 23:07:38 nope 23:08:04 that sux0rz 23:08:05 if you run your sqlplus session in an emacs shell, you can use M-p M-n to go back and forward through your typed commands 23:08:17 that's the way ti is 23:08:43 we must change the way it is 23:09:01 I'll watch 23:11:00 :) 23:11:12 What kind of a dog does Greenspun have 23:11:47 Samoyed 23:12:20 got a question for you 23:12:22 ok 23:12:35 I'm looking at sql for web nerds on his site 23:12:49 Chapter 10 (for my employee hierarchy) 23:12:54 And he has a table 23:12:56 ok 23:13:02 which references itself 23:13:37 Now, I hope i learned something in databases but you need to manually insert something in there as your "Big cheese" row where supervisor_id = NULL 23:14:02 right? 23:14:18 that might not be necessary 23:14:27 with oracle's 'connect by' statement, you can start the tree at any arbitrary point 23:15:09 so how does it reference iself 23:15:48 read the docs on connect by 23:15:52 it's been ahwile since I've used it 23:17:16 I'm asking because I ran this: 23:17:28 and got constraint errors (self referencing table) 23:18:36 what's the *exact* constraint error you're getting? 23:18:57 I'm not sure if i will get it now 23:19:00 I added a row 23:20:42 Right 23:21:00 I didn't get that error because I added admin as the "BIG CHEESE" 23:21:24 AFAIK, constraints don't know about a tree-like table 23:21:27 since connect by only happens at query time 23:22:14 right 23:22:37 So there's no way of defer the checking 23:22:38 ? 23:23:54 I don't see how the checking could happen 23:24:05 without seeing the *actual* complaint from oracle, it's all speculation 23:24:23 heh 23:24:25 hold on 23:27:48 must do a query where it's sorted somehow 23:27:57 They did not teach us about ORDER BY 23:28:01 whoa 23:28:11 how did they expect you to sort stuff? 23:28:14 in the java layer? 23:29:00 probably 23:29:04 We didn't have to do any sorting 23:29:15 Infact, when I get home, I will send you my project so you can make fun of it 23:29:45 heh 23:29:46 kool 23:30:07 Not really :) 23:30:09 It's really bad 23:30:18 At least to my liking 23:33:01 shweeeeet! 23:33:03 EMPLOYEE_ID SUPERVISOR_ID 23:33:03 ----------- ------------- 23:33:03 2189 23:33:03 3497 2189 23:33:03 3500 2189 23:33:04 3503 3500 23:33:36 qool 23:36:36 looq? 23:37:27 ooql 23:39:10 markd2 has quit ("Bork")