Bug #19606 ssl variables are not displayed in show variables

Submitted: 8 May 2006 13:16 Modified: 22 May 2006 13:28
Reporter: Oli Sennhauser Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.0.21 and 5.1.9 OS:any?
Assigned to: Jim Winstead CPU Architecture:Any

[8 May 2006 13:16] Oli Sennhauser
Description:
ssl variables like

ssl-ca          = /u00/app/mysql/openssl/cacert.pem
ssl-cert        = /u00/app/mysql/openssl/client-cert.pem
ssl-key         = /u00/app/mysql/openssl/client-key.pem

can be set in the my.cnf but do NOT appear in show variables like ...

How to repeat:
my.cnf:

[mysqld]
...
ssl-ca          = /u00/app/mysql/openssl/cacert.pem
ssl-cert        = /u00/app/mysql/openssl/client-cert.pem
ssl-key         = /u00/app/mysql/openssl/client-key.pem
...

show variables like 'ssl%';

Suggested fix:
add these values/variable to the show variables list/table.
[8 May 2006 13:23] MySQL Verification Team
Thank you for the bug report. I noticed that when handling bug:
http://bugs.mysql.com/bug.php?id=19547.
[8 May 2006 23:36] Jim Winstead
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6131
[20 May 2006 6:07] Jim Winstead
Fixed in 5.0.22 and 5.1.11.
[22 May 2006 13:28] Paul DuBois
Noted in 5.0.22, 5.1.11 changelogs.

Added the <literal>ssl_ca</literal>,
<literal>ssl_capath</literal>, <literal>ssl_cert</literal>,
<literal>ssl_cipher</literal>, and <literal>ssl_key</literal>
system variables, which display the values given via the
corresponding command options.

Also added entries for these variables in the section that
lists system variables.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.