bandwidth usage as string

[amr922]

Hello !
i would get bandwidth usage "Interface - Traffic (bytes/sec,Total Bandwidth) " as text string not as graph

how can i do that !?
Regards,

[Sirup]

Could you explain your issue in more than one sentence? I have actually no idea what you want.

[amr922]

thanks Sirup and sorry for my English

i would like to get bandwidth usage in text mode instead of graph mode
Regards,

[Sirup]

Mhm.. How about clicking on the blue button with the white arrow next to the graphs? Then you can export the data into CSV.

[amr922]

thanks a lot
do you can help me to do it through mysql query ?
Regards,

[Howie]

Take a look at the rrdtool manual.

You can use the PRINT option of the rrdtool graph command to get text output (use /dev/null as the graph filename).

Here's an example from Weathermap:

Code: Select all

rrdtool graph /dev/null -f "" -s now-30d -e now DEF:in=../rra/atm-sl_traffic_in_5498.rrd:traffic_in:AVERAGE DEF:out=../rra/atm-sl_traffic_in_5498.rrd:traffic_out:AVERAGE VDEF:avg_in=in,AVERAGE VDEF:avg_out=out,AVERAGE PRINT:avg_in:%lf PRINT:avg_out:%lf

Cacti won't really help you with this job, but you can use the graph debug option to copy some of the DEF and CDEF parts.

[amr922]

thanks Howie

i tried that but i got

Code: Select all

rrdtool graph /dev/null -f "" -s now-30d -e now DEF:in=/var/www/html/rra/public_network_traffic_in_37.rrd:AVERAGE DEF:out=/var/www/html/rra/public_network_traffic_in_37.rrd:traffic_out:AVERAGE VDEF:avg_in=in,AVERAGE VDEF:avg_out=out,AVERAGE PRINT:avg_in:%lf PRINT:avg_out:%lf
ERROR: Cannot parse DS in 'DEF:in=/var/www/html/rra/public_network_traffic_in_37.rrd:AVERAGE'

debug from cacti

Code: Select all

  	 RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-60 \
--title="public network - Traffic - GbE_18/18" \
--rigid \
--base=1000 \
--height=100 \
--width=480 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bytes per second" \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a="/var/www/html/rra/public_network_traffic_in_47.rrd":traffic_in:AVERAGE \
DEF:b="/var/www/html/rra/public_network_traffic_in_47.rrd":traffic_out:AVERAGE \
AREA:a#00CF00FF:"Inbound"  \
GPRINT:a:LAST:" Cur\:%8.2lf %s"  \
GPRINT:a:AVERAGE:"Avg\:%8.2lf %s"  \
GPRINT:a:MAX:"Max\:%8.2lf %s"  \
COMMENT:"Total In\:  15.36 GB\n"  \
LINE1:b#002A97FF:"Outbound"  \
GPRINT:b:LAST:"Cur\:%8.2lf %s"  \
GPRINT:b:AVERAGE:"Avg\:%8.2lf %s"  \
GPRINT:b:MAX:"Max\:%8.2lf %s"  \
COMMENT:"Total Out\: 2.23 GB" 

Regards,

[Howie]

DEF:in=/var/www/html/rra/public_network_traffic_in_37.rrd:AVERAGE

should be

DEF:in=/var/www/html/rra/public_network_traffic_in_37.rrd:traffic_in:AVERAGE

(you missed out the DS name)

[amr922]

thanks a lot

last thing
how can i do it for specific period (from first of the month to now )

Regards,

[Howie]

thanks a lot

last thing
how can i do it for specific period (from first of the month to now )

Regards,

There are command-line options for the start and end times. I think they are -s and -e, but they are in the rrdtool manual. You can specify dates in a lot of formats, including now-30d.

[amr922]

thanks a lot
output like
245664.840987
86962.878551


its with mbit ? or bytes or what ?