raddebug ...
Le 2017-08-17 à 06:12, Emmanuel Togo a écrit :
>
> Hello Fabrice,
>
> raddebuf command is not available.
>
>
> Regards
>
> Emmanuel
>
>
>
> ------------------------------------------------------------------------
> *From:* Durand fabrice via PacketFence-users
> <packetfence-users@lists.sourceforge.net>
> *Sent:* 26 July 2017 11:59 PM
> *To:* packetfence-users@lists.sourceforge.net
> *Cc:* Durand fabrice
> *Subject:* Re: [PacketFence-users] Packetfence-ZEN-7.2.0 bandwidth
> violation not working
>
> Hello Emmanuel,
>
> it looks that there is just start in your accounting (a way to send
> interim update and stop from the AP/Switch ?).
>
> Can you check with:
>
> raddebuf -f /usr/local/pf/run/radius-acct.sock -t 300
>
> and paste few requests ?
>
> Regards
>
> Fabrice
>
>
>
> Le 2017-07-26 à 03:38, Emmanuel Togo via PacketFence-users a écrit :
> > Hello Fabrice,
> > Thank you once again.
> > The username in radacct_log is different from mac address. See below
> the output
> >
> > MariaDB [pf]> select * from radacct_log where username="sophos5";
> >
> +------+-------------------+----------+--------------+----------------+---------------------+-----------------+------------------+-----------------+----------------------------------+
> > | id | acctsessionid | username | nasipaddress |
> acctstatustype | timestamp | acctinputoctets |
> acctoutputoctets | acctsessiontime | acctuniqueid |
> >
> +------+-------------------+----------+--------------+----------------+---------------------+-----------------+------------------+-----------------+----------------------------------+
> > | 772 | 0000002C-00000019 | sophos5 | 10.1.5.145 |
> Start | 2017-07-20 02:54:44 | 0
> | 0 | 0 | c594c1423a7cde15a0d2ed85743f1d4a |
> > | 793 | 0000002C-00000026 | sophos5 | 10.1.5.145 |
> Start | 2017-07-20 09:56:48 | 0
> | 0 | 0 | 22775775af347dee8d387e13406c5f5f |
> > | 795 | 0000002C-00000027 | sophos5 | 10.1.5.145 |
> Start | 2017-07-20 09:58:30 | 0
> | 0 | 0 | 4ac58d4ddec42d583960a1982f32d62b |
> > | 797 | 0000002C-00000028 | sophos5 | 10.1.5.145 |
> Start | 2017-07-20 10:00:58 | 0
> | 0 | 0 | 4ac58d4ddec42d583960a1982f32d62b |
> > | 909 | 00010B4E-00000035 | sophos5 | 10.1.5.145 |
> Start | 2017-07-20 15:03:04 | 0
> | 0 | 0 | 22775775af347dee8d387e13406c5f5f |
> > | 915 | 00010B4E-00000038 | sophos5 | 10.1.5.145 |
> Start | 2017-07-20 15:25:21 | 0
> | 0 | 0 | 22775775af347dee8d387e13406c5f5f |
> > | 921 | 00010B4E-0000003C | sophos5 | 10.1.5.145 |
> Start | 2017-07-20 15:40:29 | 0
> | 0 | 0 | 22775775af347dee8d387e13406c5f5f |
> > | 925 | 00010B4E-0000003F | sophos5 | 10.1.5.145 |
> Start | 2017-07-20 15:46:58 | 0
> | 0 | 0 | 22775775af347dee8d387e13406c5f5f |
> > | 929 | 00010B4E-00000040 | sophos5 | 10.1.5.145 |
> Start | 2017-07-20 15:51:01 | 0
> | 0 | 0 | 22775775af347dee8d387e13406c5f5f |
> > | 1008 | 00010B4E-00000064 | sophos5 | 10.1.5.145 |
> Start | 2017-07-21 10:23:59 | 0
> | 0 | 0 | c594c1423a7cde15a0d2ed85743f1d4a |
> > | 1038 | 00010B4E-00000073 | sophos5 | 10.1.5.145 |
> Start | 2017-07-21 12:50:49 | 0
> | 0 | 0 | c594c1423a7cde15a0d2ed85743f1d4a |
> > | 1232 | 00007844-0000000E | sophos5 | 10.1.5.145 |
> Start | 2017-07-24 16:54:10 | 0
> | 0 | 0 | ce7983729464e2b0b3cf6174c4f9e837 |
> > | 1286 | 00007844-00000028 | sophos5 | 10.1.5.145 |
> Start | 2017-07-25 11:20:12 | 0
> | 0 | 0 | 22775775af347dee8d387e13406c5f5f |
> >
> +------+-------------------+----------+--------------+----------------+---------------------+-----------------+------------------+-----------------+----------------------------------+
> > 13 rows in set (0.00 sec)
> >
> >
> > Regards
> > Emmanuel
> >
> > On 7/26/17, 1:22 AM, "Durand fabrice via PacketFence-users"
> <packetfence-users@lists.sourceforge.net> wrote:
> >
> > 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
> <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 <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 <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 <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 <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
> DISCLAIMER ------------------ NOTE: This e-mail message is subject to
> the University of Ghana email disclaimer see
> http://www.ug.edu.gh/ugemaildisclaimer for disclaimer.
--
Fabrice Durand
fdur...@inverse.ca :: +1.514.447.4918 (x135) :: www.inverse.ca
Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence
(http://packetfence.org)
------------------------------------------------------------------------------
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
