question Re: From where does the Hive Metastore gets database password? in Archives of Support Questions (Read Only)

From where does the Hive Metastore gets database password?

KuldeepK — Fri, 16 Sep 2022 10:48:00 GMT

I remember there was this property(mentioned below) in hive-site.xml for metastore password.

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>as_if_I'm_going_to_paste_my_password_here</value>
</property>

I cannot see it in my hive-site.xml (HDP-2.5.0.0), I think we have some credential provider configured for this but I'm unable to find that property in hive-site.xml as well.

 <!-- Configure credential store for passwords-->
  <property>
    <name>hadoop.security.credential.provider.path</name>
    <value>jceks://file/usr/lib/hive/conf/hive.jceks</value>
  </property>

Any idea where it stores the password?

Re: From where does the Hive Metastore gets database password?

KuldeepK — Thu, 17 Nov 2016 00:03:41 GMT

I got it.

/etc/hive/conf/conf.server

I was searching all the time in /etc/hive/conf/hive-site.xml and was assuming that /etc/hive/conf.server does not exists.

Re: From where does the Hive Metastore gets database password?

thejas — Wed, 10 May 2017 04:16:16 GMT

You can also use following command to retrieve the password - sudo java -cp "/usr/hdp/current/ranger-tagsync/lib/*" org.apache.ranger.credentialapi.buildks get javax.jdo.option.connectionpassword -provider jceks://file/etc/hive/conf/conf.server/hive-site.jceks

Re: From where does the Hive Metastore gets database password?

rakeshbca — Sun, 15 Apr 2018 23:34:49 GMT

may i know what action have you taken to get or change the passwd of hive metastore??