> On Feb. 28, 2017, 3:49 a.m., Velmurugan Periasamy wrote: > > security-admin/db/sqlserver/optimized/Ranger > > 0.7.0/ranger_core_db_sqlserver.sql, line 1 > > <https://reviews.apache.org/r/56916/diff/2/?file=1642385#file1642385line1> > > > > Do you need 'Ranger 0.7.0' in the path? Isn't '0.7.0' sufficient?
I made it like this because it is the output of 'ranger-admin version' command. I am fine with both. Please let me know if this need to be changed to '0.7.0' only. - Pradeep ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/56916/#review166999 ----------------------------------------------------------- On Feb. 22, 2017, 10:16 a.m., Pradeep Agrawal wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/56916/ > ----------------------------------------------------------- > > (Updated Feb. 22, 2017, 10:16 a.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. > > > 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 > ----- > > security-admin/db/sqlserver/optimized/Ranger > 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 > >