1# Bug 1641910: Trying to set audit_log_exclude_accounts crashes server.
2
3call mtr.add_suppression("Plugin 'audit_log' init function returned error.");
4call mtr.add_suppression("Plugin 'audit_log' registration as a AUDIT failed.");
5
6--let $restart_parameters="restart: --audit_log_exclude_accounts='user@localhost'"
7--source include/restart_mysqld.inc
8
9SET GLOBAL audit_log_exclude_accounts='info@localhost';
10
11
12--let $restart_parameters="restart: --audit_log_include_accounts='user@localhost'"
13--source include/restart_mysqld.inc
14
15SET GLOBAL audit_log_include_accounts='info@localhost';
16
17
18--let $restart_parameters="restart: --audit_log_exclude_commands='alter_table'"
19--source include/restart_mysqld.inc
20
21SET GLOBAL audit_log_exclude_commands='insert';
22
23
24--let $restart_parameters="restart: --audit_log_include_commands='alter_table'"
25--source include/restart_mysqld.inc
26
27SET GLOBAL audit_log_include_commands='insert';
28
29
30--let $restart_parameters="restart: --audit_log_exclude_accounts='user@localhost' --audit_log_include_accounts='user@localhost'"
31--source include/restart_mysqld.inc
32
33# there should be no audit_log% variables shown
34SHOW VARIABLES LIKE 'audit_log%';
35
36
37--let $restart_parameters="restart: --audit_log_exclude_commands='delete' --audit_log_include_commands='delete'"
38--source include/restart_mysqld.inc
39
40# there should be no audit_log% variables shown
41SHOW VARIABLES LIKE 'audit_log%';
42
43
44--let $restart_parameters="restart: --audit_log_exclude_accounts='user@localhost' --audit_log_file=./directory/file"
45--source include/restart_mysqld.inc
46
47# there should be no audit_log% variables shown
48SHOW VARIABLES LIKE 'audit_log%';
49