07/07/2022 1,559 People found this article helpful 460,779 Views
How to rebuild the thumbprints for Email Security (to address the Thumbprint is Stale Alert or fix a corrupted thumbprint/ MySQL database).
This article is to address the Thumbprint is Stale Alert. This alert can take place due to corruption of the thumbprint database or some update files relating to the thumbprint databases.
NOTE: This Article does not apply to email security software/appliance version 7.4.0 to 7.4.5 so if you are running any version between 7.4.0 - 8.x.x then please upgrade the firmware to 10.x.x as anything older then 9.x.x is not supported. Follow steps mentioned for respective firmware to rebuild thumbprint database.
For windows servers: Versions 9.x.x – 10.x.x
Note: The following commands are only available in 9.x.x and higher. Please upgrade to at least 10.x.x to run these commands.
C:\Program Files (x86)\SonicWallES\mlfworkr.exe" -cleanupmariadbdata
NOTE: If mlfworkr.exe is not found in Program Files (x86), look for it in Program Files
C:\Program Files (x86)\SonicWallES\PluginDefault\collab
Please Note that this command will rebuild all MySQL databases, Thumbprints and Reports Database.
For appliances: Versions 9.x.x – 10.x.x
SNWLCLI:>stop appservices
( it will take few minutes to stop services and come back to the prompt)SNWLCLI:>MySQL -dodbrecovery
( This command can take 5- 10 minutes and come back to the prompt)SNWLCLI :> cleanupdcdatabase.
(The last command will ask for a confirmation to reboot.)Once reboot is completed the Thumbprint databases and Reports database will initiate the rebuild.
It will take about 30-45 minutes to finish the download and processing of the thumbprints and insert into the MySQL databases.
NOTE: Older model Appliances (ES200 - ES500) can take much longer to process the updates. If you receive Thumbprint stale alerts still while rebuilding, please restart services and monitor the Thumbprint info page.
Please note that if you are receiving MySQL down alerts you will need to perform the complete rebuild as outlined above.
Selective Rebuilds
For windows server command line: Versions 9.0.x – 10.x.x
Support does not recommend running the ALL command In the CLI.
Please use the full rebuild commands above instead.
mlfworkr -rebuildcollabdb < AT | CT | DT | HT | IM | IP | NM | PH | TT | VR | XB | geoip | pdata | sdata | all >
Download new copies of thumbprint databases from the data center
(This command will effectively rebuild all thumbprint databases. If you wish to rebuild specific thumbprint databases based on the specific letter, simply specify the relative letter.)
The same command is used for appliances and their related build as above.
If in question type help rebuildcollabdb in the CLI to see the syntax for usage
rebuildcollabdb < AT | CT | DT | HT | IM | IP | NM | PH | TT | VR | XB | geoip | pdata | sdata | all >
Download new copies of thumbprint databases from the data center
How to rebuild Thumbprint databases from the UI (all versions).