Registry Properties File

From FMR Knowledge Base
Revision as of 02:30, 23 August 2022 by Vmurrell (talk | contribs) (File Location)
Jump to navigation Jump to search

Overview

The Registry properties file contains the connection details to the Fusion Metadata Registry database. The database password is encrypted, however other properties such as database platform and schema are in clear text.

Whilst the properties file can be modified directly, it is recommended to use the Registry User Interface to administer all registry settings.

File Location

Whilst all of the installation is performed via the Web User Interface, database connection details are stored in a local properties file.

Unlike previous versions of the Registry it is recommended that you do not modify the values in this file, as all settings are configured via the web User Interface.

The properties file is only read at start-up and changing any of the values in the Registry properties file whilst the Registry is running will have no effect.

The properties file is called:
Versions 10 and earlier

fusion_registry.properties

Version 11
fmr.properties


Fusion Metadata Registry will attempt to save a new properties file to the directory:
<user home>\MetadataTechnology\FusionRegistry

Therefore, on a Windows 7 Operating System this will typically be: C:\users\<your user name>\MetadataTechnology\FusionRegistry

Whereas on a Unix Operating System, it is more likely to be located at: /users/<your user name>/MetadataTechnology/FusionRegistry

If you are running Tomcat as a Windows service, then the Home directory is likely to be: C:\Windows\System32\config\systemprofile

And the file is likely to be located at: C:\Windows\System32\config\systemprofile\MetadataTechnology\FusionRegistry

On Fusion Metadata Registry start-up the Registry will search for a Properties file in this order:
1. The location explicitly set in an environment variable
2. The default location as described above
3. If all else fails, the location will revert to [tomcat]/WEB-INF/classes/fusion_registry.properties

If you are unsure about which of the files Fusion Metadata Registry is using to obtain system information, please look at the start-up log in your web application server. There will be entries like the following:

INFO localhost-startStop-1 org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Loading properties file from class path resource [fusion_registry.properties]
15
INFO localhost-startStop-1 org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Loading properties file from URL [file:/C:/Users/<username>/FusionRegistry/fusion_registry.properties]

File Contents

The file stores three pieces of information:

  1. Database connection details
  2. Directory to use to store temporary files
  3. Root user credentials

The file looks like this in Version 10

 
#Modified on Fri Mar 27 07:58:12 GMT 2020
#Fri Mar 27 07:58:12 GMT 2020
database.dialect=org.hibernate.dialect.MySQL55Dialect
database.driver=com.mysql.cj.jdbc.Driver
database.password=oMPSQtPj37lo1hrttvAhkQ\=\=metatech
database.url=jdbc\:mysql\://localhost\:3306/registry_datbabase
database.useCustomString=false
database.username=root
java.tmp=C\:\\Tomcats\\Tomcat-7.0.56-Registry-8080\\temp
security.auth.prov=registry
security.password=$2a$10$fhuzUaxFXv/qEN2hhuEc6O1FKUyHynebocAmWGyayAFPWfweMkpM.
security.username=root

The file looks like this in Version 11

 
#Modified on Tue Dec 14 13:42:46 GMT 2021
#Tue Dec 14 13:42:46 GMT 2021
database.dialect=org.hibernate.dialect.MySQL55Dialect
database.driver=com.mysql.cj.jdbc.Driver
database.password=U8q7WdGf5jNUOOHWXXoXVQ\=\=
database.url=jdbc\:mysql\://localhost\:3306/registry_datbabase
database.useCustomString=false
database.username=root
encrypt.password=820619a9-ef55-49e5-beb8-17a1a66b797e
encrypt.salt=94ff1c84-2498-44e3-9b2b-cf4b8c7f8bf6
security.password=$2a$10$lZzxmR1rDOxgjufIO8U7Rep1Z3wXFts85LOt/BdVRhoaWFM.xRuKi
security.username=root


Passwords are encrypted using AES-256 encryption.

Values can be directly modified in the properties file, however an application restart is required for these changes to take effect. The Fusion Registry User Interface provides an Admin UI to modify any settings (including ones stored in the Registry database) and should be used over direct modification to the file if possible.

What Happens if the properties file is deleted?

If the properties file is deleted, fear not. On application server restart, the Fusion Registry will redirect to the Install wizard. Upon entering the connection details to the database that was previously used, the Registry will detect it is already installed and redirect to the home page. If the database connection is to a new database, then the remainder of the install wizard should be completed to re-install the product.