Bug #44361 unknown COM_* returned from proxy
Submitted: 20 Apr 2009 8:01 Modified: 20 Apr 2009 13:04
Reporter: Eirik Øverby Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Proxy: Core Severity:S1 (Critical)
Version:0.6.1 OS:FreeBSD (7.1-p4)
Assigned to: CPU Architecture:Any

[20 Apr 2009 8:01] Eirik Øverby
Any command from the interactive mysql client to the proxy will return either of

  mysql> use mysql
  ERROR 1105 (07000): unknown COM_*
  mysql> select * from mysql.user;
  ERROR 1105 (07000): booh

In the first case, mysql-proxy does not print anything to stdout/stderr. In the latter, it will print

  table 'mysql.user' not found

The following software is installed:
mysql-client-5.0.51a Multithreaded SQL database (client)
mysql-proxy-0.6.1_3 Monitor, analyze or transform the communication of MySQL
mysql-server-5.0.51a Multithreaded SQL database (server)

How to repeat:
Install mysql-proxy on a FreeBSD system. Run the client from any nearby system. Execute any query or command.
[20 Apr 2009 13:04] Eirik Øverby