Decrypting database passwords (Windows)

About this task

To decrypt the database password:

Procedure

  1. Stop Sterling B2B Integrator.
  2. Complete the following steps:
    1. Click Start.
    2. Right-click Command Prompt and select Run as administrator. The Administrator: Command Prompt dialog box is displayed.
    3. Navigate to \<install_dir>\properties.
  3. Open the sandbox.cfg file.
  4. Copy encrypted password from the database_PASS property.

    Use the text that appears after the database_PASS= text. For example, if database_PASS= OBSCURED:123ABCxyz321, you would copy the text OBSCURED:123ABCxyz321. (OBSCURED is the encryption method for the password.)

  5. Complete the following steps:
    1. Click Start.
    2. Right-click Command Prompt and select Run as administrator. The Administrator: Command Prompt dialog box is displayed.
    3. Navigate to \<install_dir>\bin.
  6. Enter decrypt_string.cmd encrypted _password.

    For encrypted_password, use the text that you copied in Step 4.

    You are prompted for the system passphrase.

    Your decrypted password appears.

  7. Complete the following steps:
    1. Click Start.
    2. Right-click Command Prompt and select Run as administrator. The Administrator: Command Prompt dialog box is displayed.
    3. Navigate to \<install_dir>\properties.
  8. Edit the sandbox.cfg file to replace the encrypted password with the password that was returned in Step 6.
  9. You need to decrypt the entries for the YANTRA_DB_PASS and DB_PASS properties. Repeat Steps 4 to 8 to decrypt these entries.
    You should also decrypt any passwords present in the property files. Encrypted passwords typically reside in the following property files:
    • sandbox.cfg
    • apservsetup
    • jdbc.properties/.in
    • customer_overrides.properties/.in
  10. Complete the following steps:
    1. Click Start.
    2. Right-click Command Prompt and select Run as administrator. The Administrator: Command Prompt dialog box is displayed.
    3. Navigate to \<install_dir>\bin.
  11. Enter setupfiles.cmd.
  12. Enter deployer.cmd.
  13. Enter startWindowsService.cmd to start Sterling B2B Integrator.