Title: How to Update DB Password in Interstage BPM (RedHat JBoss EAP v6.1.0)
Fact: Fujitsu Intertage BPM (Business Process Manager) Version 11.3.1 Build IF1131212
Fact: RedHat JBoss EAP (Enterprise Application Platform) Version 6.1.0
Fact: Oracle 11g R2 Enterprise Edition
Fix:
The data source password for Interstage BPM v11.3.1 deployed to JBoss EAP v6.1.0 is persisted in
{JBoss EAP Home>\domain\configuration\domain.xml.
You can either edit domain.xml directly to update the password, by default is not encrypted, in Interstage BPM v11.3.1 build IF1131212 or edit the password via JBoss Management Console v6.1.0.
Option 1: While domain.bat/domain.sh is stopped, edit domain.xml
Locate the datasource element as shown in the screenshot below to edit the password.
(if image is not presented, click on this link screenshot1)
Change the password as shown and start domain.bat/domain.sh.
Option 2: Update "iFlowDS" data source password field via JBoss Management Console v6.1.0
Step 1: While domain.bat/domain.sh is running, login to JBoss Management Console at http://{hostname}:9990/console/
Step 2: Stop "ibpm-server" instance
Simply navigate from Runtime > Domain > Overview > Server: "ibpm-server" > click on the server instance "ibpm-server" to stop the selected instance. (See KB article for starting or stopping "ibpm-server" instance in JBoss EAP v6.1.0 )
Note: refresh the page if needed to see the current state of the server.
Note: domain.bat remains executed. The JBoss Management Console above simply start or stop the "ibpm-server" instance that belong to the server group called "iflow-server-group" which is managed via domain controller that is started by domain.bat in step 1.
Step 3: Once "ibpm-server" instance is stopped, you can edit the password field in the "iFlowDS" data source.
Simply navigate from Profiles > select "full-ha" Profile > Expand "Subsystems > Expand "Connector" > Datasources > select "iFlowDS" datasource > select "Security" tab and Edit > you will be presented with the field in which to update the password field.
(if image is not presented, click on this link screenshot2)
Step 4: Start up "ibpm-server" instance via JBoss Management Console. Follow the same procedure as explained in step 2 or See KB article for starting or stopping "ibpm-server" instance in JBoss EAP v6.1.0