Re: [pfSense Support] Bandwdith usage since start of month?

2010-07-19 Thread Seth Mos

Op 19-7-2010 7:34, David Burgess schreef:

On Sun, Jul 18, 2010 at 10:30 AM, Seth Mosseth@dds.nl  wrote:



So at first glance the RRD Summary could be reconcilable with my ISP's
figures, while the RRD Graph numbers cannot be.


Intruiging, I'll have to look into it.


Interesting that RRD Summary reports In traffic as higher, but out
traffic as lower. Also, I appear to be missing all the graph data from
last week.


There might have been a math bug that meant you went 1 period forward 
instead of backwards.


Regards,

Seth

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-07-19 Thread David Burgess
On Mon, Jul 19, 2010 at 12:34 AM, Seth Mos seth@dds.nl wrote:

 There might have been a math bug that meant you went 1 period forward
 instead of backwards.

Except the monthly graph shows a gap from the previous week when
looking at the current month. Screenshot in the forum:
http://forum.pfsense.org/index.php/topic,26789.0.html

May have something to do with me updating the firmware right at the
end of the gap.

db

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-07-19 Thread Seth Mos

Op 19-7-2010 8:42, David Burgess schreef:

On Mon, Jul 19, 2010 at 12:34 AM, Seth Mosseth@dds.nl  wrote:



Except the monthly graph shows a gap from the previous week when
looking at the current month. Screenshot in the forum:
http://forum.pfsense.org/index.php/topic,26789.0.html


No screenshot, but that should not be related to the graphing.


May have something to do with me updating the firmware right at the
end of the gap.


Unsure, what I do see is that my week graph is not working either way. 
That needs to be fixed regardless.


Regards,

Seth

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-07-18 Thread David Burgess
On Wed, Jul 14, 2010 at 1:06 AM, David Burgess apt@gmail.com wrote:

 July 23: Same thing, package will neither function nor delete. I see
 this at the bottom of the page when trying to remove the package, even
 after doing a /etc/rc.conf_mount_rw on the command line:

I just updated to the July 17 snapshot, installed the package, and it
appears to be working and reporting correct figures. Thank you.

db

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-07-18 Thread Seth Mos
Hi,

Op 18 jul 2010, om 09:14 heeft David Burgess het volgende geschreven:

 On Wed, Jul 14, 2010 at 1:06 AM, David Burgess apt@gmail.com wrote:
 
 July 23: Same thing, package will neither function nor delete. I see
 this at the bottom of the page when trying to remove the package, even
 after doing a /etc/rc.conf_mount_rw on the command line:
 
 I just updated to the July 17 snapshot, installed the package, and it
 appears to be working and reporting correct figures. Thank you.

In other news, the RRD graph presentation in 2.0 has changed over the weekend. 
You can now select the graph from start of the month as well as the previous 
full month.

I need some verification that the numbers add up though.

Regards,

Seth
-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-07-14 Thread David Burgess
On Tue, Jul 13, 2010 at 4:24 PM, Jim Pingle li...@pingle.org wrote:

 Updated again, but I didn't bump the version this time. Try it in about
 5 minutes.

Hm. I tried the reinstall button but now the package is in limbo.
pfsense thinks it's installed, but there's no longer a menu for it.
Attempting to remove it just produces and xml error, even after a
reboot. I'm updating the snapshot (2.0) now.

July 23: Same thing, package will neither function nor delete. I see
this at the bottom of the page when trying to remove the package, even
after doing a /etc/rc.conf_mount_rw on the command line:

Warning: copy(/cf/conf/backup/config-1279090322.xml): failed to open
stream: Read-only file system in /etc/inc/config.lib.inc on line 1247
Warning: fopen(/cf/conf/backup/backup.cache): failed to open stream:
Read-only file system in /etc/inc/config.lib.inc on line 1254 Warning:
fwrite(): supplied argument is not a valid stream resource in
/etc/inc/config.lib.inc on line 1255 Warning: fclose(): supplied
argument is not a valid stream resource in /etc/inc/config.lib.inc on
line 1256 Warning: fopen(/cf/conf/config.xml.23702): failed to open
stream: Read-only file system in /etc/inc/config.lib.inc on line 424
Warning: copy(/cf/conf/backup/config-1279091042.xml): failed to open
stream: Read-only file system in /etc/inc/config.lib.inc on line 1247
Warning: fopen(/cf/conf/backup/backup.cache): failed to open stream:
Read-only file system in /etc/inc/config.lib.inc on line 1254 Warning:
fwrite(): supplied argument is not a valid stream resource in
/etc/inc/config.lib.inc on line 1255 Warning: fclose(): supplied
argument is not a valid stream resource in /etc/inc/config.lib.inc on
line 1256 Warning: fopen(/cf/conf/config.xml.23702): failed to open
stream: Read-only file system in /etc/inc/config.lib.inc on line 424
XML error: not object found!

db

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



RE: [pfSense Support] Bandwdith usage since start of month?

2010-07-13 Thread Adam Thompson
Checking it against my latest ISP bill, the numbers are way out.  ISP is 
billing me for 57.4GBytes, RRD Summary page shows last month as In:108921, 
Out:8602, Total:117523.  I do note that the Total number is *almost* double the 
ISP's number - which seems to correspond with David's observations from July 
5th (included below).

-Adam Thompson
 Chief Technical Architect, C3A Inc.
 athom...@c3a.ca
 (204) 272-9628 / fax: (204) 272-8291


 -Original Message-
 From: David Burgess [mailto:apt@gmail.com]
 Sent: Monday, July 05, 2010 6:18 AM
 To: support@pfsense.com
 Subject: Re: [pfSense Support] Bandwdith usage since start of month?
 
 On Thu, Jun 24, 2010 at 2:12 PM, Jim Pingle li...@pingle.org wrote:
 
  Give it a try and see if it's still accurate.
 
 Some observations:
 
 1. Using the June 23 nanobsd snapshot, RRD Summary reported ~330GB
 of traffic from June 1 to June 30. On July 3 it reported over 700GB of
 traffic from the 1st. In other words it appeared that it not only failed to
 reset its counter on July 1, but it had also somehow doubled its count.
 
 2. I just updated to the July 4 snapshot and saw this on the console after
 the automatic reboot:
 
 
 Syncing packages: RRD Summary
 Beginning package installation for ...
 Removing package...
 Removing RRD Summary components...
 
 Warning: fwrite(): 63 is not a valid stream resource in /etc/inc/pkg-
 utils.inc on line 816
 
 Beginning package installation for ...
 
 Syncing packages:.
 Executing rc.d items...
  Starting /usr/local/etc/rc.d/*.sh...done.
 Bootup complete
 
 
 When attempting to load the dashboard for the first time it instead
 loaded one of the package pages where I saw something like All
 packages reinstalled, but it appears the RRD Summary package is not
 installed.
 
 3. I manually installed RRD Summary again from the UI. Now it is
 reporting 50GB used since the 1st, which is not unlikely, and 772GB for
 last month, which, as I stated, is more than double the amount it was
 reporting only a day or two or three from the end of June, and is
 therefore unlikely.
 
 db
 
 -
 To unsubscribe, e-mail: support-unsubscr...@pfsense.com For
 additional commands, e-mail: support-h...@pfsense.com
 
 Commercial support available - https://portal.pfsense.org



RE: [pfSense Support] Bandwdith usage since start of month?

2010-07-13 Thread Adam Thompson
Aha!

In /usr/local/www/status_rrd_summary.php, on line 38, the requested resolution 
for $lastmonth is 86400, but the RRD file in question doesn't have anything 
larger than 720*60=43200 (according to rrdtool info, anyway) and defaults to 
returning not the next-closest resolution, but the *highest* resolution 
instead.  I haven't checked this month, but the last month numbers match my 
ISP bill perfectly if I change 86400 to 720*60:

__BOF__
--- status_rrd_summary.php  2010-07-13 14:18:21.0 -0500
+++ status_rrd_summary.php.orig 2010-07-13 14:05:36.0 -0500
@@ -33,9 +33,9 @@
 $lastmonth = 00  . date(m/{$startday}/Y, strtotime(-1 month, 
strtotime(date(m/{$startday}/Y;

 $thismonth = fetch_rrd_summary($rrd, $start, now);
-$lastmonth = fetch_rrd_summary($rrd, $lastmonth, $start, 720*60);
+$lastmonth = fetch_rrd_summary($rrd, $lastmonth, $start, 86400);

-function fetch_rrd_summary($rrd, $start, $end, $resolution=(60*60)) {
+function fetch_rrd_summary($rrd, $start, $end, $resolution=3600) {
$traffic = array();
$rrd   = escapeshellarg(/var/db/rrd/{$rrd});
$start = escapeshellarg($start);
__EOF__

-Adam Thompson
 Chief Technical Architect, C3A Inc.
 athom...@c3a.ca
 (204) 272-9628 / fax: (204) 272-8291


 -Original Message-
 From: Adam Thompson [mailto:athom...@c3a.ca]
 Sent: Tuesday, July 13, 2010 1:25 PM
 To: 'support@pfsense.com'
 Subject: RE: [pfSense Support] Bandwdith usage since start of month?
 
 Checking it against my latest ISP bill, the numbers are way out.  ISP is
 billing me for 57.4GBytes, RRD Summary page shows last month as
 In:108921, Out:8602, Total:117523.  I do note that the Total number is
 *almost* double the ISP's number - which seems to correspond with
 David's observations from July 5th (included below).
 
 -Adam Thompson
  Chief Technical Architect, C3A Inc.
  athom...@c3a.ca
  (204) 272-9628 / fax: (204) 272-8291
 
 
  -Original Message-
  From: David Burgess [mailto:apt@gmail.com]
  Sent: Monday, July 05, 2010 6:18 AM
  To: support@pfsense.com
  Subject: Re: [pfSense Support] Bandwdith usage since start of month?
 
  On Thu, Jun 24, 2010 at 2:12 PM, Jim Pingle li...@pingle.org wrote:
 
   Give it a try and see if it's still accurate.
 
  Some observations:
 
  1. Using the June 23 nanobsd snapshot, RRD Summary reported
 ~330GB of
  traffic from June 1 to June 30. On July 3 it reported over 700GB of
  traffic from the 1st. In other words it appeared that it not only
  failed to reset its counter on July 1, but it had also somehow doubled
 its count.
 
  2. I just updated to the July 4 snapshot and saw this on the console
  after the automatic reboot:
 
  
  Syncing packages: RRD Summary
  Beginning package installation for ...
  Removing package...
  Removing RRD Summary components...
 
  Warning: fwrite(): 63 is not a valid stream resource in /etc/inc/pkg-
  utils.inc on line 816
 
  Beginning package installation for ...
 
  Syncing packages:.
  Executing rc.d items...
   Starting /usr/local/etc/rc.d/*.sh...done.
  Bootup complete
  
 
  When attempting to load the dashboard for the first time it instead
  loaded one of the package pages where I saw something like All
  packages reinstalled, but it appears the RRD Summary package is not
  installed.
 
  3. I manually installed RRD Summary again from the UI. Now it is
  reporting 50GB used since the 1st, which is not unlikely, and 772GB
  for last month, which, as I stated, is more than double the amount it
  was reporting only a day or two or three from the end of June, and is
  therefore unlikely.
 
  db
 
  -
  To unsubscribe, e-mail: support-unsubscr...@pfsense.com For
 additional
  commands, e-mail: support-h...@pfsense.com
 
  Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-07-13 Thread Jim Pingle
On 7/13/2010 3:21 PM, Adam Thompson wrote:
 Aha!
 
 In /usr/local/www/status_rrd_summary.php, on line 38, the requested 
 resolution for $lastmonth is 86400, but the RRD file in question doesn't have 
 anything larger than 720*60=43200 (according to rrdtool info, anyway) and 
 defaults to returning not the next-closest resolution, but the *highest* 
 resolution instead.  I haven't checked this month, but the last month 
 numbers match my ISP bill perfectly if I change 86400 to 720*60:

Thanks for catching that!

I committed a fix and updated the package. It should be up shortly.

Jim

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-07-13 Thread David Burgess
On Tue, Jul 13, 2010 at 4:06 PM, Jim Pingle li...@pingle.org wrote:

 I committed a fix and updated the package. It should be up shortly.


Parse error: syntax error, unexpected '(' in
/usr/local/www/status_rrd_summary.php on line 38

That's version 1.1

db

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-07-13 Thread Jim Pingle
On 7/13/2010 6:20 PM, David Burgess wrote:
 On Tue, Jul 13, 2010 at 4:06 PM, Jim Pingle li...@pingle.org wrote:
 
 I committed a fix and updated the package. It should be up shortly.
 
 
 Parse error: syntax error, unexpected '(' in
 /usr/local/www/status_rrd_summary.php on line 38
 
 That's version 1.1

Updated again, but I didn't bump the version this time. Try it in about
5 minutes.

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



RE: [pfSense Support] Bandwdith usage since start of month?

2010-07-13 Thread Adam Thompson
Sorry, that looks like my fault - the patch I sent inline with my last message 
accidentally included a change that I hadn't actually tested yet... and if Jim 
applied it as-is, well, that's the error you get.

Oops.

-Adam Thompson
 Chief Technical Architect, C3A Inc.
 athom...@c3a.ca
 (204) 272-9628 / fax: (204) 272-8291


 -Original Message-
 From: Jim Pingle [mailto:li...@pingle.org]
 Sent: Tuesday, July 13, 2010 5:24 PM
 To: support@pfsense.com
 Subject: Re: [pfSense Support] Bandwdith usage since start of month?
 
 On 7/13/2010 6:20 PM, David Burgess wrote:
  On Tue, Jul 13, 2010 at 4:06 PM, Jim Pingle li...@pingle.org wrote:
 
  I committed a fix and updated the package. It should be up shortly.
 
 
  Parse error: syntax error, unexpected '(' in
  /usr/local/www/status_rrd_summary.php on line 38
 
  That's version 1.1
 
 Updated again, but I didn't bump the version this time. Try it in about
 5 minutes.
 
 -
 To unsubscribe, e-mail: support-unsubscr...@pfsense.com For
 additional commands, e-mail: support-h...@pfsense.com
 
 Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-07-05 Thread David Burgess
On Thu, Jun 24, 2010 at 2:12 PM, Jim Pingle li...@pingle.org wrote:

 Give it a try and see if it's still accurate.

Some observations:

1. Using the June 23 nanobsd snapshot, RRD Summary reported ~330GB of
traffic from June 1 to June 30. On July 3 it reported over 700GB of
traffic from the 1st. In other words it appeared that it not only
failed to reset its counter on July 1, but it had also somehow doubled
its count.

2. I just updated to the July 4 snapshot and saw this on the console
after the automatic reboot:


Syncing packages: RRD Summary
Beginning package installation for ...
Removing package...
Removing RRD Summary components...

Warning: fwrite(): 63 is not a valid stream resource in
/etc/inc/pkg-utils.inc on line 816

Beginning package installation for ...

Syncing packages:.
Executing rc.d items...
 Starting /usr/local/etc/rc.d/*.sh...done.
Bootup complete


When attempting to load the dashboard for the first time it instead
loaded one of the package pages where I saw something like All
packages reinstalled, but it appears the RRD Summary package is not
installed.

3. I manually installed RRD Summary again from the UI. Now it is
reporting 50GB used since the 1st, which is not unlikely, and 772GB
for last month, which, as I stated, is more than double the amount it
was reporting only a day or two or three from the end of June, and is
therefore unlikely.

db

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



RE: [pfSense Support] Bandwdith usage since start of month?

2010-07-01 Thread Adam Thompson
 I put a version of this info into a package for 1.2.3 and 2.0
 called
 RRD Summary. For now it just shows the current and previous
 month, and
 you can pick which RRD database it uses as well as which day starts
 the
 month period.
 
 Give it a try and see if it's still accurate.
 
 Jim

Finally got back to the office and tried it - but the numbers do not seem to 
match up.  Don't know why yet, won't have time to diagnose until tomorrow or 
the weekend.  (In fact, the pkg, the command line, and my ISP's billing system 
are all giving me different answers right now.)

-Adam Thompson
 Chief Technical Architect, C3A Inc.
 athom...@c3a.ca
 (204) 272-9628 / fax: (204) 272-8291



Re: [pfSense Support] Bandwdith usage since start of month?

2010-06-24 Thread Jim Pingle
On 6/18/2010 1:44 PM, Jim Pingle wrote:
 On 6/18/2010 1:40 PM, Adam Thompson wrote:
 It wouldn't be too difficult to add this to the GUI if we can
 confirm
 that the results are indeed accurate.


 Well, I can tell you that the numbers returned matched up exactly with what 
 my ISP wants to bill me for :-)
 
 That's certainly a good measure :-)
 
 We'd just need to put a big fat disclaimer on the total that says it's
 not 100% accurate, especially if the RRD data is incomplete for the time
 period.

I put a version of this info into a package for 1.2.3 and 2.0 called
RRD Summary. For now it just shows the current and previous month, and
you can pick which RRD database it uses as well as which day starts the
month period.

Give it a try and see if it's still accurate.

Jim

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-06-18 Thread Nenhum_de_Nos

On Fri, June 18, 2010 13:04, Adam Thompson wrote:
 I'm trying to determine how much traffic I've transferred since the first
 of the month; the RRD graphs let me see the last month's worth of traffic
 but I can't see any way to specify custom ranges.

 I vaguely remember seeing a package that let me select specific ranges on
 those graphs but I can't find it now (and I might be remembering something
 else altogether - who knows).

 Is there a way to get this information?

 Thanks,

vnstat does that. but not for past time (before it is installed).

matheus

-- 
We will call you cygnus,
The God of balance you shall be

A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?

http://en.wikipedia.org/wiki/Posting_style

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-06-18 Thread Ian Bowers
darkstat will give you a rolling month, but I'm not sure what would
conveniently do traffic since the start of a given month.

On Fri, Jun 18, 2010 at 12:04 PM, Adam Thompson athom...@c3a.ca wrote:
 I’m trying to determine how much traffic I’ve transferred since the first of
 the month; the RRD graphs let me see the last month’s worth of traffic but I
 can’t see any way to specify custom ranges.



 I vaguely remember seeing a package that let me select specific ranges on
 those graphs but I can’t find it now (and I might be remembering something
 else altogether – who knows).



 Is there a way to get this information?



 Thanks,



 -Adam Thompson

  Chief Technical Architect, C3A Inc.

  athom...@c3a.ca

  (204) 272-9628 / fax: (204) 272-8291



-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-06-18 Thread David Burgess
On Fri, Jun 18, 2010 at 10:20 AM, Nenhum_de_Nos
math...@eternamente.info wrote:

 vnstat does that. but not for past time (before it is installed).

Anybody know if vnstat is compact flash friendly? I'm using the
nanobsd image since burning out one CF already, and this vnstat sounds
handy.

db

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-06-18 Thread Nenhum_de_Nos

On Fri, June 18, 2010 13:32, David Burgess wrote:
 On Fri, Jun 18, 2010 at 10:20 AM, Nenhum_de_Nos
 math...@eternamente.info wrote:

 vnstat does that. but not for past time (before it is installed).

 Anybody know if vnstat is compact flash friendly? I'm using the
 nanobsd image since burning out one CF already, and this vnstat sounds
 handy.

I can't say for sure, as I run on microdrives. but it uses damn small
files on its /var/db/vnstat dir ...

matheus

-- 
We will call you cygnus,
The God of balance you shall be

A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?

http://en.wikipedia.org/wiki/Posting_style

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



Re: [pfSense Support] Bandwdith usage since start of month?

2010-06-18 Thread Jim Pingle
On 6/18/2010 12:04 PM, Adam Thompson wrote:
 Is there a way to get this information?

Try this command at the CLI, do the values look right when compared to
the graph? My awk-fu isn't that good, there's probably a better way to
do this:

(This should all be one single line)

rrdtool fetch /var/db/rrd/wan-traffic.rrd AVERAGE -r 3600 -s '00:00
06/01/2010' -e now | grep -v nan | cut -f2 -d':' | awk '{ sum1 +=
$1/(1024*1024); sum2 += $2/(1024*1024) } END { printf IN: %u Mbytes
OUT: %u Mbytes\n, sum1*3600, sum2*3600; }'

I had to use Mbytes since using bytes made awk roll overflow its integer
type :-)

If you have more than one WAN, you can repeat that with
opt1-traffic.rrd, etc.

Jim

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



RE: [pfSense Support] Bandwdith usage since start of month?

2010-06-18 Thread Adam Thompson
Thank you very much!  I never know how to extract the raw data from rrdlogs, 
now I know it's actually not that hard.

(BTW: the AWK is fine, although you can omit the cut(1) stage in the pipe 
simply by having awk add up $2 and $3 instead of $1 and $2.)

-Adam Thompson
 Chief Technical Architect, C3A Inc.
 athom...@c3a.ca
 (204) 272-9628 / fax: (204) 272-8291


-Original Message-
From: Jim Pingle [mailto:li...@pingle.org] 
Sent: June-18-10 12:23 PM
To: support@pfsense.com
Subject: Re: [pfSense Support] Bandwdith usage since start of month?

On 6/18/2010 12:04 PM, Adam Thompson wrote:
 Is there a way to get this information?

Try this command at the CLI, do the values look right when compared to
the graph? My awk-fu isn't that good, there's probably a better way to
do this:

(This should all be one single line)

rrdtool fetch /var/db/rrd/wan-traffic.rrd AVERAGE -r 3600 -s '00:00
06/01/2010' -e now | grep -v nan | cut -f2 -d':' | awk '{ sum1 +=
$1/(1024*1024); sum2 += $2/(1024*1024) } END { printf IN: %u Mbytes
OUT: %u Mbytes\n, sum1*3600, sum2*3600; }'

I had to use Mbytes since using bytes made awk roll overflow its integer
type :-)

If you have more than one WAN, you can repeat that with
opt1-traffic.rrd, etc.

Jim



Re: [pfSense Support] Bandwdith usage since start of month?

2010-06-18 Thread Jim Pingle
On 6/18/2010 1:28 PM, Adam Thompson wrote:
 Thank you very much!  I never know how to extract the raw data from rrdlogs, 
 now I know it's actually not that hard.
 
 (BTW: the AWK is fine, although you can omit the cut(1) stage in the pipe 
 simply by having awk add up $2 and $3 instead of $1 and $2.)

And for my next trick, this one works in whatever month you run it:

rrdtool fetch /var/db/rrd/wan-traffic.rrd AVERAGE -r 3600 -s 00 `date
'+%m/01/%Y'` -e now | grep -v nan | awk '{ sum1 += $2/(1024*1024); sum2
+= $3/(1024*1024) } END { printf IN: %u Mbytes OUT: %u Mbytes\n,
sum1*3600, sum2*3600; }'

Thanks for the reminder, re: cut/awk.

It wouldn't be too difficult to add this to the GUI if we can confirm
that the results are indeed accurate.

Jim

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org



RE: [pfSense Support] Bandwdith usage since start of month?

2010-06-18 Thread Adam Thompson
 -Original Message-
 From: Jim Pingle [mailto:li...@pingle.org]
 Sent: Friday, June 18, 2010 12:37 PM
 To: support@pfsense.com
 Subject: Re: [pfSense Support] Bandwdith usage since start of
 month?
 
 It wouldn't be too difficult to add this to the GUI if we can
 confirm
 that the results are indeed accurate.


Well, I can tell you that the numbers returned matched up exactly with what my 
ISP wants to bill me for :-)


-Adam Thompson
 Chief Technical Architect, C3A Inc.
 athom...@c3a.ca
 (204) 272-9628 / fax: (204) 272-8291



Re: [pfSense Support] Bandwdith usage since start of month?

2010-06-18 Thread Jim Pingle
On 6/18/2010 1:40 PM, Adam Thompson wrote:
 It wouldn't be too difficult to add this to the GUI if we can
 confirm
 that the results are indeed accurate.
 
 
 Well, I can tell you that the numbers returned matched up exactly with what 
 my ISP wants to bill me for :-)

That's certainly a good measure :-)

We'd just need to put a big fat disclaimer on the total that says it's
not 100% accurate, especially if the RRD data is incomplete for the time
period.

-
To unsubscribe, e-mail: support-unsubscr...@pfsense.com
For additional commands, e-mail: support-h...@pfsense.com

Commercial support available - https://portal.pfsense.org