Initializing help system before first use

Using MySQL for the Repository Storage

Xpress Insight can persist its Repository data to a MySQL database. To use this option, you must create a database of the correct type for Insight to use.
The database can be given any name. In the command below, the name “insight” is used. 
 CREATE DATABASE insight DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

Insight expects to fully manage the database schema supplied to it. This capability requires a user which has been granted all privileges on the database schema.

In the command below, the user is given the name “insight”. You can replace this with any name.

The user is given access to localhost. It is expected that the MySQL service is not co-located with Insight. Therefore “localhost” should be replaced with the hostname of the MySQL service (or % for all hosts).

Finally, you should replace ‘myPasswordHere’ with a suitable password. 

CREATE USER 'insight'@'localhost' IDENTIFIED BY 'myPasswordHere';
GRANT ALL ON insight.* TO 'insight'@'localhost';
FLUSH PRIVILEGES;

Insight can be configured to use the new MySQL database within the Insight Server application.properties file. The following table describes the available properties. Review the description of each property and set its value accordingly in the properties file. Then save the file and restart Insight for changes to take effect.

Configuration property Description
insight.server.persistence.store=[mysql|filesystem] Use MySQL or the file system for persisting the Repository. Default is filesystem.
insight.server.persistence.mysql.url The URL should be a mariadb jdbc driver URL pointing to the database schema defined above e.g. jdbc:mariadb://localhost:3306/insight After configuring Insight to use MySQL, you might receive the following error message: RSA public key is not available client side (option serverRsaPublicKeyFile not set) In this case, add the following to the URL: allowPublicKeyRetrieval=true
insight.server.persistence.mysql.username The user account Insight should use to authenticate into the database. The instructions above created an "insight" user for this purpose.
insight.server.persistence.mysql.password The password of the user account Insight should use to authenticate into the database. This should be added as an encrypted property.
Parent Topic Using MySQL with Insight 5

© 2001-2024 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.