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

Collapse
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.

Collapse
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.
Collapse
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?