Bug #75134 Setting variables for Audit plugin does not work
Submitted: 6 Dec 2014 16:32 Modified: 7 Dec 2014 8:33
Reporter: Mario Beck Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:6.2.4 OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[6 Dec 2014 16:32] Mario Beck
Description:
The server variables for audit plugin are displayed but can not be edited.
Some can be changed, some not:

audit_log_buffer_size can be edited but value is not stored.
audit_log_connection_policy can be edited but value is not stored.

audit_log_current_session: The value that is displayed is the global value. This one is not used by the plugin. The local value must be displayed.

audit_log_exclude_accounts can be edited but is not changed in the server although it is a dynamic variable.
...
audit_log_policy can be changed but results in an SQL error. The variable is no longer dynamic in versions >=5.6.21

How to repeat:
Connect with workbench to a MySQL 5.6.21 server, install and activate audit plugin. Try to modify values.

Suggested fix:
Workbench should allow editing for rw variables. This depends on the server release. It seems workbench has a wrong repository of server variables.

Workbench only displays global variables. audit_log_current_session is useless as a global variable. Either workbench displays the local value or omits this variable or the description string explains the issue with local/global.
[7 Dec 2014 8:33] Umesh Shastry
Hello Mario Beck,

Thank you for report.

Thanks,
Umesh