IRC log of openacs on 2001-09-14

Timestamps are in UTC.

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