[EXTERNAL] Re: Get number of users logged in via mySQL

Renato Sousa rensousa at gmail.com
Mon Jan 7 20:56:49 CET 2019

Hello Alister,

Is it possible then to end these sessions by setting a maximum duration for
the session?
Something like a script running periodically by setting NOW () the
acctstoptime field for sessions longer than X hours.


Em ter, 18 de dez de 2018 às 05:59, Winfield, Alister via Freeradius-Users <
freeradius-users at lists.freeradius.org> escreveu:

> Remember that for an AP the concept of when a session stops is not as
> clear cut as you might imagine. Worst case is you won't see a stop until
> the DHCP lease expires or perhaps when the AP gives up on a devices
> association having not seen it for a while. What this normally means is
> that there can be many 'sessions' for a single device in your network. If
> you can guarantee that one identity can NEVER appear in two places then
> just change your SQL to only count the last session to start for each
> unique identity. Here remember if AP's are close enough together devices
> could 'flip-flop' between them so concepts like never tend to be more or
> less impossible to guarantee.
> --
> Alister
> On 17/12/2018, 19:51, "Freeradius-Users on behalf of Alan DeKok"
> <freeradius-users-bounces+alister.winfield=sky.uk at lists.freeradius.org on
> behalf of aland at deployingradius.com> wrote:
>     On Dec 17, 2018, at 11:54 AM, Renato Sousa <rensousa at gmail.com> wrote:
>     >>> Yes ... If the information provided by NAS were correct a sentence
> as
>     >>> below would solve the question:
>     >>
>     >> select count (*) from radaact where acctstoptime is null;
>       If the NAS is lying to FreeRADIUS, then there is little you can do.
>     >>> However, when I go to analyze the selected records, I see repeated
>     >>> records with the same device mac-address.
>     >>
>     >> Right now I saw that my user does not have an open session on
> radius. :(
>       I don't know what that means.  More correctly, I don't know what
> *you* think that means.
>       The radacct table just stores the data sent by the NAS.  If there
> are multiple session in the DB for a user, then:
>     a) the user has multiple sessions
>       or
>     b) the NAS isn't sending FreeRADIUS "stop" packets when a session
> closes.
>       There really aren't any other options.
>     > Most of my APs are Ubiquiti, but I also have Cisco, HP, and Aruba on
> my
>     > infraestructure. Is there any incompatibility with these
> manufacturers when
>     > users move from one to another?
>       No.  They just send RADIUS packets.
>     > Anyone have any tips to improve this diagnosis?
>       Look on the NAS to see which users are online.  Most NASes should
> provide an admin interface to do this.
>     >>> How to delete these open sessions?
>     >>
>     >>  SQL statements.
>     >>
>     > I have already done an UPDATE in the tables to insert date in the old
>     > records with acctstoptime equal to NULL, however they continue to be
>     > generated.
>       Then the user has multiple sessions.  You will need to configure
> Simultaneous-Use to ensure that each user has only one session active at a
> time.
>       Alan DeKok.
>     -
>     List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>     --------------------------------------------------------------------
>     This email is from an external source. Please do not open attachments
> or click links from an unknown or suspicious origin. Phishing attempts can
> be reported by sending them to phishing at sky.uk as attachments. Thank you
>     --------------------------------------------------------------------
> Information in this email including any attachments may be privileged,
> confidential and is intended exclusively for the addressee. The views
> expressed may not be official policy, but the personal views of the
> originator. If you have received it in error, please notify the sender by
> return e-mail and delete it from your system. You should not reproduce,
> distribute, store, retransmit, use or disclose its contents to anyone.
> Please note we reserve the right to monitor all e-mail communication
> through our internal and external networks. SKY and the SKY marks are
> trademarks of Sky plc and Sky International AG and are used under licence.
> Sky UK Limited (Registration No. 2906991), Sky-In-Home Service Limited
> (Registration No. 2067075), Sky Subscribers Services Limited (Registration
> No. 2340150) and Sky CP Limited (Registration No. 9513259) are direct or
> indirect subsidiaries of Sky plc (Registration No. 2247735). All of the
> companies mentioned in this paragraph are incorporated in England and Wales
> and share the same registered office at Grant Way, Isleworth, Middlesex TW7
> 5QD
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html

More information about the Freeradius-Users mailing list