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] Miguel Solorzano
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.