ranger-dev mailing list archives

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

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

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

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/db/mysql/patches/022-split-service-table.sql 962e715 
  security-admin/db/oracle/patches/022-split-service-table.sql 7059be2 
  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/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 6e2902e 

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


**Testing Done (with patch) :**
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