----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/63115/#review188537 -----------------------------------------------------------
Ship it! Ship It! - Velmurugan Periasamy On Oct. 18, 2017, 5:21 p.m., Pradeep Agrawal wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/63115/ > ----------------------------------------------------------- > > (Updated Oct. 18, 2017, 5:21 p.m.) > > > Review request for ranger, Ankita Sinha, Don Bosco Durai, bhavik patel, > Gautam Borad, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, > Selvamohan Neethiraj, Sailaja Polavarapu, and Velmurugan Periasamy. > > > Bugs: RANGER-1820 > https://issues.apache.org/jira/browse/RANGER-1820 > > > Repository: ranger > > > Description > ------- > > **Problem Statement:** DB schema script updated through RR-62717 does not > have new db patch entry(029) in optimized sql server script. Similarly java > patch J10008 and J10011 need to be added. > > **Proposed Solution:** Proposed solution is having insert statement for sql > patch 029 and java patch J10008,J10011 in > security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql > file. > > **Note:** Patch for master branch shall be different than ranger-0.7 branch > patch as master branch script is already having changes related to java patch > J10008. Proposed patch for master branch is attached in Apache Jira > RANGER-1820. > > > Diffs > ----- > > security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql > 27257e3 > > > Diff: https://reviews.apache.org/r/63115/diff/1/ > > > 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 > security-admin/db/sqlserver/optimized/current/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. > > > Thanks, > > Pradeep Agrawal > >
