How to change FootPrints Service Core 12.x / 20.x database user passwords

Version 3
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    FootPrints


    COMPONENT:

    FootPrints


    APPLIES TO:

    FootPrints 12.x / 20.x



    PROBLEM:

    This article describes how to change the FootPrints Service Core 12.x / 20.x database login passwords.

    These instructions require the passphrase value used during the installation of FootPrints 12.x / 20.x  Please contact FootPrints Technical Support If this value is not known.


    These steps must be performed with full Administrator privileges.


    SOLUTION:

    In the steps below, C:\Program Files\BMC Software\FootPrints Service Core refers to the base install location of FootPrints 12.x / 20.x. By default, this would be C:\Program Files\BMC Software\FootPrints Service Core on a Windows server, and opt/bmc/FootPrintsServiceCore on a linux server. When performing the steps below, please adjust the path accordingly for the actual base install location of FootPrints 12 in your environment.

       
    1. IMPORTANT! Make a backup copy of the C:\Program Files\BMC Software\FootPrints Service Core\conf\footprints-environment.properties file on the server.
    2.  
    3. Stop the FootPrints Service Core 12.x / 20.x Apache Tomcat service - On Windows, this should be listed as Apache Tomcat 7.0 Tomcat7 or version 8 (under Start -> Administrative Tools -> Services). For linux, issue a command such as service tomcat7 stop
    4.  
    5. Change the database login passwords using the database management tools available for the database being used by FootPrints Service Core. NOTE: There are 4 database logins used by FootPrints Service Core. Open the C:\Program Files\BMC Software\FootPrints Service Core\conf\footprints-environment.properties file to determine the exact names of the database logins to change. These logins are referenced by the red arrows in the image below:
                User-added image     
       
    1. Encrypt the new database passwords provided for each of the 4 users and save them in the footprints-environment.properties file.     
           
      1. On the computer where FootPrints is installed run the following command once for each of the four database users to encrypt each user's password.  Open a command prompt with Administrator rights, and change directory to the Java JRE install path where the java.exe file is stored. Example: C:\Program Files\Java\jre1.8.0_73\bin    NOTE: The path may be different!       
               
        • Replace the path values in the command with the location where FootPrints is currently installed (i.e. the "base install folder" - C:\Program Files\BMC Software\FootPrints Service Core).
        •      
        • Replace the "Your Passphrase Here" value with the passphrase value used during the installation of FootPrints.  Include quotes around the passphrase, they may contain a space.
        •      
        • Replace the "passwordToBeEncrypted" value with the plain text password to be encrypted.  Do not include quotes around the password to be encrypted.
        •     
      2.   
                        An example command is:  
                    
    java.exe -cp "C:\Program Files\BMC Software\FootPrints Service Core\web\WEB-INF\lib\*;C:\Program Files\BMC Software\FootPrints Service Core\conf" com.numarasoftware.footprints.tool.EncryptionTool -passphrase "Your Passphrase Here" -text passwordToBeEncrypted
           
       NOTE: If Java is not in the system path, provide the full path to the java executable, for example: 
           
    "C:\DifferentFolder\Java\bin\java.exe" -cp "C:\Program Files\BMC Software\FootPrints Service Core\web\WEB-INF\lib\*;C:\Program Files\BMC Software\FootPrints Service Core\conf" com.numarasoftware.footprints.tool.EncryptionTool -passphrase "Your Passphrase Here" -text passwordToBeEncrypted
        Change the Java JRE path to match the version number of your installation.
                       
       
    1. The command will return the encrypted password in the "Result" field of the command's output:
                            User-added image  
     
      NOTE: Certain output will be shown in the command prompt window when the command begins to run, which may appear to be errors and indicating failure as shown in the image immediately below. As long as the last 3 lines of the output show the "Result:", the provided password (at the line that contains "Verified:"), and the "Strength: 128" line, the "errors" shown in the image can safely be ignored.     
     
      User-added image 
     
    An error message which says, "Error: Could not complete the requested operation.", means the passphrase provided is incorrect.  
     
      User-added image   
      
       
    1. Copy the encrypted password value and paste it into the appropriate location in the C:\Program Files\BMC Software\FootPrints Service Core\conf\footprints-environment.properties file. The red arrows in the image below point to the proper locations to enter the encrypted passwords:
      
      User-added image
      
     
    Be careful to copy each password to the correct location in the    footprints-environment.properties file.  
     
    This table shows the default mapping of database login names to entries in the    footprints-environment.properties file.  
      
                                                                                                                                 
    Database Login nameUser name key in properties filePassword key in properties file
    fpscdb001_usrDatabaseUserNameDatabaseUserPassword
    fpscdb001_admDatabaseAdminNameDatabaseAdminPassword
    fpscdb001_rptReportingUserNameReportingUserPassword
    fpscdb001_secSecureUserNameSecureUserPassword
      
      NOTE: The database login names may be different than those displayed in the table above. The actual database login names must match the database user names in the restored FootPrints database. 
      
       
    1. Start the FootPrints Service Core 12.x / 20.x Apache Tomcat service.
      
      

     


    Article Number:

    000348058


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles