MySQL Bugs: #45460: Return nicely formated xml back to the agent

Bug #45460	Return nicely formated xml back to the agent
Submitted:	11 Jun 2009 19:13	Modified:	27 Jul 2009 15:54
Reporter:	Diego Medina	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Server	Severity:	S4 (Feature request)
Version:	2.1.0.1060	OS:	Any
Assigned to:	Darren Oldag	CPU Architecture:	Any

Description:
When we look at the agent debug log, specially the xml returned by the service manager, it lacks carriage returns, making it difficult to read (by a human)

It would be nice if we could see nicely formatted xml, like we see the xml that agent sends to the service manager.

Workaround: Use tidy to clean up the xml.

How to repeat:
1- Install and start the service manager
2- Set the log-level = debug on the agent
3- start the agent
4- look at the log, and you will see how the xml that comes from the service manager is all in one line.

Andy Bang writes: 
It says "Patch queued" in the bug report so this should be available in build 2.1.0.1071, but there are no notes indicating that someone actually committed anything to fix this. If it's not fixed, set it back to Verified.

Diego Medina writes: 
Verified fixed on 2.1.0.1071

On the agent log, on log-level=debug, you see

2009-06-24 13:37:09: (debug) network-io.c:73: HTTP/1.1 200 OK
2009-06-24 13:37:09: (debug) network-io.c:73: Server: Apache-Coyote/1.1
2009-06-24 13:37:09: (debug) network-io.c:73: Content-Type: text/xml;charset=utf-8
2009-06-24 13:37:09: (debug) network-io.c:73: Content-Length: 231
2009-06-24 13:37:09: (debug) network-io.c:73: Date: Wed, 24 Jun 2009 17:37:09 GMT
2009-06-24 13:37:09: (debug) network-io.c:73: Connection: close
2009-06-24 13:37:09: (debug) network-io.c:73:
2009-06-24 13:37:09: (debug) network-io.c:73: <?xml version="1.0"?>
<doc>
  <tasks>
    <task>
      <taskId>-1</taskId>
      <command><![CDATA[resynchronize]]></command>
      <utc>
      </utc>
    </task>
  </tasks>
  <agentId><![CDATA[1245865029870.1]]></agentId>
</doc>
2009-06-24 13:37:09: (debug) network-io.c:73: Closing connection #0
2009-06-24 13:37:09: (debug) network-io.c:73: SSLv3, TLS alert, Client hello (1):
2009-06-24 13:37:09: (debug) network-io.c:73: ^A
2009-06-24 13:37:09: (debug) <-- received: <?xml version="1.0"?>
<doc>
  <tasks>
    <task>
      <taskId>-1</taskId>
      <command><![CDATA[resynchronize]]></command>
      <utc>
      </utc>
    </task>
  </tasks>
  <agentId><![CDATA[1245865029870.1]]></agentId>
</doc>^M

A 'change' entry has been added to the 2.1.0 changelog:

When the Agent debug log was examined, it was found to contain XML returned by the Service Manager that did not contain carriage returns. This made the data difficult to read by a human. The Service Manager has been changed to return formatted XML.