Truesight Middleware and Transaction Management: How to change database credentials?

Version 4
    Share This:

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


    PRODUCT:

    TrueSight Middleware Transaction Monitor


    APPLIES TO:

    BMC Middleware Management - Transaction Monitoring Truesight Middleware and Transaction Monitoring Truesight Middleware Management



    QUESTION:

    Question
      

    Database credentials (database type, database schema owner, database name, database password) have changed. How to reconfigure the product so it reflects these changes?

      
    Applies to
      

    BMC Middleware Management - Performance and Availability
    BMC Middleware Management - Transaction Monitoring
    BMC Middleware and Transaction Management
    BMC Application Transaction Tracing
    BMC TrueSight Middleware and Transaction Monitor

      

     

      


     


    ANSWER:

     

    Legacy ID:KA357159

      

    You can watch a how-to video by clicking the link below:

    https://www.youtube.com/watch?v=WvqcKSWb_OY

      

     

      
    Perform these steps to change the db_name, db_password, db_user or db_type
     
      

    From the command line

      
       
    • Stop all services except the Application Service (qpas).    This  step is fine for version until 7.0.
    •  
    • Stop all services,  start from a different command line Application Service (qpas) in Jetty only mode, with qpas -j  . This step is required with version 8.x and higher.
    •  
    • Open Windows command line or a UNIX shell and navigate to the installation directory.
    •  
    • Run the mqsusertool ( Windows ) or mqsusertool.sh ( Unix / Linux )
      mqsusertool --database -db_name <db_connection_name> -db_user <db_connection_user> -db_password <db_connection_password> -db_type <db_vendor_and_version> -target LDAP -logon_user <SA> -logon_password <your_SA_password>
    •  
    • Stop Application Service (qpas).
    •  
    • Start all services.
      

    From the Management Console

      
       
    • On the Security tab, highlight the "database_login" group.
    •  
    • Make sure that the group is not read-only  (click on the "Toggle Read-Only State" icon in the toolbar if it is).
    •  
    • Click on the "Edit Advanced Properties" icon in the toolbar.
    •  
    • Select the appropriate database type from the dropdown list.
    •  
    • Confirm the chage by clicking OK.
    •  
    • Highlight the "database_login" group.
    •  
    • Set it to read-only again.
    •  
    • Save the changes.
    •  
    • Quit the Management Console.
    •  
    • Stop and start the services.
      
    Additional information
      

    Not all db_* parameters need to be specified. If, for example, only the database type ("db_type") needs to be changed, the other db_* parameters can be omitted. 

      

    Example database types from different versions, please be aware that not every type is support in every product version


    "DB2 9.2"              use  DB2
    "DB2 9.5"              use  DB2
    "DB2 9.7"              use  DB2
    "DB2 10.5"           use DB2
    "Oracle 9.2"           or ORACLE_92
    "Oracle 10.1"          or ORACLE_101
    "Oracle 10.2"          or ORACLE_102
    "Oracle 11.1"          or ORACLE_111
    "Oracle 11.2"          or ORACLE_112
    "Oracle 12.1"          or ORACLE_121
    "Microsoft SQL Server" or MSSQL

      

    Note that Oracle 12.2 and 18 should use database type Oracle 12.1

    Running mqsusertool in version 7.x  without command line parameters will show the full command line help

      

    Running mqsusertool in version 8.x  with -h command line parameters will show the full command line help


    KEYWORDS: database, password, change, expired, login failed

     


    Article Number:

    000031772


    Article Type:

    FAQ/Procedural



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