Completing the initial MySQL 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

To configure MySQL, be prepared to provide the following information:
  • Database names. The default name of the session information database is wgdata. The default name of the accounting and billing information database is wgacct.
  • Database server location, IP address or host name and port number. For MySQL, 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 MySQL 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 MySQL 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 MySQL Server over the network.

For more information about supported database clients and servers, see the System requirements.

Note: If you use a remote database server and that server grants access to designated database administrators only, you might not be able to use the following instructions to configure the database. Instead, you can run database definition language (DDL) scripts to complete the configuration. For more information, see Configuring MySQL databases for HCL SafeLinx with DDL.

To use the Database Configuration Wizard to enable the SafeLinx Server to use MySQL to store data, complete the following procedure:

Procedure

  1. If the First Steps wizard does not open automatically, click Start > Programs > HCL SafeLinx > First Steps.
  2. From the Welcome page, open the Database Configuration page, and then click Database Configuration Wizard.
  3. Select MySQL as the database type to use for configuration and accounting data.
  4. Complete the following fields:
    Note: If you are updating an existing version of the SafeLinx Server or if a database already exists, you might be prompted to delete the existing configuration database. If you want to preserve configuration information from the original database, do not delete it until you have a verified backup.
    1. In the MySQL Administrator ID and Password fields, type the credentials of a MySQL Administrator account that you want the SafeLinx Server to use when it accesses the database.
    2. Type the name of the configuration database in the Name field. If the MySQL server is hosted on a computer other than the SafeLinx Server, change the default value from localHost:3306 to <server host name>:<MySQL Port>.
    3. Type the name of the accounting database in the Name field. If the MySQL Server is hosted on a computer other than the SafeLinx Server, change the default value from localHost:3306 to <server host name>:<MySQL Port>.

What to do next

Return to the First Steps portal and open the SafeLinx Administrator to Configure the access manager.