Win32 - Monitor running processes

mcutting · Cacti Pro User Joined: 16 Oct 2006 Posts: 974

Every time I create a graph with this template, I get the following error in the log:

01/21/2008 09:41:38 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"update graph_templates_graph set name='|host_description| - Process - |query_hrSWRunName|' where local_graph_id=1978'

The graph seems to create and is updated - just wondered what this was ?

Thanks

streaker69 · Posted: Mon Jan 21, 2008 8:25 am Post subject:

Error:'1054' = Unknown column error. It would seem that query is just incorrect, as there probably isn't a column named:

|host_description| - Process - |query_hrSWRunName|

That would be my guess.

mcutting · Cacti Pro User Joined: 16 Oct 2006 Posts: 974

Thanks

Brashquido · Posted: Sat Apr 05, 2008 7:13 pm Post subject:

First off, great script!!

Have only two issues;

1) The memory usage value displayed for each process is in megabytes, however the unit used is in kilobytes. Is there anything I can do about this?

2) I suspect this is because of very low CPU usage, but I have a problem where the usage of a particular process is not displayed as a percentage and the value displayed is wildly incorrect. Any ideas why, and if it is possible to fix?

BSOD2600 · Posted: Sat Apr 05, 2008 7:59 pm Post subject:

1) hrSWRunPerfMem unit is defined to be "KBytes". rrdtool is simply reporting what it's getting from the host. If you want, you could create a CDEF to change from kb to mb (multiply by 1024.

2) the value have m or u in it? read http://forums.cacti.net/viewtopic.php?t=8168

Brashquido · Posted: Wed Apr 09, 2008 5:31 pm Post subject:

Ok, not worth it at this stage I think. Memory usage is reported correctly, just using the wrong units. As for second issue I don't think this can be corrected in Cacti unless there is a way to disable the autoscale on RRDTool.