::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
::   SSL
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

:: [ 16:24:18 ] :: [  BEGIN   ] :: DB connection status :: actually running 'mysql --ssl-mode=REQUIRED -u root <<< "status" 2>&1 | tee status.log'
--------------
mysql  Ver 8.0.40 for Linux on aarch64 (Source distribution)

Connection id:		13
Current database:	
Current user:		root@localhost
SSL:			Cipher in use is TLS_AES_256_GCM_SHA384
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		8.0.40 Source distribution
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	utf8mb4
Db     characterset:	utf8mb4
Client characterset:	utf8mb4
Conn.  characterset:	utf8mb4
UNIX socket:		/var/lib/mysql/mysql.sock
Uptime:			16 sec

Threads: 2  Questions: 27  Slow queries: 0  Opens: 200  Flush tables: 3  Open tables: 115  Queries per second avg: 1.687
--------------

:: [ 16:24:18 ] :: [   PASS   ] :: DB connection status (Expected 0, got 0)
:: [ 16:24:18 ] :: [  BEGIN   ] :: Checking that SSL is used :: actually running 'grep SSL status.log | grep Cipher'
SSL:			Cipher in use is TLS_AES_256_GCM_SHA384
:: [ 16:24:18 ] :: [   PASS   ] :: Checking that SSL is used (Expected 0, got 0)
:: [ 16:24:18 ] :: [  BEGIN   ] :: Enforcing SSL :: actually running 'sed -i 's/mysql_ssl=0/mysql_ssl=1/' mysql-dbd.pl'
:: [ 16:24:18 ] :: [   PASS   ] :: Enforcing SSL (Expected 0, got 0)
:: [ 16:24:19 ] :: [  BEGIN   ] :: Running 'grep mysql_ssl=1 mysql-dbd.pl'
$dsn = "DBI:mysql:database=$dbname;host=$dbhost;mysql_ssl=1";
:: [ 16:24:19 ] :: [   PASS   ] :: Command 'grep mysql_ssl=1 mysql-dbd.pl' (Expected 0, got 0)
:: [ 16:24:19 ] :: [   LOG    ] :: use DBD::mysql;
:: [ 16:24:19 ] :: [   LOG    ] :: $dsn = "DBI:mysql:database=$dbname;host=$dbhost;mysql_ssl=1";
$dbh = DBI->connect($dsn, $user, $password);
:: [ 16:24:19 ] :: [   LOG    ] :: MYSQLPORT=mysqlGetPort
:: [ 16:24:19 ] :: [  BEGIN   ] :: Running 'perl /home/dbtester-mysql-y5Ugl07O/mysql-dbd.pl 2>&1 | tee output.log'
DBI connect('database=dbtest;host=localhost;mysql_ssl=1','dbtester-mysql-y5Ugl07O',...) failed: SSL connection error: Enforcing SSL encryption is not supported at /home/dbtester-mysql-y5Ugl07O/mysql-dbd.pl line 13.
Unable to connect to dbtest
:: [ 16:24:19 ] :: [   PASS   ] :: Command 'perl /home/dbtester-mysql-y5Ugl07O/mysql-dbd.pl 2>&1 | tee output.log' (Expected 0, got 0)
:: [ 16:24:19 ] :: [  BEGIN   ] :: No SSL error in output :: actually running 'grep -q 'SSL.*error' output.log'
:: [ 16:24:19 ] :: [   FAIL   ] :: No SSL error in output (Expected 1, got 0)
:: [ 16:24:19 ] :: [  BEGIN   ] :: SSL version check :: actually running 'grep Ssl_version output.log | grep -v 'Ssl_version = $''
:: [ 16:24:19 ] :: [   FAIL   ] :: SSL version check (Expected 0, got 1)
:: [ 16:24:19 ] :: [  BEGIN   ] :: SSL verify mode check :: actually running 'grep Ssl_verify_mode output.log | grep -v 'Ssl_verify_mode = 0''
:: [ 16:24:19 ] :: [   FAIL   ] :: SSL verify mode check (Expected 0, got 1)
:: [ 16:24:19 ] :: [  BEGIN   ] :: SSL verify depth check :: actually running 'grep Ssl_verify_depth output.log | grep -v 'Ssl_verify_depth = 0''
:: [ 16:24:19 ] :: [   FAIL   ] :: SSL verify depth check (Expected 0, got 1)
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
::   Duration: 1s
::   Assertions: 5 good, 4 bad
::   RESULT: FAIL (SSL)