Forum OpenACS Q&A: Installation with Postgresql on network server...Help!
I get the Welcome page and fill out the preliminary info and hit submit. I then get the page saying Data Kenel being loaded, but it hangs there.
I ran with debug on and can see that before the wait for me to enter the info, it connected to the database and loaded the tcl packages, then when I hit submit, it parsed and verified the info but did not try to connect with the dbhost. It appears that it is looking on my node for [psql] and not on the server. The error says /usr/bin/psql "No Such File or Directory;" I don't have psql on my machine but thaat is where it is on the server. You can see by the line above th error line that it has all the info in $pghost &pgport etc.
Please help, I have been here for four days trying to make this work. It seems like it might fill the bill for our community project.
Thank you.
[19/Dec/2005:09:37:31][4057.3086911712][-main-] Notice: nsmain: AOLserver/4.0.10 stopping
[19/Dec/2005:09:37:31][4057.3086911712][-main-] Notice: driver: triggering shutdown
[19/Dec/2005:09:37:31][4057.3086911712][-main-] Notice: serv: stopping server: service0
[19/Dec/2005:09:37:31][4057.3065490352][-driver-] Notice: exiting
[19/Dec/2005:09:37:31][4057.3086911712][-main-] Notice: serv: connection threads stopped
[19/Dec/2005:09:37:31][4057.3086911712][-main-] Notice: driver: shutdown complete
[19/Dec/2005:09:37:31][4057.3086911712][-main-] Notice: sched: shutdown pending
[19/Dec/2005:09:37:31][4057.3074321328][-sched-] Notice: sched: shutdown started
[19/Dec/2005:09:37:31][4057.3074321328][-sched-] Notice: sched: shutdown complete
[19/Dec/2005:09:37:31][4057.3074321328][-shutdown-] Notice: nslog: closing '/var/lib/aolserver/service0/log/service0.log'
[19/Dec/2005:09:37:31][4057.3086911712][-main-] Error: pidfile: failed to remove '/usr/local/aolserver/log/nspid.service0': 'No such file or directory'
[19/Dec/2005:09:37:31][4057.3086911712][-main-] Notice: nsmain: AOLserver/4.0.10 exiting
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: nsmain: AOLserver/4.0.10 starting
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: nsmain: security info: uid=502, euid=502, gid=505, egid=505
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Error: pidfile: failed to open pid file '/usr/local/aolserver/log/nspid.service0': 'Permission denied'
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: adp[service0]: mapped /*.adp
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nssock.so'
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nslog.so'
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: nslog: opened '/var/lib/aolserver/service0/log/service0.log'
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nssha1.so'
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nscache.so'
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: nscache module version 1.5 server: service0
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nsdb.so'
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nspostgres.so'
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: PostgreSQL loaded.
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: conf: [ns/server/service0]enabletclpages = 0
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading OpenACS, rooted at /var/lib/aolserver/service0
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Sourcing /var/lib/aolserver/service0/packages/acs-bootstrap-installer/bootstrap.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/service0/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/service0/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/service0/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/service0/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/service0/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Database API: Default database (dbn) is: 'default'
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Database API: The following pools are available for OpenACS: pool2 pool3 pool1
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: dbdrv: opening database 'postgres:pgsql.wwwntm.org:5432:wwwuser_testacs'
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Opening wwwuser_testacs on pgsql.wwwntm.org, port 5432
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to pgsql.wwwntm.org:5432:wwwuser_testacs.
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: dbdrv: opening database 'postgres:pgsql.wwwntm.org:5432:wwwuser_testacs'
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Opening wwwuser_testacs on pgsql.wwwntm.org, port 5432
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to pgsql.wwwntm.org:5432:wwwuser_testacs.
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: dbdrv: opening database 'postgres:pgsql.wwwntm.org:5432:wwwuser_testacs'
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Opening wwwuser_testacs on pgsql.wwwntm.org, port 5432
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to pgsql.wwwntm.org:5432:wwwuser_testacs.
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Bootstrap: Loading acs-tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/00-database-procs-postgresql.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/application-data-link-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/application-link-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/base64-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/callback-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/ds-stub-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/install-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/md5-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/mime-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/navigation-callback-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/pdf-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/stack-trace-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[19/Dec/2005:09:40:05][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[19/Dec/2005:09:40:06][18068.3086911712][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[19/Dec/2005:09:40:06][18068.3086911712][-main-] Notice: Bootstrap: Installation is not complete - sourcing the installer.
[19/Dec/2005:09:40:06][18068.3086911712][-main-] Notice: Sourcing files for postload...
[19/Dec/2005:09:40:06][18068.3086911712][-main-] Notice: Done.
[19/Dec/2005:09:40:06][18068.3086911712][-main-] Notice: Executing initialization code blocks...
[19/Dec/2005:09:40:06][18068.3086911712][-main-] Notice: nsmain: AOLserver/4.0.10 running
[19/Dec/2005:09:40:06][18068.3086911712][-main-] Notice: nsmain: security info: uid=502, euid=502, gid=505, egid=505
[19/Dec/2005:09:40:06][18068.3074321328][-sched-] Notice: sched: starting
[19/Dec/2005:09:40:06][18068.3086911712][-main-] Notice: nssock: listening on 68.164.220.150:8000
[19/Dec/2005:09:40:06][18068.3065346992][-driver-] Notice: starting
[19/Dec/2005:09:40:06][18068.3065346992][-driver-] Notice: driver: accepting connections
[19/Dec/2005:09:40:22][18068.3069557680][-conn:service0::1] Warning: tclfilter: install_handler return invalid result:
[19/Dec/2005:09:42:18][18068.3067452336][-conn:service0::3] Notice:
DAVEB pghost = '-h pgsql.wwwntm.org' pgport = '-p 5432' pguser = '-U wwwuser_testacs'
[19/Dec/2005:09:42:18][18068.3067452336][-conn:service0::3] Error: Error sourcing /var/lib/aolserver/service0/packages/acs-bootstrap-installer/installer/install.tcl:
couldn't execute "psql": no such file or directory
while executing
"open "|[file join [db_get_pgbin] psql] $pghost $pgport $pguser -f $file_name [db_get_database] $pgpass" "r""
("postgresql" arm line 37)
invoked from within
"switch $driverkey {
oracle {
global env
set user_pass [db_get_sql_user -dbn $dbn]
cd [file dirname $file]..."
(procedure "db_source_sql_file" line 6)
invoked from within
"db_source_sql_file -callback apm_ns_write_callback acs-kernel-create.sql"
(procedure "install_do_data_model_install" line 7)
invoked from within
"install_do_data_model_install"
invoked from within
"if { ![install_good_data_model_p] } {
install_do_data_model_install
} else {
ns_write "Kernel data model already installed."
# If kernel i..."
(file "/var/lib/aolserver/service0/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
invoked from within
"source $__file "
[19/Dec/2005:09:42:18][18068.3066399664][-conn:service0::4] Warning: tclfilter: install_handler return invalid result:
[19/Dec/2005:09:47:57][18068.3068505008][-conn:service0::2] Warning: tclfilter: install_handler return invalid result:
