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
• Status: Closed
• 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.