When running the database upgrade from within Open-AudIT if you have master/slave replication configured, you may receive an error as follows:
| Code Block |
|---|
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 master) and run the following command.
| Code Block |
|---|
SET GLOBAL log_bin_trust_function_creators = 1; |
The run the Open-AudIT database upgrade, then revert the above command using:
| Code Block |
|---|
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.