1# Turn on ssl between the client and server
2# and run a number of tests
3
4-- source include/have_ssl_communication.inc
5# Slow test, don't run during staging part
6-- source include/not_staging.inc
7
8# Save the initial number of concurrent sessions
9--source include/count_sessions.inc
10
11--source include/default_charset.inc
12
13connect (ssl_con,localhost,root,,,,,SSL);
14
15# Check ssl turned on
16SELECT (VARIABLE_VALUE <> '') AS have_ssl FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='Ssl_cipher';
17
18# Check ssl expiration
19SHOW STATUS LIKE 'Ssl_server_not_before';
20SHOW STATUS LIKE 'Ssl_server_not_after';
21
22# Source select test case
23-- source include/common-tests.inc
24
25# Check ssl turned on
26SELECT (VARIABLE_VALUE <> '') AS have_ssl FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='Ssl_cipher';
27
28#
29# MDEV-7697 Client reports ERROR 2006 (MySQL server has gone away) or ERROR 2013 (Lost connection to MySQL server during query) while executing AES* functions under SSL
30#
31select aes_decrypt('MySQL','adf');
32select 'still connected?';
33
34connection default;
35disconnect ssl_con;
36
37# Wait till all disconnects are completed
38--source include/wait_until_count_sessions.inc
39