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 MainView Middleware Monitor
BMC TrueSight Middleware and Transaction Monitor

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
"Microsoft SQL Server" or MSSQL
"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

Note that when using TMTM8.1 Oracle 12.2 and 18c should also use database type Oracle 12.1

Starting MVMM9.x, following db_type should be used for supported DB versions.

Refer following doc for the list of supported databases: https://docs.bmc.com/docs/mvmm91/database-server-requirements-1034644677.html

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