<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question Ranger hive plugin issue - Unable to get client certificate. serviceName=hive in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/Ranger-hive-plugin-issue-Unable-to-get-client-certificate/m-p/227526#M189386</link>
    <description>&lt;P&gt;Hi all&lt;/P&gt;&lt;P&gt;I have hdp 2.6.3 with ranger security ssl enabled and plugins(hdfs, yarn and hive) enabled&lt;/P&gt;&lt;P&gt;hive plugin not works here is hiveserver2.log:&lt;/P&gt;&lt;PRE&gt;2018-02-16 17:34:00,920 WARN  [Thread-14]: client.RangerAdminRESTClient (RangerAdminRESTClient.java:getServicePoliciesIfUpdated(162)) - Error getting policies. secureMode=false, user=hive (auth:SIMPLE), response={"httpStatusCode":400,"statusCode":0}, serviceName=hive&lt;/PRE&gt;&lt;P&gt;and /var/log/ranger/admin/xa_portal.log:&lt;/P&gt;&lt;PRE&gt;2018-02-16 08:27:59,754 [http-bio-6182-exec-28] ERROR org.apache.ranger.common.ServiceUtil (ServiceUtil.java:1359) - Requested Service not found. serviceName=hive&lt;/PRE&gt;&lt;P&gt;I am almost 99% sure that all configurations have done correctly from ambari(because other plugins are working properly), also searched on google wondering what I have missed, but was not able to find useful information&lt;/P&gt;&lt;P&gt;P.S. I have configured ranger.plugin.hive.policy.rest.ssl.config.file = /usr/hdp/current/hive-client/conf/conf.server/ranger-policymgr-ssl.xml&lt;/P&gt;&lt;P&gt;which conatins all information about keystores and truststores, also I am sure that keystore file passwords are correct(checked many times)&lt;/P&gt;&lt;P&gt;here is the file ranger-policymgr-ssl.xml&lt;/P&gt;&lt;PRE&gt;  &amp;lt;configuration&amp;gt;
    
    &amp;lt;property&amp;gt;
      &amp;lt;name&amp;gt;xasecure.policymgr.clientssl.keystore&amp;lt;/name&amp;gt;
      &amp;lt;value&amp;gt;/etc/security/key.jks&amp;lt;/value&amp;gt;
    &amp;lt;/property&amp;gt;
    
    &amp;lt;property&amp;gt;
      &amp;lt;name&amp;gt;xasecure.policymgr.clientssl.keystore.credential.file&amp;lt;/name&amp;gt;
      &amp;lt;value&amp;gt;jceks://file/etc/ranger/hive/cred.jceks&amp;lt;/value&amp;gt;
    &amp;lt;/property&amp;gt;
    
    &amp;lt;property&amp;gt;
      &amp;lt;name&amp;gt;xasecure.policymgr.clientssl.keystore.password&amp;lt;/name&amp;gt;
      &amp;lt;value&amp;gt;crypted&amp;lt;/value&amp;gt;
    &amp;lt;/property&amp;gt;
    
    &amp;lt;property&amp;gt;
      &amp;lt;name&amp;gt;xasecure.policymgr.clientssl.truststore&amp;lt;/name&amp;gt;
      &amp;lt;value&amp;gt;/etc/security/trust.jks&amp;lt;/value&amp;gt;
    &amp;lt;/property&amp;gt;
    
    &amp;lt;property&amp;gt;
      &amp;lt;name&amp;gt;xasecure.policymgr.clientssl.truststore.credential.file&amp;lt;/name&amp;gt;
      &amp;lt;value&amp;gt;jceks://file/etc/ranger/hive/cred.jceks&amp;lt;/value&amp;gt;
    &amp;lt;/property&amp;gt;
    
    &amp;lt;property&amp;gt;
      &amp;lt;name&amp;gt;xasecure.policymgr.clientssl.truststore.password&amp;lt;/name&amp;gt;
      &amp;lt;value&amp;gt;crypted&amp;lt;/value&amp;gt;
    &amp;lt;/property&amp;gt;
&lt;/PRE&gt;&lt;P&gt;do you have any idea what I miss and how can I fix this?&lt;/P&gt;&lt;P&gt;Thank you&lt;/P&gt;</description>
    <pubDate>Fri, 16 Feb 2018 23:26:40 GMT</pubDate>
    <dc:creator>shota</dc:creator>
    <dc:date>2018-02-16T23:26:40Z</dc:date>
  </channel>
</rss>

