----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/73975/#review224424 -----------------------------------------------------------
Ship it! Ship It! - Mateen Mansoori On May 5, 2022, 12:18 p.m., Pradeep Agrawal wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/73975/ > ----------------------------------------------------------- > > (Updated May 5, 2022, 12:18 p.m.) > > > Review request for ranger, bhavik patel, Dhaval Shah, Abhay Kulkarni, Madhan > Neethiraj, Ramesh Mani, Sailaja Polavarapu, and Velmurugan Periasamy. > > > Bugs: RANGER-3747 > https://issues.apache.org/jira/browse/RANGER-3747 > > > Repository: ranger > > > Description > ------- > > **Problem statement:** While testing upgrade from ranger 0.7 to latest, found > that sql patch 037 for mysql is failing, also patch 051 is failing for > ms-sqlserver. > > **Proposed solution:** Sql script of both the patches need to be corrected to > avoid the failure cases. > > > Diffs > ----- > > security-admin/db/mysql/patches/037-create-security-zone-schema.sql > bc9921efe > security-admin/db/sqlserver/patches/051-update-datatype-to-nvarchar.sql > 9307a205c > > > Diff: https://reviews.apache.org/r/73975/diff/1/ > > > Testing > ------- > > 1) For mysql patch 037: Installed ranger admin 0.7 with mysql db flavor, > started ranger-admin service and created ranger service and policies. > Stopped ranger-admin. > Then Installed ranger-admin with patch and provided the same db configs used > in ranger 0.7 install. With proposed patch, sql patch 37 was applied and > installation finished successfully. > > 2) For mssql patch 051: Installed ranger admin 0.7 with mssql db flavor, > started ranger-admin service and created ranger service and policies. > Stopped ranger-admin. > Then Installed ranger-admin with patch and provided the same db configs used > in ranger 0.7 install. With proposed patch, sql patch 51 was applied and > installation finished successfully. > > > Thanks, > > Pradeep Agrawal > >
