[EXTERNAL] Re: Get number of users logged in via mySQL
rensousa at gmail.com
Mon Jan 7 20:56:49 CET 2019
Is it possible then to end these sessions by setting a maximum duration for
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.
> 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
> >>> 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
> b) the NAS isn't sending FreeRADIUS "stop" packets when a session
> There really aren't any other options.
> > Most of my APs are Ubiquiti, but I also have Cisco, HP, and Aruba on
> > 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
> Alan DeKok.
> List info/subscribe/unsubscribe? See
> 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
> List info/subscribe/unsubscribe? See
More information about the Freeradius-Users