question Ranger UI is still showing the old policies after a reinstall in Archives of Support Questions (Read Only)

Ranger UI is still showing the old policies after a reinstall

chiru_tnk — Thu, 21 Jun 2018 01:33:46 GMT

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.

Re: Ranger UI is still showing the old policies after a reinstall

Shelton — Thu, 21 Jun 2018 09:21:35 GMT

@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

Re: Ranger UI is still showing the old policies after a reinstall

chiru_tnk — Fri, 22 Jun 2018 09:03:06 GMT

@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