Created 06-20-2018 06:33 PM
Dear experts,
Due to some problem, we have reinstalled the Ranger and KMS services. However , if i open the ranger UI , it is still showing the old policies and even the ranger admin passwords are not getting changed.
Kindly help on what might be the issue.
Created 06-21-2018 02:21 AM
During the re-install did you drop and recreate a fresh ranger database? If you created a new DB then
Stop ranger then navigate to Ambari UI--->Ranger--->Configs--->Ranger Admin
Ensure the following match your new DB/Host
Ranger maintains policy related data in x_policy * tables ! to see which policies are enabled run the below SQL if you backend DB is Mysql else choose the appropriate syntax as the ranger DB owner
mysql> select name,is_enabled from x_policy;
Here is a link to manage the policies using REST APIs for Service Definition, Service and Policy Management
HTH
Created 06-21-2018 02:21 AM
During the re-install did you drop and recreate a fresh ranger database? If you created a new DB then
Stop ranger then navigate to Ambari UI--->Ranger--->Configs--->Ranger Admin
Ensure the following match your new DB/Host
Ranger maintains policy related data in x_policy * tables ! to see which policies are enabled run the below SQL if you backend DB is Mysql else choose the appropriate syntax as the ranger DB owner
mysql> select name,is_enabled from x_policy;
Here is a link to manage the policies using REST APIs for Service Definition, Service and Policy Management
HTH
Created 06-22-2018 02:03 AM
thanks for you reply. I have used the same database for reinstalling the Ranger. I was assuming that Ranger will delete all of its tables during the uninstallation