Forum OpenACS Q&A: OpenACS 5.0 tarball

Collapse
Posted by Chris Davies on
not having any luck getting OpenACS 5 to work from CVS, I decided to try the tarball which looks like it was recently put online.

After about 3 hours of mucking with it, I still hit a problem which I don't understand.  I have taken the config file that I used for OpenACS 4.6.3, and receive the same error upon bootstrapping OpenACS 5.0.

/etc/aolserver4/nsd.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
#
######################################################################

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

if {$database == "oracle"} {
    set db_password        "mysitepassword"
}

# change to 80 and 443 for production use
# Bind; 192.168.24.68:81
set httpport              81
set httpsport            443

# The hostname and address should be set to actual values.
#set hostname              [ns_info hostname]
set hostname              mcdlp.pbi.daviesinc.com
set address                192.168.24.68

set server              "daviesinc.com"
set db_name            $server
set servername          "New OpenACS Installation - Development"

set serverroot          "/var/www/aolserver4/${server}"

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

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

# 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
ns_param  nsrewrite      ${bindir}/nsrewrite.so
#ns_param  libtdom        ${bindir}/libtdom.so
ns_param  libtdom        /usr/lib/tdom0.7.8/libtdom0.7.8.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

# 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

######################################################################
#
# 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
ns_param  maxkeepalive      0
ns_param  logroll            on
ns_param  maxbackup          5
ns_param  debug              $debug

#
# Thread library (nsthread) parameters
#
ns_section ns/threads
ns_param  mutexmeter        true      ;# measure lock contention
ns_param  stacksize          500000

#
# MIME types.
#
#  Note: AOLserver already has an exhaustive list of MIME types, but in
#  case something is missing you can add it here.
#

ns_section ns/mimetypes
ns_param  Default            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

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

######################################################################
#
# 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    5
ns_param  maxdropped        0
ns_param  maxthreads        5
ns_param  minthreads        5
ns_param  threadtimeout      120
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"

######################################################################
#
# 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

######################################################################
#
# OpenSSL
#
######################################################################

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              false
ns_param ServerSessionCacheID            1
ns_param ServerSessionCacheSize          512
ns_param ServerSessionCacheTimeout      300
ns_param ServerPeerVerify                true
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          false
ns_param SockServerSessionCacheID        2
ns_param SockServerSessionCacheSize      512
ns_param SockServerSessionCacheTimeout  300
ns_param SockServerPeerVerify            true
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            true
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

######################################################################
#
# 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
}

#
# 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.
#
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        localhost::${db_name}
    ns_param  user              $server
    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        localhost::${db_name}
    ns_param  user              $server
    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        localhost::${db_name}
    ns_param  user              $server
    ns_param  password          ""
}

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

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

######################################################################
#
# Access log -- nslog
#
######################################################################

ns_section ns/server/${server}/module/nslog
ns_param  file                ${serverroot}/log/${server}.log
ns_param  enablehostnamelookup false
ns_param  logcombined          true
#ns_param  logrefer            false
#ns_param  loguseragent        false
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/ /web/$server/cgi-bin"
#      ns_param  map "POST /cgi-bin/ /web/$server/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"

ns_log notice "nsd.tcl: finished reading config file."

Starting AOLServer (it does work if I don't bootstrap openacs as I had it serving test content)

root@mcdlp:/var/www/aolserver4/daviesinc.com/log# /etc/init.d/aolserver4 start
+ echo -n 'Starting AOL WebServer v4: ( '
Starting AOL WebServer v4: ( + shift
+ '[' -n '' ']'
++ echo nsd:server1
++ tr : ' '
+ start_server nsd server1
+ local srvname=server1
+ local srvname=daviesinc.com
+ local config=nsd
+ local 'params=-u www-data -g www-data'
+ local ipports=
+ local tmpfile=
+ '[' -z nsd -o '!' -f /etc/aolserver4/nsd.tcl ']'
+ params=-u www-data -g www-data -t /etc/aolserver4/nsd.tcl
+ '[' -n daviesinc.com ']'
+ params=-u www-data -g www-data -t /etc/aolserver4/nsd.tcl -s daviesinc.com
+ echo -n 'nsd '
nsd ++ mktemp /tmp/nsd.ip.XXXXXX
+ tmpfile=/tmp/nsd.ip.iYHDsn
+ config=/etc/aolserver4/nsd.tcl
+ egrep '# Bind; ' /etc/aolserver4/nsd.tcl
+ tr -d ' '
+ cut -d ';' -f 2
+ tr , ' '
+ /usr/sbin/nsd -u www-data -g www-data -t /etc/aolserver4/nsd.tcl -s daviesinc.com -B /tmp/nsd.ip.iYHDsn
[27/Oct/2003:01:00:28][20801.16384][-main-] Notice: prebind: bound: 192.168.24.68:81

+ echo ') aolserver4.'
) aolserver4.
+ exit 0
root@mcdlp:/var/www/aolserver4/daviesinc.com/log# [27/Oct/2003:01:00:28][20802.16384][-main-] Notice: nsd.tcl: starting to read config file...
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: nsd.tcl: finished reading config file.

error.log

[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: nsmain: AOLserver/4.0 starting
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: adp[daviesinc.com]: mapped /*.adp
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssock.so'
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nslog.so'
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: nslog: opened '/var/www/aolserver4/daviesinc.com/log/daviesinc.com.log'
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssha1.so'
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nscache.so'
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: nscache module version @VER@ server: daviesinc.com
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsrewrite.so'
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: modload: loading '/usr/lib/tdom0.7.8/libtdom0.7.8.so'
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: libtdom module
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: conf: [ns/server/daviesinc.com]enabletclpages = 0
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: Loading OpenACS, rooted at /var/www/aolserver4/daviesinc.com
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: Sourcing /var/www/aolserver4/daviesinc.com/packages/acs-bootstrap-installer/bootstrap.tcl
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: Bootstrap: sourcing /var/www/aolserver4/daviesinc.com/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: Bootstrap: sourcing /var/www/aolserver4/daviesinc.com/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: Bootstrap: sourcing /var/www/aolserver4/daviesinc.com/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: Bootstrap: sourcing /var/www/aolserver4/daviesinc.com/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: Bootstrap: sourcing /var/www/aolserver4/daviesinc.com/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[27/Oct/2003:01:00:28][20802.16384][-main-] Error: Bootstrap: Server startup failed: Error during bootstrapping
invalid command name "ns_db"
    while executing
"ns_db pools"
    (procedure "db_bootstrap_set_db_type" line 61)
    invoked from within
"db_bootstrap_set_db_type database_problem"
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: Sourcing files for postload...
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: Done.
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: Executing initialization code blocks...
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: nsmain: AOLserver/4.0 running
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[27/Oct/2003:01:00:28][20802.32771][-sched-] Notice: sched: starting
[27/Oct/2003:01:00:28][20802.16384][-main-] Notice: nssock: listening on 192.168.24.68:81
[27/Oct/2003:01:00:28][20802.131081][-driver-] Notice: starting
[27/Oct/2003:01:00:28][20802.131081][-driver-] Notice: driver: accepting connections

the nsd.tcl file is almost identical to the one supplied in the tarball with only minor localization changes.

I see this problem occurs quite frequently based on searches of the forum, but didn't see any solutions.

I know it is probably something simple I am missing and would appreciate any pointers in the right direction.

Debian 3.0/Sid
AOLServer 4.0.0-cvs-3
tdom 0.7.8-1  (verified that it does work when openacs isn't bootstrapped)
OpenACS 5.0.0.a1 tarball

Collapse
2: Re: OpenACS 5.0 tarball (response to 1)
Posted by bill kellerman on
aolserver 4 has broken the database stuff into an external module.

add to your nsd.tcl file:

ns_param  nsdb      ${bindir}/nsdb.so

Collapse
3: Re: OpenACS 5.0 tarball (response to 2)
Posted by Joel Aufrecht on
should that be added to the default config file (commented out, since we still recommened AOLserver 3)?
Collapse
4: Re: OpenACS 5.0 tarball (response to 3)
Posted by bill kellerman on
that would be good -- this question gets asked a lot.
Collapse
5: Re: OpenACS 5.0 tarball (response to 1)
Posted by Chris Davies on
Well, it was suggested that I use AOLServer4 as it worked better with OpenACS 5.0 after spending days trying to get AOLServer 3 & OpenACS 5.0/CVS to run.

If someone will give me a magic combination that will work that won't take me 16 hours of mucking with to get an operational system running 5.0, it would be appreciated.

anyhow, now the error has moved -- it gets much further.  Even hardcoding the pool definitions to remove the check for the database type didn't seem to make a difference.

[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: nsmain: AOLserver/4.0 starting
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: adp[daviesinc.com]: mapped /*.adp
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssock.so'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nslog.so'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: nslog: opened '/var/www/aolserver4/daviesinc.com/log/daviesinc.com.log'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nssha1.so'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nscache.so'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: nscache module version @VER@ server: daviesinc.com
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsrewrite.so'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: modload: loading '/usr/lib/tdom0.7.8/libtdom0.7.8.so'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsdb.so'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nspostgres.so'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: PostgreSQL loaded.
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: libtdom module
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: conf: [ns/server/daviesinc.com]enabletclpages = 0
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading OpenACS, rooted at /var/www/aolserver4/daviesinc.com
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Sourcing /var/www/aolserver4/daviesinc.com/packages/acs-bootstrap-installer/bootstrap.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Bootstrap: sourcing /var/www/aolserver4/daviesinc.com/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Bootstrap: sourcing /var/www/aolserver4/daviesinc.com/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Bootstrap: sourcing /var/www/aolserver4/daviesinc.com/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Bootstrap: sourcing /var/www/aolserver4/daviesinc.com/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Bootstrap: sourcing /var/www/aolserver4/daviesinc.com/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Database API: Default database (dbn) is: 'default'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Database API: The following pools are available for OpenACS: pool2 pool3 pool1
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: dbdrv: opening database 'postgres:localhost::daviesinc.com'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Opening daviesinc.com on localhost
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Ns_PgOpenDb(postgres):  Openned connection to localhost::daviesinc.com.
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Couldn't determine RDBMS type of database pool "pool2".
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: dbdrv: opening database 'postgres:localhost::daviesinc.com'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Opening daviesinc.com on localhost
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Ns_PgOpenDb(postgres):  Openned connection to localhost::daviesinc.com.
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Couldn't determine RDBMS type of database pool "pool3".
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: dbdrv: opening database 'postgres:localhost::daviesinc.com'
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Opening daviesinc.com on localhost
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Ns_PgOpenDb(postgres):  Openned connection to localhost::daviesinc.com.
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Couldn't determine RDBMS type of database pool "pool1".
[27/Oct/2003:19:32:13][1393.16384][-main-] Error: RDBMS type could not be determined for any pool.
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Bootstrap: Loading acs-tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/00-database-procs-postgresql.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/base64-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[27/Oct/2003:19:32:13][1393.16384][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/md5-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/mime-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[27/Oct/2003:19:32:14][1393.16384][-main-] Error: Bootstrap: <p>The following database pools generated errors:
    <ul><li>OpenACS could not determine the RDBMS type associated with
    pool "pool2".
<li>OpenACS could not determine the RDBMS type associated with
    pool "pool3".
<li>OpenACS could not determine the RDBMS type associated with
    pool "pool1".</ul><p>
Possible causes might include:<p>
    <ul>
    <li>The database is not running.
    <li>The database driver has not been correctly installed.
    <li>The datasource or database user/password are incorrect.
    <li>You didn't define any database pools.
    </ul><p>
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Bootstrap: database problem found; Sourcing the installer.
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Sourcing files for postload...
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Done.
[27/Oct/2003:19:32:14][1393.16384][-main-] Notice: Executing initialization code blocks...
[27/Oct/2003:19:32:15][1393.16384][-main-] Notice: nsmain: AOLserver/4.0 running[27/Oct/2003:19:32:15][1393.16384][-main-] Notice: nsmain: security info: uid=33, euid=33, gid=33, egid=33
[27/Oct/2003:19:32:15][1393.32771][-sched-] Notice: sched: starting
[27/Oct/2003:19:32:15][1393.16384][-main-] Notice: nssock: listening on 192.168.24.68:81
[27/Oct/2003:19:32:15][1393.131081][-driver-] Notice: starting
[27/Oct/2003:19:32:15][1393.131081][-driver-] Notice: driver: accepting connections

Collapse
6: Re: OpenACS 5.0 tarball (response to 5)
Posted by bill kellerman on
just to make sure -- your nsd.tcl specifies "daviesinc.com" as the name of your server, the name of your database, and the name of the user accessing your database.

is this correct?

Collapse
7: Re: OpenACS 5.0 tarball (response to 1)
Posted by Chris Davies on
actually no, I changed that

set user_account        www-data

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        localhost::${db_name}
    ns_param  user              $user_account
    ns_param  password          ""
#}

pool2 and 3 are similarly adjusted

Collapse
8: Re: OpenACS 5.0 tarball (response to 7)
Posted by bill kellerman on
hmm...  i don't think the error you are getting has anything to do with oacs (i could be wrong).  are you sure you compiled the postgres driver correctly?

if you haven't already, you might try downloading and compiling the nspostgres4.0beta1 driver on aolserver.com.  it's the only one i've ever used.  make sure to add the ACS=1 option to your configure statement.

Collapse
9: Re: OpenACS 5.0 tarball (response to 1)
Posted by Chris Davies on
the ACS=1 was there -- however, the new driver makes it work.

Finally.

Thank you very much for the help.  Now to dig into categories which started the whole 5.0 upgrade requirement.