Forum OpenACS Q&A: Re: Re: RDBMS type could not be determined for any pool
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: 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?