-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/73818/
-----------------------------------------------------------
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
