Jameela_Hudson

Tech Tip: Updating/Modifying the Database Passwords for CA Workload Automation AE

Discussion created by Jameela_Hudson Employee on Nov 3, 2015

Below are the steps to update the database user passwords for Embedded Entitlements Manager (EEM), Workload Automation AE (Autosys), and Workload Control Center (WCC).

 

NOTE: The steps provided are under the assumption that users 'aedbadmin' and 'autosys' are being used strictly with Autosys and are in no way associated with WCC.

 

------------------------------------------------

Changing the password for the EEM Database User

------------------------------------------------

Because EEM governs its own database internally, there is nothing you need to do with this application.

 

------------------------------------------------

Changing the password for 'aedbadmin'

------------------------------------------------

After your DBA has updated the password for 'aedbadmin', there is nothing else you need to do with this user.

 

------------------------------------------------

Changing the password for 'autosys' - SINGLE SERVER MODE

------------------------------------------------

1. Stop the scheduler

2. From a command prompt, run this command: autosys_secure

3. Select [3] Change database password.

  A. Enter the current password

  B. Enter the new password

  C. Confirm the new password

4. Start the scheduler

5. Using the chk_auto_up command, confirm you can connect to the database

NOTE: The DBAccess parameter (DBAccess=autosys/ABCDEF0123456789) in your config.$AUTOSERV file (or config.%AUTOSERV% file) will be automatically updated with the new encrypted password.

 

------------------------------------------------

Changing the password for 'autosys' - DUAL SERVER MODE

------------------------------------------------

1. Stop the primary and shadow schedulers

2. From a command prompt on the primary scheduler, run this command: autosys_secure

3. Select [3] Change database password.

  A. Enter the current password

  B. Enter the new password

  C. Confirm the new password

4. Start the primary scheduler - using the chk_auto_up command, confirm you can connect to the database

5. Start the shadow scheduler

NOTE: The DBAccess parameter (DBAccess=autosys/ABCDEF0123456789) in your config.$AUTOSERV file (or config.%AUTOSERV% file) will be automatically updated with the new encrypted password.


------------------------------------------------

Changing the password for the WCC Database User

------------------------------------------------

1. From a command prompt, navigate to your $CA_WCC_INSTALL_LOCATION/bin directory (or %CA_WCC_INSTALL_LOCATION%\bin directory)

2. (Linux) Run this command: ./wcc_config.sh -u user_name -p password --dbuser db_user --dbpassword db_password

    (Windows) Run this command: wcc_config -u user_name -p password --dbuser db_user --dbpassword db_password

 

user_name: a user who can log into WCC

password: the password for the user who can log into WCC

db_user: the name of the WCC DB user

db_password: the password for the WCC DB user

 

3. (Linux) Run this command: ./wcc_config.sh -u user_name -p password --dbuser db_user --dbpassword db_password --dbapp REPORTING

    (Windows) Run this command: wcc_config -u user_name -p password --dbuser db_user --dbpassword db_password --dbapp REPORTING


NOTE: You must run this command twice: once without the --dbapp parameter and again with the --dbapp parameter.

Outcomes