Forum OpenACS Q&A: Example config.tcl for Oracle in AOLserver 3.4, e.g. sample-db-ini.txt
Posted by
Eric Lee
on 08/27/02 02:15 PM
I'm looking for the sample-db-ini.txt that used to be available on
the arsdigita.com website (when that site existed). Or for any
example config.tcl for Oracle in AOLserver 3.4
the arsdigita.com website (when that site existed). Or for any
example config.tcl for Oracle in AOLserver 3.4
2:
Response to Example config.tcl for Oracle in AOLserver 3.4, e.g. sample-db-ini.txt
(response to 1)
Posted by
defunct defunct
on 09/02/02 05:39 PM
This might be what you need. Its based on the sample-db-ini.txt file you mentioned.
; AOLServer ACS Virtual Server Configuration File Template ; ; Replace these variables with the correct values... ; Variable to Replace Suggestion ; --------------------------+---------------------- ; origacs | service_name ; origacs | database_password ; /usr/local/aolserver | /usr/local/aolserver ; origacs | service_name ; Experimental Service | a description of your service ; localhost.millward@open-msg.com | email-address of maintainer ; /web/origacs | /web/service_name ; localhost | your ip address ; localhost | your dns name ; 9191 | what port to use (9191 by default) ; localhost | disabled by default ; localhost_ssl | disabled by default ; 9191_ssl | disabled by default [ns/db/drivers] ora8=ora8.so [ns/db/pool/main] MaxIdle=1000000000 MaxOpen=1000000000 Driver=ora8 Connections=8 DataSource= User=origacs Password=origacs Verbose=On ExtendedTableInfo=On [ns/db/pool/subquery] MaxIdle=1000000000 MaxOpen=1000000000 Driver=ora8 Connections=8 DataSource= User=origacs Password=origacs Verbose=On ExtendedTableInfo=On [ns/db/pool/log] MaxIdle=1000000000 MaxOpen=1000000000 Driver=ora8 Connections=3 DataSource= User=origacs Password=origacs Verbose=On ExtendedTableInfo=On [ns/db/pools] main=main subquery=subquery log=log [ns/parameters] ; This used to handled with a file under acs/parameters, but ; parameters are now stored in the database. User=nsadmin Group=web ServerLog=/usr/local/aolserver/log/origacs-error.log Home=/usr/local/aolserver StackSize=500000 MaxKeepAlive=0 [ns/threads] ; use more than 1 processor (Solaris) SystemScope=on [ns/server/origacs] PageRoot=/web/origacs/www DirectoryFile=index.tcl,index.adp,index.html,index.htm Webmaster=localhost.millward@open-msg.com NoticeBgColor="#ffffff" EnableTclPages=On NotFoundResponse=/global/file-not-found.html ServerBusyResponse=/global/busy.html ServerInternalErrorResponse=/global/error.html MaxThreads=20 MaxBusyThreads=15 MaxWait=2 [ns/server/origacs/db] Pools=main,subquery,log DefaultPool=main [ns/server/origacs/adp] Map=/*.adp DefaultParser=fancy [ns/server/origacs/module/nslog] EnableHostnameLookup=Off File=/usr/local/aolserver/log/origacs.log LogCombined=On LogRefer=Off LogUserAgent=Off MaxBackup=5 RollDay=* RollFmt=%Y-%m-%d-%H:%M RollHour=0 RollOnSignal=On RollLog=On [ns/server/origacs/module/nsperm] model=Small enablehostnamelookup=Off [ns/server/origacs/module/nssock] timeout=120 ; Address=127.0.0.1 Hostname=localhost Port=9191 ; [ns/server/origacs/module/nsssl] ; Address=localhost ; Hostname=localhost_ssl ; CertFile=/usr/local/aolserver/servers/origacs/cert.pem ; KeyFile=/usr/local/aolserver/servers/origacs/key.pem ; Port=9191_ssl [ns/server/origacs/modules] nsperm=nsperm.so nssock=nssock.so nslog=nslog.so nssha1=nssha1.so nscache=nscache.so ; nsxml=nsxml.so ; nsssl=nsssle.so [ns/server/origacs/MimeTypes] Default=text/plain NoExtension=text/plain .pcd=image/x-photo-cd .prc=application/x-pilot [ns/server/origacs/tcl] Library=/web/origacs/tcl [ns/servers] origacs=Experimental Service
3:
Response to Example config.tcl for Oracle in AOLserver 3.4, e.g. sample-db-ini.txt
(response to 1)
Posted by
Eric Lee
on 09/26/02 02:23 AM
To answer my own question:
#
# Database drivers
#
# Given some of the available documentation, for example,
# http://aolserver.com/docs/admin/sample-db-config.tcl.txt
# you might expect Oracle configuration to follow the Sybase
# model and use an "external proxy daemon", but it does not.
#
# Also note the null {} datasource parameter.
#
ns_section "ns/db/drivers"
ns_param ora8 ora8.so ;# The ArsDigita Oracle driver
# Not needed for AD oracle driver.
#ns_section "ns/db/driver/ora8"
#ns_param localdaemon ??? ;# Name of the proxy daemon executable
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 foo
ns_param password bar
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 foo
ns_param password bar
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 foo
ns_param password bar
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
#
# In the case of virtual servers you can give different virtual
# servers access to different databases, or you can let them access
# them all. AOLserver 3.x does not use virtual servers so the only
# useful value is "*", but if you use one config file for multiple nsd
# processes, or you are using a version of AOLserver that supports
# virtual servers, then you should list the pools you want to access.
#
ns_section "ns/server/${servername}/db"
ns_param pools * ;# Wildcard gives access to all
ns_param defaultpool main
An example of startup messages about a successful database configuration:
... Notice: nsmain: AOLserver/3.4.2 starting ... Notice: modload: loading '/opt/usr/local/aolserver/bin/ora8.so' Notice: ora8 driver LobBufferSize = 16384 Notice: ora8 driver PrefetchRows = 0 Notice: ora8 driver PrefetchMemory = 0 Notice: Loaded ArsDigita Oracle Driver version 2.6, built on 22:04:36/Aug 26 2002
