Forum .LRN Q&A: Problems uploading dotlrn

Collapse
Posted by vivian Aguilar on
I was installing all the packages and i have this error, could somebody helpme please.
psql:security-create.sql:82: ERROR:  triggered data
change violation on relation "acs_privilege_hierarchy_index"

    invoked from within
"db_source_sql_file -callback $callback $path/$file_path"
    (procedure "apm_package_install_data_model" line 32)
    invoked from within
"apm_package_install_data_model -callback $callback
-data_model_files $data_model_files $spec_file_path"
    (procedure "apm_package_install" line 19)
    invoked from within
"apm_package_install -install_path $install_path  -callback
apm_ns_write_callback -load_data_model  -data_model_files
$data_model_files $spec_file"
    ("foreach" body line 36)
    invoked from within
"foreach pkg_info $pkg_install_list {
    set spec_file [pkg_info_spec $pkg_info]
    if { [catch {
        array set version [apm_read_package_info_file $spe..."
    ("uplevel" body line 34)
    invoked from within
"uplevel {
          ad_page_contract {

    Installs the packages.

    @author Bryan Quinn (bquinn@arsdigita.com)
    @creation-date Mon Oct  9 00:22:31..."
    (procedure
"code::tcl::/web/openacs-4/packages/acs-admin/www/apm/package..."
line 2)
    invoked from within
"code::tcl::$__adp_stub"
    invoked from within
"if { [file exists $__adp_stub.tcl] } {

      # ensure that data source preparation procedure exists and is
up-to-date
      adp_init tcl $__adp_stub
..."
    ("uplevel" body line 3)
    invoked from within
"uplevel {

    if { [file exists $__adp_stub.tcl] } {

      # ensure that data source preparation procedure exists and is
up-to-date
      adp_init t..."
    (procedure "adp_prepare" line 3)
    invoked from within
"adp_prepare "
    (procedure "template::adp_parse" line 30)
    invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
    (procedure "adp_parse_ad_conn_file" line 7)
    invoked from within
"$handler"
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
        $handler
      } ad_script_abort val {
        # do nothing
      }"
    invoked from within
"rp_serve_concrete_file [ad_conn file]"
    (procedure "rp_serve_abstract_file" line 60)
    invoked from within
"rp_serve_abstract_file "$root/$path""
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
        rp_serve_abstract_file "$root/$path"
        set tcl_url2file([ad_conn url]) [ad_conn file]
        set tcl_url2path_info([ad_conn url]) [ad_conn
path_inf..."
Collapse
Posted by Ben Adida on
this is a PG 7.1 issue. We are developing with 7.2. We are going
to be testing with PG 7.1 and will be making it compatible
shortly.
Collapse
Posted by vivian Aguilar on
I have the 7.1 if i want to install the 7.2 is there special instructions to install it
Collapse
Posted by vivian Aguilar on
i installed pg 7.2 and i got the following:
  <h2>OpenACS Installation: Error</h2>
    <hr>

Thank you for installing the Open Architecture Community System (OpenACS),
a suite of fully-integrated enterprise-class solutions
for collaborative commerce.
This is the OpenACS Installer which performs all the steps necessary
to get the OpenACS Community System running on your server.<p>
Please read the <a href="/doc/release-notes.html">Release Notes</a>
before proceeding to better understand what is contained in this release.

<p>
<p>The following database pools generated errors:
    <ul><li>OpenACS could not allocate a handle from database pool "pool2".</ul><p>
Possible causes might include:<p>
    <ul>
    <li>The database is not running.
    <li>The database driver has not been correctly installed.
    <li>The datasource or database user/password are incorrect.
    <li>You didn't define any database pools.
    </ul><p>

<p><b>The first step involved in setting up your OpenACS
installation is to configure your RDBMS, correctly install a database driver,
and configure AOLserver to use it.  You can download
and install the latest version of the AOLserver Oracle and PostgreSQL drivers
from the <a href="/software.adp">OpenACS.org Software Page</a>.

<p>
Once you're sure everything is installed and configured correctly, restart AOLserver.</b></p>

Collapse
Posted by Dan Chak on
Vivian,

This is an error w/ your postgres setup, not OACS.  Your error means AOLServer can't connect to postgres.  Make sure you've used postgres's 'createdb' command to create the database, and 'createuser' to set up the right user to access the database (usually nsadmin), and that postmaster is running on the port AOLServer is expecting.

--dan

Collapse
Posted by Jim Lynch on
Actually no... you need to get the newer openacs-4.tcl.txt; they have changed the name of the pools. I just ran into that :)
Collapse
Posted by Jim Lynch on
Oops, I'm wrong... the pool names were changed before; please ignore me :)