The Database Settings page shows a summary of the current database settings and provides access to operations related to the database.
Who has access?
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.
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.
The name of the host where the MySQL service is running.
The port number to use for the connection. If this is left blank, it will use the default port.
The name of the MySQL database that is to be used for the Elastic SSO application.
The username for the MySQL account that has access to the MySQL database.
The password associated with the above username for the MySQL account.
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
The data from a previously exported database can be restored with this operation.
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.
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.
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.
Text phrase used to encrypt the exported database file. This key must be used when importing the data using the Import Data operation.
If using an external MySQL server, the database user must have the following privileges:
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.