Bug #31018 Can connect, but any action it showed Error: Booh
Submitted: 14 Sep 2007 4:29 Modified: 23 Sep 2007 21:31
Reporter: yong huang Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Proxy Severity:S1 (Critical)
Version:mysql-proxy 0.5.1 OS:Linux (2.6.15-1.2054_FC5 #1 SMP)
Assigned to: CPU Architecture:Any

[14 Sep 2007 4:29] yong huang
Description:
download a FC4 binary and run it on FC5 box. 
vandba@icecube:~$./mysql-proxy --proxy-backend-addresses=toady:3306 --proxy-fix-bug-25371

running fine. 

Then,

vandba@cooler:~$ mysql -uroot -hicecube -P4041 -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.1.20-agent

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show processlist;
ERROR:
booh

How to repeat:
see above

Suggested fix:
cannot download the source...
[23 Sep 2007 10:57] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 0.6.0 (see http://dev.mysql.com/downloads/mysql-proxy/index.html) and inform about the results.
[23 Sep 2007 21:31] Giuseppe Maxia
If you use port 4041, you are invoking the administrative interface not the Proxy itself.
The admin interface does not recognize normal SQL commands. Thus, it's normal that it fails with "booh".

Use port 4040 and you will see the difference.