Page Comparison

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.

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.

Keywords; User Password Dashboard v3 MariaDB

Content by Label