Debian Codegraph @

mysql-test/suite/sys_vars/t/sha256_password_proxy_users_log.test

raw
1 ############ mysql-test\t\sha256_password_proxy_users_log.test #################
2 # #
3 #Variable Name: sha256_password #
4 #Scope: SESSION #
5 #Access Type: Dynamic #
6 #Data Type: BOOLEAN #
7 #Default Value: OFF #
8 #Values: ON, OFF #
9 # #
10 # #
11 #Creation Date: 2015-02-12 #
12 #Author: Horst Hunger #
13 # #
14 #Description: Test Cases of Dynamic System Variable #
15 # "sha256_password_proxy_users" #
16 # to assure entries in general log. #
17 # #
18 ################################################################################
19
20 --echo ** Setup **
21 --echo
22 #
23 # Setup
24 #
25
26 SET @old_log_output= @@global.log_output;
27 SET @old_general_log= @@global.general_log;
28 SET @old_general_log_file= @@global.general_log_file;
29
30 --replace_result $MYSQLTEST_VARDIR ...
31 eval SET GLOBAL general_log_file = '$MYSQLTEST_VARDIR/log/proxy_general.log';
32 SET GLOBAL log_output = 'FILE,TABLE';
33 SET GLOBAL general_log= 'ON';
34
35
36 SET @default_sha256_password_proxy_users = @@global.sha256_password_proxy_users;
37 SET @default_check_proxy_users = @@global.check_proxy_users;
38
39 --echo '#----- 2.1.12.1 Test of general log entries. -------------------#'
40 ###################################
41 #Setting value OFF #
42 ###################################
43
44 SET Global sha256_password_proxy_users=OFF;
45
46 ###################################
47 #Setting up proxy accounts #
48 ###################################
49
50 --echo ** Creating new base user **
51 CREATE USER proxy_base@localhost;
52 GRANT ALTER ON *.* TO proxy_base@localhost;
53 --echo ** Creating new proxy user **
54 CREATE USER proxy_sha256@localhost IDENTIFIED WITH sha256_password;
55 GRANT CREATE ON *.* TO proxy_sha256@localhost;
56 GRANT PROXY ON proxy_base@localhost TO proxy_sha256@localhost;
57
58 ###################################
59 #Setting value ON #
60 ###################################
61
62 SET Global sha256_password_proxy_users=ON;
63
64 --echo ** Connecting as proxy_sha256 with proxy mapping disabled (native mapping on) **
65 CONNECT (connd,localhost,proxy_sha256,,);
66 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
67 SHOW GRANTS;
68
69 --echo ** Connection default **
70 connection default;
71
72 --echo ** Disconnecting connections **
73 DISCONNECT connd;
74
75 ###################################
76 #Setting check_proxy value ON #
77 ###################################
78
79 SET Global check_proxy_users=ON;
80
81 --echo ** Connecting as proxy_sha256 with proxy mapping enabled **
82 CONNECT (connf,localhost,proxy_sha256,,);
83 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
84 SHOW GRANTS;
85
86 connection default;
87
88 --echo ** Disconnecting connections **
89 DISCONNECT connf;
90
91 ###################################
92 #Analyzing general log #
93 ###################################
94 SET GLOBAL general_log= 'OFF';
95
96 #show general-logging to file is correct
97 CREATE TABLE test_log (argument TEXT);
98 --replace_result $MYSQLTEST_VARDIR ...
99 eval LOAD DATA LOCAL INFILE '$MYSQLTEST_VARDIR/log/proxy_general.log'
100 INTO TABLE test_log FIELDS TERMINATED BY '\n' LINES TERMINATED BY '\n';
101
102 SELECT count(argument) FROM test_log
103 WHERE argument LIKE '%proxy_sha256@localhost on test%';
104 SELECT count(argument) FROM test_log
105 WHERE argument LIKE '%proxy_sha256@localhost as proxy_base on test%';
106
107 DROP TABLE test_log;
108
109 ###################################
110 #Cleaning up #
111 ###################################
112
113 DROP USER proxy_base@localhost;
114 DROP USER proxy_sha256@localhost;
115
116 SET @@global.sha256_password_proxy_users = @default_sha256_password_proxy_users;
117 SET @@global.check_proxy_users = @default_check_proxy_users;
118
119 SET GLOBAL general_log_file= @old_general_log_file;
120 SET GLOBAL general_log= @old_general_log;
121 SET GLOBAL log_output= @old_log_output;
122 TRUNCATE TABLE mysql.general_log;
123 --remove_file '$MYSQLTEST_VARDIR/log/proxy_general.log'