Updating a database user and password using the AAI Config tool locking my database accounts.

Products

• Automic Automation Intelligence

Issue/Introduction

Updating a database user and password using the AAI Config tool locking my database accounts.

Environment

Release : 6.5.1 and earlier

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Resolution

Resolved in AAI 6.5.2

 

Work around to update the username/password if you are not yet on 6.5.2 is below:

1. Shutdown the JAWS Server Application

2. Change path to /JAWS/jboss/standalone/configuration

3. copy jaws-database.xml to jaws-database.xml.orig (or whatever name you need it to be).

4. Edit jaws-database.xml file and enter the NEW_USER NEW_PASSWORD where you see

        <password>XXXXX=</password>

5. Make sure to change the line below to false

Change from:

        <encrypted>true</encrypted>

Change to:

        <encrypted>false</encrypted>

 

5. Save file jaws-database.xml 6. Start the JAWS Server Application.  

Additional Information

6.5.2 Release notes: https://docs.automic.com/documentation/webhelp/english/ALL/components/TERMA_DOCU/6.5.2/AAI%20Guides/Content/Release_Notes/Release_Notes_6_5_2.htm#link12