Support Questions

Find answers, ask questions, and share your expertise

Ranger UI is still showing the old policies after a reinstall

avatar
Contributor

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.

1 ACCEPTED SOLUTION

avatar
Master Mentor

@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

View solution in original post

2 REPLIES 2

avatar
Master Mentor

@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

avatar
Contributor
@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