radacct MySQL table only gets filled with the last session values for a given user ( no history logging )
oatech
oatech7402 at gmail.com
Thu Mar 24 14:14:12 CET 2016
Client : Windows 10
NAS : Cisco SB WAP121
RADIUS Server : Debian 8 / FreeRADIUS Version 2.2.5, for host
x86_64-pc-linux-gnu,
Authentication : PEAP/MSCHAPv2
While the /varl/log/freeradius/radacct/192.168.1.2/detail-20160324 files
gets filled with correct data values for each user session :
sudo cat /var/log/freeradius/radacct/192.168.1.2/detail-20160324 | grep
Acct-Input-Octets
Acct-Input-Octets = 43976
Acct-Input-Octets = 845
Acct-Input-Octets = 394240
Acct-Input-Octets = 371260
Acct-Input-Octets = 24927
the radacct MySQL table only gets filled with the last session values for a
given user ( 24927 here ). There is no history logging :
mysql> select radacct.username, radacct.nasipaddress, radacct.acctstarttime,
radacct.acctstoptime, radacct.acctinputoctets, radacct.acctoutputoctets
from radacct;
+-----------+---------------+---------------------+---------------------+-----------------+------------------+
| username | nasipaddress | acctstarttime | acctstoptime |
acctinputoctets | acctoutputoctets |
+-----------+---------------+---------------------+---------------------+-----------------+------------------+
| User1 | 192.168.1.2 | 2016-03-24 08:44:46 | 2016-03-24 08:44:23 |
24927 | 20814 |
| User2 | 192.168.1.2 | 2016-03-24 08:40:33 | 2016-03-24 08:42:22 |
0 | 0 |
+-----------+---------------+---------------------+---------------------+-----------------+------------------+
2 rows in set (0.00 sec)
2 rows in set (0.00 sec)
Is this the normal expected behaviour ? I highy doubt it.
I must have done something wrong, but I'm using a very standard
Freeradius/MySQL install.
Any help would be greatly appreciated :-)
---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus
More information about the Freeradius-Users
mailing list