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

[Launchpad Bug Tracker]

This bug was fixed in the package sphinxsearch - 2.2.11-2ubuntu1

---------------
sphinxsearch (2.2.11-2ubuntu1) focal; urgency=medium

  * Fix handshake implementation of MySQL protocol to support MySQL 8
    clients. (LP: #1855468)

 -- Lucas Kanashiro <lucas.kanashiro at canonical.com>  Fri, 06 Dec 2019
14:38:22 -0300

** Changed in: sphinxsearch (Ubuntu)
       Status: New => Fix Released

-- 
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:
  Fix Released

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