MySQL Bugs: #75134: Setting variables for Audit plugin does not work

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:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	6.2.4	OS:	Windows
Assigned to:		CPU Architecture:	Any

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.

Hello Mario Beck,

Thank you for report.

Thanks,
Umesh

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.