> On Aug. 2, 2024, 5:28 a.m., Pradeep Agrawal wrote: > > Ship It!
I have Tested upgrade from ranger 2.4 to 2.5 with this patch in mysql and postgresql db and upgrade completed successfully. - Pradeep ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/75136/#review226763 ----------------------------------------------------------- On Aug. 2, 2024, 1:33 a.m., Madhan Neethiraj wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/75136/ > ----------------------------------------------------------- > > (Updated Aug. 2, 2024, 1:33 a.m.) > > > Review request for ranger, Anand Nadar, Asit Vadhavkar, bhavik patel, Kishor > Gollapalliwar, Abhay Kulkarni, Mehul Parikh, Mugdha Varadkar, Pradeep > Agrawal, Ramesh Mani, Sailaja Polavarapu, Subhrat Chaudhary, and Velmurugan > Periasamy. > > > Bugs: RANGER-4885 > https://issues.apache.org/jira/browse/RANGER-4885 > > > Repository: ranger > > > Description > ------- > > - added DB patches to add following in the database schema during upgrade > -- view: vx_principal > -- column: x_access_type_def.category > -- column: x_security_zon.gz_jsondata > > > Diffs > ----- > > security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql > deecac27e > security-admin/db/mysql/patches/068-create-view-principal.sql PRE-CREATION > security-admin/db/mysql/patches/069-add-gz_json_x_security_zone.sql > PRE-CREATION > security-admin/db/mysql/patches/072-alter-x_access_type_def.sql > PRE-CREATION > security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql > aa64b48e5 > security-admin/db/oracle/patches/068-create-view-principal.sql PRE-CREATION > security-admin/db/oracle/patches/069-add-gz_json_x_security_zone.sql > PRE-CREATION > security-admin/db/oracle/patches/072-alter-x_access_type_def.sql > PRE-CREATION > security-admin/db/oracle/patches/077-create-x_trx_log_v2.sql > security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql > 2eec8aafd > security-admin/db/postgres/patches/068-create-view-principal.sql > PRE-CREATION > security-admin/db/postgres/patches/069-add-gz_json_x_security_zone.sql > PRE-CREATION > security-admin/db/postgres/patches/072-alter-x_access_type_def.sql > PRE-CREATION > > security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql > 1d276fb85 > security-admin/db/sqlanywhere/patches/067-create-x_trx_log_v2.sql > security-admin/db/sqlanywhere/patches/068-create-view-principal.sql > PRE-CREATION > security-admin/db/sqlanywhere/patches/069-add-gz_json_x_security_zone.sql > PRE-CREATION > security-admin/db/sqlanywhere/patches/072-alter-x_access_type_def.sql > PRE-CREATION > security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql > c49d4c09c > security-admin/db/sqlserver/patches/067-create-x_trx_log_v2.sql > security-admin/db/sqlserver/patches/068-create-view-principal.sql > PRE-CREATION > security-admin/db/sqlserver/patches/069-add-gz_json_x_security_zone.sql > PRE-CREATION > security-admin/db/sqlserver/patches/072-alter-x_access_type_def.sql > PRE-CREATION > > > Diff: https://reviews.apache.org/r/75136/diff/1/ > > > Testing > ------- > > - verified build with unit tests complete successfully > - verified upgrading from 2.4.0 to 2.5.0, with Postgres and MySQL databases > - verified fresh install of 2.5.0, with Postgres and MySQL databases > > > Thanks, > > Madhan Neethiraj > >
