-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/64869/
-----------------------------------------------------------
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 Periasamy.
Bugs: RANGER-1930
https://issues.apache.org/jira/browse/RANGER-1930
Repository: ranger
Description
-------
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
Diffs
-----
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/
Testing
-------
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.
Thanks,
bhavik patel
