Support Questions
Find answers, ask questions, and share your expertise

Ranger service is failing to install

Solved Go to solution

Ranger service is failing to install

New Contributor

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

Accepted Solutions

Re: Ranger service is failing to install

Expert Contributor

@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

Re: Ranger service is failing to install

New Contributor

Thanks a lot @Scharan this solution worked perfectly

View solution in original post

2 REPLIES 2

Re: Ranger service is failing to install

Expert Contributor

@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

Re: Ranger service is failing to install

New Contributor

Thanks a lot @Scharan this solution worked perfectly

View solution in original post