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