Are you specifying an admin script?
In the newer versions of the proxy, you must specify an administration script to be used when users connect to the administration interface.
So for example, you can download the two scripts (copy/paste) on the following page (save the first as "admin.lua" and the second one as "reporter.lua"):
http://dev.mysql.com/doc/refman/5.0/en/mysql-proxy-using-admin.html
And then you would invoke the proxy as follows:
shell> mysql-proxy --admin-lua-script=admin.lua --admin-password=password \ ยป
--admin-username=root --proxy-backend-addresses=127.0.0.1:3306 -proxy-lua-script=reporter.lua
Using these two scripts will allow you to use the following functions:
show querycounter
show myerror
show proxy processlist
SELECT * FROM backends
(Note that I did edit the above to change --backend-addresses to --proxy-backend-addresses or there would be an error. I've submitted a bug report about this as well, to have it updated in the documentation.)
http://bugs.mysql.com/bug.php?id=53013
Edited 1 time(s). Last edit at 04/20/2010 05:25PM by Chris Calender.