As a Dashboard admin I need to change a user's password but the reset email wasn't set up at install
Product Name
CIS-CAT Pro Dashboard
Product Version
3.0.0+
Date
Apr 19, 2023
Ā
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.yml
file in your Dashboard directory under thedataSource:
property.Ā
Choose to use the
ccpd
database:use ccpd;
From here, run the following command, replacing the word ābobā with the userās account name who has forgotten their password:
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):Flush privileges will force changes to take effect:
Exit MariaDB:
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.
Keywords; User Password Dashboard v3 MariaDB
Content by Label
Ā