00:37:39 loggy has joined #openacs 00:37:39 topic is: OpenACS: Free web toolkit | http://openacs.org 00:37:39 Users on #openacs: loggy chump abbaJ shagster_ rbm KarlL GEM AaronSw 00:37:39 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 00:53:38 davb has joined #OpenACS 01:10:42 ARGH! Why doesn't ALSA work with my Soundblaster. THis is a big pain! 01:49:32 Disconnected from irc.openprojects.net (ERROR :Closing Link: loggy[xcdfddb76.ip.ggn.net] by carter.openprojects.net (Ping timeout for loggy[xcdfddb76.ip.ggn.net])) 01:49:55 loggy has joined #openacs 01:49:55 topic is: OpenACS: Free web toolkit | http://openacs.org 01:49:55 Users on #openacs: loggy davb chump abbaJ shagster_ rbm KarlL AaronSw GEM 01:49:55 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 02:32:45 davb has quit 02:39:50 gnatcam has joined #openacs 03:00:59 davb: turn off pnp os in the bios if it's on 03:01:04 that almost always fixes the problem 03:11:18 replay for loggy: 03:11:19 Cool. I emailed a local paper to see if they had RSS feeds and the webmaster checked out my web site. She noticed I am using OpenACS and asked about the future of ACS. I gave a little info on how OpenACS is taking over Tcl development and supporting Oracle and Postgresql. 04:13:55 q: what method do people use to debug long pgSQL statements? 04:28:39 It's hard to debug PL/pgSQL 04:31:40 pgaccess is helpful on that. 04:31:51 I remember seeing some tool that would make it easier 04:31:53 (to debug) 04:32:05 cut from tcl/sql pages, paste into pgaccess 04:32:07 ? 04:33:00 ?? 04:33:13 * rbm lights rjr and nafai on fire 04:33:19 I mean, 04:33:29 * rbm lights gnatcam on fire 04:33:38 * rbm has a pyromania tonight :) 04:33:59 is there a log or a setting to create the log? 04:34:20 I mean a log for the pgsql sent to postgres 04:35:22 You can output stuff to the log via the RAISE statement 04:35:43 RAISE NOTICE ''foobar = %'', avariable; 04:36:34 okay. 04:38:49 what about a log on the tcl side? I'm familiar with the logging functions, but is there a setting to enable this? 04:39:03 You mean PL/Tcl? 04:39:11 Enable what? 04:39:54 can you set a param in the nsd.tcl file that causes all pgSQL sent to db_exec_plsql to be put in a log? 04:41:19 You can set the "Verbose On" parameter on the database pools settings 04:44:20 thanks rbm. i'll give it a shot 04:44:26 gnatcam has left #openacs 05:30:59 talli has joined #openacs 05:31:05 hey gusy 05:31:10 rbm, you there? 05:37:02 GEM has quit 05:37:28 Disconnected from irc.openprojects.net (ERROR :Closing Link: loggy[xcdfddb76.ip.ggn.net] by niven.openprojects.net (Ping timeout for loggy[xcdfddb76.ip.ggn.net])) 05:37:31 loggy_1 has joined #openacs 05:37:31 topic is: OpenACS: Free web toolkit | http://openacs.org 05:37:31 Users on #openacs: loggy_1 GEM_ talli loggy chump abbaJ shagster_ rbm KarlL GEM AaronSw 05:37:31 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 05:41:45 GEM has quit 05:41:45 loggy has quit 05:41:45 abbaJ has quit 05:41:45 talli has quit 05:45:36 abbaJ has joined #openacs 06:09:47 PascalS has joined #openacs 06:09:53 mornin 06:14:35 PascalS has quit 07:09:04 abbaJ has quit 07:09:04 AaronSw has quit 07:09:04 GEM_ has quit 07:09:04 KarlL has quit 07:09:13 Disconnected from irc.openprojects.net (Connection reset by peer) 07:09:22 loggy has joined #openacs 07:09:22 topic is: OpenACS: Free web toolkit | http://openacs.org 07:09:22 Users on #openacs: loggy abbaJ GEM_ KarlL AaronSw 07:09:22 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 07:10:20 chump has joined #openacs 08:17:37 Disconnected from irc.openprojects.net (ERROR :Closing Link: loggy[xcdfddb76.ip.ggn.net] by carter.openprojects.net (Ping timeout for loggy[xcdfddb76.ip.ggn.net])) 08:17:53 loggy has joined #openacs 08:17:53 topic is: OpenACS: Free web toolkit | http://openacs.org 08:17:53 Users on #openacs: loggy chump abbaJ GEM_ KarlL AaronSw 08:17:53 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 08:20:54 Disconnected from irc.openprojects.net (ERROR :Closing Link: loggy[xcdfddb76.ip.ggn.net] by benford.openprojects.net (Ping timeout for loggy[xcdfddb76.ip.ggn.net])) 08:21:17 loggy has joined #openacs 08:21:17 topic is: OpenACS: Free web toolkit | http://openacs.org 08:21:17 Users on #openacs: loggy chump abbaJ GEM_ KarlL AaronSw 08:21:17 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 12:52:05 AaronSw has quit 12:53:23 davb has joined #openacs 12:55:22 thanks aabJ. I found your advice in the log. 13:25:23 Cool. safari.oreilly.com has books from other publishers besides oreilly now. 13:26:32 http://www.oreilly.com/news/safari_announce_0901.html 13:26:32 A: http://www.oreilly.com/news/safari_announce_0901.html from davb 13:26:50 A:|Safari Tech Books Online: 13:26:50 titled item A 13:26:51 It's O'Reilly and the Best of the Rest 13:27:02 A: It's O'Reilly and the Best of the Rest 13:27:03 commented item A 13:27:14 A: "O'Reilly & Associates is pleased to announce the formation of a joint venture with the Pearson Technology Group, a division of Pearson Education, to produce Safari Tech Books Online." 13:27:14 commented item A 13:28:32 A: Now it looks like this will be a great service. O'Reilly's XSLT book is not in there yet though 13:28:33 commented item A 13:28:58 A: I hope they will keep adding the new O'Reilly titles as they are published. 13:28:58 commented item A 13:55:44 AaronSw has joined #openacs 14:06:55 shagster_ has joined #openacs 14:08:11 Hi AaronSw 14:08:50 markd2 has joined #openacs 14:09:52 hi markd2 14:12:07 greetings 14:13:32 AaronSw has quit 14:18:42 AaronSw has joined #openacs 14:19:50 * davb adds more books to his Amazon wish list 14:26:03 AaronSw have you ever used XMLRPC in AOLserver with Meerkat? Someone is asking questions on the XMLRPC list. 14:30:00 never mind... 14:31:35 rbm has joined #openacs 14:31:39 moo 14:31:48 móò 14:32:14 hmm.. wonder if you can have accented characters in the nick 14:32:15 markd2 is now known as m 14:32:19 m is now known as markd2 14:32:22 guess not 14:34:24 yeah 14:36:25 what's new? 14:40:45 nammach 14:41:27 Is that hebrew? :) 14:41:46 I should go grab a coke or something before my next class... 14:42:48 Since I had no bfast before coming to the 7:30 class, I was tempted to buy one of those frozen vending machien foods and heat it up in the microwave, but the biologist in me didn't let me. 14:42:58 heh 14:43:05 at aol we called those 'the wheel of death' 14:43:18 Hehehe. Very appropriate. 14:44:31 I just thought of how many conservants and preservatives were added to those f00ds 14:45:10 you mean how little food was added to those preservatives, don't you? 14:45:17 Heheh. 14:45:42 heh 14:45:54 I was in college when 'soft batch' cookies came out 14:46:01 we carved the date in the back of one and put it on a shelf 14:46:04 What are those? 14:46:12 cookies that remain soft 14:46:15 oh 14:46:21 supposedly 'like right out of the oven' 14:46:24 6 months later, it was still soft 14:46:27 and the scary thing was 14:46:32 *nothing* had grown on it 14:46:32 kinda like a twinkie 14:46:39 and this was in a guys dorm 14:46:57 Holy macro 14:47:11 Ever see "the family guy" end of the world edisode? There was a huge twinkie factory that was the only thing that survived 14:47:19 LOL 14:47:31 I can't believe that Twinkies longevity is actually used in its marketing. And people buy into it! 14:49:29 I remember my gastroenterology class in med school. We spent a good portion of the class analyzing north american eating/food habits and the reasons for the highest incidence of colon cancer being in the U.S. 14:50:28 yeah 14:50:30 AaronSw has quit 14:50:44 Run AaronSw! Run! 14:50:54 Andrew Weil has a good book that analyzes the american diet from a chemical / "nutritional" point of view 14:51:01 maybe Aaro nran out of twinkies 14:51:51 Hmmm. 30 Mins for my "Advanced Object-Oriented Software Development" class. 14:52:59 http://www.amazon.com/exec/obidos/ASIN/0395977894/qid=1000479250/sr=2-1/107-3206142-0797318 14:52:59 B: http://www.amazon.com/exec/obidos/ASIN/0395977894/qid=1000479250/sr=2-1/107-3206142-0797318 from davb 14:53:06 B:|Fast Food Nation 14:53:06 titled item B 14:53:34 stop. you're making me hungry 14:54:21 B: The Dark Side of the All-American Meal 14:54:21 commented item B 14:54:32 sorry 14:54:46 * davb hand markd2 a twinkie 14:55:08 * markd2 puts it in a safe-deposit box, for after the apocolypse 14:55:17 "n] 14:55:52 "Eater beware: forget your concerns about cholesterol, there is--literally--feces in your meat." 14:56:19 that's what gives McDogDoos that special flavor 14:57:26 rbm: where is that frm? 14:57:37 A quote from the book URL you posted 14:58:53 When I first moved into the U.S., the all-ready, quick, fast food was very appealing since I was so busy. After about a month I stopped and thought about what I was doing... 14:59:07 I didn't read that part... I will read that book though 14:59:40 Then went back to actually cooking my meals, like I did in Brazil. 15:00:29 To cut back on time I spent cooking, I reading about freezing techniques. So I cook more than I need, then freeze the excess. 15:00:42 s/reading/read/ 15:01:06 I better head toward the CS building. 15:01:10 bbl 15:15:36 Psychephylax has joined #openacs 15:15:40 morning 15:18:00 hiya 15:18:46 hi 15:23:27 I still do not know what this constraint is doing 15:23:46 which constraint? 15:24:14 ORA-00001: unique constraint (MYOPENACS.ACS_OBJECT_TYPES_PK) violated 15:24:14 ORA-06512: at "MYOPENACS.ACS_OBJECT_TYPE", line 28 15:24:22 what don't you understand? 15:24:30 Why it's complaining 15:24:32 I mean 15:24:40 do you know what kind of constraint it is? 15:24:45 I looked at Vinods code and his doesn't crap out 15:24:47 do you know what kind of constraint it is? 15:25:16 it's saying that there's a 2nd copy of ACS_OBJECT_TYPES_PK 15:25:19 or something of that sort 15:25:24 do you know what kind of constraint it is? 15:25:25 but I rolled the db so it shouldn't have a copy 15:25:32 do you know what kind of constraint it is? 15:25:33 It looks like you are trying to put a duplicate primary key in acs_object_type 15:27:13 I'm looking 15:27:18 but can't find a problem 15:27:28 its a primary key contrainst "constraint acs_object_types_pk primary key" 15:27:58 Psychephylax: are you trying to create a new ACS_OBJECT when it fails? 15:28:04 yes 15:28:31 Or rather a new ACS_OBJECT_TYPE 15:28:56 yep 15:29:06 And I only have one primary key reference at all 15:29:08 incident_idinteger 15:29:08 constraint incidents_incident_id_fk 15:29:08 references acs_objects(object_id) 15:29:08 constraint incidents_incident_id_pk 15:29:08 primary key, 15:29:14 OK. the object_type is the primary key. 15:29:31 what do you mean 15:29:58 No. It looks like its saying your are trying to create an acs_object_type with the same object_type of one that already exists. 15:30:08 ok 15:30:13 lemme try something than 15:30:34 I'm gonna prefix snmp_(stuph) here so it's no conflicting for sure 15:30:42 bbiab 15:47:56 ummm 15:48:29 ok, would creation_date in acs_objects.creation_date%TYPE be left alone or fixed with snmp_ prefixes 15:49:21 That is defining the TYPE referencing the column type in acs_objects. 15:51:05 hmmm 15:51:07 * Psychephylax tries something 15:51:44 Do this: 15:52:01 select object_type from acs_object_types; 15:52:16 see if your object_type you are trying to create is already in there. 16:18:03 yeah there is 16:18:11 is there a way to get more info about an object? 16:19:15 sure select * from abs_object_types where object_type='the_offending_object_type'; 16:20:59 heh 16:21:03 it doesn't have much info in there at all 16:21:27 Is it an object_type that your created? Or a built in one? 16:22:21 I can't tell that's the problem 16:22:25 I'll know for sure 16:22:33 I just modified my stuff to be snmp_incident 16:23:18 AHA! 16:23:24 * Psychephylax dances around his desk 16:23:52 Don't try to create that type again or you'll get the same error. 16:23:58 ORA-00001: unique constraint (MYOPENACS.ACS_OBJ_TYPES_PRETTY_NAME_UN) violated 16:24:18 Dave, that's what I thought originally 16:24:34 but I dropped the db on wed and it still gave me that error on the first run of my script 16:24:34 You are getting a different error?? 16:24:38 yeah 16:24:47 so....this leads me to believe that incident was probably used 16:24:58 w00t :) 16:30:15 talli has joined #openacs 16:30:22 Hi talli. 16:30:26 hey dave 16:30:33 got a qeustion for ya 16:30:40 OK 16:30:56 hey talli 16:30:58 in debian (actually i gave up on debian and installed progeny) where the hell is the linux source? 16:31:01 hey psyce 16:31:07 You need to get it. 16:31:08 probably in /usr/src 16:31:17 heh 16:31:19 huh? 16:31:20 apt-get kernel-source-2.2.19 or whatever version you want. 16:31:27 You also need kernel-headers 16:31:27 oh chirst. 16:31:33 Hold on... 16:31:43 my prob is that i'm trying to set up the networking 16:31:49 i need to update my frivers 16:31:51 drivers 16:32:02 * Psychephylax needs to hack his drop script now 16:32:18 http://www.debian.org/doc/FAQ/ch-kernel.html 16:32:18 C: http://www.debian.org/doc/FAQ/ch-kernel.html from davb 16:32:25 ok 16:32:30 i'll have to try that later. 16:32:42 right now i'm having real trouble getting my system to work 16:32:54 Anyway. Are your network drivers supplied with the kernel? 16:33:01 C:|Debian and the Kernel 16:33:01 titled item C 16:33:02 i don't think so 16:33:17 unless i'm screwing up the networking 16:33:21 Aha. You might have to download them seperately and compile and install the module 16:33:40 ok, my other question is... 16:33:46 w00t 16:33:57 i downloaded and burned a couple of .deb packages onto a cd 16:34:01 Now I just need to fix my package :) 16:34:13 OK. 16:34:21 you want to install them? 16:34:22 i would like to install them, but i can't figure out how to get apt-get to recognize them on the cd 16:34:28 when i do apt-cdrom add 16:34:37 it doesn't recognize the cd i burned them onto 16:34:47 although i know they are on the cd 16:34:56 I didn;t know there was a apt-cdrom! 16:34:58 should i save them to the harddisk? 16:35:09 I use dpkg -i for packages I downloaded myself. 16:35:19 apt is a front end for dpkg 16:35:19 apt-cdrom adds a cd to the source.list 16:35:27 Aha. 16:35:47 ok, so i should do dpkg -i *.deb? 16:35:56 Is your network built in? or PCMCIA? 16:36:16 i have both 16:36:38 Interesting. I was just wonderng if you knew which chip/card it is. 16:36:39 i have a 3com built in ethernet and a SMC wireless PCMCIA 16:36:55 i don't really know. my docs are in new york. 16:37:05 but it's a dell laptop so i should be able to find it online 16:37:13 anyway, it's the standard net 16:37:15 ORA-00972: identifier is too long 16:37:19 bah! Bah!!!! 16:37:34 when i do ifconfig, it only recognizes the lo interface 16:37:50 with the whole 127.0.0.1 shit. 16:38:08 i tried ifconfig up eth0 and it didn't recognize that interface 16:38:15 Aha. ALl the 3COM stuff should be available with the kernel. You have to select it under networking devices. I am surprised it didn't find it in the install. 16:38:39 Anyone know wtf this means: PLS-00905: object MYOPENACS.SNMP_INCIDENT is invalid 16:39:01 nope 16:39:10 talli: did you do apt-get update after apt-cdrom? 16:39:44 no 16:40:19 aha. After you change sources.list you need to do apt-get update 16:40:26 oh, ok 16:40:28 thanks 16:40:50 how do i select the 3com stuff under networking devices? 16:41:51 That is when you are configuring the kernel (which you haven't done yet.) 16:42:11 what's the longest constraint name you can have in oracle? 16:42:19 oh shit. so i need to configure the kernel. i guess i have to become a hacker now.... 16:42:28 i can get the info i need from that link you suggetsed? 16:42:33 Yes. 16:42:48 Also there is a kernel-howto at www.linuxdoc.org 16:42:56 cool, thanks 16:43:08 Keep your working kernel! So you can go back. 16:43:44 no problem. 16:43:53 Psychephylax: probably one shorter than the name you selected :) 16:44:02 ummm 16:44:03 right :P 16:44:17 but I have longer ones 16:44:20 And it doesn't complain 16:44:27 talli has quit 16:44:47 Check your manuals. Oracle error messages are a pain. 16:44:56 0/0 PL/SQL: Compilation unit analysis terminated 16:44:57 1/14 PLS-00905: object MYOPENACS.SNMP_INCIDENT is invalid 16:45:00 Man 16:45:13 I forgot my dead tree book at home 16:45:19 but I have it on cd here 16:46:10 odd 16:46:14 says something about permissions 16:51:28 doh 16:51:32 I confuzzled myself 17:55:20 AaronSw has joined #openacs 18:01:09 Hi AaronSw 18:01:28 Hi there 18:04:29 Woohooo 18:04:34 I got rid of some problems 18:04:36 but more exist 18:04:37 :( 18:05:01 isn't that always how it is 18:05:11 Its progress anyway :) 18:05:49 yeah 18:05:54 but I don't know wtf it's telling me 18:05:56 stupid oracle 18:06:37 what's the error? 18:08:28 PLS-00905 18:08:43 3/2 PL/SQL: Declaration ignored 18:08:43 4/18 PLS-00905: object MYOPENACS.SNMP_INCIDENTS is invalid 18:09:50 LOL: 18:09:50 Label LOL not found. 18:09:52 http://wmf.editthispage.com/discuss/msgReader$5694 18:09:58 http://wmf.editthispage.com/discuss/msgReader$5694 18:09:58 D: http://wmf.editthispage.com/discuss/msgReader$5694 from AaronSw 18:10:02 * markd2 suggests reading some oracle docs. maybe doing a googl search on the error 18:10:14 D:|only outlaws will have flight simulators 18:10:14 titled item D 18:10:33 D:very funny 18:10:33 commented item D 18:10:56 I did a google search 18:11:01 * markd2 also suggests asktom.oracle.com 18:11:02 Sifting through results now 18:11:11 there's a search there too 18:11:57 wooohooo 18:11:59 0 results 18:12:02 which looks like is currently broken 18:12:49 PLS-00905: object 'name' is invalid 18:12:50 Cause: 18:12:50 You referenced an invalid package specification or stored subprogram. A package specification or 18:12:50 stored subprogram is invalid if its source code or any database object it references has been 18:12:50 DROPped, REPLACEd, or ALTERed since it was last compiled. 18:12:50 Action: 18:12:52 Find out what invalidated the package specification or stored subprogram, then make sure that 18:13:07 sounds like you have your answer there 18:14:29 ORACLE can recompile it without errors. 18:14:51 heh 18:15:00 If i knew what it was talking about then yeah :P 18:15:36 Is there a way to delete an object? 18:16:01 * rbm steals mike's coke 18:16:04 ehh 18:16:20 hey roberto 18:17:52 hi 18:37:24 bartt has joined #openacs 18:37:59 Question: how do I disable the QD_LOGGER? 18:39:45 I think I've seen that answered in the openacs bboards 18:40:08 That's what I thought but I couldn't find it. 18:40:17 I can't remember how 18:43:51 bartt has quit 18:44:49 rbm has quit 18:45:31 it seems to never be answered here: http://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0002Te&topic_id=12&topic=OpenACS%204%2e0%20Design 18:46:48 this is what ben said "I made a mistake a few commits ago and switched QD logging to Notice instead of Debug. I committed again yesterday switching QD logging back to Debug. Try getting the latest QD files from CVS" 18:47:19 Is there a way to set the logging level in the tcl config file? 18:49:44 Disconnected from irc.openprojects.net (ERROR :Closing Link: loggy[xcdfddb76.ip.ggn.net] by forward.openprojects.net (Ping timeout for loggy[xcdfddb76.ip.ggn.net])) 18:49:50 loggy has joined #openacs 18:49:50 Users on #openacs: loggy AaronSw Psychephylax markd2 shagster_ davb chump KarlL GEM_ abbaJ 18:49:50 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 18:49:57 woo hoo! 18:50:21 dang. now I'll have to stop insuldting Vinod's hairstyle 18:52:27 rbm has joined #openacs 18:53:35 wow Amazon's Red Cross collection is almost 5 million dollars 18:57:13 bartt has joined #openacs 18:57:44 you guys missed my QD log stuff... 18:57:58 davb: TechTV just announced it's only 1.4 million 18:58:19 Hmmm... I wonder why it says 4.7 on the web site... rounding error? 18:59:17 bartt has quit 18:59:51 still pretty good either way 19:01:28 yeah 19:01:33 docwolf has joined #openacs 19:02:26 faa.gov says that international flights are allowed to come into the u.s. IFF both the departure airport and airline have passed stepped security measures 19:02:47 s/stepped/stepped up/ 19:03:16 hey doc 19:03:20 hi 19:04:14 how's everyone doing? 19:07:00 ok 19:09:02 bartt has joined #openacs 19:10:24 davb has quit 19:12:26 rbm has quit 19:12:38 davb has joined #openacs 19:14:33 Hi all. Does anyone know how to disable the QD_LOGGER? It's generating too many message for me. 19:14:39 rbm has joined #openacs 19:16:42 it seems to never be answered here: http://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0002Te&topic_id=12&topic=OpenACS%204%2e0%20Design 19:16:43 18:46:48 this is what ben said "I made a mistake a few commits ago and switched QD logging to Notice instead of Debug. I committed again yesterday switching QD logging back to Debug. Try getting the latest QD files from CVS" 19:16:43 18:47:19 Is there a way to set the logging level in the tcl config file? 19:19:31 I am running today's CVS. 19:20:25 OK. If the QD messages are set to DEBUG, you should be able to set your log to ignore everything except Notice and Error I think... 19:21:06 Maybe that I have clear the DB and start from scratch? 19:21:30 Aha. Check for ns_param debug false in your tcl config file maybe... 19:22:50 If Ben really set the messages to debug level you should be able to turn them off by that setting. 19:26:52 If you used the sample config file from file-storage debug is turned on. 19:30:13 All debug parameters and verbose parameters in my config file are set to Off. 19:30:24 I'll go ahead and start from scratch. 19:30:37 ok. sorry it didn't work. 19:32:59 Restarting doesn't help either. I think this a bug. 19:34:44 me too. 19:42:29 it looks like there are qd log messages still set to Notice level. 19:43:44 I broke it good! 19:43:50 * Psychephylax is proud of himself 19:47:33 I need things that are harder to break 19:47:53 Oracle is hard to break... 19:51:25 i broke it 19:53:02 You have a unique gift... 19:53:35 thank you 19:53:37 yeah 19:53:41 But I wanna get paid for it 19:53:50 I don't think breaking things is a marketable talent 19:54:01 * markd2 recommends a career in QA 19:54:31 good idea 19:57:14 bartt has quit 20:00:35 KarlL has quit 20:02:55 KarlL has joined #openacs 20:06:48 http://www.phpbuilder.com/columns/smith20010821.php3 20:06:49 E: http://www.phpbuilder.com/columns/smith20010821.php3 from davb 20:06:58 E:|Optimizing Postgresql 20:06:58 titled item E 20:13:13 Psychephylax has quit 20:20:43 http://www2.linuxjournal.com/lj-issues/issue88/4791.html 20:20:43 F: http://www2.linuxjournal.com/lj-issues/issue88/4791.html from rbm 20:20:49 F:PostgreSQL Performance Tuning 20:20:49 commented item F 20:20:57 F:|PostgreSQL Performance Tuning 20:20:57 titled item F 20:27:17 * rbm sighs deeply 20:28:06 Psychephylax has joined #openacs 20:28:09 hey guys 20:28:13 * Psychephylax returns 20:28:41 i almost got this! 20:28:47 Just need to fix 1 error :/ 20:32:19 * Psychephylax puts forth all of his Oracle knowledge 20:34:16 later... 20:34:20 davb has quit 20:34:35 * Psychephylax gets closer to markd2 and snatches his Oracle brain 20:35:17 * markd2 drools 20:39:33 Can you help me? 20:39:53 I can try 20:39:56 ok 20:40:12 I got rid of the majority of the problems with a DBA 20:40:19 cool 20:40:22 but this one he doesn't know since it's OACS related 20:40:28 ok 20:40:32 62/2 PL/SQL: SQL Statement ignored 20:40:32 62/35 PLS-00201: identifier 'OBJECT_ID' must be declared 20:40:36 that's the error 20:40:43 he said 20:40:52 I should declare that in my function new ( 20:40:53 ) 20:41:13 but I looked at Vinods reserve-create.sql and he doesn't have it 20:41:17 yeah - it's expectin the identifier to be declared (whether it's a parameter or a variable) 20:43:32 gilbertw has joined #openacs 20:44:13 hmm 20:44:34 So I would add: 20:44:40 don't blindly add stuff 20:44:55 search through the pl/sql of oacs new functions and see how they're using object_id 20:45:09 I did 20:45:15 I looked at Vinods code :/ 20:45:44 talli has joined #openacs 20:45:49 hey guys 20:45:55 beautiful it may be, Vinod's code is not the whole of oacs - he might not need features that you're needing 20:46:31 he has the thing 20:46:48 somebody say "vinod" and "beautiful" in the same sentence? 20:46:51 object_id => room_id, 20:46:58 he uses it like that 20:47:18 that means "parameter name object_id gets the value of variable room_id" 20:47:27 in a function call 20:47:42 object_id => incident_id, 20:47:52 that's how I use mine 20:48:10 is that for-sure where it's complaining? 20:48:14 yes 20:48:23 paste in the function call 20:48:25 please 20:48:32 it's looong 20:48:42 *just* the function call 20:48:47 not your whole function 20:48:50 just where object_id is being used 20:50:11 it's used here: 20:50:13 object_id => incident_id, 20:50:40 and then incident_id used here: insert into snmp_incidents 20:50:40 (incident_id, 20:50:41 the function you're invoking, that has an object_id paramter? 20:50:52 you're not getting any errors about incident_id - I don't care about it 20:50:57 I'm not following..feel free to yell at my stupidity 20:51:17 ignore incedent_id - you;re getting errors about object_id 20:51:39 that object_id => whatever should be used inside of a pl/sql function call 20:51:43 what is the function you're invoking that in? 20:53:45 ok, I have a package declaration, followed by a body of package definition 20:54:12 and I can't find the function stuff you're refering to :( 20:54:35 in that case closely compare your syntax with Vinod's 20:54:39 i did 20:54:46 because I used his as a model 20:54:55 you should have something some_function (blah => ack, object_id => bork, fnord => greeble); 20:55:08 if you don't you're comming an error, which is probably what the compiler is complaining about 20:55:51 I have a create or replace package body snmp_incident 20:55:51 as 20:55:54 function new ( 20:56:00 incident_id in blah 20:56:03 ... 20:56:05 ... 20:56:23 ) return snmp_incidents.incident_id%TYPE 20:56:24 is 20:56:28 vcontent_id integer; 20:56:35 begin 20:56:50 v_content_id :=acs_object.new( 20:56:58 object_id => incident_id, 20:57:08 object_type =>object_type, 20:57:09 ... 20:57:10 ); 20:57:17 is that what you're talking about? 20:58:04 yeah 20:58:13 ok 20:58:17 That's what I was looking at 20:58:53 that should work. so your problem may be elsewhere 20:59:07 scrutinize all uses of object_id, and make sure they're good 20:59:14 I only have 1 :/ 20:59:22 rbm has quit 20:59:24 my bad 20:59:36 5 or so 21:01:32 rbm has joined #openacs 21:02:27 hi rbm 21:04:34 rbm has quit 21:04:52 he doesn't love you Gil 21:05:24 Mark, for one thing, the oracle line numbers are whacky 21:05:51 usually it says "line number of some_refernce_name_" 21:05:57 like 'line 27 of package foobar" 21:06:11 so you go to the delcartamtion of package foobar, go down 27 lines, then look around for the complaint 21:06:21 ok 21:06:24 if worst comes to worst, paste in each thing from sqlplus 21:06:28 62 lines :P 21:06:33 and when you get the error, do an "L" to get a listing 21:06:42 and that has the line numbers that it's complaining about 21:07:21 aha! 21:07:29 delete from snmp_incidents where object_id = snmp_incident.delete.incident_id; 21:07:37 it's talking about THAT object_id 21:07:42 woo hoo! 21:08:02 bartt has joined #openacs 21:08:07 woohooo indeed 21:08:18 * Psychephylax snatches Marks' oracle brain again 21:08:23 * markd2 drools again 21:09:53 Aha! 21:11:37 SQL> @/web/oacs/packages/snmp/snmp-create.sql; 21:11:37 PL/SQL procedure successfully completed. 21:11:37 No errors. 21:11:37 Table created. 21:11:37 Package created. 21:11:38 No errors. 21:11:40 Package body created. 21:11:42 No errors. 21:11:48 * Psychephylax returns Oracle brain back to Mark 21:11:51 sweet 21:11:55 * markd2 stops drooling 21:11:57 Hi all. Has anyone taken a look at the site-wide-search package? The status sheets says that the postgres version is being tested but the data model files for PG aren't even in the .info file. 21:12:20 It's not terminating properly though 21:12:26 SQL> @/web/oacs/packages/snmp/snmp-create.sql; 21:12:26 PL/SQL procedure successfully completed. 21:12:26 No errors. 21:12:26 Table created. 21:12:26 Package created. 21:12:27 No errors. 21:12:29 Package body created. 21:12:31 No errors. 21:12:33 arg 21:12:44 No errors. 21:12:45 ^Cdeclare 21:12:45 * 21:12:45 ERROR at line 1: 21:12:45 ORA-01013: user requested cancel of current operation 21:12:45 ORA-06512: at "MYOPENACS.ACS_PRIVILEGE", line 11 21:12:47 ORA-06512: at line 18 21:12:56 oh 21:13:01 it's granting permissions I think 21:13:58 how long does it take to grant things and shtufff 21:14:20 dunno 21:14:32 i'll let it sit for a bit 21:15:14 simmer on low 21:15:24 you can run 'top' and see if there's an oracle process churning away 21:15:25 * Psychephylax sets the dial to simmer 21:15:38 I don't have top on this box :( 21:15:40 I don't think 21:16:23 Would it be in sbin? 21:18:05 I'm having trouble loading the reference packages. 21:18:22 I have it in /usr/local/bin 21:18:26 Can't load ref-language due to the error: Function 'sysdate()' does not exist. 21:19:19 Does anyone know why sysdate() is there? 21:19:40 oddness 21:22:10 Aah, I found it. The create script calls ../common/language-data at end but this file doesn't exist. Should be ref-language-data.sql. 21:22:57 Mark, do you know why a PL/SQL script would not terminate? 21:25:52 either it's churning away on something big, or it's locked in a deadlock 21:26:12 deadlock? 21:26:32 two independent processes each waiting for the other to release a resource 21:26:48 no I don't think that's it 21:26:49 you owe me $5, but you won't pay until I pay you back $10 I owed you earlier 21:26:53 that kind of thing 21:26:58 oh 21:27:03 yeah that's not the prob 21:27:07 nobody is using the db 21:27:25 And I have the acs intro done without errors 21:27:27 you can deadlock yourself if you have two db logins going 21:27:32 e.g. a sqlplus and an aolserver 21:27:38 hmmm 21:27:41 How can i test for this? 21:27:48 grovel around in v$lock 21:27:53 heh 21:27:57 like i know what that is :P 21:28:35 Aha! 21:28:39 You're a genius 21:29:05 w00t w00t! 21:29:08 Progress! 21:29:11 It works :) 21:29:18 * Psychephylax gives Mark a cookie 21:29:39 mmm.. cookies... 21:30:17 :) 21:30:23 ok 21:30:28 This is mighty important 21:30:42 Is there a way to see that my stuph was properly introduced into OACS? 21:31:04 brb 21:31:16 gonna tell my boss I got the sql stuff done 21:31:20 maybe he'll give me a cookie 21:32:58 he ain't there 21:34:25 * Psychephylax is confused 21:34:36 I don't know what to do next :( 21:35:39 if the db stuff works, now on to the tcl pages that bang the database 21:36:15 How do I see if my db stuff works? 21:37:20 by trying to use it somehow 21:37:27 heh 21:37:46 easier said than done of course 21:42:33 Hmmm 21:42:42 What's the site for the logs? 21:42:46 I need to look up that tutoral link 21:59:41 talli has quit 22:07:27 The plpgsql function sysdate() is unknown in my OpenACS 4 PG database. How could that be? 22:10:18 davb has joined #OpenACS 22:13:41 Hey dave 22:13:49 * Psychephylax gives dave a cookie 22:14:56 Thanks. 22:17:08 I got my datamodel loading into oracle :) 22:18:37 Cool. sysdate is not defined in OpenACS 4 at all. But it is an oracle function isn't it? I think its just sysdate though. 22:19:05 bartt: I think sysdate was supposed to be changed to now() or current_timestamp 22:19:19 Yes. 22:20:15 Gilbert, I tried the now() function instead of sysdate() in the offending ref-language.sql script with a different error message. 22:20:18 sysdate() was defined in openacs 3.x 22:20:50 bartt: what's the error? 22:20:55 Besides the Porting Guidelines refer to sysdate(). Do you happen to know the date format sysdate() is supposed to return 22:21:14 sysdate() used to be an alias to current_timestamp 22:21:32 which is the same as now() 22:22:12 The error msg is: Bad timestamp external representation 'ISO 639' 22:22:52 interesting. where is this error coming from? 22:23:52 Psychephylax: Make some test tcl pages that use the functions you created. Insert some stuff. Try to get it back out etc... 22:24:17 function new (ok 22:24:19 ack 22:24:22 ok, I will do that 22:24:26 I'm just wasting time now :) 22:24:29 It's Friday 22:24:29 lol 22:24:30 This is a psql error. I changed the sysdate() call in ref-language.sql to now() and then fed this to psql. 22:24:59 Cool. ns_ruby. I can't wait. Ruby is on my list after Python and Java. I will be able to use every language with AOLserver. 22:25:01 ok. is this the problem you talked about in the bboard? 22:25:18 heh 22:25:33 Yes it is. 22:27:55 is this part of acs-references? 22:29:08 If Afghanistan does not hand over Osama bin Laden, should the U.S. bomb Kabul? 22:29:24 Yes, acs-references is now broken up into several packages: language, countries, currencies, etc. 22:30:10 oh. hehe. I've been away from this stuff for a while. 22:31:56 so is it acs-language, acs-countries, and acs-currencies? 22:32:04 I don't think that the US should be provoked by terrorist to us violence against civilians. 22:32:07 Going home 22:32:08 buh bai~ 22:32:12 Psychephylax has quit 22:32:25 Yes, that is right Gilbert 22:32:42 hmmm... what is the path in the CVS repository. I can't seem to download them 22:35:20 I had some trouble with that too. Ended up checking out everything. 22:36:37 argh. I don't want to check out everything. gonna try something 22:37:42 If you can figure out a solution let me know. I'm having the same problem at the moment with acs-service-contract. 22:38:17 yeah. I had that problem with acs-references, and I got it to download somehow. I'm just trying to remember how I did it :) 22:48:31 hmmm... nothing seems to work. grrr 22:50:39 Try this Gilbert: create a directory acs-language in the package directory and then do a cvs -z6 update -P -d 22:51:25 ah ha. here's how to do it: 22:51:27 cvs -d:pserver:anonymous@openacs.org:/cvsroot co opena 22:51:27 cs-4/packages/acs-service-contract 22:51:55 doh. let me try that again :) 22:51:56 cvs -d:pserver:anonymous@openacs.org:/cvsroot co openacs-4/packages/acs-service-contract 22:52:54 Thanks. 22:52:58 no problem 22:53:11 rbm posted that a while back. took me a while to find it 22:54:23 hmmm... that doesn't work for acs-languages, acs-countries, etc. 23:05:11 gilbertw has left #openacs 23:06:12 Gilbert, I'm sorry that should be ref-countries, ref-currency, ref-language, ref-us-counties, ref-us-states and ref-us-zipcodes. 23:22:19 bartt has left #openacs 23:46:57 gnatcam has joined #openacs 23:48:13 gilbertw has joined #openacs 23:51:13 gilbertw has quit 23:54:24 does anyone know how to change the username and password in emacs sql-postgres mode? 23:54:38 I tried customize-variable... but no luck