Autosys v24 Upgrade failure while configuring database postgressql

Products

• Autosys Workload Automation

Issue/Introduction

While running the install v24, getting below error:

Error: [CAUAJM_E_112627] The provided binary path either does not exist or is not the full

=========================
Event Server Properties
-----------------------

Specify the following information to create the database.

Path to binary(psql) : /usr/bin/psql

Path to library(libpq.so) (Default: /usr/lib64): /usr/lib64/libpq.so

 

===============================================================================
Database Validation
-------------------

Error:
[CAUAJM_E_112627] The provided binary path either does not exist or is not the
full path to the psql binary.

PRESS <ENTER> TO ACCEPT THE FOLLOWING (OK):

Environment

V24

Redhat Linux

Cause

PostgresSQL database residing in another server and when installing autosys, a PostgresSQL client should be present in autosys server before running install.bin

Installer must resolve the libraries and manual login should be successful. 

 

Resolution

To fix the issue, please follow below for client configuration as well as creating symbolic link.

1. I installed PostgresSQL client Only: 

dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm

dnf -qy module disable postgresql

dnf install -y postgresql16

Below files created:

/usr/pgsql-16/lib

 ll
total 8
drwxr-xr-x. 2 root root 4096 May 27 14:37 bin
drwxr-xr-x. 3 root root 4096 May 27 17:22 lib
drwxr-xr-x. 4 root root   82 May 27 14:37 share

2. Created a symbolic link under /usr/pgsql-16/lib:

ln -s libpq.so.5.16 libpq.so

output:

drwxr-xr-x. 2 root root      6 May 13 13:30 bitcode
lrwxrwxrwx. 1 root root     22 May 13 13:30 libecpg_compat.so.3 -> libecpg_compat.so.3.16
-rwxr-xr-x. 1 root root  24720 May 13 13:30 libecpg_compat.so.3.16
lrwxrwxrwx. 1 root root     15 May 13 13:30 libecpg.so -> libecpg.so.6.16
lrwxrwxrwx. 1 root root     15 May 13 13:30 libecpg.so.6 -> libecpg.so.6.16
-rwxr-xr-x. 1 root root  99576 May 13 13:30 libecpg.so.6.16
lrwxrwxrwx. 1 root root     18 May 13 13:30 libpgtypes.so.3 -> libpgtypes.so.3.16
-rwxr-xr-x. 1 root root  78200 May 13 13:30 libpgtypes.so.3.16
lrwxrwxrwx. 1 root root     13 May 27 17:22 libpq.so -> libpq.so.5.16
lrwxrwxrwx. 1 root root     13 May 13 13:30 libpq.so.5 -> libpq.so.5.16
-rwxr-xr-x. 1 root root 358176 May 13 13:30 libpq.so.5.16
-rwxr-xr-x. 1 root root  33048 May 13 13:30 libpqwalreceiver.so

3. Run the installer v24

./install.bin

Additional Information

DB Considerations:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/24-0-00/Before-You-Begin/Database-Considerations-postgresql.html

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/24-0-00/Miscellaneous-Topics/set-up-the-database-manually/run-the-createaedb-script-for-postgres-in-interactive-mode.html