Completing the initial MariaDB database configuration on Linux

On Linux, after the installation completes, open the SafeLinx Administrator to complete the initial configuration. A wizard guides you through the process of configuring where you want the SafeLinx Server to store persistent data.

About this task

  • 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 the configuration process, the database that you want to use must be installed and available.
  • In a local installation, the MariaDB client, server, and ODBC driver are installed on the same workstation as the SafeLinx Server. In a remote installation, you install the MariaDB client and ODBC driver on the same workstation as the SafeLinx Server and configure it to connect to a MariaDB server that is hosted elsewhere.
    Note: As part of MariaDB support on Linux, after installing MariaDB ODBC connector drivers, we need to verify /etc/odbcinst.ini file for MariaDB ODBC 3.1 Driver entry. If this entry is missing then add below contents to the ini file:
    [MariaDB ODBC 3.1 Driver]
    Description = MariaDB Connector/ODBC v.3.1
    Driver = /usr/lib64/libmaodbc.so
  • For more information about supported database clients and servers, see the System requirements.
To use MariaDB, be prepared to provide the following information:
  • Database names: The database name must be eight characters or less. 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 MariaDB the host name field is of the form: <IP address>:<port>. If the port is not specified, it assumes the default value of 3306.
  • Database user ID and password: In order for the databases to be generated automatically, the Database user must already exist and have the requisite permissions to generate the schema.

Procedure

  1. Start the SafeLinx Administrator.

    If you are starting the SafeLinx Administrator for the first time on this computer, a Login Profile Details window may open.

    Before the SafeLinx Administrator can connect to the access manager, you might have to add a login profile. If no login profile exists, add a standard login profile now. Later, you can create a secure login profile for this SafeLinx Server. You can also create standard or secure login profiles to enable SafeLinx Administrator to manage other SafeLinx Servers. For more information, see Setting up an access manager login profile.

  2. After you add a login profile, select the profile, then click OK.
  3. In the SafeLinx Administrator-Login window, type admin in the Administrator ID field, type sl4!admin, the default password, in the Password field, and then click Log In.

    You can create other administrator IDs after you configure access manager.

    The Configure the SafeLinx Server Access Manager wizard opens, along with the license agreement and the SafeLinx Administrator Help.

  4. Read and accept the license agreement and then review the information in the SafeLinx Administrator Help topic Initial configuration wizard.
  5. From the Configure the SafeLinx Server Access Manager wizard, click An ODBC-compliant relational database.
  6. In the Database name field, accept the default name (wgdata) or specify a different name.
  7. In the Database administrative ID field, specify the ID for the MariaDB database account that you want the SafeLinx Server to use to create and access the database.
  8. In the MariaDB Server Host field, accept the default value (localhost) or specify a different location.
    The format for this field is in the traditional <IP address or host name>:port where the default port if not specified is 3306.
  9. For an upgrade or re installation of the SafeLinx Server, select Erase existing database (including all tables and data) and create a new database if you want to remove any old SafeLinx Server databases.

What to do next

Configure the access manager