Completing the initial SQL Server database configuration on Linux

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

Before you begin

Complete the procedures Installing the SafeLinx Server on Linux and Installing the SafeLinx Administrator on Linux.

About this task

  • The SafeLinx Server can store data on a SQL Server database that is local, or it can connect to a remote database. Before you start the database configuration process, the database that you want to use must be installed and available. You must also have installed the Microsoft ODBC driver for SQL Server and the Microsoft SQL Server command-line tools. Refer to the Microsoft documentation Install the Microsoft ODBC driver for SQL Server (Linux) and Install SQL Server command-line tools on Linux.
  • In a local installation, the SQL server and the ODBC driver for SQL Server are installed on the same workstation as the SafeLinx Server. In a remote installation, you install the ODBC driver for SQL Server on the same workstation as the SafeLinx Server and configure it to connect to a SQL Server that is hosted elsewhere.
  • For more information about supported database clients and servers, see the HCL SafeLinx 1.2 System Requirements.
To use SQL Server, 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 IP address or host name and port number. The default host name is localhost and the default port value is 1433.
  • Database user ID and password. A SQL Server running on Windows must use SQL Server Authentication. In order for the databases to be generated automatically, the Database user must already exist and have the requisite permissions to generate the schema.

To enable the SafeLinx Server to use SQL Server to store data, complete the following steps.

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 SQL Server database account that you want the SafeLinx Server to use to create and access the database.
  8. If not using a local installation of SQL Server, select A different machine than SafeLinx and provide the SQL Server host name. The format for this field is <IP address or host name>. Also enter the correct port if not using port 1433.

    When connecting to a remote SQL Server instance other than the default instance, you must use the SQL Server instance port; \<instance_name> appended to the server name is not supported.

  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.