Forum OpenACS Q&A: Re: Installation problems OpenACS 5.2 on ubuntu

Collapse
Posted by Gustaf Neumann on
what postgres version are you using? have you seen:
http://openacs.org/xowiki/How_to_install_in_Postgres_8.x ?
Collapse
Posted by Arbie Samong on
I'm also running into the same problem. I get a blank page after next-ing on the OpenACS home page. I already did the postgresql.conf modification stated above with the specified values, restarted postgresql and openacs on init.d. Yet, when I do $> tail error.log I still get:

[19/Oct/2007:22:52:42][8799.3083851456][-main-] Notice: Sourcing files for postload...
[19/Oct/2007:22:52:42][8799.3083851456][-main-] Notice: Done.
[19/Oct/2007:22:52:42][8799.3083851456][-main-] Notice: Executing initialization code blocks...
[19/Oct/2007:22:52:42][8799.3083851456][-main-] Notice: nsmain: AOLserver/4.0.10 running
[19/Oct/2007:22:52:42][8799.3083851456][-main-] Notice: nsmain: security info: uid=1000, euid=1000, gid=1001, egid=1001
[19/Oct/2007:22:52:42][8799.3083851456][-main-] Notice: nssock: listening on 0.0.0.0:8000
[19/Oct/2007:22:52:42][8799.3074980752][-sched-] Notice: sched: starting
[19/Oct/2007:22:52:42][8799.3063659408][-driver-] Notice: starting
[19/Oct/2007:22:52:42][8799.3063659408][-driver-] Notice: driver: accepting connections
[19/Oct/2007:22:52:45][8799.3067870096][-conn:arbie::1] Error: Unable to source /var/lib/aolserver/arbie/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.

PS - I had my name as the folder name following this guide on installation: http://openacs.org/xowiki/OpenACSDebianInstallGuide

PS2 - I'm running Ubuntu Feisty (7.04)

Thanks,
Arbie

Collapse
Posted by Arbie Samong on
Bump*

I tried to upgrade to Gutsy, used a VMware appliance, reinstall using apt-get on PostgreSQL8.2 and AOLServer, downloaded the OpenACS5.3 from this site, and still get the same error.

I already followed the steps on preparing PostgreSQL8.2 for installation (edits on the config file). The homepage already displays which says the the data model is now setup. When I click on proceed, I still get a blank page. Here's the full error.log (it's a fresh one). The only error I noticed is in the last line, which is a missing packages-install.tcl script. It's not included in the downloaded tarball, so I'm wondering if this file is really needed.

=====================================================
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: nsmain: AOLserver/4.0.10 starting
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: nsmain: security info: uid=1000, euid=1000, gid=1000, egid=1000
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: adp[dotlearner]: mapped /*.adp
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nssock.so'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nslog.so'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: nslog: opened '/var/lib/aolserver/openacs/log/dotlearner.log'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nssha1.so'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nscache.so'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: nscache module version @VER@ server: dotlearner
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nsdb.so'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: modload: loading '/usr/local/aolserver/bin/nspostgres.so'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: PostgreSQL loaded.
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: conf: [ns/server/dotlearner]enabletclpages = 0
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: XOTcl version 1.3.8 loaded
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading OpenACS, rooted at /var/lib/aolserver/openacs
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Sourcing /var/lib/aolserver/openacs/packages/acs-bootstrap-installer/bootstrap.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/openacs/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/openacs/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/openacs/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/openacs/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Bootstrap: sourcing /var/lib/aolserver/openacs/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Database API: Default database (dbn) is: 'default'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Database API: The following pools are available for OpenACS: pool2 pool3 pool1
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: dbdrv: opening database 'postgres:localhost::dotlearner'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Opening dotlearner on localhost
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost::dotlearner.
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: dbdrv: opening database 'postgres:localhost::dotlearner'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Opening dotlearner on localhost
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost::dotlearner.
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: dbdrv: opening database 'postgres:localhost::dotlearner'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Opening dotlearner on localhost
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to localhost::dotlearner.
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Querying 'select version();'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: dbinit: sql(localhost::dotlearner): 'select version()'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Querying 'select count(*) from pg_class;'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: dbinit: sql(localhost::dotlearner): 'select count(*) from pg_class'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Querying 'select proname from pg_proc where proname = '__test__' and pronargs = 0;'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: dbinit: sql(localhost::dotlearner): 'select proname from pg_proc where proname = '__test__' and pronargs = 0'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Querying 'create function __test__() returns integer as 'begin end;' language 'plpgsql';'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: dbinit: sql(localhost::dotlearner): 'create function __test__() returns integer as 'begin end;' language 'plpgsql''
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Querying 'drop function __test__();'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: dbinit: sql(localhost::dotlearner): 'drop function __test__();'
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Bootstrap: Loading acs-tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/00-database-procs-postgresql.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/base64-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/md5-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/mime-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[06/Nov/2007:15:54:30][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Debug: NO FULLQUERY FOR dbqd.acs-tcl.tcl.00-database-procs.db_table_exists.table_count --> using default SQL
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Querying '
select count(*) from pg_class
where relname = lower('apm_packages') and
relname !~ '^pg_' and relkind = 'r';'
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: dbinit: sql(localhost::dotlearner): '
select count(*) from pg_class
where relname = lower('apm_packages') and
relname !~ '^pg_' and relkind = 'r'
'
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Debug: NO FULLQUERY FOR dbqd.acs-tcl.tcl.00-database-procs.db_table_exists.table_count --> using default SQL
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Querying '
select count(*) from pg_class
where relname = lower('site_nodes') and
relname !~ '^pg_' and relkind = 'r';'
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: dbinit: sql(localhost::dotlearner): '
select count(*) from pg_class
where relname = lower('site_nodes') and
relname !~ '^pg_' and relkind = 'r'
'
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Querying '
select 1 from apm_package_versions
where package_key = 'acs-kernel'
and installed_p = 't';'
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: dbinit: sql(localhost::dotlearner): '
select 1 from apm_package_versions
where package_key = 'acs-kernel'
and installed_p = 't'
'
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Querying '

select 1 as admin_exists_p
from dual
where exists (select 1
from all_object_party_privilege_map m, users u, acs_magic_objects amo
where m.object_id = amo.object_id
and amo.name = 'security_context_root'
and m.party_id = u.user_id
and m.privilege = 'admin');'
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: dbinit: sql(localhost::dotlearner): '

select 1 as admin_exists_p
from dual
where exists (select 1
from all_object_party_privilege_map m, users u, acs_magic_objects amo
where m.object_id = amo.object_id
and amo.name = 'security_context_root'
and m.party_id = u.user_id
and m.privilege = 'admin')

'
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Debug: Verifying Installation: Kernel Installed? 0 An Administrator? 0
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Warning: Multiple definition of util_memoize in /var/lib/aolserver/openacs/packages/acs-tcl/tcl/memoize-procs.tcl and /var/lib/aolserver/openacs/packages/acs-bootstrap-installer/bootstrap.tcl
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Bootstrap: Installation is not complete - sourcing the installer.
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Sourcing files for postload...
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Done.
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: Executing initialization code blocks...
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Debug: QD=Postload files to load:
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Debug: QD=Postload files to load:
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: nsmain: AOLserver/4.0.10 running
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: nsmain: security info: uid=1000, euid=1000, gid=1000, egid=1000
[06/Nov/2007:15:54:31][5765.3075034000][-sched-] Notice: sched: starting
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Notice: nssock: listening on 172.16.156.130:8080
[06/Nov/2007:15:54:31][5765.3083658928][-main-] Warning: prebind: closed unused: 172.16.156.130:80 = 3
[06/Nov/2007:15:54:31][5765.3063073680][-driver-] Notice: starting
[06/Nov/2007:15:54:31][5765.3063073680][-driver-] Notice: driver: accepting connections
[06/Nov/2007:15:54:34][5765.3068337040][-conn:dotlearner::0] Debug: NO FULLQUERY FOR dbqd.acs-tcl.tcl.00-database-procs.db_table_exists.table_count --> using default SQL
[06/Nov/2007:15:54:34][5765.3068337040][-conn:dotlearner::0] Notice: Querying '
select count(*) from pg_class
where relname = lower('apm_packages') and
relname !~ '^pg_' and relkind = 'r';'
[06/Nov/2007:15:54:34][5765.3068337040][-conn:dotlearner::0] Notice: dbinit: sql(localhost::dotlearner): '
select count(*) from pg_class
where relname = lower('apm_packages') and
relname !~ '^pg_' and relkind = 'r'
'
[06/Nov/2007:15:54:34][5765.3068337040][-conn:dotlearner::0] Debug: NO FULLQUERY FOR dbqd.acs-tcl.tcl.00-database-procs.db_table_exists.table_count --> using default SQL
[06/Nov/2007:15:54:34][5765.3068337040][-conn:dotlearner::0] Notice: Querying '
select count(*) from pg_class
where relname = lower('acs_objects') and
relname !~ '^pg_' and relkind = 'r';'
[06/Nov/2007:15:54:34][5765.3068337040][-conn:dotlearner::0] Notice: dbinit: sql(localhost::dotlearner): '
select count(*) from pg_class
where relname = lower('acs_objects') and
relname !~ '^pg_' and relkind = 'r'
'
[06/Nov/2007:15:54:34][5765.3068337040][-conn:dotlearner::0] Debug: NO FULLQUERY FOR dbqd.acs-tcl.tcl.00-database-procs.db_table_exists.table_count --> using default SQL
[06/Nov/2007:15:54:34][5765.3068337040][-conn:dotlearner::0] Notice: Querying '
select count(*) from pg_class
where relname = lower('sec_session_properties') and
relname !~ '^pg_' and relkind = 'r';'
[06/Nov/2007:15:54:34][5765.3068337040][-conn:dotlearner::0] Notice: dbinit: sql(localhost::dotlearner): '
select count(*) from pg_class
where relname = lower('sec_session_properties') and
relname !~ '^pg_' and relkind = 'r'
'
[06/Nov/2007:15:54:35][5765.3067284368][-conn:dotlearner::1] Error: Unable to source /var/lib/aolserver/openacs/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.

Collapse
Posted by Arbie Samong on
PS - This is from a VMWare image. It is based from the VDotLRN appliance (www.vmware.com/appliances/directory/332) which works well out of the box, but on outdated versions. I then upgraded PostgreSQL to 8.2 and OpenACS to 5.3.0, leaving AOLServer as it is.