Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

can't install ranger

Solved Go to solution
Highlighted

can't install ranger

New Contributor

[I] Patch 006-createdefaultpublicgroup.sql is being applied..

2018-08-25 21:48:33,172  [JISQL] /usr/bin/java  -cp /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java-5.1.25-bin.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://host/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -input /usr/hdp/current/ranger-admin/db/mysql/patches/006-createdefaultpublicgroup.sql
Error executing: call insert_public_group_in_x_group_table(); 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`ranger`.`x_group`, CONSTRAINT `x_group_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`))
SQLException : SQL state: 23000 com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`ranger`.`x_group`, CONSTRAINT `x_group_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`)) ErrorCode: 1452
2018-08-25 21:48:33,618  [JISQL] /usr/bin/java  -cp /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java-5.1.25-bin.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://xxx/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = '006' and active = 'Y';"
2018-08-25 21:48:34,038  [JISQL] /usr/bin/java  -cp /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java-5.1.25-bin.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://xxx/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \; -query "delete from x_db_version_h where version='006' and active='N' and updated_by='xxx';"
2018-08-25 21:48:34,483  [E] 006-createdefaultpublicgroup.sql import failed!
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: can't install ranger

Mentor

@li Hao

Can you try setting up a new database for Ranger? Here the assumption is the:

Root password is test2345

Ranger user, database and password is ranger

##################################################
# Create the ranger user and database schema.
##################################################
mysql -u root -ptest2345
create user 'ranger'@'localhost' identified by 'ranger';
grant all privileges on *.* to 'ranger'@'%';
grant all privileges on *.* to 'ranger'@'localhost';
grant all privileges on *.* to 'ranger'@'fqdn';
grant all privileges on *.* to 'ranger'@'fqdn' identified by 'ranger' with grant option;
grant all privileges on *.* to 'ranger'@'localhost' identified by 'ranger' with grant option;
flush privileges;
quit; 

Log on as user ranger

##################################################
# As ranger user create the database
##################################################
mysql -u ranger -pranger
Create database ranger;
quit;

Now get back to the Ambari UI and retry installing Ranger all should be fine. Remember to drop that old database after successfully configuring ranger.

HTH

View solution in original post

5 REPLIES 5
Highlighted

Re: can't install ranger

New Contributor

ranger version 1.1.0

ambaris 2.7.0

hdp 3.0.0

Highlighted

Re: can't install ranger

Mentor

@li Hao

Can you try setting up a new database for Ranger? Here the assumption is the:

Root password is test2345

Ranger user, database and password is ranger

##################################################
# Create the ranger user and database schema.
##################################################
mysql -u root -ptest2345
create user 'ranger'@'localhost' identified by 'ranger';
grant all privileges on *.* to 'ranger'@'%';
grant all privileges on *.* to 'ranger'@'localhost';
grant all privileges on *.* to 'ranger'@'fqdn';
grant all privileges on *.* to 'ranger'@'fqdn' identified by 'ranger' with grant option;
grant all privileges on *.* to 'ranger'@'localhost' identified by 'ranger' with grant option;
flush privileges;
quit; 

Log on as user ranger

##################################################
# As ranger user create the database
##################################################
mysql -u ranger -pranger
Create database ranger;
quit;

Now get back to the Ambari UI and retry installing Ranger all should be fine. Remember to drop that old database after successfully configuring ranger.

HTH

View solution in original post

Highlighted

Re: can't install ranger

New Contributor

Thank you very much , btw does it must be a user named ranger

Highlighted

Re: can't install ranger

Mentor

@li Hao

Great it worked for you... NOT really you can use any name you wish I just used it for convenience to enable identification between the component users/databases.


Re: can't install ranger

New Contributor

Hi , I have the same problem. Do you install hdp 3.0 with ranger successfully? It seems the table in the db [my db is mysql 5.7] has foreign key constraint.

Don't have an account?
Coming from Hortonworks? Activate your account here