Threshold Plugin not sending emails
Moderators: Developers, Moderators
Re: Threshold Plugin not sending emails
Yes, and the other thold tables (just for good measure). You can have the import do the drop for you though.
Granted, 1st I have been trying to get you to actually run one of the failed SQL queries, as that will tell you what the problem is, but I haven't seen you do that yet.
Granted, 1st I have been trying to get you to actually run one of the failed SQL queries, as that will tell you what the problem is, but I haven't seen you do that yet.
Re: Threshold Plugin not sending emails
I have tried that and i still get nothing in the new server thold tab. When i try to import the thold_template table i get
#1054 - Unknown column 'bl_enabled' in 'field list'
#1054 - Unknown column 'bl_enabled' in 'field list'
Re: Threshold Plugin not sending emails
You need to import the table structure also, and have the import script drop the table first (or you can do that manually yourself).
Specifically you will want to add the --add-drop-table flag to the mysqldump command.
Specifically you will want to add the --add-drop-table flag to the mysqldump command.
Re: Threshold Plugin not sending emails
after doing it that way i now get
05/06/2014 10:53:05 AM - SYSTEM THOLD STATS: Time:0.0015 Tholds:0 TotalHosts:422 DownHosts:25 NewDownHosts:0
05/06/2014 10:53:05 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"UPDATE thold_data SET tcheck=0'
05/06/2014 10:53:05 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT data_id, rra_id, lastread, cdef FROM thold_data WHERE thold_enabled='on' AND tcheck=1"
But thold tab is still empty as well as thresholds and templates
05/06/2014 10:53:05 AM - SYSTEM THOLD STATS: Time:0.0015 Tholds:0 TotalHosts:422 DownHosts:25 NewDownHosts:0
05/06/2014 10:53:05 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"UPDATE thold_data SET tcheck=0'
05/06/2014 10:53:05 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT data_id, rra_id, lastread, cdef FROM thold_data WHERE thold_enabled='on' AND tcheck=1"
But thold tab is still empty as well as thresholds and templates
Re: Threshold Plugin not sending emails
It seems like it still didn't import the structure (now the table doesn't exist?). Can you run this query on the table?
Code: Select all
show columns from thold_data;
Re: Threshold Plugin not sending emails
here is the output.
mysql> show columns from thold_data;
+--------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| rra_id | int(11) | NO | MUL | 0 | |
| data_id | int(11) | NO | MUL | 0 | |
| thold_hi | varchar(100) | YES | | NULL | |
| thold_low | varchar(100) | YES | | NULL | |
| thold_fail_trigger | int(10) unsigned | YES | | NULL | |
| thold_fail_count | int(11) | NO | | 0 | |
| thold_alert | int(1) | NO | | 0 | |
| thold_enabled | enum('on','off') | NO | MUL | on | |
| bl_enabled | enum('on','off') | NO | | off | |
| bl_ref_time | int(50) unsigned | YES | | NULL | |
| bl_ref_time_range | int(10) unsigned | YES | | NULL | |
| bl_pct_down | int(10) unsigned | YES | | NULL | |
| bl_pct_up | int(10) unsigned | YES | | NULL | |
| bl_fail_trigger | int(10) unsigned | YES | | NULL | |
| bl_fail_count | int(11) unsigned | YES | | NULL | |
| bl_alert | int(2) | NO | | 0 | |
| lastread | varchar(100) | YES | | NULL | |
| oldvalue | varchar(100) | NO | | | |
| repeat_alert | int(10) unsigned | YES | | NULL | |
| notify_default | enum('on','off') | YES | | NULL | |
| notify_extra | varchar(255) | YES | | NULL | |
| host_id | int(10) | YES | | NULL | |
| syslog_priority | int(2) | YES | | 3 | |
| cdef | int(11) | NO | | 0 | |
| template | int(11) | NO | MUL | 0 | |
| template_enabled | char(3) | NO | MUL | | |
+--------------------+------------------+------+-----+---------+----------------+
27 rows in set (0.00 sec)
mysql> show columns from thold_data;
+--------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| rra_id | int(11) | NO | MUL | 0 | |
| data_id | int(11) | NO | MUL | 0 | |
| thold_hi | varchar(100) | YES | | NULL | |
| thold_low | varchar(100) | YES | | NULL | |
| thold_fail_trigger | int(10) unsigned | YES | | NULL | |
| thold_fail_count | int(11) | NO | | 0 | |
| thold_alert | int(1) | NO | | 0 | |
| thold_enabled | enum('on','off') | NO | MUL | on | |
| bl_enabled | enum('on','off') | NO | | off | |
| bl_ref_time | int(50) unsigned | YES | | NULL | |
| bl_ref_time_range | int(10) unsigned | YES | | NULL | |
| bl_pct_down | int(10) unsigned | YES | | NULL | |
| bl_pct_up | int(10) unsigned | YES | | NULL | |
| bl_fail_trigger | int(10) unsigned | YES | | NULL | |
| bl_fail_count | int(11) unsigned | YES | | NULL | |
| bl_alert | int(2) | NO | | 0 | |
| lastread | varchar(100) | YES | | NULL | |
| oldvalue | varchar(100) | NO | | | |
| repeat_alert | int(10) unsigned | YES | | NULL | |
| notify_default | enum('on','off') | YES | | NULL | |
| notify_extra | varchar(255) | YES | | NULL | |
| host_id | int(10) | YES | | NULL | |
| syslog_priority | int(2) | YES | | 3 | |
| cdef | int(11) | NO | | 0 | |
| template | int(11) | NO | MUL | 0 | |
| template_enabled | char(3) | NO | MUL | | |
+--------------------+------------------+------+-----+---------+----------------+
27 rows in set (0.00 sec)
Re: Threshold Plugin not sending emails
I thought you said you were running 0.4.9 on the old host? You are missing a ton of columns in that table.
Can you run that same command on the old host?
Can you run that same command on the old host?
Re: Threshold Plugin not sending emails
I upgraded it trying to fix it.
Below is output from old server that works.
mysql> show columns from thold_data;
+--------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| rra_id | int(11) | | MUL | 0 | |
| data_id | int(11) | | MUL | 0 | |
| thold_hi | varchar(100) | YES | | NULL | |
| thold_low | varchar(100) | YES | | NULL | |
| thold_fail_trigger | int(10) unsigned | YES | | NULL | |
| thold_fail_count | int(11) | | | 0 | |
| thold_alert | int(1) | | | 0 | |
| thold_enabled | enum('on','off') | | MUL | on | |
| bl_enabled | enum('on','off') | | | off | |
| bl_ref_time | int(50) unsigned | YES | | NULL | |
| bl_ref_time_range | int(10) unsigned | YES | | NULL | |
| bl_pct_down | int(10) unsigned | YES | | NULL | |
| bl_pct_up | int(10) unsigned | YES | | NULL | |
| bl_fail_trigger | int(10) unsigned | YES | | NULL | |
| bl_fail_count | int(11) unsigned | YES | | NULL | |
| bl_alert | int(2) | | | 0 | |
| lastread | varchar(100) | YES | | NULL | |
| oldvalue | varchar(100) | | | | |
| repeat_alert | int(10) unsigned | YES | | NULL | |
| notify_default | enum('on','off') | YES | | NULL | |
| notify_extra | varchar(255) | YES | | NULL | |
| host_id | int(10) | YES | | NULL | |
| syslog_priority | int(2) | YES | | 3 | |
| cdef | int(11) | | | 0 | |
| template | int(11) | | MUL | 0 | |
| template_enabled | char(3) | | MUL | | |
+--------------------+------------------+------+-----+---------+----------------+
27 rows in set (0.00 sec)
Below is output from old server that works.
mysql> show columns from thold_data;
+--------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| rra_id | int(11) | | MUL | 0 | |
| data_id | int(11) | | MUL | 0 | |
| thold_hi | varchar(100) | YES | | NULL | |
| thold_low | varchar(100) | YES | | NULL | |
| thold_fail_trigger | int(10) unsigned | YES | | NULL | |
| thold_fail_count | int(11) | | | 0 | |
| thold_alert | int(1) | | | 0 | |
| thold_enabled | enum('on','off') | | MUL | on | |
| bl_enabled | enum('on','off') | | | off | |
| bl_ref_time | int(50) unsigned | YES | | NULL | |
| bl_ref_time_range | int(10) unsigned | YES | | NULL | |
| bl_pct_down | int(10) unsigned | YES | | NULL | |
| bl_pct_up | int(10) unsigned | YES | | NULL | |
| bl_fail_trigger | int(10) unsigned | YES | | NULL | |
| bl_fail_count | int(11) unsigned | YES | | NULL | |
| bl_alert | int(2) | | | 0 | |
| lastread | varchar(100) | YES | | NULL | |
| oldvalue | varchar(100) | | | | |
| repeat_alert | int(10) unsigned | YES | | NULL | |
| notify_default | enum('on','off') | YES | | NULL | |
| notify_extra | varchar(255) | YES | | NULL | |
| host_id | int(10) | YES | | NULL | |
| syslog_priority | int(2) | YES | | 3 | |
| cdef | int(11) | | | 0 | |
| template | int(11) | | MUL | 0 | |
| template_enabled | char(3) | | MUL | | |
+--------------------+------------------+------+-----+---------+----------------+
27 rows in set (0.00 sec)
-
- Posts: 6
- Joined: Fri Feb 20, 2015 12:33 am
Re: Threshold Plugin not sending emails
Hi, I am having similar issues - thold tab hangs the server for nearly 2 minutes. I have checked the thold table and it has all of the columns. I have removed plugin, dropped all tables etc and reinstalled without any change.
Any thoughts?
Simon
Any thoughts?
Simon
Who is online
Users browsing this forum: No registered users and 5 guests