Freeradius-Users Digest, Vol 136, Issue 55

[Mohamad Yazdian]

I think I have problem with sqlcounter...!!!
I can't monitor periodicaly user information from radacct.
My NAS send each 10 second data to my freeradius so freeradius get this
data and save they on the radacct table but I can't rum the appropriate
event between them.
For example when total download /upload user from radacct > 1G then
disconnect the user connection.
I can not see any request on the Mikrotik Radius Incoming.

I do much more google it but just I find this configuration for freeradius
sqlcounter but it's not work fine.

On Sun, Aug 28, 2016 at 1:00 PM, <
freeradius-users-request at lists.freeradius.org> wrote:

> Send Freeradius-Users mailing list submissions to
>         freeradius-users at lists.freeradius.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://lists.freeradius.org/mailman/listinfo/freeradius-users
> or, via email, send a message with subject or body 'help' to
>         freeradius-users-request at lists.freeradius.org
>
> You can reach the person managing the list at
>         freeradius-users-owner at lists.freeradius.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Freeradius-Users digest..."
>
>
> Today's Topics:
>
>    1. Re: Disconnect user when hit bandwith (Alan DeKok)
>    2. Re: Disconnect user when hit bandwith (Vijay S)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 27 Aug 2016 07:58:42 -0400
> From: Alan DeKok <aland at deployingradius.com>
> To: FreeRadius users mailing list
>         <freeradius-users at lists.freeradius.org>
> Subject: Re: Disconnect user when hit bandwith
> Message-ID: <0B7ADD16-C1B8-4E76-B03F-F0AB4DA6DCD2 at deployingradius.com>
> Content-Type: text/plain; charset=us-ascii
>
> On Aug 26, 2016, at 2:10 PM, Mohamad Yazdian <m.programer at gmail.com>
> wrote:
> > I use the Mikrotik-Total-Limit in my sqlcounter and add this counter name
> > on the radcheck table for my users so when my users hit the 1G bandwith
> (1
> > week etc.) the connections are not droped...!!!
>
>   Ask Mikrotik why their NAS doesn't work.
>
>   Alan DeKok.
>
>
>
> ------------------------------
>
> Message: 2
> Date: Sun, 28 Aug 2016 12:09:43 +0530
> From: Vijay S <vijay.hcr at gmail.com>
> To: FreeRadius users mailing list
>         <freeradius-users at lists.freeradius.org>
> Subject: Re: Disconnect user when hit bandwith
> Message-ID:
>         <CAPTJ3-drCEwsDgxJC+QeXxkKrKexDOAQQg9Yw8999DERmHyo
> UQ at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Hi Mohamad,
> Set reply value of 1g manually for user and see if it disconnect on usage
> of 1g  in mikrotik nas before diving into freeradius configuration details.
> Once you sure that your nas is doing what it meant to do then you can start
> digging into FR config.
>
> Regards
> Vijay A.
> +91 9930804010
>
> On Aug 26, 2016 11:41 PM, "Mohamad Yazdian" <m.programer at gmail.com> wrote:
>
> Hello
> I use freeradius for authenticate my PPPoE users and I NAS router is
> mikrotik.
> every think is fine like as authentication and expiration in the monthly
> date but now I like to limit my users for 1G downloadn per month but when I
> make a sqlcounter and add this counter to the site-available default
> (authorize{}).
>
> I use the Mikrotik-Total-Limit in my sqlcounter and add this counter name
> on the radcheck table for my users so when my users hit the 1G bandwith (1
> week etc.) the connections are not droped...!!!
> But when the users disconnect the pppoe connection and try again to connect
> get the access denied message.
>
> I like to dissconnect the pppoe connection when hit 1G.
>
> Please advise me how to solve this issue.
>
> Thank you
>
> sqlcounter  sample_Limit{
> counter-name = Mikrotik-Total-Limit
>                 check-name = Mikrotik-Total-Limit
>                 reply-name = Mikrotik-Total-Limit
>                 sqlmod-inst = sql
>                 key = User-Name
>                 reset = never
>                 query = "SELECT
> ((SUM(AcctInputOctets)+SUM(AcctOutputOctets))) FROM radacct WHERE
> UserName='%{%k}'"
> }
>
>
> sample_Limit{
> reject = 1
> }
> if(reject){
> update reply {
> Reply-Message := "You have reached your bandwidth limit"
> }
> reject
> }
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/
> list/users.html
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/
> list/users.html
>
> ------------------------------
>
> End of Freeradius-Users Digest, Vol 136, Issue 55
> *************************************************
>