Forum OpenACS Q&A: static-pages doesn't load data model

Collapse
Posted by Rafael Calvo on
I was going to report it in the SDM, but since I downloaded the 4.5 version and got the same error, I wonder what is wrong.
on PG 7.2, AOLserver 3.4.2, when loading the data model I get:
couldn't execute "psql": no such file or directory
    while executing
"open "|[file join [db_get_pgbin] psql] $pghost $pgport $pguser -f
$file_name [db_get_database] $pgpass" "r""
    (procedure "db_source_sql_file" line 38)
    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 {
I do not understand the error.
Collapse
Posted by Jeff Davis on
This means the server process could not find the psql executable.
Either make sure it is on the PATH or change db_get_pgbin
so it returns the explicit path to the psql executable.
Collapse
Posted by Rafael Calvo on
Jeff,

The system is running, so it is already using PG.

Since I have PG7.1 for and older site, and I am now using 7.2 to test ACS 4.6, I put PG7.2 in ad different port.

I set up the nsd-conf files

set pgport              5433
ns_param  pgport            $pgport

and

ns_param  datasource        localhost:${pgport}:${db_name}

for each of the DB pools.

Could it be that there is a call in the RP or somewhere else? that doesn't use the pgport parameter?

Collapse
Posted by Tilmann Singer on
Add this parameter setting to your database driver configuration if it's not in the PATH:

ns_param pgbin /path/to/your/new/psql

Collapse
Posted by Rafael Calvo on
Thanks