[Bug 1855468] Re: Version 2.2.11 does not support MySQL 8 clients

[Lucas Kanashiro]

This patch will also fix part of this ruby-riddle regression [1] which
is holding ruby-defaults version 1:2.5.2 in proposed.

[1] https://bugs.launchpad.net/ubuntu/+source/ruby-riddle/+bug/1855475

-- 
You received this bug notification because you are a member of Ubuntu
Sponsors Team, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/1855468

Title:
  Version 2.2.11 does not support MySQL 8 clients

Status in sphinxsearch package in Ubuntu:
  New

Bug description:
  sphinxsearch package version 2.2.11-2build1 was rebuilt during MySQL 8
  transition (as all MySQL related packages, like clients), however, its
  handshake implementation of MySQL protocol does not support MySQL 8
  clients, not allowing connections. According to upstream release
  notes, it was fixed in version 3.1.1:
  http://sphinxsearch.com/docs/sphinx3.html#version-3.1.1-17-oct-2018

  Steps to reproduce this issue in a brand new LXD container (focal-
  amd64):

  $ apt install sphinxsearch ruby-mysql2 -y
  $ cp /etc/sphinxsearch/sphinx.conf.dist /etc/sphinxsearch/sphinx.conf
  $ searchd --config /etc/sphinxsearch/sphinx.conf      // ignore the warnings, not relevant to this bug
  $ irb
  irb(main):001:0> require 'mysql2'
  => true
  irb(main):002:0> Mysql2::Client.new(:host => '127.0.0.1', :port => 9306)
  Traceback (most recent call last):
          5: from /usr/bin/irb:11:in `<main>'
          4: from (irb):2
          3: from (irb):2:in `new'
          2: from /usr/lib/ruby/vendor_ruby/mysql2/client.rb:90:in `initialize'
          1: from /usr/lib/ruby/vendor_ruby/mysql2/client.rb:90:in `connect'
  Mysql2::Error (Unknown MySQL error)

  
  You should get the same result with other MySQL clients rebuilt against MySQL 8.

  Here is also the patch applied by manticoresearch (sphinxsearch fork)
  to fix this issue:
  https://github.com/manticoresoftware/manticoresearch/commit/ed98fdd7230c1d7298e1000fd10812338c6ba698

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/sphinxsearch/+bug/1855468/+subscriptions