Child pages
  • Errata - 1.12.0 MySQL SUPER priv required for database upgrade
Skip to end of metadata
Go to start of metadata

When running the database upgrade from within Open-AudIT if you have MySQL master/slave 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 master) 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.

 

  • No labels