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.
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