Retrieve RMON password from Cloudera Manager

[#1]

Summary

If you have lost your RMON db password and need to retrieve it, in CM GUI it is **** out.  This article will tell you have you can retrieve it in plain text.

Symptoms

Any customer needing to get into RMON db but not having the password would need to get the password to get in (assuming they do not have DB ROOT)

Instructions

To retrieve the password we can do an API call that gives us the RMON db config info.

 api/v31/cm/service/roleConfigGroups/mgmt-REPORTSMANAGER-BASE/config

an example would be:

curl -u admin:admin GET http://ccycloud-1.oteixeira-ubuntu2004.root.comops.site:7180/api/v31/cm/service/roleConfigGroups/mgmt-REPORTSMANAGER-BASE/config
​

And the results would appear similar to:

{
  "items" : [ {
    "name" : "headlamp_database_host",
    "value" : "ccycloud-1.oteixeira-ubuntu2004.root.comops.site:3306"
  }, {
    "name" : "headlamp_database_name",
    "value" : "reportsmanager9f05b8e6450d2994f37859d1ee3f1967"
  }, {
    "name" : "headlamp_database_password",
    "value" : "reportsmanager9f"
  }, {
    "name" : "headlamp_database_type",
    "value" : "mysql"
  }, {
    "name" : "headlamp_database_user",
    "value" : "reportsmanager9f"
  }, {
    "name" : "headlamp_heapsize",
    "value" : "1073741824"
  }, {
    "name" : "process_auto_restart",
    "value" : "false"
  }, {
    "name" : "process_swap_memory_thresholds",
    "value" : "{\"critical\":\"never\",\"warning\":\"never\"}"
  } ]
}​

[#2]

Symptoms

Any customer needing to get into RMON db but not having the password would need to get the password to get in (assuming they do not have DB ROOT)

Instructions

To retrieve the password we can do an API call that gives us the RMON db config info.

 api/v31/cm/service/roleConfigGroups/mgmt-REPORTSMANAGER-BASE/config

an example would be: