Ranger service is failing to install

Question

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!

Scharan · Accepted Answer

@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

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.