Child pages
  • Errata - 1.12.0 MySQL SUPER priv required for database upgrade

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.