Forum OpenACS Q&A: Install ACS 4.6 problem

Collapse
1: Install ACS 4.6 problem
Posted by Nagita Karunaratne on 02/14/03 10:26 AM
I followed the instructions for installing Postgres 7.3.2, aol server 3.3+ad13, and ACS 4.6
When I started aolserver and started the OPenACS Installer, it did not completely render the first page. Part if the error.log file (~/web/birdnotes/log/error.log) at the point where aolserver is accepting connections and where errors start is below.

Can anyone give me a hint?

---------------- error.log START -----------------------
... [snip] ...
[14/Feb/2003:01:16:21][2147.8192][-main-] Notice: sched: idle
[14/Feb/2003:01:16:21][2147.8192][-main-] Notice: nssock: listening on 127.0.0.1:8000
[14/Feb/2003:01:16:21][2147.65545][-nssock-] Notice: nssock: starting
[14/Feb/2003:01:16:21][2147.65545][-nssock-] Notice: nssock: accepting connections

[14/Feb/2003:01:17:53][2147.24580][-conn0-] Error: Error sourcing /home/karunnt/web/birdnotes/packages/acs-bootstrap-installer/installer/install-data-model.tcl:
psql:acs-objects-create.sql:156: WARNING:  Error occurred while executing PL/pgSQL function int_to_tree_key
psql:acs-objects-create.sql:156: WARNING:  line 20 at return
psql:acs-objects-create.sql:156: ERROR:  Function bitfromint4(integer) does not exist
    Unable to identify a function that satisfies the given argument types
    You may need to add explicit typecasts
psql:acs-relationships-create.sql:299: WARNING:  Error occurred while executing PL/pgSQL function int_to_tree_key
psql:acs-relationships-create.sql:299: WARNING:  line 20 at return
psql:acs-relationships-create.sql:299: ERROR:  Function bitfromint4(integer) does not exist
    Unable to identify a function that satisfies the given argument types
    You may need to add explicit typecasts
psql:community-core-create.sql:237: WARNING:  Error occurred while executing PL/pgSQL function int_to_tree_key
psql:community-core-create.sql:237: WARNING:  line 20 at return
psql:community-core-create.sql:237: ERROR:  Function bitfromint4(integer) does not exist
    Unable to identify a function that satisfies the given argument types
    You may need to add explicit typecasts
psql:community-core-create.sql:576: ERROR:  acs_obj_type_tbls_obj_type_fk referential integrity violation - key referenced from acs_object_type_tables not found in acs_object_types
psql:groups-create.sql:125: WARNING:  Error occurred while executing PL/pgSQL function int_to_tree_key
psql:groups-create.sql:125: WARNING:  line 20 at return
psql:groups-create.sql:125: ERROR:  Function bitfromint4(integer) does not exist
    Unable to identify a function that satisfies the given argument types
    You may need to add explicit typecasts
... [snip] ...
---------------- END -----------------------------------

Collapse
2: Re: Install ACS 4.6 problem (response to 1)
Posted by Cathy Sarisky on 02/14/03 08:59 PM
You need Postgres 7.2.3.  Try that - should fix you right up. :)
Collapse
3: Re: Install ACS 4.6 problem (response to 2)
Posted by Bart Teeuwisse on 02/14/03 09:32 PM
Cathy,

the current CVS version of OpenACS core does not require PG 7.2.x It also works with PG 7.3.x. However not all packages besides the core support PG 7.3.x yet.

Nagita, it appears that you installed from the OpenACS 4.6 tarball. In that case you will have to use PG 7.2.x as Cathy said.

/Bart