Testing it on Mikrotik 5.20 and 6.34.x Same issue that user dont get auto disconnect when quota reaches limit. [however they get access denied on there next login]
> Date: Wed, 16 Mar 2016 08:34:38 -0400 > From: [email protected] > To: [email protected] > Subject: Re: [Mikrotik] mikrotik with freeradius Quota exceed auto > disconnection not working > > What version of Mikrotik? > > On Wed, March 16, 2016 6:16 am, JAHANZAIB SYED wrote: > > I am using Mikrotik with FREERADIUS 2.x. Radius Incoming is enabled with > > port 1700. > > > > My problem is that after user reaches his quota limit , he does not gets > > disconnect automatically. If I disconnect him myself and he try to > > reconnect then he gets access denied. how this disconnection can be made > > automatically? > > > > Using following sql counter. > > > > > > sqlcounter totalbytecounter { counter-name = Mikrotik-Total-Limit > > check-name = Mikrotik-Total-Limit reply-name = Mikrotik-Total-Limit > > reply-message = "You have reached your bandwidth limit" sqlmod-inst = sql > > key = User-Name reset = never query = "SELECT > > ((SUM(AcctInputOctets)+SUM(AcctOutputOctets))) FROM radacct WHERE > > UserName='%{%k}'" > > } > > > > > > Also I have defined this under authorize section in > > /etc/freeradius/sites-enabled/default > > > > > > totalbytecounter > > > > Help Please. > > > > > > > > > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > URL: > > <http://mail.butchevans.com/pipermail/mikrotik/attachments/20160316/4ce02 > > 42d/attachment.html> > > _______________________________________________ > > Mikrotik mailing list > > [email protected] > > http://mail.butchevans.com/mailman/listinfo/mikrotik > > > > > > Visit http://blog.butchevans.com/ for tutorials related to Mikrotik > > RouterOS > > > > > > > _______________________________________________ > Mikrotik mailing list > [email protected] > http://mail.butchevans.com/mailman/listinfo/mikrotik > > Visit http://blog.butchevans.com/ for tutorials related to Mikrotik RouterOS -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mail.butchevans.com/pipermail/mikrotik/attachments/20160317/74cc3f9f/attachment.html> _______________________________________________ Mikrotik mailing list [email protected] http://mail.butchevans.com/mailman/listinfo/mikrotik Visit http://blog.butchevans.com/ for tutorials related to Mikrotik RouterOS
