Configuring Database Settings

Database settings configuration is largely the same for any role when you choose to include the database on that appliance. For roles that automatically include the default MySQL database, such as All In One or Database Only, the Database Type, Database Host, and Database Port fields are not editable. This is also the case for any role when Include Database (MYSQL) is selected. The Administrator Credentials fields are displayed only if the role has been defined to include the installation of the MySQL database. These are not available when a SQL Server database is selected.

This section describes the options for configuring the database settings for either the MySQL database or the Microsoft SQL Server database. The SonicWALL GMS can run the MySQL database, but SonicWALL GMS can also use either a MySQL or a SQL Server database running on a Windows Server machine in a multi-system deployment.

To configure the database settings for any role, complete the following steps in the appliance management interface:

1	Navigate to the Deployment > Role page and select the role for this appliance.

2	To run the MySQL database on this SonicWALL GMS, select Include Database (MYSQL). To use a MySQL or Microsoft SQL Server database on another system, do not select this check box.

3

Under Database Configuration, if Include Database (MYSQL) was not selected in the previous step, select either MYSQL or SQL Server from the Database Type pull-down list. This field is not editable if you previously selected Include Database (MYSQL) or if the selected role is All In One or Database Only.

 

4

In the Database Host field, type in the IP address of the database server or accept the default, localhost, if this SonicWALL GMS includes the database. This field is not editable if you previously selected Include Database (MYSQL) or if the selected role is All In One or Database Only. This field can accept/display IPv4 and IPv6 addresses.

NOTE: If your deployment requires an instance name for the SQL server database, when completing the Database Host field, enter the Host or IP address, followed by a back slash and the instance name. The format should look as follows: 10.20.30.40\INSTANCE.

5	To use a different port when SonicWALL GMS accesses the database, type the port into the Database Port field. The default port is 3306.

6	To use a different user name when SonicWALL GMS accesses the database, type the user name into the Database User field. The default user name is “sa”.

7	Type the password that SonicWALL GMS uses to access the database into both the Database Password and Confirm Database Password fields.

8	If your deployment uses a custom database driver, type the value into the Database Driver field. Otherwise, accept the default, com.mysql.jdbc.Driver.

9	If your deployment uses a custom database URL, type the value into the Database URL field. If you are using a different port, change the default port, 3306, in the URL. Otherwise, accept the default URL, jdbc:mysql://localhost:3306.