Debian Codegraph @

mysql-test/suite/x/t/mysqlxtest_variables.test

raw
1 ## XPLUGIN: Following test cases for mysqlx plugin ssl connection testing
2 ## with SSL cert verification on client side.
3
4 --source include/xplugin_preamble.inc
5
6
7 CREATE DATABASE xtest;
8 CREATE USER 'user1'@'127.0.0.1' IDENTIFIED BY 'user1_pass';
9 CREATE USER 'user2'@'127.0.0.1' IDENTIFIED BY 'user2_pass';
10
11 GRANT SELECT ON xtest.* TO user1@'127.0.0.1';
12 GRANT SELECT ON xtest.* TO user2@'127.0.0.1';
13
14 --write_file $MYSQL_TMP_DIR/mysqlx-verify-variables.xpl
15 -->import connection.macro
16 -->callmacro Verify_its_xprotocol_connection
17 -->varlet %OLD_SOCKET_ID% %ACTIVE_SOCKET_ID%
18
19 -->macro Check_cmd_options %TEXT%
20 -->echo #
21 -->echo # Command line options must be unchange, %TEXT%
22 -->echo # on every session or authenticated account
23 -->assert_eq xtest %OPTION_CLIENT_SCHEMA%
24 -->assert_eq user1 %OPTION_CLIENT_USER%
25 -->assert_eq user1_pass %OPTION_CLIENT_PASSWORD%
26 -->assert_eq 127.0.0.1 %OPTION_CLIENT_HOST%
27 -->assert_eq DISABLED %OPTION_SSL_MODE%
28 -->endmacro
29
30 -->callmacro Check_cmd_options on unauthenticated connection
31
32 -->echo #
33 -->echo # Authenticating on existing connection
34 -->login
35 -->echo # * SOCKET_ID must be the same as before
36 -->assert_eq %OLD_SOCKET_ID% %ACTIVE_SOCKET_ID%
37 -->echo # * CLIENT_ID must have a expected value
38 -->assert_eq %EXPECTED_CLIENT_ID% %ACTIVE_CLIENT_ID%
39 -->callmacro Check_cmd_options on authenticated connection
40 -->varinc %EXPECTED_CLIENT_ID% 1
41
42 -->echo #
43 -->echo # New connection:
44 -->newsession second_session user2 user2_pass
45 -->callmacro Check_cmd_options on second session
46 -->echo # * SOCKET_ID must have a new value
47 -->assert_ne %OLD_SOCKET_ID% %ACTIVE_SOCKET_ID%
48 -->echo # * CLIENT_ID must have a new value
49 -->assert_eq %EXPECTED_CLIENT_ID% %ACTIVE_CLIENT_ID%
50 EOF
51
52
53 --echo
54 --echo ############################################################
55 --echo ## Verify mysqlxtests variables at first connection
56 --echo ##
57
58 exec $MYSQLXTEST
59 -v%EXPECTED_CLIENT_ID%=1
60 --no-auth
61 --user=user1
62 --password=user1_pass
63 --host=127.0.0.1
64 --schema=xtest
65 --ssl-mode=DISABLED
66 --file=$MYSQL_TMP_DIR/mysqlx-verify-variables.xpl 2>&1;
67
68 --echo
69 --echo ############################################################
70 --echo ## Verify mysqlxtests variables at second connection
71 --echo ##
72
73 exec $MYSQLXTEST
74 -v%EXPECTED_CLIENT_ID%=3
75 --no-auth
76 --user=user1
77 --password=user1_pass
78 --host=127.0.0.1
79 --schema=xtest
80 --ssl-mode=DISABLED
81 --file=$MYSQL_TMP_DIR/mysqlx-verify-variables.xpl 2>&1;
82
83 ## Cleanup
84 DROP USER 'user1'@'127.0.0.1';
85 DROP USER 'user2'@'127.0.0.1';
86 --source ../include/xplugin_cleanup.inc
87