I run
aol3.2ad10 downloaded from arsdigita (I think the oracle driver comes in
the download if not get it from arsdigita)
oracle 8.1.6 enterprise
The config file I posted before is from a running development box running
NT2000 but I haven't noticed any difference between 2000 and NT4
I did not have to purchase any software (other than oracle and NT)
I didn't have any tech support and I don't remember reading the documents
but I've installed on Solaris and Linux before NT. What docs there are are
Unix centric and if you don't know Unix/Oracle installing on NT could be a
challange.
Make sure your webroot and server are on the same drive and don't try and
run as a service. You can also turn on verbose in the db config stuff. It
might tell you something
I would also download ACS4.X and point the webroot at the www directory.
That way when you go to the site the install program may tell you what's
wrong with your setup. If you install ACS you can access the database with
db_foreach customers customers { select lastname, firstname from customers }
{
set name "$lastname, $firstname"
}
see the acs docs for more info. I'm not that familiar with the straight
AOLServer db routines since I never use them.
I would make sure you can connect with sqlplus use scott/tiger@ora0 If you
can't AOLServer will not work either
I see also in your config file
> > >
> > > ns_section ns/server/gsdev/db
> > > ns_param pools *
> > > ns_param DefaultPool main
I think this thould be
ns_section ns/server/$servername/db
barry
----- Original Message -----
From: "Ling Wang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 8:15 PM
Subject: Re: [AOLSERVER] Help on Oracle8 driver for WinNT needed
> Barry,
>
> I tried almost everything and it still does not work. No matter what I
did,
> the ALOServer says that ns_db is not enabled and I have no idea why
because
> I loaded the ora8.dll without any errors.
>
> Could you do me a favor, could you please tell me how you made it work
from
> ground zero. Did you purchase the driver? Where did you get your tech
> support?
>
> Suppose I have a fresh WinNT40 machine which has a working Oracle8.0
> installed. What should I do to make ALOServer work with Oracle8.0
>
> 1. Which version and where should I download the ALOServer?
> 2. Which version and where should I get Oracle8.0 driver?
> 3. What steps should I take to install them besides the poorly documented
> steps.
> 4. Could you please send me a sample file which execute a SQL statement
like
> "select * from customers".
>
> I am really desperate.
>
> I would appreciate very much.
>
> Thanks.
>
> Ling Wang
>
>
> >From: Barry Books <[EMAIL PROTECTED]>
> >Reply-To: AOLserver Discussion <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: [AOLSERVER] Help on Oracle8 driver for WinNT needed
> >Date: Wed, 18 Apr 2001 05:33:36 -0500
> >
> >I run acs so I never use the ns_db interface but I think you have to have
a
> >default pool or specify the pool in the get handle call. I think that you
> >need
> >
> >set db [ns_db gethandle main]
> >
> >BTW: the acs database routines are the best there is and the first
install
> >page will tell you if you database connections are set up correctly
> >
> >bary
> >
> >----- Original Message -----
> >From: "Ling Wang" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Tuesday, April 17, 2001 9:54 PM
> >Subject: Re: [AOLSERVER] Help on Oracle8 driver for WinNT needed
> >
> >
> > > Thanks a lot for the hint and I got through the loading stage and I
did
> >not
> > > see any error message now. Then I started to run a simple adp file
> > > (test.adp) as shown in the following:
> > >
> > >
> > > <HTML>
> > > <HEAD><TITLE>Test</TITLE></HEAD>
> > > <BODY>
> > > <H1>Test</H1>
> > > <%
> > > set db [ns_db gethandle]
> > > %>
> > > </BODY></HTML>
> > >
> > > I got the "Test" displayed which means the AOLServer is working.
> >However,
> > > when I look at the command prompt, AOLServer says the command ns_db is
> >not
> > > enabled. As I understand, once the driver is loaded, I should be able
to
> >do
> > > the above.
> > >
> > > Anyone one has any suggestions as to what was the problem?
> > >
> > > I have made progress from tons of error to no errors when I run
> >nsd.exe -ft
> > > nsd.tcl. The following is the right nsd.tcl for running "nsd.exe -ft
> > > nsd.tcl":
> > >
> > >
> > > # $Header: /cvsroot/aolserver/aolserver/nsd/sample-config.tcl,v 1.1
> > > 2000/10/09 22:00:32 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 8000
> > > set httpsport 8443
> > >
> > > # The hostname and address should be set to actual values.
> > > set hostname [ns_info hostname]
> > > set address [ns_info address]
> > >
> > > 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 9999
> > > 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 256000
> > > #ns_param stacksize [expr 128*1024] ;# Per-thread stack size.
> > > set home [file dirname [ns_info config]]
> > > set bin [file dirname [info nameofexecutable]]
> > >
> > > # Setting the following should get you going.
> > > set server acs
> > > set httpport 8000
> > > set oracleuser "scott"
> > > set oraclepassword "tiger"
> > > set sroot servers/$server
> > >
> > > foreach d [list log servers $sroot $sroot/modules $sroot/pages] {
> > > if ![file exists $home/$d] {
> > > file mkdir $home/$d
> > > }
> > > }
> > >
> > > # Oracle8 driver
> > > ns_section ns/db/drivers
> > > ns_param ora8 ora8.dll
> > >
> > > ns_section ns/db/pool/main
> > > ns_param driver ora8
> > > ns_param connections 2
> > > ns_param user $oracleuser
> > > ns_param datasource "ora0"
> > > ns_param password $oraclepassword
> > > ns_param verbose off
> > >
> > > ns_section ns/db/pool/subquery
> > > ns_param driver ora8
> > > ns_param connections 2
> > > ns_param user $oracleuser
> > > ns_param datasource "ora0"
> > > ns_param password $oraclepassword
> > > ns_param verbose off
> > >
> > > ns_section ns/db/pool/log
> > > ns_param driver ora8
> > > ns_param connections 2
> > > ns_param user $oracleuser
> > > ns_param datasource "ora0"
> > > ns_param password $oraclepassword
> > > ns_param verbose off
> > >
> > > ns_section ns/db/pools
> > > ns_param main main
> > > ns_param subquery subquery
> > > ns_param log log
> > >
> > >
> > > #
> > > # 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.
> > >
> > > # 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.
> > >
> > >
> > > #
> > > # 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 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 ;# ADP error
page.
> > >
> > >
> > > #
> > > # ADP custom parsers -- see adp.c
> > > #
> > > ns_section "ns/server/${servername}/adp/parsers"
> > > ns_param adp ".adp" ;# adp is the default parser.
> > >
> > >
> > > #
> > > # 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.
> > > #
> > > ns_section "ns/server/${servername}/module/nscp"
> > > ns_param port $nscp_port
> > > ns_param address $nscp_addr
> > >
> > > ns_section "ns/server/${servername}/module/nscp/users"
> > > ns_param user $nscp_user
> > >
> > > ns_section ns/server/gsdev/db
> > > ns_param pools *
> > > ns_param DefaultPool main
> > >
> > > #
> > > # 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 5 ;# Max number to keep around when
> > > rolling.
> > >
> > >
> > > #
> > > # CGI interface -- nscgi
> > > #
> > > # WARNING: These directories must not live under pageroot.
> > > #
> > > ns_section "ns/server/${servername}/module/nscgi"
> > > #ns_param map "GET /cgi /usr/local/cgi" ;# CGI script file dir
> >(GET).
> > > #ns_param map "POST /cgi /usr/local/cgi" ;# CGI script file dir
> > > (POST).
> > >
> > >
> > > #
> > > # Modules to load
> > > #
> > > ns_section "ns/server/${servername}/modules"
> > > ns_param nssock ${bindir}/nssock${ext}
> > > ns_param nslog ${bindir}/nslog${ext}
> > > #ns_param nscgi ${bindir}/nscgi${ext} ;# Map the paths
> >before
> > > using.
> > > #ns_param nsperm ${bindir}/nsperm${ext} ;# Edit passwd
before
> > > using.
> > >
> > > #
> > > # nsssl: Only loads if sslcertfile and sslkeyfile exist (see above).
> > > #
> > > if { [file exists $sslcertfile] && [file exists $sslkeyfile] } {
> > > ns_param nsssl ${bindir}/${sslmodule}
> > > } else {
> > > ns_log warning "config.tcl: nsssl not loaded -- key/cert files do
> >not
> > > exist."
> > > }
> > >
> > > #
> > > # nscp: Only loads if nscp_user is set (see above).
> > > #
> > > if { $nscp_user != "" } {
> > >
> > > if ![string match "127.0.0.1" $nscp_addr] {
> > > # Anything but 127.0.0.1 is not recommended.
> > > ns_log warning "config.tcl: nscp listening on
> >${nscp_addr}:${nscp_port}"
> > > }
> > > ns_param nscp ${bindir}/nscp${ext}
> > >
> > > } else {
> > > ns_log warning "config.tcl: nscp not loaded -- user/password is
not
> > > set."
> > > }
> > >
> > > ns_log notice "config.tcl: finished reading config file."
> > >
> > >
> > >
> > > >From: Rob Mayoff <[EMAIL PROTECTED]>
> > > >Reply-To: AOLserver Discussion <[EMAIL PROTECTED]>
> > > >To: [EMAIL PROTECTED]
> > > >Subject: Re: [AOLSERVER] Help on Oracle8 driver for WinNT needed
> > > >Date: Tue, 17 Apr 2001 04:51:09 -0500
> > > >
> > > > > The very first problem I have is that when nsd.exe try to load the
> > > >driver,
> > > > > it looks for the function called Ns_ModuleInit in the ora8.dll.
This
> > > > > function does not exist in the ora8.dll. As a matter of fact, all
> >other
> > > >dlls
> > > > > in the bin directory have this function, for example, nsd.dll,
> >nscp.dll
> > > >etc.
> > > > > I looked through the source code and found only Ns_DbDriverInit.
> > > >
> > > >ora8.dll does not have Ns_ModuleInit. It is not supposed to.
> > > >Ns_ModuleInit is for loadable modules. ora8.dll is not a loadable
> > > >module. It is a database driver.
> > > >
> > > >You are loading the driver incorrectly. You are listing it in the
> > > >ns/server/server1/modules section of your config file instead of in
the
> > > >ns/db/drivers section.
> > >
> > > _________________________________________________________________
> > > Get your FREE download of MSN Explorer at http://explorer.msn.com
> > >
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
