Freeradius Not working with Bits limit for Hotspots

[Alan DeKok]

On Jul 5, 2021, at 11:49 AM, Jahans Solutions <jahans.solutions at gmail.com> wrote:
> I have acquired a freeradius server which i currently manage. I am facing
> some issues with it. All hotspot users are getting disconnected after using
> 2gb. As per debug what i have seen is that freeradius is receiving an
> attribute Mikrotik-Total-Limit with 2147483648  I cannot find where this
> attribute is coming from.. Also there is no Mikrotik-Total-Limit  on
> radgroupreply. It is driving me crazy. Can someone help me with this? I
> have attached three debug reports.

  Which are... what?  You're leaving us to figure out what's going on.  The next time, PLEASE describe what each debug is, and what it's supposed to be.   The harder you make it for us to help you, the less likely we are to help.

  And PLEASE also follow the guidelines at http://wiki.freeradius.org/list-help .  These guidelines are also sent to you when you join the list.  We need to see NORMAL debug output, and not anything else.  

  And posting debug output in-line is much better than attaching files.

  FreeRADIUS doesn't "receive" Mikrotik-Total-Limit with 2147483648.  It sends that in the Access-Accept.

  If you read the rest of the debug output, and look for Mikrotik-Total-Limit or  2147483648, you'll see:

Mon Jul  5 17:44:43 2021 : Debug: (0) sql: Group "HSP6G-20day": Merging reply items
Mon Jul  5 17:44:43 2021 : Debug: (0) sql:   WISPr-Bandwidth-Max-Down := 52428800
Mon Jul  5 17:44:43 2021 : Debug: (0) sql:   WISPr-Bandwidth-Max-Up := 52428800
Mon Jul  5 17:44:43 2021 : Debug: (0) sql:   Simultaneous-Use := 1
Mon Jul  5 17:44:43 2021 : Debug: (0) sql:   Max-All-Session := 1728000
Mon Jul  5 17:44:43 2021 : Debug: (0) sql:   Max-All-MB := 2147483648
...
Mon Jul  5 17:44:43 2021 : Debug: rlm_sql (sql): Released connection (2)
Mon Jul  5 17:44:43 2021 : Debug: (0) maximum_mbs: EXPAND %{sql:SELECT IFNULL((SUM(AcctInputOctets)+SUM(AcctOutputOctets)),0) FROM radacct WHERE UserName='%{Use                                                                                                          r-Name}'}
Mon Jul  5 17:44:43 2021 : Debug: (0) maximum_mbs:    --> 0
Mon Jul  5 17:44:43 2021 : Debug: (0) maximum_mbs: Allowing user, &control:Max-All-MB value (2147483648) is greater than counter value (0)
Mon Jul  5 17:44:43 2021 : Debug: (0) maximum_mbs: Setting &reply:Mikrotik-Total-Limit value to 2147483648
Mon Jul  5 17:44:43 2021 : Debug: (0)     modsingle[authorize]: returned from maximum_mbs (rlm_sqlcounter)

  Look in SQL for Max-All-MB, and then read the sqlcounter configuration.

  Alan DeKok.