Bug #41975 Support for SSL options not included in mysqlbinlog

• Submitted: 8 Jan 2009 19:18
• Modified: 24 Sep 2013 14:41
• Reporter: Santo Leto
• Status: Closed
• Category: MySQL Server: Command-line Clients
• Severity: S4 (Feature request)
• Version: 5.0.x, 5.1.x
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any
• Tags: Contribution, mysqlbinlog, SSL

[8 Jan 2009 19:18] Santo Leto

Description:
Unlike other client programs (mysqldump, mysqladmin, ...) mysqlbinlog does not support ssl options.

How to repeat:
mysqlbinlog --help

[12 Jan 2009 11:32] MySQL Verification Team

thanks for the feature request.

all the other client program already have ssl options: mysql, mysqlcheck, mysqladmin, mysqlimport, mysqlslap, mysqltest, mysqlshow, mysql_upgrade

[2 Mar 2009 11:00] Andrew Hutchings

My patch to add SSL support to mysqlbinlog

Attachment: MySQL-5.1.31-binlog-ssl.patch (text/x-patch), 1.48 KiB.

[29 Aug 2013 11:21] MySQL Verification Team

Bug #69998 Marked as duplicate of this

[24 Sep 2013 14:41] Jon Stephens

Fixed in 5.7.3, documented as follows in the 5.7.3 changelog:

      mysqlbinlog now supports the same SSL options as mysql, 
      mysqladmin, and other MySQL client programs. See "SSL Command 
      Options", for more information.

Also updated options info for mysqlbinlog in the 5.7 Manual.

Closed.

[27 Aug 2014 14:45] Laurynas Biveinis

$ bzr log -r 6506
------------------------------------------------------------
revno: 6506
committer: Joao Gramacho <[e-mail]>
branch nick: mysql-trunk
timestamp: Tue 2013-09-17 11:41:26 +0100
message:
  WL#7198 Add SSL support for mysqlbinlog
  Bug#11751199 SUPPORT FOR SSL OPTIONS NOT INCLUDED IN MYSQLBINLOG
  
  Problem:
  =======
  Unlike other client programs (mysqldump, mysqladmin, ...) mysqlbinlog does
  not support SSL options.
  
  Users cannot use secure channels to query binlog of a remote server.
  
  Analysis:
  ========
  All MySQL client tools supporting SSL use the same set of SSL options to
  configure SSL support into a MySQL client connection with a given MySQL server.
  
  The code for supporting these SSL options in command line parameters, for
  creating SSL options variables (using its defaults) and for handling the SSL
  options during command line options evaluation already exists and is distributed
  in three include files.
  
  Fix:
  ===
  Included in mysqlbinlog references to sslopt-longopts.h, sslopt-vars.h and
  sslopt-case.h. Also, added the SSL options to the MySQL connection, so the
  client could effectively use SSL on its connection.