Forum OpenACS Q&A: Error installing Core Services

Collapse
Posted by Luis Garcia on
I installed OpenACS 4.6. Everything went perfectly up until I got to install the core services. This is what I get:

OpenACS Installation: Installing OpenACS Core Services

Failed to install ACS Core Documents, version 4.5. The following error was generated:

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

Package enabled.

Failed to install Skin, version 4.5. The following error was generated:

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

Package enabled.

Completing Install sequence.

CREATE FUNCTION
CREATE FUNCTION
CREATE TABLE
id
----
(0 rows)
UPDATE 0
DROP FUNCTION
DROP FUNCTION
DROP TABLE

And that's all it does and it stalls or soemthing and nothing else happens. I had installed OpenACS before with this same platform (SuSE 8.0) and all went pretty well. Any ideas?

Collapse
Posted by Bart Teeuwisse on
Luis,

check the aolserver error log for meaningfull error messages. The messages displayed in the browser don't contain all the information.

/Bart

Collapse
Posted by Luis Garcia on
Hi Bart,
these are the errors I found. If you want to see the whole thing I just posted it in another note.

first one:
...[30/Jan/2003:07:18:28][1129.1024][-main-] Notice: Loading packages/acs-tcl/tcl/tcl-documentation-procs.tcl...
[30/Jan/2003:07:18:28][1129.1024][-main-] Warning: apm_boostrap_load_file skipping /home/lgarcia3/web/exchange/packages/acs-tcl/tcl/tcl-documentation-tests.tcl because it isn't either a -procs.tcl or -init.tcl file
[30/Jan/2003:07:18:28][1129.1024][-main-] Notice: Loading packages/acs-tcl/tcl/text-html-procs.tcl...

second:
...[30/Jan/2003:07:18:29][1129.1024][-main-] Notice: Loading packages/acs-tcl/tcl/xml-2-procs.tcl...
[30/Jan/2003:07:18:30][1129.1024][-main-] Notice: Multiple definition of util_memoize in /home/lgarcia3/web/exchange/packages/acs-tcl/tcl/memoize-procs.tcl and /home/lgarcia3/web/exchange/packages/acs-bootstrap-installer/bootstrap.tcl
[30/Jan/2003:07:18:30][1129.1024][-main-] Notice: Installation is not complete - sourcing the installer.
[30/Jan/2003:07:18:30][1129.1024][-main-] Notice: Sourcing files for postload...
[30/Jan/2003:07:18:30][1129.1024][-main-] Notice: Done.
[30/Jan/2003:07:18:30][1129.1024][-main-] Notice: Executing initialization code blocks...

third:
...[30/Jan/2003:07:18:31][1129.8201][-nssock-] Notice: nssock: starting
[30/Jan/2003:07:18:31][1129.8201][-nssock-] Notice: nssock: accepting connections
[30/Jan/2003:07:19:10][1129.5126][-conn2-] Error: tclop: invalid return code from filter proc '': must be filter_ok, filter_return, or filter_break
[30/Jan/2003:07:19:16][1129.6151][-conn3-] Notice: Scanning for new unregistered packages...
[30/Jan/2003:07:19:16][1129.6151][-conn3-] Notice: /home/lgarcia3/web/exchange/packages/acs-admin/acs-admin.info...

fourth:
...[30/Jan/2003:07:19:17][1129.6151][-conn3-] Notice: /home/lgarcia3/web/exchange/packages/wp-slim/wp-slim.info
[30/Jan/2003:07:19:37][1129.6151][-conn3-] Notice: APM/QD = loading up package query files for acs-core-docs
[30/Jan/2003:07:19:37][1129.6151][-conn3-] Notice: APM: Query files for acs-core-docs:
WARNING:  Error occurred while executing PL/pgSQL function apm_package_version__new
WARNING:  line 16 at if
[30/Jan/2003:07:19:37][1129.6151][-conn3-] Error: Ns_PgExec: result status: 7 message: ERROR:  pg_atoi: zero-length string

[30/Jan/2003:07:19:37][1129.6151][-conn3-] Notice: APM/QD = loading up package query files for skin
[30/Jan/2003:07:19:37][1129.6151][-conn3-] Notice: APM: Query files for skin:
WARNING:  Error occurred while executing PL/pgSQL function apm_package_version__new
WARNING:  line 16 at if
[30/Jan/2003:07:19:37][1129.6151][-conn3-] Error: Ns_PgExec: result status: 7 message: ERROR:  pg_atoi: zero-length string

[30/Jan/2003:07:19:38][1129.6151][-conn3-] Error: Error sourcing /home/lgarcia3/web/exchange/packages/acs-bootstrap-installer/installer/packages-install.tcl:
psql:acs-install.sql:247: WARNING:  Error occurred while executing PL/pgSQL function inline_0
psql:acs-install.sql:247: WARNING:  line 15 at assignment
psql:acs-install.sql:247: ERROR:  Function apm_service__new("unknown", "unknown", "unknown", "unknown", timestamptz, "unknown", "unknown", integer) does not exist
    Unable to identify a function that satisfies the given argument types
    You may need to add explicit typecasts
psql:acs-install.sql:254: WARNING:  Error occurred while executing PL/pgSQL function acs_permission__grant_permission
psql:acs-install.sql:254: WARNING:  line 17 at SQL statement
psql:acs-install.sql:254: ERROR:  ExecInsert: Fail to add null value in not null attribute object_id

    invoked from within
"db_source_sql_file -callback apm_ns_write_callback acs-install.sql"
    invoked from within
"if { ![ad_acs_admin_node] } {
    ns_write "  <p><li> Completing Install sequence.<p>
    <blockquote><pre>"
    cd [file join [acs_root_dir] packages..."
    (file "/home/lgarcia3/web/exchange/packages/acs-bootstrap-installer/installer/packages-install.tcl" line 34)
    invoked from within
"source $__file "
[30/Jan/2003:07:19:38][1129.7176][-conn4-] Error: tclop: invalid return code from filter proc '': must be filter_ok, filter_return, or filter_break
[30/Jan/2003:07:19:38][1129.3076][-conn0-] Notice: dbdrv: opening database 'postgres:localhost::exchange'
[30/Jan/2003:07:19:38][1129.3076][-conn0-] Notice: Opening exchange on localhost
[30/Jan/2003:07:19:38][1129.3076][-conn0-] Notice: Ns_PgOpenDb(postgres):  Openned connection to localhost::exchange.