ssl.test 1.49 KB
Newer Older
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
#Want to skip this test from daily Valgrind execution
--source include/no_valgrind_without_big.inc
# Turn on ssl between the client and server
# and run a number of tests

-- source include/have_ssl_communication.inc

# Save the initial number of concurrent sessions
--source include/count_sessions.inc

connect (ssl_con,localhost,root,,,,,SSL);

# Check ssl turned on
SHOW STATUS LIKE 'Ssl_cipher';

# Check ssl expiration
SHOW STATUS LIKE 'Ssl_server_not_before';
SHOW STATUS LIKE 'Ssl_server_not_after';

# Source select test case
-- source include/common-tests.inc

# Check ssl turned on
SHOW STATUS LIKE 'Ssl_cipher';

connection default;
disconnect ssl_con;

--echo #
--echo # Bug#54790: Use of non-blocking mode for sockets limits performance
--echo #

--echo # Open ssl_con and set a timeout.
connect (ssl_con,localhost,root,,,,,SSL);

LET $ID= `SELECT connection_id()`;
SET @@SESSION.wait_timeout = 2;

--echo # Wait for ssl_con to be disconnected.
connection default;
let $wait_condition=
  SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.PROCESSLIST
  WHERE ID = $ID;
--source include/wait_condition.inc

--echo # Check that ssl_con has been disconnected.
connection ssl_con;
--echo # CR_SERVER_LOST, CR_SERVER_GONE_ERROR
--error 2006,2013
SELECT 1;

connection default;
disconnect ssl_con;

# Wait till all disconnects are completed
--source include/wait_until_count_sessions.inc

##  This test file is for testing encrypted communication only, not other
##  encryption routines that the SSL library happens to provide!