-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/46932/
-----------------------------------------------------------
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
https://issues.apache.org/jira/browse/RANGER-965
Repository: ranger
Description
-------
**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.
Diffs
-----
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/java/org/apache/ranger/patch/cliutil/DbToSolrMigrationUtil.java
9ce1a12
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
-------
**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)
Thanks,
Pradeep Agrawal
