Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

How do I enable or disable external database access to the SMS?

    • Updated:
    • 6 Sep 2017
    • Product/Version:
    • TippingPoint SMS All
    • TippingPoint Virtual SMS
    • Platform:
Summary

The SMS Server allows external access to its database. With this external access, other systems can perform a number of tasks including reading the SMS database, generating reports, and replicating the database. The SMS does not allow modifications to the database through external connections. Any external access to the SMS database is restricted to read-only. External access can be secured by granting access to a specified list of IP addresses.

 

Note 1: Enabling external access and enabling database replication to an external system both require a reboot of the SMS Server. Follow your company's server downtime policies, including notification to SMS clients of the pending reboot.

Note 2: To configure external database replication, you must create an SMS database snapshot, and then copy the snapshot to the target replication system and import it into a MariaDB database before the SMS server can replicate its data to the target system.

Note 3 : External database replication and the SMS High Availability (HA) features both leverage the same functionality in the underlying MariaDB database. The SMS database does not support replication to multiple destinations; therefore, we do not recommend using SMS HA and external database replication at the same time.

Details
Public

How To: Common Task

  1. Log in to the SMS from a client.
  2. On the SMS toolbar, navigate to the Admin->Database tab.


How To: Manage External Database Access

  1. In the External Database Settings section, click Edit. The Edit External Database Settings dialog box opens.
  2. From the navigation pane, click External Access Settings.
  3. Check the checkbox titled Enable external database access to grant external access and uncheck the box to disable access.
  4. If enabling access, enter the username and password of a database user with sufficient rights to read all the desired data from the SMS database.
  5. After ensuring all SMS clients are logged off the SMS Server, click Reboot to complete the task of changing the external access setting.


How To: Manage External Database Replication

  1. In the External Database Settings section, click Edit. The Edit External Database Settings dialog box opens.
  2. From the navigation pane, click External Replication Settings.
  3. Check the checkbox titled Enable External Database Replication to grant enable replication and uncheck the box to disable replication.
  4. If enabling replication, enter the username and password of a database user with sufficient rights to read from the SMS database all data that is targeted for replication.
  5. After ensuring all SMS clients are logged off the SMS Server, click Reboot to complete the task of changing the external replication setting.
  6. Once SMS restarts, select Database from the Admin Navigation menu, then click Edit in the External Database Settings section.
  7. From the navigation pane in the Edit External Database Settings dialog box, click External Replication Settings.
  8. Click Create Snapshot to create a snapshot of the SMS database. The snapshot is saved locally on the SMS server. You will copy it to the target replication system, where you will import it into a new, or existing, database, before the SMS server begins to replicate its data to the target system.
  9. Configure the database on the target system.
  10. Import the data schema and data that are stored in the snapshot into the target system's database.
  11. Gracefully terminate other client connections to the SMS server.
  12. Reboot the SMS server, to initialize the SMS database replication service and begin replicating data to the target system.


How To: Manage External database Access Restrictions

  1. In the External Database Settings area, click Edit.The Edit External Database Settings dialog box opens.
  2. From the dialog box navigation pane, click Access Restrictions.
  3. Check the check box titled Enable Restricted Access to restrict access and uncheck the box to remove access restrictions.
  4. If restricting access, select from the drop-down list a Named IP Address Group. Note that a Named IP Address Group is defined in the Admin - Named Resources area of the SMS Console.
  5. Click OK.



Reference: SMS User Guide

Premium
Internal
Rating:
Category:
Configure; Troubleshoot; Deploy
Solution Id:
TP000088864
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.