Bug #53431 admin plugin without --admin-lua-script leads to errors
Submitted: 5 May 2010 10:24 Modified: 9 Jan 2015 10:31
Reporter: Jan Kneschke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Proxy: Core Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Jan Kneschke CPU Architecture:Any

[5 May 2010 10:24] Jan Kneschke
Description:
Running the admin plugin with default values and connecting to the admin-port with the mysql client prints:

ERROR 1105 (07000): need a resultset + proxy.PROXY_SEND_RESULT

How to repeat:
$ mysql5 --port=4041 --user=... --password=...
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.99-agent-admin

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@127.0.0.1:4041 [(none)]> select 1;
...
ERROR 1105 (07000): need a resultset + proxy.PROXY_SEND_RESULT

Suggested fix:
Without a --admin-lua-script the plugin is useless. Force the user to provide a --admin-lua-script value.
[5 May 2010 10:48] Jan Kneschke
adjusted the category to MySQL Proxy: core
[5 May 2010 10:50] Enterprise Tools JIRA Robot
Jan Kneschke writes: 
revno: 1072
committer: jan@mysql.com
branch nick: trunk
timestamp: Wed 2010-05-05 12:46:53 +0200
message:
  set the name of the admin-lua-script as it is enforced now
------------------------------------------------------------
revno: 1071
committer: jan@mysql.com
branch nick: trunk
timestamp: Wed 2010-05-05 12:40:43 +0200
message:
  add the admin.lua to the distribution
------------------------------------------------------------
revno: 1070
fixes bug(s): http://bugs.mysql.com/53431
committer: jan@mysql.com
branch nick: trunk
timestamp: Wed 2010-05-05 12:40:11 +0200
message:
  enforce --admin-lua-script if the admin plugin is loaded incl. a hint which script to use
------------------------------------------------------------
revno: 1069
committer: jan@mysql.com
branch nick: trunk
timestamp: Wed 2010-05-05 12:39:24 +0200
message:
  provide a useful error-msg if the command isn't understood