You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by Pradeep Agrawal <pr...@freestoneinfotech.com> on 2017/02/22 06:27:28 UTC
Review Request 56916: RANGER-1401 : Add consolidated db schema script
for SQLServer DB flavor
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/56916/
-----------------------------------------------------------
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-1401
https://issues.apache.org/jira/browse/RANGER-1401
Repository: ranger
Description
-------
**Problem Statement:** Ranger installation with SQL Server DB Flavor may take lot of time in Azure environment due to latency issue.
**Proposed Solution :** A consolidated db schema script for SQLServer DB flavor would be required as execution of db patches and java patches takes lot of time. Before installing Ranger User can separately run this script to reduce db setup and installation time.
Diffs
-----
security-admin/db/sqlserver/optimized/1.0.0/ranger_core_db_sqlserver.sql PRE-CREATION
security-admin/db/sqlserver/xa_core_db_sqlserver.sql 89dfbf6
Diff: https://reviews.apache.org/r/56916/diff/
Testing
-------
1) Executed DBA Setup and ensured that ranger-admin database and ranger-admin DB user are created.
2) From a MSSQL Client tool executed ranger_core_db_sqlserver.sql file on database created in previous step.
3) Executed DB setup and java patches execution command.
**Expected Behaviour :** Ranger setup process should skip the DB schema creation and java patch execution. Ranger UI should work properly after starting Ranger admin.
**Actual Behaviour :** DB schema creation and java patch execution was skipped and patches were marked executed in x_db_version_h table. After Starting Ranger admin, I was able to do crud operations related to users and policy.
Thanks,
Pradeep Agrawal
Re: Review Request 56916: RANGER-1401 : Add consolidated db schema
script for SQLServer DB flavor
Posted by Pradeep Agrawal <pr...@freestoneinfotech.com>.
> On Feb. 28, 2017, 3:49 a.m., Velmurugan Periasamy wrote:
> > security-admin/db/sqlserver/optimized/Ranger 0.7.0/ranger_core_db_sqlserver.sql, line 1
> > <https://reviews.apache.org/r/56916/diff/2/?file=1642385#file1642385line1>
> >
> > Do you need 'Ranger 0.7.0' in the path? Isn't '0.7.0' sufficient?
I made it like this because it is the output of 'ranger-admin version' command. I am fine with both. Please let me know if this need to be changed to '0.7.0' only.
- Pradeep
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/56916/#review166999
-----------------------------------------------------------
On Feb. 22, 2017, 10:16 a.m., Pradeep Agrawal wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/56916/
> -----------------------------------------------------------
>
> (Updated Feb. 22, 2017, 10:16 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-1401
> https://issues.apache.org/jira/browse/RANGER-1401
>
>
> Repository: ranger
>
>
> Description
> -------
>
> **Problem Statement:** Ranger installation with SQL Server DB Flavor may take lot of time in Azure environment due to latency issue.
>
> **Proposed Solution :** A consolidated db schema script for SQLServer DB flavor would be required as execution of db patches and java patches takes lot of time. Before installing Ranger User can separately run this script to reduce db setup and installation time.
>
>
> Diffs
> -----
>
> security-admin/db/sqlserver/optimized/Ranger 0.7.0/ranger_core_db_sqlserver.sql PRE-CREATION
> security-admin/db/sqlserver/xa_core_db_sqlserver.sql 89dfbf6
>
> Diff: https://reviews.apache.org/r/56916/diff/
>
>
> Testing
> -------
>
> 1) Executed DBA Setup and ensured that ranger-admin database and ranger-admin DB user are created.
> 2) From a MSSQL Client tool executed ranger_core_db_sqlserver.sql file on database created in previous step.
> 3) Executed DB setup and java patches execution command.
>
> **Expected Behaviour :** Ranger setup process should skip the DB schema creation and java patch execution. Ranger UI should work properly after starting Ranger admin.
> **Actual Behaviour :** DB schema creation and java patch execution was skipped and patches were marked executed in x_db_version_h table. After Starting Ranger admin, I was able to do crud operations related to users and policy.
>
>
> Thanks,
>
> Pradeep Agrawal
>
>
Re: Review Request 56916: RANGER-1401 : Add consolidated db schema
script for SQLServer DB flavor
Posted by Velmurugan Periasamy <vp...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/56916/#review166999
-----------------------------------------------------------
Fix it, then Ship it!
security-admin/db/sqlserver/optimized/Ranger 0.7.0/ranger_core_db_sqlserver.sql (line 1)
<https://reviews.apache.org/r/56916/#comment239102>
Do you need 'Ranger 0.7.0' in the path? Isn't '0.7.0' sufficient?
- Velmurugan Periasamy
On Feb. 22, 2017, 10:16 a.m., Pradeep Agrawal wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/56916/
> -----------------------------------------------------------
>
> (Updated Feb. 22, 2017, 10:16 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-1401
> https://issues.apache.org/jira/browse/RANGER-1401
>
>
> Repository: ranger
>
>
> Description
> -------
>
> **Problem Statement:** Ranger installation with SQL Server DB Flavor may take lot of time in Azure environment due to latency issue.
>
> **Proposed Solution :** A consolidated db schema script for SQLServer DB flavor would be required as execution of db patches and java patches takes lot of time. Before installing Ranger User can separately run this script to reduce db setup and installation time.
>
>
> Diffs
> -----
>
> security-admin/db/sqlserver/optimized/Ranger 0.7.0/ranger_core_db_sqlserver.sql PRE-CREATION
> security-admin/db/sqlserver/xa_core_db_sqlserver.sql 89dfbf6
>
> Diff: https://reviews.apache.org/r/56916/diff/
>
>
> Testing
> -------
>
> 1) Executed DBA Setup and ensured that ranger-admin database and ranger-admin DB user are created.
> 2) From a MSSQL Client tool executed ranger_core_db_sqlserver.sql file on database created in previous step.
> 3) Executed DB setup and java patches execution command.
>
> **Expected Behaviour :** Ranger setup process should skip the DB schema creation and java patch execution. Ranger UI should work properly after starting Ranger admin.
> **Actual Behaviour :** DB schema creation and java patch execution was skipped and patches were marked executed in x_db_version_h table. After Starting Ranger admin, I was able to do crud operations related to users and policy.
>
>
> Thanks,
>
> Pradeep Agrawal
>
>
Re: Review Request 56916: RANGER-1401 : Add consolidated db schema
script for SQLServer DB flavor
Posted by Pradeep Agrawal <pr...@freestoneinfotech.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/56916/
-----------------------------------------------------------
(Updated Feb. 28, 2017, 2:21 p.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.
Changes
-------
Addressed review comments
Bugs: RANGER-1401
https://issues.apache.org/jira/browse/RANGER-1401
Repository: ranger
Description
-------
**Problem Statement:** Ranger installation with SQL Server DB Flavor may take lot of time in Azure environment due to latency issue.
**Proposed Solution :** A consolidated db schema script for SQLServer DB flavor would be required as execution of db patches and java patches takes lot of time. Before installing Ranger User can separately run this script to reduce db setup and installation time.
Diffs (updated)
-----
security-admin/db/sqlserver/optimized/0.7.0/ranger_core_db_sqlserver.sql PRE-CREATION
security-admin/db/sqlserver/xa_core_db_sqlserver.sql 89dfbf6
Diff: https://reviews.apache.org/r/56916/diff/
Testing
-------
1) Executed DBA Setup and ensured that ranger-admin database and ranger-admin DB user are created.
2) From a MSSQL Client tool executed ranger_core_db_sqlserver.sql file on database created in previous step.
3) Executed DB setup and java patches execution command.
**Expected Behaviour :** Ranger setup process should skip the DB schema creation and java patch execution. Ranger UI should work properly after starting Ranger admin.
**Actual Behaviour :** DB schema creation and java patch execution was skipped and patches were marked executed in x_db_version_h table. After Starting Ranger admin, I was able to do crud operations related to users and policy.
Thanks,
Pradeep Agrawal
Re: Review Request 56916: RANGER-1401 : Add consolidated db schema
script for SQLServer DB flavor
Posted by Pradeep Agrawal <pr...@freestoneinfotech.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/56916/
-----------------------------------------------------------
(Updated Feb. 22, 2017, 10:16 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.
Changes
-------
Updated Patch for Ranger-0.7 branch
Bugs: RANGER-1401
https://issues.apache.org/jira/browse/RANGER-1401
Repository: ranger
Description
-------
**Problem Statement:** Ranger installation with SQL Server DB Flavor may take lot of time in Azure environment due to latency issue.
**Proposed Solution :** A consolidated db schema script for SQLServer DB flavor would be required as execution of db patches and java patches takes lot of time. Before installing Ranger User can separately run this script to reduce db setup and installation time.
Diffs (updated)
-----
security-admin/db/sqlserver/optimized/Ranger 0.7.0/ranger_core_db_sqlserver.sql PRE-CREATION
security-admin/db/sqlserver/xa_core_db_sqlserver.sql 89dfbf6
Diff: https://reviews.apache.org/r/56916/diff/
Testing
-------
1) Executed DBA Setup and ensured that ranger-admin database and ranger-admin DB user are created.
2) From a MSSQL Client tool executed ranger_core_db_sqlserver.sql file on database created in previous step.
3) Executed DB setup and java patches execution command.
**Expected Behaviour :** Ranger setup process should skip the DB schema creation and java patch execution. Ranger UI should work properly after starting Ranger admin.
**Actual Behaviour :** DB schema creation and java patch execution was skipped and patches were marked executed in x_db_version_h table. After Starting Ranger admin, I was able to do crud operations related to users and policy.
Thanks,
Pradeep Agrawal