Basic Settings

This section describes how to enable the MySQL store for Xpress Insight 5. You should also secure the connection by performing the instructions in the following section.

Edit the application.properties file to disable the file system store and enable the MySQL store:

1. In the Filesystem Persistence section, comment out the value for insight.server.persistence.store from filesystem.

   #insight.server.persistence.store=filesystem

2. In the MySQL Persistence section, un-comment or add the following values:

   #------------------------------------------------------------------------------
   # MySQL Persistence
   #------------------------------------------------------------------------------
   ## Use the MySQL persistence store.
   insight.server.persistence.store=mysql
   
   ## The URL to connect to the repository database.
   insight.server.persistence.mysql.url=jdbc:mariadb://localhost:3306/insight
   
   ## The username for the repository database connection.
   insight.server.persistence.mysql.username=insight
   
   # The password for the repository database connection.
   insight.server.persistence.mysql.password=

   Note The URL should be a mariadb jdbc driver URL pointing to the schema defined above. The username should be for the user mentioned in the prerequisites section (with all privileges on the schema to allow insight to manage its tables) The password can be encrypted within the properties file. For more, see the later topic Encrypting Sensitive Information Stored in Configuration Files.

Note 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 For example: insight.server.persistence.mysql.url=jdbc:mysql://localhost:3306/insight?allowPublicKeyRetrieval=true

© 2001-2021 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.