HMIB Issues

[ARC1450]

Code: Select all

11/16/2011 11:48:50 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT COUNT(*) FROM plugin_hmib_hrSWInstalled AS hrswi INNER JOIN host ON host.id=hrswi.host_id INNER JOIN plugin_hmib_hrSystem AS hrs ON host.id=hrs.host_id WHERE hrs.host_type="
11/16/2011 11:48:50 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT hrswi.*, host.hostname, host.description, host.disabled FROM plugin_hmib_hrSWInstalled AS hrswi INNER JOIN host ON host.id=hrswi.host_id INNER JOIN plugin_hmib_hrSystem AS hrs ON host.id=hrs.host_id WHERE hrs.host_type= ORDER BY name ASC LIMIT 0,1000"
11/16/2011 11:48:48 AM - TEST: Poller[0] running_legend totals: N;
11/16/2011 11:48:48 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT ROUND(SUM(perfCPU),2) as cpu, ROUND(SUM(perfMemory),2) as memory FROM plugin_hmib_hrSWRun AS hrswr INNER JOIN host ON host.id=hrswr.host_id INNER JOIN plugin_hmib_hrSystem AS hrs ON hrs.host_id=host.id INNER JOIN plugin_hmib_hrSystemTypes AS hrst ON hrst.id=hrs.host_type WHERE hrswr.name!='' AND hrswr.name!='System Idle Process' AND hrs.host_type="
11/16/2011 11:48:48 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT COUNT(*) FROM plugin_hmib_hrSWRun AS hrswr INNER JOIN host ON host.id=hrswr.host_id INNER JOIN plugin_hmib_hrSystem AS hrs ON hrs.host_id=host.id INNER JOIN plugin_hmib_hrSystemTypes AS hrst ON hrst.id=hrs.host_type WHERE hrswr.name!='' AND hrswr.name!='System Idle Process' AND hrs.host_type="
11/16/2011 11:48:48 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT hrswr.*, host.hostname, host.description, host.disabled FROM plugin_hmib_hrSWRun AS hrswr INNER JOIN host ON host.id=hrswr.host_id INNER JOIN plugin_hmib_hrSystem AS hrs ON hrs.host_id=host.id INNER JOIN plugin_hmib_hrSystemTypes AS hrst ON hrst.id=hrs.host_type WHERE hrswr.name!='' AND hrswr.name!='System Idle Process' AND hrs.host_type= ORDER BY name ASC LIMIT 0,1000"
11/16/2011 11:48:44 AM - SYSTEM THOLD STATS: Time:5.7173 Tholds:2336 DownHosts:0
11/16/2011 11:48:38 AM - SYSTEM STATS: Time:24.5554 Method:spine Processes:4 Threads:10 Hosts:428 HostsPerProcess:107 DataSources:46749 RRDsProcessed:0
11/16/2011 11:48:20 AM - SPINE: Poller[0] ERROR: SS[1] PHP Script Server communications lost. Restarting PHP Script Server
11/16/2011 11:48:19 AM - TEST: Poller[0] running_legend totals: N;
11/16/2011 11:48:19 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT ROUND(SUM(perfCPU),2) as cpu, ROUND(SUM(perfMemory),2) as memory FROM plugin_hmib_hrSWRun AS hrswr INNER JOIN host ON host.id=hrswr.host_id INNER JOIN plugin_hmib_hrSystem AS hrs ON hrs.host_id=host.id INNER JOIN plugin_hmib_hrSystemTypes AS hrst ON hrst.id=hrs.host_type WHERE hrswr.name!='' AND hrswr.name!='System Idle Process' AND hrs.host_type="
11/16/2011 11:48:19 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT COUNT(*) FROM plugin_hmib_hrSWRun AS hrswr INNER JOIN host ON host.id=hrswr.host_id INNER JOIN plugin_hmib_hrSystem AS hrs ON hrs.host_id=host.id INNER JOIN plugin_hmib_hrSystemTypes AS hrst ON hrst.id=hrs.host_type WHERE hrswr.name!='' AND hrswr.name!='System Idle Process' AND hrs.host_type="
11/16/2011 11:48:19 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT hrswr.*, host.hostname, host.description, host.disabled FROM plugin_hmib_hrSWRun AS hrswr INNER JOIN host ON host.id=hrswr.host_id INNER JOIN plugin_hmib_hrSystem AS hrs ON hrs.host_id=host.id INNER JOIN plugin_hmib_hrSystemTypes AS hrst ON hrst.id=hrs.host_type WHERE hrswr.name!='' AND hrswr.name!='System Idle Process' AND hrs.host_type= ORDER BY name ASC LIMIT 0,1000" 

For some odd reason, these errors keep popping up when I try to view anything under the HMIB tab. What's the MySQL version this was tested against, just curious?

[ARC1450]

Okay. . .so after a little checking, the OS Types aren't coming through. For whatever reason, when I run a query against the supposed version OIDs, I get a "No Such Object" issue.

Since I'm not exactly a server guy, can anyone point me to something resembling help?

[TheWitness]

Is this when you press the 'Rescan' button? If so, report the OS and version of Net-SNMP.

[ARC1450]

Is this when you press the 'Rescan' button? If so, report the OS and version of Net-SNMP.

No, it is when I do an "snmpwalk" against the OID listed in the "OS Type".

Dumb question, but do you mean the OS and Net-SNMP version of the Cacti server?

If so, it's Windows 2008 and Net-SNMP 5.5.0.

[edit]
I see this:

Code: Select all

11/17/2011 09:00:04 AM - TEST: Poller[0] running_legend totals: a:2:{s:3:"cpu";N;s:6:"memory";N;} 

in the log file when I try to run a query against any of the servers for say, storage or hardware or whatever.

[ARC1450]

Any thoughts?

I tossed the devices into MACTrack to try and get the Vendor OID. Vendor OID is correct (why I can't query it, I have no clue).

The only thing I can think of is that I have 57 different Windows hosts and for some reason, HMIB just doesn't like differentiating between them.

[TheWitness]

For the life of me I'm confused. Need pictures.