Close menu

sqlictool utility

As of SQL/R A.04.20 the sqlictool utility is included with SQL/R and provides a convenient option to install license keys in an automatic way.

The sqlictool utility submits a request to the Marxmeier license server and installs the license key.

The following functions are currently supported:

Usage

The sqlictool utility takes a command on the command line. Options may be used to override the default target file, to request a verbose output, or to log debug information. 
$ sqlictool -help

SQL/R SQLICTOOL A.04.20    (C) Copyright 1992-2025 Marxmeier Software AG
usage: sqlictool [options] command [...]
       sqlictool help [command ...]
options:
 -help   - show usage (this list)
 -v      - verbose
 -o file - override default output file, '-' write to stdout
 -d flgs - debug flags
A license request is submitted to the Marxmeier license server and returns a completion status, a message (optional) and license data that is saved to the license file.

Write access to the license file is required to install the resulting license key. A new license file is created if the request succeeds. A previous license file will be renamed (license.1 …) and retained as a backup.
The -o command line option may be used to specify the output file instead of using the default. If the output file cannot be created the license data is output to stdout instead.

A non-zero return code indicates an error.

help command

The help command lists the available commands. It may also be used to verify the connection to the Marxmeier license server as the output is provided by the server. 
$ sqlictool help

Command usage:
  getlic system
    - Obtain license for specific system.
  getlic temp
    - Obtain temporary license for specific system.

getlic system command

The getlic system request is used to install a perpetual license key for a system. This can be used if a license key was previously created for this system and is covered by a maintenance agreement. For example when updating to a newer SQL/R version. The request will obtain and install a perpetual license key.

For example, if a permanent license exists: 

# sqlictool -v getlic system

System-specific permanent license issued.
Writing license to '/etc/opt/sqlr/4.2/license'.
This request is also used to install a temporary license issued by marxmeier Software. For example, if a temporary license exists: 
# sqlictool -v getlic system

System-specific temporary license issued, expires on 2025-12-31.
Writing license to '/etc/opt/sqlr/4.2/license'.
A message as below indicates the request did not succeed: 
License not available for this system.
Possible causes are the system ID is not known to the license server, the license was transferred to another system or the license is not covered by a maintenance agreement. If this is an error please contact the Marxmeier support for assistance.

getlic temp command

The getlic temp request is used to generate and install an installation license key which provides a temporary license valid for 30 days. Please note that an installation license may be requested only once per system and product version. If a perpetual license is available, or if a temporary license has been issued by Marxmeier Software, requesting an installation license will not succeed. Please use the getlic system request in this case.

Data submitted to the server

The sqlictool utility requires an (outgoing) internet connection for the https protocol to the Marxmeier license server. The following information is submitted to the Marxmeier license server to service the request and is logged with the results.

The "-d*1" debug option may be used to obtain additional details. The -d*1H2 option may be used to log the server exchange in detail.

Please note: By using the sqlictool utility you agree to submit this information and allow using it to process and log the request.

Please note: Using the lictool utility implies acceptance of the Marxmeier license terms.