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

1: Installation problems OpenACS 5.2 on ubuntu

Posted by robert gilaard on 04/09/07 08:47 PM

Hi folks,

I managed to install every required package and when I look into my logfile I see this:

psql:groups-body-create.sql:350: WARNING: changing return type of function composition_rels_del_tr from "opaque" to "trigger"
psql:site-nodes-create.sql:99: WARNING: changing return type of function site_node_insert_tr from "opaque" to "trigger"
psql:site-nodes-create.sql:159: WARNING: changing return type of function site_node_update_tr from "opaque" to "trigger"
psql:apm-create.sql:2376: ERROR: syntax error at or near "initial_install_p" at character 350
QUERY: UPDATE apm_package_types SET pretty_name = coalesce( $1 , pretty_name), pretty_plural = coalesce( $2 , pretty_plural), package_uri = coalesce( $3 , package_uri), package_type = coalesce( $4 , package_type), spec_file_path = coalesce( $5 , spec_file_path), spec_file_mtime = coalesce( $6 , spec_file_mtime), singleton_p = coalesce( $7 , singleton_p) initial_install_p = coalesce( $8 , initial_install_p) where package_key = $9
CONTEXT: SQL statement in PL/PgSQL function "apm_package_type__update_type" near line 21
psql:apm-create.sql:2376: LINE 1: ...mtime), singleton_p = coalesce( $7 , singleton_p) initial_in...
psql:apm-create.sql:2376: ^
CONTEXT: SQL statement "SELECT acs_object_id_seq.nextval from dual"
PL/pgSQL function "acs_object__new" line 17 at select into variables
PL/pgSQL function "acs_rel__new" line 13 at assignment
PL/pgSQL function "membership_rel__new" line 11 at assignment
SQL statement "SELECT membership_rel__new ( null, 'membership_rel', acs__magic_object_id('the_public'), acs__magic_object_id('unregistered_visitor'), 'approved', null, null)"
PL/pgSQL function "inline_2" line 54 at perform

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 "/usr/lib/aolserver4/servers/openacs-5-2/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
invoked from within
"source $__file "
[09/Apr/2007:20:34:28][4719.3065174960][-conn:openacs-5-2::3] Error: Unable to source /usr/lib/aolserver4/servers/openacs-5-2/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.
[09/Apr/2007:20:34:40][4719.3064122288][-conn:openacs-5-2::4] Error: Unable to source /usr/lib/aolserver4/servers/openacs-5-2/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.
[09/Apr/2007:20:34:48][4719.3068332976][-conn:openacs-5-2::0] Error: Unable to source /usr/lib/aolserver4/servers/openacs-5-2/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.
[09/Apr/2007:20:35:04][4719.3067280304][-conn:openacs-5-2::1] Error: Unable to source /usr/lib/aolserver4/servers/openacs-5-2/packages/acs-bootstrap-installer/installer/openacs.tcl: file does not exist.
[09/Apr/2007:20:35:11][4719.3066227632][-conn:openacs-5-2::2] Error: Unable to source /usr/lib/aolserver4/servers/openacs-5-2/packages/acs-bootstrap-installer/installer/openacs-5-2.tcl: file does not exist.
[09/Apr/2007:20:35:16][4719.3065174960][-conn:openacs-5-2::3] Warning: tclfilter: install_handler return invalid result:
[09/Apr/2007:20:35:22][4719.3068332976][-conn:openacs-5-2::0] Error: Unable to source /usr/lib/aolserver4/servers/openacs-5-2/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.
[09/Apr/2007:20:35:51][4719.3066227632][-conn:openacs-5-2::2] Error: Unable to source /usr/lib/aolserver4/servers/openacs-5-2/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.
[09/Apr/2007:20:35:57][4719.3065174960][-conn:openacs-5-2::3] Error: Unable to source /usr/lib/aolserver4/servers/openacs-5-2/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.
[09/Apr/2007:20:36:00][4719.3064122288][-conn:openacs-5-2::4] Error: Unable to source /usr/lib/aolserver4/servers/openacs-5-2/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.
[09/Apr/2007:20:36:02][4719.3068332976][-conn:openacs-5-2::0] Error: Unable to source /usr/lib/aolserver4/servers/openacs-5-2/packages/acs-bootstrap-installer/installer/packages-install.tcl: file does not exist.

How can I fix this?

Brgds
Robert

2: Re: Installation problems OpenACS 5.2 on ubuntu (response to 1)

Posted by robert gilaard on 04/09/07 08:50 PM

And after I go the the site: localhost:8000, I see a message that my data model was installed ok, and I needed to click on next.

I arrive at this page: http://localhost:8000/packages-install?

But nothing happens.

I don't know where to look because I'm new to openACS.

3: Re: Installation problems OpenACS 5.2 on ubuntu (response to 1)

Posted by Gustaf Neumann on 04/10/07 09:08 AM

what postgres version are you using? have you seen:
http://openacs.org/xowiki/How_to_install_in_Postgres_8.x ?

4: Re: Installation problems OpenACS 5.2 on ubuntu (response to 3)

Posted by Arbie Samong on 10/19/07 04:59 PM

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

5: Re: Installation problems OpenACS 5.2 on ubuntu (response to 1)

Posted by Dave Bauer on 10/19/07 06:54 PM

If you have PostgreSQL 8.x you need to set the compatibility flags in postgresql.conf.

http://openacs.org/xowiki/How_to_install_in_Postgres_8.x

After you make sure you have those settings correct, restart PostgreSQL and then try to install again after removing and recreating the datbase.

If you still have a problem go back in the error log to the first error that occurs during the install and post that to the forums.

6: Re: Installation problems OpenACS 5.2 on ubuntu (response to 4)

Posted by Arbie Samong on 11/06/07 04:07 PM

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.

7: Re: Installation problems OpenACS 5.2 on ubuntu (response to 4)

Posted by Arbie Samong on 11/06/07 04:11 PM

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.

8: Re: Installation problems OpenACS 5.2 on ubuntu (response to 1)

Posted by Dave Bauer on 11/06/07 04:29 PM

Please do

dropdb "openacs"
createdb "openacs"
where "openacs" is the name of the database you are using to install openacs.

if the data model installed page comes up it means that you have a preexisting failed install and you need to start over.

9: Re: Installation problems OpenACS 5.2 on ubuntu (response to 8)

Posted by Arbie Samong on 11/08/07 07:57 PM

FINALLY... I saw the light in the dark tunnel

What fixed this was the permissions on the file nsd-postgres. What I did was:
a. Make sure nsd-postgres is also owned by the user running the server. > chown $user nsd-postgres
b. Make sure that user is in a group with the root. I don't think this is important but in my setup the server startup script is owned by $user already. > chgrp $user nsd-postgres
c. Make sure nsd-postgres has read-write-execute (770) permission. > chown 770 nsd-postgres
This has been mentioned in a different post but I forgot where it was. That said post spoke of doing a $>chmod 700 on nsd-postgres, which wasn't enough for me. I'm guessing that it's just my user setup.

I ran into other issues before, but this case was encountered in my try with a vdotlrn appliance for vmware (contains PostgreSQL 7.4 and a OpenACS 5.0 I think). I upgraded those two to make the image at least in a recent version (I got an openacs folder from my colleague). The server is running in Ubuntu Breezy.

My first try in Ubuntu was done in Feisty, which encountered similar issues yelling a similar error.log output. That Feisty install was done by getting PostgreSQL and AOLServer on Feisty repositories (default sources.list), while OpenACS is in 5.3.0. I'm guessing that trying an install on Feisty will likely encounter same issues, and, hence, worthy of the same solution.

Now I can get some good sleep

10: Re: Installation problems OpenACS 5.2 on ubuntu (response to 9)

Posted by Arbie Samong on 11/08/07 07:58 PM

PS - I know it is a success because I'm viewing the Site-Wide Administration page now.

11: Re: Res: Installation problems OpenACS 5.2 on ubuntu (response to 1)

Posted by David Arroyo Menéndez on 12/25/07 09:52 PM

I've updated the quicksheet to install openacs on ubuntu to avoid this and another problems.

Merry Christmas.