Forum OpenACS Q&A: DB Connection Error

Posted by danny kim on 09/15/11 12:48 PM

There is DB connection error when ACS server is invoked.

The following database pools generated errors:
* OpenACS could not allocate a handle from database pool "pool1".
Possible causes might include:
* The database is not running.
* The database driver has not been correctly installed.
* The datasource or database user/password are incorrect.
* You didn't define any database pools.

Followings are 5 kinds of information -- ps info., aolserver4.log, error.log, psql and postgresql.conf file

===========================================================================
1. ps

cs@debian:~$ ps axw |grep post
1588 ? S 0:01 /usr/lib/postgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c config_file=/etc/postgresql/8.4/main/postgresql.conf
1652 ? Ss 0:00 postgres: writer process
1653 ? Ss 0:00 postgres: wal writer process
1654 ? Ss 0:00 postgres: autovacuum launcher process
1655 ? Ss 0:00 postgres: stats collector process
2201 ? Ss 0:00 postgres: www-data openacs [local] idle
2457 pts/1 S+ 0:00 grep post

===========================================================================
2. aolserver4.log

[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: nsmain: AOLserver/4.5.1 starting
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: fastpath[main]: mapped GET /
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: fastpath[main]: mapped HEAD /
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: fastpath[main]: mapped POST /
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: adp[main]: mapped GET /*.adp
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: adp[main]: mapped HEAD /*.adp
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: adp[main]: mapped POST /*.adp
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: adp[main]: mapped GET /*.html
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: adp[main]: mapped HEAD /*.html
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: adp[main]: mapped POST /*.html
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssock.so'
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nslog.so'
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: nslog: opened '/var/log/aolserver4/aolserver4.log'
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nscgi.so'
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Warning: nscgi: no such interps section: ns/interps/cgiinterps
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: nscgi: GET /cgi-bin -> /usr/lib/cgi-bin
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: nscgi: POST /cgi-bin -> /usr/lib/cgi-bin
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: nscgi: GET /*.py
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: nscgi: POST /*.pl
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: nscgi: POST /*.py
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsperm.so'
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: conf: [ns/server/main]enabletclpages = 0
[14/Sep/2011:10:24:22][1174.3075675840][-main-] Notice: default thread pool: minthreads 0 maxthreads 20 idle 0 current 0 maxconns 100 queued 0 timeout 120 spread 20
[14/Sep/2011:10:24:33][1174.3075675840][-main-] Notice: XOTcl version 1.6.6 loaded
[14/Sep/2011:10:24:34][1174.3075675840][-main-] Notice: nsmain: AOLserver/4.5.1 running
[14/Sep/2011:10:24:34][1174.3075675840][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[14/Sep/2011:10:24:34][1174.3067063152][-sched-] Notice: sched: starting
[14/Sep/2011:10:24:34][1174.3075675840][-main-] Notice: driver: starting: nssock
[14/Sep/2011:10:24:34][1174.3066702704][-nssock:driver-] Notice: starting
[14/Sep/2011:10:24:34][1174.3066702704][-nssock:driver-] Error: nssock: failed to listen on 127.0.0.1:80: Address already in use
[14/Sep/2011:10:24:34][1174.3075675840][-main-] Fatal: could not start drivers

===========================================================================
3. error.log

[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: nsmain: AOLserver/4.5.1 starting
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: encoding: loaded: utf-8
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: fastpath[openacs]: mapped GET /
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: fastpath[openacs]: mapped HEAD /
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: fastpath[openacs]: mapped POST /
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: adp[openacs]: mapped GET /*.adp
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: adp[openacs]: mapped HEAD /*.adp
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: adp[openacs]: mapped POST /*.adp
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssock.so'
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nslog.so'
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: nslog: opened '/usr/share/openacs/log/openacs.log'
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssha1.so'
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsdb.so'
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nspostgres.so'
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: PostgreSQL loaded.
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: modload: loading '/usr/lib/tcltk/thread2.6.5/libthread2.6.5-aolserver.so'
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: conf: [ns/server/openacs]enabletclpages = 0
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: default thread pool: minthreads 5 maxthreads 10 idle 0 current 0 maxconns 100 queued 0 timeout 120 spread 20
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: XOTcl version 1.6.6 loaded
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Loading OpenACS, rooted at /usr/share/openacs
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Sourcing /usr/share/openacs/packages/acs-bootstrap-installer/bootstrap.tcl
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Database API: Default database (dbn) is: 'default'
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Database API: The following pools are available for OpenACS: pool1 pool2 pool3
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Opening openacs on localhost
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost:5432:openacs.
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Opening openacs on localhost
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost:5432:openacs.
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Opening openacs on localhost
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost:5432:openacs.
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Bootstrap: Loading acs-tcl
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/00-database-procs-postgresql.tcl
[08/Sep/2011:11:42:45][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl

===========================================================================
4. psql

postgres@debian:~$
postgres@debian:~$ psql -l
List of databases
Name | Owner | Encoding | Collation | Ctype | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
openacs | www-data | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
pool1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
service1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
: postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
: postgres=CTc/postgres
(6 rows)

postgres@debian:~$

===========================================================================
5. postgresql configuration file(postgresql.conf)

2011-09-15 16:45:04 KST LOG: database system was shut down at 2011-09-15 16:43:56 KST
2011-09-15 16:45:04 KST LOG: incomplete startup packet
2011-09-15 16:45:04 KST LOG: database system is ready to accept connections
2011-09-15 16:45:04 KST LOG: autovacuum launcher started
2011-09-15 16:54:07 KST LOG: unexpected EOF on client connection
2011-09-15 16:54:07 KST LOG: incomplete startup packet
2011-09-15 16:54:07 KST LOG: received fast shutdown request
2011-09-15 16:54:07 KST LOG: aborting any active transactions
2011-09-15 16:54:07 KST LOG: autovacuum launcher shutting down
2011-09-15 16:54:07 KST LOG: shutting down
2011-09-15 16:54:07 KST LOG: database system is shut down
2011-09-15 16:55:14 KST LOG: database system was shut down at 2011-09-15 16:54:07 KST
2011-09-15 16:55:14 KST LOG: database system is ready to accept connections
2011-09-15 16:55:14 KST LOG: autovacuum launcher started
2011-09-15 6:55:14 KST LOG: incomplete startup packet

3. Postgresql.conf file

#------------------------------------------------------------------------------
# FILE LOCATIONS
#------------------------------------------------------------------------------

# The default values of these variables are driven from the -D command-line
# option or PGDATA environment variable, represented here as ConfigDir.

data_directory = '/var/lib/postgresql/8.4/main' # use data in another directory
# (change requires restart)
hba_file = '/etc/postgresql/8.4/main/pg_hba.conf' # host-based authentication file
# (change requires restart)
ident_file = '/etc/postgresql/8.4/main/pg_ident.conf' # ident configuration file
# (change requires restart)

# If external_pid_file is not explicitly set, no extra PID file is written.
external_pid_file = '/var/run/postgresql/8.4-main.pid' # write an extra PID file
# (change requires restart)

#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------

# - Connection Settings -

listen_addresses = 'localhost' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
# (change requires restart)
port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
# Note: Increasing max_connections costs ~400 bytes of shared memory per
# connection slot, plus lock space (see max_locks_per_transaction).
#superuser_reserved_connections = 3 # (change requires restart)
unix_socket_directory = '/var/run/postgresql' # (change requires restart)
#unix_socket_group = '' # (change requires restart)
#unix_socket_permissions = 0777 # begin with 0 to use octal notation
# (change requires restart)
#bonjour_name = '' # defaults to the computer name
# (change requires restart)

# - Security and Authentication -

#authentication_timeout = 1min # 1s-600s
ssl = true # (change requires restart)
#ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers
# (change requires restart)
#ssl_renegotiation_limit = 512MB # amount of data between renegotiations
#password_encryption = on
#db_user_namespace = off

# Kerberos and GSSAPI
#krb_server_keyfile = ''
#krb_srvname = 'postgres' # (Kerberos only)
#krb_caseins_users = off

# - TCP Keepalives -
# see "man 7 tcp" for details

#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds;
# 0 selects the system default
#tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds;
# 0 selects the system default
#tcp_keepalives_count = 0 # TCP_KEEPCNT;
# 0 selects the system default

#------------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#------------------------------------------------------------------------------

# - Memory -

shared_buffers = 28MB # min 128kB
# (change requires restart)
#temp_buffers = 8MB # min 800kB
#max_prepared_transactions = 0 # zero disables the feature
# (change requires restart)
# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory
# per transaction slot, plus lock space (see max_locks_per_transaction).
# It is not advisable to set max_prepared_transactions nonzero unless you
# actively intend to use prepared transactions.
#work_mem = 1MB # min 64kB
#maintenance_work_mem = 16MB # min 1MB
#max_stack_depth = 2MB # min 100kB

# - Kernel Resource Usage -

#max_files_per_process = 1000 # min 25
# (change requires restart)
#shared_preload_libraries = '' # (change requires restart)

# - Cost-Based Vacuum Delay -

#vacuum_cost_delay = 0ms # 0-100 milliseconds
#vacuum_cost_page_hit = 1 # 0-10000 credits
#vacuum_cost_page_miss = 10 # 0-10000 credits
#vacuum_cost_page_dirty = 20 # 0-10000 credits
#vacuum_cost_limit = 200 # 1-10000 credits

# - Background Writer -

#bgwriter_delay = 200ms # 10-10000ms between rounds
#bgwriter_lru_maxpages = 100 # 0-1000 max buffers written/round
#bgwriter_lru_multiplier = 2.0 # 0-10.0 multipler on buffers scanned/round

# - Asynchronous Behavior -

#effective_io_concurrency = 1 # 1-1000. 0 disables prefetching

3: Re: DB Connection Error (response to 1)

Posted by danny kim on 09/16/11 02:46 AM

Here's a config.tcl.
I'm not sure this is file you wanted.

1. config.tcl

ns_log notice "nsd.tcl: starting to read config file..."

######################################################################
#
# Instance-specific settings
# These default settings will only work in limited circumstances
# Two servers with default settings cannot run on the same host
#
######################################################################

#---------------------------------------------------------------------
# change to 80 and 443 for production use
set httpport 8000
set httpsport 8443
# If setting port below 1024 with AOLServer 4, read comments in file:
# /var/lib/aolserver/service0/packages/etc/daemontools/run

# The hostname and address should be set to actual values.
# setting the address to 0.0.0.0 means aolserver listens on all interfaces
set hostname [ns_info hostname]
set address [ns_info address]

# Note: If port is privileged (usually < 1024), OpenACS must be
# started by root, and, in AOLserver 4, the run script have a
# '-b address' flag which matches the address according to settings (above)

set server "service0"
set servername "New OpenACS Installation - Development"

set serverroot "/var/lib/aolserver/${server}"

#---------------------------------------------------------------------
# which database do you want? postgres or oracle
set database postgres

set db_name $server

if { $database == "oracle" } {
set db_password "mysitepassword"
} else {
set db_host localhost
set db_port ""
set db_user $server
}

#---------------------------------------------------------------------
# if debug is false, all debugging will be turned off
set debug false

#set homedir /usr/local/aolserver
#set bindir [file dirname [ns_info nsd]]
set homedir혻혻혻혻혻혻혻혻혻혻혻혻혻혻혻혻혻혻 /usr/lib/aolserver4
set bindir혻혻혻혻혻혻혻혻혻혻혻혻혻혻혻혻혻혻혻 /usr/lib/aolserver4/bin

######################################################################
#
# End of instance-specific settings
#
# Nothing below this point need be changed in a default install.
#
######################################################################

#---------------------------------------------------------------------
#
# AOLserver's directories. Autoconfigurable.
#
#---------------------------------------------------------------------
# Where are your pages going to live ?
set pageroot ${serverroot}/www
set directoryfile index.tcl,index.adp,index.html,index.htm

#---------------------------------------------------------------------
# Global server parameters
#---------------------------------------------------------------------
ns_section ns/parameters
ns_param serverlog ${serverroot}/log/error.log
ns_param home $homedir
# maxkeepalive is ignored in aolserver4.x
ns_param maxkeepalive 0
ns_param logroll on
ns_param maxbackup 5
ns_param debug $debug
# ns_param mailhost localhost

# setting to Unicode by default
# see http://dqd.com/~mayoff/encoding-doc.html
ns_param HackContentType 1
ns_param DefaultCharset utf-8
ns_param HttpOpenCharset utf-8
ns_param OutputCharset utf-8
ns_param URLCharset utf-8

#---------------------------------------------------------------------
# Thread library (nsthread) parameters
#---------------------------------------------------------------------
ns_section ns/threads
ns_param mutexmeter true ;# measure lock contention
# The per-thread stack size must be a multiple of 8k for AOLServer to run under MacOS X
ns_param stacksize [expr 128 * 8192]

#
# MIME types.
#
ns_section ns/mimetypes
# Note: AOLserver already has an exhaustive list of MIME types:
# see: /usr/local/src/aolserver-4.{version}/aolserver/nsd/mimetypes.c
# but in case something is missing you can add it here.
ns_param Default text/plain
ns_param NoExtension text/plain
ns_param .pcd image/x-photo-cd
ns_param .prc application/x-pilot
ns_param .xls application/vnd.ms-excel
ns_param .doc application/vnd.ms-word

#---------------------------------------------------------------------
#
# 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 $server $servername

#
# Server parameters
#
ns_section ns/server/${server}
ns_param directoryfile $directoryfile
ns_param pageroot $pageroot
ns_param maxconnections 100 ;# Max connections to put on queue
ns_param maxdropped 0
ns_param maxthreads 10
ns_param minthreads 5
ns_param threadtimeout 120 ;# Idle threads die at this rate
ns_param globalstats false ;# Enable built-in statistics
ns_param urlstats false ;# Enable URL statistics
ns_param maxurlstats 1000 ;# Max number of URL's to do stats on
# ns_param directoryadp $pageroot/dirlist.adp ;# Choose one or the other
# ns_param directoryproc _ns_dirlist ;# ...but not both!
# ns_param directorylisting fancy ;# Can be simple or fancy

#
# Special HTTP pages
#
ns_param NotFoundResponse "/global/file-not-found.html"
ns_param ServerBusyResponse "/global/busy.html"
ns_param ServerInternalErrorResponse "/global/error.html"

#---------------------------------------------------------------------
#
# ADP (AOLserver Dynamic Page) configuration
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/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 $debug ;# Allow Tclpro debugging with "?debug"
ns_param defaultparser fancy

ns_section ns/server/${server}/adp/parsers
ns_param fancy ".adp"

ns_section ns/server/${server}/redirects
ns_param 404 "global/file-not-found.html"
ns_param 403 "global/forbidden.html"

#
# Tcl Configuration
#
ns_section ns/server/${server}/tcl
ns_param library ${serverroot}/tcl
ns_param autoclose on
ns_param debug $debug

#---------------------------------------------------------------------
#
# Rollout email support
#
# These procs help manage differing email behavior on
# dev/staging/production.
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/acs/acs-rollout-support

# EmailDeliveryMode can be:
# default: Email messages are sent in the usual manner.
# log: Email messages are written to the server's error log.
# redirect: Email messages are redirected to the addresses specified
# by the EmailRedirectTo parameter. If this list is absent
# or empty, email messages are written to the server's error log.
# filter: Email messages are sent to in the usual manner if the
# recipient appears in the EmailAllow parameter, otherwise they
# are logged.

# ns_param EmailDeliveryMode redirect
# ns_param EmailRedirectTo somenerd@yourdomain.test, othernerd@yourdomain.test
# ns_param EmailAllow somenerd@yourdomain.test,othernerd@yourdomain.test

#---------------------------------------------------------------------
#
# WebDAV Support (optional, requires oacs-dav package to be installed
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/tdav
ns_param propdir ${serverroot}/data/dav/properties
ns_param lockdir ${serverroot}/data/dav/locks
ns_param defaultlocktimeout "300"

ns_section ns/server/${server}/tdav/shares
ns_param share1 "OpenACS"
# ns_param share2 "Share 2 description"

ns_section ns/server/${server}/tdav/share/share1
ns_param uri "/dav/*"
# all WebDAV options
ns_param options "OPTIONS COPY GET PUT MOVE DELETE HEAD MKCOL POST PROPFIND PROPPATCH LOCK UNLOCK"

#ns_section ns/server/${server}/tdav/share/share2
# ns_param uri "/share2/path/*"
# read-only WebDAV options
# ns_param options "OPTIONS COPY GET HEAD MKCOL POST PROPFIND PROPPATCH"

#---------------------------------------------------------------------
#
# Socket driver module (HTTP) -- nssock
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/module/nssock
ns_param timeout 120
ns_param address $address
ns_param hostname $hostname
ns_param port $httpport
# setting maxinput higher than practical may leave the server vulnerable to resource DoS attacks
# see http://www.panoptic.com/wiki/aolserver/166
ns_param maxinput [expr 20 * 1024 * 1024] ;# Maximum File Size for uploads in bytes
ns_param recvwait [expr 5 * 60] ;# Maximum request time in minutes

#---------------------------------------------------------------------
#
# Access log -- nslog
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/module/nslog
ns_param debug false
ns_param dev false
ns_param enablehostnamelookup false
ns_param file ${serverroot}/log/${server}.log
ns_param logcombined true
ns_param extendedheaders COOKIE
# ns_param logrefer false
# ns_param loguseragent false
ns_param logreqtime true
ns_param maxbackup 1000
ns_param rollday *
ns_param rollfmt %Y-%m-%d-%H:%M
ns_param rollhour 0
ns_param rollonsignal true
ns_param rolllog true

#---------------------------------------------------------------------
#
# nsjava - aolserver module that embeds a java virtual machine. Needed to
# support webmail. See http://nsjava.sourceforge.net for further
# details. This may need to be updated for OpenACS4 webmail
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/module/nsjava
ns_param enablejava off ;# Set to on to enable nsjava.
ns_param verbosejvm off ;# Same as command line -debug.
ns_param loglevel Notice
ns_param destroyjvm off ;# Destroy jvm on shutdown.
ns_param disablejitcompiler off
ns_param classpath /usr/local/jdk/jdk118_v1/lib/classes.zip:${bindir}/nsjava.jar:${pageroot}/webmail/java/activation.jar:${pageroot}/webmail/java/mail.jar:${pageroot}/webmail/java

#---------------------------------------------------------------------
#
# CGI interface -- nscgi, if you have legacy stuff. Tcl or ADP files inside
# AOLserver are vastly superior to CGIs. I haven't tested these params but they
# should be right.
#
#---------------------------------------------------------------------
#ns_section "ns/server/${server}/module/nscgi"
# ns_param map "GET /cgi-bin/ ${serverroot}/cgi-bin"
# ns_param map "POST /cgi-bin/ ${serverroot}/cgi-bin"
# ns_param Interps CGIinterps

#ns_section "ns/interps/CGIinterps"
# ns_param .pl "/usr/bin/perl"

#---------------------------------------------------------------------
#
# PAM authentication
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/module/nspam
ns_param PamDomain "pam_domain"

#---------------------------------------------------------------------
#
# OpenSSL for Aolserver 3.3 and 4
#
#---------------------------------------------------------------------
if { [ns_info version] < 4} {

#---------------------------------------------------------------------
# OpenSSL for Aolserver 3.3
#---------------------------------------------------------------------

ns_section "ns/server/${server}/module/nsopenssl"

ns_param ModuleDir ${serverroot}/etc/certs

# NSD-driven connections:
ns_param ServerPort $httpsport
ns_param ServerHostname $hostname
ns_param ServerAddress $address
ns_param ServerCertFile certfile.pem
ns_param ServerKeyFile keyfile.pem
ns_param ServerProtocols "SSLv2, SSLv3, TLSv1"
ns_param ServerCipherSuite "ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP"
ns_param ServerSessionCache true
ns_param ServerSessionCacheID 1
ns_param ServerSessionCacheSize 512
ns_param ServerSessionCacheTimeout 300
ns_param ServerPeerVerify false
ns_param ServerPeerVerifyDepth 3
ns_param ServerCADir ca
ns_param ServerCAFile ca.pem
ns_param ServerTrace false

# For listening and accepting SSL connections via Tcl/C API:
ns_param SockServerCertFile certfile.pem
ns_param SockServerKeyFile keyfile.pem
ns_param SockServerProtocols "SSLv2, SSLv3, TLSv1"
ns_param SockServerCipherSuite "ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP"
ns_param SockServerSessionCache true
ns_param SockServerSessionCacheID 2
ns_param SockServerSessionCacheSize 512
ns_param SockServerSessionCacheTimeout 300
ns_param SockServerPeerVerify false
ns_param SockServerPeerVerifyDepth 3
ns_param SockServerCADir internal_ca
ns_param SockServerCAFile internal_ca.pem
ns_param SockServerTrace false

# Outgoing SSL connections
ns_param SockClientCertFile certfile.pem
ns_param SockClientKeyFile keyfile.pem
ns_param SockClientProtocols "SSLv2, SSLv3, TLSv1"
ns_param SockClientCipherSuite "ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP"
ns_param SockClientSessionCache false
ns_param SockClientSessionCacheID 3
ns_param SockClientSessionCacheSize 512
ns_param SockClientSessionCacheTimeout 300
ns_param SockClientPeerVerify false
ns_param SockServerPeerVerifyDepth 3
ns_param SockClientCADir ca
ns_param SockClientCAFile ca.pem
ns_param SockClientTrace false

# OpenSSL library support:
# ns_param RandomFile /some/file
ns_param SeedBytes 1024

} else {

#---------------------------------------------------------------------
# OpenSSL for Aolserver 4
#---------------------------------------------------------------------
ns_section "ns/server/${server}/module/nsopenssl"

# Note this portion of the configuration is not perfect, and you
# will get errors in the your error.log. However, it does
# work. Fixes welcome.

# this is used by acs-tcl/tcl/security-procs.tcl to get the
# https port.
ns_param ServerPort $httpsport

# We explicitly tell the server which SSL contexts to use as defaults when an
# SSL context is not specified for a particular client or server SSL
# connection. Driver connections do not use defaults; they must be explicitly
# specificied in the driver section. The Tcl API will use the defaults as there
# is currently no provision to specify which SSL context to use for a
# particular connection via an ns_openssl Tcl command.
ns_section "ns/server/${server}/module/nsopenssl/sslcontexts"
ns_param users "SSL context used for regular user access"
# ns_param admins "SSL context used for administrator access"
ns_param client "SSL context used for outgoing script socket connections"

ns_section "ns/server/${server}/module/nsopenssl/defaults"
ns_param server users
ns_param client client

ns_section "ns/server/${server}/module/nsopenssl/sslcontext/users"
ns_param Role server
ns_param ModuleDir ${serverroot}/etc/certs
ns_param CertFile certfile.pem
ns_param KeyFile keyfile.pem
# ns_param CADir ca-client/dir
# ns_param CAFile ca-client/ca-client.crt
# for Protocols "ALL" = "SSLv2, SSLv3, TLSv1"
ns_param Protocols "SSLv3, TLSv1"
ns_param CipherSuite "ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP"
ns_param PeerVerify false
ns_param PeerVerifyDepth 3
ns_param Trace false

# following from bartt's nsd4.tcl, might help stablize openssl connections?
# http://www.mail-archive.com/aolserver@listserv.aol.com/msg07092.html
ns_param SessionCache true
ns_param SessionCacheID 1
ns_param SessionCacheSize 512
ns_param SessionCacheTimeout 300

# ns_section "ns/server/${server}/module/nsopenssl/sslcontext/admins"
# ns_param Role server
# ns_param ModuleDir /path/to/dir
# ns_param CertFile server/server.crt
# ns_param KeyFile server/server.key
# ns_param CADir ca-client/dir
# ns_param CAFile ca-client/ca-client.crt
# for Protocols "ALL" = "SSLv2, SSLv3, TLSv1"
# ns_param Protocols "All"
# ns_param CipherSuite "ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP"
# ns_param PeerVerify false
# ns_param PeerVerifyDepth 3
# ns_param Trace false

ns_section "ns/server/${server}/module/nsopenssl/sslcontext/client"
ns_param Role client
ns_param ModuleDir ${serverroot}/etc/certs
ns_param CertFile certfile.pem
ns_param KeyFile keyfile.pem
# ns_param CADir ${serverroot}/etc/certs
# ns_param CAFile certfile.pem
# for Protocols "ALL" = "SSLv2, SSLv3, TLSv1"
ns_param Protocols "SSLv2, SSLv3, TLSv1"
ns_param CipherSuite "ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP"
ns_param PeerVerify false
ns_param PeerVerifyDepth 3
ns_param Trace false

# following from bartt's nsd4.tcl, might help stablize openssl connections?
# http://www.mail-archive.com/aolserver@listserv.aol.com/msg07092.html
ns_param SessionCache true
ns_param SessionCacheID 1
ns_param SessionCacheSize 512
ns_param SessionCacheTimeout 300

# SSL drivers. Each driver defines a port to listen on and an explitictly named
# SSL context to associate with it. Note that you can now have multiple driver
# connections within a single virtual server, which can be tied to different
# SSL contexts.
ns_section "ns/server/${server}/module/nsopenssl/ssldrivers"
ns_param users "Driver for regular user access"
# ns_param admins "Driver for administrator access"

ns_section "ns/server/${server}/module/nsopenssl/ssldriver/users"
ns_param sslcontext users
# ns_param port $httpsport_users
ns_param port $httpsport
ns_param hostname $hostname
ns_param address $address
# following added per
# http://www.mail-archive.com/aolserver@listserv.aol.com/msg07365.html
# Maximum File Size for uploads:
ns_param maxinput [expr 5 * 1024 * 1024] ;# in bytes
# Maximum request time
ns_param recvwait [expr 5 * 60] ;# in minutes

# ns_section "ns/server/${server}/module/nsopenssl/ssldriver/admins"
# ns_param sslcontext admins
# ns_param port $httpsport_admins
# ns_param port $httpsport
# ns_param hostname $hostname
# ns_param address $address
}

#---------------------------------------------------------------------
#
# Database drivers
# The database driver is specified here.
# Make sure you have the driver compiled and put it in {aolserverdir}/bin
#
#---------------------------------------------------------------------
ns_section "ns/db/drivers"
if { $database == "oracle" } {
ns_param ora8 ${bindir}/ora8.so
} else {
ns_param postgres ${bindir}/nspostgres.so ;# Load PostgreSQL driver
}

if { $database == "oracle" } {
ns_section "ns/db/driver/ora8"
ns_param maxStringLogLength -1
ns_param LobBufferSize 32768
}

# Database Pools: This is how AOLserver ``talks'' to the RDBMS. You need
# three for OpenACS: main, log, subquery. Make sure to replace ``yourdb''
# and ``yourpassword'' with the actual values for your db name and the
# password for it, if needed.
#
# AOLserver can have different pools connecting to different databases
# and even different different database servers. See
# http://openacs.org/doc/openacs-5-1/tutorial-second-database.html

ns_section ns/db/pools
ns_param pool1 "Pool 1"
ns_param pool2 "Pool 2"
ns_param pool3 "Pool 3"

ns_section ns/db/pool/pool1
ns_param maxidle 1000000000
ns_param maxopen 1000000000
ns_param connections 5
ns_param verbose $debug
ns_param extendedtableinfo true
ns_param logsqlerrors $debug
if { $database == "oracle" } {
ns_param driver ora8
ns_param datasource {}
ns_param user $db_name
ns_param password $db_password
} else {
ns_param driver postgres
ns_param datasource ${db_host}:${db_port}:${db_name}
ns_param user $db_user
ns_param password ""
}

ns_section ns/db/pool/pool2
ns_param maxidle 1000000000
ns_param maxopen 1000000000
ns_param connections 5
ns_param verbose $debug
ns_param extendedtableinfo true
ns_param logsqlerrors $debug
if { $database == "oracle" } {
ns_param driver ora8
ns_param datasource {}
ns_param user $db_name
ns_param password $db_password
} else {
ns_param driver postgres
ns_param datasource ${db_host}:${db_port}:${db_name}
ns_param user $db_user
ns_param password ""
}

ns_section ns/db/pool/pool3
ns_param maxidle 1000000000
ns_param maxopen 1000000000
ns_param connections 5
ns_param verbose $debug
ns_param extendedtableinfo true
ns_param logsqlerrors $debug
if { $database == "oracle" } {
ns_param driver ora8
ns_param datasource {}
ns_param user $db_name
ns_param password $db_password
} else {
ns_param driver postgres
ns_param datasource ${db_host}:${db_port}:${db_name}
ns_param user $db_user
ns_param password ""
}

ns_section ns/server/${server}/db
ns_param pools "*"
ns_param defaultpool pool1

#---------------------------------------------------------------------
# which modules should be loaded? Missing modules break the server, so
# don't uncomment modules unless they have been installed.
ns_section ns/server/${server}/modules
ns_param nssock ${bindir}/nssock.so
ns_param nslog ${bindir}/nslog.so
ns_param nssha1 ${bindir}/nssha1.so
ns_param nscache ${bindir}/nscache.so

# openacs versions earlier than 5.x requires nsxml
# ns_param nsxml ${bindir}/nsxml.so

#---------------------------------------------------------------------
# nsopenssl will fail unless the cert files are present as specified
# later in this file, so it's disabled by default
# ns_param nsopenssl ${bindir}/nsopenssl.so

# authorize-gateway package requires dqd_utils
# ns_param dqd_utils dqd_utils[expr {int($tcl_version)}].so

# Full Text Search
# ns_param nsfts ${bindir}/nsfts.so

# PAM authentication
# ns_param nspam ${bindir}/nspam.so

# LDAP authentication
# ns_param nsldap ${bindir}/nsldap.so

# These modules aren't used in standard OpenACS installs
# ns_param nsperm ${bindir}/nsperm.so
# ns_param nscgi ${bindir}/nscgi.so
# ns_param nsjava ${bindir}/libnsjava.so
# ns_param nsrewrite ${bindir}/nsrewrite.so

if { [ns_info version] >= 4 } {
# Required for AOLserver 4.x
ns_param nsdb ${bindir}/nsdb.so
} else {
# Required for AOLserver 3.x
ns_param libtdom ${bindir}/libtdom.so
}

ns_log notice "nsd.tcl: using threadsafe tcl: [info exists tcl_platform(threaded)]"
ns_log notice "nsd.tcl: finished reading config file."

------------------------------------------------------------

2. the rest of errors in error.log

[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/util-diff-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Bootstrap: Installation is not complete - sourcing the installer.
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Sourcing files for postload...
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Done.
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: Executing initialization code blocks...
[08/Sep/2011:11:42:46][5407.3054005104][-default:0-] Notice: random: generating 1 seed
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: nsmain: AOLserver/4.5.1 running
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[08/Sep/2011:11:42:46][5407.3076118208][-main-] Notice: driver: starting: nssock
[08/Sep/2011:11:42:46][5407.3065977712][-sched-] Notice: sched: starting
[08/Sep/2011:11:42:46][5407.3027204976][-nssock:driver-] Notice: starting
[08/Sep/2011:11:42:46][5407.3027204976][-nssock:driver-] Notice: nssock: listening on 127.0.0.1:8000
[08/Sep/2011:14:33:37][5407.3076118208][-main-] Notice: nsmain: AOLserver/4.5.1 stopping
[08/Sep/2011:14:33:37][5407.3076118208][-main-] Notice: driver: stopping: nssock
[08/Sep/2011:14:33:37][5407.3076118208][-main-] Notice: sched: shutdown pending
[08/Sep/2011:14:33:37][5407.3027204976][-nssock:driver-] Notice: exiting
[08/Sep/2011:14:33:37][5407.3065977712][-sched-] Notice: sched: shutdown started
[08/Sep/2011:14:33:37][5407.3065977712][-sched-] Notice: sched: shutdown complete
[08/Sep/2011:14:33:37][5407.3044014960][-default:2-] Notice: exiting: shutdown pending
[08/Sep/2011:14:33:37][5407.3076118208][-main-] Notice: driver: stopped: nssock
[08/Sep/2011:14:33:37][5407.3054005104][-default:0-] Notice: exiting: shutdown pending
[08/Sep/2011:14:33:37][5407.3035609968][-default:3-] Notice: exiting: shutdown pending
[08/Sep/2011:14:33:37][5407.3049802608][-default:1-] Notice: exiting: shutdown pending
[08/Sep/2011:14:33:37][5407.3039812464][-default:4-] Notice: exiting: shutdown pending
[08/Sep/2011:14:33:37][5407.3027204976][-shutdown-] Notice: nslog: closing '/usr/share/openacs/log/openacs.log'
[08/Sep/2011:14:33:37][5407.3076118208][-main-] Notice: nsmain: AOLserver/4.5.1 exiting
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: nsmain: AOLserver/4.5.1 starting
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: encoding: loaded: utf-8
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: fastpath[openacs]: mapped GET /
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: fastpath[openacs]: mapped HEAD /
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: fastpath[openacs]: mapped POST /
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: adp[openacs]: mapped GET /*.adp
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: adp[openacs]: mapped HEAD /*.adp
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: adp[openacs]: mapped POST /*.adp
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssock.so'
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nslog.so'
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: nslog: opened '/usr/share/openacs/log/openacs.log'
[08/Sep/2011:14:34:25][1177.3074541248][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssha1.so'
[08/Sep/2011:14:34:26][1177.3074541248][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsdb.so'
[08/Sep/2011:14:34:26][1177.3074541248][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nspostgres.so'
[08/Sep/2011:14:34:26][1177.3074541248][-main-] Notice: PostgreSQL loaded.
[08/Sep/2011:14:34:26][1177.3074541248][-main-] Notice: modload: loading '/usr/lib/tcltk/thread2.6.5/libthread2.6.5-aolserver.so'
[08/Sep/2011:14:34:27][1177.3074541248][-main-] Notice: conf: [ns/server/openacs]enabletclpages = 0
[08/Sep/2011:14:34:27][1177.3074541248][-main-] Notice: default thread pool: minthreads 5 maxthreads 10 idle 0 current 0 maxconns 100 queued 0 timeout 120 spread 20
[08/Sep/2011:14:34:32][1177.3074541248][-main-] Notice: XOTcl version 1.6.6 loaded
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Loading OpenACS, rooted at /usr/share/openacs
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Sourcing /usr/share/openacs/packages/acs-bootstrap-installer/bootstrap.tcl
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Database API: Default database (dbn) is: 'default'
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Database API: The following pools are available for OpenACS: pool1 pool2 pool3
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Opening openacs on localhost
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Error: Ns_PgOpenDb(postgres): Could not connect to localhost:5432:openacs: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

[08/Sep/2011:14:34:33][1177.3074541248][-main-] Error: dbdrv: failed to open database 'postgres:localhost:5432:openacs'
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Warning: Database API: couldn't allocate a handle from database pool "pool1".
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Error: Database API: RDBMS type could not be determined for any pool.
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Bootstrap: Loading acs-tcl
[08/Sep/2011:14:34:33][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[08/Sep/2011:14:34:34][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[08/Sep/2011:14:34:34][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[08/Sep/2011:14:34:34][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[08/Sep/2011:14:34:34][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[08/Sep/2011:14:34:34][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[08/Sep/2011:14:34:34][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[08/Sep/2011:14:34:34][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/application-data-link-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/application-link-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/callback-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/ds-stub-procs.tcl
[08/Sep/2011:14:34:35][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[08/Sep/2011:14:34:36][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[08/Sep/2011:14:34:36][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[08/Sep/2011:14:34:36][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/http-auth-procs.tcl
[08/Sep/2011:14:34:36][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[08/Sep/2011:14:34:36][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/install-procs.tcl
[08/Sep/2011:14:34:36][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[08/Sep/2011:14:34:36][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[08/Sep/2011:14:34:37][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/navigation-callback-procs.tcl
[08/Sep/2011:14:34:37][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[08/Sep/2011:14:34:37][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[08/Sep/2011:14:34:37][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[08/Sep/2011:14:34:37][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[08/Sep/2011:14:34:37][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[08/Sep/2011:14:34:38][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/pdf-procs.tcl
[08/Sep/2011:14:34:38][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/proxy-procs.tcl
[08/Sep/2011:14:34:38][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[08/Sep/2011:14:34:38][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[08/Sep/2011:14:34:38][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[08/Sep/2011:14:34:38][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[08/Sep/2011:14:34:39][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[08/Sep/2011:14:34:39][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[08/Sep/2011:14:34:39][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[08/Sep/2011:14:34:39][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[08/Sep/2011:14:34:39][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[08/Sep/2011:14:34:39][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/stack-trace-procs.tcl
[08/Sep/2011:14:34:40][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[08/Sep/2011:14:34:40][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[08/Sep/2011:14:34:40][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/tdom-procs.tcl
[08/Sep/2011:14:34:40][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[08/Sep/2011:14:34:40][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[08/Sep/2011:14:34:40][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/util-diff-procs.tcl
[08/Sep/2011:14:34:40][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[08/Sep/2011:14:34:40][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[08/Sep/2011:14:34:41][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[08/Sep/2011:14:34:41][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[08/Sep/2011:14:34:41][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[08/Sep/2011:14:34:41][1177.3074541248][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[08/Sep/2011:14:34:41][1177.3074541248][-main-] Error: Bootstrap:

The following database pools generated errors:

OpenACS could not allocate a handle from database pool "pool1".

Possible causes might include:

The database is not running.
The database driver has not been correctly installed.
The datasource or database user/password are incorrect.
You didn't define any database pools.

[08/Sep/2011:14:34:41][1177.3074541248][-main-] Notice: Bootstrap: database problem found; Sourcing the installer.
[08/Sep/2011:14:34:41][1177.3074541248][-main-] Notice: Sourcing files for postload...
[08/Sep/2011:14:34:42][1177.3074541248][-main-] Notice: Done.
[08/Sep/2011:14:34:42][1177.3074541248][-main-] Notice: Executing initialization code blocks...
[08/Sep/2011:14:34:42][1177.3054025584][-default:0-] Notice: random: generating 1 seed
[08/Sep/2011:14:34:42][1177.3074541248][-main-] Notice: nsmain: AOLserver/4.5.1 running
[08/Sep/2011:14:34:42][1177.3074541248][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[08/Sep/2011:14:34:42][1177.3074541248][-main-] Notice: driver: starting: nssock
[08/Sep/2011:14:34:42][1177.3065928560][-sched-] Notice: sched: starting
[08/Sep/2011:14:34:42][1177.3028810608][-nssock:driver-] Notice: starting
[08/Sep/2011:14:34:42][1177.3028810608][-nssock:driver-] Notice: nssock: listening on 127.0.0.1:8000
[08/Sep/2011:14:37:04][1177.3054025584][-default:0-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[08/Sep/2011:14:37:04][1177.3054025584][-default:0-] Notice: Opening openacs on localhost
[08/Sep/2011:14:37:04][1177.3054025584][-default:0-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost:5432:openacs.
[08/Sep/2011:14:37:04][1177.3054025584][-default:0-] Error: Tcl exception:
No fullquery for dbqd.acs-tcl.tcl.request-processor-procs.ad_acs_kernel_id_mem.acs_kernel_id_get and default SQL empty - query for statement missing
while executing
"error "No fullquery for $statement_name and default SQL empty - query for statement missing""
(procedure "db_qd_replace_sql" line 10)
invoked from within
"db_qd_replace_sql $statement_name $pre_sql"
(procedure "db_exec" line 13)
invoked from within
"db_exec 0or1row $db $full_name $sql"
invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec 0or1row $db $full_name $sql]
}"
(procedure "db_string" line 27)
invoked from within
"db_string acs_kernel_id_get {} -default 0"
(procedure "ad_acs_kernel_id_mem" line 2)
invoked from within
"ad_acs_kernel_id_mem"
(procedure "ad_acs_kernel_id" line 2)
invoked from within
"ad_acs_kernel_id"
(procedure "util_current_location" line 16)
invoked from within
"util_current_location"
(procedure "ad_returnredirect" line 18)
invoked from within
"ad_returnredirect "/""
(procedure "install_handler" line 32)
invoked from within
"install_handler cns1 {} preauth"
[08/Sep/2011:14:37:06][1177.3049823088][-default:2-] Error: Tcl exception:
No fullquery for dbqd.acs-tcl.tcl.request-processor-procs.ad_acs_kernel_id_mem.acs_kernel_id_get and default SQL empty - query for statement missing
while executing
"error "No fullquery for $statement_name and default SQL empty - query for statement missing""
(procedure "db_qd_replace_sql" line 10)
invoked from within
"db_qd_replace_sql $statement_name $pre_sql"
(procedure "db_exec" line 13)
invoked from within
"db_exec 0or1row $db $full_name $sql"
invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec 0or1row $db $full_name $sql]
}"
(procedure "db_string" line 27)
invoked from within
"db_string acs_kernel_id_get {} -default 0"
(procedure "ad_acs_kernel_id_mem" line 2)
invoked from within
"ad_acs_kernel_id_mem"
(procedure "ad_acs_kernel_id" line 2)
invoked from within
"ad_acs_kernel_id"
(procedure "util_current_location" line 16)
invoked from within
"util_current_location"
(procedure "ad_returnredirect" line 18)
invoked from within
"ad_returnredirect "/""
(procedure "install_handler" line 32)
invoked from within
"install_handler cns2 {} preauth"
[08/Sep/2011:14:43:12][1177.3045620592][-default:1-] Error: Tcl exception:
No fullquery for dbqd.acs-tcl.tcl.request-processor-procs.ad_acs_kernel_id_mem.acs_kernel_id_get and default SQL empty - query for statement missing
while executing
"error "No fullquery for $statement_name and default SQL empty - query for statement missing""
(procedure "db_qd_replace_sql" line 10)
invoked from within
"db_qd_replace_sql $statement_name $pre_sql"
(procedure "db_exec" line 13)
invoked from within
"db_exec 0or1row $db $full_name $sql"
invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec 0or1row $db $full_name $sql]
}"
(procedure "db_string" line 27)
invoked from within
"db_string acs_kernel_id_get {} -default 0"
(procedure "ad_acs_kernel_id_mem" line 2)
invoked from within
"ad_acs_kernel_id_mem"
(procedure "ad_acs_kernel_id" line 2)
invoked from within
"ad_acs_kernel_id"
(procedure "util_current_location" line 16)
invoked from within
"util_current_location"
(procedure "ad_returnredirect" line 18)
invoked from within
"ad_returnredirect "/""
(procedure "install_handler" line 32)
invoked from within
"install_handler cns5 {} preauth"
[08/Sep/2011:14:43:22][1177.3054025584][-default:0-] Error: Unable to source /usr/share/openacs/packages/acs-bootstrap-installer/installer/openacs.tcl: file does not exist.
[08/Sep/2011:15:40:43][1177.3049823088][-default:2-] Error: Unable to source /usr/share/openacs/packages/acs-bootstrap-installer/installer/openacs.tcl: file does not exist.
[08/Sep/2011:17:15:24][1177.3049823088][-default:2-] Error: Tcl exception:
No fullquery for dbqd.acs-tcl.tcl.request-processor-procs.ad_acs_kernel_id_mem.acs_kernel_id_get and default SQL empty - query for statement missing
while executing
"error "No fullquery for $statement_name and default SQL empty - query for statement missing""
(procedure "db_qd_replace_sql" line 10)
invoked from within
"db_qd_replace_sql $statement_name $pre_sql"
(procedure "db_exec" line 13)
invoked from within
"db_exec 0or1row $db $full_name $sql"
invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec 0or1row $db $full_name $sql]
}"
(procedure "db_string" line 27)
invoked from within
"db_string acs_kernel_id_get {} -default 0"
(procedure "ad_acs_kernel_id_mem" line 2)
invoked from within
"ad_acs_kernel_id_mem"
(procedure "ad_acs_kernel_id" line 2)
invoked from within
"ad_acs_kernel_id"
(procedure "rp_serve_concrete_file" line 25)
invoked from within
"rp_serve_concrete_file [ad_conn file]"
(procedure "rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file $path"
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file $path
} notfound val {
install_return 404 "Not found" "
The file you've requested, doesn't exist. Plea..."
(procedure "install_file_serve" line 6)
invoked from within
"install_file_serve "[acs_root_dir]/packages/acs-core-docs/www[join $doc_urlv /]""
(procedure "install_handler" line 8)
invoked from within
"install_handler cns12 {} preauth"
[08/Sep/2011:20:08:30][1177.3074541248][-main-] Notice: nsmain: AOLserver/4.5.1 stopping
[08/Sep/2011:20:08:30][1177.3074541248][-main-] Notice: driver: stopping: nssock
[08/Sep/2011:20:08:30][1177.3074541248][-main-] Notice: sched: shutdown pending
[08/Sep/2011:20:08:30][1177.3037215600][-default:3-] Notice: exiting: shutdown pending
[08/Sep/2011:20:08:30][1177.3028810608][-nssock:driver-] Notice: exiting
[08/Sep/2011:20:08:30][1177.3041418096][-default:4-] Notice: exiting: shutdown pending
[08/Sep/2011:20:08:30][1177.3045620592][-default:1-] Notice: exiting: shutdown pending
[08/Sep/2011:20:08:30][1177.3054025584][-default:0-] Notice: exiting: shutdown pending
[08/Sep/2011:20:08:30][1177.3065928560][-sched-] Notice: sched: shutdown started
[08/Sep/2011:20:08:30][1177.3065928560][-sched-] Notice: sched: shutdown complete
[08/Sep/2011:20:08:30][1177.3049823088][-default:2-] Notice: exiting: shutdown pending
[08/Sep/2011:20:08:30][1177.3074541248][-main-] Notice: driver: stopped: nssock
[08/Sep/2011:20:08:30][1177.3028810608][-shutdown-] Notice: nslog: closing '/usr/share/openacs/log/openacs.log'
[08/Sep/2011:20:08:30][1177.3074541248][-main-] Notice: nsmain: AOLserver/4.5.1 exiting
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: nsmain: AOLserver/4.5.1 starting
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: encoding: loaded: utf-8
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: fastpath[openacs]: mapped GET /
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: fastpath[openacs]: mapped HEAD /
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: fastpath[openacs]: mapped POST /
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: adp[openacs]: mapped GET /*.adp
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: adp[openacs]: mapped HEAD /*.adp
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: adp[openacs]: mapped POST /*.adp
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssock.so'
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nslog.so'
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: nslog: opened '/usr/share/openacs/log/openacs.log'
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssha1.so'
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsdb.so'
[08/Sep/2011:20:09:20][1185.3076187840][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nspostgres.so'
[08/Sep/2011:20:09:22][1185.3076187840][-main-] Notice: PostgreSQL loaded.
[08/Sep/2011:20:09:22][1185.3076187840][-main-] Notice: modload: loading '/usr/lib/tcltk/thread2.6.5/libthread2.6.5-aolserver.so'
[08/Sep/2011:20:09:23][1185.3076187840][-main-] Notice: conf: [ns/server/openacs]enabletclpages = 0
[08/Sep/2011:20:09:23][1185.3076187840][-main-] Notice: default thread pool: minthreads 5 maxthreads 10 idle 0 current 0 maxconns 100 queued 0 timeout 120 spread 20
[08/Sep/2011:20:09:25][1185.3076187840][-main-] Notice: XOTcl version 1.6.6 loaded
[08/Sep/2011:20:09:25][1185.3076187840][-main-] Notice: Loading OpenACS, rooted at /usr/share/openacs
[08/Sep/2011:20:09:25][1185.3076187840][-main-] Notice: Sourcing /usr/share/openacs/packages/acs-bootstrap-installer/bootstrap.tcl
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Notice: Database API: Default database (dbn) is: 'default'
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Notice: Database API: The following pools are available for OpenACS: pool1 pool2 pool3
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Notice: Opening openacs on localhost
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Error: Ns_PgOpenDb(postgres): Could not connect to localhost:5432:openacs: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

[08/Sep/2011:20:09:26][1185.3076187840][-main-] Error: dbdrv: failed to open database 'postgres:localhost:5432:openacs'
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Warning: Database API: couldn't allocate a handle from database pool "pool1".
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Error: Database API: RDBMS type could not be determined for any pool.
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Notice: Bootstrap: Loading acs-tcl
[08/Sep/2011:20:09:26][1185.3076187840][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[08/Sep/2011:20:09:27][1185.3076187840][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.
--------------------------------------------------

let me know any other informations.

thanks

5: Re: DB Connection Error (response to 1)

Posted by danny kim on 09/16/11 04:42 AM

I'm sure my database server(openacs) is running.
review following Info. and previous log and configuration files.

===========================================================================
1. ps

7: Re: DB Connection Error (response to 1)

Posted by danny kim on 09/16/11 07:25 AM

I think Data of Sep 8 is same as 15.
Here,s Sep 15's error log file..

[15/Sep/2011:00:00:00][1184.3067059056][-sched-] Notice: nslog: closing '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:00:00:00][1184.3067059056][-sched-] Notice: nslog: opened '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: nsmain: AOLserver/4.5.1 starting
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: encoding: loaded: utf-8
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: fastpath[openacs]: mapped GET /
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: fastpath[openacs]: mapped HEAD /
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: fastpath[openacs]: mapped POST /
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: adp[openacs]: mapped GET /*.adp
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: adp[openacs]: mapped HEAD /*.adp
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: adp[openacs]: mapped POST /*.adp
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssock.so'
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nslog.so'
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: nslog: opened '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssha1.so'
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsdb.so'
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nspostgres.so'
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: PostgreSQL loaded.
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: modload: loading '/usr/lib/tcltk/thread2.6.5/libthread2.6.5-aolserver.so'
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: conf: [ns/server/openacs]enabletclpages = 0
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: default thread pool: minthreads 5 maxthreads 10 idle 0 current 0 maxconns 100 queued 0 timeout 120 spread 20
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: XOTcl version 1.6.6 loaded
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading OpenACS, rooted at /usr/share/openacs
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Sourcing /usr/share/openacs/packages/acs-bootstrap-installer/bootstrap.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Database API: Default database (dbn) is: 'default'
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Database API: The following pools are available for OpenACS: pool1 pool2 pool3
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Opening openacs on localhost
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost:5432:openacs.
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Opening openacs on localhost
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost:5432:openacs.
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Opening openacs on localhost
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost:5432:openacs.
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Bootstrap: Loading acs-tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/00-database-procs-postgresql.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/application-data-link-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/application-link-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/callback-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/ds-stub-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[15/Sep/2011:07:58:50][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/http-auth-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/install-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/navigation-callback-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/pdf-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/proxy-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/stack-trace-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/tdom-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/util-diff-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Bootstrap: Installation is not complete - sourcing the installer.
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Sourcing files for postload...
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Done.
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: Executing initialization code blocks...
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: nsmain: AOLserver/4.5.1 running
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Notice: driver: starting: nssock
[15/Sep/2011:07:58:51][7667.3044014960][-default:0-] Notice: random: generating 1 seed
[15/Sep/2011:07:58:51][7667.3066153840][-sched-] Notice: sched: starting
[15/Sep/2011:07:58:51][7667.3023002480][-nssock:driver-] Notice: starting
[15/Sep/2011:07:58:51][7667.3023002480][-nssock:driver-] Error: nssock: failed to listen on 127.0.0.1:8000: Address already in use
[15/Sep/2011:07:58:51][7667.3023002480][-nssock:driver-] Notice: exiting
[15/Sep/2011:07:58:51][7667.3076294336][-main-] Fatal: could not start drivers
[15/Sep/2011:10:47:51][1184.3075671744][-main-] Notice: nsmain: AOLserver/4.5.1 stopping
[15/Sep/2011:10:47:51][1184.3075671744][-main-] Notice: driver: stopping: nssock
[15/Sep/2011:10:47:51][1184.3075671744][-main-] Notice: sched: shutdown pending
[15/Sep/2011:10:47:51][1184.3032456048][-nssock:driver-] Notice: exiting
[15/Sep/2011:10:47:51][1184.3045063536][-default:1-] Notice: exiting: shutdown pending
[15/Sep/2011:10:47:51][1184.3036658544][-default:3-] Notice: exiting: shutdown pending
[15/Sep/2011:10:47:51][1184.3067059056][-sched-] Notice: sched: shutdown started
[15/Sep/2011:10:47:51][1184.3067059056][-sched-] Notice: sched: shutdown complete
[15/Sep/2011:10:47:51][1184.3050953584][-default:4-] Notice: exiting: shutdown pending
[15/Sep/2011:10:47:51][1184.3040861040][-default:2-] Notice: exiting: shutdown pending
[15/Sep/2011:10:47:51][1184.3075671744][-main-] Notice: driver: stopped: nssock
[15/Sep/2011:10:47:51][1184.3032456048][-shutdown-] Notice: nslog: closing '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:10:47:51][1184.3075671744][-main-] Notice: nsmain: AOLserver/4.5.1 exiting
[15/Sep/2011:10:47:51][1184.3055156080][-default:0-] Notice: exiting: shutdown pending
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: nsmain: AOLserver/4.5.1 starting
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: encoding: loaded: utf-8
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: fastpath[openacs]: mapped GET /
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: fastpath[openacs]: mapped HEAD /
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: fastpath[openacs]: mapped POST /
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: adp[openacs]: mapped GET /*.adp
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: adp[openacs]: mapped HEAD /*.adp
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: adp[openacs]: mapped POST /*.adp
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssock.so'
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nslog.so'
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: nslog: opened '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssha1.so'
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsdb.so'
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nspostgres.so'
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: PostgreSQL loaded.
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: modload: loading '/usr/lib/tcltk/thread2.6.5/libthread2.6.5-aolserver.so'
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: conf: [ns/server/openacs]enabletclpages = 0
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: default thread pool: minthreads 5 maxthreads 10 idle 0 current 0 maxconns 100 queued 0 timeout 120 spread 20
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: XOTcl version 1.6.6 loaded
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading OpenACS, rooted at /usr/share/openacs
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Sourcing /usr/share/openacs/packages/acs-bootstrap-installer/bootstrap.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Database API: Default database (dbn) is: 'default'
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Database API: The following pools are available for OpenACS: pool1 pool2 pool3
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Opening openacs on localhost
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Error: Ns_PgOpenDb(postgres): Could not connect to localhost:5432:openacs: FATAL: database "openacs" does not exist

[15/Sep/2011:10:48:09][9028.3074459328][-main-] Error: dbdrv: failed to open database 'postgres:localhost:5432:openacs'
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Warning: Database API: couldn't allocate a handle from database pool "pool1".
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Error: Database API: RDBMS type could not be determined for any pool.
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Bootstrap: Loading acs-tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/application-data-link-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/application-link-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/callback-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/ds-stub-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/http-auth-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/install-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/navigation-callback-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/pdf-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/proxy-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/stack-trace-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/tdom-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/util-diff-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[15/Sep/2011:10:48:09][9028.3074459328][-main-] Error: Bootstrap:

The following database pools generated errors:

OpenACS could not allocate a handle from database pool "pool1".

Possible causes might include:

The database is not running.
The database driver has not been correctly installed.
The datasource or database user/password are incorrect.
You didn't define any database pools.

[15/Sep/2011:10:48:09][9028.3074459328][-main-] Notice: Bootstrap: database problem found; Sourcing the installer.
[15/Sep/2011:10:48:10][9028.3074459328][-main-] Notice: Sourcing files for postload...
[15/Sep/2011:10:48:10][9028.3074459328][-main-] Notice: Done.
[15/Sep/2011:10:48:10][9028.3074459328][-main-] Notice: Executing initialization code blocks...
[15/Sep/2011:10:48:10][9028.3052350320][-default:0-] Notice: random: generating 1 seed
[15/Sep/2011:10:48:10][9028.3074459328][-main-] Notice: nsmain: AOLserver/4.5.1 running
[15/Sep/2011:10:48:10][9028.3074459328][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[15/Sep/2011:10:48:10][9028.3074459328][-main-] Notice: driver: starting: nssock
[15/Sep/2011:10:48:10][9028.3064318832][-sched-] Notice: sched: starting
[15/Sep/2011:10:48:10][9028.3025107824][-nssock:driver-] Notice: starting
[15/Sep/2011:10:48:10][9028.3025107824][-nssock:driver-] Notice: nssock: listening on 127.0.0.1:8000
[15/Sep/2011:11:03:55][9028.3074459328][-main-] Notice: nsmain: AOLserver/4.5.1 stopping
[15/Sep/2011:11:03:55][9028.3074459328][-main-] Notice: driver: stopping: nssock
[15/Sep/2011:11:03:55][9028.3074459328][-main-] Notice: sched: shutdown pending
[15/Sep/2011:11:03:55][9028.3025107824][-nssock:driver-] Notice: exiting
[15/Sep/2011:11:03:55][9028.3037715312][-default:3-] Notice: exiting: shutdown pending
[15/Sep/2011:11:03:55][9028.3064318832][-sched-] Notice: sched: shutdown started
[15/Sep/2011:11:03:55][9028.3064318832][-sched-] Notice: sched: shutdown complete
[15/Sep/2011:11:03:55][9028.3074459328][-main-] Notice: driver: stopped: nssock
[15/Sep/2011:11:03:55][9028.3041917808][-default:1-] Notice: exiting: shutdown pending
[15/Sep/2011:11:03:55][9028.3048147824][-default:4-] Notice: exiting: shutdown pending
[15/Sep/2011:11:03:55][9028.3052350320][-default:0-] Notice: exiting: shutdown pending
[15/Sep/2011:11:03:55][9028.3033512816][-default:2-] Notice: exiting: shutdown pending
[15/Sep/2011:11:03:55][9028.3025107824][-shutdown-] Notice: nslog: closing '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:11:03:55][9028.3074459328][-main-] Notice: nsmain: AOLserver/4.5.1 exiting
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: nsmain: AOLserver/4.5.1 starting
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: encoding: loaded: utf-8
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: fastpath[openacs]: mapped GET /
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: fastpath[openacs]: mapped HEAD /
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: fastpath[openacs]: mapped POST /
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: adp[openacs]: mapped GET /*.adp
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: adp[openacs]: mapped HEAD /*.adp
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: adp[openacs]: mapped POST /*.adp
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssock.so'
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nslog.so'
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: nslog: opened '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssha1.so'
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsdb.so'
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nspostgres.so'
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: PostgreSQL loaded.
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: modload: loading '/usr/lib/tcltk/thread2.6.5/libthread2.6.5-aolserver.so'
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: conf: [ns/server/openacs]enabletclpages = 0
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: default thread pool: minthreads 5 maxthreads 10 idle 0 current 0 maxconns 100 queued 0 timeout 120 spread 20
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: XOTcl version 1.6.6 loaded
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading OpenACS, rooted at /usr/share/openacs
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Sourcing /usr/share/openacs/packages/acs-bootstrap-installer/bootstrap.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Database API: Default database (dbn) is: 'default'
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Database API: The following pools are available for OpenACS: pool1 pool2 pool3
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Opening openacs on localhost
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Error: Ns_PgOpenDb(postgres): Could not connect to localhost:5432:openacs: FATAL: database "openacs" does not exist

[15/Sep/2011:11:04:16][9165.3075872448][-main-] Error: dbdrv: failed to open database 'postgres:localhost:5432:openacs'
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Warning: Database API: couldn't allocate a handle from database pool "pool1".
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Error: Database API: RDBMS type could not be determined for any pool.
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Bootstrap: Loading acs-tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/application-data-link-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/application-link-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/callback-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/ds-stub-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/http-auth-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/install-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/navigation-callback-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/pdf-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/proxy-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/stack-trace-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/tdom-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/util-diff-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Error: Bootstrap:

The following database pools generated errors:

OpenACS could not allocate a handle from database pool "pool1".

Possible causes might include:

The database is not running.
The database driver has not been correctly installed.
The datasource or database user/password are incorrect.
You didn't define any database pools.

[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Bootstrap: database problem found; Sourcing the installer.
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Sourcing files for postload...
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Done.
[15/Sep/2011:11:04:16][9165.3075872448][-main-] Notice: Executing initialization code blocks...
[15/Sep/2011:11:04:17][9165.3053763440][-default:0-] Notice: random: generating 1 seed
[15/Sep/2011:11:04:17][9165.3075872448][-main-] Notice: nsmain: AOLserver/4.5.1 running
[15/Sep/2011:11:04:17][9165.3075872448][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[15/Sep/2011:11:04:17][9165.3075872448][-main-] Notice: driver: starting: nssock
[15/Sep/2011:11:04:17][9165.3065731952][-sched-] Notice: sched: starting
[15/Sep/2011:11:04:17][9165.3027204976][-nssock:driver-] Notice: starting
[15/Sep/2011:11:04:17][9165.3027204976][-nssock:driver-] Notice: nssock: listening on 127.0.0.1:8000
[15/Sep/2011:11:21:19][9165.3075872448][-main-] Notice: nsmain: AOLserver/4.5.1 stopping
[15/Sep/2011:11:21:19][9165.3075872448][-main-] Notice: driver: stopping: nssock
[15/Sep/2011:11:21:19][9165.3075872448][-main-] Notice: sched: shutdown pending
[15/Sep/2011:11:21:19][9165.3027204976][-nssock:driver-] Notice: exiting
[15/Sep/2011:11:21:19][9165.3049560944][-default:1-] Notice: exiting: shutdown pending
[15/Sep/2011:11:21:19][9165.3044014960][-default:2-] Notice: exiting: shutdown pending
[15/Sep/2011:11:21:19][9165.3035609968][-default:3-] Notice: exiting: shutdown pending
[15/Sep/2011:11:21:19][9165.3065731952][-sched-] Notice: sched: shutdown started
[15/Sep/2011:11:21:19][9165.3065731952][-sched-] Notice: sched: shutdown complete
[15/Sep/2011:11:21:19][9165.3039812464][-default:4-] Notice: exiting: shutdown pending
[15/Sep/2011:11:21:19][9165.3053763440][-default:0-] Notice: exiting: shutdown pending
[15/Sep/2011:11:21:19][9165.3075872448][-main-] Notice: driver: stopped: nssock
[15/Sep/2011:11:21:19][9165.3027204976][-shutdown-] Notice: nslog: closing '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:11:21:19][9165.3075872448][-main-] Notice: nsmain: AOLserver/4.5.1 exiting
[15/Sep/2011:11:22:09][1187.3075454656][-main-] Notice: nsmain: AOLserver/4.5.1 starting
[15/Sep/2011:11:22:09][1187.3075454656][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[15/Sep/2011:11:22:09][1187.3075454656][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[15/Sep/2011:11:22:09][1187.3075454656][-main-] Notice: encoding: loaded: utf-8
[15/Sep/2011:11:22:09][1187.3075454656][-main-] Notice: fastpath[openacs]: mapped GET /
[15/Sep/2011:11:22:09][1187.3075454656][-main-] Notice: fastpath[openacs]: mapped HEAD /
[15/Sep/2011:11:22:09][1187.3075454656][-main-] Notice: fastpath[openacs]: mapped POST /
[15/Sep/2011:11:22:09][1187.3075454656][-main-] Notice: adp[openacs]: mapped GET /*.adp
[15/Sep/2011:11:22:09][1187.3075454656][-main-] Notice: adp[openacs]: mapped HEAD /*.adp
[15/Sep/2011:11:22:09][1187.3075454656][-main-] Notice: adp[openacs]: mapped POST /*.adp
[15/Sep/2011:11:22:09][1187.3075454656][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssock.so'
[15/Sep/2011:11:22:10][1187.3075454656][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nslog.so'
[15/Sep/2011:11:22:10][1187.3075454656][-main-] Notice: nslog: opened '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:11:22:10][1187.3075454656][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssha1.so'
[15/Sep/2011:11:22:10][1187.3075454656][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsdb.so'
[15/Sep/2011:11:22:11][1187.3075454656][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nspostgres.so'
[15/Sep/2011:11:22:11][1187.3075454656][-main-] Notice: PostgreSQL loaded.
[15/Sep/2011:11:22:11][1187.3075454656][-main-] Notice: modload: loading '/usr/lib/tcltk/thread2.6.5/libthread2.6.5-aolserver.so'
[15/Sep/2011:11:22:11][1187.3075454656][-main-] Notice: conf: [ns/server/openacs]enabletclpages = 0
[15/Sep/2011:11:22:11][1187.3075454656][-main-] Notice: default thread pool: minthreads 5 maxthreads 10 idle 0 current 0 maxconns 100 queued 0 timeout 120 spread 20
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: XOTcl version 1.6.6 loaded
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Loading OpenACS, rooted at /usr/share/openacs
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Sourcing /usr/share/openacs/packages/acs-bootstrap-installer/bootstrap.tcl
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Database API: Default database (dbn) is: 'default'
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Database API: The following pools are available for OpenACS: pool1 pool2 pool3
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Opening openacs on localhost
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Error: Ns_PgOpenDb(postgres): Could not connect to localhost:5432:openacs: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

[15/Sep/2011:11:22:18][1187.3075454656][-main-] Error: dbdrv: failed to open database 'postgres:localhost:5432:openacs'
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Warning: Database API: couldn't allocate a handle from database pool "pool1".
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Error: Database API: RDBMS type could not be determined for any pool.
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Bootstrap: Loading acs-tcl
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[15/Sep/2011:11:22:18][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/application-data-link-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/application-link-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/callback-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[15/Sep/2011:11:22:19][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[15/Sep/2011:11:22:20][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[15/Sep/2011:11:22:20][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[15/Sep/2011:11:22:20][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/ds-stub-procs.tcl
[15/Sep/2011:11:22:20][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[15/Sep/2011:11:22:20][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[15/Sep/2011:11:22:20][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[15/Sep/2011:11:22:20][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/http-auth-procs.tcl
[15/Sep/2011:11:22:20][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/install-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/navigation-callback-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/pdf-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/proxy-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[15/Sep/2011:11:22:21][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[15/Sep/2011:11:22:22][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[15/Sep/2011:11:22:22][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[15/Sep/2011:11:22:22][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[15/Sep/2011:11:22:22][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[15/Sep/2011:11:22:23][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[15/Sep/2011:11:22:23][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[15/Sep/2011:11:22:23][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/stack-trace-procs.tcl
[15/Sep/2011:11:22:23][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[15/Sep/2011:11:22:23][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/tdom-procs.tcl
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/util-diff-procs.tcl
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Error: Bootstrap:

The following database pools generated errors:

OpenACS could not allocate a handle from database pool "pool1".

Possible causes might include:

The database is not running.
The database driver has not been correctly installed.
The datasource or database user/password are incorrect.
You didn't define any database pools.

[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Bootstrap: database problem found; Sourcing the installer.
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Sourcing files for postload...
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Done.
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: Executing initialization code blocks...
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: nsmain: AOLserver/4.5.1 running
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[15/Sep/2011:11:22:24][1187.3066841968][-sched-] Notice: sched: starting
[15/Sep/2011:11:22:24][1187.3075454656][-main-] Notice: driver: starting: nssock
[15/Sep/2011:11:22:24][1187.3042331504][-default:0-] Notice: random: generating 1 seed
[15/Sep/2011:11:22:24][1187.3033926512][-nssock:driver-] Notice: starting
[15/Sep/2011:11:22:24][1187.3033926512][-nssock:driver-] Notice: nssock: listening on 127.0.0.1:8000
[15/Sep/2011:11:24:32][1187.3046534000][-default:1-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[15/Sep/2011:11:24:32][1187.3046534000][-default:1-] Notice: Opening openacs on localhost
[15/Sep/2011:11:24:32][1187.3046534000][-default:1-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost:5432:openacs.
[15/Sep/2011:11:24:32][1187.3046534000][-default:1-] Error: Tcl exception:
No fullquery for dbqd.acs-tcl.tcl.request-processor-procs.ad_acs_kernel_id_mem.acs_kernel_id_get and default SQL empty - query for statement missing
while executing
"error "No fullquery for $statement_name and default SQL empty - query for statement missing""
(procedure "db_qd_replace_sql" line 10)
invoked from within
"db_qd_replace_sql $statement_name $pre_sql"
(procedure "db_exec" line 13)
invoked from within
"db_exec 0or1row $db $full_name $sql"
invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec 0or1row $db $full_name $sql]
}"
(procedure "db_string" line 27)
invoked from within
"db_string acs_kernel_id_get {} -default 0"
(procedure "ad_acs_kernel_id_mem" line 2)
invoked from within
"ad_acs_kernel_id_mem"
(procedure "ad_acs_kernel_id" line 2)
invoked from within
"ad_acs_kernel_id"
(procedure "util_current_location" line 16)
invoked from within
"util_current_location"
(procedure "ad_returnredirect" line 18)
invoked from within
"ad_returnredirect "/""
(procedure "install_handler" line 32)
invoked from within
"install_handler cns1 {} preauth"
[15/Sep/2011:16:43:55][1187.3075454656][-main-] Notice: nsmain: AOLserver/4.5.1 stopping
[15/Sep/2011:16:43:55][1187.3075454656][-main-] Notice: driver: stopping: nssock
[15/Sep/2011:16:43:55][1187.3075454656][-main-] Notice: sched: shutdown pending
[15/Sep/2011:16:43:55][1187.3033926512][-nssock:driver-] Notice: exiting
[15/Sep/2011:16:43:55][1187.3054938992][-default:2-] Notice: exiting: shutdown pending
[15/Sep/2011:16:43:55][1187.3066841968][-sched-] Notice: sched: shutdown started
[15/Sep/2011:16:43:55][1187.3066841968][-sched-] Notice: sched: shutdown complete
[15/Sep/2011:16:43:55][1187.3038129008][-default:3-] Notice: exiting: shutdown pending
[15/Sep/2011:16:43:55][1187.3050736496][-default:4-] Notice: exiting: shutdown pending
[15/Sep/2011:16:43:55][1187.3042331504][-default:0-] Notice: exiting: shutdown pending
[15/Sep/2011:16:43:55][1187.3046534000][-default:1-] Notice: exiting: shutdown pending
[15/Sep/2011:16:43:55][1187.3075454656][-main-] Notice: driver: stopped: nssock
[15/Sep/2011:16:43:55][1187.3033926512][-shutdown-] Notice: nslog: closing '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:16:43:55][1187.3075454656][-main-] Notice: nsmain: AOLserver/4.5.1 exiting
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: nsmain: AOLserver/4.5.1 starting
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: encoding: loaded: utf-8
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: fastpath[openacs]: mapped GET /
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: fastpath[openacs]: mapped HEAD /
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: fastpath[openacs]: mapped POST /
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: adp[openacs]: mapped GET /*.adp
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: adp[openacs]: mapped HEAD /*.adp
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: adp[openacs]: mapped POST /*.adp
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssock.so'
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nslog.so'
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: nslog: opened '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssha1.so'
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsdb.so'
[15/Sep/2011:16:44:41][1183.3074565824][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nspostgres.so'
[15/Sep/2011:16:44:42][1183.3074565824][-main-] Notice: PostgreSQL loaded.
[15/Sep/2011:16:44:42][1183.3074565824][-main-] Notice: modload: loading '/usr/lib/tcltk/thread2.6.5/libthread2.6.5-aolserver.so'
[15/Sep/2011:16:44:42][1183.3074565824][-main-] Notice: conf: [ns/server/openacs]enabletclpages = 0
[15/Sep/2011:16:44:42][1183.3074565824][-main-] Notice: default thread pool: minthreads 5 maxthreads 10 idle 0 current 0 maxconns 100 queued 0 timeout 120 spread 20
[15/Sep/2011:16:44:54][1183.3074565824][-main-] Notice: XOTcl version 1.6.6 loaded
[15/Sep/2011:16:44:54][1183.3074565824][-main-] Notice: Loading OpenACS, rooted at /usr/share/openacs
[15/Sep/2011:16:44:54][1183.3074565824][-main-] Notice: Sourcing /usr/share/openacs/packages/acs-bootstrap-installer/bootstrap.tcl
[15/Sep/2011:16:44:55][1183.3074565824][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[15/Sep/2011:16:44:55][1183.3074565824][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[15/Sep/2011:16:44:55][1183.3074565824][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[15/Sep/2011:16:44:55][1183.3074565824][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[15/Sep/2011:16:44:55][1183.3074565824][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Database API: Default database (dbn) is: 'default'
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Database API: The following pools are available for OpenACS: pool1 pool2 pool3
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Opening openacs on localhost
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Error: Ns_PgOpenDb(postgres): Could not connect to localhost:5432:openacs: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

[15/Sep/2011:16:44:56][1183.3074565824][-main-] Error: dbdrv: failed to open database 'postgres:localhost:5432:openacs'
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Warning: Database API: couldn't allocate a handle from database pool "pool1".
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Error: Database API: RDBMS type could not be determined for any pool.
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Bootstrap: Loading acs-tcl
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[15/Sep/2011:16:44:56][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[15/Sep/2011:16:44:57][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[15/Sep/2011:16:44:57][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[15/Sep/2011:16:44:57][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[15/Sep/2011:16:44:57][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[15/Sep/2011:16:44:57][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[15/Sep/2011:16:44:57][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/application-data-link-procs.tcl
[15/Sep/2011:16:44:57][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/application-link-procs.tcl
[15/Sep/2011:16:44:57][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/callback-procs.tcl
[15/Sep/2011:16:44:57][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[15/Sep/2011:16:44:57][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[15/Sep/2011:16:44:57][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[15/Sep/2011:16:44:57][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[15/Sep/2011:16:44:58][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[15/Sep/2011:16:44:58][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/ds-stub-procs.tcl
[15/Sep/2011:16:44:58][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[15/Sep/2011:16:44:58][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[15/Sep/2011:16:44:58][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[15/Sep/2011:16:44:59][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/http-auth-procs.tcl
[15/Sep/2011:16:44:59][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[15/Sep/2011:16:44:59][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/install-procs.tcl
[15/Sep/2011:16:44:59][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[15/Sep/2011:16:44:59][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[15/Sep/2011:16:44:59][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/navigation-callback-procs.tcl
[15/Sep/2011:16:44:59][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[15/Sep/2011:16:44:59][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[15/Sep/2011:16:44:59][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[15/Sep/2011:16:44:59][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[15/Sep/2011:16:44:59][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[15/Sep/2011:16:44:59][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/pdf-procs.tcl
[15/Sep/2011:16:45:00][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/proxy-procs.tcl
[15/Sep/2011:16:45:00][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[15/Sep/2011:16:45:00][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[15/Sep/2011:16:45:00][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[15/Sep/2011:16:45:00][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[15/Sep/2011:16:45:00][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[15/Sep/2011:16:45:00][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[15/Sep/2011:16:45:00][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[15/Sep/2011:16:45:00][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[15/Sep/2011:16:45:00][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[15/Sep/2011:16:45:00][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/stack-trace-procs.tcl
[15/Sep/2011:16:45:00][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[15/Sep/2011:16:45:01][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[15/Sep/2011:16:45:01][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/tdom-procs.tcl
[15/Sep/2011:16:45:01][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[15/Sep/2011:16:45:01][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[15/Sep/2011:16:45:01][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/util-diff-procs.tcl
[15/Sep/2011:16:45:01][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[15/Sep/2011:16:45:01][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[15/Sep/2011:16:45:01][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[15/Sep/2011:16:45:01][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[15/Sep/2011:16:45:01][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[15/Sep/2011:16:45:01][1183.3074565824][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[15/Sep/2011:16:45:01][1183.3074565824][-main-] Error: Bootstrap:

The following database pools generated errors:

OpenACS could not allocate a handle from database pool "pool1".

Possible causes might include:

The database is not running.
The database driver has not been correctly installed.
The datasource or database user/password are incorrect.
You didn't define any database pools.

[15/Sep/2011:16:45:02][1183.3074565824][-main-] Notice: Bootstrap: database problem found; Sourcing the installer.
[15/Sep/2011:16:45:02][1183.3074565824][-main-] Notice: Sourcing files for postload...
[15/Sep/2011:16:45:02][1183.3074565824][-main-] Notice: Done.
[15/Sep/2011:16:45:02][1183.3074565824][-main-] Notice: Executing initialization code blocks...
[15/Sep/2011:16:45:03][1183.3054050160][-default:0-] Notice: random: generating 1 seed
[15/Sep/2011:16:45:03][1183.3074565824][-main-] Notice: nsmain: AOLserver/4.5.1 running
[15/Sep/2011:16:45:03][1183.3074565824][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[15/Sep/2011:16:45:03][1183.3074565824][-main-] Notice: driver: starting: nssock
[15/Sep/2011:16:45:03][1183.3065953136][-sched-] Notice: sched: starting
[15/Sep/2011:16:45:03][1183.3027213168][-nssock:driver-] Notice: starting
[15/Sep/2011:16:45:03][1183.3027213168][-nssock:driver-] Notice: nssock: listening on 127.0.0.1:8000
[15/Sep/2011:16:45:47][1183.3049847664][-default:2-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[15/Sep/2011:16:45:47][1183.3049847664][-default:2-] Notice: Opening openacs on localhost
[15/Sep/2011:16:45:47][1183.3049847664][-default:2-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost:5432:openacs.
[15/Sep/2011:16:45:47][1183.3049847664][-default:2-] Error: Tcl exception:
No fullquery for dbqd.acs-tcl.tcl.request-processor-procs.ad_acs_kernel_id_mem.acs_kernel_id_get and default SQL empty - query for statement missing
while executing
"error "No fullquery for $statement_name and default SQL empty - query for statement missing""
(procedure "db_qd_replace_sql" line 10)
invoked from within
"db_qd_replace_sql $statement_name $pre_sql"
(procedure "db_exec" line 13)
invoked from within
"db_exec 0or1row $db $full_name $sql"
invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec 0or1row $db $full_name $sql]
}"
(procedure "db_string" line 27)
invoked from within
"db_string acs_kernel_id_get {} -default 0"
(procedure "ad_acs_kernel_id_mem" line 2)
invoked from within
"ad_acs_kernel_id_mem"
(procedure "ad_acs_kernel_id" line 2)
invoked from within
"ad_acs_kernel_id"
(procedure "util_current_location" line 16)
invoked from within
"util_current_location"
(procedure "ad_returnredirect" line 18)
invoked from within
"ad_returnredirect "/""
(procedure "install_handler" line 32)
invoked from within
"install_handler cns1 {} preauth"
[15/Sep/2011:16:54:07][1183.3074565824][-main-] Notice: nsmain: AOLserver/4.5.1 stopping
[15/Sep/2011:16:54:07][1183.3074565824][-main-] Notice: driver: stopping: nssock
[15/Sep/2011:16:54:07][1183.3074565824][-main-] Notice: sched: shutdown pending
[15/Sep/2011:16:54:07][1183.3039820656][-default:1-] Notice: exiting: shutdown pending
[15/Sep/2011:16:54:07][1183.3027213168][-nssock:driver-] Notice: exiting
[15/Sep/2011:16:54:07][1183.3045645168][-default:3-] Notice: exiting: shutdown pending
[15/Sep/2011:16:54:07][1183.3065953136][-sched-] Notice: sched: shutdown started
[15/Sep/2011:16:54:07][1183.3065953136][-sched-] Notice: sched: shutdown complete
[15/Sep/2011:16:54:07][1183.3035618160][-default:4-] Notice: exiting: shutdown pending
[15/Sep/2011:16:54:07][1183.3054050160][-default:0-] Notice: exiting: shutdown pending
[15/Sep/2011:16:54:07][1183.3049847664][-default:2-] Notice: exiting: shutdown pending
[15/Sep/2011:16:54:07][1183.3074565824][-main-] Notice: driver: stopped: nssock
[15/Sep/2011:16:54:07][1183.3027213168][-shutdown-] Notice: nslog: closing '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:16:54:07][1183.3074565824][-main-] Notice: nsmain: AOLserver/4.5.1 exiting
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: nsmain: AOLserver/4.5.1 starting
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: encoding: loaded: utf-8
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: fastpath[openacs]: mapped GET /
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: fastpath[openacs]: mapped HEAD /
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: fastpath[openacs]: mapped POST /
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: adp[openacs]: mapped GET /*.adp
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: adp[openacs]: mapped HEAD /*.adp
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: adp[openacs]: mapped POST /*.adp
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssock.so'
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nslog.so'
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: nslog: opened '/usr/share/openacs/log/openacs.log'
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssha1.so'
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsdb.so'
[15/Sep/2011:16:54:51][1188.3075462848][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nspostgres.so'
[15/Sep/2011:16:54:52][1188.3075462848][-main-] Notice: PostgreSQL loaded.
[15/Sep/2011:16:54:52][1188.3075462848][-main-] Notice: modload: loading '/usr/lib/tcltk/thread2.6.5/libthread2.6.5-aolserver.so'
[15/Sep/2011:16:54:52][1188.3075462848][-main-] Notice: conf: [ns/server/openacs]enabletclpages = 0
[15/Sep/2011:16:54:52][1188.3075462848][-main-] Notice: default thread pool: minthreads 5 maxthreads 10 idle 0 current 0 maxconns 100 queued 0 timeout 120 spread 20
[15/Sep/2011:16:55:04][1188.3075462848][-main-] Notice: XOTcl version 1.6.6 loaded
[15/Sep/2011:16:55:04][1188.3075462848][-main-] Notice: Loading OpenACS, rooted at /usr/share/openacs
[15/Sep/2011:16:55:04][1188.3075462848][-main-] Notice: Sourcing /usr/share/openacs/packages/acs-bootstrap-installer/bootstrap.tcl
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: Bootstrap: sourcing /usr/share/openacs/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: Database API: Default database (dbn) is: 'default'
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: Database API: The following pools are available for OpenACS: pool1 pool2 pool3
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: Opening openacs on localhost
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Error: Ns_PgOpenDb(postgres): Could not connect to localhost:5432:openacs: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

[15/Sep/2011:16:55:05][1188.3075462848][-main-] Error: dbdrv: failed to open database 'postgres:localhost:5432:openacs'
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Warning: Database API: couldn't allocate a handle from database pool "pool1".
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Error: Database API: RDBMS type could not be determined for any pool.
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: Bootstrap: Loading acs-tcl
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[15/Sep/2011:16:55:06][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[15/Sep/2011:16:55:06][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[15/Sep/2011:16:55:06][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[15/Sep/2011:16:55:06][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[15/Sep/2011:16:55:06][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[15/Sep/2011:16:55:06][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[15/Sep/2011:16:55:06][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[15/Sep/2011:16:55:06][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[15/Sep/2011:16:55:06][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[15/Sep/2011:16:55:06][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[15/Sep/2011:16:55:06][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[15/Sep/2011:16:55:06][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[15/Sep/2011:16:55:07][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[15/Sep/2011:16:55:07][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/application-data-link-procs.tcl
[15/Sep/2011:16:55:07][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/application-link-procs.tcl
[15/Sep/2011:16:55:07][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/callback-procs.tcl
[15/Sep/2011:16:55:07][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[15/Sep/2011:16:55:07][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[15/Sep/2011:16:55:07][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[15/Sep/2011:16:55:07][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[15/Sep/2011:16:55:08][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[15/Sep/2011:16:55:08][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/ds-stub-procs.tcl
[15/Sep/2011:16:55:08][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[15/Sep/2011:16:55:08][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[15/Sep/2011:16:55:08][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[15/Sep/2011:16:55:09][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/http-auth-procs.tcl
[15/Sep/2011:16:55:09][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[15/Sep/2011:16:55:09][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/install-procs.tcl
[15/Sep/2011:16:55:10][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[15/Sep/2011:16:55:10][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[15/Sep/2011:16:55:10][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/navigation-callback-procs.tcl
[15/Sep/2011:16:55:10][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[15/Sep/2011:16:55:10][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[15/Sep/2011:16:55:10][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[15/Sep/2011:16:55:10][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[15/Sep/2011:16:55:11][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[15/Sep/2011:16:55:11][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/pdf-procs.tcl
[15/Sep/2011:16:55:11][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/proxy-procs.tcl
[15/Sep/2011:16:55:11][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[15/Sep/2011:16:55:11][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/stack-trace-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/tdom-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/util-diff-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Error: Bootstrap:

The following database pools generated errors:

OpenACS could not allocate a handle from database pool "pool1".

Possible causes might include:

The database is not running.
The database driver has not been correctly installed.
The datasource or database user/password are incorrect.
You didn't define any database pools.

[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Bootstrap: database problem found; Sourcing the installer.
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Sourcing files for postload...
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Done.
[15/Sep/2011:16:55:12][1188.3075462848][-main-] Notice: Executing initialization code blocks...
[15/Sep/2011:16:55:13][1188.3075462848][-main-] Notice: nsmain: AOLserver/4.5.1 running
[15/Sep/2011:16:55:13][1188.3075462848][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[15/Sep/2011:16:55:13][1188.3075462848][-main-] Notice: driver: starting: nssock
[15/Sep/2011:16:55:13][1188.3066850160][-sched-] Notice: sched: starting
[15/Sep/2011:16:55:13][1188.3038137200][-default:0-] Notice: random: generating 1 seed
[15/Sep/2011:16:55:13][1188.3033934704][-nssock:driver-] Notice: starting
[15/Sep/2011:16:55:13][1188.3033934704][-nssock:driver-] Notice: nssock: listening on 127.0.0.1:8000
[15/Sep/2011:16:55:57][1188.3046542192][-default:1-] Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[15/Sep/2011:16:55:57][1188.3046542192][-default:1-] Notice: Opening openacs on localhost
[15/Sep/2011:16:55:57][1188.3046542192][-default:1-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost:5432:openacs.
[15/Sep/2011:16:55:57][1188.3046542192][-default:1-] Error: Tcl exception:
No fullquery for dbqd.acs-tcl.tcl.request-processor-procs.ad_acs_kernel_id_mem.acs_kernel_id_get and default SQL empty - query for statement missing
while executing
"error "No fullquery for $statement_name and default SQL empty - query for statement missing""
(procedure "db_qd_replace_sql" line 10)
invoked from within
"db_qd_replace_sql $statement_name $pre_sql"
(procedure "db_exec" line 13)
invoked from within
"db_exec 0or1row $db $full_name $sql"
invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec 0or1row $db $full_name $sql]
}"
(procedure "db_string" line 27)
invoked from within
"db_string acs_kernel_id_get {} -default 0"
(procedure "ad_acs_kernel_id_mem" line 2)
invoked from within
"ad_acs_kernel_id_mem"
(procedure "ad_acs_kernel_id" line 2)
invoked from within
"ad_acs_kernel_id"
(procedure "util_current_location" line 16)
invoked from within
"util_current_location"
(procedure "ad_returnredirect" line 18)
invoked from within
"ad_returnredirect "/""
(procedure "install_handler" line 32)
invoked from within
"install_handler cns1 {} preauth"

-------------------------------------------------------

I think Database is running. I created and inserted table with sql command on openacs DB.

I got database connection problem(5432 port) continuously.

thanks

9: Re: DB Connection Error (response to 1)

Posted by danny kim on 09/16/11 10:11 AM

I made a mistake. here's a right config.tcl.

1. openacs.sh
#!/bin/sh
# These variables can be customized to change OpenACS AOLserver settings.
# More changes can be done by modifying the /etc/openacs/config.tcl Tcl script.
#
AOL_USER=www-data
AOL_GROUP=www-data
AOL_ADDRESS=127.0.0.1
AOL_PORT=8000
RUN_DAEMON=yes
---------------------------------

2. config.tcl
ns_log notice "nsd.tcl: starting to read config file..."

######################################################################
#
# Instance-specific settings
# These default settings will only work in limited circumstances
# Two servers with default settings cannot run on the same host
#
######################################################################

#---------------------------------------------------------------------

# Defined in /etc/aolserver4/conf.d/openacs.sh
set httpport [exec grep "^AOL_PORT" /etc/aolserver4/conf.d/openacs.sh | sed s/AOL_PORT=//]
set address [exec grep "^AOL_ADDRESS" /etc/aolserver4/conf.d/openacs.sh | sed s/AOL_ADDRESS=//]
#---------------------------------------------------------------------

set httpsport 8443

# The hostname and address should be set to actual values.
# setting the address to 0.0.0.0 means aolserver listens on all interfaces
set hostname localhost

# Note: If port is privileged (usually < 1024), OpenACS must be
# started by root, and, in AOLserver 4, the run script have a
# '-b address' flag which matches the address according to settings (above)

set server "openacs"
set servername "New OpenACS Installation"

set serverroot "/usr/share/openacs"
set pidfile /var/run/aolserver4/${server}.pid

#---------------------------------------------------------------------
# which database do you want? postgres or oracle
set database postgres

set db_name $server

if { $database eq "oracle" } {
set db_password "mysitepassword"
} else {
## Debconf changes (DO NOT EDIT BYHAND) ##
set db_host localhost
set db_password ""
set db_port "5432"
set db_user www-data
## End Debconf Changes ###################
}

#---------------------------------------------------------------------
# if debug is false, all debugging will be turned off
set debug false

set homedir /usr/lib/aolserver4
set bindir ${homedir}/bin

set max_file_upload_mb 20
set max_file_upload_min 5

######################################################################
#
# End of instance-specific settings
#
# Nothing below this point need be changed in a default install.
#
######################################################################

#---------------------------------------------------------------------
#
# AOLserver's directories. Autoconfigurable.
#
#---------------------------------------------------------------------
# Where are your pages going to live ?
set pageroot ${serverroot}/www
set directoryfile index.tcl,index.adp,index.html,index.htm

#---------------------------------------------------------------------
# Global server parameters
#---------------------------------------------------------------------
ns_section ns/parameters
ns_param serverlog ${serverroot}/log/error.log
ns_param home $homedir
# maxkeepalive is ignored in aolserver4.x
ns_param maxkeepalive 0
ns_param logroll on
ns_param maxbackup 5
ns_param debug $debug
# ns_param mailhost localhost
ns_param pidfile ${pidfile}
# setting to Unicode by default
# see http://dqd.com/~mayoff/encoding-doc.html
ns_param HackContentType 1
ns_param DefaultCharset utf-8
ns_param HttpOpenCharset utf-8
ns_param OutputCharset utf-8
ns_param URLCharset utf-8

#---------------------------------------------------------------------
# Thread library (nsthread) parameters
#---------------------------------------------------------------------
ns_section ns/threads
ns_param mutexmeter true ;# measure lock contention
# The per-thread stack size must be a multiple of 8k for AOLServer to run under MacOS X
ns_param stacksize [expr {512 * 8192}]

#
# MIME types.
#
ns_section ns/mimetypes
# Note: AOLserver already has an exhaustive list of MIME types:
# see: /usr/local/src/aolserver-4.{version}/aolserver/nsd/mimetypes.c
# but in case something is missing you can add it here.
ns_param Default */*
ns_param NoExtension */*
ns_param .pcd image/x-photo-cd
ns_param .prc application/x-pilot
ns_param .xls application/vnd.ms-excel
ns_param .doc application/vnd.ms-word

#---------------------------------------------------------------------
#
# 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 $server $servername

#
# Server parameters
#
ns_section ns/server/${server}
ns_param directoryfile $directoryfile
ns_param pageroot $pageroot
ns_param maxconnections 100 ;# Max connections to put on queue
ns_param maxdropped 0
ns_param maxthreads 10
ns_param minthreads 5
ns_param threadtimeout 120 ;# Idle threads die at this rate
ns_param globalstats false ;# Enable built-in statistics
ns_param urlstats false ;# Enable URL statistics
ns_param maxurlstats 1000 ;# Max number of URL's to do stats on
# ns_param directoryadp $pageroot/dirlist.adp ;# Choose one or the other
# ns_param directoryproc _ns_dirlist ;# ...but not both!
# ns_param directorylisting fancy ;# Can be simple or fancy

#
# Special HTTP pages
#
ns_param NotFoundResponse "/global/file-not-found.html"
ns_param ServerBusyResponse "/global/busy.html"
ns_param ServerInternalErrorResponse "/global/error.html"

#---------------------------------------------------------------------
#
# ADP (AOLserver Dynamic Page) configuration
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/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 $debug ;# Allow Tclpro debugging with "?debug"
ns_param defaultparser fancy

ns_section ns/server/${server}/adp/parsers
ns_param fancy ".adp"

ns_section ns/server/${server}/redirects
ns_param 404 "global/file-not-found.html"
ns_param 403 "global/forbidden.html"

#
# Tcl Configuration
#
ns_section ns/server/${server}/tcl
ns_param library ${serverroot}/tcl
ns_param autoclose on
ns_param debug $debug

#---------------------------------------------------------------------
#
# Rollout email support
#
# These procs help manage differing email behavior on
# dev/staging/production.
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/acs/acs-rollout-support

# EmailDeliveryMode can be:
# default: Email messages are sent in the usual manner.
# log: Email messages are written to the server's error log.
# redirect: Email messages are redirected to the addresses specified
# by the EmailRedirectTo parameter. If this list is absent
# or empty, email messages are written to the server's error log.
# filter: Email messages are sent to in the usual manner if the
# recipient appears in the EmailAllow parameter, otherwise they
# are logged.

# ns_param EmailDeliveryMode redirect
# ns_param EmailRedirectTo somenerd@yourdomain.test, othernerd@yourdomain.test
# ns_param EmailAllow somenerd@yourdomain.test,othernerd@yourdomain.test

#---------------------------------------------------------------------
#
# WebDAV Support (optional, requires oacs-dav package to be installed
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/tdav
ns_param propdir ${serverroot}/data/dav/properties
ns_param lockdir ${serverroot}/data/dav/locks
ns_param defaultlocktimeout "300"

ns_section ns/server/${server}/tdav/shares
ns_param share1 "OpenACS"
# ns_param share2 "Share 2 description"

ns_section ns/server/${server}/tdav/share/share1
ns_param uri "/dav/*"
# all WebDAV options
ns_param options "OPTIONS COPY GET PUT MOVE DELETE HEAD MKCOL POST PROPFIND PROPPATCH LOCK UNLOCK"

#ns_section ns/server/${server}/tdav/share/share2
# ns_param uri "/share2/path/*"
# read-only WebDAV options
# ns_param options "OPTIONS COPY GET HEAD MKCOL POST PROPFIND PROPPATCH"

#---------------------------------------------------------------------
#
# Socket driver module (HTTP) -- nssock
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/module/nssock
ns_param timeout 120
ns_param address $address
ns_param hostname $hostname
ns_param port $httpport
# setting maxinput higher than practical may leave the server vulnerable to resource DoS attacks
# see http://www.panoptic.com/wiki/aolserver/166
ns_param maxinput [expr {$max_file_upload_mb * 1024 * 1024}] ;# Maximum File Size for uploads in bytes
ns_param maxpost [expr {$max_file_upload_mb * 1024 * 1024}] ;# Maximum File Size for uploads in bytes
ns_param recvwait [expr {$max_file_upload_min * 60}] ;# Maximum request time in minutes

# maxsock will limit the number of simultanously returned pages,
# regardless of what maxthreads is saying
ns_param maxsock 100 ;# 100 = default

# On Windows you need to set this parameter to define the number of
# connections as well (it seems).
ns_param backlog 5 ;# if < 1 == 5

# Optional params with defaults:
ns_param bufsize 16000
ns_param rcvbuf 0
ns_param sndbuf 0
ns_param socktimeout 30 ;# if < 1 == 30
ns_param sendwait 30 ;# if < 1 == socktimeout
ns_param recvwait 30 ;# if < 1 == socktimeout
ns_param closewait 2 ;# if < 0 == 2
ns_param keepwait 30 ;# if < 0 == 30
ns_param readtimeoutlogging false
ns_param serverrejectlogging false
ns_param sockerrorlogging false
ns_param sockshuterrorlogging false

#---------------------------------------------------------------------
#
# Access log -- nslog
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/module/nslog
ns_param debug false
ns_param dev false
ns_param enablehostnamelookup false
ns_param file ${serverroot}/log/${server}.log
ns_param logcombined true
ns_param extendedheaders COOKIE
# ns_param logrefer false
# ns_param loguseragent false
ns_param logreqtime true
ns_param maxbackup 1000
ns_param rollday *
ns_param rollfmt %Y-%m-%d-%H:%M
ns_param rollhour 0
ns_param rollonsignal true
ns_param rolllog true

#---------------------------------------------------------------------
#
# nsjava - aolserver module that embeds a java virtual machine. Needed to
# support webmail. See http://nsjava.sourceforge.net for further
# details. This may need to be updated for OpenACS4 webmail
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/module/nsjava
ns_param enablejava off ;# Set to on to enable nsjava.
ns_param verbosejvm off ;# Same as command line -debug.
ns_param loglevel Notice
ns_param destroyjvm off ;# Destroy jvm on shutdown.
ns_param disablejitcompiler off
ns_param classpath /usr/local/jdk/jdk118_v1/lib/classes.zip:${bindir}/nsjava.jar:${pageroot}/webmail/java/activation.jar:${pageroot}/webmail/java/mail.jar:${pageroot}/webmail/java

#---------------------------------------------------------------------
#
# CGI interface -- nscgi, if you have legacy stuff. Tcl or ADP files inside
# AOLserver are vastly superior to CGIs. I haven't tested these params but they
# should be right.
#
#---------------------------------------------------------------------
#ns_section "ns/server/${server}/module/nscgi"
# ns_param map "GET /cgi-bin ${serverroot}/cgi-bin"
# ns_param map "POST /cgi-bin ${serverroot}/cgi-bin"
# ns_param Interps CGIinterps

#ns_section "ns/interps/CGIinterps"
# ns_param .pl "/usr/bin/perl"

#---------------------------------------------------------------------
#
# PAM authentication
#
#---------------------------------------------------------------------
ns_section ns/server/${server}/module/nspam
ns_param PamDomain "pam_domain"

#---------------------------------------------------------------------
#
# OpenSSL for Aolserver 3.3 and 4
#
#---------------------------------------------------------------------
if { [ns_info version] < 4} {

#---------------------------------------------------------------------
# OpenSSL for Aolserver 3.3
#---------------------------------------------------------------------

ns_section "ns/server/${server}/module/nsopenssl"

ns_param ModuleDir ${serverroot}/etc/certs

# NSD-driven connections:
ns_param ServerPort $httpsport
ns_param ServerHostname $hostname
ns_param ServerAddress $address
ns_param ServerCertFile certfile.pem
ns_param ServerKeyFile keyfile.pem
ns_param ServerProtocols "SSLv2, SSLv3, TLSv1"
ns_param ServerCipherSuite "ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP"
ns_param ServerSessionCache true
ns_param ServerSessionCacheID 1
ns_param ServerSessionCacheSize 512
ns_param ServerSessionCacheTimeout 300
ns_param ServerPeerVerify false
ns_param ServerPeerVerifyDepth 3
ns_param ServerCADir ca
ns_param ServerCAFile ca.pem
ns_param ServerTrace false

# For listening and accepting SSL connections via Tcl/C API:
ns_param SockServerCertFile certfile.pem
ns_param SockServerKeyFile keyfile.pem
ns_param SockServerProtocols "SSLv2, SSLv3, TLSv1"
ns_param SockServerCipherSuite "ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP"
ns_param SockServerSessionCache true
ns_param SockServerSessionCacheID 2
ns_param SockServerSessionCacheSize 512
ns_param SockServerSessionCacheTimeout 300
ns_param SockServerPeerVerify false
ns_param SockServerPeerVerifyDepth 3
ns_param SockServerCADir internal_ca
ns_param SockServerCAFile internal_ca.pem
ns_param SockServerTrace false

# Outgoing SSL connections
ns_param SockClientCertFile certfile.pem
ns_param SockClientKeyFile keyfile.pem
ns_param SockClientProtocols "SSLv2, SSLv3, TLSv1"
ns_param SockClientCipherSuite "ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP"
ns_param SockClientSessionCache false
ns_param SockClientSessionCacheID 3
ns_param SockClientSessionCacheSize 512
ns_param SockClientSessionCacheTimeout 300
ns_param SockClientPeerVerify false
ns_param SockServerPeerVerifyDepth 3
ns_param SockClientCADir ca
ns_param SockClientCAFile ca.pem
ns_param SockClientTrace false

# OpenSSL library support:
# ns_param RandomFile /some/file
ns_param SeedBytes 1024

} else {

#---------------------------------------------------------------------
# OpenSSL for Aolserver 4
#---------------------------------------------------------------------
ns_section "ns/server/${server}/module/nsopenssl"

# Note this portion of the configuration is not perfect, and you
# will get errors in the your error.log. However, it does
# work. Fixes welcome.

# this is used by acs-tcl/tcl/security-procs.tcl to get the
# https port.
ns_param ServerPort $httpsport
# setting maxinput higher than practical may leave the server vulnerable to resource DoS attacks
# see http://www.panoptic.com/wiki/aolserver/166
# must set maxinput for nsopenssl as well as nssock
ns_param maxinput [expr {$max_file_upload_mb * 1024 * 1024}] ;# Maximum File Size for uploads in bytes

# We explicitly tell the server which SSL contexts to use as defaults when an
# SSL context is not specified for a particular client or server SSL
# connection. Driver connections do not use defaults; they must be explicitly
# specificied in the driver section. The Tcl API will use the defaults as there
# is currently no provision to specify which SSL context to use for a
# particular connection via an ns_openssl Tcl command.
ns_section "ns/server/${server}/module/nsopenssl/sslcontexts"
ns_param users "SSL context used for regular user access"
# ns_param admins "SSL context used for administrator access"
ns_param client "SSL context used for outgoing script socket connections"

ns_section "ns/server/${server}/module/nsopenssl/defaults"
ns_param server users
ns_param client client

ns_section "ns/server/${server}/module/nsopenssl/sslcontext/users"
ns_param Role server
ns_param ModuleDir ${serverroot}/etc/certs
ns_param CertFile certfile.pem
ns_param KeyFile keyfile.pem
# ns_param CADir ca-client/dir
# ns_param CAFile ca-client/ca-client.crt
# for Protocols "ALL" = "SSLv2, SSLv3, TLSv1"
ns_param Protocols "SSLv3, TLSv1"
ns_param CipherSuite "ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP"
ns_param PeerVerify false
ns_param PeerVerifyDepth 3
ns_param Trace false

# following from bartt's nsd4.tcl, might help stablize openssl connections?
# http://www.mail-archive.com/aolserver@listserv.aol.com/msg07092.html
ns_param SessionCache true
ns_param SessionCacheID 1
ns_param SessionCacheSize 512
ns_param SessionCacheTimeout 300

# ns_section "ns/server/${server}/module/nsopenssl/sslcontext/admins"
# ns_param Role server
# ns_param ModuleDir /path/to/dir
# ns_param CertFile server/server.crt
# ns_param KeyFile server/server.key
# ns_param CADir ca-client/dir
# ns_param CAFile ca-client/ca-client.crt
# for Protocols "ALL" = "SSLv2, SSLv3, TLSv1"
# ns_param Protocols "All"
# ns_param CipherSuite "ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP"
# ns_param PeerVerify false
# ns_param PeerVerifyDepth 3
# ns_param Trace false

ns_section "ns/server/${server}/module/nsopenssl/sslcontext/client"
ns_param Role client
ns_param ModuleDir ${serverroot}/etc/certs
ns_param CertFile certfile.pem
ns_param KeyFile keyfile.pem
# ns_param CADir ${serverroot}/etc/certs
# ns_param CAFile certfile.pem
# for Protocols "ALL" = "SSLv2, SSLv3, TLSv1"
ns_param Protocols "SSLv2, SSLv3, TLSv1"
ns_param CipherSuite "ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP"
ns_param PeerVerify false
ns_param PeerVerifyDepth 3
ns_param Trace false

# following from bartt's nsd4.tcl, might help stablize openssl connections?
# http://www.mail-archive.com/aolserver@listserv.aol.com/msg07092.html
ns_param SessionCache true
ns_param SessionCacheID 1
ns_param SessionCacheSize 512
ns_param SessionCacheTimeout 300

# SSL drivers. Each driver defines a port to listen on and an explitictly named
# SSL context to associate with it. Note that you can now have multiple driver
# connections within a single virtual server, which can be tied to different
# SSL contexts.
ns_section "ns/server/${server}/module/nsopenssl/ssldrivers"
ns_param users "Driver for regular user access"
# ns_param admins "Driver for administrator access"

ns_section "ns/server/${server}/module/nsopenssl/ssldriver/users"
ns_param sslcontext users
# ns_param port $httpsport_users
ns_param port $httpsport
ns_param hostname $hostname
ns_param address $address
# following added per
# http://www.mail-archive.com/aolserver@listserv.aol.com/msg07365.html
# Maximum File Size for uploads:
ns_param maxinput [expr {$max_file_upload_mb * 1024 * 1024}] ;# in bytes
# Maximum request time
ns_param recvwait [expr {$max_file_upload_min * 60}] ;# in minutes

# ns_section "ns/server/${server}/module/nsopenssl/ssldriver/admins"
# ns_param sslcontext admins
# ns_param port $httpsport_admins
# ns_param port $httpsport
# ns_param hostname $hostname
# ns_param address $address
}

#---------------------------------------------------------------------
#
# Database drivers
# The database driver is specified here.
# Make sure you have the driver compiled and put it in {aolserverdir}/bin
#
#---------------------------------------------------------------------
ns_section "ns/db/drivers"
if { $database eq "oracle" } {
ns_param ora8 ${bindir}/ora8.so
} else {
ns_param postgres ${bindir}/nspostgres.so ;# Load PostgreSQL driver
}

if { $database eq "oracle" } {
ns_section "ns/db/driver/ora8"
ns_param maxStringLogLength -1
ns_param LobBufferSize 32768
}

# Database Pools: This is how AOLserver ``talks'' to the RDBMS. You need
# three for OpenACS: main, log, subquery. Make sure to replace ``yourdb''
# and ``yourpassword'' with the actual values for your db name and the
# password for it, if needed.
#
# AOLserver can have different pools connecting to different databases
# and even different different database servers. See
# http://openacs.org/doc/openacs-5-1/tutorial-second-database.html

ns_section ns/db/pools
ns_param pool1 "Pool 1"
ns_param pool2 "Pool 2"
ns_param pool3 "Pool 3"

ns_section ns/db/pool/pool1
ns_param maxidle 0
ns_param maxopen 0
ns_param connections 15
ns_param verbose $debug
ns_param extendedtableinfo true
ns_param logsqlerrors $debug
if { $database eq "oracle" } {
ns_param driver ora8
ns_param datasource {}
ns_param user $db_name
ns_param password $db_password
} else {
ns_param driver postgres
ns_param datasource ${db_host}:${db_port}:${db_name}
ns_param user $db_user
ns_param password $db_password
}

ns_section ns/db/pool/pool2
ns_param maxidle 0
ns_param maxopen 0
ns_param connections 5
ns_param verbose $debug
ns_param extendedtableinfo true
ns_param logsqlerrors $debug
if { $database eq "oracle" } {
ns_param driver ora8
ns_param datasource {}
ns_param user $db_name
ns_param password $db_password
} else {
ns_param driver postgres
ns_param datasource ${db_host}:${db_port}:${db_name}
ns_param user $db_user
ns_param password $db_password
}

ns_section ns/db/pool/pool3
ns_param maxidle 0
ns_param maxopen 0
ns_param connections 5
ns_param verbose $debug
ns_param extendedtableinfo true
ns_param logsqlerrors $debug
if { $database eq "oracle" } {
ns_param driver ora8
ns_param datasource {}
ns_param user $db_name
ns_param password $db_password
} else {
ns_param driver postgres
ns_param datasource ${db_host}:${db_port}:${db_name}
ns_param user $db_user
ns_param password $db_password
}

ns_section ns/server/${server}/db
ns_param pools pool1,pool2,pool3
ns_param defaultpool pool1

#---------------------------------------------------------------------
# which modules should be loaded? Missing modules break the server, so
# don't uncomment modules unless they have been installed.
ns_section ns/server/${server}/modules
ns_param nssock ${bindir}/nssock.so
ns_param nslog ${bindir}/nslog.so
ns_param nssha1 ${bindir}/nssha1.so
# since aolserver version 4.5.1 built-in ns_cache, so we dont
# need to load the nscache module.
if {[ns_info version] < 4.5 || [ns_info patchlevel] eq "4.5.0"} {
ns_param nscache ${bindir}/nscache.so
}
# openacs versions earlier than 5.x requires nsxml
# ns_param nsxml ${bindir}/nsxml.so

#---------------------------------------------------------------------
# nsopenssl will fail unless the cert files are present as specified
# later in this file, so it's disabled by default
# ns_param nsopenssl ${bindir}/nsopenssl.so

# authorize-gateway package requires dqd_utils
# ns_param dqd_utils dqd_utils[expr {int($tcl_version)}].so

# Full Text Search
# ns_param nsfts ${bindir}/nsfts.so

# PAM authentication
# ns_param nspam ${bindir}/nspam.so

# LDAP authentication
# ns_param nsldap ${bindir}/nsldap.so

# These modules aren't used in standard OpenACS installs
# ns_param nsperm ${bindir}/nsperm.so
# ns_param nscgi ${bindir}/nscgi.so
# ns_param nsjava ${bindir}/libnsjava.so
# ns_param nsrewrite ${bindir}/nsrewrite.so

if { [ns_info version] >= 4 } {
# Required for AOLserver 4.x
ns_param nsdb ${bindir}/nsdb.so
} else {
# Required for AOLserver 3.x
ns_param libtdom ${bindir}/libtdom.so
}

# nsthread library which should become standard in 5.3
ns_param libthread [lindex [glob /usr/lib/tcltk/thread*/libthread*-aolserver[info sharedlibextension]] 0]

if {[ns_info version] >= 4.5} {
ns_limits set default -maxupload [ns_config ns/server/${server}/module/nssock maxinput]
}

ns_log notice "nsd.tcl: using threadsafe tcl: [info exists tcl_platform(threaded)]"
ns_log notice "nsd.tcl: finished reading config file."
if {[ns_info version] >= 4.5} {
ns_limits set default -maxupload [ns_config ns/server/${server}/module/nssock maxinput]
}
------------------------------------------

Thanks

11: Re: DB Connection Error (response to 1)

Posted by Jim Lynch on 09/18/11 11:05 PM

Hi, just checking in...

It looks to me as though the db is either not running or not listening on the port. Is this a new install of openacs?

Gustaf, do you concur with this? (as opposed to the pg driver not working)

-Jim

13: Re: DB Connection Error (response to 1)

Posted by danny kim on 09/19/11 06:53 AM

1. "psql -p 5432 -U www-data openacs" is working.

"openacs -> " logined as openacs DB and prompted.

2. I got sokect(/var/run/postgresql/.s.PGSQL.5432) connection problem. so, I changed port 80 to 8000 for testing.
but, That does not matter with this.

my problem iss as followings.

----------------------------------------------------
Notice: dbdrv: opening database 'postgres:localhost:5432:openacs'
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Notice: Opening openacs on localhost
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Error: Ns_PgOpenDb(postgres): Could not connect to localhost:5432:openacs: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

[15/Sep/2011:16:55:05][1188.3075462848][-main-] Error: dbdrv: failed to open database 'postgres:localhost:5432:openacs'
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Warning: Database API: couldn't allocate a handle from database pool "pool1".
[15/Sep/2011:16:55:05][1188.3075462848][-main-] Error: Database API: RDBMS type could not be determined for any pool.
----------------------------------------------------

Thanks

15: Re: DB Connection Error (response to 14)

Posted by danny kim on 09/19/11 02:32 PM

It's the first time to install openACS.

1. /etc/init.d/aolserver4
#!/bin/sh
#
# Start the AOLServer HTTP server.
#
# Copyright (C) 2003-2009 Francesco P. Lovergine <frankie@debian.org>
#

### BEGIN INIT INFO
# Provides: aolserver4
# Required-Start: $local_fs $remote_fs $network $syslog
# Required-Stop: $local_fs $remote_fs $network $syslog
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Should-Start: $postgresql
# Should-Stop: $postgresql
# Short-Description: Starts AOLserver web daemon
# Description: It starts up the AOLserver http multi-threaded
# server
### END INIT INFO

NAME=aolserver4
USER=www-data
GROUP=www-data
ADDRESS=127.0.0.1
HTTP_PORT=80
DAEMON=/usr/sbin/aolserver4-nsd
PIDFILE=/var/run/aolserver4/$NAME.pid
CONF=/etc/aolserver4/aolserver4.tcl
RUN_DAEMON=yes

trap "" 1

[ -x $DAEMON ] || exit 0

. /lib/lsb/init-functions

if [ -x /etc/default/aolserver4 ]; then
. /etc/default/aolserver4
fi

# /var/run could be on a tmpfs

[ ! -d $RUNDIR ] && mkdir -p -m 755 $RUNDIR

start()
{
    if [ "$RUN_DAEMON" = "yes" ]; then
    log_daemon_msg "Starting web server" "$NAME"
        start-stop-daemon --start --quiet --exec $DAEMON --pidfile $PIDFILE --oknodo -- \
            -u $USER -g $GROUP -b $ADDRESS:$HTTP_PORT -s main -t $CONF >/dev/null
        if [ $? != 0 ]; then
            log_end_msg 1
        exit 1
        else
            log_end_msg 0
        fi
    fi

    for name in /etc/aolserver4/conf.d/*.sh; do
        base=$(basename $name .sh)
        if [ -e /etc/aolserver4/conf.d/$base.tcl ]; then
            AOL_PIDFILE=/var/run/aolserver4/$base.pid
            AOL_ADDRESS=$ADDRESS
            AOL_PORT=$(expr $HTTP_PORT + 1)
            AOL_USER=$USER
            AOL_GROUP=$GROUP
            RUN_DAEMON=yes
            . $name
            if [ "$RUN_DAEMON" = "yes" ]; then
                log_daemon_msg "Starting AOL instance" "$base"
                start-stop-daemon --start --quiet --exec $DAEMON --pidfile $AOL_PIDFILE --oknodo -- \
                    -u $AOL_USER -g $AOL_GROUP -b $AOL_ADDRESS:$AOL_PORT -s $base -t /etc/aolserver4/conf.d/$base.tcl >/dev/null
                if [ $? != 0 ]; then
                    log_end_msg 1
                exit 1
                else
                    log_end_msg 0
                fi
            fi
        fi
    done
}

stop()
{
    for name in /var/run/aolserver4/*.pid; do
        if [ -f $name ]; then
            base=$(basename $name .pid)
            log_daemon_msg "Stopping web server" "$base"
            start-stop-daemon --stop --quiet --pidfile $name --oknodo >/dev/null
            if [ $? != 0 ]; then
                log_end_msg 1
            exit 2
            else
                log_end_msg 0
            fi
        fi
    done
}

case "$1" in
start)
start
;;

stop)
stop
;;

reload|force-reload|restart)
stop
sleep 2
start
;;

*)
echo "Usage: /etc/init.d/$NAME {start|stop|restart|reload|force-reload}"
exit 1
;;
esac

exit 0

2. openacs.sh

#!/bin/sh
# These variables can be customized to change OpenACS AOLserver settings.
# More changes can be done by modifying the /etc/openacs/config.tcl Tcl script.
#
AOL_USER=www-data
AOL_GROUP=www-data
AOL_ADDRESS=127.0.0.1
AOL_PORT=8000
RUN_DAEMON=yes

3. openacs
#!/bin/sh -e
#
# Start the AOLServer HTTP server.
#

NAME="OpenACS on service1"
SERVICEPATH=/var/lib/aolserver/service1
PATH=$PATH:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/pgsql/bin
#trap "" 1

. /lib/lsb/init-functions

start () {
혻혻 echo -n "Starting web server: $NAME"
혻혻 echo -e -n "\r"

혻혻 #we need to export the library stuff first
혻혻 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/pgsql/lib
혻혻 export PATH=$PATH:/usr/local/pgsql/bin

혻혻혻 # give time for Postgres to come up
혻혻혻 sleep 1
혻혻혻 exec /usr/sbin/aolserver4-nsd -it $SERVICEPATH/etc/config.tcl -u service1 -g web &

혻혻혻 # For AOLserver 4 using privileged ports (usually < 1024), add the flag
혻혻 # -b youraddress:yourport
혻혻혻 echo ""
}

stop () {
혻혻혻 echo -n "Stopping web server: $NAME"
혻혻혻 killall aolserver4-nsd
혻혻혻 echo ""
}

case "$1" in
start)
start
    ;;
stop)
    ;;
restart)
stop
sleep 2
start
    ;;
*)
    echo "Usage: /etc/init.d/$NAME {start|stop|restart}"
    exit 1
    ;;
esac

#echo -n -e "\c\r\n"
exit 0
# End of script

Thanks

17: Re: DB Connection Error (response to 16)

Posted by Jim Lynch on 09/19/11 05:59 PM

Hector, we already know by his log that it's trying to start on port 80; further, it's either not finding nspostgres or its lib.