Forum OpenACS Q&A: Psql permission denied - Help Me

Collapse
Posted by Ashwin Kumar on
i've the below problem
every time i create a package i get below error messg
and stops thereitself. Wat 2 do ??
"
OpenACS Installation
Installing the OpenACS kernel data model...
"
i

PLease HELP ME to solve this problem

-----------------------------------------------------------
[root@ffff /]# /usr/local/aolserver40r10/bin/nsd -u jack -g web -ft /var/openacs-5.1.5/etc/config.tcl
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: nsd.tcl: starting to read config file...
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: nsd.tcl: using threadsafe tcl: 1
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: nsd.tcl: finished reading config file.
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: encoding: loaded: utf-8
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: nsmain: AOLserver/4.0.10 starting
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: nsmain: security info: uid=502, euid=502, gid=502, egid=502
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: nsmain: max files: FD_SETSIZE = 1024, rl_cur = 1024, rl_max = 1024
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: adp[openacs-5.1.5]: mapped /*.adp
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: modload: loading '/usr/local/aolserver40r10/bin/nssock.so'
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: modload: loading '/usr/local/aolserver40r10/bin/nslog.so'
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: nslog: opened '/var/openacs-5.1.5/log/openacs-5.1.5.log'
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: modload: loading '/usr/local/aolserver40r10/bin/nssha1.so'
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: modload: loading '/usr/local/aolserver40r10/bin/nscache.so'
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: nscache module version @VER@ server: openacs-5.1.5
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: modload: loading '/usr/local/aolserver40r10/bin/nsdb.so'
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: modload: loading '/usr/local/aolserver40r10/bin/nspostgres.so'
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: PostgreSQL loaded.
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: conf: [ns/server/openacs-5.1.5]enabletclpages = 0
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Loading OpenACS, rooted at /var/openacs-5.1.5
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Sourcing /var/openacs-5.1.5/packages/acs-bootstrap-installer/bootstrap.tcl
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Bootstrap: sourcing /var/openacs-5.1.5/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Bootstrap: sourcing /var/openacs-5.1.5/packages/acs-bootstrap-installer/tcl/10-utilities-procs.tcl
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Bootstrap: sourcing /var/openacs-5.1.5/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Bootstrap: sourcing /var/openacs-5.1.5/packages/acs-bootstrap-installer/tcl/30-apm-load-procs.tcl
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Bootstrap: sourcing /var/openacs-5.1.5/packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Database API: Default database (dbn) is: 'default'
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Database API: Using ALL database pools for OpenACS.
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Database API: The following pools are available for OpenACS: pool2 pool3 pool1
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: dbdrv: opening database 'postgres:::opacs3'
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Opening opacs3 on , port
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to ::opacs3.
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: dbdrv: opening database 'postgres:::opacs3'
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Opening opacs3 on , port
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to ::opacs3.
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: dbdrv: opening database 'postgres:::opacs3'
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Opening opacs3 on , port
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Ns_PgOpenDb(postgres): Openned connection to ::opacs3.
[05/Jul/2005:11:51:29][3666.4142872256][-main-] Notice: Bootstrap: Loading acs-tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/00-database-procs-postgresql.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/00-database-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/10-charset-compat-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/30-xml-utils-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/acs-kernel-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/acs-permissions-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/acs-private-data-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/ad-functional-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/admin-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/adp-parser-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/aolserver-3-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/apm-file-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/apm-install-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/apm-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/apm-xml-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/base64-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/community-core-2-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/community-core-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/defs-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/deprecated-utilities-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/document-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/exception-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/form-processing-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/html-email-procs.tcl
[05/Jul/2005:11:51:30][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/image-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/md5-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/membership-rel-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/memoize-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/mime-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/navigation-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/object-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/object-type-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/openacs-kernel-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/parameter-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/request-processor-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/rollout-email-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/security-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/server-cluster-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/set-operation-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/site-node-apm-integration-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/site-node-object-map-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/site-nodes-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/sql-statement-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/table-display-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/tcl-documentation-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/text-html-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/user-extensions-procs.tcl
[05/Jul/2005:11:51:31][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/utilities-procs.tcl
[05/Jul/2005:11:51:32][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/whos-online-procs.tcl
[05/Jul/2005:11:51:32][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/widgets-procs.tcl
[05/Jul/2005:11:51:32][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/xml-0-sgml-procs.tcl
[05/Jul/2005:11:51:32][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/xml-1-dom-procs.tcl
[05/Jul/2005:11:51:32][3666.4142872256][-main-] Notice: Loading acs-tcl/tcl/xml-2-procs.tcl
[05/Jul/2005:11:51:32][3666.4142872256][-main-] Notice: Bootstrap: Installation is not complete - sourcing the installer.
[05/Jul/2005:11:51:32][3666.4142872256][-main-] Notice: Sourcing files for postload...
[05/Jul/2005:11:51:32][3666.4142872256][-main-] Notice: Done.
[05/Jul/2005:11:51:32][3666.4142872256][-main-] Notice: Executing initialization code blocks...
[05/Jul/2005:11:51:32][3666.4142872256][-main-] Notice: nsmain: AOLserver/4.0.10 running
[05/Jul/2005:11:51:32][3666.4142872256][-main-] Notice: nsmain: security info: uid=502, euid=502, gid=502, egid=502
[05/Jul/2005:11:51:32][3666.4130212784][-sched-] Notice: sched: starting
[05/Jul/2005:11:51:32][3666.4142872256][-main-] Notice: nssock: listening on 127.0.0.1:8045
[05/Jul/2005:11:51:32][3666.4120726448][-driver-] Notice: starting
[05/Jul/2005:11:51:32][3666.4120726448][-driver-] Notice: driver: accepting connections
[05/Jul/2005:11:51:41][3666.4124937136][-conn:openacs-5.1.5::1] Warning: tclfilter: install_handler return invalid result:
[05/Jul/2005:11:51:51][3666.4122831792][-conn:openacs-5.1.5::3] Notice:
DAVEB pghost = '' pgport = '' pguser = '-U opacs3'

[05/Jul/2005:11:51:51][3666.4122831792][-conn:openacs-5.1.5::3] Error: Error sourcing /var/openacs-5.1.5/packages/acs-bootstrap-installer/installer/install.tcl:
couldn't execute "psql": permission denied
while executing
"open "|[file join [db_get_pgbin] psql] $pghost $pgport $pguser -f $file_name [db_get_database] $pgpass" "r""
("postgresql" arm line 37)
invoked from within
"switch $driverkey {

oracle {
global env
set user_pass [db_get_sql_user -dbn $dbn]
cd [file dirname $file]..."
(procedure "db_source_sql_file" line 6)
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/openacs-5.1.5/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
invoked from within
"source $__file "
[05/Jul/2005:11:51:51][3666.4121779120][-conn:openacs-5.1.5::4] Warning: tclfilter: install_handler return invalid result:

Collapse
Posted by Håkan Ståby on
Have you tried starting up with nsd-postgres instead, like this?

/usr/local/aolserver40r10/bin/nsd-postgres -u jack -g web -ft /var/openacs-5.1.5/etc/config.tcl

Could also be a missing username in the config.tcl file or a missing postgres environment variable.

Collapse
Posted by Brian Fenton on
Hello Ashwin,
the error is saying you don't have permission to run the "psql" command. You need to check the permissions on that executable. Also make sure you're running AOLserver as the correct user.

Brian