thold wont poll?? all latest versions - jimmy??

[tribune]

Hi guys / Jimmy,

Wanted to get the threshold plugin going today but hit more drama than I had actually expected

I have the following :

Centos 5
Apache/2.2.3
MySQL 5.0.22
PHP 5.1.6 (Zend Engine v2.1.0)

Cacti Version 0.8.7b
Program ........ Plugin Architecture
Version ........ 2.1
Thold 0.3.9

Than with all that, was receiving the Last Poll: Poller has not yet ran!
Checking the cacti logs and was getting the following error :

04/29/2008 05:47:56 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select thold_data.cdef, thold_data.rra_id, thold_data.data_id, thold_data.lastread, thold_data.oldvalue, data_template_rrd.data_source_name as name, data_template_rrd.data_source_type_id from thold_data LEFT JOIN data_template_rrd on (data_template_rrd.id = thold_data.data_id) WHERE data_template_rrd.data_source_name != '' AND "

With a bit of googling and reading this forum and another cacti forum, I found the below Fix/hack (whichever way you look at it) and the error disappeared. (inserted the following code in the setup.php file for thold to replace the $thold_items = db_fetch line.

if ( $rra_ids ) {
$thold_items = db_fetch_assoc("select thold_data.cdef, thold_data.rra_id, thold_data.data_id, thold_data.lastread, thold_data.oldvalue, data_template_rrd.data_source_name as name, data_template_rrd.data_source_type_id from thold_data
LEFT JOIN data_template_rrd on (data_template_rrd.id = thold_data.data_id)
WHERE data_template_rrd.data_source_name != '' AND $rra_ids");
} else {
$thold_items = db_fetch_assoc("select thold_data.cdef, thold_data.rra_id, thold_data.data_id, thold_data.lastread, thold_data.oldvalue, data_template_rrd.data_source_name as name, data_template_rrd.data_source_type_id from thold_data
LEFT JOIN data_template_rrd on (data_template_rrd.id = thold_data.data_id)
WHERE data_template_rrd.data_source_name != ''");
}

After this I thought perhaps I had missed something, and figured it must be the Data Sources section, as mentioned when you click on "Thresholds" under Management.

To add more elements - go to:
'Data Sources' -> 'select a host' (on top) -> and click the 'Template Name / Click for THold' section for the desired element

Now when I do this, I presume by (on top) its meaning select a host from the drop down host box.

Did that, no prob

The next part however "click the 'Template Name / Click for THold' section for the desired element ????

I've read and re-read that line all day and still confuses me does it mean there should be a template in the template drop down box called "Click for THold" ???

Or do I just select a template such as "Unix - load average" ??

There is nothing in that template drop down box that resembles "Click for THold" for example just a whole bunch of my other templates used.

The method of installing the PA 2.1 was by syncing up the newer files, I did not opt to patch if that makes any difference, I thought this would work better to be honest. Than also imported the pa.sql file.

I followed those instructions as per - http://cactiusers.org/wiki/PluginArchitectureInstall

Guys any help would be greatly appreciated..

I've seemed to have exhausted all avenues I can think of currently to get this up and operational.

Thanks in advance for all help.

[jimmy]

The error isn't anything serious, its a minor bug when you have no thresholds setup, but it doesn't stop actual polling.

Easy way to create a threshold. Goto the console, click on Threshold Templates (under Templates). Then create a template. Then goto a device that has a graph for the threshold template you setup previously. Click on the device, and then click "Create Graphs" at the top, then click "Auto-create thresholds"

[tribune]

Ahh ok,

that explains it a lot clearer for me on how it is supposed to work, you can only setup thresholds on items that are already graphed.

Thanks for the quick reply jimmy!! appreciate it