Ranger service is failing to install

[#1]

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 solution]

@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 

[#3 · Accepted solution]

@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 

[#4 · Accepted solution]

Thanks a lot @Scharan this solution worked perfectly