----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/73818/#review224011 -----------------------------------------------------------
Ship it! Ship It! - bhavik patel On Jan. 24, 2022, 11:55 a.m., Pradeep Agrawal wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/73818/ > ----------------------------------------------------------- > > (Updated Jan. 24, 2022, 11:55 a.m.) > > > Review request for ranger, bhavik patel, Dhaval Shah, Dineshkumar Yadav, > Abhay Kulkarni, Mateen Mansoori, Madhan Neethiraj, Mahesh Bandal, Mateen > Mansoori, Mehul Parikh, Mateen Mansoori, Ramesh Mani, Sailaja Polavarapu, and > Velmurugan Periasamy. > > > Bugs: RANGER-3594 > https://issues.apache.org/jira/browse/RANGER-3594 > > > Repository: ranger > > > Description > ------- > > **Problem Statement:** Ranger Admin installation fails when using > MariaDB/MySQL with binary logging enabled. > The install should work even if binary logging is enabled. > > > **Proposed Solution:** We can remove usage of stored function and it can be > replaced with the stored procedure. > > > Diffs > ----- > > security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql > 28d57a086 > security-admin/db/mysql/patches/013-permissionmodel.sql 5bc4868fe > security-admin/db/mysql/patches/037-create-security-zone-schema.sql > 8c9e0739f > > security-admin/db/mysql/patches/046-insert-statename-in-x-ranger-global-state.sql > d9cc6501a > > > Diff: https://reviews.apache.org/r/73818/diff/1/ > > > Testing > ------- > > **Steps Performed (with patch) :** > 1. Enabled binary logging in mysql and restarted mysql service. > 2. After mvn Build; untar the Ranger module and updated install.properties > for MySQL DB flavor. > 2. Called setup.sh to install Ranger. > > > **Expected Behavior :** > 1. Ranger installation should finish successfully and db patches should get > applied successfully. > 2. Ranger UI should work. > > > **Actual Behavior :** > 1. Ranger Installtion finished successfully and db patch was applied > successfully. > 2. Started Ranger Admin and was able to login in Ranger UI. > > > Also tested the upgrade case from 2.0 to 3.0 and patches are applying > successfully. > > > Thanks, > > Pradeep Agrawal > >
