Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Ranger Audit not available in Ranger UI. Audits are visible in DB

Ranger Audit not available in Ranger UI. Audits are visible in DB

I have HDP 2.4 (9 node Cluster) and Ranger 0.5 with Apache ambari 2.2 version.

i'm trying to store ranger audits in Postgresql DB by applying Ranger Policy. Policy is applied successfully and audits are stored in Database in table "xa_access_audit" but those audits are not showing in Ranger UI.

I tried to store audits in solr and after installing solr and chaging ranger_audit_source_type : solr, audits are visible in UI but with DB it's not possible. I want to use DB instead of solr.

I have attached screenshot with config properties.

19542-advanced-ranger-admin-site1.png

19543-advanced-ranger-admin-site2.png

19544-advanced-ranger-hdfs-audit1.png

2 REPLIES 2
Highlighted

Re: Ranger Audit not available in Ranger UI. Audits are visible in DB

Expert Contributor
@Magesh Kumar

Check in xa_portal.log what error you get when you configure db.

Just FYI, DB is not supported anymore for Ranger audits and Solr is the option for you in later versions.

Highlighted

Re: Ranger Audit not available in Ranger UI. Audits are visible in DB

As @Ramesh Mani mentioned above, the best option is to move to use audit on Solr. DB Audit support is not available from HDP 2.5.

For this particular case, check if you have any error in xa_portal.log

Don't have an account?
Coming from Hortonworks? Activate your account here