- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Problem installing Ranger
Created on ‎09-24-2015 04:06 AM - edited ‎08-19-2019 06:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
We ran into an error during Ranger installation on Mysql. Error 1071 the unique key is longer than 767 bytes. We could extend the innodb prefix to 3072 but this still means that no unique column can be longer than 767 and one of the unique key columns is 1024
anybody ran into this before?
Its not in the problem solving guide
Attaching the screen shot.
It’s Ambari-2.1.1 and HDP-2.3.0
Created ‎09-24-2015 04:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes. This is known issue. You can get around this by "pre-creating" the database ranger,ranger_audit with the latin1 character set.
create database ranger CHARACTER SET=latin1; create database ranger_audit CHARACTER SET=latin1;
Created ‎09-24-2015 04:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes. This is known issue. You can get around this by "pre-creating" the database ranger,ranger_audit with the latin1 character set.
create database ranger CHARACTER SET=latin1; create database ranger_audit CHARACTER SET=latin1;
Created ‎09-24-2015 04:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Indeed! We have an Apache JIRA created for it already and it is a prime candidate to get scheduled soon. In the meantime we are also working to have this documented in the interim.
Best,
Created ‎09-24-2015 07:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Applied this recently as well with MySql 5.5 instance with HA (Tungsten). Haven't seen the issue on 5.6 basic install.
