ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gautam Borad" <gbo...@gmail.com>
Subject Review Request 41128: RANGER-776 : Write sql patch to create Ranger user 'rangertagsync' for all DB
Date Wed, 09 Dec 2015 12:05:16 GMT

This is an automatically generated e-mail. To reply, visit:

Review request for ranger, Alok Lal, Don Bosco Durai, Abhay Kulkarni, Madhan Neethiraj, Ramesh
Mani, Selvamohan Neethiraj, and Velmurugan Periasamy.

Bugs: RANGER-776

Repository: ranger


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


  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/


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.


Gautam Borad

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