[RANGER-1788] Install Ranger admin failure.

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.7.0, 1.0.0, master, 0.7.1
• Fix Version/s: 1.0.0, 0.7.2
• Component/s: admin
• Labels: patch
• Flags: Patch, Important
• Assignee: peng.jianhua
• Reporter: peng.jianhua
• Created: 16/Sep/17 23:32
• Updated: 19/Sep/17 14:01
• Resolved: 19/Sep/17 14:01

Description

1. Fetch latest source using "git clone https://git-wip-us.apache.org/repos/asf/ranger.git" command.
2. Build.
3. Install Ranger admin.
Error information is as following:

2017-09-16 23:39:54,695  [E] 028-add-unique-constraint-on-table-x_group.sql import failed!

Execute 028-add-unique-constraint-on-table-x_group.sql file separately, there are following:

1. error code:1314
ALTER VIEW is not allowed in stored procedures
2. error code:1305
PROCEDURE ranger.create_unique_constraint_on_groupname does not exist

This issue was introduced by the RANGER-1765.

mysql> source /diskc/installranger/run/ranger-1.0.0-admin/db/mysql/patches/028-add-unique-constraint-on-table-x_group.sql
Query OK, 0 rows affected, 1 warning (0.00 sec)
ERROR 1314 (0A000): ALTER VIEW is not allowed in stored procedures
ERROR 1305 (42000): PROCEDURE ranger.create_unique_constraint_on_groupname does not exist
Query OK, 0 rows affected, 1 warning (0.00 sec)

Reason:

As of MySQL 5.7.4, the IGNORE clause for ALTER TABLE is removed and its use produces an error.

Issue Links

• links to: https://reviews.apache.org/r/62372/