Thold not working- doest find current or last value

[darshakamodi]

Hi, i am using 087h, and thold -0.4.9-3. , I have setup thold for Active ppp connections and for network if_in/out also
But for both its unable to find Current/Last value and in Last Value tab ,inside threshold it shows n/a.

The log is here...


11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_arrays' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'config_arrays' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name, value) VALUES ('stats_thold', 'Time:0.0211 Tholds:0 DownHosts:0')"
11/15/2011 10:25:11 AM - SYSTEM THOLD STATS: Time:0.0211 Tholds:0 DownHosts:0
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "DELETE FROM plugin_thold_log WHERE time<1318654511"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM host WHERE disabled="" AND status!=3"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "TRUNCATE TABLE plugin_thold_host_failed"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT * FROM host WHERE disabled="" AND status=1 AND status_event_count=2"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT * FROM plugin_thold_host_failed"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT status FROM plugin_config WHERE directory = 'maint'"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "UPDATE thold_data SET tcheck=0"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'thold_get_live_hosts' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'thold_get_live_hosts' AND ph.name NOT IN ('settings', 'boost',
'dsstats') ORDER BY id ASC"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT * FROM thold_data WHERE thold_enabled='on' AND tcheck=1"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name ='manage_poller'"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name ='manage_enable'"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select status from plugin_config where directory='manage'"
11/15/2011 10:25:11 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select id from plugin_realms where plugin='manage'

[TheWitness]

Does not help

[darshakamodi]

Then what would help? what is required to debug?

[linux83]

could you please post snapshot of your threshold configuration for that link, from user perspective might be basic issue.

linux83.

[darshakamodi]

Here it is.. pl let me know if any thing required..

[linux83]

Hi,

As per your config, you are monitoring the link for:

Warning:-
Low value: 10 (bytes)
High value 70 (byes)

Alerting:-
Low value: 5 (bytes)
high value 80 (bytes)

when using "Data mainupliation", the value in (Byte) it's not percentage, so you have to convert your links to bytes value insted of percentage.

for example:
for Alerting, you have to set your hight value of (10000000) to monitor the link if it reach 80Mbps.

other way use CDEF and choice "covert byte to bit" then your setting value will be in bits insted.

hope this help.

linux83

[darshakamodi]

Hi.

Thanks but.,

This is not link. this is Active PPP Connections. which ranges from 30 to 100, in poller log it shows this values.
But in thold, is absolute value, not %.