VERIFIED SOLUTION i

How to update password for EngageOne Repository datbase login when deployed on JBoss 6.2.X


 
There could be a scenario wherein password for user ( that was used when EngageOne Repository was referred in Installed, sometimes referred as "sa") gets changed. This will not allow application server to communicate with EngageOne repository. Follow these steps by after choosing correct JBoss version.

1. Open a command prompt.

2. Verify JBoss server version installed in your environment.
change directory to <JBOSS_HOME>\bin and type the command: standalone –version

3. Change directory to <JBOSS_HOME>. In order to encrypt password, having knowledge about your JBoss version, execute one of the following commands:
a. For JBoss 6.2.0:
java -cp modules\system\layers\base\org\picketbox\main\picketbox-4.0.19.SP2-redhat-1.jar;modules\system\layers\base\org\picketbox\main\jboss-logging-3.1.2.GA-redhat-1.jar org.picketbox.datasource.security.SecureIdentityLoginModule NEW_PASSWORD
b. For JBoss 6.2.1:
java -cp modules\system\layers\base\.overlays\layer-base-jboss-eap-6.2.1.CP\org\picketbox\main\picketbox-4.0.19.SP3-redhat-1.jar;modules\system\layers\base\org\picketbox\main\jboss-logging-3.1.2.GA-redhat-1.jar org.picketbox.datasource.security.SecureIdentityLoginModule NEW_PASSWORD
c. For JBoss 6.2.2:
java -cp modules\system\layers\base\.overlays\layer-base-jboss-eap-6.2.2.CP\org\picketbox\main\picketbox-4.0.19.SP4-redhat-1.jar;modules\system\layers\base\org\picketbox\main\jboss-logging-3.1.2.GA-redhat-1.jar org.picketbox.datasource.security.SecureIdentityLoginModule NEW_PASSWORD
d. For JBoss 6.2.3:
java -cp modules\system\layers\base\.overlays\layer-base-jboss-eap-6.2.3.CP\org\picketbox\main\picketbox-4.0.19.SP6-redhat-1.jar;modules\system\layers\base\org\picketbox\main\jboss-logging-3.1.2.GA-redhat-1.jar org.picketbox.datasource.security.SecureIdentityLoginModule NEW_PASSWORD
e. For JBoss 6.2.4:
java -cp modules\system\layers\base\.overlays\layer-base-jboss-eap-6.2.4.CP\org\picketbox\main\picketbox-4.0.19.SP8-redhat-1.jar;modules\system\layers\base\org\picketbox\main\jboss-logging-3.1.2.GA-redhat-1.jar org.picketbox.datasource.security.SecureIdentityLoginModule NEW_PASSWORD

4. Copy the encrypted password output.

5. Edit the <JBOSS_HOME>/standalone/configuration/standalone-full.xml with a text editor.

6. Search for "security-domain name" in the file:
               <security-domain name="EncryptDBPassword">

7. Update the value attribute in element
               <module-option name="password" value="ENCRYPTED_PASSWORD"/> replacing ENCRYPTED_PASSWORD with the encrypted password.

8. Restart JBoss application server.

Note: it is recommended to take the back up of standalone-full.xml before altering it.

If issue remains unresolved, contact Client Support.
UPDATED:  March 22, 2017