Difference between revisions of "Registry Properties File"
(Created page with "= Overview = The Fusion Registry properties file contains the connection details to the Fusion Registry database. The database password is encrypted, however other properties...") |
(→File Location) |
||
(7 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | [[Category:How_To]] | ||
+ | [[Category:Fusion Registry Install]] | ||
= Overview = | = Overview = | ||
The Fusion Registry properties file contains the connection details to the Fusion Registry database. The database password is encrypted, however other properties such as database platform and schema are in clear text. | The Fusion Registry properties file contains the connection details to the Fusion Registry database. The database password is encrypted, however other properties such as database platform and schema are in clear text. | ||
Line 4: | Line 6: | ||
Whilst the properties file can be modified directly, it is reccomended to use the Fusion Registry User Interface to adminster all registry settings. | Whilst the properties file can be modified directly, it is reccomended to use the Fusion Registry User Interface to adminster all registry settings. | ||
− | = Location = | + | = File Location = |
Whilst all of the installation is performed via the Web User Interface, database connection details are stored in a local properties file. | Whilst all of the installation is performed via the Web User Interface, database connection details are stored in a local properties file. | ||
Line 27: | Line 29: | ||
On Fusion Registry start-up the Registry will search for a Properties file in this order: | On Fusion Registry start-up the Registry will search for a Properties file in this order: | ||
− | + | # The location [[Tomcat_setenv_file|explicitly set in an environment variable]] - RegistryProperties | |
− | + | # The default location as decribed above | |
− | + | # If all else fails, the location will revert to <code>[tomcat]/WEB-INF/classes/fusion_registry.properties</code> | |
If you are unsure about which of the files Fusion 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: | If you are unsure about which of the files Fusion 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: | ||
Line 38: | Line 40: | ||
INFO localhost-startStop-1 org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Loading properties file from URL [file:/C:/Users/<username>/FusionRegistry/fusion_registry.properties] | INFO localhost-startStop-1 org.springframework.beans.factory.config.PropertyPlaceholderConfigurer - Loading properties file from URL [file:/C:/Users/<username>/FusionRegistry/fusion_registry.properties] | ||
</pre> | </pre> | ||
+ | |||
+ | = File Contents = | ||
+ | The file stores three pieces of information: | ||
+ | # Database connection details | ||
+ | # Directory to use to store temporary files | ||
+ | # Root user credentials | ||
+ | |||
+ | The file looks like this: | ||
+ | |||
+ | <pre> | ||
+ | #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 | ||
+ | </pre> | ||
+ | |||
+ | Passwords are encrypted using [https://en.wikipedia.org/wiki/Advanced_Encryption_Standard 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? = | = 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. | 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. |
Latest revision as of 00:01, 29 April 2024
Contents
Overview
The Fusion Registry properties file contains the connection details to the Fusion 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 reccomended to use the Fusion Registry User Interface to adminster 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 Fusion 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 Fusion Registry properties file whilst Fusion Registry is running will have no effect.
The properties file is called:
fusion_registry.properties
Fusion 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 Registry start-up the Registry will search for a Properties file in this order:
- The location explicitly set in an environment variable - RegistryProperties
- The default location as decribed above
- 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 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:
- Database connection details
- Directory to use to store temporary files
- Root user credentials
The file looks like this:
#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
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.