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
Poller updating rrd files
Moderators: Developers, Moderators
Who is online
Users browsing this forum: No registered users and 4 guests