[
https://issues.apache.org/jira/browse/RANGER-1710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
peng.jianhua updated RANGER-1710:
---------------------------------
Summary: When install ranger-1.0.0-SNAPSHOT-admin,execute ./setup.sh find
[E] 007-updateBlankPolicyName.sql import failed (was: When install
ranger-1.0.0-SNAPSHOT-admin,execute 007-updateBlankPolicyName.sql)
> When install ranger-1.0.0-SNAPSHOT-admin,execute ./setup.sh find [E]
> 007-updateBlankPolicyName.sql import failed
> ------------------------------------------------------------------------------------------------------------------
>
> Key: RANGER-1710
> URL: https://issues.apache.org/jira/browse/RANGER-1710
> Project: Ranger
> Issue Type: Bug
> Components: admin
> Affects Versions: 1.0.0
> Reporter: peng.jianhua
> Assignee: peng.jianhua
>
> 1.Scene：
> When I install ranger-1.0.0-SNAPSHOT-admin execute ./setup.sh
> Then The console prints out：
> java.sql.SQLException: This function has none of DETERMINISTIC, NO SQL, or
> READS SQL DATA in its declaration and binary logging is enabled (you *might*
> want to use the less safe log_bin_trust_function_creators variable)
> SQLException : SQL state: HY000 java.sql.SQLException: This function has none
> of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary
> logging is enabled (you *might* want to use the less safe
> log_bin_trust_function_creators variable) ErrorCode: 1418
> 2017-07-25 11:44:08,733 [JISQL] /home/glc/java/jdk1.7.80/bin/java -cp
> /usr/share/java/mysql-connector-java-5.1.39-bin.jar:/home/glc/ranger/ranger-1.0.0-SNAPSHOT-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://10.43.182.242/ranger245 -u 'root' -p '********' -noheader -trim
> -c \; -query "select version from x_db_version_h where version = '007' and
> active = 'Y';"
> 2017-07-25 11:44:09,379 [JISQL] /home/glc/java/jdk1.7.80/bin/java -cp
> /usr/share/java/mysql-connector-java-5.1.39-bin.jar:/home/glc/ranger/ranger-1.0.0-SNAPSHOT-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://10.43.182.242/ranger245 -u 'root' -p '********' -noheader -trim
> -c \; -query "delete from x_db_version_h where version='007' and active='N'
> and updated_by='super.com';"
> 2017-07-25 11:44:10,041 [E] 007-updateBlankPolicyName.sql import failed!
> 2.Solution：Modify file： 007-updateBlankPolicyName.sql
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
