Ranger admin install fails with “007-updateBlankPolicyName.sql import failed”
Category : Ranger
If you see following error during ranger install then no need to worry as you can solve it by following just one step.
2016-03-18 16:10:44,048 [JISQL] /usr/jdk64/jdk1.8.0_60/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://mysqldb/ranger -u ‘user’ -p ‘********’ -noheader -trim -c \; -input /usr/hdp/current/ranger-admin/db/mysql/patches/007-updateBlankPolicyName.sql
Resolution :
- SET GLOBAL log_bin_trust_function_creators = 1
- Reinstall again Ranger service.