an you do that:
select * from radacct_log where username="08:ee:8b:8c:2e:35";
does it return something ?
Le 2017-07-25 à 19:30, Emmanuel Togo via PacketFence-users a écrit :
Hello Fabrice,
Thank you. See the output below
+-------------------+-----------+------------+-----------+
| callingstationid | acctinput | acctoutput | accttotal |
+-------------------+-----------+------------+-----------+
| 08:ee:8b:8c:2e:35 | 0 | 0 | 0 |
| 10:2f:6b:7d:87:1b | 0 | 0 | 0 |
| 1c:23:2c:c2:7e:33 | 0 | 0 | 0 |
| 20:64:32:c8:18:7c | 0 | 0 | 0 |
| 30:c7:ae:68:2c:7c | 0 | 0 | 0 |
| 34:31:11:27:65:09 | 0 | 0 | 0 |
| 3c:83:75:c3:38:d9 | 0 | 0 | 0 |
| 48:5a:3f:84:75:64 | 0 | 0 | 0 |
| 64:89:9a:14:82:6f | 0 | 0 | 0 |
| 78:ff:ca:14:4d:e4 | 0 | 0 | 0 |
| 78:ff:ca:51:5e:d9 | 0 | 0 | 0 |
| 78:ff:ca:6d:97:bf | 0 | 0 | 0 |
| 84:2e:27:05:f5:9c | 0 | 0 | 0 |
| 84:38:38:6e:45:08 | 0 | 0 | 0 |
| a4:5e:60:f2:62:e5 | 0 | 0 | 0 |
| a8:bb:cf:05:1b:4c | 0 | 0 | 0 |
| ac:37:43:62:a1:8d | 0 | 0 | 0 |
| c0:bd:d1:2e:15:1e | 0 | 0 | 0 |
| c4:9a:02:8e:65:d4 | 0 | 0 | 0 |
| cc:5f:bf:2e:c2:5d | 0 | 0 | 0 |
| d0:22:be:d7:9b:ba | 0 | 0 | 0 |
| e8:4e:84:da:48:ed | 0 | 0 | 0 |
| f0:99:bf:28:f1:6c | 0 | 0 | 0 |
| f0:fc:97:c1:58:cf | 0 | 0 | 0 |
+-------------------+-----------+------------+-----------+
24 rows in set, 1 warning (0.00 sec)
On 7/25/17, 11:05 PM, "Durand fabrice via PacketFence-users"
<packetfence-users@lists.sourceforge.net> wrote:
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"
<packetfence-users@lists.sourceforge.net> 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
> > PacketFence-users@lists.sourceforge.net
> > 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
> PacketFence-users@lists.sourceforge.net
> 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
> PacketFence-users@lists.sourceforge.net
> 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
PacketFence-users@lists.sourceforge.net
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
PacketFence-users@lists.sourceforge.net
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
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
