-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/56916/
-----------------------------------------------------------
(Updated Feb. 28, 2017, 2:21 p.m.)
Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay
Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj,
Sailaja Polavarapu, and Velmurugan Periasamy.
Changes
-------
Addressed review comments
Bugs: RANGER-1401
https://issues.apache.org/jira/browse/RANGER-1401
Repository: ranger
Description
-------
**Problem Statement:** Ranger installation with SQL Server DB Flavor may take
lot of time in Azure environment due to latency issue.
**Proposed Solution :** A consolidated db schema script for SQLServer DB flavor
would be required as execution of db patches and java patches takes lot of
time. Before installing Ranger User can separately run this script to reduce db
setup and installation time.
Diffs (updated)
-----
security-admin/db/sqlserver/optimized/0.7.0/ranger_core_db_sqlserver.sql
PRE-CREATION
security-admin/db/sqlserver/xa_core_db_sqlserver.sql 89dfbf6
Diff: https://reviews.apache.org/r/56916/diff/
Testing
-------
1) Executed DBA Setup and ensured that ranger-admin database and ranger-admin
DB user are created.
2) From a MSSQL Client tool executed ranger_core_db_sqlserver.sql file on
database created in previous step.
3) Executed DB setup and java patches execution command.
**Expected Behaviour :** Ranger setup process should skip the DB schema
creation and java patch execution. Ranger UI should work properly after
starting Ranger admin.
**Actual Behaviour :** DB schema creation and java patch execution was skipped
and patches were marked executed in x_db_version_h table. After Starting Ranger
admin, I was able to do crud operations related to users and policy.
Thanks,
Pradeep Agrawal
