Manage Users via RDBMS
By default, Syncrify does not require any database. It stores everything in local files, most of them are in XML format. Often, companies (particularly service providers) have thousands of users and they want to maintain the users in Syncrify programatically.
Important: This feature is only available in Syncrify's ISP Edition.
Consider This Scenario
Most ISPs have their own website where they offer other services besides remote backup. By storing the user information in a database, information can be modified in realtime without using Syncrify's web interface.
Here are some pros and cons of using a relational database.
Advantages
- External management - you can add/view/modify users from another program, such as your website.
- Highly scaleable
Disadvantages
- Additional dependency - if your database goes down, Syncrify goes down.
- Additional configuration
Prerequisites
At this time, Syncrify supports two database Vendor:
- MySQL
- MS SQL Server
You must have one of the above RDBMS installed either on the same machine or a different machine. You will need a valid user account on the back-end with the following permissions:
- CREATE TABLE
- SELECT
- UPDATE
- DELETE
Syncrify stores user records in just one table called synusers. If this table does not exist, it will be created when you enable RDBMS in Syncrify.
Configuration
Follow the steps below to configure database.
- Log in as admin using the web interface.
- Click on the ISP Configuration link on the right hand side
- Click on Configure Database link on the following screen
- Select the type of database vendor.
- Syncrify will download necessary files for establishing connection from Synametrics' main website
- Once the files are downloaded, it will prompt you for connection parameters such as host name, TCP/IP port, user name and password.
- A new table called synusers will be created if it does not exist
- You can also import existing user accounts to the newly created table if desired.