Configure the Database
Skyhigh Content Security Reporter is installed with an internal database, or you can use a supported external database.
Connect to the internal database
Installed with Content Security Reporter.
- Select Menu > Configuration > Reporter Server Settings.
- From the Setting Categories menu, select Database.
- In the Configuration section, select Default internal database.
Backup and restore the internal database
Back up the internal database to safeguard your data against hardware failures or other issues. Reinstate data from the backup
using the restore feature.
Before you begin
Skyhigh Security recommends using the MySQL GUI Tools, which includes MySQL Administrator, to back up or restore the Content Security Reporter internal database.
The MySQL GUI Tools is available as a free download from dev.mysql.com/downloads/gui-tools and must be installed on the
same computer as Content Security Reporter.
You will need the following information when using this tool:
- Server Hostname — 127.0.0.1
- Port — 9129
- Username — dba
- Password — dba
- Database name — reporting
- Log off Content Security Reporter.
- Shut down the Content Security Reporter Internal Database service.
- Perform the backup or restore procedure using instructions in the MySQL Administrator documentation
- Restart the Content Security Reporter Internal Database service.
- Log on to Content Security Reporter.
Results: The backup or restore is complete and the internal database is functional.
Connect to an external database
To store the data for your medium- to large-size organization, connect Content Security Reporter to a supported external
database.
IMPORTANT: If the Content Security Reporter and Skyhigh ePO™ databases share the same SQL Server instance, you must configure
separate databases for each.
- Users on the Microsoft SQL Server database must have db_owner permissions.
- You can install Content Security Reporter and the external database on the same computer, or on separate computers.
If Content Security Reporter is installed on the same computer as the external database, there must be enough disk space to accumulate large amounts of data.
- Select Menu > Configuration > Reporter Server Settings.
- From the Setting Categories menu, click Database.
- On the Database page, select Edit.
- From the This external database menut, select the database.
- On the Database settings configuration area, enter the database information.
- Select the SSL checkbox to use SSL encryption while connecting to the database.
NOTE: To connect using SSL, the database server must also be SSL-enabled
- To verify that the database information is correct, click Test.
A status message indicates success or failure. - Click Save.
Results
The connected external database appears as the database server in the Registered Servers list:
Menu > Configuration >Registered Servers.
Skyhigh Security recommends that you do not edit the settings on the Registered Servers page.