Encrypted Password in Datasource File
The Datasource file contains the connectivity information between m-Power and the database, including the user name and password. For your security m-Power encrypts the password for each connection, this adds security to your development platform by not displaying the passwords in clear text when opening the Datasource file. The encryption feature is setup by default on all new m-Power installs from August 2013 and later.
For existing customer updating to the August 2013 release: after applying the update, the passwords will no longer display in clear text on the Datasource GUI, but one extra step is needed to encrypt the passwords in the mrc-spring-context.xml file when opened in text mode. Please follow these steps:
- Navigate to Admin, click Edit Data Dictionary Files, click Data Source Configuration, and then click Text Mode.
- Click the binoculars icon and do a Find/Replace, the text to find is:
org.apache.commons.dbcp.BasicDataSource
and it is to be replaced with:
com.mrc.dbo.EncryptionDataSource
NOTE: All of the connection beans class attribute must be changed, even if they are not being used. The find and replace is the fastest way to replace all of them in one step. - Once finished changing all the class beans to the new class, click the Save icon on the upper left toolbar section. Close the text editor.
- Open the Data Source Configuration GUI. Press the Accept button. Doing so will encrypt the existing clear text passwords.
- Next, click Data Source Configuration, this time select m-Power Interface from the drop down at the top of the page, next to "Select database connection information for" and then click Text Mode. This will open the mrc-spring-context.xml file located in the mrcwebgui folder. Repeat the steps and replace the class name for: com.mrc.dbo.EncryptionDataSource in all the beans like you did before.
- Once finished changing all the class beans to the new class, click the Save icon on the upper left toolbar section. Close the text editor.