Build Cache issue
Posted: Fri Oct 18, 2019 10:18 am
Hi.
I am having an issue that is replicated in a live and test environment where if I run 'Build Cache' option from the Admin Settings tab I get this error :
Capture.PNG (5.91 KiB) Viewed 4119 times
The 'Workflow Applications Cache Info' details shows current/root user not having SUPERUSER/SUPER Privileged (Highlighted in yellow) :
Capture2.PNG (44.63 KiB) Viewed 4119 times
Another live site running on an older Processmaker and MySQL version that does not have this issue shows this :
Capture1.PNG (45.21 KiB) Viewed 4119 times
I took a look at the log and the error generates this message :
Is it safe to make this change to log_bin_trust_function_creators or is there another solution?
Any help would be appreciated.
I am having an issue that is replicated in a live and test environment where if I run 'Build Cache' option from the Admin Settings tab I get this error :
The 'Workflow Applications Cache Info' details shows current/root user not having SUPERUSER/SUPER Privileged (Highlighted in yellow) :
Another live site running on an older Processmaker and MySQL version that does not have this issue shows this :
I took a look at the log and the error generates this message :
Code: Select all
ExceptionCron ERROR: Could not execute query [Native Error: 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)]Is it safe to make this change to log_bin_trust_function_creators or is there another solution?
Any help would be appreciated.