search cancel

CDA/AWA Oneinstaller issue: Postgresql permission denied

book

Article ID: 113575

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

The OneInstaller is unable to continue with the installation due to an error.

The error displayed looks similar to:
SEVERE: Connection error: 
org.postgresql.util.PSQLException: Connection to localhost:5434 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

In reviewing the install.log above the error, you see similar to:
INFO: STDERR:
initdb: could not create directory "D:/Automic/External.Resources/postgresql/data": Permission denied

SEVERE: Could not initialize Analytics Datastore
com.automic.installer.api.common.InstallerException: Could not initialize Analytics Datastore

Or, in linux:
The actual issue was caused by:
INFO: ProcessRunner.run: bash /opt/Automic/Automation.Platform/Analytics/datastore/pg_init.sh /opt/Automic/External.Resources/postgresql postgres
Feb 18, 2020 10:29:28 AM com.automic.installer.api.common.utils.ProcessRunner run
INFO: The process returned: 126; Process command was: bash /opt/Automic/Automation.Platform/Analytics/datastore/pg_init.sh /opt/Automic/External.Resources/postgresql postgres
Feb 18, 2020 10:29:28 AM com.automic.installer.api.common.utils.ConsoleCollector close
INFO: STDOUT:
Initialize automic datastore now.

Feb 18, 2020 10:29:28 AM com.automic.installer.api.common.utils.ConsoleCollector close
INFO: STDERR:
bash: /opt/Automic/External.Resources/postgresql/pgsql/bin/initdb: Permission denied

Resolution

1.  Delete any old OneInstaller installation files.
2. Manually create the target Automic folder (i.e. D:\Automic or /opt/Automic/) and grant everyone full control/755 permissions
Tip:  Remove read-only permissions to the Automic folder and add user administrator owner full permissions. 
3. Run the CDA OneInstaller.