thold plugin 0.4.6 screenshots

[skatter]

Update to 0.4.8-2. There was a conflict with weathermap.

Downloaded http://docs.cacti.net/_media/plugin:thold-v0.4.8-2.tgz, deinstalled 0.4.8-1, re-installed 0.4.8-2 with the same results as before. No MySQL tables are created, and the same errors are generated in my apache error log.

I can confirm that installing/uninstalling Mac Track from PIA adds/deletes tables to the cacti DB, so I'm not sure what is being done differently in thold.

Code: Select all

| mac_track_aggregated_ports   |
| mac_track_approved_macs      |
| mac_track_device_types       |
| mac_track_devices            |
| mac_track_interfaces         |
| mac_track_ip_ranges          |
| mac_track_ips                |
| mac_track_macauth            |
| mac_track_macwatch           |
| mac_track_oui_database       |
| mac_track_ports              |
| mac_track_processes          |
| mac_track_scan_dates         |
| mac_track_scanning_functions |
| mac_track_sites              |
| mac_track_snmp               |
| mac_track_snmp_items         |
| mac_track_temp_ports         |
| mac_track_vlans              |

[TheWitness]

Weird. Dump you db and pm it to me.

[pmacct]

Same issue here with 0.4.8-3 on cacti 0.8.7g with all official patches running on php 5.3.6 and mysql 5.5.15. Did you successfully isolated the issue ?

[skatter]

Same issue here with 0.4.8-3 on cacti 0.8.7g with all official patches running on php 5.3.6 and mysql 5.5.15. Did you successfully isolated the issue ?

No, the issue remains.

[TheWitness]

There is something definitely wrong with your install then. I can't help you I guess.

[uhtred]

Hi,

1. i got an error in my apache log, if i click 'View Graph' of a Threshold at Thresholds Tab

[Thu Oct 27 13:03:00 2011] [error] [client 172.20.254.225] PHP Notice: Uninitialized string offset: 1 in /var/www/cacti/lib/functions.php on line 1806, referer: http://172.20.1.95/cacti/plugins/thold/ ... 30&filter=

2. Triggering doesn't work for High/Low Type
value is at 2 & alert setting is 2 --> not Triggered
Bug or wrong settings?

[TheWitness]

It has to be above '2'.

[skatter]

There is something definitely wrong with your install then. I can't help you I guess.

Well, if I could manually create the thold tables (thold.sql), or debug why the tables aren't being created through the PIA install method, that would be a start.

Are the above options not possible?

[uhtred]

Hi,

with my settings i dont get any restoral events via mail.

[TheWitness]

What does the log look like for the thold in question?

[uhtred]

log i.e.:
11/02/2011 03:13:18 PM - THOLD: Threshold Breached ID: 379 DataTemplate: Interface - Status DataSource: intf_1min_status Type: Time Based Enabled: on Current: 2 High: 1.9 Low: Trigger: 1 Time: 10 Minutes Warning High: 1.9 Warning Low: Warning Trigger: 1 Warning Time: 10 Minutes SentTo: me@you.com

11/02/2011 03:24:07 PM - THOLD: Threshold Breached ID: 379 DataTemplate: Interface - Status DataSource: intf_1min_status Type: Time Based Enabled: on Current: 1 High: 1.9 Low: Trigger: 1 Time: 10 Minutes Warning High: 1.9 Warning Low: Warning Trigger: 1 Warning Time: 10 Minutes SentTo:

[TheWitness]

Thold log, not Cacti log.

[uhtred]

sry

[pmacct]

There is something definitely wrong with your install then. I can't help you I guess.

The issue was caused because the use of TYPE = MyISAM is deprecated and obsolete in mysql 5.5.15. Instead the ENGINE keyword should be used. Thold was using the api_plugin_db_table_create function, which is declared in lib/plugins.php. I had to replace line 181 from lib/plugins.php :

$sql .= ') TYPE = ' . $data['type'];

with

$sql .= ') ENGINE = ' . $data['type'];


It seems to work fine now. Thanks for this wonderfull plugin.

This issue is affecting all the plugins that use the api_plugin_db_table_create function, maybe there should be a patch applied for this. I'm using version 0.8.7g with all official patches, I don't know if this was changed in the latest 0.8.7h.

[TheWitness]

It's more of MySQL issue by deprecating something for no good reason