Hello Emmanuel,
can you try that in mysql:
SELECT radacct.callingstationid,
SUM(radacct_log.acctinputoctets) AS acctinput,
SUM(radacct_log.acctoutputoctets) AS acctoutput,
SUM(radacct_log.acctinputoctets+radacct_log.acctoutputoctets) AS accttotal
FROM radacct_log
RIGHT JOIN radacct ON radacct_log.acctuniqueid =
radacct.acctuniqueid
WHERE DAY(timestamp) = DAY(CURRENT_DATE()) AND timestamp >= ?
GROUP BY radacct.callingstationid
HAVING accttotal >= ?;
and check if it return some mac address ? (change ? by values)
Regards
Fabrice
Le 2017-07-25 à 11:11, Emmanuel Togo via PacketFence-users a écrit :
Hello Fabrice,
Yes I have.
Jul 25 03:16:12 pf pfmon: pfmon(5757) INFO: [mac:unknown] getting violations
triggers for accounting cleanup (pf::accounting::acct_maintenance)
Jul 25 03:16:12 pf pfmon: pfmon(5757) INFO: [mac:unknown] Found timeframed
accounting policy : TOT2MBD for violation 15000001
(pf::accounting::acct_maintenance)
Regards
Emmanuel
On 7/25/17, 3:37 AM, "Durand fabrice via PacketFence-users"
<[email protected]> wrote:
Hello Emmanuel,
do you have something related to bandwidth violation in pfmon.log ?
Regards
Fabrice
Le 2017-07-19 à 16:08, Emmanuel Togo via PacketFence-users a écrit :
> Hi All
>
> I have upgraded Packetfence-6.5.1 to Packetfence-7.2.0 and bandwidth
> violation of 100MB/Day stop working. Nothing happens when a client uses
more than
> 100MB traffic.
>
> Regards
> Emmanuel
>
>
> DISCLAIMER ------------------ NOTE: This e-mail message is subject to
the University of Ghana email disclaimer see
http://www.ug.edu.gh/ugemaildisclaimer for disclaimer.
>
------------------------------------------------------------------------------
> 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
------------------------------------------------------------------------------
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
DISCLAIMER ------------------ NOTE: This e-mail message is subject to the
University of Ghana email disclaimer see http://www.ug.edu.gh/ugemaildisclaimer
for disclaimer.
------------------------------------------------------------------------------
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
------------------------------------------------------------------------------
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
