IRC log of openacs on 2001-10-05

Timestamps are in UTC.

00:01:42 [loggy]
loggy has joined #openacs
00:01:42 [forward.openprojects.net]
topic is: Welcome to the OpenACS Helpline | http://www.openacs.org/
00:01:42 [forward.openprojects.net]
Users on #openacs: loggy abbaJ davb rbm AaronSw Psychephylax shagster chump
00:01:43 [ChanServ]
This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog
00:48:59 [Psychephylax]
greetings
00:49:02 [Psychephylax]
* Psychephylax pokes dave
01:15:56 [AaronSw]
AaronSw has quit
01:22:06 [davb]
hey!
01:32:34 [AaronSw]
AaronSw has joined #openacs
01:47:00 [davb]
http://www.bris.ac.uk/ISC/cms/ttw.html
01:47:00 [chump]
B: http://www.bris.ac.uk/ISC/cms/ttw.html from davb
01:47:19 [davb]
B:|List of web-based WYSIWYG Editors
01:47:20 [chump]
titled item B
01:51:08 [davb]
http://www.labour.org.uk/lp/new/labour/docs/LONGSPEECHES/TBCONF2001SPEECH.html
01:51:08 [chump]
C: http://www.labour.org.uk/lp/new/labour/docs/LONGSPEECHES/TBCONF2001SPEECH.html from davb
01:51:29 [davb]
C:|Transcript of Tony Blair's Speech
01:51:29 [chump]
titled item C
01:51:38 [AaronSw]
about what?
01:53:21 [davb]
I didn't read the whole thing. About 9-11 and what we should do.
01:55:52 [Psychephylax]
heh
01:55:54 [Psychephylax]
dave is awake
01:56:52 [davb]
Not just about that, but really how it all ties in with how the world is changing and we have to wake up because it's not going to stop.
01:57:52 [Psychephylax]
I'm working on my resume
01:58:00 [Psychephylax]
Have to describe what my project is all about
01:58:38 [Psychephylax]
Somehow "Bugging dave and mark on IRC to get tips on how to structure my program" is not the right thing to write down :/
01:59:26 [davb]
Hey we just helped you with the syntax. You learned the system and build extensions. You took a web-based application toolkit and customized it.
02:00:08 [Psychephylax]
But do I really know the system?
02:01:38 [Psychephylax]
i can't even write a damn resume lol
02:02:09 [davb]
You know more than alot of us. I haven't actually used the system yet.
02:06:25 [Psychephylax]
that's impossible
02:07:49 [Psychephylax]
·Development of a support tool for the Customer Service and Technical Support Groups of Cablevision. The tool is based on the ArsDigita Community System with a custom data model and user interface as well as additional functionality incorporated into the system through the use of TCL and AOLServer.
02:08:38 [davb]
cool.
02:08:43 [Psychephylax]
gonna add more stuph
02:09:33 [davb]
tell what the "added functionality" is.
02:10:13 [Psychephylax]
Beautiful
02:10:16 [Psychephylax]
·Development of a support tool for the Customer Service and Technical Support Groups of Cablevision. The tool is based on the ArsDigita Community System with a custom data model and user interface as well as additional functionality that allows for cable modem queries incorporated into the system through the use of SNMP, TCL and AOLServer. Upon completion the tool will support approximately a million subscribers of broadband cable servi
02:10:46 [davb]
good.
02:11:08 [davb]
davb has changed the topic to: Welcome to the OpenACS based resume enhancement channel
02:11:13 [Psychephylax]
rofl
02:11:19 [Psychephylax]
can anyone change the topic?
02:11:56 [davb]
yeah. I guess so.
02:12:22 [Psychephylax]
Psychephylax has changed the topic to: Welcome to the OpenACS based resume enhancement channel, soon to be an OACS module
02:12:26 [Psychephylax]
rofl
02:12:48 [davb]
Cool! I'll tell Don you signed up to work on it
02:13:12 [Psychephylax]
hehehehe
02:15:48 [Psychephylax]
Oh
02:15:51 [Psychephylax]
I might not be around tomorrow
02:16:01 [Psychephylax]
I think they want me to rebuild a server rack
02:17:11 [davb]
is that good or bad?
02:18:33 [Psychephylax]
Good because i get to do something different
02:18:44 [Psychephylax]
bad because it sounds like a lot of work I probably won't want to do :P
02:18:52 [Psychephylax]
I hear it involves crimpers and stuph
02:19:05 [rbm]
moo
02:19:21 [Psychephylax]
¿oom
02:19:49 [davb]
heh, someones gotta do it. Thats what I do at work now. The network admin has me do all the work he doesn't want to do.
02:22:08 [Psychephylax]
hehehe
02:23:56 [Psychephylax]
ok
02:24:04 [Psychephylax]
Who's up for looking at my resumee
02:28:15 [Psychephylax]
Anyone?
02:30:38 [Psychephylax]
puhleeeeeze?
02:30:40 [Psychephylax]
dave?
02:39:44 [rbm]
heh
02:46:39 [Psychephylax]
Roberto? wanna seeeeee? :)
02:52:18 [davb]
where is it?
02:52:32 [Psychephylax]
umm http://www.neverhere.com:1085/resume2.pdf
02:52:39 [Psychephylax]
lol
02:52:41 [Psychephylax]
"
02:52:47 [Psychephylax]
"twain assisted data entry"
02:52:54 [Psychephylax]
sounds a lot better than "scan monkey" lol
02:55:54 [davb]
ack pdf. I don't know if I am equipped to handle that.
02:56:10 [Psychephylax]
heh
02:56:13 [Psychephylax]
What formad you want
02:56:34 [davb]
Probably plain text or html.
02:57:27 [Psychephylax]
ugh
02:57:39 [Psychephylax]
html or text always mess up the formatting
02:58:05 [davb]
hmmm.... Really? Most places only want text resumes by email these days.
03:01:26 [davb]
I have ghostscript. does that do pdf?
03:01:55 [Psychephylax]
umm
03:01:56 [Psychephylax]
not sure
03:02:18 [Psychephylax]
most take word or pdf too
03:04:40 [davb]
cool.
03:05:02 [davb]
I got it. gs filename x11
03:06:45 [davb]
You gotta do something with the twain-assisted thing. Noone who is hiring for the type of position you are looking for is gonna be fooled by that one. Unless they have a really good sense of humor.
03:11:29 [davb]
Good luck. I have to go though.
03:11:44 [davb]
davb has quit
05:58:18 [abbaJ]
abbaJ has quit
06:00:36 [abbaJ]
abbaJ has joined #openacs
08:34:49 [ola]
ola has joined #openacs
09:47:16 [sinaptico]
sinaptico has joined #openacs
09:48:07 [sinaptico]
sinaptico has left #openacs
10:59:50 [ola]
ola has quit
11:06:53 [ola]
ola has joined #openacs
11:24:38 [davb]
davb has joined #OpenACS
11:25:42 [davb]
davb has changed the topic to: Welcome to the OpenACS helpline http://openacs.org
11:26:01 [ola]
morning.
11:26:06 [davb]
Hi
11:27:34 [ola]
hmm...I'm trying to open up a shell in emacs so I can do "tail -f"...
11:29:03 [davb]
M-x shell
11:30:02 [ola]
thanks.
11:31:37 [davb]
np
11:31:41 [davb]
davb has quit
12:00:36 [davb]
davb has joined #openacs
12:03:50 [Psychephylax]
Psychephylax has quit
12:40:46 [ola]
dave, when I disable or delete my package from the admin pages, will the system execute the drop script?
12:41:17 [davb]
It will try.
12:41:35 [davb]
I am not sure about disable, delete runs it.
12:42:17 [ola]
ok.
12:43:15 [ola]
everything installed without errors the first time I tried. I find that hard to believe..
12:54:30 [ola]
grr. "database support" only shows oracle8.
13:10:17 [davb]
hmmmmm
13:10:39 [davb]
i wonder if that is specified in the .info file
13:13:40 [ola]
postgresql is specified, but not the sql/postgresql/package-create.sql , the drop file and so on...
13:14:21 [ola]
perhaps I need to "Manage File Information" and "Scan for new files" first?
13:15:42 [ola]
see, I haven't edited the info file at all.
13:17:48 [ola]
sorry to bug you like this, dave;-)
13:22:37 [davb]
np
13:22:49 [davb]
i am not sure. try it
13:34:09 [ola]
that was it. now I'm beginning to see some errors.
13:51:00 [markd2]
markd2 has joined #openacs
13:51:39 [davb]
cool! that means you are making progress.
13:51:51 [markd2]
progress is good
13:52:00 [davb]
I was always happy to get a new error. it meant the old one was fixed.
13:53:11 [markd2]
or introduced a brand new one :-)
13:53:18 [markd2]
* markd2 is feeling particularly cynical this morning
13:56:05 [davb]
heh, i did that too!
13:57:58 [ola]
markd2: it promises well.
13:58:21 [ola]
you feeling x-tra cynical, that is:-)
14:01:50 [markd2]
heh
14:37:48 [ola]
what is wrong with the following view:
14:37:58 [ola]
create view mp3_mp3_playlist_map_view as
14:37:58 [ola]
select m.mp3_id,
14:37:58 [ola]
m.playlist_id,
14:37:58 [ola]
m.sort_key,
14:37:58 [ola]
coalesce(v.total,0) as total
14:37:59 [ola]
from mp3_mp3_playlist_map m
14:38:01 [ola]
left join (select mp3_id,
14:38:03 [ola]
playlist_id,
14:38:05 [ola]
sum(vote) as total
14:38:07 [ola]
from mp3_votes
14:38:09 [ola]
group by mp3_id, playlist_id) v
14:38:11 [ola]
using (mp3_id)
14:38:13 [ola]
left join v using (playlist_id);
14:38:23 [ola]
I get: ERROR: Relation 'v' does not exist
14:39:03 [ola]
the original view looks like this:
14:39:25 [ola]
create or replace view mp3_mp3_playlist_map_view as
14:39:25 [ola]
select m.mp3_id,
14:39:25 [ola]
m.playlist_id,
14:39:25 [ola]
m.sort_key,
14:39:25 [ola]
nvl(v.total,0) as total
14:39:26 [ola]
from mp3_mp3_playlist_map m,
14:39:28 [ola]
(select mp3_id,
14:39:30 [ola]
playlist_id,
14:39:32 [ola]
sum(vote) as total
14:39:34 [ola]
from mp3_votes
14:39:36 [ola]
group by mp3_id, playlist_id) v
14:39:38 [ola]
where m.mp3_id = v.mp3_id (+)
14:39:40 [ola]
and m.playlist_id = v.playlist_id (+);
14:41:17 [davb]
ack! I just entered a password into my windows machine by accident. I don't know what it is...
14:41:34 [markd2]
it's probably stored in cleartext in several files
14:41:45 [davb]
i am not sure about the join syntax...
14:41:51 [davb]
markd2: i am sure...
14:43:38 [Psychephylax]
Psychephylax has joined #openacs
14:43:46 [Psychephylax]
morning
14:44:58 [davb]
hi
14:45:26 [markd2]
markd2 has quit
14:49:45 [Psychephylax]
:)
14:50:38 [Psychephylax]
lets seee...where was I
14:50:53 [Psychephylax]
I'm getting moved again
14:51:47 [Psychephylax]
oh...Dave, what do you think I should replace my "Twain assisted data entry" with...ehehe
14:52:27 [davb]
no idea
14:52:41 [davb]
ola: looks like you are missing a ( somewhere in there
14:52:43 [davb]
brb
14:52:50 [davb]
davb has quit
14:53:06 [davb]
davb has joined #OpenACS
14:54:09 [davb]
never mind about the (
14:54:28 [Psychephylax]
:)
15:00:23 [Psychephylax]
i guess I need a custom search page now
15:01:39 [davb]
fun!
15:01:53 [Psychephylax]
Well
15:01:57 [Psychephylax]
maybe I can hack this one
15:02:15 [Psychephylax]
it just has to go find a person by e-mail address
15:03:36 [davb]
That is definitely in ACS already.
15:04:36 [Psychephylax]
yep
15:04:45 [Psychephylax]
I just have to figure out what the hell %5 represents
15:04:49 [Psychephylax]
I know %20 is a space
15:06:10 [Psychephylax]
my bad
15:06:13 [Psychephylax]
it's %5F
15:06:54 [davb]
ola: try this
15:06:58 [davb]
left join (
15:06:58 [davb]
select mp3_id,
15:06:58 [davb]
playlist_id,
15:06:58 [davb]
sum(vote) as total
15:06:58 [davb]
from mp3_vots
15:06:59 [davb]
group by mp3_id, playlist_id ) v
15:07:01 [davb]
on (m.mp3_id = v.mp3_id and
15:07:03 [davb]
m.playlist_id = v.playlist_id )
15:07:04 [Psychephylax]
aha
15:07:12 [Psychephylax]
%5F is an underscore
15:07:34 [davb]
I am just winging it though.
15:08:09 [Psychephylax]
http://www.blooberry.com/indexdot/html/topics/urlencoding.htm
15:08:09 [chump]
A: http://www.blooberry.com/indexdot/html/topics/urlencoding.htm from Psychephylax
15:08:20 [Psychephylax]
A:| All you ever wanted to know about URL Encoding
15:08:20 [chump]
titled item A
15:08:22 [Psychephylax]
B
15:08:39 [davb]
Psychephylax: OpenACS/AOLserver does url encoding for you.
15:08:39 [Psychephylax]
A: Now with it's own converter!
15:08:39 [chump]
commented item A
15:11:22 [Psychephylax]
I know
15:11:25 [Psychephylax]
I'm trying decode it!
15:11:27 [Psychephylax]
lol
15:12:36 [davb]
for fun? ad_page_contract should stuff the URL variables into Tcl variables for you
15:12:40 [davb]
:)
15:13:20 [Psychephylax]
no
15:13:38 [Psychephylax]
I'm trying to search for an email by manually passing it parameters in a URL
15:13:58 [Psychephylax]
Instead of coding the page first and then finding out that it doesn't work I'd much rather try the search manually first
15:14:22 [Psychephylax]
And it searches for everyone still even though I tell it to find people with specific email
15:17:01 [davb]
dont you need something like this: select * from users where email = :email_passed_in_form_variable
15:17:25 [davb]
How many users will you have? If its not too many a drop down box might be better.
15:17:54 [Psychephylax]
it'll be many
15:18:05 [davb]
Ok, so thats a bad idea.
15:18:34 [davb]
we are assuming the user knows the exact email address?
15:18:55 [Psychephylax]
yeah
15:19:08 [Psychephylax]
of course knowing my boss that will change once i mention this to him
15:19:14 [davb]
heh
15:19:17 [davb]
What fun!
15:19:30 [Psychephylax]
not really
15:19:37 [Psychephylax]
I think I'll use this Quick search thing
15:19:46 [Psychephylax]
it seems to use keywords and can find multiple things
15:20:50 [davb]
cool.
15:21:33 [Psychephylax]
now I just have to figure out how it works
15:21:33 [shagster]
shagster has quit
15:21:34 [Psychephylax]
lol
15:22:14 [Psychephylax]
aha
15:22:16 [Psychephylax]
it calls search
15:22:37 [Psychephylax]
my package is gonna be huuuge
15:22:48 [Psychephylax]
cuz I'm duplicating all the stuff
15:24:40 [ola]
davb: thanks! it works.
15:24:42 [davb]
yeah but your package is really "the system"
15:24:50 [shagster]
shagster has joined #openacs
15:25:17 [davb]
ola! I can't believe it. what luck. Maybe one day I'll actually understand what all the stuff means. I copied off a join DanW helped me port.
15:25:25 [Psychephylax]
lol
15:25:38 [Psychephylax]
I rule
15:26:54 [Psychephylax]
actually..."Eureka!" :)
15:28:06 [ola]
davb: cool!
15:32:45 [Psychephylax]
muahaha
15:32:50 [ola]
unfortunately I posted to the forum before...
15:33:29 [ola]
hi psyche!
15:33:29 [shagster]
shagster has quit
15:33:34 [Psychephylax]
So post back
15:33:37 [Psychephylax]
Hi Ola
15:33:55 [Psychephylax]
Post back with a solution to your problem this way if someone has a similar problem they might learn
15:34:09 [ola]
there should be an "unpost" option.
15:34:43 [shagster]
shagster has joined #openacs
15:35:06 [ola]
yes sir, but I want to wait out other possible solutions first:-)
15:36:40 [Psychephylax]
Well
15:36:47 [Psychephylax]
maybe not unpost but definetly an "edit"
15:37:45 [shagster]
shagster has quit
15:38:08 [ola]
two replies already...
15:38:14 [Psychephylax]
cool
15:38:44 [shagster]
shagster has joined #openacs
15:40:15 [shagster]
shagster has quit
15:40:44 [shagster]
shagster has joined #openacs
15:41:42 [davb]
ola: There is a difference between ON and USING
15:41:56 [davb]
but I have no idea what or if it matters for that query
15:43:48 [Psychephylax]
alrighty!
15:44:10 [Psychephylax]
hmmm
15:44:14 [Psychephylax]
this won't be fun
15:44:18 [davb]
of course not!
15:45:12 [Psychephylax]
no, I have to figure out how to make it so that only the people who you work for and you can edit your information
15:45:49 [davb]
that is a privilege (write) and a permission I think
15:47:00 [ola]
davb: both ways are fine but USING is less code.
15:47:16 [davb]
Interesting.
15:47:57 [ola]
see Don's and Gilbert's replys.
15:48:11 [ola]
replies
15:49:13 [davb]
ON a.blah = b.blah apparently is the same as using ( blah) with on you have to specify which column matches in each table so they could have different name. Using they have to have the same name.
15:49:14 [Psychephylax]
hmm
15:49:15 [Psychephylax]
ok, I got a question
15:49:29 [davb]
thats my new thing I learned today.
15:49:54 [davb]
and this : " A side-effect of both
15:49:54 [davb]
USING and NATURAL is that only one copy of each joined column is emitted into the result table (compare the
15:49:54 [davb]
relational-algebra definition of JOIN, shown earlier).
15:49:54 [davb]
"
15:51:14 [ola]
coolio
15:51:56 [Psychephylax]
This is more of a double check
15:52:12 [Psychephylax]
if I want to pass a variable from page A to page C
15:52:23 [Psychephylax]
wher A links to B first and B goes to C
15:52:24 [davb]
You just do the ad_permission_p on both pages.
15:52:29 [ola]
davb: on is good if the tables uses different keys
15:52:31 [Psychephylax]
I have to page_contract the variable in B
15:52:37 [Psychephylax]
and then pass it into C from B again?
15:52:47 [davb]
Thats what edit-this-page does.
15:53:03 [davb]
A and B are ADP pages?
15:53:12 [Psychephylax]
A,B,C are all ADP pages
15:53:16 [davb]
you need something like form_vars
15:53:26 [Psychephylax]
they're not form vars
15:53:29 [davb]
you set form_vars in the TCL scripts.
15:53:29 [shagster]
shagster has quit
15:53:35 [Psychephylax]
I have a user clicking on add or remove links for a user
15:53:52 [davb]
the you do @form_vars@ in the ADP page. It encodes them as hidden form fields
15:53:53 [Psychephylax]
I mean edit/remove
15:54:06 [Psychephylax]
They're already hidden sorta
15:54:15 [Psychephylax]
If the user hits edit I don't want the "delete" link showing up
15:54:23 [Psychephylax]
if he hits delete I don't want the edit
15:54:45 [shagster]
shagster has joined #openacs
15:54:47 [davb]
Oh. Ok. So the TCL page checks and sets a variable say display_edit_link
15:54:55 [davb]
then check for it in the ADP template.
15:54:57 [Psychephylax]
yes
15:55:14 [davb]
and you want to pass that around between the pages?
15:55:20 [Psychephylax]
but that page is like 3 pages inward from the page where you click on "edit/remove"
15:55:27 [davb]
hmmmm...
15:55:30 [Psychephylax]
so each page has to keep the state
15:55:35 [Psychephylax]
Hang on
15:55:39 [Psychephylax]
lemme try my idea :)
15:56:20 [davb]
ok
15:57:12 [Psychephylax]
Since you claim I know ACS now I should be able to figure it out
15:57:13 [Psychephylax]
hehehe
15:58:00 [rbm]
rbm has quit
16:02:13 [vinod]
vinod has joined #openacs
16:02:46 [davb]
heh
16:02:52 [davb]
Hi vinod!
16:03:00 [vinod]
hey dave!
16:03:15 [vinod]
what's new?
16:03:26 [Psychephylax]
Hey vinod!
16:03:42 [davb]
Not much. Sick kids all week so I had to stay home and haven't got much work done.
16:03:46 [vinod]
hey Psychephylax!
16:03:50 [vinod]
bummer
16:04:00 [davb]
Arthur's Preschool and Tonka Construction don't run in Linux.
16:04:11 [vinod]
:-)
16:04:13 [vinod]
..yet
16:04:21 [Psychephylax]
Hey, stupid question
16:04:25 [Psychephylax]
in a page contract
16:04:35 [Psychephylax]
I have the decode block listen for a "action"
16:04:51 [Psychephylax]
can it also have a property to return to adp of "action" or is that a scope problem?
16:05:36 [davb]
Don't know. Try it. If ad_page_contract doesn't like it, it will tell you.
16:05:46 [Psychephylax]
ok
16:06:05 [davb]
It should be OK. if action is defined. you should be able to change the value in the tcl code if you need to.
16:06:54 [markd2]
markd2 has joined #openacs
16:07:02 [Psychephylax]
hmmm
16:07:04 [Psychephylax]
Hey Mark
16:07:11 [ola]
does "acs_object_type__drop_type" take two arguments. if so, what are the second for?
16:07:53 [davb]
Psychephylax: see how easy it is to make it look like I actually know what I am talking about when I really am totally clueless!
16:07:54 [ola]
can't find it in the api-browser.
16:07:55 [markd2]
hiya
16:08:08 [davb]
hmmm.
16:08:37 [Psychephylax]
same here, not in the API
16:09:15 [Psychephylax]
uhmmm
16:09:20 [vinod]
ola: it's a cascade parameter. if 't', it's supposed to drop all types which are dependent on it (i think)
16:10:34 [vinod]
although looking at the code, it's completely ignored... (defined in packages/acs-kernel/sql/postgresql/acs-metadata-create.sql
16:10:57 [davb]
On the API browser go to acs-kernel then SQL files. You can search through the code to see how it really works.
16:11:39 [ola]
thanks vinod and dave!
16:11:51 [davb]
aD planned ahead. That is why there are so many 46 parameter functions.
16:11:53 [markd2]
oooh. vinod is in the haus too
16:11:58 [markd2]
shouldn't you be out saving lives, or something like that?
16:12:11 [davb]
vinod: you missed the outer join!
16:12:26 [vinod]
should, shouldn't - those are all very subjective terms
16:12:39 [vinod]
ugh - i hate outer joins :-)
16:12:41 [markd2]
subjunctive, too
16:12:49 [markd2]
help! I've got subjunctivitis!
16:13:01 [vinod]
hey, don't go grammar-school on me
16:13:06 [Psychephylax]
w00t
16:13:48 [ola]
vinod hates outer joins. then how does the rest of us feel about them;-)
16:14:13 [vinod]
haha - well, i love them once they're ported
16:14:20 [ola]
haha
16:15:07 [vinod]
so mark, how's java treating ya?
16:16:01 [Psychephylax]
i could use some java right about now
16:16:13 [markd2]
the project I was on fell through
16:16:21 [vinod]
doh! sorry to hear that
16:16:30 [markd2]
worked out best for both parties
16:16:45 [markd2]
so I'm taking advantage of my "on the bench time" do get more oracle studliness
16:16:56 [Psychephylax]
hehe
16:16:57 [markd2]
Right now I'm reading a wacky book on Backup & Recovery
16:16:58 [Psychephylax]
Oh
16:17:07 [Psychephylax]
I had a test on Databases yesterday
16:17:14 [davb]
THere is WHOLE book on backup?
16:17:27 [davb]
There's like 2 paragraphs for Postgresql.
16:17:28 [Psychephylax]
My oracle l33tness helped me I think
16:17:29 [markd2]
this one is 688 pages
16:18:10 [Psychephylax]
We had to draw an E-R diagram of items with like 5 properties and a relation stored and another entity shelf which had 2 properties
16:18:16 [davb]
Ah, a small Oracle book.
16:18:17 [Psychephylax]
Then convert that to a schema
16:18:26 [markd2]
yeah. with large type
16:18:34 [Psychephylax]
I am not sure if my syntax was correct
16:19:20 [markd2]
did you use boxes and lines?
16:20:17 [Psychephylax]
yes
16:20:17 [Psychephylax]
and ovals
16:20:24 [Psychephylax]
Well, not for the schema
16:20:32 [Psychephylax]
cuz he wanted us to create tables out of tose
16:20:43 [Psychephylax]
Is this valid
16:20:47 [markd2]
oooh.. ovals
16:20:54 [markd2]
the sophisticated ER tools
16:21:08 [markd2]
I dropped out before we hit the parallelograms
16:21:09 [markd2]
* markd2 shudders
16:21:10 [Psychephylax]
constraint validshelf check (size=100 OR size=150)
16:21:21 [markd2]
I think those are for the transverse normal form
16:21:36 [Psychephylax]
parallelograms are relations :P
16:22:59 [Psychephylax]
hmmm
16:23:00 [Psychephylax]
I see
16:23:05 [Psychephylax]
passthrough_parameters
16:23:09 [Psychephylax]
Need to figure out what this does
16:37:58 [john]
john has joined #openacs
16:38:43 [john]
does anyone know how to port plsql output parameters to pgplsql?
16:39:54 [ola]
john: see: http://www.brasileiro.net/postgres/porting/
16:40:13 [john]
I've read it three times. Nothing about output parameters
16:40:48 [ola]
ok. sorry I don't know much..
16:41:19 [john]
that is the best doc I've found on pgplsql ... you'd think there'd be something more comprehensive somewhere
16:41:34 [Psychephylax]
welcome to the wonderful world of ACS development
16:41:38 [john]
lol
16:41:43 [Psychephylax]
where nobody knows anything
16:41:56 [davb]
There are no output parameters in pl/pgsql I think.
16:41:59 [Psychephylax]
Well, Mark knows oracle
16:42:19 [Psychephylax]
* Psychephylax gives Mark a cookie
16:43:15 [john]
davb - I think you're right. I was hoping someone would say otherwise.
16:43:25 [john]
In the acs-worfklow module, there are lots of comments that say
16:43:31 [john]
TODO: output parameters
16:43:31 [chump]
Label TODO not found.
16:43:57 [Psychephylax]
hehe
16:44:02 [john]
I assume that means it's not straightforward, but my pgsql experience is measured in days.
16:44:02 [Psychephylax]
A:
16:44:02 [chump]
http://www.blooberry.com/indexdot/html/topics/urlencoding.htm
16:44:03 [chump]
All you ever wanted to know about URL Encoding
16:44:04 [chump]
(Psychephylax) Now with it's own converter!
16:45:35 [davb]
I don't have too much experience either. too bad rbm is not around.
16:46:45 [ola]
so, what could this be:
16:46:46 [ola]
psql:mp3jukebox-create.sql:30: ERROR: Function 'acs_object_type__create_type(unknown, unknown, unknown, unknown, unknown, unknown)' does not exist
16:46:46 [ola]
Unable to identify a function that satisfies the given argument types
16:46:47 [ola]
You may need to add explicit typecasts
16:47:47 [davb]
ola: go back in the log a little farther and see what values the function is getting.
16:47:57 [Psychephylax]
what's this mean: {passthrough ""} in a page_contract?
16:48:12 [davb]
Also, the parameters must be in order. They usually are not becuase Oracle takes named parameters.
16:49:09 [john]
I just looked up the definition for that function. It looks like it takes 10 args, not 8
16:49:23 [john]
fill in the missing ones, should work
16:49:45 [davb]
Yeah. if there are defaults you need to fill them in. Postgresql cannout have default parameters.
16:49:54 [davb]
In the oracle they are probably left out.
16:51:51 [Psychephylax]
EUREKA!
16:51:58 [Psychephylax]
I got it to pass the action!
16:54:27 [davb]
cool!
16:55:41 [Psychephylax]
yeah
16:55:43 [Psychephylax]
I fscking rule
16:55:44 [Psychephylax]
lol
16:58:51 [ola]
yes! thanks davb and john. 10 args not 6.
16:59:14 [Psychephylax]
hehe
17:00:41 [davb]
ola: np. you will see that ALOT in porting.
17:00:54 [ola]
cool!
17:03:51 [Psychephylax]
where was that Expr thing on the web?
17:03:59 [Psychephylax]
I gots to find out how to compare stings again hehe
17:04:34 [vinod]
john: the pg docs suggest that you can create a function with a return type of 'setof' that lets you return multiple params in a set. it doesn't give examples though
17:04:38 [vinod]
http://www.postgresql.org/idocs/index.php?sql-createfunction.html
17:04:38 [chump]
B: http://www.postgresql.org/idocs/index.php?sql-createfunction.html from vinod
17:05:45 [vinod]
B:| PG docs for 'create function'
17:05:45 [chump]
titled item B
17:08:55 [davb]
Psychephylax: http://www.aolserver.com/docs/
17:09:54 [Psychephylax]
gracias
17:10:51 [davb]
np
17:11:11 [davb]
It is the easier place to find Tcl docs. Also Tcl for web nerds is handy.
17:11:46 [Psychephylax]
yeah
17:11:48 [Psychephylax]
I like that page
17:11:50 [Psychephylax]
i bookmarked it
17:11:55 [vinod]
vinod has quit
17:12:42 [davb]
plus it has the AOLserver tcl api stuff which is handy.
17:13:36 [ola]
woohoo! no errors when I load the datamodel.
17:13:50 [davb]
great!
17:15:18 [Psychephylax]
heh
17:15:28 [Psychephylax]
I'm having so much fun torturing one of my old x-friends
17:16:49 [davb]
hmmmm
17:18:23 [Psychephylax]
it's a long story that I prefer not to have logged :)
17:18:29 [davb]
does anyone know if AOLserver sends a user-agent when it does an HTTP GET or POST?
17:18:34 [davb]
k
17:19:38 [Psychephylax]
if {[action == "edit"]} {
17:19:43 [Psychephylax]
it's telling me that's not valid
17:19:49 [markd2]
you can have stuff not be logged by prepending "#" to the line
17:19:51 [davb]
action s/b $action?
17:20:03 [markd2]
lose the square brackets
17:20:07 [davb]
that too.
17:20:29 [Psychephylax]
oh
17:20:30 [Psychephylax]
right on
17:20:51 [markd2]
davb: check out $NS_HOME/modules/tcl/http.tcl
17:21:05 [davb]
cool.
17:21:22 [davb]
Aha!
17:21:35 [davb]
I am using util_httppost. it sets it to Mozilla 1.01
17:23:10 [ola]
psyche: you should use [string_compare $action "edit"] instead.
17:24:51 [Psychephylax]
Is there an advantage?
17:25:22 [markd2]
if $action is a number, you'l get an error
17:26:17 [Psychephylax]
well, it's hardcoded it can only be remove or edit
17:26:28 [Psychephylax]
users can't choose :)
17:28:43 [Psychephylax]
hmmm
17:28:57 [Psychephylax]
I would like to hide the url stuff later
17:29:14 [john]
john has quit
17:34:37 [vinod]
vinod has joined #openacs
17:34:50 [Psychephylax]
wb
17:36:26 [Psychephylax]
aha
17:36:43 [ola]
vinod: I found something I think should be changed in "A Day in the Life of a Porter"
17:38:25 [vinod]
vinod has quit
17:38:52 [davb]
Woah! you scared him away!
17:38:58 [Psychephylax]
lol
17:39:07 [ola]
darn.
17:42:12 [markd2]
markd2 has quit
17:49:36 [Psychephylax]
alrighty
17:49:55 [Psychephylax]
I think I'm in alpha of my User interface
17:51:02 [Psychephylax]
now I have to figure out all this extra permissions stuff
17:52:54 [ola]
go gadget, go!
17:53:32 [Psychephylax]
heh
17:53:37 [Psychephylax]
I guess this is the hard part
17:53:39 [Psychephylax]
:(
17:54:02 [Psychephylax]
not only that
17:54:12 [Psychephylax]
I'm not sure if my tables are right
17:55:23 [rbm]
rbm has joined #openacs
17:56:16 [Psychephylax]
hey roberto
17:56:17 [ola]
hi.
17:56:35 [davb]
Psychephylax: the datamodel?
17:56:41 [davb]
or HTML tables?
17:57:22 [Psychephylax]
datamodel
17:57:30 [Psychephylax]
I had to add 3 more tables
17:57:35 [Psychephylax]
CM_PINGS
17:57:37 [Psychephylax]
CMTS_PINGS
17:57:43 [Psychephylax]
EMPLOYEE_HIERARCHY
17:57:50 [davb]
Ok.
17:58:02 [Psychephylax]
But I am not sure if I need to register any of them with Oacs
17:58:17 [Psychephylax]
I think I might have to with EMP_H
17:58:22 [davb]
I don't think so. They are for your application. As long as your code knows about them.
17:58:43 [davb]
OACS doesn't care who is whose boss.
17:58:59 [Psychephylax]
Yeah but I'm gonna have to check things like: Is the current user able to update this persons data?
17:59:00 [ola]
heh
17:59:34 [davb]
Oh. right like you said only someones boss can edit thier data.
17:59:52 [davb]
YOu should probably model that in the OACS user/group structure somehow.
17:59:52 [Psychephylax]
Yyes
18:00:01 [Psychephylax]
well
18:00:04 [Psychephylax]
I sort of did
18:00:05 [Psychephylax]
lol
18:00:21 [Psychephylax]
ACS knows there are Managers and Supervisors
18:00:35 [Psychephylax]
but it only allows for these types of constraints:
18:00:38 [davb]
Right. You almost need a group for EACH manager/supervisot.
18:00:42 [Psychephylax]
All managers can edit all regular users
18:00:50 [Psychephylax]
yeah
18:00:54 [davb]
DISCLAIMER: davb has no idea what he is talking about.
18:00:54 [chump]
Label DISCLAIMER not found.
18:00:58 [Psychephylax]
it would be Manager A group
18:01:02 [Psychephylax]
No, you're right
18:01:23 [Psychephylax]
I would have to create a new relation for every new Manager and Supervisor
18:01:28 [davb]
Well you can have the ALL managers permissions and the individual manager permissions.
18:01:31 [Psychephylax]
and then users would hae to go to that
18:01:45 [Psychephylax]
It would be too complex to code I think
18:01:45 [davb]
I think your type of application is exactly why the permission system is so complex.
18:01:55 [Psychephylax]
lol
18:02:00 [davb]
Isn't that what the group relationships stuff is?
18:02:06 [Psychephylax]
yah
18:02:11 [Psychephylax]
I would have to do this
18:02:12 [davb]
Most web sites have a webmaster and maybe a content editor or two.
18:02:19 [Psychephylax]
yeah
18:02:41 [Psychephylax]
Groups types: Manager, Supervisor, User
18:02:58 [Psychephylax]
Groups: Manager (manager type), Supervisor (supervisor type), USer (main site user)
18:03:50 [Psychephylax]
Sub Group Manager: John Smith (of Manager type)
18:04:03 [Psychephylax]
Then if he creates a user they work under him
18:26:25 [markd2]
markd2 has joined #openacs
18:26:46 [rbm]
Anybody has libclntsh.so to mail to me please? (it's the oracle client library)
18:28:22 [markd2]
what platform / version?
18:28:32 [rbm]
Linux. 8i should do
18:28:38 [markd2]
8.1.6 or 8.1.7?
18:28:45 [rbm]
Hmmm. good question
18:28:45 [markd2]
lemon or tuna flavored?
18:29:03 [markd2]
I'll put 'em both up
18:29:17 [rbm]
If you could mail both, that gets rid of the possibility of me having to nag you again :-)
18:29:39 [rbm]
Stupid Oracle! Why not release a tarball jusst with the client libs?!??!
18:30:06 [rbm]
BTW, tune with a touch of lemon please :)
18:30:46 [davb]
Oracle has to keep up their minumum pain factor.
18:31:32 [rbm]
markd2: Thanks a zillion!
18:31:38 [markd2]
m'pleasure
18:31:54 [markd2]
find out where Psychephylax gets his cookies. They're pretty good
18:32:37 [markd2]
now to dismantle my PC and see what's wrong with the network card
18:33:02 [rbm]
AaronSw: Wha??
18:49:52 [rbm]
Hmmm, someone please remind me how to convert a cpio file to a .tgz?
18:50:12 [rbm]
<-- thinks RPM is an ugly hack
18:50:50 [markd2]
expand the cpio, then tar it up?
18:50:53 [markd2]
* markd2 grins weakly
18:52:12 [ola]
please help me port this:
18:52:18 [rbm]
markd2: No...
18:52:34 [ola]
FIX ME PLSQL
18:52:34 [ola]
begin
18:52:34 [ola]
:1 := mp3_playlist__vote_cast (
18:52:34 [ola]
mp3_id => :mp3_id,
18:52:34 [ola]
playlist_id => :playlist_id,
18:52:34 [ola]
user_id => :user_id,
18:52:36 [ola]
vote_date => current_timestamp,
18:52:36 [rbm]
how do you expand the cpio (I guess you're right)
18:52:38 [ola]
vote => :vote_num
18:52:40 [ola]
);
18:52:42 [ola]
end;
18:53:42 [Psychephylax]
heh
18:53:52 [Psychephylax]
who registers a domain called agentpp
18:54:38 [davb]
ola: select mp3_playlist__vote_cast ( params )
18:54:58 [rbm]
ola: db_exec_plsql will do create an inline function for you. Just call db_exec_plsql (with the appropriate PG function syntax) and assign the result to :1 (there's a switch if I am not mistaken)
18:55:23 [rbm]
OH, I saw something different. davb is right
18:55:41 [davb]
I never would have believed it.
18:55:41 [rbm]
* rbm twacks self for thinking the hard way
18:55:48 [davb]
Sometimes it is easier in Postgresql than oracle.
18:55:49 [ola]
aha, thanks.
18:56:55 [gilbertw]
gilbertw has joined #openacs
18:58:01 [ola]
do I need the begin-end stuff?
18:58:03 [rbm]
Almost time for my very (Yawwwwwnnn) exciting class.
18:58:08 [rbm]
no
18:58:13 [ola]
heh
18:58:18 [ola]
thanks
18:58:40 [rbm]
Same professor of last semester's mega-lame (tm) class
18:59:53 [rbm]
* rbm wonders why all P2 lab computers were replaced with P3s with 500 Mb of RAM when all 99% of the students do is read their Yahoo/Hotmail mail and use AIM/MSN Messenger.
18:59:53 [gilbertw]
gilbertw has quit
19:00:31 [rbm]
So?
19:00:39 [markd2]
Gotta get them buzzwords in
19:00:50 [davb]
Just amusing
19:01:19 [ola]
does this look ok:
19:01:21 [ola]
<querytext>
19:01:22 [ola]
select mp3_playlist__vote_cast (
19:01:22 [ola]
:mp3_id,
19:01:22 [ola]
:playlist_id,
19:01:22 [ola]
:user_id,
19:01:22 [ola]
current_timestamp,
19:01:24 [ola]
:vote_num
19:01:26 [ola]
);
19:01:28 [ola]
19:01:30 [ola]
</querytext>
19:01:34 [ola]
?
19:02:02 [rbm]
Yeah. I'm worried about the assignment to ":1" though
19:02:19 [ola]
ok.
19:02:44 [davb]
ola: what does the Tcl that calls it look like?
19:02:46 [ola]
share your worries...:-)
19:02:59 [davb]
* davb has been wrong before
19:03:09 [ola]
wait...
19:03:43 [rbm]
"But WAIT! Call now and receive a free foobar! A $50 value absolutely free!"
19:03:59 [ola]
davb: like this:
19:04:01 [ola]
db_exec_plsql vote_cast "
19:04:01 [ola]
begin
19:04:01 [ola]
:1 := mp3_playlist.vote_cast (
19:04:01 [ola]
mp3_id => :mp3_id,
19:04:01 [ola]
playlist_id => :playlist_id,
19:04:02 [ola]
user_id => :user_id,
19:04:04 [ola]
vote_date => sysdate,
19:04:06 [ola]
vote => :vote_num
19:04:08 [ola]
);
19:04:10 [ola]
end;
19:04:12 [ola]
"
19:04:29 [davb]
So it doesn't return the value to a Tcl variable?
19:05:36 [ola]
no. I don't think so. it's inside a catch statement, though.
19:06:01 [davb]
OK.
19:07:53 [ola]
hmm... the plpgsql proc returns "v_l_vote_sum".
19:08:15 [ola]
mp3_playlist__vote_cast that is.
19:08:53 [rbm]
look at the syntax for db_exec_plsql. There's a return switch IIANM
19:10:38 [Psychephylax]
ugh!
19:10:52 [Psychephylax]
It would be nice to have something in the readme on how to compile the library
19:10:55 [rbm]
* rbm curses cpio
19:11:21 [Psychephylax]
* Psychephylax curses C3PO
19:12:12 [Psychephylax]
ummm
19:12:21 [Psychephylax]
there's a Makefile.solaris
19:12:28 [Psychephylax]
but no way to start it compiling
19:12:41 [rbm]
Get R2D2. He's smarter.
19:12:55 [markd2]
"and r2d2 said 'weeeeeeeeeeeeeee.... bleep!'"
19:13:12 [Psychephylax]
heh
19:13:52 [rbm]
* rbm now feels like watching Star Wars
19:14:04 [Psychephylax]
sigh
19:14:05 [Psychephylax]
ok
19:14:11 [Psychephylax]
this wants a cc compiler and I have gcc
19:14:20 [markd2]
that's ok
19:14:23 [markd2]
alias cc gcc
19:14:46 [markd2]
or there may be a makefile tweak to change your CC var to be gcc
19:15:13 [Psychephylax]
yeah
19:15:15 [Psychephylax]
i did that
19:15:17 [Psychephylax]
change cc to gcc
19:15:22 [Psychephylax]
It still bombs out
19:15:33 [rbm]
* rbm gives up and grabs a source file
19:15:36 [ola]
rbm: how about: select mp3_playlist__vote_cast (blargh) into :1 ?
19:15:43 [rbm]
Nope
19:15:55 [ola]
okay.
19:15:55 [Psychephylax]
cc1plus: Invalid option `t'
19:16:16 [rbm]
At least I don't think that would work (unless the driver is handling such cases, which I doubt)
19:16:27 [Psychephylax]
Mark, solaris 2.6 is Pre-SunOS what?
19:16:37 [Psychephylax]
or is it post
19:16:41 [davb]
Postgres doesn't have PL/SQL, of course, but it does have PL/pgSQL and
19:16:41 [davb]
other procedural languages. Rather than assign the result to a bind variable which is then returned to the caller, the Postgres version of
19:16:41 [davb]
OpenACS requires the caller to perform a select query that returns
19:16:41 [davb]
the value of the function.
19:16:41 [davb]
We are no longer calling db_string, which screws up the bind variable
19:16:43 [davb]
stuff otherwise because of calling environments. (ben)
19:18:31 [rbm]
Oh crap
19:18:36 [rbm]
* rbm goes to class
19:18:43 [markd2]
Solars 2.6 is SunOS 5.6
19:18:53 [markd2]
so it's Solaris-new-improved land
19:20:01 [Psychephylax]
So, if I have SunOS 5.7
19:20:08 [Psychephylax]
Can I still compile stuff for 5.6?
19:20:25 [davb]
ola: what tcl file are you in?
19:20:40 [markd2]
usually it works the other way around
19:20:47 [markd2]
stuff compiled on 5.6 runs on 5.7
19:20:52 [markd2]
but it's worth a try
19:21:11 [Psychephylax]
no no
19:21:13 [Psychephylax]
I have the source
19:21:20 [Psychephylax]
but it says it's Solaris 2.6
19:21:29 [Psychephylax]
I need to compile it for SunOS 2.7
19:21:35 [markd2]
not a problem
19:21:43 [markd2]
I doubt it says SunOS 2.7. it's probably solaris 2.7
19:21:56 [markd2]
if it says sunos 2.7, and was written in the last 10 years, it's solaris 2.7
19:22:56 [Psychephylax]
No, it says Solaris 2.6
19:23:05 [Psychephylax]
but uname -a says SunOS 5.7
19:23:19 [markd2]
then you're fine
19:23:23 [markd2]
Solaris 2.6 == SunOS 5.6
19:23:28 [Psychephylax]
Not if I can't get it compiled :P
19:28:15 [Psychephylax]
wait a second
19:28:22 [Psychephylax]
cc is a c compiler or a c++ compiler?
19:28:28 [markd2]
C
19:28:33 [ola]
davb: mp3jukebox/www/vote.tcl
19:29:53 [Psychephylax]
k
19:30:21 [Psychephylax]
i have no fscking idea
19:30:37 [davb]
I think the :1 is a dummy variable.
19:32:12 [ola]
oh. maybe I don't have to worry about it..
19:34:38 [Psychephylax]
ok
19:34:40 [Psychephylax]
I have no clue
19:34:51 [Psychephylax]
so I'm open to suggestoins
19:35:44 [Psychephylax]
Do I have to go get the SPROcc package installed on the solaris box?
19:35:50 [davb]
ola that seems to count the number of times someone tries to vote.
19:35:53 [markd2]
gcc should work ok
19:35:56 [markd2]
how is it failing?
19:36:16 [Psychephylax]
it's telling me it doesn't know what -t is
19:36:27 [markd2]
"it"?
19:37:14 [Psychephylax]
$ make
19:37:14 [Psychephylax]
gcc -mt -D_XPG4_EXTENDED -Dsun -D__unix -I../include -I./ -g -pta -o address.o -c address.cpp
19:37:14 [Psychephylax]
gcc: unrecognized option `-pta'
19:37:14 [Psychephylax]
cc1plus: Invalid option `t'
19:37:14 [Psychephylax]
make: *** [address.o] Error 1
19:37:46 [ola]
ok. now this: FIX ME ROWNUM ???
19:38:30 [ola]
* ola searches the openacs forum
19:39:19 [markd2]
guess you're out of luck
19:39:32 [davb]
ola see this: set folder_id [db_exec_plsql create_new_folder {
19:39:32 [davb]
begin
19:39:32 [davb]
:1 := static_page.new_folder (
19:39:32 [davb]
name=> :directory,
19:39:32 [davb]
label=> :directory,
19:39:32 [markd2]
try seeing if there are any porting note out on the net to gcc for whatever software package this is
19:39:35 [davb]
parent_id=> :parent_folder_id,
19:39:35 [davb]
description=> 'Static pages folder'
19:39:36 [davb]
);
19:39:38 [davb]
end;
19:39:40 [davb]
}]
19:39:56 [davb]
it sets folder_id to the value returned by the pl/sql function.
19:40:08 [Psychephylax]
Mark any ideas?
19:40:26 [davb]
Yours is just throwing away the result.
19:40:38 [markd2]
the flags its passing aren't compatible with gcc
19:40:48 [markd2]
so either get the sun for-pay compiler, or troll the net for porting advice
19:41:13 [Psychephylax]
You mean go ask my boss to install the package that has cc in it?
19:41:18 [davb]
hmmmmm
19:41:45 [markd2]
yeah
19:42:07 [Psychephylax]
ok
19:42:08 [markd2]
if it's a popular piece of software, there may be a gcc port out there already
19:42:11 [Psychephylax]
brb
19:43:01 [ola]
davb: yeah. it should return the total vote sum.
19:44:27 [ola]
maybe it's someting strange ybos did.
19:44:34 [ola]
* ola ducks
19:45:12 [markd2]
* markd2 quacks
20:05:01 [Psychephylax]
ugh
20:05:07 [Psychephylax]
he didn't know either
20:05:55 [Psychephylax]
must find out what -t does in CC
20:06:06 [markd2]
what software is this?
20:06:18 [Psychephylax]
snmp++
20:06:23 [Psychephylax]
I need it for nssnmp
20:07:40 [davb]
Psychephylax: is that the AOLserver module?
20:08:51 [Psychephylax]
yeah
20:09:16 [davb]
Trying to integrate it with your package huh?
20:09:45 [Psychephylax]
yes
20:10:29 [davb]
hmmm.. good luck.
20:10:40 [Psychephylax]
heh
20:10:45 [Psychephylax]
my friend jsut told me what -t does
20:10:59 [davb]
cool.
20:11:05 [markd2]
whazzit dooz?
20:11:21 [davb]
* davb has to search for information in the ........ PHONE BOOK!!!
20:11:57 [Psychephylax]
it prints out the files as the linker processes them
20:12:02 [Psychephylax]
But it still does not solve my problem
20:12:22 [Psychephylax]
$ make
20:12:22 [Psychephylax]
gcc -mt -D_XPG4_EXTENDED -Dsun -D__unix -I../include -I./ -I../../libdes -g -pa -o address.o -c address.cpp
20:12:22 [Psychephylax]
gcc: unrecognized option `-pa'
20:12:22 [Psychephylax]
cc1plus: Invalid option `t'
20:12:22 [Psychephylax]
address.cpp: In method `int IpAddress::parse_dotted_ipstring(const char *)':
20:12:23 [Psychephylax]
address.cpp:446: implicit declaration of function `int strtok_r(...)'
20:12:25 [Psychephylax]
address.cpp:446: assignment to `char *' from `int' lacks a cast
20:12:27 [Psychephylax]
address.cpp:471: assignment to `char *' from `int' lacks a cast
20:12:29 [Psychephylax]
make: *** [address.o] Error 1
20:12:31 [Psychephylax]
$
20:12:35 [Psychephylax]
if i used Java I probably would have finished
20:13:43 [markd2]
so go use java
20:14:55 [Psychephylax]
yeah good luck convincing my boss to switch
20:15:29 [Psychephylax]
i guess I'll post on the bboard to that guy asking him what the hell he did to compile it
20:15:59 [markd2]
maybe he'll send you a binary if you give him a cookie
20:16:22 [Psychephylax]
maybe
20:17:15 [Psychephylax]
e-mail or post?
20:18:29 [markd2]
email
20:18:37 [markd2]
that way he won't be besieged by request for the binaries
20:19:00 [Psychephylax]
heh
20:19:10 [Psychephylax]
Well, I think he's russian I can encode my post in russian
20:19:11 [Psychephylax]
muahaha
20:26:49 [Psychephylax]
how's this:
20:26:52 [Psychephylax]
Hello,
20:26:52 [Psychephylax]
This is regarding your post on the OpenACS BB and your SNMP module for AOLServer.
20:26:52 [Psychephylax]
I have started trying to set up AOLServer so that I can do the SNMP part of my project, however, I am encountering some problems along the way. First question I have is regarding the version of SNMP++ you used for your module. I have tried compiling both 2.8 and 3.1 to no avail. Also, what operating system did you use to compile? I'm trying to use SunOS 5.7 and it does not have CC installed so I am trying to tell the makefiles to use gcc
20:27:15 [Psychephylax]
ugh
20:27:18 [Psychephylax]
stupid client
20:27:32 [markd2]
looks good to me
20:30:40 [Psychephylax]
oh
20:30:43 [ola]
ok. done with the first round
20:30:46 [Psychephylax]
forgot to ask him about the binder.c patch
20:30:51 [Psychephylax]
Any of you heard of it?
20:34:10 [davb]
ola: cool
20:34:24 [davb]
Psychephylax: you can use Java inside AOLserver
20:35:57 [Psychephylax]
?
20:36:07 [Psychephylax]
no, I would write a servlet
20:36:17 [davb]
OK. never mind then.
20:36:18 [Psychephylax]
Eh
20:36:25 [Psychephylax]
I'd figure out a way to get it to work
20:36:48 [ola]
I'm extra lousy dealing with RIGHT JOIN...
20:37:07 [davb]
Opposite of LEFT :)
20:37:12 [ola]
heh
20:37:43 [davb]
I have no idea how to figure out which is which.
20:38:00 [ola]
the bad news is that I don't exactly understand these outer joins.
20:38:01 [Psychephylax]
one is when you're taking stuff out of the RIGHT table
20:38:05 [Psychephylax]
and the other one is the left table
20:38:09 [Psychephylax]
afaik
20:38:47 [ola]
whats this.
20:39:08 [ola]
a page saying...MP3 Jukebox..
20:39:15 [ola]
:-)
20:39:38 [ola]
porting is fun.
20:40:07 [davb]
Java Servlets can be run in aolserver using the nstomcat module, see nstomcat
20:40:20 [davb]
http://www.cs.pub.ro/~gaburici/nstomcat/
20:40:20 [chump]
C: http://www.cs.pub.ro/~gaburici/nstomcat/ from davb
20:40:25 [davb]
C:|NS Tomcat
20:40:25 [chump]
titled item C
20:40:34 [davb]
C: Java Servlets in AOLserver
20:40:35 [chump]
commented item C
20:40:48 [Psychephylax]
yeah
20:41:04 [davb]
ola: what query?
20:41:06 [Psychephylax]
but that means I'd have to rewrite the whole user interface and the data model and so forth and so on etc
20:41:39 [davb]
Oh yeah. I thought you were think just about the SNMP stuff.
20:43:10 [Psychephylax]
no
20:43:18 [Psychephylax]
I would have done the whole thing in Java from scratch
20:43:35 [ola]
I have some problem with ROWNUM in this query:
20:43:51 [ola]
FIX ME ROWNUM
20:43:51 [ola]
select title, mp3_id, creation_date
20:43:51 [ola]
from (select title, mp3_id, creation_date
20:43:51 [ola]
from mp3_mp3s_not_deleted, acs_objects
20:43:51 [ola]
where mp3_id = object_id
20:43:51 [ola]
and creation_date > current_timestamp - 1
20:43:53 [ola]
order by creation_date desc)
20:43:55 [ola]
where rownum < 10
20:44:32 [davb]
I know somewhere this is something about porting ROWNUM.
20:46:06 [ola]
Dan Wickstrom talks about using LIMIT instead of ROWNUM...?
20:46:10 [davb]
I think you can use LIMIT 10
20:46:30 [ola]
I'll try.
20:47:46 [abbaJ]
abbaJ has quit
20:50:23 [ola]
davb: do you mean; where LIMIT 10 ?
20:51:27 [davb]
I think you can skip the WHERE
20:51:36 [davb]
rownum is a fake column.
20:51:55 [ola]
aha.
20:52:41 [davb]
http://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0000XF&topic_id=11&topic=OpenACS
20:52:41 [chump]
D: http://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0000XF&topic_id=11&topic=OpenACS from davb
20:52:56 [davb]
D:|Porting ROWRUM from Oracle to Postgresql thread on Openacs.Org
20:52:56 [chump]
titled item D
20:56:58 [ola]
cooooool! dave, it works.
21:00:16 [davb]
great!
21:03:46 [Psychephylax]
* Psychephylax twiddles thumbs
21:04:31 [Psychephylax]
i'm about to start looking at porn here
21:05:04 [ola]
[06/Oct/2001:01:06:22][2711.5125][-conn1-] Error: dbinit: error(localhost::openacs4,ERROR: Function 'mp3_playlist__new(unknown, unknown, unknown, unknown, unknown, timestamp, unknown)' does not exist
21:05:04 [ola]
Unable to identify a function that satisfies the given argument types
21:05:04 [ola]
You may need to add explicit typecasts
21:05:04 [ola]
): '
21:05:04 [ola]
select mp3_playlist__new(
21:05:05 [ola]
'7135',-- playlist_id
21:05:07 [ola]
'Ola',-- name
21:05:09 [ola]
'-3',-- remove_threshold
21:05:11 [ola]
'127.0.0.1',-- creation_ip
21:05:13 [ola]
'2215',-- creation_user
21:05:15 [ola]
current_timestamp,-- creation_date
21:05:17 [ola]
'7128'-- context_id
21:05:19 [ola]
);
21:05:36 [ola]
hmm..
21:06:27 [davb]
Is that one missing a couple parameters?
21:08:33 [ola]
there should be nine parameters.
21:10:58 [ola]
how come there are missing parans in the query?
21:11:14 [ola]
can oracle cope with that?
21:11:45 [ola]
s/parans/params
21:13:58 [davb]
defaults.
21:14:03 [davb]
( i think )
21:15:48 [rbm]
moo
21:18:20 [rbm]
* rbm 's brother is on a plane back to Brazil :-(
21:19:06 [ola]
question: can I use current_timestamp in place of now() ?
21:19:44 [ola]
* ola hopes the best for rbm's bro
21:22:40 [rbm]
ola: In 7.1, yes. In fact, you should.
21:23:29 [ola]
aha. why? :-)
21:24:21 [rbm]
Because it's part of SQL3.
21:24:37 [rbm]
(the standard). Hopefully other products will also adopt it soon.
21:25:23 [ola]
so now() is postgres specific, right?
21:25:48 [rbm]
yes.
21:25:59 [rbm]
Just like sysdate is to Oracle.
21:27:42 [ola]
thanks, rbm.
21:28:43 [rbm]
np
21:31:21 [Psychephylax]
i smell popcorn
21:32:02 [rbm]
buttery?
21:32:22 [Psychephylax]
very
21:32:30 [Psychephylax]
I think that's what's making it smell really tasty
21:33:16 [Psychephylax]
this is the exact error I'm getting: http://www.katz.dusnet.de/agent++Archiv/0107/0071.html
21:33:27 [Psychephylax]
Mark, you awake?
21:33:33 [Psychephylax]
* Psychephylax gives Mark a cookie
21:33:36 [markd2]
barely
21:33:39 [Psychephylax]
hehe
21:33:45 [Psychephylax]
Take a look at that
21:34:12 [Psychephylax]
It's a solution Makefile but I don't think it will work for be....because....it's for x86 and uses gmake
21:34:16 [markd2]
looks good
21:34:29 [Psychephylax]
i don't have gmake
21:34:29 [markd2]
gmake is easy to compile
21:34:38 [markd2]
and solarisx86 and solaris are nearly identical
21:34:45 [Psychephylax]
ok
21:34:49 [Psychephylax]
where can i get gmake?
21:34:49 [markd2]
the port of aolserver 2.3.3 to solaris x86 was literally a recompile
21:34:55 [markd2]
www.gnu.org
21:35:44 [Psychephylax]
* Psychephylax runs a find on the box to make sure it's definetly not installed
21:38:11 [abbaJ]
abbaJ has joined #openacs
21:40:11 [ola]
* ola gotta go
21:40:17 [rbm]
bye ola
21:40:34 [ola]
ola has quit
22:03:11 [markd2]
* markd2 puts his head back in the backup & recovery book
22:03:14 [markd2]
markd2 has quit
23:10:43 [docwolf]
docwolf has joined #openacs
23:10:57 [docwolf]
yo
23:26:44 [rbm]
hey Adam!
23:26:49 [rbm]
what's up?
23:27:23 [rbm]
moo anerd
23:27:27 [rbm]
roehuoeur
23:42:09 [docwolf]
hi
23:42:32 [docwolf]
anyone here a prize winner?
23:43:12 [rbm]
AaronSw is
23:43:23 [rbm]
Rats! mark is not here anymore
23:44:10 [docwolf]
d'oh
23:44:42 [docwolf]
i heard some horrible shit
23:44:51 [docwolf]
about their server
23:47:13 [docwolf]
right.. i've heard from a couple of people
23:47:17 [rbm]
docwolf: got Oracle in the machine you're in?
23:47:20 [docwolf]
that aD is taking them back
23:47:32 [docwolf]
nope. i'm oracle-free :-)
23:47:50 [rbm]
hmm
23:50:01 [docwolf]
i just wanted to confirm this
23:50:09 [docwolf]
so i could perhaps convey to the right people within the company
23:50:18 [docwolf]
that it's probably not a nice thing to do
23:50:31 [docwolf]
(hey, i'm a VC, and even I know _that_ .. )
23:51:28 [docwolf]
but.. i'm not sure that it's even true.
23:51:30 [docwolf]
so we'll see.
23:51:53 [rbm]
heheh
23:52:05 [rbm]
It would be a pretty low thing to do that.
23:52:10 [docwolf]
yeah