Proxysql: Enable X-Plugin connection over ProxySQL

[ShahriyarR]

Hi dear all,
Is there any possible way to open X session over proxysql?

[root@pxc_5_7 ~]# mysqlsh -uproxysql -pproxysql -h 127.0.0.1 --py --x --port=3306
mysqlx: [Warning] Using a password on the command line interface can be insecure.
Creating an X Session to [email protected]:3306
MySQL Error (2006): MySQL server has gone away

From proxysql.log

2016-07-15 12:16:14 mysql_data_stream.cpp:298:check_data_flow(): [ERROR] Session=0x7fc62a86a000, DataStream=0x7fc62aaf0800 -- Data at both ends of a MySQL data stream: IN <1 bytes 0 packets> , OUT <1 bytes 0 packets>

As general information:
X-Plugin will accept connections from 33060 port by default:

2016-07-15T07:21:09.454761Z 200 [Note] Plugin mysqlx reported: 'X plugin tcp connection enable at port 33060.'
2016-07-15T07:21:09.454959Z 200 [Note] Plugin mysqlx reported: 'Scheduler "work" started.'
2016-07-15T07:21:09.454976Z 200 [Note] Plugin mysqlx reported: 'X plugin initialization successes'
2016-07-15T07:21:09.484303Z 201 [Note] Plugin mysqlx reported: 'Using existing mysqlxsys@localhost account for authentication. Incomplete grants will be fixed'
2016-07-15T07:21:09.501627Z 0 [Note] Plugin mysqlx reported: 'Using OpenSSL for TCP connections'
2016-07-15T07:21:09.501752Z 0 [Note] Plugin mysqlx reported: 'Server starts handling incoming connections'

It is also impossible directly connect to MySQL:

[root@pxc_5_7 ~]# mysqlsh -uproxysql -pproxysql -h 127.0.0.1 --py --x --port=26100
mysqlx: [Warning] Using a password on the command line interface can be insecure.
Creating an X Session to [email protected]:26100
MySQL Error (2027): Unknown message received from server 10

For now the only way is to connect directly by default port:

[root@pxc_5_7 ~]# mysqlsh -uproxysql -pproxysql -h 127.0.0.1 --py --x --port=33060
mysqlx: [Warning] Using a password on the command line interface can be insecure.
Creating an X Session to [email protected]:33060
No default schema selected.

Welcome to MySQL Shell 1.0.4 Development Preview

[renecannao]

Hi Shahriyar,

X Plugin is currently not supported, and is currently not even in the near future roadmap. The main focus right now is only in the standard MySQL Protocol.

Thanks.

[rameshvs02]

Hi Rene,

Could you please include this info in the documentation.

Thanks,
Ramesh

[rcollina]

Hi @renecannao,
Any chance x-protocol support is being reconsidered?