Public bug reported:
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
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1855468
Title:
Version 2.2.11 does not support MySQL 8 clients
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/sphinxsearch/+bug/1855468/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
