Forum OpenACS Q&A: RDBMS type could not be determined for any pool

1: RDBMS type could not be determined for any pool

Posted by anjali n on 02/01/06 11:01 AM

hi,
I'm trying to install dotLRN and am totally new to this.I've installed PostgreSQL and AOLserver on my RHEL4.0 .As root i'm able to start and shutdown AOL server.Postgres is also starting and shutting down.Now the problem is that when i try to load it on my browser,i'm not getting the page with next button.Instead i'm getting an OpenACS page with error saying "RDBMS type could not be determined for any pool".Previously i got another error saying openACS could not allocate a handle from db pool1.I tried to make changes in config.tcl file as mentioned in the AOLserverdocumentation.Could anyone please tell me how to get rid of this error.
Thanx

2: Re: RDBMS type could not be determined for any pool (response to 1)

Posted by Dave Bauer on 02/01/06 02:49 PM

Make sure the database is configured corrrectly.

Make sure the database name is set in the config.tcl file and that the database exists.

If you can't figure it out, post the database pool section of your config file without any passwords or other private information.

3: Re: Re: RDBMS type could not be determined for any pool (response to 2)

Posted by anjali n on 02/02/06 07:09 AM

Thank you so much for the reply.
Given below is my config.tcl file.i've cut the section starting from MIME types .Do i need to send copy of Make files or any other files.
Do reply.

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.
set hostname gave my host name here
set address my ip 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 "my_server_name"
set servername "my_server"
set serverroot "/var/lib/aolserver/${server}"
#---------------------------------------------------------------------
# which database do you want? postgres or oracle
set database postgres

set db_name my_server_name #gave same name as the server name for data base .password set blank

if { $database == "oracle" } {
set db_password ""
} else {
set db_host localhost
set db_port 5432
set db_user my_server_name /*db user name and server name are same*/

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

set homedir /usr/local/aolserver
set bindir /usr/local/aolserver/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 512 * 8192]

/*i've deleted the section from MIME types till database drivers*/

#---------------------------------------------------------------------
#
# 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
}
ns_section "ns/db/driver/postgresql"
ns_param pgbin /usr/local/pgsql/bin

# 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
# https://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
ns_param min_stack_size 512
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:5432:${db_name}

ns_param user $db_user
ns_param password "" /*no password set*/
}

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 ""
}
/*i'm not sure which of the following should be commented or used.....found this in one documentation*/
/*******************************************************************************************/

ns_section "ns/server/${server}/db"
ns_section ns/server/${server}/acs/database
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"
#ns_param databases [list ora pg foo]
#ns_param pools_ora [list main subquery log]
ns_param pools_main [list pool1]
#ns_param pools_pg [list pg-main ]
#ns_param pools_foo [list foo1 foo2]
ns_param driverkey_pg {postgres}
#---------------------------------------------------------------------
# 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 libtDOM /usr/lib/tDOM-0.7.8/lib
# openacs versions earlier than 5.x requires nsxml
# ns_param nsxml ${bindir}/nsxml.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."

4: please help (response to 2)

Posted by anjali n on 02/02/06 07:34 AM

I'm using AOLSERVER4.0,OpenACS 5.2.0,postgreSQL7.4.11,TCL8.4.Do i need to mention the tDOM file in config.tcl.Also i'm not able to start and stop the AOLServer only as root and not as the AOLserver user.

5: error (response to 3)

Posted by anjali n on 02/02/06 08:39 AM

This is the error in my error.log file

[02/Feb/2006:12:14:40][11390.3086915264][-main-] Notice: nsmain: AOLserver/4.0.10 stopping
[02/Feb/2006:12:14:40][11395.3086915264][-main-] Notice: nsmain: AOLserver/4.0.10 stopping
[02/Feb/2006:12:14:40][11390.3086915264][-main-] Notice: driver: triggering shutdown
[02/Feb/2006:12:14:40][11390.3086915264][-main-] Notice: serv: stopping server: my_server_name
[02/Feb/2006:12:14:40][11390.3048717232][-driver-] Notice: exiting
[02/Feb/2006:12:14:40][11395.3086915264][-main-] Notice: driver: triggering shutdown
[02/Feb/2006:12:14:40][11395.3086915264][-main-] Notice: serv: stopping server: my_server_name
[02/Feb/2006:12:14:40][11395.3046734768][-driver-] Notice: exiting
[02/Feb/2006:12:14:40][11390.3086915264][-main-] Notice: serv: connection threads stopped
[02/Feb/2006:12:14:40][11390.3086915264][-main-] Notice: driver: shutdown complete
[02/Feb/2006:12:14:40][11390.3086915264][-main-] Notice: sched: shutdown pending
[02/Feb/2006:12:14:40][11390.3076422576][-sched-] Notice: sched: shutdown started
[02/Feb/2006:12:14:40][11390.3076422576][-sched-] Notice: sched: shutdown complete
[02/Feb/2006:12:14:40][11390.3076422576][-shutdown-] Notice: nslog: closing '/var/lib/aolserver/my_server_name/log/my_server_name.log'
[02/Feb/2006:12:14:40][11390.3086915264][-main-] Error: pidfile: failed to remove '/usr/local/aolserver/log/nspid.my_server_name': 'No such file or directory'
[02/Feb/2006:12:14:40][11390.3086915264][-main-] Notice: nsmain: AOLserver/4.0.10 exiting
[02/Feb/2006:12:14:40][11395.3086915264][-main-] Notice: serv: connection threads stopped
[02/Feb/2006:12:14:40][11395.3086915264][-main-] Notice: driver: shutdown complete
[02/Feb/2006:12:14:40][11395.3086915264][-main-] Notice: sched: shutdown pending
[02/Feb/2006:12:14:40][11395.3074325424][-sched-] Notice: sched: shutdown started
[02/Feb/2006:12:14:40][11395.3074325424][-sched-] Notice: sched: shutdown complete
[02/Feb/2006:12:14:40][11395.3074325424][-shutdown-] Notice: nslog: closing '/var/lib/aolserver/my_server_name/log/my_server_name.log'
[02/Feb/2006:12:14:40][11395.3086915264][-main-] Error: pidfile: failed to remove '/usr/local/aolserver/log/nspid.my_server_name': 'No such file or directory'
[02/Feb/2006:12:14:40][11395.3086915264][-main-] Notice: nsmain: AOLserver/4.0.10 exiting
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: nsmain: AOLserver/4.0.10 starting
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: nsmain: security info: uid=502, euid=502, gid=501, egid=501
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Error: pidfile: failed to open pid file '/usr/local/aolserver/log/nspid.my_server_name': 'Permission denied'
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: adp[my_server_name]: mapped /*.adp
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nssock.so'
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nslog.so'
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: nslog: opened '/var/lib/aolserver/my_server_name/log/my_server_name.log'
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nssha1.so'
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nscache.so'
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: nscache module version 1.5 server: e_learning_oracle_hcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nsdb.so'
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nspostgres.so'
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: PostgreSQL loaded.
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: conf: [ns/server/e_learning_oracle_hcl]enabletclpages = 0
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading OpenACS, rooted at /var/lib/aolserver/my_server_name
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/bootstrap.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Database API: Default database (dbn) is: 'default'
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Database API: The following pools are available for OpenACS:
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Error: Database API: RDBMS type could not be determined for any pool.
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Bootstrap: Loading acs-tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/base64-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/md5-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/mime-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[02/Feb/2006:12:14:44][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Error: Bootstrap: RDBMS type could not be determined for any pool.
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Bootstrap: database problem found; Sourcing the installer.
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Sourcing files for postload...
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Done.
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: Executing initialization code blocks...
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Debug: QD=Postload files to load:
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Debug: QD=Postload files to load:
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: nsmain: AOLserver/4.0.10 running
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: nsmain: security info: uid=502, euid=502, gid=501, egid=501
[02/Feb/2006:12:14:45][11481.3076422576][-sched-] Notice: sched: starting
[02/Feb/2006:12:14:45][11481.3086915264][-main-] Notice: nssock: listening on 10.103.93.207:8000
[02/Feb/2006:12:14:45][11481.3048717232][-driver-] Notice: starting
[02/Feb/2006:12:14:45][11481.3048717232][-driver-] Notice: driver: accepting connections
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: nsmain: AOLserver/4.0.10 starting
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: nsmain: security info: uid=502, euid=502, gid=501, egid=501
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Error: pidfile: failed to open pid file '/usr/local/aolserver/log/nspid.my_server_name': 'Permission denied'
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: adp[e_learning_oracle_hcl]: mapped /*.adp
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nssock.so'
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nslog.so'
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: nslog: opened '/var/lib/aolserver/my_server_name/log/my_server_name.log'
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nssha1.so'
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nscache.so'
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: nscache module version 1.5 server: my_server_name
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nsdb.so'
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nspostgres.so'
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: PostgreSQL loaded.
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: conf: [ns/server/my_server_name]enabletclpages = 0
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading OpenACS, rooted at /var/lib/aolserver/my_server_name
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Sourcing /var/lib/aolserver/e_learning_oracle_hcl/packages/acs-bootstrap-installer/bootstrap.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Database API: Default database (dbn) is: 'default'
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Database API: The following pools are available for OpenACS:
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Error: Database API: RDBMS type could not be determined for any pool.
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Bootstrap: Loading acs-tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/base64-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/md5-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/mime-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Error: Bootstrap: RDBMS type could not be determined for any pool.
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Bootstrap: database problem found; Sourcing the installer.
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Sourcing files for postload...
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Done.
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: Executing initialization code blocks...
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Debug: QD=Postload files to load:
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Debug: QD=Postload files to load:
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: nsmain: AOLserver/4.0.10 running
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Notice: nsmain: security info: uid=502, euid=502, gid=501, egid=501
[02/Feb/2006:12:15:16][11515.3074325424][-sched-] Notice: sched: starting
[02/Feb/2006:12:15:16][11515.3086915264][-main-] Error: nssock: failed to listen on 10.103.93.207:8000: Address already in use
[02/Feb/2006:12:15:16][11515.3046734768][-driver-] Notice: starting
[02/Feb/2006:12:15:16][11515.3046734768][-driver-] Notice: driver: accepting connections
[02/Feb/2006:12:15:28][11481.3052915632][-conn:my_server_name::0] Debug: apm_attribute_value domNode0x8928ba0 name --> dotlrn
[02/Feb/2006:12:15:28][11481.3052915632][-conn:my_server_name::0] Debug: apm_attribute_value domNode0x8928ba0 pretty-name dotlrn --> .LRN
[02/Feb/2006:12:15:28][11481.3052915632][-conn:my_server_name::0] Debug: apm_attribute_value domNode0x8928ba0 home --> https://openacs.org/projects/dotlrn
[02/Feb/2006:12:15:28][11481.3052915632][-conn:my_server_name::0] Debug: apm_attribute_value domNode0x8928ba0 min_stack_size 128 --> 512

6: Re: RDBMS type could not be determined for any pool (response to 1)

Posted by Dave Bauer on 02/02/06 03:22 PM

Looks ok, default config file should generally work.

I recommend you open the error log. Search backwards until you find the section where the server first starts up, then look until you see the initial connection to the database. You should see a more useful error than cannot allocate a pool. The database driver, for whatever reason is not loading, or is not connecting to the datbase.

7: Re: Re: RDBMS type could not be determined for any pool (response to 6)

Posted by anjali n on 02/02/06 06:31 PM

Now i GOT the database pool error initially.Now i'm getting RDBMS type could not be found error.I've installed tDOM also.Should i mention it anywhere in the config.tcl file.

8: Re: RDBMS type could not be determined for any pool (response to 1)

Posted by Dave Bauer on 02/02/06 06:49 PM

Here is a log of a bunch of errors b/c I don't have postgresql running:

First

[02/Feb/2006:12:42:06][9290.3084195520][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nsdb.so'
[02/Feb/2006:12:42:06][9290.3084195520][-main-] Notice: modload: loading '/usr/lib/aolserver4/bin/nspostgres.so'
[02/Feb/2006:12:42:06][9290.3084195520][-main-] Notice: PostgreSQL loaded.

Make sure nsdb and nspostgres are loaded. If they are...

[02/Feb/2006:12:42:07][9290.3084195520][-main-] Notice: Database API: Default database (dbn) is: 'default'
[02/Feb/2006:12:42:07][9290.3084195520][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[02/Feb/2006:12:42:07][9290.3084195520][-main-] Notice: Database API: The following pools are available for OpenACS: poo
l2 pool3 pool1
[02/Feb/2006:12:42:07][9290.3084195520][-main-] Notice: dbdrv: opening database 'postgres:localhost::openacs-5-2'
[02/Feb/2006:12:42:07][9290.3084195520][-main-] Notice: Opening openacs-5-2 on localhost
[02/Feb/2006:12:42:07][9290.3084195520][-main-] Error: Ns_PgOpenDb(postgres):  Could not connect to localhost::openacs-5
-2:  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"?
[02/Feb/2006:12:42:07][9290.3084195520][-main-] Error: dbdrv: failed to open database 'postgres:localhost::openacs-5-2'

Notice the chain of events that occurs when it tries to setup the database.

You should see something very close to this " Notice: dbdrv: opening database 'postgres:localhost::openacs-5-2'" in your log.

9: Re: Re: RDBMS type could not be determined for any pool (response to 6)

Posted by anjali n on 02/02/06 06:53 PM

This is the section of error.log when i first started the server.I had not mentioned the database name at that time.
could you please go through it

[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: nsmain: AOLserver/4.0.10 starting
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: nsmain: security info: uid=502, euid=502, gid=501, egid=501
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Error: pidfile: failed to open pid file '/usr/local/aolserver/log/nspid.my_server_name': 'Permission denied'
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: adp[my_server_name]: mapped /*.adp
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nssock.so'
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nslog.so'
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: nslog: opened '/var/lib/aolserver/my_server_name/log/e_learning_oracle_hcl.log'
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nssha1.so'
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nscache.so'
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: nscache module version 1.5 server: my_server_name
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nsdb.so'
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nspostgres.so'
[22/Jan/2006:17:19:27][26846.3086924000][-main-] Notice: PostgreSQL loaded.
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: conf: [ns/server/my_server_name]enabletclpages = 0
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading OpenACS, rooted at /var/lib/aolserver/my_server_name
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/bootstrap.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/my_server_name/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Database API: Default database (dbn) is: 'default'
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Database API: The following pools are available for OpenACS: pool2 pool3 pool1
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: dbdrv: opening database 'postgres:localhost::my_server_name'
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Opening my_server_name on localhost
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost::my_server_name.
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: dbdrv: opening database 'postgres:localhost::my_server_name'
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Opening e_learning_oracle_hcl on localhost
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost::my_server_name.
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: dbdrv: opening database 'postgres:localhost::my_server_name'
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Opening my_server_name on localhost
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost::my_server_name.
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Querying 'select version();'
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: dbinit: sql(localhost::my_server_name): 'select version()'
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Querying 'select count(*) from pg_class;'
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: dbinit: sql(localhost::my_server_name): 'select count(*) from pg_class'
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Querying 'select proname from pg_proc where proname = '__test__' and pronargs = 0;'
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: dbinit: sql(localhost::my_server_name): 'select proname from pg_proc where proname = '__test__' and pronargs = 0'
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Querying 'create function __test__() returns integer as 'begin end;' language 'plpgsql';'
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Error: Ns_PgExec: result status: 7 message: ERROR: language "plpgsql" does not exist
HINT: You need to use "createlang" to load the language into the database.

[22/Jan/2006:17:19:28][26846.3086924000][-main-] Error: dbinit: error(localhost::e_learning_oracle_hcl,ERROR: language "plpgsql" does not exist
HINT: You need to use "createlang" to load the language into the database.
): 'create function __test__() returns integer as 'begin end;' language 'plpgsql''
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Bootstrap: Loading acs-tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/00-database-procs-postgresql.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/base64-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/md5-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/mime-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Error: Bootstrap: We found the following problems with your PostgreSQL installation:

PL/pgSQL has not been created in your database. Execute the following command while logged in as a PostgreSQL "superuser":
```
createlang plpgsql your_database_name
```

[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Bootstrap: database problem found; Sourcing the installer.
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Sourcing files for postload...
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Done.
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: Executing initialization code blocks...
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Debug: QD=Postload files to load:
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Debug: QD=Postload files to load:
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: nsmain: AOLserver/4.0.10 running
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Notice: nsmain: security info: uid=502, euid=502, gid=501, egid=501
[22/Jan/2006:17:19:28][26846.3074333616][-sched-] Notice: sched: starting
[22/Jan/2006:17:19:28][26846.3086924000][-main-] Error: nssock: failed to listen on 127.0.0.1:80: Permission denied
[22/Jan/2006:17:19:28][26846.3065473968][-driver-] Notice: starting
[22/Jan/2006:17:19:28][26846.3065473968][-driver-] Notice: driver: accepting connections
[22/Jan/2006:17:34:28][26846.3086924000][-main-] Notice: nsmain: AOLserver/4.0.10 stopping
[22/Jan/2006:17:34:28][26846.3086924000][-main-] Notice: driver: triggering shutdown
[22/Jan/2006:17:34:28][26846.3086924000][-main-] Notice: serv: stopping server: my_server_name
[22/Jan/2006:17:34:28][26846.3065473968][-driver-] Notice: exiting
[22/Jan/2006:17:34:28][26846.3086924000][-main-] Notice: serv: connection threads stopped
[22/Jan/2006:17:34:28][26846.3086924000][-main-] Notice: driver: shutdown complete
[22/Jan/2006:17:34:28][26846.3086924000][-main-] Notice: sched: shutdown pending
[22/Jan/2006:17:34:28][26846.3074333616][-sched-] Notice: sched: shutdown started
[22/Jan/2006:17:34:28][26846.3074333616][-sched-] Notice: sched: shutdown complete
[22/Jan/2006:17:34:28][26846.3074333616][-shutdown-] Notice: nslog: closing '/var/lib/aolserver/my_server_name/log/my_server_name.log'
[22/Jan/2006:17:34:28][26846.3086924000][-main-] Error: pidfile: failed to remove '/usr/local/aolserver/log/nspid.my_server_name': 'No such file or directory'
[22/Jan/2006:17:34:28][26846.3086924000][-main-] Notice: nsmain: AOLserver/4.0.10 exiting

Could anything be wrong with the installation of postgres?Which are the other files and environmental variables which should be edited and set .Should i send the entire error.log file?

10: Re: RDBMS type could not be determined for any pool (response to 1)

Posted by Dave Bauer on 02/02/06 07:03 PM

Did you read the messagess on the install page?

[22/Jan/2006:17:19:28][26846.3086924000][-main-] Error: Ns_PgExec: result status: 7 message: ERROR: language "plpgsql" does not exist
HINT: You need to use "createlang" to load the language into the database.

This shows plpgsql is not installed in your database.

createlang plpgsql dbname

will fix it.

11: Re: Re: RDBMS type could not be determined for any pool (response to 10)

Posted by anjali n on 02/02/06 08:22 PM

plpgsql is installed and i am able to create database.I got this error when i had just started .Now i can create and drop database successfully..
i had given createlang plpgsql template1.here's the server.log file of postgres

FATAL: lock file "/tmp/.s.PGSQL.5432.lock" already exists
HINT: Is another postmaster (PID 29594) using socket file "
/tmp/.s.PGSQL.5432"?
FATAL: lock file "/tmp/.s.PGSQL.5432.lock" already exists
HINT: Is another postmaster (PID 29594)
using socket file "/tmp/.s.PGSQL.5432"?
FATAL: lock file "/tmp/.s.PGSQL.5432.lock" already exists
HINT: Is another
postmaster (PID 29594) using socket file "/tmp/.s.PGSQL.5432"?
FATAL: data directory "/usr/local/pgsql/data" does not
exist
LOG: database system was shut down at 2006-01-23 10:41:51 IST
LOG: checkpoint record is at 0/9B1058
LOG: redo
record is at 0/9B1058; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 536; next OID: 17142
LOG:
database system is ready
ERROR: syntax error at or near "createfunction" at character 1
FATAL: database
"" does not exist
FATAL: database "my_server" does not exist
FATAL:
lock file "/tmp/.s.PGSQL.5432.lock" already exists
HINT: Is another postmaster (PID 2812) using socket file
"/tmp/.s.PGSQL.5432"?
FATAL: "/usr/local/pgsql/data" is not a valid data directory
DETAIL:
File "/usr/local/pgsql/data/PG_VERSION" is missing.
FATAL: lock file "/tmp/.s.PGSQL.5432.lock" already exists
HINT:
Is another postmaster (PID 2812) using socket file "/tmp/.s.PGSQL.5432"?
FATAL: lock file "/tmp/.s.PGSQL.5432.lock"
already exists
HINT: Is another postmaster (PID 2812) using socket file "/tmp/.s.PGSQL.5432"?
FATAL:
"/usr/local/pgsql/data" is not a valid data directory
DETAIL: File "/usr/local/pgsql/data/PG_VERSION" is missing.
FATAL:
"/usr/local/pgsql/data" is not a valid data directory
DETAIL: File "/usr/local/pgsql/data/PG_VERSION" is missing.
FATAL:
"/usr/local/pgsql/data" is not a valid data directory
DETAIL: File "/usr/local/pgsql/data/PG_VERSION" is missing.
LOG:
unexpected EOF on client connection
LOG: received smart shutdown request
LOG: shutting down
LOG: could not open "/usr/
local/pgsql/data/base/17145/1255": No such file or directory
CONTEXT: writing block 64 of relation 17145/1255
PANIC: c
ould not write block 64 of 17145/1255 blind: No such file or directory
CONTEXT:
writing block 64 of relation 17145/1255
LOG: shutdown process (PID 19637) was terminated by signal 6

12: Re: Re: RDBMS type could not be determined for any pool (response to 10)

Posted by anjali n on 02/03/06 10:51 AM

createlang: language "plpgsql" is already installed in database "my_server_name"

This (RDBMS type could not be determined for any pool)
is the only error i'm getting..I am not able to figure out as to what error it is.
please help....

13: Re: RDBMS type could not be determined for any pool (response to 1)

Posted by Torben Brosten on 02/03/06 11:58 AM

Anjali N,

Which documentation are you following?

The error logs suggest you have 2 aolservers running at times, and attempt to run 2 pg postmasters sometimes, too. Is it possible that you createlang plpgsql for one database, while aolserver is accessing another (installation of postgres)?

I don't have RHEL4.0 here, but I believe you can use:

  ps -auxwww | grep postmaster

to see if postgres is running, and:

  ps -auxwww | grep nsd

  ps -auxwww | grep aol

to see if aolserver is running.

How are you starting/stopping aolserver and postgres? Did you install any automatic startup scripts?

14: hi (response to 13)

Posted by anjali n on 02/03/06 12:40 PM

Hi Torben,
Thanks for your response

I'm using the documents at the following link
for postgres
https://openacs.org/doc/openacs-4/postgres.html
for aolserver
https://openacs.org/doc/openacs-5-0-0/aolserver4.html
for dotlrn
https://openacs.org/projects/dotlrn/dotlrn-doc/dotlrn_1_0_installation
for openacs
https://openacs.org/doc/openacs-5-2/openacs.html
for starting and stopping aolserver
https://openacs.org/doc/openacs-5-0-0/maintenance-web.html

I gave the following as root

ps -auxwww | grep postmaster

Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
postgres 18327 0.0 0.0 18060 1668 pts/1 S 15:06 0:00 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
root 14577 0.0 0.0 4048 682 pts/1 S+ 16:41 0:00 grep postmaster

ps -auxwww | grep nsd

root 1610 0.0 0.0 2776 236 ? S Jan24 0:00 readproctitle service errors: ...Notice: encoding: loaded: utf-8?[03/Feb/2006:14:19:06][18059.3086915264][-main-] Notice: nsd.tcl: starting to read config file...?[03/Feb/2006:14:19:06][18859.3186915764][-main-] Notice: nsd.tcl: using threadsafe tcl: 1?[03/Feb/2006:14:19:06][18559.308515242][-main-] Notice: nsd.tcl: finished reading config file.?[03/Feb/2006:14:19:06][18059.3086915264][-main-] Notice: encoding: loaded: utf-8?
root 12344 0.0 0.0 4608 578 ? Ss Jan30 0:00 rhnsd --interval 240
502 16429 0.0 1.2 72802 26572 ? Ssl 15:15 0:00 /usr/local/aolserver/bin/nsd -t /var/lib/aolserver/my_server_name/etc/config.tcl
root 18539 0.0 0.0 4068 632 pts/1 S+ 16:44 0:00 grep nsd

ps -auxwww | grep aol

Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
502 18419 0.0 1.2 72192 25272 ? Ssl 15:15 0:00 /usr/local/aolserver/bin/nsd -t /var/lib/aolserver/my_server_name/etc/config.tcl
root 18532 0.0 0.0 5236 692 pts/1 S+ 16:48 0:00 grep aol

i haven't installed any automatic start up scripts yet.
i'm using
$OPENACS_SERVICE_NAME etc]$ killall nsd
nsd: no process killed
[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ /usr/local/aolserver/bin/nsd-postgres -t /var/lib/aolserver/$OPENACS_SERVICE_NAME/etc/config.tcl

to start up aolserver and also

svc -d /service/service0 - Bring the server down
svc -u /service/service0 - Start the server up and leave it in keepalive mode.
svc -o /service/service0 - Start the server up once. Do not restart it if it stops.
svc -t /service/service0 - Stop and immediately restart the server.
svc -k /service/service0
I think i've installed two instances of aolserver at different locations.Will it work if i remove one of them?

Thanx.

15: Re: RDBMS type could not be determined for any pool (response to 1)

Posted by Torben Brosten on 02/03/06 10:18 PM

It looks like you should not include the dash with "ps" commands. So ps -auxwww becomes ps auxwww. You can also use ps aux to view 1 line per process.

The first number in the ps is the process id, pid for short. The commands above both show 502, so you have only 1 aolserver running at the time you ran ps auxwww.

The svc commands are part of daemontools, which is an automatic startup facility for aolserver. Avoid using them when you are using the other method to start aolserver. You may want to type svc -d /service/service0 just to verify that daemontools does not try to restart aolserver on its own.

Since you used the oacs-5-0 instructions for installing aolserver (instead of https://openacs.org/doc/openacs-5-2/aolserver4.html ), get a fresh copy of config.tcl from cvs to verify that you have one that works well with oacs-5-2. Get it from: http://cvs.openacs.org/cvs/*checkout*/openacs-4/etc/config.tcl?rev=1.32.2.1
Only edit these to begin with:

set hostname [ns_info hostname] set address 0.0.0.0 set db_host localhost set db_port "" set db_user $server

Then verify that postmaster is running and aolserver is not running:

ps aux | grep postmaster
ps aux | nsd

Here is how it looks when I verify here:

~ bohr$ ps aux | grep postmaster
postgres   346   0.0  0.0    38040    208  ??  S    21Jan06   0:04.23 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/dat
root      4326   0.0  0.1    18172    336 std  S+    1:08PM   0:00.00 grep postmaster
~ bohr$ ps aux | grep nsd
root      4328   0.0  0.0    18644     92 std  R+    1:08PM   0:00.00 grep nsd

My example shows 1 pid for postmaster, number 346. No existing processes for aolserver.

To rule out any problems carrying over from earlier attempts at installing, drop the current database, and re-create it with the CREATEDB command.

Then start aolserver, and watch the logs.

Post how it breaks.

16: Re: Re: RDBMS type could not be determined for any pool (response to 15)

Posted by anjali n on 02/06/06 05:16 AM

thanks for the reply.I'll work on it and let you know.

17: error (response to 16)

Posted by anjali n on 02/06/06 03:36 PM

Hi,
I tried to reinstall aolserver.When i installed nspostgres following the OpenACS-5.2.0 manual i'm getting the following error

make install POSTGRES=LSB ACS=1 INST=/usr/local/aolserver AOLSERVER=/usr/local/aolserver

gcc -pipe -DBIND_EMULATION -I/usr/include -DFOR_ACS_USE -O2 -Wall -Wno-implicit-int -fno-strict-aliasing -fPIC -I/usr/local/aolserver/include -I/usr/local/include -DNO_CONST -DTCL_THREADS=1 -DUSE_THREAD_ALLOC=1 -D_REENTRANT=1 -D_THREAD_SAFE=1 -DHAVE_PTHREAD_ATTR_SETSTACKSIZE=1 -DHAVE_PTHREAD_ATFORK=1 -DHAVE_READDIR_R=1 -DHAVE_THREE_ARG_READDIR_R=1 -DPEEK_XCLOSEIM=1 -D_LARGEFILE64_SOURCE=1 -DTCL_WIDE_INT_TYPE=long\ long -DHAVE_STRUCT_STAT64=1 -DHAVE_OPEN64=1 -DHAVE_LSEEK64=1 -DHAVE_TYPE_OFF64_T=1 -DHAVE_GETCWD=1 -DHAVE_OPENDIR=1 -DHAVE_STRSTR=1 -DHAVE_STRTOL=1 -DHAVE_STRTOLL=1 -DHAVE_STRTOULL=1 -DHAVE_TMPNAM=1 -DHAVE_WAITPID=1 -DHAVE_LIMITS_H=1 -DHAVE_UNISTD_H=1 -DHAVE_SYS_PARAM_H=1 -DUSE_TERMIOS=1 -DHAVE_SYS_TIME_H=1 -DTIME_WITH_SYS_TIME=1 -DHAVE_TM_ZONE=1 -DHAVE_GMTIME_R=1 -DHAVE_LOCALTIME_R=1 -DHAVE_TM_GMTOFF=1 -DHAVE_TIMEZONE_VAR=1 -DHAVE_ST_BLKSIZE=1 -DSTDC_HEADERS=1 -DHAVE_SIGNED_CHAR=1 -DHAVE_LANGINFO=1 -DHAVE_SYS_IOCTL_H=1 -DTCL_CFG_OPTIMIZED=1 -DTCL_CFG_DEBUG=1 -DHAVE_INTTYPES_H=1 -DHAVE_TIMEGM=1 -DHAVE_POLL=1 -DHAVE_DRAND48=1 -DHAVE_RANDOM=1 -DHAVE_CMMSG=1 -DHAVE_GETADDRINFO=1 -DHAVE_GETNAMEINFO=1 -DHAVE_ZLIB_H=1 -DHAVE_LIBZ=1 -c -o nspostgres.o nspostgres.c
In file included from nspostgres.c:32:
nspostgres.h:48:22: libpq-fe.h: No such file or directory
In file included from nspostgres.c:32:
nspostgres.h:169: syntax error before "PGconn"
nspostgres.h:169: warning: no semicolon at end of struct or union
nspostgres.h:171: syntax error before '*' token
nspostgres.h:171: warning: data definition has no type or storage class
nspostgres.h:176: syntax error before '}' token
nspostgres.h:176: warning: data definition has no type or storage class
nspostgres.c: In function `Ns_PgOpenDb':
nspostgres.c:109: `nsConn' undeclared (first use in this function)
nspostgres.c:109: (Each undeclared identifier is reported only once
nspostgres.c:109: for each function it appears in.)
nspostgres.c:110: `PGconn' undeclared (first use in this function)
nspostgres.c:110: `pgConn' undeclared (first use in this function)
nspostgres.c:134: warning: implicit declaration of function `PQsetdbLogin'
nspostgres.c:142: warning: implicit declaration of function `PQstatus'
nspostgres.c:142: `CONNECTION_OK' undeclared (first use in this function)
nspostgres.c:164: warning: implicit declaration of function `PQerrorMessage'
nspostgres.c:165: warning: implicit declaration of function `PQfinish'
nspostgres.c: In function `Ns_PgCloseDb':
nspostgres.c:178: `nsConn' undeclared (first use in this function)
nspostgres.c: In function `Ns_PgSetErrorstate':
nspostgres.c:209: `nsConn' undeclared (first use in this function)
nspostgres.c:214: warning: implicit declaration of function `PQresultStatus'
nspostgres.c:215: `PGRES_EMPTY_QUERY' undeclared (first use in this function)
nspostgres.c:216: `PGRES_COMMAND_OK' undeclared (first use in this function)
nspostgres.c:217: `PGRES_TUPLES_OK' undeclared (first use in this function)
nspostgres.c:218: `PGRES_COPY_OUT' undeclared (first use in this function)
nspostgres.c:219: `PGRES_COPY_IN' undeclared (first use in this function)
nspostgres.c:220: `PGRES_NONFATAL_ERROR' undeclared (first use in this function)
nspostgres.c:221: warning: implicit declaration of function `PQresultErrorMessage'
nspostgres.c:221: warning: passing arg 2 of `Tcl_DStringAppend' makes pointer from integer without a cast
nspostgres.c:224: `PGRES_FATAL_ERROR' undeclared (first use in this function)
nspostgres.c:225: warning: passing arg 2 of `Tcl_DStringAppend' makes pointer from integer without a cast
nspostgres.c:228: `PGRES_BAD_RESPONSE' undeclared (first use in this function)
nspostgres.c:230: warning: passing arg 2 of `Tcl_DStringAppend' makes pointer from integer without a cast
nspostgres.c: In function `set_transaction_state':
nspostgres.c:244: `nsConn' undeclared (first use in this function)
nspostgres.c: In function `Ns_PgExec':
nspostgres.c:274: `nsConn' undeclared (first use in this function)
nspostgres.c:290: warning: implicit declaration of function `PQclear'
nspostgres.c:308: warning: implicit declaration of function `PQexec'
nspostgres.c:320: `CONNECTION_BAD' undeclared (first use in this function)
nspostgres.c:330: `PGRES_NONFATAL_ERROR' undeclared (first use in this function)
nspostgres.c:397: `PGRES_TUPLES_OK' undeclared (first use in this function)
nspostgres.c:401: `PGRES_COPY_IN' undeclared (first use in this function)
nspostgres.c:402: `PGRES_COPY_OUT' undeclared (first use in this function)
nspostgres.c:405: `PGRES_COMMAND_OK' undeclared (first use in this function)
nspostgres.c:407: warning: implicit declaration of function `PQcmdTuples'
nspostgres.c:407: warning: passing arg 1 of `sscanf' makes pointer from integer without a cast
nspostgres.c:413: warning: passing arg 3 of `Ns_DbSetException' makes pointer from integer without a cast
nspostgres.c: In function `Ns_PgResetHandle':
nspostgres.c:423: `nsConn' undeclared (first use in this function)
nspostgres.c:436: `PGRES_COMMAND_OK' undeclared (first use in this function)
nspostgres.c: In function `Ns_PgSelect':
nspostgres.c:461: `nsConn' undeclared (first use in this function)
nspostgres.c:478: `PGRES_TUPLES_OK' undeclared (first use in this function)
nspostgres.c:480: warning: implicit declaration of function `PQnfields'
nspostgres.c:481: warning: implicit declaration of function `PQntuples'
nspostgres.c:485: warning: implicit declaration of function `PQfname'
nspostgres.c: In function `Ns_PgGetRow':
nspostgres.c:506: `nsConn' undeclared (first use in this function)
nspostgres.c:534: warning: implicit declaration of function `PQgetvalue'
nspostgres.c: In function `Ns_PgFlush':
nspostgres.c:551: `nsConn' undeclared (first use in this function)
nspostgres.c: In function `blob_get':
nspostgres.c:792: `nsConn' undeclared (first use in this function)
nspostgres.c:792: syntax error before ')' token
nspostgres.c:820: warning: assignment makes pointer from integer without a cast
nspostgres.c:821: warning: assignment makes pointer from integer without a cast
nspostgres.c: In function `blob_send_to_stream':
nspostgres.c:977: `nsConn' undeclared (first use in this function)
nspostgres.c:977: syntax error before ')' token
nspostgres.c:1040: warning: assignment makes pointer from integer without a cast
nspostgres.c:1041: warning: assignment makes pointer from integer without a cast
nspostgres.c: In function `DbFail':
nspostgres.c:1116: `pgconn' undeclared (first use in this function)
nspostgres.c:1130: warning: assignment makes pointer from integer without a cast
nspostgres.c: In function `parse_bind_variables':
nspostgres.c:1211: warning: unused variable `first_bind'
nspostgres.c: In function `PgBindCmd':
nspostgres.c:1327: warning: unused variable `value_frag_len'
nspostgres.c: In function `PgCmd':
nspostgres.c:1524: `pgconn' undeclared (first use in this function)
nspostgres.c:1530: syntax error before ')' token
nspostgres.c:1601: warning: implicit declaration of function `PQdb'
nspostgres.c:1603: warning: implicit declaration of function `PQhost'
nspostgres.c:1605: warning: implicit declaration of function `PQoptions'
nspostgres.c:1607: warning: implicit declaration of function `PQport'
nspostgres.c:1614: `CONNECTION_OK' undeclared (first use in this function)
nspostgres.c: In function `Ns_PgBindRow':
nspostgres.c:1675: `nsConn' undeclared (first use in this function)
nspostgres.c:1691: `PGRES_TUPLES_OK' undeclared (first use in this function)
make: *** [nspostgres.o] Error 1

please help

18: Re: RDBMS type could not be determined for any pool (response to 1)

Posted by Dave Bauer on 02/06/06 03:44 PM

This is they key "nspostgres.h:48:22: libpq-fe.h: No such file or directory"

You specifiied POSTGRES=LSB on the make command line.
#
# Manage to find PostgreSQL components in the system, or where you specify
#
ifeq ($(POSTGRES),LSB)
PGLIB = /usr/lib
PGINC = /usr/include
else
PGLIB = $(POSTGRES)/lib
PGINC = $(POSTGRES)/include
endif

It's looking for libpq-fe.h in /usr/include

Find out if that is where the Postgresql headers are installed or not. The second most common location would be /usr/local so you could try specifying POSTGRES=/usr/local and see if that works. Make sure libpq-fe.h does exist somewhere on your system. The nspostgres Makefile says

19: Re: Re: RDBMS type could not be determined for any pool (response to 18)

Posted by anjali n on 02/07/06 05:32 AM

i tried using "make install POSTGRES=/usr/local/pgsql ACS=1 INST=/usr/local/aolserver AOLSERVER=/usr/local/aolserver"
i'm getting this warning
nspostgres.c: In function `blob_send_to_stream':
nspostgres.c:979: warning: `fd' might be used uninitialized in this function
nspostgres.c:981: warning: `conn' might be used uninitialized in this function
nspostgres.c: In function `parse_bind_variables':
nspostgres.c:1210: warning: unused variable `first_bind'
nspostgres.c: In function `PgBindCmd':
nspostgres.c:1326: warning: unused variable `value_frag_len'
/bin/rm -f nspostgres.so
gcc -pipe -shared -nostartfiles -L/usr/local/aolserver/lib -o nspostgres.so nspostgres.o -L/usr/local/pgsql/lib -lpq -lnsthread -lnsd -L/usr/local/lib -ltcl8.4 -ldl -lpthread -lieee -lm -lz -lgcc_s -Wl,-rpath,/usr/local/aolserver/lib -Wl ,-rpath,/usr/local/lib
/usr/local/aolserver/bin/install-sh -c nspostgres.so /usr/local/aolserver/bin/

can i ignore this warning and proceed

20: Re: RDBMS type could not be determined for any pool (response to 1)

Posted by Nitish Bezzala on 02/07/06 05:47 AM

Yes, you can ignore the warnings.

21: Re: Re: RDBMS type could not be determined for any pool (response to 20)

Posted by anjali n on 02/07/06 08:32 AM

Thankyou very much........Finally i got OpenACS page loaded on my Web browser.......