【Ranger】ranger-1.2.0 ranger admin安装问题记录

发现问题

2021-12-14 20:09:28,460  [JISQL] /opt/dtstack/java/bin/java  -cp /opt/ranger/mysql-connector-java-5.1.27-bin.jar:/opt/ranger/ranger-1.2.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://172-16-82-76/ranger -u 'ranger' -p '********' -noheader -trim -c \; -query "insert into x_db_version_h (version, inst_at, inst_by, updated_at, updated_by,active) values ('006', now(), 'Ranger 1.2.0', now(), '172-16-82-76','N') ;"
2021-12-14 20:09:28,767  [I] Patch 006-createdefaultpublicgroup.sql is being applied..
2021-12-14 20:09:28,767  [JISQL] /opt/dtstack/java/bin/java  -cp /opt/ranger/mysql-connector-java-5.1.27-bin.jar:/opt/ranger/ranger-1.2.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://172-16-82-76/ranger -u 'ranger' -p '********' -noheader -trim -c \; -input /opt/ranger/ranger-1.2.0-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
2021-12-14 20:09:29,083  [JISQL] /opt/dtstack/java/bin/java  -cp /opt/ranger/mysql-connector-java-5.1.27-bin.jar:/opt/ranger/ranger-1.2.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://172-16-82-76/ranger -u 'ranger' -p '********' -noheader -trim -c \; -query "select version from x_db_version_h where version = '006' and active = 'Y';"
2021-12-14 20:09:29,402  [JISQL] /opt/dtstack/java/bin/java  -cp /opt/ranger/mysql-connector-java-5.1.27-bin.jar:/opt/ranger/ranger-1.2.0-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://172-16-82-76/ranger -u 'ranger' -p '********' -noheader -trim -c \; -query "delete from x_db_version_h where version='006' and active='N' and updated_by='172-16-82-76';"
2021-12-14 20:09:29,725  [E] 006-createdefaultpublicgroup.sql import failed!

找到问题

https://issues.apache.org/jira/browse/RANGER-2234
重新打包编译了下

结果还是各种报错，把我折磨的不行。这就是sql报错啊。。。。。

然后我根据上面的issue更改了代码，还是手改的结果编译打包后还是不行。绝了，是我姿势不对？

ok，我认栽了，换个方法。。。。
重新下载新的ranger1.2.0项目重新搞。

这些sql在开始和末尾加上这个参数然后重新编译打包。

凸(艹皿艹 )
终于好了。。。

另外，set auto_increment_increment=1;SQL加上这参数不好使（当然你也可以认为是我姿势问题），我之前一直尝试这个结果不行占用了我非常多时间。。