The 'Logs' page in the Control Center of the Symantec Brightmail Gateway shows "Cannot display the logs"

Products

• Messaging Gateway

Issue/Introduction

When opening the page > Status > Logs the top of the page shows in red letters "Cannot display the logs".

Symptoms
Everything else seems to be working fine.

When clicking the drop-down lists on the 'Logs' page:

• The drop-down list for Host shows "All hosts" and nothing else.
• The drop-down list for Severity shows "All" and nothing else.
• The drop-down list for Component is empty.
• The drop-down list for Log type is empty.
• The drop-down list for Time range is empty.

 

Cause

This is most likely caused by corrupted MySQL tables.

Resolution

The MySQL tables need to be repaired.

For users of Brightmail Gateway versions 7.7.X and 8.0.X
Please contact Symantec Enterprise Technical Support.
They will need to be able to log on to your machine with a Command Line Interface tool (e.g. putty) in order to set the correct account and run a mysqlcheck.
 

For users of Brightmail Gateway version 9.0.X and 10.x
This version includes a new command that allows an Administrator to run a MySQL Check. This will need to be performed as per the article found below:

https://knowledge.broadcom.com/external/article?articleId=152314

Please note: Once a MySQL check has been performed, if a MySQL table had been marked as "crashed" and is repaired, it is likely that logging covering the period of when the table is crashed, may not be available on the Logs page.