Forum OpenACS Q&A: Request Error: Server startup failed

Request Error
Server startup failed: Error during bootstrapping

command "ns_db" is not enabled
    while executing
"ns_db pools"
    (procedure "db_bootstrap_set_db_type" line 72)
    invoked from within
"db_bootstrap_set_db_type database_problem"

Here is the first warning from freegeek-error.log.

Warning: modload: failed to load '/usr/local/aolserver/bin/nspostgres.so': 'libpq.so.2: cannot open shared object file: No such file or directory'
[01/Jul/2003:04:00:57][792.1024][-main-] Error: dbdrv: failed to load driver 'postgres'
[01/Jul/2003:04:00:57][792.1024][-main-] Error: dbinit: no such default pool 'pool1'

/usr/local/aolserver/bin/nspostgres.so does exist. The owner is nsadmin.nsadmin, permissions 755.

/usr/local/pgsql/lib/libpq.so.2 also exists. The owner is postgres.web, permissions 755. Libpq.so.2 links to libpq.so.2.2.

Later the log reports a series of errors beginning with the warning at the top of this post. The later errors seem to derive from the modload error.

Tom

#!/bin/bash

export PATH=$PATH:/usr/local/pgsql/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/pgsql/lib

exec /usr/local/aolserver/bin/nsd $*

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

btw, the start command I am using is /usr/local/aolserver/bin/nsd-postgresql -u nsadmin -t /web/freegeek/freegeek.tcl.

If I start oacs as user nsadmin (rather than root), the nsd-postgres script above appears to work. At least postgresql loads. But other errors are exposed.

As the various packages load, there is a lot of querying on some of them, particularly ones which start "NO FULLQUERY FOR dbqd".

Example:

[01/Jul/2003:08:54:26][1583.1024][-main-] Debug: NO FULLQUERY FOR dbqd..NULL --> using default SQL
[01/Jul/2003:08:54:26][1583.1024][-main-] Notice: Querying '
    select package_key from apm_packages where package_id = '0';'
[01/Jul/2003:08:54:26][1583.1024][-main-] Notice: dbinit: sql(localhost::freegeek): '
    select package_key from apm_packages where package_id = '0'

There are errors on a proc indexer routine.

Example:

[01/Jul/2003:08:31:28][1379.2051][-sched-] Notice: Running scheduled proc search_indexer...
[01/Jul/2003:08:31:28][1379.2051][-sched-] Error: invalid command name "parameter::get"
invalid command name "parameter::get"
    while executing
"parameter::get -package_id $package_id -parameter $name -default $default"
    (procedure "ad_parameter" line 6)
    invoked from within
"ad_parameter -package_id [apm_package_id_from_key search] FtsEngineDriver"
    (procedure "search_indexer" line 3)
    invoked from within
"search_indexer"
    ("eval" body line 1)
    invoked from within
"eval [concat [list $proc] $args]"
    (procedure "ad_run_scheduled_proc" line 43)
    invoked from within
"ad_run_scheduled_proc {f f 60 search_indexer {} 1057064728 0 t}"

Finally, Aolserver no longer returns an error page. Now it returns a blank screen.

Tom

Yes, the system has worked in the past, very recently in fact. I wish I could tell you that I changed a config file or a set of permissions, anything. But I can't think of a single change. So it has to be something unremarkable.

I set "export LD_DEBUG=libs" in nsd-postgres and exported an output file. The other options (detail and basic) returned errors in Slackware so I dropped them. But the libs option was good. I searched the debug output file for occurances of libpq.so.2. It never turned up. So I searched for "libpq" and "so.2". Plenty of each but never combined as libpq.so.2.

Tom