mirror of
https://github.com/MariaDB/server.git
synced 2026-01-01 00:55:43 +01:00
f0c2753cd1
Setting a name for the the THD::security_ctx:user field for wsrep applier threads. With this, the audit log events related to wsrep applying will be written in the audit log. Using user name <wsrep_applier> for wsrep appliers. This is for having identical look with async replication, which uses: <replication_slave> for audit logging. Using same approach as async replication to replace the security_ctx user name with "system user" for processlist output. Commit has also a mtr test galera.MDEV-35511, to verify wsrep applier audit logging. The test does not install/uninstall audit log plugin, but loads the audit log plugin before the test. This is because uninstalling the audit log plugin gives a warning saying that plugin is busy and uninstall will be delayed until server shutdown. This anomaly must be because of the applier thread being active audit logger. Same problem with plugin uninstall happens also with async relication workers. If plugn would remain installed, the post test sanity check complains of mismatching state of pre and post test states, and test execution would fail for this.
34 lines
924 B
Text
Executable file
34 lines
924 B
Text
Executable file
--source include/galera_cluster.inc
|
|
|
|
if (!$SERVER_AUDIT_SO) {
|
|
skip No SERVER_AUDIT plugin;
|
|
}
|
|
|
|
# enable audit loggin in node 2
|
|
--connection node_2
|
|
SET GLOBAL server_audit_logging=ON;
|
|
|
|
# replicate CREATE and INSERT, these should be seen in the audit log
|
|
--connection node_1
|
|
CREATE TABLE t1(a INT);
|
|
INSERT INTO t1 VALUES (1);
|
|
|
|
--connection node_2
|
|
# make sure that the INSERT has been applied
|
|
--let $wait_condition = SELECT COUNT(*) = 1 FROM test.t1;
|
|
--source include/wait_condition.inc
|
|
|
|
--echo # Now checking the audit log
|
|
let $MYSQLD_DATADIR= `SELECT @@datadir`;
|
|
--replace_regex /[0-9]* [0-9][0-9]:[0-9][0-9]:[0-9][0-9]\,[^,]*\,/TIME,HOSTNAME,/ /\,[1-9][0-9]*\,/,1,/ /\,[1-9][0-9]*/,ID/
|
|
cat_file $MYSQLD_DATADIR/server_audit.log;
|
|
|
|
--echo # resetting the test state
|
|
SET GLOBAL server_audit_logging=DEFAULT;
|
|
|
|
--connection node_1
|
|
DROP TABLE t1;
|
|
|
|
#UNINSTALL PLUGIN server_audit;
|
|
|
|
remove_file $MYSQLD_DATADIR/server_audit.log;
|