Re: [AOLSERVER] TDS database driver for AOLserver

2001-05-07 Thread Ian Harding

I am a volunteer for testing against SQL Server 7, as of right now it is service pack 
free, although I will apply them if required...



Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: [EMAIL PROTECTED]

 [EMAIL PROTECTED] 05/05/01 07:40PM 
In case anyone wants to keep track of my progress with the
nsfreetds driver, here's its page on the AOLserver Wiki:

  http://panoptic.com/wiki/aolserver/nsfreetds

Are there folks out there who would volunteer to do some
initial beta testing?

Also, Kris or Jim -- would it be okay for me to check this into
the CVS tree?  Or, is it something you'd rather keep separate?

- Dossy

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



Re: [AOLSERVER] Has server.log rolling ever worked?

2001-05-07 Thread Ian Harding

Thanks for the tip, I will try it on my NetBSD installation.  The one I have the big 
log on is Win32 thought.  However, that problem is scheduled to be overcome by other 
events.

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: [EMAIL PROTECTED]

 [EMAIL PROTECTED] 05/05/01 10:38AM 
 Yikes!  My server.log is 250 MB!  However, access.log is rolling nicely.

I recommend running aolserver under daemontools (instead of inittab),
using the -f flag (foreground mode, with the server log going to
stderr), and using multilog (from the daemontools package) to write the
server log to disk.  With multilog, you say how many files of server log
to keep, and how to big let each file get.  It rolls the logs based on
size instead of time.  Thus you never have to worry about your server
log growing to 250 MB unless you meant to let it get that big.

http://cr.yp.to/daemontools.html



Re: [AOLSERVER] TDS database driver for AOLserver

2001-05-07 Thread Dossy

On 2001.05.07, Ian Harding [EMAIL PROTECTED] wrote:
 I am a volunteer for testing against SQL Server 7, as of right now it
 is service pack free, although I will apply them if required...

It doesn't seem as though the service pack is actually required.
Jerry Asher has both SQL7 with and without the SP2, and both seem
to work just fine.

What's the easiest way for people to volunteer for testing?  Can
everyone do anonymous CVS?  Should I put snapshots of my CVS up
somewhere?

- Dossy

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



[AOLSERVER] Objectifying AOLserver

2001-05-07 Thread Kris Rehberg

We're looking for someone who can quickly and accurately change all the data
types in AOLserver from strings to Tcl_Objects.  Any takers?

Kris



Re: [AOLSERVER] Objectifying AOLserver

2001-05-07 Thread Rob Mayoff

Are you offering to pay for this work?

 We're looking for someone who can quickly and accurately change all the data
 types in AOLserver from strings to Tcl_Objects.  Any takers?



Re: [AOLSERVER] Oracle driver problem

2001-05-07 Thread Ling Wang

You are one of the few I ever heard that is using AOLServer+Oracle on Win32.
I posted so many messages asking who knows how to make it work. I still
don't know how to make it work. Where did you get your Win32 AOLServer and
Oracle driver with what version? I am running a WinNT4.0 and a couple of
people helped me some what without any success.

Good luck.

Ling Wang

From: Barry Books [EMAIL PROTECTED]
Reply-To: AOLserver Discussion [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [AOLSERVER] Oracle driver problem
Date: Mon, 7 May 2001 16:54:22 -0500

Hello,

I'm working on an Oracle driver problem and I'm curious if anyone else has
seen it. I'm running the win32 version 2.4 driver with Oracle 8.1.6 on NT
(client and server)

The problem is if I try and update a column with a clob greater that 64k I
get

[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4538:unknown:
  ns_ora clob_dml:  binding variable xml
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4538:unknown:
  ns_ora clob_dml:  binding variable transaction_id
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4538:unknown:
  ns_ora clob_dml:  binding variable 1
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:4543:unknown:
  bind variable 1 is a lob
[07/May/2001:16:16:29][610.601][-conn0-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:2763:unknown:
  entry
[07/May/2001:16:16:29][610.601][-conn0-] Error: SQL():
H:\src\aD\root\oracle-driver\ora8.c:4601:unk
nown: error in `OCIStmtExecute ()': ORA-01480: trailing null missing from
STR bind value

SQL:
 update bv_transactions
 set transaction = :xml
 where transaction_id = :transaction_id
 returning transaction into :1


At first I thought I had not set LobBufferSize but the logs contain:

[07/May/2001:16:02:07][610.218][-main-] Notice: modload: loading
'd:/acs/aol32/bin/ora8.dll'
[07/May/2001:16:02:07][610.218][-main-] Notice: ora8 driver LobBufferSize =
50
[07/May/2001:16:02:07][610.218][-main-] Notice:
H:\src\aD\root\oracle-driver\ora8.c:920:unknown: e
ntry (hdriver 00417640, config_path ns/db/driver/ora8)
[07/May/2001:16:02:07][610.218][-main-] Notice: Loaded ArsDigita Oracle
Driver version 2.4, built on
  16:05:38/Nov 14 2000

The config section:

ns_section ns/db/driver/ora8
ns_param Debug true
ns_param LobBufferSize 50

All of this would not be so bad but when this happens the Oracle instance
quits without even putting anything in the event log

The dml statement is:
 db_dml update_trans {
 update bv_transactions
 set transaction = :xml
 where transaction_id = :transaction_id
 returning transaction into :1
 } -clobs [list $xml]

Has anyone else seen this?

Thanks
Barry

_
Get your FREE download of MSN Explorer at http://explorer.msn.com



Re: [AOLSERVER] nsopenssl version 1.1 released

2001-05-07 Thread Jerry Asher

Tom Ivar Helbekkmo writes:

 Maybe I'm being stupid here, but I can't figure out how to ensure that
 a given page is accessed only using SSL.  I'd like to enforce this for
 pages containing sensitive data.

[ns_conn driver] will tell you if it's nssock/nsssl/nsopenssl, etc., and you
can write some logic to redirect nssockies to your https port.

Jerry