Forum OpenACS Q&A: Install Error (core services) on Free BSD

Collapse
1: Install Error (core services) on Free BSD
Posted by Arthur Pinkerton on 11/30/01 05:38 AM
After installing openacs using Gilbert's instructions http://www.orchardlabs.com/ freebsd/ I get to this point: Then when I click next i get this error and unable to continue.Please Help

OpenACS Installation: Installing OpenACS Core Services

OpenACS Installation: Installing OpenACS Core Services

  • Completing Install sequence.

    CREATE
 id 
----
(0 rows)
UPDATE 0
DROP
    • Collapse
    2: Response to Install Error (core services) on Free BSD (response to 1)
    Posted by Arthur Pinkerton on 11/30/01 06:05 AM
    This is what is at the end of the openacs-4-error.log

    [30/Nov/2001:04:36:26][4448.138384384][-conn1-] Error: Error sourcing
    /web/openacs-4/packages/acs-bootstrap-installer/installer/packages-install.tcl:
    psql:acs-install.sql:208: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
    Pre-installed languages are SQL, C, and internal.
    Additional languages may be installed using 'createlang'.
    psql:acs-install.sql:240: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
    Pre-installed languages are SQL, C, and internal.
    Additional languages may be installed using 'createlang'.
    psql:acs-install.sql:247: ERROR: Function 'inline_0()' 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: ERROR: Function 'inline_1()' 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:256: ERROR: pg_func_ownercheck: function 'inline_0()' does not exist
    psql:acs-install.sql:257: ERROR: pg_func_ownercheck: function 'inline_1()' does not exist
    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 "/web/openacs-4/packages/acs-bootstrap-installer/installer/packages-install.tcl" line 34)
    invoked from within
    "source $__file "

    Collapse
    3: Response to Install Error (core services) on Free BSD (response to 1)
    Posted by Vinod Kurup on 11/30/01 06:30 AM
    Hi Arthur,

    It looks like the language 'plpgsql' hasn't been installed into your postgresql instance.

    Did you do step 22 of Gilbert's postgresql installation instructions?

    /usr/local/bin/createlang plpgsql template1

    If so, were there any errors? You can do createlang -l template1 to see which languages have been successfully installed.

    Collapse
    4: Response to Install Error (core services) on Free BSD (response to 1)
    Posted by S. Y. on 11/30/01 07:23 AM

    (sigh) I really wish bboard could handle dangling HTML tags. Just in case it's not fixed yet...

    Any better?

    Collapse
    5: Response to Install Error (core services) on Free BSD (response to 1)
    Posted by S. Y. on 11/30/01 07:25 AM

    I guess not.