Brightmail ControlCenter not updating properly

About a week ago I noticed that Brightmail was no longer sending me daily reports telling me how many messages came in, what percentage was spam, virus, etc. so I finally got around to looking into it. Turns out the ControlCenter within Brightmail was no longer updating so it was not showing updates for virus or spam definition files, nor was it tracking how many messages were handled. I searched their online knowledgebase, but it’s not very user friendly. After a call to their support center I got the instructions I needed to get the ControlCenter updating again. Here are the steps I took:

# cd /opt/symantec/sbas/ControlCenter/MySQL/mysql-pro-4.0.16-sun-solaris2.8-sparc/bin

NOTE: this is the default install directory. If you installed in a non-standard place you will need to replace the above path with your install directory

# ./mysqlcheck –h --auto-repair –ubrightmailuser –ppassword brightmail

The password can be obtained by looking for the password attribute located in:


I generally direct the output from this command to a text file, although it is of very little actual value:

# ./mysqlcheck –h --optimize –ubrightmailuser –ppassword brightmail
# /etc/init.d/tomcat4 stop
# /etc/init.d/mysql.server stop
# /etc/init.d/mailwall stop
# /etc/init.d/mysql.server start
# /etc/init.d/mailwall start
# /etc/init.d/tomcat4 start

I was able to then restart the ControlCenter and log in, and I found all of my information was once again updating correctly and I am able to pull reports on the messages that have been scanned.