Completing the initial MariaDB database configuration on Windows
On Windows, after the Installation wizard completes, the First Steps portal opens to guide you through the initial configuration.
Before you begin
- Database names The default name of the session information database is
wgdata
. The default name of the accounting and billing information database iswgacct
. - Database server location, IP address or host name and port number For MariaDB, the host name field is of the form: <IP address>:<port>.
- Database user ID and password For the databases to be generated automatically, the Database user must already exist and have the requisite permissions to generate the schema.
About this task
The First Steps portal includes a link to open the Database Configuration Wizard. This wizard guides you through the process of configuring the SafeLinx Server to use the relational database where you want the SafeLinx Server to store persistent data.
The SafeLinx Server can store data on a MariaDB database that is local or it can connect to a remote database. Before you start database configuration, the database that you want to use must be installed and available.
In a local installation, you install MySQL client, MySQL ODBC driver, and MariaDB Server on the same workstation as the SafeLinx Server. In a remote installation, you install the MySQL Client and MySQL ODBC driver on the same workstation as the SafeLinx Server and configure it to connect to a MariaDB Server over the network.
To use the Database Configuration Wizard to enable the SafeLinx Server to use MariaDB to store data, complete the following procedure:
Procedure
- If the First Steps wizard does not open automatically, click .
- From the Welcome page, open the Database Configuration page, and then click Database Configuration Wizard.
- Select MariaDB as the database type to use for configuration and accounting data.
-
Complete the following fields:
Note: If you are updating an existing version of the SafeLinx Server and a database already exists, you might be prompted to delete the original version. If you want to preserve configuration information from the original database, do not delete it until you have a verified backup.
- In the MariaDB Administrator ID and Password fields, type the credentials of a MariaDB Administrator account that you want the SafeLinx Server to use when it accesses the database.
-
Type the name of the configuration database in the
Name field. If the MariaDB server is hosted
on a computer other than the SafeLinx Server, change the default value
from
localHost:3306
to<server host name>:<MariaDB Port>.
-
Type the name of the accounting database in the
Name field. If the MariaDB Server is hosted
on a computer other than the SafeLinx Server, change the default value
from
localHost:3306
to<server host name>:<MariaDB Port>
.