{"id":5989,"date":"2013-08-07T09:17:52","date_gmt":"2013-08-07T14:17:52","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/legacy\/?page_id=5989"},"modified":"2017-06-12T14:29:55","modified_gmt":"2017-06-12T19:29:55","slug":"encrypted-password-in-datasource-file","status":"publish","type":"page","link":"https:\/\/www.mrc-productivity.com\/legacy\/m-power-admin\/encrypted-password-in-datasource-file","title":{"rendered":"Encrypted Password in Datasource File"},"content":{"rendered":"<h1>Encrypted Password in Datasource File<\/h1>\n<p>The <a href=\"https:\/\/www.mrc-productivity.com\/legacy\/m-power-admin\/understanding-the-data-source-configuration-file-for-web-2-0-templates-2\" target=\"_blank\">Datasource <\/a>file contains the connectivity information between m-Power and the database, including the user name and password.\u00a0 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.<\/p>\n<p>For existing customer updating to the August 2013 release: after applying the update, the passwords\u00a0will no longer display in clear text on the Datasource GUI, but one extra\u00a0 step is needed to encrypt the passwords in the mrc-spring-context.xml file when opened in text mode. Please follow these steps:<\/p>\n<ul style=\"padding-left: 30px;\">\n<li>Navigate to Admin, click Edit Data Dictionary Files, click Data Source Configuration, and then click Text Mode.<\/li>\n<li>Click the binoculars icon and do a Find\/Replace, the text to find is:<br \/>\n<strong>org.apache.commons.dbcp.BasicDataSource<\/strong><br \/>\nand it is to be replaced with:<br \/>\n<strong>com.mrc.dbo.EncryptionDataSource<\/strong><br \/>\n<strong>NOTE: <\/strong>All of the connection beans class attribute\u00a0must 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.<\/li>\n<li>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.<\/li>\n<li>Open the Data Source Configuration GUI. Press the Accept button. Doing so will encrypt the existing clear text passwords.<\/li>\n<li>Next, click Data Source Configuration, this time select <strong>m-Power Interface<\/strong> from the drop down at the top of the page, next to &quot;Select database connection information for&quot; 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: <strong>com.mrc.dbo.EncryptionDataSource<\/strong> in all the beans like you did before.<\/li>\n<li>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.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/datasourcee.png\"><img loading=\"lazy\" decoding=\"async\" width=\"848\" height=\"103\" class=\"alignnone size-full wp-image-6041\" alt=\"datasourcee\" src=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/datasourcee.png\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Encrypted Password in Datasource File The Datasource file contains the connectivity information between m-Power and the database, including the user name and password.\u00a0 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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1161,"menu_order":500,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-5989","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/5989","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/comments?post=5989"}],"version-history":[{"count":37,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/5989\/revisions"}],"predecessor-version":[{"id":7308,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/5989\/revisions\/7308"}],"up":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1161"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/media?parent=5989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}