ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pradeep Agrawal <pradeep.agra...@freestoneinfotech.com>
Subject Re: Review Request 47158: RANGER-965 : Validate Audit DB to Solr Migration script from any previous version to 0.6 upgrade
Date Mon, 16 May 2016 04:09:22 GMT

This is an automatically generated e-mail. To reply, visit:

(Updated May 16, 2016, 4:09 a.m.)

Review request for ranger, Alok Lal, Don Bosco Durai, Gautam Borad, Abhay Kulkarni, Madhan
Neethiraj, Ramesh Mani, Selvamohan Neethiraj, and Velmurugan Periasamy.


Update Reviewers list

Bugs: RANGER-965

Repository: ranger


Problem Statement : 
Currently migration script can migrate Audit DB log to Solr only if 'xa_access_audit' table
schema is updated according to 0.6 version. Ranger should support migration of Access audit
logs from previous version also.

Proposed Solution :
Before starting migration process java code will fetch columns of 'xa_access_audit' table
using native query; Received columns name and its count can be used to decide on which version
of Ranger 'xa_access_audit' table was created; Separate sql statement for underligned version
of 'xa_access_audit' can be executed to fetch audit logs from 'xa_access_audit' table.


  security-admin/src/main/java/org/apache/ranger/biz/RangerPolicyRetriever.java ec4f165 
  security-admin/src/main/java/org/apache/ranger/common/AppConstants.java e9c7ac0 
  security-admin/src/main/java/org/apache/ranger/db/XXAccessAuditDao.java 432dfa9 
  security-admin/src/main/java/org/apache/ranger/entity/XXAccessAudit.java 96859a7 
  security-admin/src/main/java/org/apache/ranger/entity/XXAccessAuditBase.java PRE-CREATION

  security-admin/src/main/java/org/apache/ranger/entity/XXAccessAuditV4.java PRE-CREATION

  security-admin/src/main/java/org/apache/ranger/entity/XXAccessAuditV5.java PRE-CREATION

  security-admin/src/main/resources/META-INF/jpa_named_queries.xml f209bc4 
  security-admin/src/main/resources/conf.dist/ranger-admin-default-site.xml 0d6679c 
  security-admin/src/main/webapp/META-INF/applicationContext.xml 17f35a2 
  tagsync/src/main/java/org/apache/ranger/tagsync/process/TagSyncConfig.java e51d165 

Diff: https://reviews.apache.org/r/47158/diff/


Tested following use cases : 
1. Ranger 0.4 to 0.6 (MySQL DB Flavor) 
2. Ranger 0.4 to 0.6 (Oracle DB Flavor) 
3. Ranger 0.5 to 0.6 (MySQL DB Flavor) 
4. Ranger 0.5 to 0.6 (Oracle DB Flavor) 
5. Ranger 0.5 to 0.6 (Postgres DB Flavor) 
6. Ranger 0.5 to 0.6 (SQLAnywhere DB Flavor) 
7. Ranger 0.5 to 0.6 (MSSQL Server DB Flavor)


Pradeep Agrawal

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message