Track-It! 11.4 SP1 - Change Database Password function not writing a matching encrypted password to all configuration files.

Version 2
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Track-It!


    COMPONENT:

    Track-It!


    APPLIES TO:

    Track-It! 11.4 SP1 (11.4.1.558)



    PROBLEM:

    In Tools > Administration Console > Configuration > Change Database Password, Administrators change the SQL SIDs that components of Track-It! use to access the database.

    On completion of this operation, the encrypted hash for the new password should appear in both of these files;

    C:\Program Files (x86)\BMC Software\Track-It!\Track-It! Server\trackit.cfg

    and

    C:\Program Files (x86)\BMC Software\Track-It!\Track-It! Services\ConfigurationData\trackit.core.dataaccess.xml

    Technical Support has had reports of instances where either of these files are not being written to with the new encrypted password following this operation.

    Two files should be changed after using Tools > Administration Console > Configuration > Change Database Password, the trackit.cfg file and the trackit.core.dataaccess.xml file. Once the database password has been changed, the encrypted values in these two files do not match.

    Before

    trackit.cfg

    TRACKIT_USER=TRACKIT80_9
    TRACKIT_PASSWORD=t+Bf9rLsBBbZUAFJaDFirw==

    trackit.core.dataaccess.xml

    <Search server="TI20" database="TI21_Trackit_Data" user="TrackIt80_9" password="t+Bf9rLsBBbZUAFJaDFirw==" />


    After

    trackit.cfg

    TRACKIT_USER=TRACKIT80_9
    TRACKIT_PASSWORD=8vFrM6+yV2sj/ENHPSsWWA==

    trackit.core.dataaccess.xml

    <Search server="TI20" database="TI21_Trackit_Data" user="TrackIt80_9" password="B844oSK/FG9ccBeTfR8PmQ==">
    </Search>

    Both of the encrypted passwords should match in both files.

    Steps to reproduce

    1.    Login to the Technician Client
    2.    Open the Administration Console->Configuration-> Change Database password
    3.    Change the password.
    4.    Check the trackit.cfg and the trackit.core.dataaccess.xml file. They both with have different encrypted values for the Trackit80_X account
    5.    We also see that Audit Now fails and the Support Center crashes.
     


    CAUSE:

    This is a known issue which has not yet been rectified in the current version of the product.


    SOLUTION:

    Workaround:

    To resolve the issue, copy the encrypted password from the trackit.core.dataaccess.xml file to the trackit.cfg file, so that they match. Be sure to do that, and not the other way around.

    Then restart the Track-It! Service Management service.

    If that does not fix the issue, contact Track-It! Support and refer to this article. We have a tool that we can use to correct your encryption and keys.

    Defect:

    If you are experiencing this issue, please open a new support case and refer to Track-It! Defect number DRZOZ-7422: "Change Database Password function not writing a matching encrypted password to all configuration files".

    Your case will be associated with the defect, and you will be able to view the defect status in your case in the Defects/RFEs/CARs section.


    Article Number:

    000122862


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles