Product Name
CIS-CAT Pro Dashboard
Product Version
3.0.0+
Date
Problem
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.
It is a simple process (Please note that at this time a Gmail account will not work for a reset)
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:
Launch PowerShell as Administrator
Make sure your database is running with this command:
net start MariaDB
Run the following command and enter your MariaDB root password when prompted:
mariadb -u root -p
Should you not recall your MariaDB root password set during installation, it can be found in the
/conf/ccpd-config.ymlfile in your Dashboard directory under thedataSource:property.
Choose to use the
ccpddatabase:use ccpd;
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';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';
Flush privileges will force changes to take effect:
FLUSH PRIVILEGES;
Exit MariaDB:
exit;
Have the User navigate back to Dashboard, login with their username and the password
@admin123, which will prompt them to reset their 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.
Add Comment