----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/30760/ -----------------------------------------------------------
(Updated Feb. 19, 2015, 2:38 p.m.) Review request for ranger, Don Bosco Durai, Madhan Neethiraj, Ramesh Mani, Selvamohan Neethiraj, and Velmurugan Periasamy. Changes ------- updated patch after pluggable service model changes with a) oracle schema for pluggable service model. b) changed column name 'level' of table 'x_resource_def' to 'res_level' Bugs: RANGER-239 https://issues.apache.org/jira/browse/RANGER-239 Repository: ranger Description ------- Currently Ranger setup executes SQL scripts via SQL command line tools to create DB schema. Since it is not guaranteed to have SQL command line clients available on the host this becomes a prerequisite. This can be addressed by a tool that can execute SQL scripts via JDBC (currenly supports Mysql) Diffs (updated) ----- agents-common/pom.xml ede7b9d jisql/src/main/java/org/apache/util/sql/Jisql.java f3fab71 security-admin/db/create_dbversion_catalog.sql 9c90633 security-admin/db/create_dev_user.sh a59e264 security-admin/db/create_dev_user.sql bf475d0 security-admin/db/init/backup_mysql_db.sh ef66140 security-admin/db/init/create_dev_backup_mysql.sh db2e2a7 security-admin/db/init/create_dev_backup_mysql_loaded.sh c1905b6 security-admin/db/init/create_xa_core_db.sh 3c9483f security-admin/db/init/mysql_seed_data.sql 8f992b1 security-admin/db/init/reset_db.sh 8a7632d security-admin/db/init/reset_db_with_seed.sh 5670922 security-admin/db/init/schema_mysql.sql 1dd7420 security-admin/db/mysql/create_dbversion_catalog.sql PRE-CREATION security-admin/db/mysql/create_dev_user.sh PRE-CREATION security-admin/db/mysql/create_dev_user.sql PRE-CREATION security-admin/db/mysql/init/backup_mysql_db.sh PRE-CREATION security-admin/db/mysql/init/create_dev_backup_mysql.sh PRE-CREATION security-admin/db/mysql/init/create_dev_backup_mysql_loaded.sh PRE-CREATION security-admin/db/mysql/init/create_xa_core_db.sh PRE-CREATION security-admin/db/mysql/init/mysql_seed_data.sql PRE-CREATION security-admin/db/mysql/init/reset_db.sh PRE-CREATION security-admin/db/mysql/init/reset_db_with_seed.sh PRE-CREATION security-admin/db/mysql/init/schema_mysql.sql PRE-CREATION security-admin/db/mysql/patches/001-groupsource.sql PRE-CREATION security-admin/db/mysql/patches/002-policyname.sql PRE-CREATION security-admin/db/mysql/patches/003-knoxrepo.sql PRE-CREATION security-admin/db/mysql/patches/004-assetconfigsize.sql PRE-CREATION security-admin/db/mysql/patches/005-xtrxlogcolumnsize.sql PRE-CREATION security-admin/db/mysql/patches/006-createdefaultpublicgroup.sql PRE-CREATION security-admin/db/mysql/patches/007-updateBlankPolicyName.sql PRE-CREATION security-admin/db/mysql/patches/008-removeTrailingSlash.sql PRE-CREATION security-admin/db/mysql/patches/009-updated_schema.sql PRE-CREATION security-admin/db/mysql/reset_asset.sql PRE-CREATION security-admin/db/mysql/reset_audit_mysql.sh PRE-CREATION security-admin/db/mysql/reset_core_mysql.sh PRE-CREATION security-admin/db/mysql/resetdb_dev_mysql.sh PRE-CREATION security-admin/db/mysql/xa_audit_db.sql PRE-CREATION security-admin/db/mysql/xa_core_db.sql PRE-CREATION security-admin/db/mysql/xa_db.sql PRE-CREATION security-admin/db/mysql/xa_db_bare.sql PRE-CREATION security-admin/db/oracle/patches/001-groupsource.sql cda2d15 security-admin/db/oracle/patches/002-policyname.sql be20751 security-admin/db/oracle/patches/003-knoxrepo.sql 422649c security-admin/db/oracle/patches/006-createdefaultpublicgroup.sql 55c0cd5 security-admin/db/oracle/patches/009-updated_schema.sql PRE-CREATION security-admin/db/oracle/reset_audit_db_oracle.sql PRE-CREATION security-admin/db/oracle/reset_core_db_oracle.sql PRE-CREATION security-admin/db/oracle/xa_audit_db_oracle.sql 4e1a184 security-admin/db/oracle/xa_core_db_oracle.sql 449c461 security-admin/db/patches/001-groupsource.sql c49d8cb security-admin/db/patches/002-policyname.sql 35927f5 security-admin/db/patches/003-knoxrepo.sql 04c050a security-admin/db/patches/004-assetconfigsize.sql bec992b security-admin/db/patches/005-xtrxlogcolumnsize.sql 4ec9a6d security-admin/db/patches/006-createdefaultpublicgroup.sql ddb211e security-admin/db/patches/007-updateBlankPolicyName.sql d251bc2 security-admin/db/patches/008-removeTrailingSlash.sql 2e00f5f security-admin/db/patches/009-updated_schema.sql 401a1dc security-admin/db/reset_asset.sql 1d53819 security-admin/db/reset_audit_mysql.sh 51a5359 security-admin/db/reset_core_mysql.sh 26f7d46 security-admin/db/resetdb_dev_mysql.sh c2bf5fb security-admin/db/xa_audit_db.sql dba98ce security-admin/db/xa_core_db.sql 9d889a0 security-admin/db/xa_db.sql 4b2919f security-admin/db/xa_db_bare.sql 8204f1d security-admin/pom.xml 97606b6 security-admin/scripts/db_setup.py PRE-CREATION security-admin/scripts/install.properties b835bba security-admin/scripts/setup.sh e9b69a6 security-admin/src/main/java/org/apache/ranger/entity/XXEnumElementDef.java f2522f3 security-admin/src/main/java/org/apache/ranger/entity/XXResourceDef.java 7d5df92 src/main/assembly/admin-web.xml 8696252 Diff: https://reviews.apache.org/r/30760/diff/ Testing ------- Following testing was done to validate : 1] Create a tar with the attached patch 2] Copy tar to the host machine and perform install as per current design 3] Make sure the clients 'mysql' tool is not used in 2] above 4] After installation open localhost:6080 and login with admin/admin 5] Create a user/group and check if its persisted in db. Thanks, Gautam Borad