Re: Review Request 64869: RANGER-1930 : Add consolidated db schema script for all supported DB flavor
--- 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_.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 > >
Re: Review Request 64869: RANGER-1930 : Add consolidated db schema script for all supported DB flavor
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/64869/#review195512 --- Ship it! Ship It! - Velmurugan Periasamy 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_.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 > >
Re: Review Request 64869: RANGER-1930 : Add consolidated db schema script for all supported DB flavor
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/64869/#review195443 --- Ship it! Ship It! - Pradeep Agrawal 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_.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 > >
Review Request 64869: RANGER-1930 : Add consolidated db schema script for all supported DB flavor
--- 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_.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
