I need a Broadcom Techdoc for Autosys database password change procedure

Products

• CA Workload Automation AE

Issue/Introduction

I found this KB https://knowledge.broadcom.com/external/article/9635/how-to-change-autosys-db-loginuser-passw.html but it is very high level.

I want a techdoc I can save as PDF locally that goes into detail on the database password change procedure for Autosys R11.3.7. Also, The KB barely mentions how to manage the password update in autosys_secure.

Is there a techdoc that has detailed A to Z instructions for updating the password everywhere in Autosys it needs to be updated after we update the password in our SQL database?

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

The following steps are from https://knowledge.broadcom.com/external/article?articleId=18986 with an additional note.

Description:

The document is to help find out if the database password is changed. Also gives the steps to update the encrypted password in the configuration file.

Solution:

Environment Autosys 11.3.5
Problem        The scheduler and the application server fails to start with the following error messages

 

   CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <232>   
   CAUAJM_E_18402 ORA-01017: invalid username/password; logon denied 

 

Solution

You can check if the encrypted password in the config file is the same as the current password of the autosys user in database

$AUTOUSER/config.$AUTOSERV

 

#+---------
#
# Keyword: DBAccess=username/password
#
# Defines  the user name and password (in encrypted format) used by
# the scheduler and  application server to connect to the database.
# The database user name  and  password is  defined  during  the CA
# Workload Automation AE installation.
#
DBAccess=autosys/2B4A60C0D02773E4E3FF7452033F9D3C

 

We can find the encrypted password of the current autosys user by using the autosys_secure command

$ autosys_secure 

CA WAAE Security Utility 

Please select from the following options:

 

[1] Activate CA EEM instance security.
[2] Manage EDIT/EXEC superusers.
[3] Change database password.
[4] Change remote authentication method.
[5] Manage [email protected] or [email protected] users.
[6] Get encrypted password.
[0] Exit CA WAAE Security Utility.
>  6
 
Get encrypted password
 
Please select from the following options:
[1] Encrypt password for instance configuration (using AES).
[2] Encrypt password for legacy agents and adapters (using DES).
[9] Exit from "Get encrypted password" menu.
[0] Exit CA WAAE Security Utility.
>  1
 
Enter password:  ******
 
Enter confirmation password: ******
 
CAUAJM_I_60062 Password= 2B4A60C0D02773E4E3FF7452033F9D3C

 

If these passwords do not match then copy this encrypted password to the $AUTOUSER/config.$AUTOSERV file and restart the CA WAAE services

Note:

After updating the password in the configuration file and restarting WAAE services, to update the encrypted password for autosys in AEDB table, use autosys_secure as follows:

$ autosys_secure

CA WAAE Security Utility

Please select from the following options:
[1] Revert to NATIVE instance security.
[2] Manage CA EEM security settings.
[3] Change database password.
[4] Change remote authentication method.
[5] Manage users.
[6] Get encrypted password.
[0] Exit CA WAAE Security Utility.
>  3

Enter current password:

Enter new password:

Enter new password again:

CAUAJM_I_60059 Password change successful.

In the above step, enter the same password for current and new password.