Symptoms
Task "Install oam-aps to MN" fail with error:
Failed to process executeInstallSequence at xpath tail HOOKS/HOOK[@when='finally' and @install='yes']/child::* for pkgId: 9408, ex message is: Failed to process EXEC command for package oam-backend of type other having pkgId: 9408, exception message: Invalid exitCode, HCL out: , HCL err: , HCL exit code: 1 input xml: <EXEC cmd="/usr/local/bin/oa-migrator" group="root" user="root" valid_exit_codes="0"> <ARG value="init-db"/> </EXEC>
OA migrator log
/opt/oa-migrator/logs/debug.log
contains the error:[2018-01-09 12:51:19,951] 139680786282304 [DBG] Command stderr: createuser: could not connect to database postgres: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? [2018-01-09 12:51:19,951] 139680786282304 [DBG] Command exit code: 1 [2018-01-09 12:51:19,951] 139680786282304 [DBG] Context: Traceback (most recent call last): File "/opt/oa-migrator/lib/python2.7/site-packages/migrator/core/cli/commands/implementation_base.py", line 22, in new_func func(self, options) File "/opt/oa-migrator/lib/python2.7/site-packages/migrator/core/cli/commands/implementation/init_db.py", line 9, in run init_db() File "/opt/oa-migrator/lib/python2.7/site-packages/migrator/core/utils/init_db.py", line 41, in init_db error_message='role "{username}" already exists'.format(username=username) File "/opt/oa-migrator/lib/python2.7/site-packages/migrator/core/utils/init_db.py", line 86, in _run_local_command stderr_str MigrationError: Command 'su - postgres -c 'createuser -S -d -R oam'' executed locally failed with exit code 1. stdout: stderr:createuser: could not connect to database postgres: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Cause
Software-related issue #OAM-3065.
OA DB is running on separate node. OA migrator tries to create PostgreSQL DB user but corresponding scripts does not specify the IP address DB resides. Without hostname specified Migrator attempts to create DB user on MN which does not have PostgreSQL service running.
Resolution
Contact your Technical Account Manager or PTA team (pta@odin.com) to trace the status of #OAM-3065.
In case of PGHA is disabled according to Disabling PGHA Cluster - contact Odin Technical Support to apply workaround.