Forum .LRN Q&A: (file "/var/lib/aolserver/dotlrn/packages/acs-bootstrap-installer/installer/install.tcl" line 36)

Hi, im installing openacs on centos5.1, and i had this problem:

PL/pgSQL function "acs_object__new" line 17 at select into variables
PL/pgSQL function "authority__new" line 38 at assignment

    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 "/var/lib/aolserver/dotlrn/packages/acs-bootstrap-installer/installer/install.tcl" line 36)  <-- i think this is the main problem
    invoked from within
"source $__file "

in the web page I can enter my basic information, then start  creating all the tables and sunddenly y stops..

"..
DROP FUNCTION
CREATE FUNCTION
DROP FUNCTION
acs_privilege__create_privilege
---------------------------------
                              0
(1 fila)
acs_privilege__add_child
--------------------------
                        0
(1 fila)<---- last operation
"

i hope you could help me cause im really lost.. thank you!

What version of PG are you running? If 8.x.x, make sure you set these params in postgresql.conf
add_missing_from = on
default_with_oids = on
regex_flavor = extended
When the installer bombs it gets a bit confused when you run it again, but this message makes it clear:

"Kernel data model already installed"

You need to drop and then create the database again before restarting the install process.

thanks, that solve my problem!... when i did it a the first time i didnt restart the service... so thats the reason it didn't work the first time...
Thank You