Thold (and monitor) not sending emails after thold 1.8.1 upgrade

Hello, On Jun 14th I upgraded from thold 1.5.2 ( 1.5.2 up to git commit 20682cb) to thold 1.8.1. Since then, I no longer get email alerts from thold or monitor (both stopped on the same date). Have tried updating thold & monitor to their latest github commits.

Currently Running: Cacti - 1.2.27 Thold - 1.8.1 up to git commit b822704 (1 commit behind current) Monitor - 2.7 up to git commit 1d10911 (believe is current version) I see this on two different openSuSE - 15.6 (latest) and 15.5 (still supported, but one release behind) cmd.php poller, not spine

I'm guessing the lack of email alerts is somehow related to these thold errors ?:

2024/09/24 08:30:18 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '53-0' for key 'PRIMARY' 2024/09/24 08:30:18 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/24 08:30:18 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '56-0' for key 'PRIMARY' 2024/09/24 08:30:18 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/24 08:30:18 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '54-0' for key 'PRIMARY' 2024/09/24 08:30:18 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/24 08:30:18 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '52-0' for key 'PRIMARY' 2024/09/24 08:30:18 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/24 08:30:18 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '58-0' for key 'PRIMARY' 2024/09/24 08:30:18 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) But I don't understand what they mean or where to look in the database for errors?

These are my current Thold settings (I've tried with & without Threshold Daemon and with & without Notification Queue)

My notification queue is empty

Can you handle this @xmacan ?

@TheWitness ok, tomorrow

@iamnacho please show result of sql query: show create table plugin_thold_daemon_data;

@iamnacho please try disabling thold_daemon and disabling the notification queue. After disabling them, you should not get the "duplicate record" error. Maybe you will have another error in log, post it here

@iamnacho please test it and let me know

show create table plugin_thold_daemon_data;

| plugin_thold_daemon_data | CREATE TABLEplugin_thold_daemon_data( idint(11) NOT NULL, poller_idint(10) unsigned NOT NULL DEFAULT 1, thread_idint(10) unsigned NOT NULL DEFAULT 0, rrd_reindexedvarchar(600) NOT NULL DEFAULT '', rrd_time_reindexedint(10) unsigned NOT NULL, timetimestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (id,thread_id), KEYpoller_id(poller_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Table of Poller Outdata needed for queued daemon processes' | +--------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

With just updating the plugin to the latest commit, still getting errors in log (see below)

Will try disabling Notification Queue & Threshold Daemon now.

2024/09/25 14:30:22 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '58-0' for key 'PRIMARY' 2024/09/25 14:30:22 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:22 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '52-0' for key 'PRIMARY' 2024/09/25 14:30:22 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:22 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '54-0' for key 'PRIMARY' 2024/09/25 14:30:22 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:22 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '56-0' for key 'PRIMARY' 2024/09/25 14:30:20 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:20 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '53-0' for key 'PRIMARY' 2024/09/25 14:30:12 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:12 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '76-0' for key 'PRIMARY' 2024/09/25 14:30:08 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:08 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '55-0' for key 'PRIMARY' 2024/09/25 14:30:06 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:06 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '74-0' for key 'PRIMARY' 2024/09/25 14:30:06 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:06 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '75-0' for key 'PRIMARY' 2024/09/25 14:30:05 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[824]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:05 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '82-0' for key 'PRIMARY' 2024/09/25 14:30:05 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[824]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:05 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '77-0' for key 'PRIMARY' 2024/09/25 14:30:05 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[824]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:05 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '23-0' for key 'PRIMARY' 2024/09/25 14:30:05 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[824]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:05 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '18-0' for key 'PRIMARY' 2024/09/25 14:30:05 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[824]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:05 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '1-0' for key 'PRIMARY' 2024/09/25 14:30:04 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:04 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '81-0' for key 'PRIMARY' 2024/09/25 14:30:04 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:04 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '78-0' for key 'PRIMARY' 2024/09/25 14:30:04 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:04 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '59-0' for key 'PRIMARY' 2024/09/25 14:30:04 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:04 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '17-0' for key 'PRIMARY' 2024/09/25 14:30:04 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:04 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '6-0' for key 'PRIMARY' 2024/09/25 14:30:04 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:04 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '5-0' for key 'PRIMARY' 2024/09/25 14:30:02 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[824]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:02 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '45-0' for key 'PRIMARY' 2024/09/25 14:30:02 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[824]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:02 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '9-0' for key 'PRIMARY' 2024/09/25 14:30:02 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[824]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:02 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '8-0' for key 'PRIMARY' 2024/09/25 14:30:02 - CMDPHP SQL Backtrace: (/poller.php[780]:process_poller_output(), /lib/poller.php[824]:process_poller_output(), /lib/poller.php[805]:api_plugin_hook_function(), /lib/plugins.php[161]:api_plugin_run_plugin_hook_function(), /lib/plugins.php[282]:thold_poller_output(), /plugins/thold/includes/polling.php[124]:db_execute(), /lib/database.php[385]:db_execute_prepared()) 2024/09/25 14:30:02 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate entry '65-0' for key 'PRIMARY'

@iamnacho please test it and let me know

@xmacan I think it's not working/fixed. I disabled Notification Queue & Threshold Daemon and now there are not the duplicate entry errors in the log, but I'm not getting alerts.

As a test, I create a new threshold and let it run a couple of polling cycles. It's stuck green and has not triggered (nor emailed), though I think it should be triggered??

Was a simple test, alert if more than 2 users show logged in on a graph/data source that shows 7 users logged in. Unless I made an error during the fast creation of the test threshold, I think it's not working still. 1_thold_not_triggering 2_thold_user_graph 3_thold_settings1 4_thold_settings2

Console -> Configuration -> settings -> Mail/reporting/dns tab -> Send a Test Email - is it working? How is set alerting? Via notification list of Alert/warning emails?

You have incorrect table definition, run: ALTER TABLE plugin_thold_daemon_data DROP INDEX poller_id;

Console -> Configuration -> settings -> Mail/reporting/dns tab -> Send a Test Email - is it working? How is set alerting? Via notification list of Alert/warning emails?

Test mail works. Originally was a list of email addresses (comma-separated,) but I changed it to notification lists as a test. This did not help and mails still do not come.

I've altered the table, that would just help with thold daemon right? not non-demon?

You should see something in the log when email notification is triggered.

Are you using maint plugin? If devices are in maintenance plan, alerting is disabled.

Yes, altered table is for deamon.

You should see something in the log when email notification is triggered.

Are you using maint plugin? If devices are in maintenance plan, alerting is disabled.

Yes, altered table is for deamon.

Yes, we have maint plugin installed, but not sure we are using it?? In Management -> Maintenance Schedules there are no schedules set. Is that what you mean by "if devices are in maintenance plan"?

Nothing in cacti log showing alerts and My thold tab -> log does not show any data/logs after Jun 14th (when upgraded to 1.8.1 & emails stopped).

You should see something in the log when email notification is triggered. Are you using maint plugin? If devices are in maintenance plan, alerting is disabled. Yes, altered table is for deamon.

Yes, we have maint plugin installed, but not sure we are using it?? In Management -> Maintenance Schedules there are no schedules set. Is that what you mean by "if devices are in maintenance plan"?

so, ok, no maintenance plan

Nothing in cacti log showing alerts and My thold tab -> log does not show any data/logs after Jun 14th (when upgraded to 1.8.1 & emails stopped).

check cacti log too

Nothing in cacti log showing alerts. For the test threshold I made yesterday cacti log says: 2024/09/26 09:15:03 - THOLD: Checking Threshold: Name: 'USER PC - Logged in Users [users]', Graph: '11347'

And I think it should be triggered, but is not. I've set the alert high value = 2 & the current value is 7. So should be triggered, yes?

thold_not_triggered_2

Why not triggered???

Strange. Try to set warning high/log to 1. Maybe only alert is broken. Did you try delete this thold and create it again?

This is a thold I created yesterday after updating to the latest version and testing without luck. An attempt to have a thold that should send an email immediate & every 5mins to test.

I modified it to add a warning, but still shows not triggered & no email is sent.: thold_not_triggered_3 and thold_not_triggered_4

Is it possible to post here cacti log, at least one poller cycle? Or you can send it to my email (petr.macek@kostax.cz)

Here's an anonymized log (changed names/IPs)

2024/09/26 10:25:37 - SYSTEM STATS: Time:36.9105 Method:cmd.php Processes:10 Threads:1 Hosts:310 HostsPerProcess:31 DataSources:8759 RRDsProcessed:6240 2024/09/26 10:25:31 - 0: Poller[Main Poller] PID[14529] WARNING: SNMP Error:'snmp2_get(): No response from PC2_IP_WAS_HERE', Device:'PC2_IP_WAS_HERE', OID:'.1.3.6.1.2.1.25.2.3.1.5.2' 2024/09/26 10:25:21 - THOLD: Checking Threshold: Name: 'Server12 - Used Space - / [hdd_used]', Graph: '9049' 2024/09/26 10:25:21 - POLLER: Poller[Main Poller] PID[14466] WARNING: Invalid output! MULTI DS[Apache - Server12.example.com - ApacheStats08 - Workers] Graphs[Apache - Server12.example.com - Apache Stats - F - Thread Details (%)] Encountered [U] Expected[apache_busy_workers:value apache_idle_workers:value] 2024/09/26 10:25:21 - POLLER: Poller[Main Poller] PID[14466] WARNING: Invalid output! MULTI DS[Apache - Server12.example.com - ApacheStats08 - Workers] Graphs[Apache - Server12.example.com - Apache Stats - E - Thread Details] Encountered [U] Expected[apache_busy_workers:value apache_idle_workers:value] 2024/09/26 10:25:21 - POLLER: Poller[Main Poller] PID[14466] WARNING: Invalid output! MULTI DS[Apache - Server13.example.com - ApacheStats08 - Workers] Graphs[Apache - Server13.example.com - Apache Stats - F - Thread Details (%)] Encountered [U] Expected[apache_busy_workers:value apache_idle_workers:value] 2024/09/26 10:25:21 - POLLER: Poller[Main Poller] PID[14466] WARNING: Invalid output! MULTI DS[Apache - Server13.example.com - ApacheStats08 - Workers] Graphs[Apache - Server13.example.com - Apache Stats - E - Thread Details] Encountered [U] Expected[apache_busy_workers:value apache_idle_workers:value] 2024/09/26 10:25:21 - THOLD: Checking Threshold: Name: 'Server11 - Used Space - / [hdd_used]', Graph: '8980' 2024/09/26 10:25:21 - THOLD: Checking Threshold: Name: 'Server9 - Used Space - / [hdd_used]', Graph: '9005' 2024/09/26 10:25:21 - THOLD: Checking Threshold: Name: 'Server10 - Used Space - / [hdd_used]', Graph: '8804' 2024/09/26 10:25:21 - THOLD: Checking Threshold: Name: 'Server9 - Used Space - /srv [hdd_used]', Graph: '9008' 2024/09/26 10:25:21 - CMDPHP ERROR: Output from local_data_id 10829, for RRDfile DS Name 'rserr', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:21 - CMDPHP ERROR: Output from local_data_id 10827, for RRDfile DS Name 'recverr', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:21 - CMDPHP ERROR: Output from local_data_id 10827, for RRDfile DS Name 'sockbf', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:20 - 0: Poller[Main Poller] PID[14509] WARNING: SNMP Error:'snmp2_get(): No response from HOST1_IP_WAS_HERE', Device:'host1.example.com', OID:'.1.3.6.1.2.1.25.2.3.1.5.8' 2024/09/26 10:25:19 - 0: Poller[Main Poller] PID[14529] WARNING: SNMP Error:'snmp2_get(): Error in packet at 'HOST-RESOURCES-MIB::hrStorageUsed.9': (noSuchName) There is no such variable name in this MIB.', Device:'PC4_IP_WAS_HERE', OID:'.1.3.6.1.2.1.25.2.3.1.6.9' 2024/09/26 10:25:19 - 0: Poller[Main Poller] PID[14529] WARNING: SNMP Error:'snmp2_get(): Error in packet at 'HOST-RESOURCES-MIB::hrStorageSize.9': (noSuchName) There is no such variable name in this MIB.', Device:'PC4_IP_WAS_HERE', OID:'.1.3.6.1.2.1.25.2.3.1.5.9' 2024/09/26 10:25:19 - 0: Poller[Main Poller] PID[14529] WARNING: SNMP Error:'snmp2_get(): Error in packet at 'HOST-RESOURCES-MIB::hrStorageUsed.8': (noSuchName) There is no such variable name in this MIB.', Device:'PC4_IP_WAS_HERE', OID:'.1.3.6.1.2.1.25.2.3.1.6.8' 2024/09/26 10:25:19 - 0: Poller[Main Poller] PID[14529] WARNING: SNMP Error:'snmp2_get(): Error in packet at 'HOST-RESOURCES-MIB::hrStorageSize.8': (noSuchName) There is no such variable name in this MIB.', Device:'PC4_IP_WAS_HERE', OID:'.1.3.6.1.2.1.25.2.3.1.5.8' 2024/09/26 10:25:17 - 0: Poller[Main Poller] PID[14509] WARNING: SNMP Error:'snmp2_get(): No response from HOST2_IP_WASHERE', Device:'host2.example.com', OID:'.1.3.6.1.2.1.25.2.3.1.5.8' 2024/09/26 10:25:17 - 0: Poller[Main Poller] PID[14529] WARNING: SNMP Error:'snmp2_get(): No response from SERVER15_IP_WASHERE', Device:'SERVER15_IP_WASHERE', OID:'.1.3.6.1.2.1.25.2.3.1.5.2' 2024/09/26 10:25:14 - 0: Poller[Main Poller] PID[14509] WARNING: SNMP Error:'snmp2_get(): No response from HOST3_IP_WASHERE', Device:'host3.example.com', OID:'.1.3.6.1.2.1.25.2.3.1.5.8' 2024/09/26 10:25:12 - THOLD: Checking Threshold: Name: 'Server Room Tstat 2 [temp1]', Graph: '11811' 2024/09/26 10:25:07 - THOLD: Checking Threshold: Name: 'Server14 - Used Space - / [hdd_used]', Graph: '6815' 2024/09/26 10:25:07 - CMDPHP ERROR: Output from local_data_id 8499, for RRDfile DS Name 'rserr', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:07 - CMDPHP ERROR: Output from local_data_id 8497, for RRDfile DS Name 'recverr', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:07 - CMDPHP ERROR: Output from local_data_id 8497, for RRDfile DS Name 'sockbf', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:07 - POLLER: Poller[Main Poller] PID[14466] WARNING: Invalid output! MULTI DS[Apache - server16.example.com - ApacheStats08 - Workers] Graphs[Apache - server16.example.com - Apache Stats - F - Thread Details (%)] Encountered [U] Expected[apache_idle_wrkrs_s:value] 2024/09/26 10:25:07 - POLLER: Poller[Main Poller] PID[14466] WARNING: Invalid output! MULTI DS[Apache - server16.example.com - ApacheStats08 - Workers] Graphs[Apache - server16.example.com - Apache Stats - F - Thread Details (%)] Encountered [U] Expected[apache_busy_workers:value] 2024/09/26 10:25:07 - POLLER: Poller[Main Poller] PID[14466] WARNING: Invalid output! MULTI DS[Apache - server16.example.com - ApacheStats08 - Workers] Graphs[Apache - server16.example.com - Apache Stats - E - Thread Details] Encountered [U] Expected[apache_idle_wrkrs_s:value] 2024/09/26 10:25:06 - POLLER: Poller[Main Poller] PID[14466] WARNING: Invalid output! MULTI DS[Apache - server17.example.com - ApacheStats08 - Workers] Graphs[Apache - server17.example.com - Apache Stats - F - Thread Details (%)] Encountered [U] Expected[apache_idle_wrkrs_s:value] 2024/09/26 10:25:06 - POLLER: Poller[Main Poller] PID[14466] WARNING: Invalid output! MULTI DS[Apache - server17.example.com - ApacheStats08 - Workers] Graphs[Apache - server17.example.com - Apache Stats - F - Thread Details (%)] Encountered [U] Expected[apache_busy_workers:value] 2024/09/26 10:25:06 - POLLER: Poller[Main Poller] PID[14466] WARNING: Invalid output! MULTI DS[Apache - server17.example.com - ApacheStats08 - Workers] Graphs[Apache - server17.example.com - Apache Stats - E - Thread Details] Encountered [U] Expected[apache_idle_wrkrs_s:value] 2024/09/26 10:25:05 - THOLD: Checking Threshold: Name: 'UPS Unit - Output Source [output_source]', Graph: '11486' 2024/09/26 10:25:05 - THOLD: Checking Threshold: Name: 'UPS Unit - Output Source [output_source]', Graph: '11494' 2024/09/26 10:25:05 - THOLD: Checking Threshold: Name: 'Server8 - Used Space - /var [hdd_used]', Graph: '3161' 2024/09/26 10:25:05 - THOLD: Checking Threshold: Name: 'Server8 - Used Space - /tmp [hdd_used]', Graph: '3160' 2024/09/26 10:25:05 - THOLD: Checking Threshold: Name: 'Server8 - Used Space - /file/server/path [hdd_used]', Graph: '3163' 2024/09/26 10:25:05 - THOLD: Checking Threshold: Name: 'Server8 - Used Space - / [hdd_used]', Graph: '3159' 2024/09/26 10:25:05 - THOLD: Checking Threshold: Name: 'Server8 - ssCpuRawIdle [ucd_ssCpuRawIdle]', Graph: '3142' 2024/09/26 10:25:05 - THOLD: Checking Threshold: Name: 'Server7 - Used Space - /var [hdd_used]', Graph: '3139' 2024/09/26 10:25:05 - THOLD: Checking Threshold: Name: 'Server7 - Used Space - /tmp [hdd_used]', Graph: '3138' 2024/09/26 10:25:05 - THOLD: Checking Threshold: Name: 'Server7 - Used Space - /file/server/path [hdd_used]', Graph: '3141' 2024/09/26 10:25:05 - THOLD: Checking Threshold: Name: 'Server7 - Used Space - / [hdd_used]', Graph: '3137' 2024/09/26 10:25:05 - THOLD: Checking Threshold: Name: 'Server7 - ssCpuRawIdle [ucd_ssCpuRawIdle]', Graph: '3120' 2024/09/26 10:25:05 - CMDPHP ERROR: Output from local_data_id 11478, for RRDfile DS Name 'recverr', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:05 - CMDPHP ERROR: Output from local_data_id 11478, for RRDfile DS Name 'sockbf', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:05 - CMDPHP ERROR: Output from local_data_id 11474, for RRDfile DS Name 'recverr', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:05 - CMDPHP ERROR: Output from local_data_id 11474, for RRDfile DS Name 'sockbf', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:04 - THOLD: Checking Threshold: Name: 'Server6 - Used Space - /file/path [hdd_used]', Graph: '12657' 2024/09/26 10:25:04 - THOLD: Checking Threshold: Name: 'Server6 - Used Space - / [hdd_used]', Graph: '12656' 2024/09/26 10:25:04 - THOLD: Checking Threshold: Name: 'Server Room Tstat [temp1]', Graph: '9156' 2024/09/26 10:25:04 - 0: Poller[Main Poller] PID[14489] WARNING: SNMP Error:'snmp2_get(): Error in packet at 'HOST-RESOURCES-MIB::hrStorageUsed.71': No Such Instance currently exists at this OID', Device:'SERVER18_IP_WASHERE', OID:'.1.3.6.1.2.1.25.2.3.1.6.71' 2024/09/26 10:25:04 - 0: Poller[Main Poller] PID[14489] WARNING: SNMP Error:'snmp2_get(): Error in packet at 'HOST-RESOURCES-MIB::hrStorageSize.71': No Such Instance currently exists at this OID', Device:'SERVER18_IP_WASHERE', OID:'.1.3.6.1.2.1.25.2.3.1.5.71' 2024/09/26 10:25:04 - 0: Poller[Main Poller] PID[14489] WARNING: SNMP Error:'snmp2_get(): Error in packet at 'HOST-RESOURCES-MIB::hrStorageUsed.66': No Such Instance currently exists at this OID', Device:'SERVER18_IP_WASHERE', OID:'.1.3.6.1.2.1.25.2.3.1.6.66' 2024/09/26 10:25:04 - 0: Poller[Main Poller] PID[14489] WARNING: SNMP Error:'snmp2_get(): Error in packet at 'HOST-RESOURCES-MIB::hrStorageSize.66': No Such Instance currently exists at this OID', Device:'SERVER18_IP_WASHERE', OID:'.1.3.6.1.2.1.25.2.3.1.5.66' 2024/09/26 10:25:03 - THOLD: Checking Threshold: Name: 'USER PC - Logged in Users [users]', Graph: '11347' 2024/09/26 10:25:03 - THOLD: Checking Threshold: Name: 'Server4 - Used Space - /file2 [hdd_used]', Graph: '12342' 2024/09/26 10:25:03 - THOLD: Checking Threshold: Name: 'Server4 - Used Space - /file/path2 [hdd_used]', Graph: '12340' 2024/09/26 10:25:03 - THOLD: Checking Threshold: Name: 'Server4 - Used Space - /file/path1 [hdd_used]', Graph: '12341' 2024/09/26 10:25:03 - THOLD: Checking Threshold: Name: 'Server4 - Used Space - / [hdd_used]', Graph: '12339' 2024/09/26 10:25:03 - THOLD: Checking Threshold: Name: 'Server3 - Traffic - IP1_WAS_HERE - eth0 [traffic_out]', Graph: '7310' 2024/09/26 10:25:03 - THOLD: Checking Threshold: Name: 'Server5 - Used Space - / [hdd_used]', Graph: '2332' 2024/09/26 10:25:03 - THOLD: Checking Threshold: Name: 'Server5 - ssCpuRawIdle [ucd_ssCpuRawIdle]', Graph: '2318' 2024/09/26 10:25:03 - THOLD: Checking Threshold: Name: 'Server3 - Used Space - / [hdd_used]', Graph: '1838' 2024/09/26 10:25:03 - THOLD: Checking Threshold: Name: 'Server3 - ssCpuRawIdle [ucd_ssCpuRawIdle]', Graph: '1824' 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11078, for RRDfile DS Name 'rsrtt8001600', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11078, for RRDfile DS Name 'rsrtt500800', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11078, for RRDfile DS Name 'rsrtt1600', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11077, for RRDfile DS Name 'rsqt', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11077, for RRDfile DS Name 'rsqr', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11077, for RRDfile DS Name 'rsmismatch', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11077, for RRDfile DS Name 'rserr', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11077, for RRDfile DS Name 'rsfail', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11075, for RRDfile DS Name 'recverr', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11075, for RRDfile DS Name 'sockbf', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11074, for RRDfile DS Name 'rsrtt8001600', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11074, for RRDfile DS Name 'rsrtt500800', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11074, for RRDfile DS Name 'rsrtt1600', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11074, for RRDfile DS Name 'rsrtt100500', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11073, for RRDfile DS Name 'rsqt', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11073, for RRDfile DS Name 'rsqr', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11073, for RRDfile DS Name 'rsmismatch', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11073, for RRDfile DS Name 'rserr', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11073, for RRDfile DS Name 'rsfail', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11071, for RRDfile DS Name 'recverr', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:03 - CMDPHP ERROR: Output from local_data_id 11071, for RRDfile DS Name 'sockbf', is invalid. It outputs was : ''. Please check your script or data input method for errors. 2024/09/26 10:25:02 - THOLD: Checking Threshold: Name: 'Server Rack - Temperature [snmp_temp]', Graph: '263' 2024/09/26 10:25:02 - THOLD: Checking Threshold: Name: 'Server2 - Used Space - / [hdd_used]', Graph: '1823' 2024/09/26 10:25:02 - THOLD: Checking Threshold: Name: 'Server2 - ssCpuRawIdle [ucd_ssCpuRawIdle]', Graph: '1810' 2024/09/26 10:25:02 - THOLD: Checking Threshold: Name: 'Server1 - Used Space - /home [hdd_used]', Graph: '1175' 2024/09/26 10:25:02 - THOLD: Checking Threshold: Name: 'Server1 - Used Space - / [hdd_used]', Graph: '1174' 2024/09/26 10:25:02 - THOLD: Checking Threshold: Name: 'Server1 - ssCpuRawIdle [ucd_ssCpuRawIdle]', Graph: '1159' 2024/09/26 10:20:37 - CLEANUP WARNING: RRDfile Cleanup Poller terminated by user 2024/09/26 10:20:37 - SNMPAGENT WARNING: No notification receivers configured for event: cactiNotifyDeviceFailedPoll (CACTI-MIB), severity: medium 2024/09/26 10:20:36 - SYSTEM STATS: Time:36.2794 Method:cmd.php Processes:10 Threads:1 Hosts:310 HostsPerProcess:31 DataSources:8759 RRDsProcessed:6240

Wow, that was ugly copy/paste - sorry. I've also sent the log as a .txt file to your email. For some reason Github wouldn't let me attach a .txt file here (it kept disappearing after I added it)

Thanks!

please show result of SQL query: select * from thold_data where local_graph_id=11347 \G

have you any threshold which is breached or triggered?

show result of SQL command: select * from settings where name like '%thold%' and name not like '%text%'; You can post it here with ``` your text ```

select * from thold_data where local_graph_id=11347 \G

MariaDB [cacti]> select * from thold_data where local_graph_id=11347 \G;
*************************** 1. row ***************************
id: 84
thread_id: 0
name: |data_source_description| [|data_source_name|]
name_cache: USER PC - Logged in Users [users]
local_data_id: 13601
data_template_rrd_id: 28586
local_graph_id: 11347
graph_template_id: 0
data_template_hash:
data_template_id: 46
data_source_name: users
thold_hi: 2
thold_low: 0
thold_fail_trigger: 1
thold_fail_count: 0
time_hi:
time_low:
time_fail_trigger: 1
time_fail_length: 1
thold_warning_hi: 1
thold_warning_low: 0
thold_warning_fail_trigger: 1
thold_warning_fail_count: 0
time_warning_hi:
time_warning_low:
time_warning_fail_trigger: 1
time_warning_fail_length: 1
thold_alert: 0
prev_thold_alert: 0
thold_enabled: on
thold_per_enabled: on
thold_type: 0
bl_ref_time_range: 3600
bl_type: 0
bl_pct_down:
bl_pct_up:
bl_fail_trigger: 3
bl_fail_count: 0
bl_alert: 0
bl_cf: AVG
bl_reference_min: 0
bl_reference_max: 0
bl_reference_avg: 0
bl_reference_last: 0
lastread: 7
lasttime: 2024-09-26 11:20:03
lastchanged: 0000-00-00 00:00:00
oldvalue: 7
repeat_alert: 1
notify_extra:
notify_warning_extra:
notify_warning: 1
notify_alert: 1
host_id: 655
syslog_priority: 3
syslog_facility: 0
syslog_enabled:
data_type: 0
show_units: off
units_suffix:
decimals: -1
cdef: 0
percent_ds:
expression:
upper_ds:
thold_template_id: 0
template_enabled: off
tcheck: 1
exempt:
acknowledgment:
thold_hrule_alert: 0
thold_hrule_warning: 0
skipscale:
restored_alert:
reset_ack:
persist_ack:
email_subject:
email_subject_warn:
email_subject_restoral:
email_body: An Alert has been issued that requires your attention. <br><br><strong>Host</strong>: <DESCRIPTION> (<HOSTNAME>)<br><strong>URL</strong>: <URL><br><strong>Message</strong>: <SUBJECT><br><br><GRAPH>
email_body_warn: A warning has been issued that requires your attention. <br><br><strong>Host</strong>: <DESCRIPTION> (<HOSTNAME>)<br><strong>URL</strong>: <URL><br><strong>Message</strong>: <SUBJECT><br><br><GRAPH>
email_body_restoral: A Threshold has returned to normal status. <br><br><strong>Device</strong>: <DESCRIPTION> (<HOSTNAME>)<br><strong>URL</strong>: <URL><br><strong>Message</strong>: <SUBJECT><br><br><GRAPH>
trigger_cmd_high:
trigger_cmd_low:
trigger_cmd_norm:
bl_thold_valid: 0
snmp_event_category: NULL
snmp_event_description:
snmp_event_severity: 4
snmp_event_warning_severity: 3
notes:
external_id:
format_file: default.format
graph_timespan: 7
1 row in set (0.001 sec)

show result of SQL command: select * from settings where name like '%thold%' and name not like '%text%'; You can post it here with your text

If you see me using SMTP setting, but I've also tried PHP Mail() to see if the results were different - they were not, both successfully sent a test message, but neither make thold alerts being sent.

MariaDB [cacti]> select * from settings where name like '%thold%' and name not like '%text%';
+-------------------------------------------+------------------------------------------------------------------------+
| name                                      | value                                                                  |
+-------------------------------------------+------------------------------------------------------------------------+
| intropage_alert_thold_logonly             | red                                                                    |
| monitor_reboot_thold                      | on                                                                     |
| stats_thold                               | Time:0.1129 Tholds:36 TotalDevices:309 DownDevices:13 NewDownDevices:0 |
| thold_alert_snmp                          |                                                                        |
| thold_alert_snmp_normal                   |                                                                        |
| thold_alert_snmp_warning                  |                                                                        |
| thold_autocreate                          |                                                                        |
| thold_consider_unknown_zero               |                                                                        |
| thold_daemon_dead_notification            | 7200                                                                   |
| thold_daemon_debug                        | on                                                                     |
| thold_daemon_enable                       |                                                                        |
| thold_device_command                      |                                                                        |
| thold_disable_all                         |                                                                        |
| thold_disable_legacy                      |                                                                        |
| thold_down_subject                        | Host Error: <DESCRIPTION> (<HOSTNAME>) is DOWN                         |
| thold_email_prio                          |                                                                        |
| thold_empty_if_speed_default              | 10000                                                                  |
| thold_enable_per_thold_body               | on                                                                     |
| thold_enable_scripts                      |                                                                        |
| thold_filter_default                      | -1                                                                     |
| thold_from_email                          | cacti@example.com                                                       |
| thold_from_name                           | Cacti Monitor                                                          |
| thold_how                                 | 2                                                                      |
| thold_last_poll                           | 2010-01-14 16:30:23                                                    |
| thold_log_cacti                           | on                                                                     |
| thold_log_changes                         | on                                                                     |
| thold_log_debug                           | on                                                                     |
| thold_log_storage                         | 31                                                                     |
| thold_log_unknown_to_zero                 |                                                                        |
| thold_max_concurrent_processes            | 10                                                                     |
| thold_notification_delay                  |                                                                        |
| thold_notification_purged_by              | admin                                                                  |
| thold_notification_purged_time            | 1727184693                                                             |
| thold_notification_queue                  |                                                                        |
| thold_notify_alerts_to_warning_recipients | on                                                                     |
| thold_send_email_separately               |                                                                        |
| thold_sendmail_path                       | /usr/sbin/sendmail                                                     |
| thold_show_datasource                     | on                                                                     |
| thold_smtp_host                           | emailserver.example.com                                                |
| thold_smtp_password                       |                                                                        |
| thold_smtp_port                           | 25                                                                     |
| thold_smtp_username                       |                                                                        |
| thold_syslog_facility                     | 24                                                                     |
| thold_syslog_level                        | 4                                                                      |
| thold_syslog_priority                     | 4                                                                      |
| thold_up_subject                          | Host Notice: <DESCRIPTION> (<HOSTNAME>) returned from DOWN state       |
| time_last_change_thold                    | 1727293591                                                             |
| time_last_change_thold_device             | 1718388032                                                             |
| time_last_change_thold_log                | 1718385032                                                             |
+-------------------------------------------+------------------------------------------------------------------------+
49 rows in set (0.001 sec)

have you any threshold which is breached or triggered?

Yes, but I think it might be invalid/old: thold_triggered

thold_triggered2

try to run php /your/cacti/cli/audit_database.php --report

try to run php /your/cacti/cli/audit_database.php --report

FATAL: Failed to find Audit Schema
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates'                   - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_graph'             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_item'              - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs'                            - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_graph_item'                 - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_items'                      - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_devices'                          - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rule_items'                 - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rules'                      - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_ips'                              - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_match_rule_items'                 - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_networks'                         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_processes'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp_items'                       - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_templates'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rule_items'                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rules'                       - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'cdef'                                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'cdef_items'                                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'color_template_items'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'color_templates'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'colors'                                      - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_debug'                                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_input'                                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_data'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_fields'                           - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_local'                                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_cf'                     - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_rra'                    - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_action'                    - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_temp'                      - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_daily'                     - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly'                    - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_cache'              - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_last'               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_monthly'                   - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_weekly'                    - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_yearly'                    - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_template'                               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_data'                          - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_rrd'                           - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'external_links'                              - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_local'                                 - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input_defs'                   - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_gprint'                      - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_graph'                       - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_item'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree'                                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree_items'                            - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host'                                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_graph'                                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_cache'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_query'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_template'                               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_graph'                         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_snmp_query'                    - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_aggregated_ports'                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_approved_macs'                     - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_arp'                               - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_device_types'                      - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_devices'                           - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_dot1x'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_interface_graphs'                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_interfaces'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_ip_ranges'                         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_ips'                               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_macauth'                           - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_macwatch'                          - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_oui_database'                      - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_ports'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_processes'                         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_scan_dates'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_scanning_functions'                - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_sites'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_snmp'                              - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_snmp_items'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_temp_ports'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_vlans'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'notification_queue'                          - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_config'                               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_db_changes'                           - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_flowview_devices'                     - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_flowview_dnscache'                    - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_flowview_ports'                       - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_flowview_queries'                     - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_flowview_schedules'                   - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_hooks'                                - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_dashboard'                  - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_dashboard'            - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_data'                 - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_definition'           - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_trends'                     - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_user_auth'                  - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_user_group_auth'            - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_maint_hosts'                          - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_maint_schedules'                      - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_dashboards'                   - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_notify_history'               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_reboot_history'               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_uptime'                       - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_notification_lists'                   - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_realms'                               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_contacts'                       - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_daemon_data'                    - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_device_template'                - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host'                           - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host_failed'                    - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host_template'                  - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_log'                            - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_template_contact'               - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_threshold_contact'              - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_update_info'                          - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller'                                      - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_command'                              - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_data_template_field_mappings'         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_item'                                 - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output'                               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost'                         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost_local_data_ids'          - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost_processes'               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_realtime'                      - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_reindex'                              - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_resource_cache'                       - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_time'                                 - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'processes'                                   - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'quicktree_graphs'                            - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'reports'                                     - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'reports_items'                               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'rrdcheck'                                    - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'sessions'                                    - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings'                                    - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings_tree'                               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user'                               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user_group'                         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'sites'                                       - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query'                                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph'                            - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd_sv'                     - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_sv'                         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_notifications'               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_textual_conventions'         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers'                          - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers_notifications'            - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_mibs'                              - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_notifications_log'                 - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'table_columns'                               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'table_indexes'                               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'thold_data'                                  - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'thold_template'                              - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth'                                   - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_cache'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_members'                     - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_perms'                       - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_realm'                       - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_perms'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_realm'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_row_cache'                         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains'                                - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains_ldap'                           - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_log'                                    - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'vdef'                                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'vdef_items'                                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'version'                                     - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_auth'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_data'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_groups'                           - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_maps'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_settings'                         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Audit was clean, no errors or warnings
---------------------------------------------------------------------------------------------

it looks like my distro packaging removes the docs folder. I manaully added it back in so audit .sql file was there and re-ran:

Run with --repair now ???

SUCCESS: Loaded the Audit Schema
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates'
ERROR Col: 'created', Attribute 'Type' invalid. Should be: 'timestamp', Is: 'timestamp /* mariadb-5.3 */'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_graph'             - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_item'
ERROR Col: 'color_template', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs'
ERROR Col: 'created', Attribute 'Type' invalid. Should be: 'timestamp', Is: 'timestamp /* mariadb-5.3 */'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_graph_item'
ERROR Col: 'color_template', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_items'                      - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_devices'
ERROR Col: 'snmp', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'
ERROR Col: 'known', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'
ERROR Col: 'up', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'
ERROR Col: 'time', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'snmp_priv_protocol', Attribute 'Type' invalid. Should be: 'char(6)', Is: 'char(7)'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rule_items'                 - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rules'                      - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_ips'                              - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_match_rule_items'                 - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_networks'
ERROR Col: 'next_start', Attribute 'Type' invalid. Should be: 'timestamp', Is: 'timestamp /* mariadb-5.3 */'
ERROR Col: 'last_started', Attribute 'Type' invalid. Should be: 'timestamp', Is: 'timestamp /* mariadb-5.3 */'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_processes'                        - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp'                             - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp_items'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint(5) unsigned'
ERROR Col: 'snmp_retries', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(11) unsigned'
ERROR Col: 'max_oids', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'snmp_priv_protocol', Attribute 'Type' invalid. Should be: 'char(6)', Is: 'char(7)'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_templates'                        - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rule_items'                  - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rules'                       - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'cdef'                                        - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'cdef_items'                                  - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'color_template_items'
ERROR Col: 'color_template_item_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'color_templates'                             - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'colors'                                      - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_debug'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11) unsigned'
ERROR Col: 'started', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'done', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'user', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'datasource', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'issue', Attribute 'Null' invalid. Should be: 'NO', Is: 'YES'

ERRORS: 6, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_input'
ERROR Col: 'type_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'
WARNING Index: 'name', does not exist in default Cacti.  Dropping.

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_data'                             - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_fields'                           - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_local'                                  - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles'                        - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_cf'                     - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_rra'                    - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_action'                    - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_temp'
ERROR Col: 'in_cacti', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_daily'                     - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly'                    - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_cache'              - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_last'               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_monthly'                   - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_weekly'                    - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_yearly'                    - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_template'                               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_data'                          - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_rrd'
WARNING Index: 'data_source_name', does not exist in default Cacti.  Dropping.
WARNING Index: 'data_source_name_2', does not exist in default Cacti.  Dropping.
WARNING Index: 'data_source_name_3', does not exist in default Cacti.  Dropping.
WARNING Index: 'data_source_name_4', does not exist in default Cacti.  Dropping.

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'external_links'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'sortorder', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_local'                                 - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input'                        - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input_defs'
ERROR Col: 'graph_template_input_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'mediumint(8) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates'                             - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_gprint'                      - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_graph'
ERROR Col: 'image_format_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'
ERROR Col: 'auto_scale_opts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_item'
ERROR Col: 'graph_type_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(3)'
ERROR Col: 'consolidation_function_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree'
ERROR Col: 'locked', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'
ERROR Col: 'locked_date', Attribute 'Type' invalid. Should be: 'timestamp', Is: 'timestamp /* mariadb-5.3 */'
ERROR Col: 'last_modified', Attribute 'Type' invalid. Should be: 'timestamp', Is: 'timestamp /* mariadb-5.3 */'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree_items'                            - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host'
ERROR Col: 'snmp_priv_protocol', Attribute 'Type' invalid. Should be: 'char(6)', Is: 'char(7)'
ERROR Col: 'availability_method', Attribute 'Default' invalid. Should be: '1', Is: '2'
ERROR Col: 'ping_port', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'ping_timeout', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'ping_retries', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'max_oids', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'device_threads', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2) unsigned'
WARNING Col: 'monitor', does not exist in default Cacti.  Plugin possible
WARNING Col: 'monitor_text', does not exist in default Cacti.  Plugin possible
ERROR Col: 'total_polls', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'failed_polls', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 9, WARNINGS: 2
---------------------------------------------------------------------------------------------
Checking Table: 'host_graph'                                  - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_cache'
ERROR Col: 'present', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_query'                             - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host_template'                               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_graph'                         - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_snmp_query'                    - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_aggregated_ports'                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_approved_macs'                     - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_arp'                               - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_device_types'                      - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_devices'                           - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_dot1x'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_interface_graphs'                  - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_interfaces'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_ip_ranges'                         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_ips'                               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_macauth'                           - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_macwatch'                          - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_oui_database'                      - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_ports'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_processes'                         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_scan_dates'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_scanning_functions'                - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_sites'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_snmp'                              - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_snmp_items'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_temp_ports'                        - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'mac_track_vlans'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'notification_queue'                          - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_config'                               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_db_changes'                           - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_flowview_devices'                     - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_flowview_dnscache'                    - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_flowview_ports'                       - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_flowview_queries'                     - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_flowview_schedules'                   - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_hooks'                                - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_dashboard'                  - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_dashboard'            - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_data'                 - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_definition'           - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_trends'                     - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_user_auth'                  - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_user_group_auth'            - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_maint_hosts'                          - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_maint_schedules'                      - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_dashboards'                   - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_notify_history'               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_reboot_history'               - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_uptime'                       - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_notification_lists'                   - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_realms'                               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_contacts'                       - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_daemon_data'                    - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_device_template'                - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host'                           - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host_failed'                    - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host_template'                  - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_log'                            - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_template_contact'               - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_threshold_contact'              - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_update_info'                          - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller'
ERROR Col: 'total_polls', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'processes', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'sync_interval', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'requires_sync', Attribute 'Type' invalid. Should be: 'char(2)', Is: 'char(3)'
ERROR Col: 'requires_sync', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_command'
ERROR Col: 'time', Attribute 'Type' invalid. Should be: 'timestamp', Is: 'timestamp /* mariadb-5.3 */'
ERROR Col: 'last_updated', Attribute 'Type' invalid. Should be: 'timestamp', Is: 'timestamp /* mariadb-5.3 */'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_data_template_field_mappings'
ERROR Col: 'last_updated', Attribute 'Type' invalid. Should be: 'timestamp', Is: 'timestamp /* mariadb-5.3 */'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_item'
ERROR Col: 'snmp_priv_protocol', Attribute 'Type' invalid. Should be: 'char(6)', Is: 'char(7)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output'                               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost'                         - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost_local_data_ids'          - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost_processes'               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_realtime'                      - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_reindex'
ERROR Col: 'present', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_resource_cache'                       - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_time'
ERROR Col: 'pid', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11) unsigned'
ERROR Col: 'start_time', Attribute 'Type' invalid. Should be: 'timestamp', Is: 'timestamp /* mariadb-5.3 */'
ERROR Col: 'end_time', Attribute 'Type' invalid. Should be: 'timestamp', Is: 'timestamp /* mariadb-5.3 */'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'processes'
ERROR Col: 'timeout', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'quicktree_graphs'                            - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'reports'
ERROR Col: 'offset', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'reports_items'                               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'rrdcheck'                                    - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'sessions'                                    - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'settings'                                    - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'settings_tree'                               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user'                               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user_group'                         - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'sites'                                       - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query'                                  - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph'                            - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd'                        - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd_sv'                     - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_sv'                         - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache'                             - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_notifications'               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_textual_conventions'         - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'
ERROR Col: 'max_log_size', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint(1)'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'snmp_priv_protocol', Attribute 'Type' invalid. Should be: 'char(6)', Is: 'char(7)'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint(5) unsigned'
ERROR Col: 'snmp_message_type', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint(1)'

ERRORS: 6, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers_notifications'
ERROR Col: 'manager_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_mibs'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_notifications_log'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12)'
ERROR Col: 'severity', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint(1)'
ERROR Col: 'manager_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'table_columns'                               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'table_indexes'                               - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'thold_data'                                  - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'thold_template'                              - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth'
ERROR Col: 'lastchange', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int(12)'
ERROR Col: 'lastlogin', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int(12)'
ERROR Col: 'lastfail', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12)'
ERROR Col: 'reset_perms', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_cache'
ERROR Col: 'last_update', Attribute 'Type' invalid. Should be: 'timestamp', Is: 'timestamp /* mariadb-5.3 */'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group'                             - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_members'                     - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_perms'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_realm'                       - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_perms'                             - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_realm'                             - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_row_cache'                         - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains'
ERROR Col: 'defdomain', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(3)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains_ldap'                           - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_log'                                    - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'vdef'                                        - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'vdef_items'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'version'                                     - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_auth'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_data'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_groups'                           - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_maps'                             - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'weathermap_settings'                         - Does not Exist.  Possible Plugin
---------------------------------------------------------------------------------------------
ERRORS are fixable using the --repair option.  WARNINGS will not be repaired
due to ambiguous use of the column.
---------------------------------------------------------------------------------------------

make sql backup backup before repair

what is your db version?

If you have mariadb, you need 5.5 or higher

Ran repair a couple of times and it is clean now. Still no thold emails :(

MariaDB mariadb-10.11.9-150600.4.6.1

in your cacti log I don't see lines like 2024-09-27 16:16:27 - SYSTEM THOLD STATS: ....

Your thold_daemon is still running? Check ps ax | grep thold

thold_daemon is not running ps: command not found

so something is wrong. Logs -> select Type "stats", search "thold" and you have to see something like: 2024-09-27 16:51:27 - SYSTEM THOLD STATS: Time:11.84 Tholds:8119 TotalDevices:407 DownDevices:4 NewDownDevices:0 2024-09-27 16:46:31 - SYSTEM THOLD STATS: Time:12.87 Tholds:8119 TotalDevices:407 DownDevices:4 NewDownDevices:0 2024-09-27 16:41:35 - SYSTEM THOLD STATS: Time:12.68 Tholds:8119 TotalDevices:407 DownDevices:4 NewDownDevices:0 2024-09-27 16:36:39 - SYSTEM THOLD STATS: Time:13.49 Tholds:8119 TotalDevices:407 DownDevices:4 NewDownDevices:0

install ps (https://ubuntushell.com/ps-command-not-found/) and try it again, maybe try ps ax | grep php

Sorry about that, had a weird shell problem. We have ps installed. It finds no thold process (except the grep of thold) & no cacti php processes (server does some other php stuff that shows up, totally unrelated to cacti)

in log -> Stats, all 122 entries are like this: 2024/09/27 10:15:36 - SYSTEM STATS: Time:36.3798 Method:cmd.php Processes:10 Threads:1 Hosts:310 HostsPerProcess:31 DataSources:8759 RRDsProcessed:6240 none are SYSTEM THOLD STATS like yours

Cacti / plugin_thold

Thold (and monitor) not sending emails after thold 1.8.1 upgrade #697