mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2026-01-22 11:24:53 +01:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/plugins/r/server_audit.result
Sergei Golubchik 38828f2078 MDEV-37501 plugins.server_audit Fails in 12.1+ 
DISCONNECT audit record is added at some point after the actual
disconnect. To have it at the deterministic place in the log,
we have to wait for it to be added before continuing.
2025-09-30 22:20:40 +02:00

599 lines
32 KiB
Text
Raw Permalink Blame History

install plugin server_audit soname 'server_audit';
show variables like 'server_audit%';
Variable_name Value
server_audit_events
server_audit_excl_users
server_audit_file_buffer_size 0
server_audit_file_path server_audit.log
server_audit_file_rotate_now OFF
server_audit_file_rotate_size 1000000
server_audit_file_rotations 9
server_audit_incl_users
server_audit_logging OFF
server_audit_mode 0
server_audit_output_type file
server_audit_query_log_limit 1024
server_audit_sync_log_file OFF
server_audit_syslog_facility LOG_USER
server_audit_syslog_ident mysql-server_auditing
server_audit_syslog_info
server_audit_syslog_priority LOG_INFO
set global server_audit_file_path=null;
set global server_audit_incl_users=null;
set global server_audit_file_path='server_audit.log';
set global server_audit_output_type=file;
set global server_audit_file_path=REPEAT(REPEAT('new_file_name', 50), 50);
Warnings:
Warning 1 server_audit_file_path can't exceed FN_LEN characters.
set global server_audit_logging=on;
set global server_audit_incl_users= repeat("'root',", 10000);
ERROR 42000: Variable 'server_audit_incl_users' can't be set to the value of ''root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','...'
show variables like 'server_audit_incl_users';
Variable_name Value
server_audit_incl_users
set global server_audit_excl_users= repeat("'root',", 10000);
ERROR 42000: Variable 'server_audit_excl_users' can't be set to the value of ''root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','root','...'
show variables like 'server_audit_excl_users';
Variable_name Value
server_audit_excl_users
Line count in file: 5
connect con1,localhost,root,,mysql;
disconnect con1;
Line count in file: 7
connect(localhost,no_such_user,,mysql,MASTER_PORT,MASTER_SOCKET);
connect con1,localhost,no_such_user,,mysql;
ERROR 28000: Access denied for user 'no_such_user'@'localhost' (using password: NO)
Line count in file: 9
connection default;
set global server_audit_incl_users='odin, dva, tri';
create table t1 (id int);
set global server_audit_incl_users='odin, root, dva, tri';
create table t2 (id int);
set global server_audit_excl_users='odin, dva, tri';
Warnings:
Warning 1 User 'odin' is in the server_audit_incl_users, so wasn't added.
Warning 1 User 'dva' is in the server_audit_incl_users, so wasn't added.
Warning 1 User 'tri' is in the server_audit_incl_users, so wasn't added.
insert into t1 values (1), (2);
select * from t1;
id
1
2
set global server_audit_incl_users='odin, root, dva, tri';
insert into t2 values (1), (2);
select * from t2;
id
1
2
alter table t1 rename renamed_t1;
set global server_audit_events='connect,query';
select 1,
2,
# comment
3;
1 2 3
1 2 3
insert into t2 values (1), (2);
select * from t2;
id
1
2
1
2
select * from t_doesnt_exist;
ERROR 42S02: Table 'test.t_doesnt_exist' doesn't exist
syntax_error_query;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'syntax_error_query' at line 1
drop table renamed_t1, t2;
show variables like 'server_audit%';
Variable_name Value
server_audit_events CONNECT,QUERY
server_audit_excl_users
server_audit_file_buffer_size 0
server_audit_file_path server_audit.log
server_audit_file_rotate_now OFF
server_audit_file_rotate_size 1000000
server_audit_file_rotations 9
server_audit_incl_users odin, root, dva, tri
server_audit_logging ON
server_audit_mode 0
server_audit_output_type file
server_audit_query_log_limit 1024
server_audit_sync_log_file OFF
server_audit_syslog_facility LOG_USER
server_audit_syslog_ident mysql-server_auditing
server_audit_syslog_info
server_audit_syslog_priority LOG_INFO
set global server_audit_mode=1;
set global server_audit_events='';
create database sa_db;
Line count in file: 47
connect con1,localhost,root,,test;
create table t1 (id2 int);
insert into t1 values (1), (2);
select * from t1;
id2
1
2
drop table t1;
use sa_db;
create table sa_t1(id int);
insert into sa_t1 values (1), (2);
drop table sa_t1;
drop database sa_db;
disconnect con1;
Line count in file: 80
connection default;
create database sa_db;
use sa_db;
CREATE USER u1 IDENTIFIED BY 'pwd-123';
GRANT ALL ON sa_db TO u2 IDENTIFIED BY "pwd-321";
SET PASSWORD FOR u1 = PASSWORD('pwd 098');
CREATE USER u3 IDENTIFIED BY '';
ALTER USER u3 IDENTIFIED BY 'pwd-456';
drop user u1, u2, u3;
set global server_audit_events='query_ddl';
create table t1(id int);
insert into t1 values (1), (2);
select * from t1;
id
1
2
select 2;
2
2
(select 2);
2
2
/*! select 2*/;
2
2
/*comment*/ select 2;
2
2
drop table t1;
create procedure pr1() insert into test.t1 values ("foo", 42);
create function fn1(i int) returns int deterministic return i+1;
drop procedure pr1;
drop function fn1;
set global server_audit_events='query_ddl,query_dml';
create table t1(id int);
insert into t1 values (1), (2);
select * from t1;
id
1
2
select 2;
2
2
drop table t1;
set global server_audit_events='query_dml';
create table t1(id int);
insert into t1 values (1), (2);
select * from t1;
id
1
2
select 2;
2
2
(select 2);
2
2
/*! select 2*/;
2
2
/*comment*/ select 2;
2
2
drop table t1;
set global server_audit_events='query_dcl';
create table t1(id int);
insert into t1 values (1), (2);
select * from t1;
id
1
2
CREATE USER u1 IDENTIFIED BY 'pwd-123';
GRANT ALL ON sa_db TO u2 IDENTIFIED BY "pwd-321";
SET PASSWORD
# comment
FOR u1 = PASSWORD('pwd 098');
SET PASSWORD FOR u1=<secret>;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<secret>' at line 1
CREATE USER u3 IDENTIFIED BY '';
drop user u1, u2, u3;
select 2;
2
2
(select 2);
2
2
/*! select 2*/;
2
2
/*comment*/ select 2;
2
2
drop table t1;
set global server_audit_events='query_dml_no_select';
create table t1(id int);
insert into t1 values (1), (2);
select * from t1;
id
1
2
select 2;
2
2
drop table t1;
create procedure pr1() insert into test.t1 values ("foo", 42);
create function fn1(i int) returns int deterministic return i+1;
drop procedure pr1;
drop function fn1;
create procedure pr1() insert into test.t1 values ("foo", 42);
create function fn1(i int) returns int deterministic return i+1;
drop procedure pr1;
drop function fn1;
set global server_audit_events='table';
set global server_audit_incl_users='user1';
create user user1@localhost;
grant all on sa_db.* to user1@localhost;
connect cn1,127.0.0.1,user1,,sa_db,$MASTER_MYPORT;
create table t1(id int) engine=myisam;
insert delayed into t1 values (1);
connection default;
# Waiting until INSERT DELAYED thread does the insert.
drop table t1;
set global server_audit_logging= off;
set global server_audit_incl_users='root';
set global server_audit_logging= on;
disconnect cn1;
Line count in file: 140
drop user user1@localhost;
set global server_audit_events='';
set global server_audit_incl_users='root, plug_dest, ssl_user1';
CREATE USER plug IDENTIFIED WITH 'test_plugin_server' AS 'plug_dest';
CREATE USER plug_dest IDENTIFIED BY 'plug_dest_passwd';
connect(localhost,plug,plug_dest,test,MYSQL_PORT,MYSQL_SOCK);
connect plug_con,localhost,plug,plug_dest;
ERROR 28000: Access denied for user 'plug'@'localhost' (using password: YES)
GRANT PROXY ON plug_dest TO plug;
connect plug_con,localhost,plug,plug_dest,"*NO-ONE*";
select USER(),CURRENT_USER();
USER() CURRENT_USER()
plug@localhost plug_dest@%
connection default;
disconnect plug_con;
Line count in file: 174
DROP USER plug;
DROP USER plug_dest;
CREATE USER ssl_user1@localhost require SSL;
GRANT ALL ON sa_db TO ssl_user1@localhost;
connect conssl1,localhost,ssl_user1,,sa_db,,,SSL;
select variable_value > '' as 'have_ssl' from information_schema.session_status where variable_name='ssl_cipher';
have_ssl
1
disconnect conssl1;
Line count in file: 205
connection default;
DROP USER ssl_user1@localhost;
set global server_audit_query_log_limit= 15;
select (1), (2), (3), (4);
1 2 3 4
1 2 3 4
select 'A', 'B', 'C', 'D';
A B C D
A B C D
set global server_audit_query_log_limit= 1024;
drop database sa_db;
select length('01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789');
length('0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456
2750
CREATE TABLE test.t1 (a char(4));
set sql_mode="";
insert into test.t1 value("12345");
Warnings:
Warning 1265 Data truncated for column 'a' at row 1
set sql_mode=default;
drop table test.t1;
set global server_audit_file_path='.';
show status like 'server_audit_current_log';
Variable_name Value
Server_audit_current_log HOME_DIR/server_audit.log
set global server_audit_file_path='';
show status like 'server_audit_current_log';
Variable_name Value
Server_audit_current_log server_audit.log
set global server_audit_file_path=' ';
show status like 'server_audit_current_log';
Variable_name Value
Server_audit_current_log server_audit.log
set global server_audit_file_path='nonexisting_dir/';
Warnings:
Warning 1 SERVER AUDIT plugin can't create file 'nonexisting_dir/'.
show status like 'server_audit_current_log';
Variable_name Value
Server_audit_current_log server_audit.log
show variables like 'server_audit%';
Variable_name Value
server_audit_events
server_audit_excl_users
server_audit_file_buffer_size 0
server_audit_file_path
server_audit_file_rotate_now OFF
server_audit_file_rotate_size 1000000
server_audit_file_rotations 9
server_audit_incl_users root, plug_dest, ssl_user1
server_audit_logging ON
server_audit_mode 1
server_audit_output_type file
server_audit_query_log_limit 1024
server_audit_sync_log_file OFF
server_audit_syslog_facility LOG_USER
server_audit_syslog_ident mysql-server_auditing
server_audit_syslog_info
server_audit_syslog_priority LOG_INFO
uninstall plugin server_audit;
Warnings:
Warning 1620 Plugin is busy and will be uninstalled on shutdown
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_logging=on',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_incl_users= repeat("\'root\',", 10000)',ID
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'show variables like \'server_audit_incl_users\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_excl_users= repeat("\'root\',", 10000)',ID
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'show variables like \'server_audit_excl_users\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,0,CONNECT,mysql,,0
TIME,HOSTNAME,root,localhost:PORT,ID,0,DISCONNECT,mysql,,0
TIME,HOSTNAME,no_such_user,localhost:PORT,ID,0,FAILED_CONNECT,,,ID
TIME,HOSTNAME,no_such_user,localhost:PORT,ID,0,DISCONNECT,,,0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_incl_users=\'odin, dva, tri\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_incl_users=\'odin, root, dva, tri\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,CREATE,test,t2,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'create table t2 (id int)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_excl_users=\'odin, dva, tri\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'SHOW WARNINGS',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,test,t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,table_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,column_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,index_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'insert into t1 values (1), (2)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,test,t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'select * from t1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_incl_users=\'odin, root, dva, tri\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,test,t2,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,table_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,column_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,index_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'insert into t2 values (1), (2)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,test,t2,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'select * from t2',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,ALTER,test,t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,RENAME,test,t1|test.renamed_t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,table_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,column_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,index_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'alter table t1 rename renamed_t1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_events=\'connect,query\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'select 1,\n2,\n# comment\n3',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'insert into t2 values (1), (2)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'select * from t2',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'select * from t_doesnt_exist',ID
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'syntax_error_query',ID
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'drop table renamed_t1, t2',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'show variables like \'server_audit%\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_mode=1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'set global server_audit_events=\'\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'create database sa_db',0
TIME,HOSTNAME,root,localhost:PORT,ID,0,CONNECT,test,,0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,CREATE,test,t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'create table t1 (id2 int)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,test,t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,table_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,column_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,index_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'insert into t1 values (1), (2)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,test,t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'select * from t1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,table_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,column_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,index_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,DROP,test,t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'drop table t1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'use sa_db',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,CREATE,sa_db,sa_t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'create table sa_t1(id int)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,sa_db,sa_t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,table_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,column_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,index_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'insert into sa_t1 values (1), (2)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,table_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,column_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,index_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,DROP,sa_db,sa_t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop table sa_t1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,proc,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proc,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,event,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop database sa_db',0
TIME,HOSTNAME,root,localhost:PORT,ID,0,DISCONNECT,,,0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,test,'create database sa_db',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'use sa_db',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER u1 IDENTIFIED BY *****',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'GRANT ALL ON sa_db TO u2 IDENTIFIED BY *****',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'SET PASSWORD FOR u1 = PASSWORD(*****)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER u3 IDENTIFIED BY *****',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'ALTER USER u3 IDENTIFIED BY *****',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop user u1, u2, u3',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'create table t1(id int)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop table t1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'create procedure pr1() insert into test.t1 values ("foo", 42)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'create function fn1(i int) returns int deterministic return i+1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop procedure pr1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop function fn1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'create table t1(id int)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'insert into t1 values (1), (2)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select * from t1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select 2',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop table t1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'insert into t1 values (1), (2)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select * from t1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select 2',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'(select 2)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'/*! select 2*/',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'/*comment*/ select 2',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER u1 IDENTIFIED BY *****',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'GRANT ALL ON sa_db TO u2 IDENTIFIED BY *****',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'SET PASSWORD \n# comment\nFOR u1 = PASSWORD(*****)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'SET PASSWORD FOR u1=<secret>',ID
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER u3 IDENTIFIED BY *****',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop user u1, u2, u3',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'insert into t1 values (1), (2)',0
TIME,HOSTNAME,user1,localhost:PORT,ID,ID,CREATE,sa_db,t1,
TIME,HOSTNAME,user1,localhost,ID,ID,WRITE,sa_db,t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_logging= off',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_events=\'\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_incl_users=\'root, plug_dest, ssl_user1\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER plug IDENTIFIED WITH \'test_plugin_server\' AS \'plug_dest\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER plug_dest IDENTIFIED BY *****',0
TIME,HOSTNAME,plug,localhost:PORT,ID,0,FAILED_CONNECT,,,ID
TIME,HOSTNAME,plug,localhost:PORT,ID,0,DISCONNECT,,,0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'GRANT PROXY ON plug_dest TO plug',0
TIME,HOSTNAME,plug,localhost:PORT,ID,0,CONNECT,,,0
TIME,HOSTNAME,plug,localhost:PORT,ID,0,PROXY_CONNECT,,`plug_dest`@`%`,0
TIME,HOSTNAME,plug,localhost:PORT,ID,ID,QUERY,,'select USER(),CURRENT_USER()',0
TIME,HOSTNAME,plug,localhost:PORT,ID,0,DISCONNECT,,,0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'DROP USER plug',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'DROP USER plug_dest',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE USER ssl_user1@localhost require SSL',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'GRANT ALL ON sa_db TO ssl_user1@localhost',0
TIME,HOSTNAME,ssl_user1,localhost:PORT,ID,0,CONNECT,sa_db,TLS_VERSION,0
TIME,HOSTNAME,ssl_user1,localhost:PORT,ID,ID,QUERY,sa_db,'SHOW STATUS LIKE \'Ssl_version\'',0
TIME,HOSTNAME,ssl_user1,localhost:PORT,ID,ID,QUERY,sa_db,'select variable_value > \'\' as \'have_ssl\' from information_schema.session_status where variable_name=\'ssl_cipher\'',0
TIME,HOSTNAME,ssl_user1,localhost:PORT,ID,0,DISCONNECT,sa_db,TLS_VERSION,0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,db,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,tables_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,columns_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,procs_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proxies_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,roles_mapping,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,global_priv,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'DROP USER ssl_user1@localhost',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global serv',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select (1), (2)',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select \'A\', ',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_query_log_limit= 1024',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,proc,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,proc,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,event,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop database sa_db',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'select length(\'012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,CREATE,test,t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'CREATE TABLE test.t1 (a char(4))',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set sql_mode=""',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,test,t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,table_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,column_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,READ,mysql,index_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'insert into test.t1 value("12345")',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'SHOW WARNINGS',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set sql_mode=default',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,table_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,column_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,index_stats,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,DROP,test,t1,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'drop table test.t1',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'.\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'.\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'show status like \'server_audit_current_log\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'show status like \'server_audit_current_log\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\' \'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\' \'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'show status like \'server_audit_current_log\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'nonexisting_dir/\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'set global server_audit_file_path=\'nonexisting_dir/\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'SHOW WARNINGS',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'show status like \'server_audit_current_log\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'show variables like \'server_audit%\'',0
TIME,HOSTNAME,root,localhost:PORT,ID,ID,WRITE,mysql,plugin,
TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'uninstall plugin server_audit',0
#
# MDEV-27631 Assertion `global_status_var.global_memory_used == 0' failed in mysqld_exit
#
install plugin server_audit soname 'server_audit';
uninstall plugin server_audit;
Warnings:
Warning 1620 Plugin is busy and will be uninstalled on shutdown
Reference in a new issue View git blame Copy permalink