Cannot connect to ProxySQL with boost mysql.

[Lyricia]

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).

1000 0001 1000 1111 1111 1010 0010 1111 -> proxysql server_ capabilities
0000 0001 0010 1000 1000 0010 0000 1000 -> boost::mysql required_caps

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