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

[Launchpad Bug Tracker]

You have been subscribed to a public bug by Lucas Kanashiro (lucaskanashiro):

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

** Affects: sphinxsearch (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: patch
-- 
Version 2.2.11 does not support MySQL 8 clients
https://bugs.launchpad.net/bugs/1855468
You received this bug notification because you are a member of Ubuntu Sponsors Team, which is subscribed to the bug report.