Ok this my Notebook wifi adapter (E4:B3:18:2C:E0:C0) and 192.168.7.221
is a Cisco WLC. No problem here, the accounting data looks ok:
MariaDB [pf]> select * from radacct_log where
acctuniqueid="c16c078f963c875d37013c5cba979106";
+--------+----------------------------------+---------------------+---------------+----------------+---------------------+-----------------+------------------+-----------------+----------------------------------+
| id | acctsessionid | username |
nasipaddress | acctstatustype | timestamp | acctinputoctets |
acctoutputoctets | acctsessiontime | acctuniqueid |
+--------+----------------------------------+---------------------+---------------+----------------+---------------------+-----------------+------------------+-----------------+----------------------------------+
| 145688 | 5a042efb/e4:b3:18:2c:e0:c0/7093 | APRA=5C=5Cc.mammoli |
192.168.7.221 | Start | 2017-11-09 11:33:31 | 0
| 0 | 0 | c16c078f963c875d37013c5cba979106 |
| 145705 | 5a042efb/e4:b3:18:2c:e0:c0/7093 | APRA=5C=5Cc.mammoli |
192.168.7.221 | Interim-Update | 2017-11-09 11:35:03 | 5803
| 8401 | 93 | c16c078f963c875d37013c5cba979106 |
| 145784 | 5a042efb/e4:b3:18:2c:e0:c0/7093 | APRA=5C=5Cc.mammoli |
192.168.7.221 | Stop | 2017-11-09 11:40:29 | 223227
| 44823 | 326 | c16c078f963c875d37013c5cba979106 |
| 183214 | 5a0aa387/e4:b3:18:2c:e0:c0/11165 | APRA=5C=5Cc.mammoli |
192.168.7.221 | Start | 2017-11-14 09:04:24 | 0
| 0 | 0 | c16c078f963c875d37013c5cba979106 |
| 183481 | 5a0aa387/e4:b3:18:2c:e0:c0/11165 | APRA=5C=5Cc.mammoli |
192.168.7.221 | Stop | 2017-11-14 09:15:25 | 6705186
| 63346445 | 661 | c16c078f963c875d37013c5cba979106 |
+--------+----------------------------------+---------------------+---------------+----------------+---------------------+-----------------+------------------+-----------------+----------------------------------+
5 rows in set (0.00 sec)
This is my ethernet Adapter (84:7B:EB:4A:52:05), here the traffic looks
"out of scale", the same happens for everyone on this switches.
MariaDB [pf]> select * from radacct_log where
acctuniqueid="085b986ead6b7d9a6951d1486493d889";
+--------+---------------+---------------------+---------------+----------------+---------------------+-----------------+------------------+-----------------+----------------------------------+
| id | acctsessionid | username | nasipaddress |
acctstatustype | timestamp | acctinputoctets |
acctoutputoctets | acctsessiontime | acctuniqueid |
+--------+---------------+---------------------+---------------+----------------+---------------------+-----------------+------------------+-----------------+----------------------------------+
| 143611 | 00001212 | APRA=5C=5Cc.mammoli | 192.168.16.43 |
Start | 2017-11-09 09:01:15 | 0 |
0 | 0 | 085b986ead6b7d9a6951d1486493d889 |
| 143612 | 00001212 | APRA=5C=5Cc.mammoli | 192.168.16.43 |
Interim-Update | 2017-11-09 09:01:15 | 2512995005 | 2056003245
| 0 | 085b986ead6b7d9a6951d1486493d889 |
| 143613 | 00001212 | APRA=5C=5Cc.mammoli | 192.168.16.43 |
Interim-Update | 2017-11-09 09:01:15 | 2512995005 | 2056003245
| 0 | 085b986ead6b7d9a6951d1486493d889 |
| 144184 | 00001212 | APRA=5C=5Cc.mammoli | 192.168.16.43 |
Stop | 2017-11-09 09:32:36 | 6535801 | 64990835
| 1881 | 085b986ead6b7d9a6951d1486493d889 |
| 144373 | 00001217 | APRA=5C=5Cc.mammoli | 192.168.16.43 |
Start | 2017-11-09 09:45:34 | 0 |
0 | 0 | 085b986ead6b7d9a6951d1486493d889 |
| 146834 | 00001217 | APRA=5C=5Cc.mammoli | 192.168.16.43 |
Interim-Update | 2017-11-09 12:46:07 | 2543121066 | 2372276848
| 0 | 085b986ead6b7d9a6951d1486493d889 |
| 149206 | 00001217 | APRA=5C=5Cc.mammoli | 192.168.16.43 |
Interim-Update | 2017-11-09 15:46:40 | 29469179 | 261831473
| 0 | 085b986ead6b7d9a6951d1486493d889 |
| 149848 | 00001217 | APRA=5C=5Cc.mammoli | 192.168.16.43 |
Stop | 2017-11-09 16:40:12 | 7283459 | 86594327
| 3212 | 085b986ead6b7d9a6951d1486493d889 |
+--------+---------------+---------------------+---------------+----------------+---------------------+-----------------+------------------+-----------------+----------------------------------+
8 rows in set (0.00 sec)
MariaDB [pf]> select * from radacct_log where
acctuniqueid="a707be366d38eae790c9baf62fb087df";
+--------+---------------+-------------------------+---------------+----------------+---------------------+-----------------+------------------+-----------------+----------------------------------+
| id | acctsessionid | username | nasipaddress |
acctstatustype | timestamp | acctinputoctets |
acctoutputoctets | acctsessiontime | acctuniqueid |
+--------+---------------+-------------------------+---------------+----------------+---------------------+-----------------+------------------+-----------------+----------------------------------+
| 149849 | 00001222 | host/NB-MAMMOLI.apra.it | 192.168.16.43 |
Start | 2017-11-09 16:40:12 | 0 |
0 | 0 | a707be366d38eae790c9baf62fb087df |
| 149855 | 00001222 | host/NB-MAMMOLI.apra.it | 192.168.16.43 |
Stop | 2017-11-09 16:40:22 | 2579924138 | 2720777597
| 9 | a707be366d38eae790c9baf62fb087df |
+--------+---------------+-------------------------+---------------+----------------+---------------------+-----------------+------------------+-----------------+----------------------------------+
2 rows in set (0.00 sec)
MariaDB [pf]>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
