How to check or repair a MySQL database when errors are returned for the installed version of Symantec Brightmail AntiSpam 6.x or Symantec Mail Security for SMTP 5.x

Article:TECH82759  |  Created: 2004-01-04  |  Updated: 2010-08-23  |  Article URL http://www.symantec.com/docs/TECH82759
Article Type
Technical Solution

Product(s)

Environment

Issue



You want to check the status of the Brightmail MySQL database. If the status check returns an error message, you want to know how to repair the database.

 


Solution



For steps on checking and repairing the Brightmail MySQL database, go to the section for the operating system installed.

If you use Brightmail AntiSpam 6.02, the user account was changed and the default password is now auto-generated and stored in the server.xml file.
For more information see "Access MySQL with brightmailuser Account Instead of root" in the section titled "Important Additions and Changes to Consider, Version 6.0.2" in Release Notes for Symantec Brightmail AntiSpam for Sendmail 6.0.2.

To obtain the password read Determining your MySQL user name and password for Symantec Brightmail 6.0.x or Symantec Mail Security 5 for SMTP product.

To check and repair the Brightmail MySQL database when using Windows

  1. On the Windows taskbar, click Start > Run.
  2. In the Open box, type the command:
    cmd.exe
     
  3. Press Enter.
  4. Change to the MySQL\bin folder.
    By default it is on drive C.
  5. At the command prompt, type the command that applies to your version:
    • Symantec Mail Security 5 for SMTP

      The command is run from the directory location:
      C:\Program Files\Symantec\SMSSMTP\MySQL\Bin

      mysqlcheck -ubrightmailuser -p<paste password here> brightmail --auto-repair

      Replace <password> with the value found in the .brightmailuser file. The .brightmailuser file is located in the following directory by default:
      C:\Program Files\Symantec\SMSSMTP\
       
    • Symantec Brightmail version 6.0.2 or later
      The command is run from the directory location:
      C:\MySQL\bin folder

      mysqlcheck --auto-repair -ubrightmailuser -p<password> brightmail

      Replace <password> with the value found in the server.xml file. The server.xml file is located in the following directory by default:
      C:\Program Files\Symantec\SBAS\ControlCenter\Tomcat\jakarta-tomcat-4.1.27\conf\
       
    • Symantec Brightmail versions 6.0 and 6.0.1
      The command is run from the directory location:
      C:\MySQL\bin folder

      mysqlcheck --auto-repair -uroot -pbrightmail brightmail > check.txt

      There are two dashes before auto in the above command. This repairs the corrupted tables and outputs the results to the file Check.txt. The time to output the results to the file check.txt depends on the size of the MySQL database. The larger the database, the longer the time.
       
  6. Press Enter.
  7. Exit the command prompt.



To check and repair the Brightmail MySQL database when using Linux

  1. Open a command prompt.
  2. At the prompt type the following command to change to the correct MySQL/bin directory:
    cd /opt/symantec/sbas/ControlCenter/MySQL/Mysql-pro-4.0.16-pc-linux-i686/bin

    Change the above default path to where MySQL installed if the installation is in another location.
  3. If the status check returns an error, type the command that applies to your version, and then press Enter:
    • 6.0.2 or later
      ./mysqlcheck -h127.0.0.1 --auto-repair -ubrightmailuser -p<password> brightmail > check.txt

      Replace <password> with the value found in the server.xml file. The server.xml file is located in the following directory by default:
      /opt/Symantec/SBAS/ControlCenter/Tomcat/jakarta-tomcat-4.1.27/conf/
       
    • Versions 6.0 and 6.0.1
      ./mysqlcheck --auto-repair -uroot -pbrightmail brightmail > check.txt

      There are two dashes before auto in the above command. This repairs the corrupted tables and outputs the results to the file Check.txt. The time to output the results to the file check.txt depends on the size of the MySQL database. The larger the database, the longer the time.
  4. Exit the command prompt.



To check and repair the Brightmail MySQL database when using Solaris

  1. Open a command prompt.
  2. At the prompt, type the following command to change to the MySQL/bin directory:
    cd /opt/symantec/sbas/ControlCenter/mysql-pro-4.0.16-sun-solaris2.8-sparc/bin

    Change the above default path to where MySQL installed if the installation is in another location.
  3. If the status check returns an error, type the command that applies to your version, and then press Enter:
    • Version 6.0.2
      ./mysqlcheck -h127.0.0.1 --auto-repair -ubrightmailuser -p<password> brightmail > check.txt

      Replace <password> with the value found in the server.xml file. The server.xml file is located in the following directory by default:
      /opt/Symantec/SBAS/ControlCenter/Tomcat/jakarta-tomcat-4.1.27/conf/
       
    • Versions 6.0 and 6.0.1
      ./mysqlcheck --auto-repair -uroot -pbrightmail brightmail > check.txt

      There are two dashes before auto in the above command. This repairs the corrupted tables and outputs the results to the file Check.txt. The time to output the results to the file check.txt depends on the size of the MySQL database. The larger the database, the longer the time.
  4. Exit the command prompt.




References
 

Determining your MySQL user name and password for Symantec Brightmail 6.0.2 or later
Scheduling a check of the Quarantine Database and Control Center database on a computer with a supported Linux operating system



Technical Information
In the event a MySQL database repair does not correct the problem, a list of corrupted tables is given. You can then use try running a repair on each table listed. The command:
mysql -ubrightmailuser -p<password> brightmail REPAIR TABLE brightmail <tablename>


Additional information go to 13.5.2.6 REPAIR TABLE Syntax.


 



Legacy ID



2004110407532763


Article URL http://www.symantec.com/docs/TECH82759


Terms of use for this information are found in Legal Notices