Loading...

Knowledge Center


How to wipe, create, and re-create the Network Security Manager database on Microsoft Windows
Technical Articles ID:   KB54396
Last Modified:  10/17/2019

Environment

McAfee Network Security Manager (NSM) 9.x, 8.x
Microsoft Windows Server
IMPORTANT: Network Security Manager has transitioned from MySQL to MariaDB.
  • The Database used in NSM 9.1 changes to MariaDB with release 9.1.7.77.
     
  • This article features different steps if using NSM 9.1.7.77 and later.
     
  • For full information and news about other releases of NSM, see:
    KB91518 - Network Security Manager and Network Threat Behavior Analysis installation software images will be removed from McAfee Download server on May 31, 2019 (MySQL to MariaDB Transition)

IMPORTANT:
Before you make changes to the database, ensure that you have taken an all table backup. For guidance on the backup, see the "Using the database admin tool" section of the NSP Manager Administration Guide for your release. When you have completed the backup, then perform the following solution.

Summary

This article describes the following topics:
  • How to wipe (empty, erase, or delete) the NSM database after corruption
  • How to create a blank NSM database, or re-create the NSM database after an antivirus product deletes it.

Solution

To wipe or delete the NSM database: 
  1. Stop the Manager Service:
    Click the Network Security icon in the notification area and select Stop Manager.
     
  2. Open a command-line session:
    Click Start, Run, type cmd, and click OK.
     
  3. Change directory to the <database>\bin directory:
    • For NSM 8.x, 9.1.7.75 and earlier and 9.2:
      Type cd $Install_directory\McAfee\Network Security Manager\MySQL\bin\ and press Enter.
    • For NSM 9.1.7.77 and later:
      Type cd $:\MariaDB\bin (for example, c:\MariaDB\bin) and press Enter.
      NOTE: For upgrades, the default location is the previous database installation directory. 
       
  4. Log on to the database:
    • For NSM 8.x, 9.1.7.75 and earlier and 9.2:
      Type C:\mysql\bin>mysql.exe -uadmin -padmin123 lf and press Enter.

      You see the following:
      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 349 to server version: 4.1.15-nt-max
      Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
       
    • For NSM 9.1.7.77 and later:
      Type C:\MariaDB\bin>mysql.exe -uadmin -padmin123 lf and press Enter.

      You see the following:Your MariaDB connection id is 48
      Server version: 10.3.13-MariaDB-log MariaDB Server
      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 
       
  5. Type the following commands, and then press Enter:

    drop database lf ;
    exit
The database is now erased. To use the Manager again, you must re-create the database.

Solution

To create or re-create the NSM database:
  1. Stop the Manager Service:
    Click the Network Security icon in the notification area and select Stop Manager.
     
  2. Open a command-line session:
    Click Start, Run, type cmd, and click OK.
     
  3. Change directory to :
    • For all NSM version:
      Type cd <$install_directory>\McAfee\Network Security Manager\App\bin\ and press Enter.
  4. Type initdb.bat

    You see the following:

    Usage: 0 [ install | upgrade | update | dump ] 
     
  5. Type the following command and then press Enter:

    initdb.bat install

    You see the following:
    Starting Database Installer at Thu Jun 22 13:29:56 BST 2006
    JDBC url = jdbc:mysql://localhost:3306/lf
    Performing installation on jdbc:mysql://localhost:3306/lf
    Initializing the database.
     
  6. Restart the Manager:
    Click the NSM notification area icon and click Start Manager.

Previous Document ID

4679941

Rate this document

Glossary of Technical Terms


 Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.