Support Questions

Find answers, ask questions, and share your expertise

Ranger service is failing to install

avatar

Ranger service is failing to install with below error

 

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
2021-01-19 10:13:39,544 [E] ranger_core_db_mysql.sql file import failed!

2 ACCEPTED SOLUTIONS

avatar
Master Collaborator

@Harish-hadoop  try setting log_bin_trust_function_creators = 1 by using the below command in ranger db and retry installing the ranger service 

# SET GLOBAL log_bin_trust_function_creators = 1 

 

View solution in original post

avatar

Thanks a lot @Scharan this solution worked perfectly

View solution in original post

2 REPLIES 2

avatar
Master Collaborator

@Harish-hadoop  try setting log_bin_trust_function_creators = 1 by using the below command in ranger db and retry installing the ranger service 

# SET GLOBAL log_bin_trust_function_creators = 1 

 

avatar

Thanks a lot @Scharan this solution worked perfectly