In our product, we are using the Boost MySQL connector, but the connection to ProxySQL fails due to a server_capabilities error.
boost mysql error:
server_unsupported : The server does not support the minimum required capabilities to establish the connection.
While debugging the connection process, the Boost connector received a capabilities flag (2,173,696,559) from ProxySQL and compared it with its client capabilities flag (19,431,944).
Because the received server_caps does not contain the CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA flag, Boost returned client_errc::server_unsupported, and the connection was closed immediately.
I set the mysql-server_capabilities value to 2175791663, but the same error still occurred.
I think connector cannot receive CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA flag from ProxySQL's server_capabilities.
# proxysql --version
2024-11-25 07:09:48 [INFO] Using jemalloc with MALLOC_CONF: config.xmalloc:1, lg_tcache_max:16, opt.prof_accum:1, opt.prof_leak:1, opt.lg_prof_sample:20, opt.lg_prof_interval:30, rc:0
ProxySQL version 2.7.1-16-g2726c27, codename Truls
os version - ubuntu 22.04
boost version - 1.85.0
Hi, Team.
In our product, we are using the Boost MySQL connector, but the connection to ProxySQL fails due to a server_capabilities error.
boost mysql error: server_unsupported : The server does not support the minimum required capabilities to establish the connection.
While debugging the connection process, the Boost connector received a capabilities flag (2,173,696,559) from ProxySQL and compared it with its client capabilities flag (19,431,944).
Because the received server_caps does not contain the CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA flag, Boost returned client_errc::server_unsupported, and the connection was closed immediately.
I set the mysql-server_capabilities value to 2175791663, but the same error still occurred.
I think connector cannot receive CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA flag from ProxySQL's server_capabilities.