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
111
|
--source include/big_test.inc
let BASEDIR= `select @@basedir`;
let DDIR=$MYSQL_TMP_DIR/installdb_test;
let MYSQLD_LOG=$MYSQL_TMP_DIR/server.log;
let extra_args=--no-defaults --innodb_dedicated_server=OFF --console --basedir=$BASEDIR --lc-messages-dir=$MYSQL_SHAREDIR;
let PASSWD_FILE=$MYSQL_TMP_DIR/password_file.txt;
--echo # Save the count of columns in mysql
--let $mysql_cnt=`SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='mysql'`
--echo # shut server down
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--echo # Server is down
--echo #
--echo # Try --initialize --default-authentication-plugin=sha256_password
--echo #
--echo # Run the server with --initialize --default-authentication-plugin=sha256_password
--exec $MYSQLD $extra_args --initialize --default-authentication-plugin=sha256_password --datadir=$DDIR > $MYSQLD_LOG 2>&1
--echo extract the root password
--perl
use strict;
my $log= $ENV{'MYSQLD_LOG'} or die;
my $passwd_file= $ENV{'PASSWD_FILE'} or die;
my $FILE;
open(FILE, "$log") or die;
while (my $row = <FILE>)
{
if ($row =~ m/.*A temporary password is generated for root.localhost: ([^ \n][^ \n]*)/)
{
my $passwd=$1;
print "password found\n";
my $OUT_FILE;
open(OUT_FILE, "> $passwd_file");
print OUT_FILE "delimiter lessprobability;\n";
print OUT_FILE "let new_pwd=$passwd";
print OUT_FILE "lessprobability\n";
print OUT_FILE "--delimiter ;\n";
close(OUT_FILE);
}
}
close(FILE);
EOF
source $passwd_file;
--echo # Restart the server against DDIR
--exec echo "restart:--datadir=$DDIR --default-authentication-plugin=sha256_password " > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc
--echo # connect as root
connect(root_con,localhost,root,$new_pwd,mysql,,,SSL);
--echo # must fail due to password expiration
--error ER_MUST_CHANGE_PASSWORD
SELECT 1;
--echo # reset the password
SET PASSWORD='';
--echo # Check the count of columns in mysql
--let $cnt=`SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='mysql';`
if ($cnt != $mysql_cnt)
{
--echo # Column count doesn't match. mtr=$mysql_cnt server=$cnt
--echo list columns in I_S.COLUMNS for the mysql db
SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='mysql' ORDER BY TABLE_NAME,ORDINAL_POSITION;
}
--echo # check the user account
SELECT user, host, plugin, LENGTH(authentication_string) > 0
FROM mysql.user ORDER BY user;
CREATE DATABASE test;
--echo # shut server down
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--echo # Server is down
--echo # close the test connection
connection default;
disconnect root_con;
--echo # remove the password file
remove_file $PASSWD_FILE;
--echo # delete mysqld log
remove_file $MYSQLD_LOG;
--echo # delete datadir
--force-rmdir $DDIR
--echo #
--echo # Cleanup
--echo #
--echo # Restarting the server
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc
|
