When running the database upgrade from within Open-AudIT if you have MySQL Primary/poller replication configured, you may receive an error as follows:
A Database Error Occurred Error Number: 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) CREATE FUNCTION cidr_to_mask (cidr INT(2)) RETURNS CHAR(15) DETERMINISTIC RETURN INET_NTOA(CONV(CONCAT(REPEAT(1,cidr),REPEAT(0,32-cidr)),2,10)) Filename: controllers/admin.php Line Number: 4994
The solution to this is to log in to the MySQL server as root (on the Primary) and run the following command.
SET GLOBAL log_bin_trust_function_creators = 1;
The run the Open-AudIT database upgrade, then revert the above command using:
SET GLOBAL log_bin_trust_function_creators = 0;
The issue is the binary logging used in replication, as described on this page http://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html.