ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bhavik patel <bhavikpatel...@gmail.com>
Subject Review Request 64869: RANGER-1930 : Add consolidated db schema script for all supported DB flavor
Date Fri, 29 Dec 2017 09:51:29 GMT

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

Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay Kulkarni, Madhan
Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, Sailaja Polavarapu, and Velmurugan

Bugs: RANGER-1930

Repository: ranger


Currently Ranger installation with different DB Flavors are taking lot of time in some environment
due to execution of many db and java patches or due to latency issues.

To avoid this issue before installing Ranger, User can separately run this script to reduce
db setup and installation time.
1) Execute DBA setup and ensure that ranger-admin user & database are created.
2) From a Client tool execute ranger_core_db_<DB FLAVOR>.sql file on the database created
in previous step.
For Exampele : 
For mysql DB, run following command: 
mysql -u username -p database_name < /file_path/file.sql


  security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql PRE-CREATION 
  security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql PRE-CREATION 
  security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql PRE-CREATION 
  security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql PRE-CREATION

  security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql d5af82b 

Diff: https://reviews.apache.org/r/64869/diff/1/


After manually importing Ranger Schema from given patch: 
1) DB schema creation and java patch execution was skipped during Ranger installation and
patches were marked executed in x_db_version_h table (manual installation).
2) For Ambari based installs  of Ranger - start time for Ranger service reduces,as schema
was imported using given patch. 
3) Ranger Admin, Ranger KMS started successfully.
4) Also verified CRUD operations related to users/groups and policies/services.


bhavik patel

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