*DARFT* As a Dashboard admin I need to change a user's password but the reset email wasn't set up at install

Problem

Solution 1 - Setting up the Password Reset email

If you would like to set-up the email you can re-launch the installer and choose to update/ modify the installation. Once that is complete you should be able to trigger the password reset email automatically from the log-in screen.

1. It is a simple process (Please note that at this time a Gmail account will not work for a reset)

2. You can use this section of the CIS-CAT Pro Dashboard Document Library as a reference: 3. Installation - Windows - CIS-CAT Pro Dashboard Document Library | Email

Solution 2

If you have not set up the email and are unable to do so, you can use a Database query to reset the User’s password.

We always recommend that someone with database experience make these changes as issues with the backend database are not something Support will be able to rectify.

This is what the Maria DB query should look, but you will need to replace bob with the actual username:

These are the exact steps used to reset the user’s password via PowerShell:

1. Launch PowerShell as Administrator

2. Make sure your database is running with this command:

   net start MariaDB

3. Run the following command and enter your MariaDB root password when prompted:

   mariadb -u root -p

   1. Should you not recall your MariaDB root password set during installation, it can be found in the /conf/ccpd-config.yml file in your Dashboard directory under the dataSource: property. 

4. Choose to use the ccpd database:

   use ccpd;

5. From here, run the following command, replacing the word “bob” with the user’s account name who has forgotten their password:

   update ccpd.user set password = '{bcrypt}$2a$10$a3q/yfSXin0JSzamE10vE.S1GWEPhINZEhNKBGoveS3DSQTF2r4vW' where username = 'bob';

6. Unlock the user’s account in case it has been locked out from too many incorrect login attempts (replace “bob" with the user's account name again):

   update ccpd.user set account_locked = 0 where username = 'bob';

7. Flush privileges will force changes to take effect:

   FLUSH PRIVILEGES;

8. Exit MariaDB:

   exit;

9. Have the User navigate back to Dashboard, login with their username and the password @admin123, which will prompt them to reset their password.

Keywords;

Content by Label

• Page:
  Feature Enhancement Requests for CIS Products