Poller updating rrd files

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
dheiert
Posts: 3
Joined: Mon Jul 21, 2014 9:18 am

Poller updating rrd files

Post by dheiert »

I have a situation where a script returns a valid value, looks like it gets posted, but never shows up in the graph.
If the devel log is in order of operation chronologically, the value is deleted from the DB before the rrd is updated.
And the rrd ends up with a "U" for its value... What am I doing wrong? See below.

07/21/2014 09:56:33 AM - CMDPHP: Poller[0] Host[31] DS[1006] CMD: /usr/bin/php -q /usr/share/cacti/scripts/wmi.php -h '192.168.128.20' -u '/etc/cacti/cactiwmi.pw' -w 'Win32_PerfFormattedData_MSExchangeTransportQueues_MSExchangeTransportQueues' -n '' -k '' -v '' -c 'ActiveMailboxDeliveryQueueLength', output: ActiveMailboxDeliveryQueueLength:0
07/21/2014 09:56:33 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1006, 'SMPTQ', '2014-07-21 09:56:31', 'ActiveMailboxDeliveryQueueLength:0')"
07/21/2014 09:56:33 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select data_template_rrd.data_source_name, data_input_fields.data_name from (data_template_rrd,data_input_fields) where data_template_rrd.data_input_field_id=data_input_fields.id and data_template_rrd.local_data_id=1006"
07/21/2014 09:56:33 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "DELETE FROM poller_output WHERE local_data_id IN (1006)"
07/21/2014 09:56:33 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT thold_data.id, thold_data.name AS thold_name, thold_data.graph_id, thold_data.percent_ds, thold_data.expression, thold_data.data_type, thold_data.cdef, thold_data.rra_id, thold_data.data_id, thold_data.lastread, UNIX_TIMESTAMP(thold_data.lasttime) AS lasttime, thold_data.oldvalue, data_template_rrd.data_source_name as name, data_template_rrd.data_source_type_id, data_template_data.rrd_step, data_template_rrd.rrd_maximum FROM thold_data LEFT JOIN data_template_rrd ON (data_template_rrd.id = thold_data.data_id) LEFT JOIN data_template_data ON ( data_template_data.local_data_id = thold_data.rra_id ) WHERE data_template_rrd.data_source_name!='' AND thold_data.rra_id IN(1006)"
07/21/2014 09:56:33 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /usr/share/cacti/rra/device_smptq_1006.rrd --template SMPTQ 1405950991:U
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests