Ranger UI is still showing the old policies after a reinstall

[#1]

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.

[#2 · Accepted solution]

@Chiranjeevi Nimmala

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 DB name
• Ranger DB username
• Ranger DB host
• Ranger DB password
• Driver class name for a JDBC Ranger database
• JDBC connect string for a Ranger database

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

[#3]

@Geoffrey Shelton Okot

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