Database Settings

The Database Settings page shows a summary of the current database settings and provides access to operations related to the database.

Who has access?

Super Administrator

Detailed Description

The Elastic SSO application uses a MySQL database for storing information. The application can use the MySQL service that runs on the same server as the application or it can be one that exists on another server.

Operations related to the database can be done by selecting the buttons in the Operations sidebar menu.

Connection Settings

Enter the connection parameters and click on the Save button. If the connection cannot be made, an error message will be displayed indicating why the connection failed. If the connection is valid, the parameters will be saved and the application will return to the Database Settings overview page.

Host

The name of the host where the MySQL service is running.

Port

The port number to use for the connection. If this is left blank, it will use the default port.

Database Name

The name of the MySQL database that is to be used for the Elastic SSO application.

Username

The username for the MySQL account that has access to the MySQL database.

Password

The password associated with the above username for the MySQL account.

Initialize

Overwrite Existing Tables

This option will only be displayed if tables already exist in the database. If this option is displayed, it must be checked in order to initialize the database. An error message will be displayed if tables exist and this is not checked when attempting to initialize. Once initialized, all tables will be set to their default state and any existing settings other than the default values will be lost.

Include sample data

If this option is checked when the database is initialized, sample data will be inserted into the database tables.

Import Data

The data from a previously exported database can be restored with this operation.

Import File

Select the file that is to be used for the import. This should be a file that was previously exported through the Export Data operation.

Key

Text phrase used to decrypt the imported database file. This key must be the same as what was used when the database was exported using the Export Data operation.

Export Data

A snapshot of the data in the current database can be exported to a file which can then later be restored using the Import Data operation. The export data operation uses the supplied key to encrypt the data and then compresses the file for download.

Key

Text phrase used to encrypt the exported database file. This key must be used when importing the data using the Import Data operation.

External Database

If using an external MySQL server, the database user must have the following privileges:

CREATE
DROP
LOCK TABLES
REFERENCES
ALTER
DELETE
INDEX
INSERT
SELECT
UPDATE
TRIGGER
ALTER ROUTINE
CREATE ROUTINE
EXECUTE

The supported MySQL database is version 5.5.x or 5.6.x and requires the InnoDB engine. If you are using AWS RDS, you will need to create a custom parameter group in order to modify the log_bin_trust_function_creators parameter and set it to true. If you’ve already created the RDS instance, you can apply the parameter group and restart. If you have not created the RDS instance, you can simply select the custom parameter group during the creation wizard.