Forums » Interstage BPM Knowledgebase Articles

• C.Y. Chen

  

  • 33 posts
   

  October 1, 2015 3:49:08 PM PDT

  Title: How to Update DB Password in Interstage BPM (RedHat JBoss EAP v5.1.0)

   

  Fact: Fujitsu Interstage BPM (Business Process Manager) Version 11.3.0 Build IF1130108

   

  Fact: RedHat JBoss EAP (Enterprise Application Platform) Version 5.1.0

   

  Fact: MS SQL Server 2008

   

  Fix:

  This article provides instructions on how to update Interstage BPM data source password in RedHat JBoss EAP v5.1.0.

   

  Step 1: Encrypt the new password following the command as shown below:

  This procedure is for JBoss Enterprise Application Platform versions 5.1 and later

  1. Change directory to the jboss-as directory

  2. On Windows environment, use the following command at DOS Console: 
     java -cp client\jboss-logging-spi.jar;lib\jbosssx.jar org.jboss.resource.security.SecureIdentityLoginModule PASSWORD
     
     The command will return an encrypted password.

  Step 2: Obtain the encrypted password in step 1 and update it to login-config.xml, typically found in {JBoss Install Root}\jboss-as\server\ibpm\conf\login-config.xml

  Note:  Please back up the original login-config.xml before editing it.

  Also make sure BPM server is shut down before editing.

  
  

  You can scan for your BPM DB username used to access MS SQL server in the login-config.xml.  Once located the userName attribute, the password attribute is nearby.

  
  

  The password can be located in two difference occurrences.  See the selected red box in the image below.

  
  

  Step 3: After saving the edit of login-config.xml, test to see if BPM server starts up.  
   

  
  

  Note: See http://docs.jboss.org/jbosssecurity/docs/6.0/security_guide/html/Encrypting_Data_Source_Passwords.html#sect-encrypt-data-source-password on how to ecrypt data source password for JBoss 5.1 or later.

  
  

  
  

  
  

  
  

  
  This post was edited by C.Y. Chen at October 1, 2015 4:05:11 PM PDT