no graph with no error, data always zero.

[mild]

This is a part of issue.

Code: Select all

01/11/2007 02:10:02 PM - CMDPHP: Poller[0] Host[2] DS[37] CMD: /usr/sbin/php -q /home/mild/public_html/cacti/scripts/mysql_stats.php traffic 222.122.166.40 uid pwd, output: in:78 out:67
01/11/2007 02:10:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (37, '', '2007-01-11 14:10:02', 'in:78 out:67')"
01/11/2007 02:10:02 PM - CMDPHP: Poller[0] Time: 0.9999 s, Theads: N/A, Hosts: 2
01/11/2007 02:10:02 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
01/11/2007 02:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
01/11/2007 02:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  limit 10000"
01/11/2007 02:10:03 PM - CMDPHP: Poller[0] DEBUG: 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=37"
01/11/2007 02:10:03 PM - POLLER: Poller[0] Parsed MULTI output field 'in:78' [map in->traffic_in]
01/11/2007 02:10:03 PM - POLLER: Poller[0] Parsed MULTI output field 'out:67' [map out->traffic_out]
01/11/2007 02:10:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='37' and rrd_name='' and time='2007-01-11 14:10:02'"
01/11/2007 02:10:03 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /home/mild/public_html/cacti/rra/a3box_db_server_traffic_out_37.rrd --template traffic_in:traffic_out 1168524602:78:67

and.. i think there is no problem @ input method.

but.
when i fetch data from rrd directly,

Code: Select all

[root@mp3-list log]# rrdtool fetch /home/mild/public_html/cacti/rra/a3box_db_server_traffic_out_37.rrd AVERAGE


1168522800: 0.0000000000e+00 0.0000000000e+00
1168523100: 0.0000000000e+00 0.0000000000e+00
1168523400: 0.0000000000e+00 0.0000000000e+00
1168523700: 0.0000000000e+00 0.0000000000e+00
1168524000: 0.0000000000e+00 0.0000000000e+00
1168524300: 0.0000000000e+00 0.0000000000e+00
1168524600: 0.0000000000e+00 0.0000000000e+00
1168524900: 0.0000000000e+00 0.0000000000e+00
1168525200: nan nan

it's always 0

i confirmed 78:67 value and field name . but useless

how can i fix that ?

[gandalf]

I suppose you're trying to graph a constant value and setup your rrd file data sources as COUNTER. Please change to GAUGE both in the Data Template and in all existing rrd files using the appropriate rrdtool tune ... statement
Reinhard

[mild]

thanx for reply

i tried rrdtool tune and the result is below

Code: Select all

[root@mp3-list rra]# rrdtool tune a3box_db_server_traffic_out_37.rrd 
DS[traffic_out] typ: COUNTER    hbt: 600        min: 0.0000     max: 100000000.0000
DS[traffic_in] typ: COUNTER     hbt: 600        min: 0.0000     max: 100000000.0000

and i don't know how to set GAUGE.. anyone who explain ?

[mild]

Code: Select all

01/12/2007 09:28:32 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /home/mild/public_html/cacti/rra/a3box_db_server_traffic_out_37.rrd --template traffic_in:traffic_out 1168594112:78:67
01/12/2007 09:28:32 AM - SYSTEM STATS: Time:1.0621 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:19 RRDsProcessed:15
OK u:0.00 s:0.00 r:0.04
OK u:0.00 s:0.00 r:0.04
OK u:0.00 s:0.00 r:0.04
OK u:0.00 s:0.00 r:0.04
OK u:0.00 s:0.00 r:0.04
OK u:0.00 s:0.00 r:0.04
OK u:0.00 s:0.00 r:0.04
OK u:0.00 s:0.00 r:0.04
OK u:0.00 s:0.00 r:0.04
OK u:0.00 s:0.00 r:0.04
OK u:0.00 s:0.01 r:0.04
OK u:0.00 s:0.01 r:0.04
OK u:0.00 s:0.01 r:0.05
OK u:0.00 s:0.01 r:0.05
OK u:0.00 s:0.01 r:0.05

Code: Select all

1168592100: 0.0000000000e+00 0.0000000000e+00
1168592400: 0.0000000000e+00 0.0000000000e+00
1168592700: 0.0000000000e+00 0.0000000000e+00
1168593000: 0.0000000000e+00 0.0000000000e+00
1168593300: 0.0000000000e+00 0.0000000000e+00
1168593600: 0.0000000000e+00 0.0000000000e+00
1168593900: 0.0000000000e+00 0.0000000000e+00
1168594200: 6.6553333333e+01 7.7480000000e+01
1168594500: nan nan

Code: Select all

[root@mp3-list rra]# rrdtool tune a3box_db_server_traffic_out_37.rrd 
DS[traffic_out] typ: GAUGE      hbt: 600        min: 0.0000     max: 100000000.0000
DS[traffic_in] typ: GAUGE       hbt: 600        min: 0.0000     max: 100000000.0000

thanx very much .. it must be working !

[gandalf]

Yep, looks good
Reinhard