| The information on this page refers to License Statistics v7.4 or newer, which introduced 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 v7.4. |
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
You can find out more about MySQL at http://www.mysql.com.
For more details about using custom SSL certificates with an external MySQL database, see Enabling MySQL SSL.
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 updating or reconfiguring it.
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)
In Windows, you can review and edit database configuration settings using the License Statistics Manager.
Database configuration settings (Linux)
In Linux, you can view and edit database settings in the xflicstat.cfg file, as described below.
| Setting | Required | Default value | Description |
|---|---|---|---|
| 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. |