Hashing algorithm for FastStats systems
Following the deprecation of the SHA-1 hash function, it is no longer recommended for use with digital signatures. For this reason, we recommended that all FastStats systems move away from SHA-1 to at least SHA-256 as soon as possible.
If your FastStats system is still set to SHA-1 Security Hash Method, then follow the steps below to upgrade the system to your preferred hash method.
Changing hash method for FastStats
To change the hash method for FastStats:
-
Ask all users to log out.
-
Open the FastStats Web Service Configurator.
-
Click System, then Security.
-
Set Hash method to desired level (SHA-256 minimum).
You must then reset all users passwords.
-
Open the FastStats Configurator.
-
Click File, then Generate Password Hash.
-
Enter password in the Password box, select the new hashing method used in the previous step and click Generate (if using password salt then check the Generate salt box).
The Hash box populates with the hashed version of password.
-
You must now update the Users table in the Control Database (WS DB) to change all user’s passwords and set a flag to force them to change their password on next login.
To do this, use the following SQL script:
CopyUSE TealHols
UPDATE dbo.Users
SET [Password] = 'daa0ae2248187da55ce3b006831cd0e76d22a03f84dc09a3497a58f2d02f8d1f' --generated hashed password
, PasswordManuallyExpired = 1 -
Users can now log back into FastStats using the password.
They are prompted to change their password before they can continue into the system.
You have now updated the hash function on your FastStats system.
Changing hash method for Orbit
If the system also has Orbit running, then it may be necessary to update the hash method in the Orbit API Configurator.
To change the hash method in Orbit:
-
Open the FastStats Orbit Update Configurator.
-
In the API section, click Open API Configurator.
-
In General > FS Config database, if the Connection string has a valid FS_ Config connection string then the changes made previously in the FastStats Configurator automatically appear.
-
If not populated, then you must to go to the DataView tab > Session service and change the Hashing algorithm to match the method set in the FastStats Configurator Web Service.
-
Save and Close the Orbit API Configurator.
You have now updated the hash function on your Orbit system.