Re: [PacketFence-users] Packetfence-ZEN-5-1 bandwidth violation

[Hubert K. <ku...@un...>]

Yes, the MAC ist listed in radacct.


mysql> select 
callingstationid,acctinputoctets,acctoutputoctets,acctstarttime from 
radacct;
+------------------+-----------------+------------------+---------------------+
| callingstationid | acctinputoctets | acctoutputoctets | 
acctstarttime       |
+------------------+-----------------+------------------+---------------------+
| MAC of Device     |          305985 |          2136314 | 2015-06-11 
05:31:10 |
| MAC of Device     |          135939 |           321679 | 2015-06-11 
07:32:13 |
| MAC of Device     |          544740 |          2168492 | 2015-06-11 
07:34:03 |
| MAC of Device     |          411509 |          1880426 | 2015-06-16 
04:39:54 |
| MAC of Device     |          316077 |          1993235 | 2015-07-01 
07:59:10 |
| MAC of Device     |          315078 |          1101516 | 2015-07-02 
00:29:02 |
| MAC of Device     |          226604 |           761901 | 2015-07-02 
01:43:50 |
| MAC of Device     |           15288 |            11989 | 2015-07-02 
01:47:19 |
| MAC of Device     |           22990 |            54229 | 2015-07-02 
04:06:15 |
| MAC of Device     |           60292 |           165055 | 2015-07-02 
04:07:26 |
| MAC of Device     |               0 |                0 | 2015-07-02 
04:30:46 |
| MAC of Device     |          196851 |           811680 | 2015-07-02 
04:38:57 |
| MAC of Device     |           34725 |            34158 | 2015-07-02 
07:07:31 |
| MAC of Device     |           17383 |            24721 | 2015-07-02 
07:17:34 |
| MAC of Device     |           39313 |            65616 | 2015-07-02 
07:24:14 |
| MAC of Device     |          354304 |          1158021 | 2015-07-03 
01:13:53 |
| MAC of Device     |          334114 |           570187 | 2015-07-03 
01:51:05 |
| MAC of Device     |          212704 |           422752 | 2015-07-03 
04:55:47 |
| MAC of Device     |          301328 |          1245402 | 2015-07-07 
07:36:40 |
| MAC of Device     |           91855 |           267978 | 2015-07-07 
08:16:18 |
| MAC of Device     |          118911 |           324120 | 2015-07-07 
08:36:41 |
| MAC of Device     |           86473 |           329396 | 2015-07-08 
01:55:24 |
| MAC of Device     |          442385 |          3770689 | 2015-07-08 
01:56:13 |
| MAC of Device     |       124448991 |       5465876903 | 2015-07-09 
01:12:29 |
| MAC of Device     |       127366974 |       9757331459 | 2015-07-09 
01:42:45 |
| MAC of Device     |       131368744 |       9744742120 | 2015-07-09 
03:04:56 |
| MAC of Device     |        80610925 |       4877655570 | 2015-07-09 
04:53:02 |
| MAC of Device     |       110464498 |       5096069898 | 2015-07-09 
05:30:39 |
| MAC of Device     |          133285 |           870032 | 2015-07-14 
01:28:06 |
| MAC of Device     |       251748459 |      10893782952 | 2015-07-14 
01:28:54 |
| MAC of Device     |           39804 |            99565 | 2015-07-14 
03:39:47 |
| MAC of Device     |          349453 |          6216738 | 2015-07-14 
03:45:53 |
| MAC of Device     |           13428 |            32963 | 2015-07-14 
04:12:49 |
| MAC of Device     |          165034 |           634026 | 2015-07-20 
05:22:59 |
| MAC of Device     |        82744904 |       5757677242 | 2015-07-20 
05:26:20 |
| MAC of Device     |         6286503 |        436994840 | 2015-07-20 
05:41:35 |
| MAC of Device     |         8937332 |        531312039 | 2015-07-20 
07:36:45 |
| MAC of Device     |         5974933 |        453600467 | 2015-07-20 
07:41:06 |
| MAC of Device     |         1696527 |        115864972 | 2015-07-20 
07:55:07 |
| MAC of Device     |           15832 |           246426 | 2015-07-20 
08:01:41 |
| MAC of Device     |         3415249 |        208973612 | 2015-07-21 
03:05:05 |
| MAC of Device     |         2701508 |        153512871 | 2015-07-21 
03:08:54 |
| MAC of Device     |           21482 |             6456 | 2015-07-28 
09:51:14 |
| MAC of Device     |            8756 |            13620 | 2015-07-28 
09:54:30 |
+------------------+-----------------+------------------+---------------------+
44 rows in set (0.00 sec)

Regards,
Hubert



Am 28.07.2015 um 20:23 schrieb Louis Munro:
>
> On Jul 28, 2015, at 8:37 , Hubert Kupper <ku...@un... 
> <mailto:ku...@un...>> wrote:
>
>> there is traffic on port 1813 from the cisco switch to th server. 
>> tcpdump shows it.
>>
>> mysql> select count(*) from radacct; shows count(*) 44
>
>
> Is the MAC of the device among those listed in radacct?
>
> Something like this should return more:
>
> mysql> select 
> callingstationid,acctinputoctets,acctoutputoctets,acctstarttime from 
> radacct;
>
>
> Regards,
> --
> Louis Munro
> lm...@in... <mailto:lm...@in...>  :: www.inverse.ca 
> <http://www.inverse.ca>
> +1.514.447.4918 x125  :: +1 (866) 353-6153 x125
> Inverse inc. :: Leaders behind SOGo (www.sogo.nu <http://www.sogo.nu>) 
> and PacketFence (www.packetfence.org <http://www.packetfence.org>)
>
>
>
> ------------------------------------------------------------------------------
>
>
> _______________________________________________
> PacketFence-users mailing list
> Pac...@li...
> https://lists.sourceforge.net/lists/listinfo/packetfence-users