Hi Scott..
here is my nsd.tcl which some of part is deleted and changed :-)
*********************************************
# $Header: /cvsroot/aolserver/aolserver3/scripts/nsd.tcl,v 1.12 2000/04/12
15:52:37 kriston Exp $
#
# nsd.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 "nsd.tcl: starting to read config file..."
#
# Set some Tcl variables that are commonly used throughout this file.
#
set httpport 80
set httpsport 443
set hostname www.foo.com
set address bla.. bla...
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 home.html,home.htm,index.adp,index.html,index.htm
# nsssl: Only loads if keyfile.pem and certfile.pem exist.
set sslkeyfile
${homedir}/servers/${servername}/modules/nsssl/keyfile.pem
set sslcertfile
${homedir}/servers/${servername}/modules/nsssl/certfile.pem
........
#
# Global server parameters
#
ns_section "ns/parameters"
ns_param home $homedir
ns_param debug true
ns_param enableadmin false
ns_param StackSize 1500000
# Miscellaneous
ns_param checkexitcode false ;# Check exit code on forked process
ns_param crashcmd ns_crash ;# A Tcl command that dumps core.
ns_param mailhost smtp.foo.com ;# SMTP host for ns_sendmail
#
# 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 for hungry C
modules.
#
# 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 urlstats true ;# Enable URL statistics
ns_param maxurlstats 1000 ;# Max number of URL's to do stats on
ns_param enabletclpages false ;# Parse tcl files in pageroot
(dangerous)
# Directory listings -- use an ADP or a Tcl proc to generate them.
#ns_param directoryadp $pageroot/dirlist.adp ;# Choose one or the other
#ns_param directoryproc _ns_dirlist ;# ...but not both!
#ns_param directorylisting simple ;# Can be simple or fancy
#
# Tcl interpreter
#
ns_section "ns/server/${servername}/tcl"
ns_param autoclose true ;# Close files the Tcl interp opened
ns_param debug false ;# Names of files sourced is logged
ns_param nsvbuckets 8 ;# No. of buckets to hold nsv's
ns_param statlevel 0 ;# How many levels deep to run tclstats
ns_param statmaxbuf 100 ;# Maximum entries in tclstats table
ns_param library "${homedir}/servers/${servername}/modules/tcl" ;#
Private tcl library for the server
#
# ADP (AOLserver Dynamic Page) configuration
#
ns_section "ns/server/${servername}/adp"
ns_param map "/*.adp" ;# Extensions to parse as ADP's
ns_param map "/*.html" ;# Any extension can be mapped
ns_param map "/*.htm" ;# Any extension can be mapped
ns_param enableexpire false ;# Set "Expires: now" on all ADP's
ns_param enabledebug false ;# Allow Tclpro debugging with "?debug"
# ADP special pages
#ns_param errorpage ${pageroot}/errorpage.adp ;# Pretty-print ADP
scripting errors
#
# ADP custom parsers -- see adp.c
#
ns_section "ns/server/${servername}/adp/parsers"
ns_param aspStyle ".adp"
ns_param aspStyle ".html"
ns_param aspStyle ".htm"
#
# Socket driver module (HTTP) -- nssock
#
ns_section "ns/server/${servername}/module/nssock"
ns_param port $httpport
ns_param hostname $hostname
ns_param address $address
#
# Socket driver module (HTTPS) -- nsssl
#
# nsssl does not load unless sslkeyfile/sslcertfile exist (above).
#
ns_section "ns/server/${servername}/module/nsssl"
ns_param port $httpsport
ns_param hostname $hostname
ns_param address $address
ns_param keyfile $sslkeyfile
ns_param certfile $sslcertfile
#
# Control port -- nscp
#
# nscp does not load unless nscp_user is a valid user.
#
..........
#
# Access log -- nslog
#
ns_section "ns/server/${servername}/module/nslog"
ns_param rolllog true ;# Should we roll log?
ns_param rollonsignal true ;# Roll log on SIGHUP
ns_param rollhour 0 ;# Time to roll log
ns_param maxbackup 60 ;# Max number to keep around when
rolling
#
# CGI interface -- nscgi
#
ns_section "ns/server/${servername}/module/nscgi"
#ns_param map "GET /cgi /usr/local/cgi"
#ns_param map "POST /cgi /usr/local/cgi"
#
# Modules to load
#
ns_section "ns/server/${servername}/modules"
ns_param nssock ${bindir}/nssock.so
ns_param nslog ${bindir}/nslog.so
ns_param nscgi ${bindir}/nscgi.so
ns_param nsperm ${bindir}/nsperm.so
ns_param nsAspStyleAdps ${bindir}/nsAspStyleAdps.so
############################ database driver settings #################
# Sybase server parameters
#
# The database driver is specified here (it is loaded by nsext.so).
ns_section "ns/db/drivers"
ns_param nssybpd nsext.so
ns_param defaultpool intershop ;# Optionally specify default pool
ns_param pools intershop
ns_param ora8 ora8.so
ns_section "ns/db/driver/ora8"
#ns_param debug on
ns_section "ns/db/driver/nssybpd"
ns_param localdaemon nssybpd
ns_param param "/InterShop4/sybase"
ns_param maxelementsize [expr 32*1024]
ns_param iotrace false ;# Detailed database I/O logging
ns_param trimdata false ;# Trim whitespace off end of data
ns_param timeout 60 ;# Timeout waiting for proxy
# Specify the name of the database pool here.
ns_section "ns/db/pools"
ns_param dbase1 "This pool is for the sybase db"
ns_param dbase2 "The second pool is for oracle db"
# Describe the pool in detail here. This section depends on the db driver.
ns_section "ns/db/pool/dbase1"
ns_param driver nssybpd ;# From "ns/db/drivers" list
ns_param datasource "datasource_name"
ns_param user "xxxxxx"
ns_param password "xxxxxx"
ns_param connections 3 ;# No. of connections to open
ns_param logsqlerrors true ;# Verbose SQL query 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
#
# Oracle server parameters
#
ns_section "ns/db/pool/dbase2"
ns_param driver ora8
ns_param connections 6
ns_param dataSource "datasource_name"
ns_param user "xxxxxx"
ns_param password "xxxxxx"
ns_param verbose Off
ns_param ExtendedTableInfo Off
# Tell the virtual server about the pools it can use.
ns_section "ns/server/${servername}/db"
ns_param pools *
## nsssl: loads only if requisite files already exist (see top of this
file).
if { [file exists $sslcertfile] && [file exists $sslkeyfile] } {
ns_param nsssl ${bindir}/nsssle.so
} else {
ns_log warning "nsd.tcl: nsssl not loaded because key/cert files do not
exist."
}
# nscp: loads only if nscp_user is set (see top of this file).
if { $nscp_user != "" } {
ns_param nscp ${bindir}/nscp.so
} else {
ns_log warning "nsd.tcl: nscp not loaded because user/password is not
set."
}
ns_log notice "nsd.tcl: finished reading config file."
*********************************************
Actually i don't thinking the problem is from nsd.tcl. The problem is
happenned when it's running to get field from database (see note at below).
Please could you tell me if I'm wrong :-)
Thanks for your attention.
Oetjoen
Note:
This is the some of log file messages where I got from my web server
*********************************************
Error: nsd.tcl: Database operation "0or1row" failed (exception NSINT)
Database operation "0or1row" failed (exception NSINT)
while executing
"ns_db 0or1row $db $sql"
invoked from within
"set row [ns_db 0or1row $db $sql]..."
(procedure "get_payment_method" line 6)
invoked from within
"get_payment_method "name" $keynr"
invoked from within
"return [get_payment_method "name" $keynr]..."
*********************************************
----- Original Message -----
From: Scott S. Goodwin <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 21, 2002 11:18 AM
Subject: Re: [AOLSERVER] Error: nsd.tcl: Database operation "0or1row" failed
(exception NSINT)
> Post your nsd.tcl file (minus any usernames and passwords).
>
> /s.
>
> -+-+-+-+-+-+-+-+-+-+-+-+-
> If to err is human, I must be more human than most.
>
> Scott S. Goodwin
> u: http://scottg.net
> e: [EMAIL PROTECTED]
> p: 850.897.6830
> aim: scottgnet
>
>
> ----- Original Message -----
> From: "The Oetjoen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: "The Oetjoen" <[EMAIL PROTECTED]>
> Sent: Wednesday, February 20, 2002 8:38 PM
> Subject: Error: nsd.tcl: Database operation "0or1row" failed (exception
> NSINT)
>
>
> > Hi folks..
> > Can anyone tell me what is the problem with log file "Error: nsd.tcl:
> > Database operation "0or1row" failed (exception NSINT)"?
> > I already try to find out what's going on, but until now I can solve it.
> > any suggestion to solve that problem?
> >
> > Thanks
> >
> > Oetjoen
> >
