ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Velmurugan Periasamy" <vperias...@hortonworks.com>
Subject Re: Review Request 41128: RANGER-776 : Write sql patch to create Ranger user 'rangertagsync' for all DB
Date Wed, 09 Dec 2015 15:44:54 GMT

-----------------------------------------------------------
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
> 
>


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message