Setting up a Database for Statistics

Cerberus FTP Server Enterprise edition supports collecting and reporting detailed session and file access statistics using an ODBC-compliant database. A database connection must be configured in Cerberus before the server will begin collecting statistics. The reporting database connection will also be used by the Reporting Manager for generating reports.

The following databases are currently supported (others may work with appropriate ODBC driver installed):

  • Microsoft SQL Server 2012 and 2014 LocalDB
  • Microsoft SQL Server 2012 and 2014 Express
  • Microsoft SQL Server 2012 and 2014 Enterprise
  • MySQL Server 5.2 and higher

help-51

Database Configuration page for Statistics Collection

Selecting a Database

If you are setting up a new database connection for the first time you will need to enable statistics collection and select a database ODBC driver. The basic steps for this task are detailed below. The ODBC database driver and individual driver settings will vary by database.

  1. Press the Configure button on the Cerberus FTP Server toolbar to open the Server Manager.
  2. Select the Reporting page on the Server Manager.
  3. Open the Drivers select box and select the ODBC database driver appropriate for your database type (i.e. ODBC Driver 11 for SQL Server for a remote connection to Microsoft SQL Server).
    For Microsoft SQL Server installations other than LocalDB, we recommend downloading and installing the Microsoft ODBC Driver 11 for SQL Server. Some reporting features may not work with the default SQL Server ODBC driver installed on most machines.
  4. The connection parameters available for your driver type will now appear and must be filled in.
  5. After filling in the ODBC driver connection parameters, press the Connect button to test your connection. The Connect button will test that Cerberus can establish a connection to the database, and run a quick search for the necessary Cerberus statistics tables.
  6. The ODBC Connection result should say Success. There should also be entries for the different database tables. If those tables haven’t yet been created then there will be error messages displayed beside each table entry. If you are using a database that requires a username and password, the user account must have permission to create a database, and tables in the database. Statistics collection and reporting will not work if the user account does not have create database and create table permissions.
  7. Press the Create Tables button to create the necessary database tables for Cerberus to write to the database.
  8. If Create Tables was successful then you will see each table listed in the status box with the message Created next to it. You are finished setting up your connection.
  9. Check the Enable Statistics Collection checkbox.

Installing Microsoft SQL Server 2012 LocalDB

The quickest and easiest database option is Microsoft Server 2012 LocalDB. LocalDB is a light-weight, embedded database option from Microsoft that is suitable for local, low-utilization database traffic. It has a relatively small footprint, and installs quickly. You will also need the Microsoft SQL Server 2012 Native Client ODBC driver for connectin to LocalDB. Links to both products are below.

Important: If you are running the 64-bit version of Cerberus FTP Server, make sure you download and install the 64-bit version of SQL LocalDB and the corresponding 64-bit SQL Server 2012 Native Client driver.

Microsoft LocalDB 2012 Downloads

After installing SQL Server 2012 LocalDB and the SQL Server 2012 Native Client, you can go to the Server Manager’s Reporting page and select the SQL Server Native Client 11.0 driver.

  1. Press the Configure button on the Cerberus FTP Server toolbar to open the Server Manager.
  2. In the Drivers field select SQL Server Native Client 11.0
  3. The connection parameters available for your driver type will now appear. Select LocalDB 2012 for a Microsoft SQL Server 2012 LocalDB installation.
  4. Press the Connect button to test your connection.
  5. If there are no ODBC Connection errors after pressing the Connect button, press the Create Tables button to create the necessary database tables for Cerberus to write to the database.
  6. Check the Enable Statistics Collection checkbox.

Database Backup and Restore

The Backup and Restore buttons are currently only supported when connecting to Microsoft SQL Server databases. The buttons will be disabled when any other database type is selected. The buttons allow downloading a copy of a local database, and later restoring it. Note, the database will be saved to the local machine where the database is running. If you click the Backup button for a remote database, the database will be saved to the selected path on the remote server running the database. The same goes for restoring a database. The database must be on the local machine.

Non-SQL Server databases should be backed up using whatever backup system is native to that database.