db_password environment variable shows only the first 100 characters of a password
search cancel

db_password environment variable shows only the first 100 characters of a password

book

Article ID: 383661

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

The $db_password or %db_password%(Windows) environment variable can be used to pass the Job's Primary Login password value to your script or however else a environment variables are used.

The Primary Login is defined within the Job's Execution Options window.

However, if the Login password exceeds 100 characters, the db_password environment variable resolves to only the first 100 characters.

Environment

Applications Manager 9.x

Cause

When saving a Login object with a password greater then 100 characters, only the first 100 characters is written to the database. This is a client specific issue.

Resolution

This issue is currently being investigated to determine if it is a bug.

If found a bug, a fix will be included in a future version of Applications Manager, and this article will be updated.

Workaround:

  1. Manually update password while changing the encrypted flag to N:

    SQL> update so_ids set so_passwd='<your password>', so_encrypted='N' where so_login='<your login>';
    SQL> commit;

  2. Run the below awexe command to manually re-encrypt the password:

    awexe id_recrypt