Forum OpenACS Development: no psql command on aolserver

Collapse
Posted by Iuri Sampaio on
Hi all,

I got the error bellow from a fresh installation of OACS 5.5.

It's strange because i do have psql commands working fine in the shell prompt. Plus i have edited ~/.profile with the correct lines in order to export pgsql vars and libs to the user environment

does anyone have an idea what it could be?

[16/Mar/2009:23:47:28][2038.3062299568][-conn:openacs::1] Error: Error sourcing /web/openacs/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 58)
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 "/web/openacs/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
invoked from within
"source $__file "

Collapse
Posted by Dave Bauer on
psql is not in the path of the environment where AOLserver is running.

See #5 under Install AOLserver, Add database specific wrapper script.

Collapse
Posted by Iuri Sampaio on
Right there!
Thanks Dave. the issue is solved.

I always forget to edit the file "etc/daemontools/run".
it comes from default from HEAD with the line

exec /usr/local/aolserver/bin/nsd -it /web/openacs /etc/config.tcl -u openacs -g web

One thing, we could do to get rid of this problem is to change the default file "etc/daemontools/run" on HEAD line 12 to

exec /usr/local/aolserver/bin/nsd-postgres -it /web/openacs /etc/config.tcl -u openacs -g web

cheers,

Collapse
Posted by Dave Bauer on
This assumed the default install instructions. Installing aolserver itself doesn't create the nsd-postgres script.

So what is the best solution here? How does aolserver start with the new debian based packages?