Ranger 安装报错日志

最新推荐文章于 2024-09-21 09:30:00 发布

原创

最新推荐文章于 2024-09-21 09:30:00 发布 · 1.7k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#ranger #apache ranger

博客内容涉及在MySQL中遇到的函数创建错误，由于`log_bin_trust_function_creators`参数设置为OFF导致。通过修改该变量为ON解决了问题，但之后在安装Ranger时仍遇到数据库导入失败。最终通过删除Ranger数据库并重新安装成功启动服务。

1，导入失败，log_bin_trust_function_creators 为 OFF

Error executing: CREATE FUNCTION `getXportalUIdByLoginId`(input_val VARCHAR(100)) RETURNS int(11) BEGIN DECLARE myid INT; SELECT x_portal_user.id into myid FROM x_portal_user WHERE x_portal_user.login_id = input_val; RETURN myid; END  
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
2022-01-04 10:38:19,847  [E] ranger_core_db_mysql.sql file import failed!
2022-01-04 10:38:19,848  [I] Unable to create DB schema, Please drop the database and try again
2022-01-04 10:38:19,848 &nb