Ranger service is failing to install

Harish-hadoop — Wed, 20 Jan 2021 15:27:36 GMT

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!

Re: Ranger service is failing to install

Scharan — Wed, 20 Jan 2021 15:31:22 GMT

@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

Re: Ranger service is failing to install

Harish-hadoop — Thu, 21 Jan 2021 14:29:29 GMT

Thanks a lot @Scharan this solution worked perfectly

question Re: Ranger service is failing to install in Support Questions

Ranger service is failing to install

Re: Ranger service is failing to install

Re: Ranger service is failing to install