Category Archives: Ranger

  • 0

Ranger admin install fails with “007-updateBlankPolicyName.sql import failed”

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 :

  1. SET GLOBAL log_bin_trust_function_creators = 1
  2. Reinstall again Ranger service.