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 <kup...@uni-landau.de
<mailto:kup...@uni-landau.de>> 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
lmu...@inverse.ca <mailto:lmu...@inverse.ca> :: 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
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
