← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/t/old_passwords_func.test

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/old_passwords_func.test
 
1
############# mysql-test\t\old_passwords_func.test ############################
 
2
#                                                                             #
 
3
# Variable Name: old_passwords                                                #
 
4
# Scope: GLOBAL & SESSION                                                     #
 
5
# Access Type: Dynamic                                                        #
 
6
# Data Type: BOOLEAN                                                          #
 
7
# Default Value: FALSE                                                        #
 
8
# Values:       TRUE, FALSE                                                   #
 
9
#                                                                             #
 
10
#                                                                             #
 
11
# Creation Date: 2008-03-12                                                   #
 
12
# Author:  Sharique Abdullah                                                  #
 
13
#                                                                             #
 
14
# Description: Test Cases of Dynamic System Variable "old_passwords"          #
 
15
#              that checks behavior of this variable in the following ways    #
 
16
#              * Functionality based on different values                      #
 
17
#                                                                             #
 
18
# Reference: http://dev.mysql.com/doc/refman/5.0/en                           #
 
19
#                /server-options.html#option_mysqld_old-passwords             #
 
20
#                                                                             #
 
21
###############################################################################
 
22
 
 
23
#
 
24
# Setup
 
25
#
 
26
 
 
27
--source include/not_embedded.inc
 
28
 
 
29
SET @global_old_passwords = @@GLOBAL.old_passwords;
 
30
SET @session_old_passwords = @@SESSION.old_passwords;
 
31
SET @global_secure_auth = @@GLOBAL.secure_auth;
 
32
 
 
33
 
 
34
--echo '#------------------------FN_DYNVARS_115_01---------------------------#'
 
35
 
 
36
--echo ** Connection default **
 
37
connection default;
 
38
 
 
39
#
 
40
# 2 Users with FALSE value
 
41
#
 
42
 
 
43
CREATE USER 'userNewPass1'@'localhost' IDENTIFIED BY 'pass1';
 
44
CREATE USER 'userNewPass2'@'localhost' IDENTIFIED BY 'pass2';
 
45
 
 
46
SET GLOBAL old_passwords = TRUE;
 
47
SET SESSION old_passwords = TRUE;
 
48
 
 
49
#
 
50
# 1 User with TRUE value
 
51
#
 
52
 
 
53
CREATE USER 'userOldPass'@'localhost' IDENTIFIED BY 'pass3';
 
54
 
 
55
SET GLOBAL secure_auth = FALSE;
 
56
 
 
57
--echo ** Connecting con1 using username 'userNewPass1' **
 
58
connect (con1,localhost,userNewPass1,pass1,);
 
59
SELECT CURRENT_USER();
 
60
--echo userNewPass1@localhost Expected
 
61
 
 
62
--echo ** Connecting con2 using username 'userNewPass2' **
 
63
connect (con2,localhost,userNewPass2,pass2,);
 
64
SELECT CURRENT_USER();
 
65
--echo userNewPass2@localhost Expected
 
66
 
 
67
--echo ** Connecting con3 using username 'userOldPass' **
 
68
connect (con3,localhost,userOldPass,pass3,);
 
69
SELECT CURRENT_USER();
 
70
--echo userOldPass@localhost Expected
 
71
 
 
72
--echo ** Connection default **
 
73
connection default;
 
74
 
 
75
--echo ** Disconnecting con1, con2, con3  **
 
76
disconnect con1;
 
77
disconnect con2;
 
78
disconnect con3;
 
79
 
 
80
--echo '#------------------------FN_DYNVARS_115_02---------------------------#'
 
81
 
 
82
SET GLOBAL secure_auth = TRUE;
 
83
 
 
84
--echo ** Connecting con1 using username 'userNewPass1' **
 
85
connect (con1,localhost,userNewPass1,pass1,);
 
86
SELECT CURRENT_USER();
 
87
--echo userNewPass1@localhost Expected
 
88
 
 
89
--echo ** Connecting con2 using username 'userNewPass2' **
 
90
connect (con2,localhost,userNewPass2,pass2,);
 
91
SELECT CURRENT_USER();
 
92
--echo userNewPass2@localhost Expected
 
93
 
 
94
--echo ** Connecting con3 using username 'userOldPass' **
 
95
--disable_query_log
 
96
--error ER_SERVER_IS_IN_SECURE_AUTH_MODE
 
97
connect (con3,localhost,userOldPass,pass3,);
 
98
--enable_query_log
 
99
--echo Expected Error 'Server is running in secure auth mode'
 
100
SELECT CURRENT_USER();
 
101
--echo userNewPass2@localhost Expected
 
102
 
 
103
--echo ** Connection default **
 
104
connection default;
 
105
 
 
106
--echo ** Disconnecting con1, con2 **
 
107
disconnect con1;
 
108
disconnect con2;
 
109
 
 
110
#
 
111
# Cleanup
 
112
#
 
113
 
 
114
DROP USER 'userNewPass1'@'localhost';
 
115
DROP USER 'userNewPass2'@'localhost';
 
116
DROP USER 'userOldPass'@'localhost';
 
117
 
 
118
SET @@GLOBAL.old_passwords = @global_old_passwords;
 
119
SET @@SESSION.old_passwords = @session_old_passwords;
 
120
SET @@GLOBAL.secure_auth = @global_secure_auth;