----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/64869/#review195545 -----------------------------------------------------------
Ship it! Ship It! - Qiang Zhang On Dec. 29, 2017, 9:51 a.m., bhavik patel wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/64869/ > ----------------------------------------------------------- > > (Updated Dec. 29, 2017, 9:51 a.m.) > > > 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 > >