[
https://issues.apache.org/jira/browse/RANGER-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pradeep Agrawal updated RANGER-1912:
------------------------------------
Description:
Ranger Admin installation fails when using MariaDB/MySQL with binary logging
enabled.
The install should work even if binary logging is enabled.
A workaround to solve this by modifying the global MySQL configuration
attribute log_bin_trust_function_creators = 1.
Proposed Solution: Currently MySQL DB patch 007 and 008 is having MySQL UDF
functions which are not DETERMINISTIC
When you create a stored function, you must declare either that it is
deterministic or that it does not modify data. Otherwise, it may be unsafe for
data recovery or replication.
By default, for a CREATE FUNCTION statement to be accepted, at least one of
DETERMINISTIC, NO SQL, or READS SQL DATA must be specified explicitly.
Otherwise an error occurs:
was:
Ranger Admin installation fails when using MariaDB/MySQL with binary logging
enabled.
The install should work even if binary logging is enabled.
A workaround to solve this by modifying the global MySQL configuration
attribute log_bin_trust_function_creators = 1.
Proposed Solution: Currently MySQL db patch 007 and 008 is having MySQL UDF
functions which are not DETERMINISTIC
When you create a stored function, you must declare either that it is
deterministic or that it does not modify data. Otherwise, it may be unsafe for
data recovery or replication.
By default, for a CREATE FUNCTION statement to be accepted, at least one of
DETERMINISTIC, NO SQL, or READS SQL DATA must be specified explicitly.
Otherwise an error occurs:
> Ranger setup fails with mariadb/mysql when binary logging is enabled
> --------------------------------------------------------------------
>
> Key: RANGER-1912
> URL: https://issues.apache.org/jira/browse/RANGER-1912
> Project: Ranger
> Issue Type: Bug
> Components: Ranger
> Affects Versions: 0.4.0, 0.5.0, 0.6.0, 0.7.0
> Reporter: Pradeep Agrawal
> Assignee: Pradeep Agrawal
> Fix For: 1.0.0
>
>
> Ranger Admin installation fails when using MariaDB/MySQL with binary logging
> enabled.
> The install should work even if binary logging is enabled.
> A workaround to solve this by modifying the global MySQL configuration
> attribute log_bin_trust_function_creators = 1.
> Proposed Solution: Currently MySQL DB patch 007 and 008 is having MySQL UDF
> functions which are not DETERMINISTIC
> When you create a stored function, you must declare either that it is
> deterministic or that it does not modify data. Otherwise, it may be unsafe
> for data recovery or replication.
> By default, for a CREATE FUNCTION statement to be accepted, at least one of
> DETERMINISTIC, NO SQL, or READS SQL DATA must be specified explicitly.
> Otherwise an error occurs:
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
