1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
|
TRUNCATE TABLE mysql.slow_log;
SET @old_master_info_repository = @@GLOBAL.master_info_repository;
Warnings:
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
SET @old_relay_log_info_repository = @@GLOBAL.relay_log_info_repository;
Warnings:
Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
SET @old_log_output= @@global.log_output;
SET @old_slow_query_log= @@global.slow_query_log;
SET @old_slow_query_log_file= @@global.slow_query_log_file;
SET @old_long_query_time= @@global.long_query_time;
SET GLOBAL slow_query_log_file= '.../log/rewrite_slow.log';
SET GLOBAL log_output = 'FILE,TABLE';
SET GLOBAL slow_query_log= 'ON';
SET SESSION long_query_time= 0;
CREATE USER test_user2 IDENTIFIED BY 'azundris2';
SET SESSION long_query_time = 0;
ALTER USER test_user2 IDENTIFIED BY 'azundris2' REPLACE 'azundris2';
SET PASSWORD='azundris2' REPLACE 'azundris2';
SET PASSWORD FOR test_user2='azundris2' REPLACE 'azundris2';
SET GLOBAL master_info_repository = 'TABLE';
Warnings:
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
SET GLOBAL relay_log_info_repository = 'TABLE';
Warnings:
Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
CHANGE REPLICATION SOURCE TO SOURCE_PASSWORD='azundris3',
SOURCE_BIND = 'eth4n',
SOURCE_TLS_CIPHERSUITES = ''
FOR CHANNEL 'chan_jackie';
CHANGE REPLICATION SOURCE TO SOURCE_PASSWORD='azundris3',
SOURCE_CONNECT_RETRY = 1, SOURCE_HEARTBEAT_PERIOD = 1.01,
SOURCE_LOG_FILE = 'master_log_name', SOURCE_LOG_POS = 0,
SOURCE_SSL = 0, SOURCE_SSL_CA = 'ca_file_name',
SOURCE_SSL_CAPATH = 'ca_directory_name',
SOURCE_SSL_CERT = 'cert_file_name', SOURCE_SSL_KEY = 'key_file_name',
SOURCE_SSL_CIPHER = 'cipher_list', SOURCE_SSL_VERIFY_SERVER_CERT = 1,
SOURCE_SSL_CRL = 'crl_file_name', SOURCE_SSL_CRLPATH = 'crl_directory_name',
IGNORE_SERVER_IDS = (99,100), SOURCE_TLS_VERSION = 'TLSv1.2',
SOURCE_TLS_CIPHERSUITES = NULL,
SOURCE_BIND = 'eth4n', SOURCE_RETRY_COUNT = 7,
SOURCE_DELAY = 4711, SOURCE_AUTO_POSITION = 0 FOR CHANNEL 'chan_jackie';
RESET SLAVE ALL;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
SET GLOBAL master_info_repository = DEFAULT;
Warnings:
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
SET GLOBAL relay_log_info_repository = DEFAULT;
Warnings:
Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
CREATE USER 'test_user4'@'localhost';
SET PASSWORD FOR 'test_user4'@'localhost' = 'azundris4';
SET SESSION long_query_time= @old_long_query_time;
SET GLOBAL slow_query_log='OFF';
DROP USER 'test_user4'@'localhost';
DROP USER test_user2;
CREATE TABLE test_log (sql_text TEXT);
LOAD DATA LOCAL INFILE '.../log/rewrite_slow.log'
INTO TABLE test_log FIELDS TERMINATED BY '\n' LINES TERMINATED BY '\n';
This line should be followed by two SELECTs with empty result sets
SELECT sql_text FROM test_log WHERE sql_text LIKE CONCAT('%azun','dris%');
sql_text
SELECT sql_text FROM mysql.slow_log WHERE sql_text LIKE CONCAT('%azun','dris%');
sql_text
SELECT count(*)=1 OR count(*)=2 FROM mysql.slow_log WHERE sql_text LIKE '%REPLACE%';
count(*)=1 OR count(*)=2
0
------ from file ------
SELECT count(*)=1 OR count(*)=2 FROM test_log WHERE sql_text LIKE 'CREATE USER %' AND sql_text LIKE '%<secret>%';
count(*)=1 OR count(*)=2
1
SELECT sql_text FROM test_log WHERE sql_text LIKE 'CHANGE REPLICATION SOURCE TO SOURCE_BIND %';
sql_text
CHANGE REPLICATION SOURCE TO SOURCE_BIND = 'eth4n', SOURCE_PASSWORD = <secret>, SOURCE_TLS_CIPHERSUITES = '' FOR CHANNEL 'chan_jackie';
CHANGE REPLICATION SOURCE TO SOURCE_BIND = 'eth4n', SOURCE_PASSWORD = <secret>, SOURCE_CONNECT_RETRY = 1, SOURCE_RETRY_COUNT = 7, SOURCE_DELAY = 4711, SOURCE_HEARTBEAT_PERIOD = 1.010000, SOURCE_LOG_FILE = 'master_log_name', SOURCE_LOG_POS = 4, SOURCE_AUTO_POSITION = 0, SOURCE_SSL = 0, SOURCE_SSL_CA = 'ca_file_name', SOURCE_SSL_CAPATH = 'ca_directory_name', SOURCE_SSL_CERT = 'cert_file_name', SOURCE_SSL_CRL = 'crl_file_name', SOURCE_SSL_CRLPATH = 'crl_directory_name', SOURCE_SSL_KEY = 'key_file_name', SOURCE_SSL_CIPHER = 'cipher_list', SOURCE_SSL_VERIFY_SERVER_CERT = 1, SOURCE_TLS_VERSION = 'TLSv1.2', SOURCE_TLS_CIPHERSUITES = NULL, IGNORE_SERVER_IDS = ( 99, 100 ) FOR CHANNEL 'chan_jackie';
SELECT count(*) FROM test_log WHERE sql_text LIKE 'SET PASSWORD %' AND sql_text LIKE '%<secret>%';
count(*)
3
------ from table ------
SELECT count(*)=1 OR count(*)=2 FROM mysql.slow_log WHERE sql_text LIKE 'CREATE USER %' AND sql_text LIKE '%<secret>%';
count(*)=1 OR count(*)=2
1
SELECT sql_text FROM test_log WHERE sql_text LIKE 'CHANGE REPLICATION SOURCE TO SOURCE_BIND %';
sql_text
CHANGE REPLICATION SOURCE TO SOURCE_BIND = 'eth4n', SOURCE_PASSWORD = <secret>, SOURCE_TLS_CIPHERSUITES = '' FOR CHANNEL 'chan_jackie';
CHANGE REPLICATION SOURCE TO SOURCE_BIND = 'eth4n', SOURCE_PASSWORD = <secret>, SOURCE_CONNECT_RETRY = 1, SOURCE_RETRY_COUNT = 7, SOURCE_DELAY = 4711, SOURCE_HEARTBEAT_PERIOD = 1.010000, SOURCE_LOG_FILE = 'master_log_name', SOURCE_LOG_POS = 4, SOURCE_AUTO_POSITION = 0, SOURCE_SSL = 0, SOURCE_SSL_CA = 'ca_file_name', SOURCE_SSL_CAPATH = 'ca_directory_name', SOURCE_SSL_CERT = 'cert_file_name', SOURCE_SSL_CRL = 'crl_file_name', SOURCE_SSL_CRLPATH = 'crl_directory_name', SOURCE_SSL_KEY = 'key_file_name', SOURCE_SSL_CIPHER = 'cipher_list', SOURCE_SSL_VERIFY_SERVER_CERT = 1, SOURCE_TLS_VERSION = 'TLSv1.2', SOURCE_TLS_CIPHERSUITES = NULL, IGNORE_SERVER_IDS = ( 99, 100 ) FOR CHANNEL 'chan_jackie';
SELECT count(*) FROM test_log WHERE sql_text LIKE 'SET PASSWORD %' AND sql_text LIKE '%<secret>%';
count(*)
3
------ done ------
DROP TABLE test_log;
End of 5.6 tests!
#
# Bug#16467055: GRANT STATEMENTS LOGGED TWICE IN SLOW QUERY LOG
#
SET SESSION long_query_time= 0;
SET GLOBAL slow_query_log = 1;
SET GLOBAL log_output = 'TABLE';
TRUNCATE mysql.slow_log;
DROP USER u16467055;
End of 5.7 tests!
SET SESSION long_query_time= @old_long_query_time;
SET GLOBAL slow_query_log_file=@old_slow_query_log_file;
SET GLOBAL slow_query_log= @old_slow_query_log;
SET GLOBAL log_output= @old_log_output;
TRUNCATE TABLE mysql.slow_log;
TRUNCATE TABLE mysql.general_log;
SET GLOBAL master_info_repository= @old_master_info_repository;
SET GLOBAL relay_log_info_repository= @old_relay_log_info_repository;
|
