You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "peng.jianhua (JIRA)" <ji...@apache.org> on 2017/07/25 03:58:00 UTC
[jira] [Updated] (RANGER-1710) When setup cannot execute
007-updateBlankPolicyName.sql
[ https://issues.apache.org/jira/browse/RANGER-1710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
peng.jianhua updated RANGER-1710:
---------------------------------
Description:
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
> When setup cannot execute 007-updateBlankPolicyName.sql
> --------------------------------------------------------
>
> 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)