Support Questions
Find answers, ask questions, and share your expertise

In Hive properties, which Ranger property has to updated when 'Ranger Admin username for Ambari (ranger_admin_username)' is updated in Rnager Admin Settings?

In Hive properties, which Ranger property has to updated when 'Ranger Admin username for Ambari (ranger_admin_username)' is updated in Rnager Admin Settings?

Currently, I have a HDP 2.6.1 cluster with Ranger (LDAP). I disabled Hive plugin, deleted the Hive service from Ranger UI and also reset the Ranger admin password by following the instructions inline:

'https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_security/content/updating_ranger_admin_p...'. I updated Ranger UI admin password first, then updated same password for the following 2 values:

  • Ranger Admin user -- The credentials for this user are set in Configs > Advanced ranger-env in the fields labeled admin_username (default value: admin) and admin_password (default value: admin).
  • Admin user used by Ambari to create repo/policies -- The user name for this user is set in Configs > Admin Settings in the field labeled Ranger Admin username for Ambari (default value: amb_ranger_admin). The password for this user is set in the field labeled Ranger Admin user's password for Ambari. This password is specified during the Ranger installation.

Now, when I enable Hive plugin and restart hive services, I get the following error:

2017-08-17 18:51:18,877 - Error getting HDP_Cluster2_hive repository for component hive. Http status code - 401. {"statusCode":401,"msgDesc":"Authentication Failed"}

2017-08-17 18:51:53,664 - Error creating repository. Http status code - 401. {"statusCode":401,"msgDesc":"Authentication Failed"}

2017-08-17 18:52:58,553 - Error getting HDP_Cluster2_hive repository for component hive. Http status code - 401. {"statusCode":401,"msgDesc":"Authentication Failed"}

2017-08-17 18:53:33,505 - Error creating repository. Http status code - 401. {"statusCode":401,"msgDesc":"Authentication Failed"}

2017-08-17 18:53:33,505 - Hive Repository creation failed in Ranger admin

___________________________LOG_File__________________________________________________

2017-08-17 18:44:05,039 - call returned (0, 'hive-server2 - 2.6.1.0-129') 2017-08-17 18:44:05,039 - RangeradminV2: Skip ranger admin if it's down !

2017-08-17 18:44:05,621 - amb_ranger_admin user already exists.

2017-08-17 18:44:06,160 - Will retry 4 time(s), caught exception: Error getting HDP_Cluster2_hive repository for component hive. Http status code - 401. {"statusCode":401,"msgDesc":"Authentication Failed"}. Sleeping for 8 sec(s)

2017-08-17 18:44:14,741 - Will retry 3 time(s), caught exception: Error getting HDP_Cluster2_hive repository for component hive. Http status code - 401. {"statusCode":401,"msgDesc":"Authentication Failed"}. Sleeping for 8 sec(s)

____________________________________________________________________________

If I understand right I need to updated the ranger plugin properties in Hive. But i'm not sure which one. Please let me know how do I go about fixing the issue. Thanks

31381-ambarihdphiveranger.png

2 REPLIES 2
Highlighted

Re: In Hive properties, which Ranger property has to updated when 'Ranger Admin username for Ambari (ranger_admin_username)' is updated in Rnager Admin Settings?

@Gaurav Mallikarjuna

Try to import the ranger-plugin-truststore.jks file to Ambari truststore. Hope that solves your problem. You can use below link for instructions to import truststore.

Highlighted

Re: In Hive properties, which Ranger property has to updated when 'Ranger Admin username for Ambari (ranger_admin_username)' is updated in Rnager Admin Settings?

@Sridhar Reddy can you please share the link?