...
| The information on this page refers to License Statistics v6v7.6 4 or newer, which introduced the License Statistics Manager, a tool that replaces direct editing of the xflicstat.cfg configuration file for Windows installations. customizable SSL configuration and added a validation process that prohibits running multiple instances of License Statistics using the same database. If you are using an earlier version of License Statistics, please refer to the documentation for releases prior to v6v7.64. |
License Statistics can use either an external or embedded MySQL database. The following sections contain information relevant to MySQL database configuration, including:
- Backup/restoration and upgrading an embedded database
- Using an external MySQL database
- Enabling MySQL SSL
| Info |
|---|
You can find out more about MySQL at http://www.mysql.com. |
| Info |
|---|
For more details about using custom SSL certificates with an external MySQL database, see Enabling MySQL SSL. |
| Warning |
|---|
| Important: Direct SQL queries and manipulation of the database is unsupported. Manipulating the database can result in database corruption. Direct SQL queries and manipulation of the database structure are unsupported. Always make a backup of your database before manipulatingupdating or reconfiguring it. |
| Info |
|---|
To prevent data corruption, running more than one instance of License Statistics using the same database is not allowed. A validation is run upon application startup to prevent running multiple instances of License Statistics on the same database schema. If detected it, any instances that attempt to start after the first instance will fail to start. |
Database configuration settings (Windows)
For In Windows, you you can review and edit edit database configuration settings using the License Statistics Manager. See Using the License Statistics Manager for more information.
Database configuration settings (Linux)
For In Linux, you can view and edit database settings in the xflicstatthe xflicstat.cfg file, as described below. Available settings in xflicstat.cfg include the following.
| Setting | Required | Default value | set by installerDescription | |
|---|---|---|---|---|
| MYSQL_SERVER | Yes | EMBEDDED64 | To use the embedded MySQL server delivered with the application, set this value to EMBEDDED64. To use an external MySQL server, specify the server name or IP address. | |
| MYSQL_PORT | Yes | 3306 | MySQL server port. | |
| MYSQL_DATABASE | Yes | xformation_licstat | Name of License Statistics database. If you use an embedded MySQL server, the database will be created automatically the first time you run License Statistics. If you use an external MySQL server, the database must be created manually before running License Statistics. | |
| MYSQL_USERNAME | Yes | root | Username for the account created in the License Statistics database. | |
| MYSQL_PASSWORD | No | empty | Password for the account created in the License Statistics database. | |
| MYSQL_SSL_VERIFY | No | FALSE | May be set to TRUE or FALSE. To force certificate verification, set to TRUE. | |
| MYSQL_SSL_KEYSTORE | No | INSTALLDIR/mysql_keystore.jks | Path to keystore with loaded certificate and its private key. By default, License Statistics will try to use the mysql_keystore.jks file located in the installation directory. | |
| MYSQL_SSL_KEYSTORE_PASSWORD | No | empty | Password for accessing the keystore. |