Last modified: 2014-08-27 19:59:38 UTC
Hello, when i try to create functions for the database i got the followin message, "ERROR 1419: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)" So i'd like to know if i can get the rights in order to implement functions. Thanks
Please provide exact steps to reproduce so somebody could follow the steps and face the same problem. This neither mentions "the database" nor any commands nor any information how to get there nor anything about the setup.
The database i'm refering to is named p50380g50790__wanderwiki and is associated with project wanderwiki on the tool server. I connect to it using my account on the tool lab : joffreyq and doing the following: - become wanderwiki - mysql --defaults-file="${HOME}"/replica.my.cnf -h tools-db p50380g50790__wanderwiki After this if i run the following command : DELIMITER $$ CREATE FUNCTION `new_function` () RETURNS INTEGER BEGIN RETURN 1; END I have this error: "ERROR 1418: 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)" So i tried the following command: CREATE FUNCTION `new_function` () RETURNS INTEGER DETERMINISTIC NO SQL BEGIN RETURN 1; END And had this error: "ERROR 1419: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)"
See also: https://bugzilla.wikimedia.org/show_bug.cgi?id=54653 Might be because binlogging is enabled on tools-db.
*** Bug 54653 has been marked as a duplicate of this bug. ***
It is (because binlogging is enabled). The new database in eqiad will allow function creation, and that is slated to be live at the end of January alongside the new migrated labs. If that is soon enough, I'd rather not fiddle with the already rickety tools-db (which lives in a VM with very limited resources), but I can probably do so if necessary.
This should be fixed now.