question how to check hive meta store db's password? in Support Questions

how to check hive meta store db's password?

michaelli — Mon, 11 May 2020 06:16:16 GMT

I am using CM 5.14.2, and from hive's configuration page, i can see the value for javax.jdo.option.ConnectionUserName, which is used to access the underneath metastore db like mysql, but i can't see the value of javax.jdo.option.ConnectionPassword (which is display as **** in the page).

i have forgotten the password used to access hive metastore db. Is there any way to find it back?

Re: how to check hive meta store db's password?

stevenmatison — Sat, 09 May 2020 12:24:19 GMT

@michaelli Not from the UI. You will need to go back to the actual metastore server and see the command(s) to create the hive user. If it’s a MySQL metastore it’s easy to go to MySQL prompt and arrow up to see previously executed commands with the hive user and password.

Re: how to check hive meta store db's password?

paras — Sat, 09 May 2020 16:27:34 GMT

@michaelli

You can use the CM API to fetch the service configurations by executing below command from terminal

# curl -u admin_uname:admin_pass "http://cm_server_host:7180/api/v19/cm/deployment"

The password should be present under the name :

hive_metastore_database_password

Refer:

https://docs.cloudera.com/documentation/enterprise/5-14-x/topics/cm_intro_api.html#concept_dnn_cr5_mr__section_ztf_lyt_xr

Hope this helps,

Paras

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.