Changing the EngageOne Server Repository database password in the JBoss 6.2.X


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

1. Open a command prompt.

2. Verify the 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 the element
               <module-option name="password" value="ENCRYPTED_PASSWORD"/> replacing ENCRYPTED_PASSWORD with the encrypted password.

8. Restart the JBoss application server.

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

 
UPDATED:  September 18, 2019