Forum OpenACS Development: couldn't execute "psql": no such file or directory

Hi there,

in attempt to have a fresh installation of oacs 5.4,
i have got the error message bellow. I debugged the file
/usr/local/aolserver/servers/projop/packages/acs-bootstrap-installer/installer/install.tcl
but i haven't found any reference to psql

does anyone already got into this issue?

[02/Jul/2008:09:17:34][4065.3083651296][-main-] Notice: nssock: listening on 10.5.100.50:8090
[02/Jul/2008:09:17:34][4065.3057777584][-driver-] Notice: starting
[02/Jul/2008:09:17:34][4065.3057777584][-driver-] Notice: driver: accepting connections
[02/Jul/2008:09:17:52][4065.3062209456][-conn:projop::1] Notice:
DAVEB pghost = '' pgport = '' pguser = '-U projop'

[02/Jul/2008:09:17:52][4065.3062209456][-conn:projop::1] Error: Error sourcing /usr/local/aolserver/servers/projop/packages/acs-bootstrap-installer/installer/install.tcl:
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 59)
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 "/usr/local/aolserver/servers/projop/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
invoked from within
"source $__file "

Collapse
Posted by Dave Bauer on
You'll need to set the path when starting aolserver so psql is included in the path.

See nsd-postgres script.
https://openacs.org/api-doc/content-page-view?path=packages%2facs%2dcore%2ddocs%2fwww%2ffiles%2fnsd%2dpostgres%2etxt&version%5fid=358355&source_p=1

Collapse
Posted by Iuri Sampaio on
Many Thanks Dave,

I am using daemontools I and got a bit confused here starting aolserver directly with aolserver/bin/nsd instead of nsd-postgres

:)

Collapse
Posted by Don Baccus on
And it appears that DAVEB needs to remove his NOTICE message from the install file?
Collapse
Posted by Don Baccus on
Actually, I just got rid of it on HEAD, too late for 5.4.2...