Gautam, Your great description and testing are highly appreciated. Thanks Dilli
On Wed, Dec 9, 2015 at 7:44 AM, Velmurugan Periasamy < [email protected]> wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/41128/#review109532 > ----------------------------------------------------------- > > Ship it! > > > Ship It! > > - Velmurugan Periasamy > > > On Dec. 9, 2015, 12:05 p.m., Gautam Borad wrote: > > > > ----------------------------------------------------------- > > This is an automatically generated e-mail. To reply, visit: > > https://reviews.apache.org/r/41128/ > > ----------------------------------------------------------- > > > > (Updated Dec. 9, 2015, 12:05 p.m.) > > > > > > Review request for ranger, Alok Lal, Don Bosco Durai, Abhay Kulkarni, > Madhan Neethiraj, Ramesh Mani, Selvamohan Neethiraj, and Velmurugan > Periasamy. > > > > > > Bugs: RANGER-776 > > https://issues.apache.org/jira/browse/RANGER-776 > > > > > > Repository: ranger > > > > > > Description > > ------- > > > > **Problem Statement:** > > Ranger tagsync code uses 'rangertagsync' user to sync Tags in Ranger > Policy manager. For this the 'rangertagsync' user should be created at the > time of Ranger installation. > > SQL patch to create 'rangertagsync' user is available currently only for > MySQL and Oracle DB. Since Ranger can run on Postgres, SQL-Anywhere and > MSSQL Server, it is expected that support be extended to these DB. > > Since currently Ranger doesnt have a script to create the > 'rangertagsync' user for Postgres/SQL-Anywhere and MSSQL Server, tagsync > will not work unless the user is created manually from Ranger UI. > > > > **Proposed Solution:** > > Create separate SQL patches for Postgres, SQL-Anywhere and MSSQL Server > which will create 'rangertagsync' user in Ranger. > > > > > > Diffs > > ----- > > > > security-admin/db/mysql/patches/017-createtagsyncuser.sql 02a5285 > > security-admin/db/mysql/patches/018-createtagsyncuser.sql PRE-CREATION > > security-admin/db/oracle/patches/017-createtagsyncuser.sql 7b72262 > > security-admin/db/oracle/patches/018-createtagsyncuser.sql PRE-CREATION > > security-admin/db/postgres/patches/018-createtagsyncuser.sql > PRE-CREATION > > security-admin/db/sqlanywhere/patches/018-createtagsyncuser.sql > PRE-CREATION > > security-admin/db/sqlserver/patches/018-createtagsyncuser.sql > PRE-CREATION > > > > Diff: https://reviews.apache.org/r/41128/diff/ > > > > > > Testing > > ------- > > > > Steps performed : > > 1. Build Ranger by using mvn command. > > 2. Untar the generated Ranger tar file. > > 3. Changed configuration of install.properties according to local MySQL > DB server. > > 4. Run setup.sh to install Ranger. > > 5. During installation it was observed that sql patch '018' was executed > successfully. > > 6. Logged in to configured Ranger DB on MySQL server machine and it was > observed that 'rangertagsync' user was created in x_portal_user and x_user > table. > > > > > > Did above testing with Oracle, Postgres, SQL Server and SQL Anywhere DB > also in local environment. > > > > > > Thanks, > > > > Gautam Borad > > > > > >
