Yes, nsdb.so is what was needed.
Sample nsd.tcl config for AOLserver 4.0 with Oracle 9i under RH Linux 3ES
follows:
There is nothing special for 9i or RHL but there is for 4.0.
(This is based on AOLserver 3.4.2 and earlier. It may not be ideal or
complete for 4.0
or for what you want to do but it does work.)
#
# Oracle database driver, with three pools
#
ns_section "ns/db/drivers"
# The ArsDigita Oracle driver, 2.6 rev 1.10
ns_param ora8 ${bindir}/ora8.so
ns_section "ns/db/pools"
ns_param main "Main Pool"
ns_param log "Log Pool"
ns_param subquery "Subquery Pool"
ns_section "ns/db/pool/main"
ns_param driver ora8
ns_param datasource {}
ns_param user scott
ns_param password yourpass
ns_param connections 5
ns_param logsqlerrors true ;# Verbose SQL query error logging
ns_param verbose false ;# Verbose error logging
ns_param maxidle 600 ;# Max time to keep idle db conn open
ns_param maxopen 3600 ;# Max time to keep active db conn open
ns_section "ns/db/pool/log"
ns_param driver ora8
ns_param datasource {}
ns_param user scott
ns_param password yourpass
ns_param connections 5
ns_param logsqlerrors true ;# Verbose SQL query error logging
ns_param verbose false ;# Verbose error logging
ns_param maxidle 600 ;# Max time to keep idle db conn open
ns_param maxopen 3600 ;# Max time to keep active db conn open
ns_section "ns/db/pool/subquery"
ns_param driver ora8
ns_param datasource {}
ns_param user scott
ns_param password yourpass
ns_param connections 2
ns_param logsqlerrors true ;# Verbose SQL query error logging
ns_param verbose false ;# Verbose error logging
ns_param maxidle 600 ;# Max time to keep idle db conn open
ns_param maxopen 3600 ;# Max time to keep active db conn open
#
# Accessing DB pools
#
ns_section "ns/server/${servername}/db"
ns_param pools * ;# Wildcard gives access to all
ns_param defaultpool main
#
# Modules to load
#
ns_section "ns/server/${servername}/modules"
ns_param nssock ${bindir}/nssock.so
ns_param nsdb ${bindir}/nsdb.so ;# New for AOLserver 4.0
Successful start of nsd with the config above logs (or displays, if -f)
these lines:
...
[-main-] Notice: modload: loading '/opt/aolserver/aolserver40/bin/nssock.so'
[-main-] Notice: modload: loading '/opt/aolserver/aolserver40/bin/nsdb.so'
[-main-] Notice: modload: loading '/opt/aolserver/aolserver40/bin/ora8.so'
[-main-] Notice: ora8 driver LobBufferSize = 16384
[-main-] Notice: ora8 driver PrefetchRows = 0
[-main-] Notice: ora8 driver PrefetchMemory = 0
[-main-] Notice: Loaded ArsDigita Oracle Driver version 2.6, built on
20:31:16/Feb 2 2004
...
At 01:54 PM 2/4/04 -0700, you wrote:
>> I copied the lines for nsd.tcl from a version I am running
>> successfully
>> under Solaris 7 with AOLserver 3.4.2 and Oracle 8.1.7
>
>Under 4.0 you need to load the nsdb.so module.
>
>--cro
Eric Lee
[EMAIL PROTECTED]
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of
your email blank.
