Bug #45013 The Agent needs the proxy plugin to work now, even if you are not doing quan

• Submitted: 21 May 2009 17:36
• Modified: 22 May 2009 15:20
• Reporter: Diego Medina
• Status: Not a Bug
• Category: MySQL Enterprise Monitor: Agent
• Severity: S1 (Critical)
• Version: 2.1.0.1046
• OS: Any
• Assigned to: Jan Kneschke
• CPU Architecture: Any

[21 May 2009 17:36] Diego Medina

Description:
If you only add the Agent plugin to your ini file, you will not be able to run the agent.

You also need to add the proxy plugin to the ini file

This was introduced by adding the option of fetching the quan config from the UI

How to repeat:
1- install the agent and make sure to *not* enable query analyzer using the installer. Also install the service manager
2- Start the agent and Service manager
3- Look at the agent log and you will see

(critical) agent-items-xml.c:45: lua_pcall(): ....1/agent-2.1.0.1046/share/mysql-proxy/items/quan.lua:26: attempt to index global 'proxy' (a nil value)
(critical) agent.c:369: reading item-file no. 0 (name: '/Applications/mysql/enterprise/2.1/agent-2.1.0.1046/share/mysql-proxy/items/quan.lua') failed
(critical) shutting down normally
(critical) shutting down normally

[22 May 2009 9:20] Jan Kneschke

The installer shouldn't put the items/quan.lua into the agent-item-files list, if QUAN isn't requested.

[22 May 2009 15:10] Diego Medina

If you do not have the lua file, then there is nothing listening on port 4040 and the agent conencts to the dashboard and it all works.

I will not test the installer to see what it does.

[22 May 2009 15:20] Diego Medina

If you use the installer, and select "not" to use query analyzer, the installer does the right thing, which is:

on the mysql-monitor-agent.ini  file you will see
* agent-item-files = share/mysql-proxy/items/items-mysql-monitor.xml
* plugins=agent