Forum OpenACS Q&A: VMWare OACS installation question
I downloaded a copy of VMWare OACS distro from http://home.attbi.com/~jseq/oasis/about.html#section-4 and try to install OACS following the instrction note. But when I connect to aolserver it serves a page saying
The following database pools generated errors:
OpenACS could not allocate a handle from database pool "subquery
Possible causes might include
The database is not running.
The database driver has not been correctly installed.
The datasource or database user/password are incorrect.
You didn't define any database pools.
Has anyone else hit the same problem. Did I make a mistake somewhere
or is there some problem with that file. Maybe I should do a
installation from scratch. I played with ACS 3.4 2 years ago and
would like to see what OACS can do. Thanks for your time
excerpt form the log file
[23/Jul/2002:23:27:05][847.1024][-main-] Notice: nsmain: AOLserver/3.3.1+ad13 starting [23/Jul/2002:23:27:05][847.1024][-main-] Notice: nsmain: security info: uid=100, euid=100, gid=97, egid=97 [23/Jul/2002:23:27:05][847.1024][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024 [23/Jul/2002:23:27:05][847.1024][-main-] Notice: modload: loading '/usr/lib/postgres.so' [23/Jul/2002:23:27:05][847.1024][-main-] Notice: PostgreSQL loaded. [23/Jul/2002:23:27:05][847.1024][-main-] Notice: adp: mapped /*.adp [23/Jul/2002:23:27:05][847.1024][-main-] Notice: adp: mapped /*.adp [23/Jul/2002:23:27:05][847.1024][-main-] Notice: modload: loading '/usr/lib/nssock.so' [23/Jul/2002:23:27:05][847.1024][-main-] Notice: modload: loading '/usr/lib/nslog.so' [23/Jul/2002:23:27:05][847.1024][-main-] Notice: nslog: opened '/var/log/aolserver/openacs4.log' [23/Jul/2002:23:27:05][847.1024][-main-] Notice: modload: loading '/usr/lib/nsperm.so' [23/Jul/2002:23:27:05][847.1024][-main-] Notice: modload: loading '/usr/lib/nssha1.so' [23/Jul/2002:23:27:05][847.1024][-main-] Notice: modload: loading '/usr/lib/nscache.so' [23/Jul/2002:23:27:05][847.1024][-main-] Notice: nscache module version @VER@ [23/Jul/2002:23:27:05][847.1024][-main-] Notice: modload: loading '/usr/lib/nsrewrite.so' [23/Jul/2002:23:27:05][847.1024][-main-] Notice: modload: loading '/usr/lib/nsxml.so' [23/Jul/2002:23:27:05][847.1024][-main-] Notice: nsxml module starting [23/Jul/2002:23:27:05][847.1024][-main-] Notice: conf: [ns/server/openacs4]enabletclpages = 1 [23/Jul/2002:23:27:05][847.1024][-main-] Notice: tcl: enabling .tcl pages [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Loading OpenACS, rooted at /var/lib/aolserver/servers/openacs4 [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Sourcing /var/lib/aolserver/servers/openacs4/packages/acs-bootstrap- installer/bootstrap.tcl [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/servers/openacs4/packages/acs-bootstrap- installer/tcl/00-proc-procs.tcl [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/servers/openacs4/packages/acs-bootstrap- installer/tcl/10-utilities-procs.tcl [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/servers/openacs4/packages/acs-bootstrap- installer/tcl/20-db-bootstrap-procs.tcl [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/servers/openacs4/packages/acs-bootstrap- installer/tcl/30-apm-load-procs.tcl [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/servers/openacs4/packages/acs-bootstrap- installer/tcl/40-db-query-dispatcher-procs.tcl [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Database API: The following pools are available: subquery main log [23/Jul/2002:23:27:05][847.1024][-main-] Notice: dbdrv: opening database 'postgres:localhost::openacs4' [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Opening openacs4 on localhost [23/Jul/2002:23:27:05][847.1024][-main-] Error: Ns_PgOpenDb (postgres): Could not connect to localhost::openacs4: connectDBStart () -- connect() failed: No such file or directory Is the postmaster running locally and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'? [23/Jul/2002:23:27:05][847.1024][-main-] Error: dbdrv: failed to open database 'postgres:localhost::openacs4' [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Couldn't allocate a handle from database pool "subquery". [23/Jul/2002:23:27:05][847.1024][-main-] Error: RDBMS type could not be determined for any pool. [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Loading acs-tcl [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/00-database-procs.tcl... [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/10-charset-compat-procs.tcl... [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/30-xml-utils-procs.tcl... [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/acs-kernel-procs.tcl... [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/acs-permissions-procs.tcl... [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/acs-private-data-procs.tcl... [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/admin-procs.tcl... [23/Jul/2002:23:27:05][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/adp-parser-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/aolserver-3-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/apm-file-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/apm-install-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/apm-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/apm-xml-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/community-core-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/defs-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/deprecated-utilities-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/document-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/exception-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/membership-rel-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/memoize-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/navigation-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/object-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/object-type-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/openacs-kernel-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/request-processor-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/security-procs.tcl... [23/Jul/2002:23:27:06][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/server-cluster-procs.tcl... [23/Jul/2002:23:27:07][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/set-operation-procs.tcl... [23/Jul/2002:23:27:07][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/site-nodes-procs.tcl... [23/Jul/2002:23:27:07][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/sql-statement-procs.tcl... [23/Jul/2002:23:27:07][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/table-display-procs.tcl... [23/Jul/2002:23:27:07][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/tcl-documentation-procs.tcl... [23/Jul/2002:23:27:07][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/text-html-procs.tcl... [23/Jul/2002:23:27:07][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/user-extensions-procs.tcl... [23/Jul/2002:23:27:07][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/utilities-procs.tcl... [23/Jul/2002:23:27:07][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/widgets-procs.tcl... [23/Jul/2002:23:27:07][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/xml-0-sgml-procs.tcl... [23/Jul/2002:23:27:07][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/xml-1-dom-procs.tcl... [23/Jul/2002:23:27:08][847.1024][-main-] Notice: Loading packages/acs- tcl/tcl/xml-2-procs.tcl... [23/Jul/2002:23:27:08][847.1024][-main-] Error:The following database pools generated errors:
- OpenACS could not allocate a handle from database pool "subquery".
Possible causes might include:
- The database is not running.
- The database driver has not been correctly installed.
- The datasource or database user/password are incorrect.
- You didn't define any database pools.
[23/Jul/2002:23:27:08][847.1024][-main-] Notice: database problem found; Sourcing the installer. [23/Jul/2002:23:27:08][847.1024][-main-] Notice: Sourcing files for postload... [23/Jul/2002:23:27:08][847.1024][-main-] Notice: Done. [23/Jul/2002:23:27:08][847.1024][-main-] Notice: Executing initialization code blocks... [23/Jul/2002:23:27:08][847.1024][-main-] Notice: QD=Postload files to load: /var/lib/aolserver/servers/openacs4/www/index- oracle.xql /var/lib/aolserver/servers/openacs4/www/index- postgresql.xql /var/lib/aolserver/servers/openacs4/www/index.xql [23/Jul/2002:23:27:08][847.1024][-main-] Notice: QD=Postload files to load: [23/Jul/2002:23:27:08][847.1024][-main-] Notice: tcl: generating interp init script [23/Jul/2002:23:27:08][847.1024][-main-] Notice: nsmain: AOLserver/3.3.1+ad13 running [23/Jul/2002:23:27:08][847.1024][-main-] Notice: nsmain: security info: uid=100, euid=100, gid=97, egid=97 [23/Jul/2002:23:27:08][847.2051][-sched-] Notice: sched: starting [23/Jul/2002:23:27:08][847.1024][-main-] Notice: serv: waiting for warmup [23/Jul/2002:23:27:08][847.1024][-main-] Notice: serv: warmed up [23/Jul/2002:23:27:08][847.1024][-main-] Notice: socks: idle [23/Jul/2002:23:27:08][847.1024][-main-] Notice: sched: idle [23/Jul/2002:23:27:08][847.1024][-main-] Notice: nssock: listening on 192.168.111.131:8000 [23/Jul/2002:23:27:08][847.3076][-nssock-] Notice: nssock: starting [23/Jul/2002:23:27:08][847.3076][-nssock-] Notice: nssock: accepting connections
It seems that Postgres is not running. If you are comfortable with Unix then try to install it without the vmware. The docs are here... https://openacs.org/doc/openacs-4/
Everyone,
I think John's approach to using VMware is a good one. No more installation stuff. Just turn on the vmware. I have been discussing with Talli about packaging OpenACS into preset packages. Since OACS is just too flexible I think if we make different setup like ecommerce site, elearning site, cms site, etc. it will tell new users how good it is. John approach using VMWare looks good, install serveral pre-package OACS on the vmware. What do you guys think?
/etc/rc.d/init.d/postgresql startProbably postgresql is not started on bootup. You may want to tell Jon about this.
I restarted the postgres server and can try out OACS now.
Thanks a lot for your help.
Thanks for the bug report, and glad you were able to get it to work.
I'll make sure this is fixed in the next Oasis refresh.
js
I have exactly the same problem, but restarting or starting the postgre service didn't help.
What else did you change (in nsd.tcl, in postgresql.conf)?
Any ideas?
Thanks for any help.
I believe you want to try (as root)
/sbin/service postgresql start su postgres psql openacsIf you succeed with that, do you still get the same log errors when you start aolserver?
i.e.
/sbin/service aolserver start
Then read the log file...
If you succeed with the psql command, you can type "\d" to get a list of all the objects in the database. If you get a bunch of acs* tables, this should confirm that your db is fine.
Other debugging thoughts:
What you do get when you type ifconfig?
And what type of virtual network adapter is the VM using (bridged or NAT)?
Can you ping the VM from your host OS?
