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

book

Article ID: 48863

calendar_today

Updated On:

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>

    Figure 1

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

    <Please see attached file for image>

    Figure 2

  5. Leave the COMPLETE option selected and click NEXT.

    <Please see attached file for image>

    Figure 3

  6. Click INSTALL to start the MySQL Workbench install.

    <Please see attached file for image>

    Figure 4

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

    <Please see attached file for image>

    Figure 5

  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>

    Figure 6

  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>

    Figure 7

    <Please see attached file for image>

    Figure 8

    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>

    Figure 9

  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>

    Figure 10

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

    <Please see attached file for image>

    Figure 11

  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>

    Figure 12

  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>

    Figure 13

  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>

    Figure 14

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

    <Please see attached file for image>

    Figure 15

  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

Attachments

1558721528416000048863_sktwi1f5rjvs16w34.gif get_app
1558721525579000048863_sktwi1f5rjvs16w33.gif get_app
1558721523709000048863_sktwi1f5rjvs16w32.gif get_app
1558721521852000048863_sktwi1f5rjvs16w31.gif get_app
1558721519834000048863_sktwi1f5rjvs16w30.gif get_app
1558721517836000048863_sktwi1f5rjvs16w2z.gif get_app
1558721516034000048863_sktwi1f5rjvs16w2y.gif get_app
1558721514207000048863_sktwi1f5rjvs16w2x.gif get_app
1558721512178000048863_sktwi1f5rjvs16w2w.gif get_app
1558721508246000048863_sktwi1f5rjvs16w2v.gif get_app
1558721506472000048863_sktwi1f5rjvs16w2u.gif get_app
1558721504602000048863_sktwi1f5rjvs16w2t.gif get_app
1558721502871000048863_sktwi1f5rjvs16w2s.gif get_app
1558721501038000048863_sktwi1f5rjvs16w2r.gif get_app
1558721498916000048863_sktwi1f5rjvs16w2q.gif get_app