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

Create a technical support case if you need further support.

Accessing and managing the SafeSync for Enterprise (SSFE) database

    • Updated:
    • 20 Apr 2016
    • Product/Version:
    • SafeSync for Enterprise 2.0
    • SafeSync for Enterprise 2.1
    • SafeSync for Enterprise 3.1
    • SafeSync for Enterprise 3.2
    • Platform:
    • iOS 9.2
    • Macintosh Leopard
    • Macintosh Lion
    • Macintosh Snow Leopard
    • Windows 7 32-bit
    • Windows 7 64-bit
    • Windows 7 Home Premium 32-bit
    • Windows 7 Home Premium 64-bit
    • Windows 7 Ultimate 32-bit
    • Windows 7 Ultimate 64-bit
    • Windows Vista 32-bit
    • Windows Vista 64-bit
    • Windows XP Professional
    • Windows XP Tablet PC
Summary

Determine which database server is being used by SafeSync for Enterprise and how administrator can access it.

Details
Public

SafeSync for Enterprise uses MySQL as its database. MySQL is configured during SSFE server installation. Below are the several databases created in MySQL for SSFE:

  • osdp – main database that stores everything that is not in shard_1 or data
  • shard_1 – objects and permissions reference database
  • data – contains the data table
  • mogilefs – MogileFS’ own database managed independently by the MogileFS system
  • gearman – stores the gearman queue
  • auth – contains persistent logins and SSO information
  • tmsb_db – Shared Protection Extension configuration and keys
  • au – update configuration and component versions

Administrators can locally manage the database or make database queries using the following options:

 
SafeSynce databases are automatically managed and updated by the different components that use them. Take extra caution when accessing database objects and making queries as any incorrect deletions or alterations may cause the system to stop working.

Option 1: Third-party MySQL access tools

Third-party tools such as MySQL Workbench and Navicat for MySQL can be used to connect to MySQL. When using a third-party tool, make sure to set up the connection via SSH tunnel. This is necessary because, by default, MySQL is configured to prohibit remote connections to the database. Only local access is allowed.

Option 2: MySQL command line tool

To work directly with the database:

  1. Log in to SSFE server command line interface.
  2. Run the following command:

    mysql -uroot -p

  3. Type the password when prompted.
Premium
Internal
Rating:
Category:
Configure; Troubleshoot
Solution Id:
1114002
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.


Need More Help?

Create a technical support case if you need further support.