Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Product Name

CIS-CAT Pro Dashboard

Product Version

v33.0.0+

Date



Problem

Info

I wish to reset a user password for someone that is unable to access the server. I have reviewed the documentation and checked all the settings for the user but I don’t see an option for changing their password.

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.

Warning

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:

    Code Block
    net start MariaDB
  3. Run the following command and enter your MariaDB root password when prompted:

    Code Block
    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:

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

    Code Block
    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):

    Code Block
    update ccpd.user set account_locked = 0 where username = 'bob';
  7. Flush privileges will force changes to take effect:

    Code Block
    FLUSH PRIVILEGES;
  8. Exit MariaDB:

    Code Block
    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.

 

Warning

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.

Keywords; User Password Dashboard v3 MariaDB

Content by Label

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel = "sbp_fer"

Copyright © 2023

Center for Internet Security®


Page Properties
hiddentrue

Action

Name(s)

Date

Linked ticket

Jira Legacy
serverSystem JIRA
serverIdb90ca2a8-9df7-3869-89db-c424866c1b16
keySUPPORT-26200

Jira Legacy
serverSystem JIRA
serverIdb90ca2a8-9df7-3869-89db-c424866c1b16
keySUPPORT-25978

Created by

Amanda McGown

Reviewed by

SBP Product Technical Support Team (Amanda McGown Allan Cornwell Andrew Dannenberger Nick Romanzo Parami Swenson (Unlicensed) Perfect Tangban (Unlicensed))

Approved by

SBP Product Technical Support Team (Amanda McGown Allan Cornwell Andrew Dannenberger Nick Romanzo Parami Swenson (Unlicensed) Perfect Tangban (Unlicensed))

Remove by