How to find the CABI login password if forgotten.

Document ID : KB000038918
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:

How to find the CABI login password if forgotten.

Instructions: 

In case if you miss or forget the password of CABI login please follow the below steps:

For Windows:

1)      Open the CMD

2)      Bash -l

3)      cd $SPECROOT/mySql/bin/

4)      Run the command <./mysql -uroot -proot reporting>

Here you are connected to reporting database.

5)      Now run the command <Select AES_DECRYPT(BOPassword, 'spectrum') from registry;>

This command will show the CABI password for the user

For Linux:

1)      Login with CABI install user

2)      cd $SPECROOT/mySql/bin/

3)      ./mysql – defaults-file = ../my-spectrum.cnf –uroot –proot

Here you will get connected to Mysql Database.

4)      Run the command <Use reporting;>

5)      Now run the command <Select AES_DECRYPT(BOPassword, 'spectrum') from registry;>

This command will show the CABI password for the user

Additional Information:

NA