Bug #114960 ssl_session_data_print
Submitted: 10 May 2024 18:19 Modified: 13 May 2024 10:36
Reporter: Tony Chen (OCA) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: C API (client library) Severity:S3 (Non-critical)
Version:MySQL 8.4 OS:Linux (Amazon Linux 2)
Assigned to: CPU Architecture:x86
Tags: mtr

[10 May 2024 18:19] Tony Chen
Description:
On MySQL 8.4.0, the MTR `main.client_ssl_data_print` is failing, complaining that the `ssl_session_data_print` command isn't supported.

```
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ssl_session_data_print'.
```

Weirdly, I run into no such problems with the command when I start up the server normally. I do not see options specified during this MTR test that would cause such a behavior.

I am building with OpenSSL 1.1.1x.

How to repeat:
Just simply running the MTR test:

./mysql-test-run main.client_ssl_data_print

Suggested fix:
This is likely specific to my environment but I'm just opening up this bug report to track this issue and to possibly get some insight as to what differences in the MTR environment would cause this.
[13 May 2024 10:36] MySQL Verification Team
Hi Mr. Chen,

Thank you for your bug report.

We have run the test and got the following result:

[100%] main.client_ssl_data_print                [ pass ]     86

We are using our binaries available from dev.mysql.com.

Also, to make sure that your build is OK, please run this command:

 SHOW VARIABLES LIKE 'tls_version';

The output should be :
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| tls_version   | TLSv1.2,TLSv1.3 |
+---------------+-----------------+

In any case, please use our binary.

Can't repeat.