How to reset the CA Business Intelligence (CABI) CMS Administrator password when using a MySQL CMS database

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

The MySQL install that is provided with CABI r3 does not include a graphical management console for MySQL. Therefore it is necessary to first download and install a MySQL Management Console to assist in resetting the CABI CMS Administrator password.

1. Login to the CABI server with an OS account that has administrator rights and download the MySQL Workbench installer from the following URL:
   
   http://dev.mysql.com/downloads/workbench
   
   
2. Launch the MySQL Workbench installer.
   
   
3. Click NEXT on the Welcome Screen.
   
   

   <Please see attached file for image>

   
   
   
4. Click NEXT to accept the default install location or alter the install location if desired.
   
   

   <Please see attached file for image>

   
   
   
5. Leave the COMPLETE option selected and click NEXT.
   
   

   <Please see attached file for image>

   
   
   
6. Click INSTALL to start the MySQL Workbench install.
   
   

   <Please see attached file for image>

   
   
   
7. Once the install is complete, leave the 'LAUNCH MYSQL WORKBENCH NOW' option selected and click FINISH.
   
   

   <Please see attached file for image>

   
   
   
8. When MySQL Workbench launches, select the 'Open Connection to Start Querying' link to create the connection to the MySQL CABI database
   
   

   <Please see attached file for image>

   
   
   
9. Enter LOCALHOST in the HOSTNAME field and verify the MySQL listening port (3306 by default). Leave the USERNAME as 'root' and click on the 'STORE IN VAULT' button to enter the MySQL 'root' password. Once the MySQL 'root' password has been entered, click on OK.
   
   

   <Please see attached file for image>

   
   
   

   <Please see attached file for image>

   
   
   NOTE: If the MySQL 'root' password has been forgotten, follow the instructions in TEC529518 to reset the MySQL 'root' password.
   
   
10. Click OK On the 'Connect to Database' screen.
    
    

    <Please see attached file for image>

    
    
    
11. You will see a 'Connect to SQL Editor' screen appear as MySQL Workbench makes the connection to the MySQL database.
    
    

    <Please see attached file for image>

    
    
    You will then be connected to the MySQL database and see the Query Editor window.
    
    

    <Please see attached file for image>

    
    
    
12. Before proceeding to reset the CABI Administrator password, on the CABI server open the Central Configuration Manager (CCM) and stop the Server Intelligence Agent (SIA).
    
    

    <Please see attached file for image>

    
    
    
13. When the SIA has stopped, switch back to MySQL Workbench. Highlight the BOE120 database in the OBJECT BROWSER and enter the following query in the QUERY window:
    
    DELETE FROM cms_infoobjects6 WHERE (ObjectID=12);
    COMMIT;
    
    

    <Please see attached file for image>

    
    
    
14. Click on the 'lightning bolt' icon in the toolbar to execute the query against the BOE120 database. This will delete the database record that belongs to the CABI Administrator account.
    
    

    <Please see attached file for image>

    
    
    
15. Restart the SIA from the CCM. The CABI Administrator account will be recreated with a blank password.
    
    

    <Please see attached file for image>

    
    
    
16. Login to the Central Management Console (CMC) with the Administrator account and a blank password. Remember to reset the CABI Administrator password from the CMC.

Environment

Release:
Component: SDBOXI