Radacct Reused ?

[Oscar]

-----Mensaje original-----
De: Freeradius-Users
<freeradius-users-bounces+oscar=jofre.com at lists.freeradius.org> En nombre de
Oscar
Enviado el: martes, 16 de abril de 2019 23:52
Para: 'FreeRadius users mailing list'
<freeradius-users at lists.freeradius.org>
Asunto: Radacct Reused ?

Hi,

 

I've created a Trigger to save on a new table the las time a user has been
stop connection (acctstoptime).

 

So I've createad table and created this trigger:

 

                create TRIGGER UpdateStopTime AFTER UPDATE ON radacct

                FOR EACH ROW 

                BEGIN

                               INSERT into usuario_instalacion_stoptime (

                                                               select
u.department as user,u.company as insta,if(r.acctstoptime is
null,now(),r.acctstoptime) stoptime 

                                                                from radacct
r,userinfo u where r.username=u.username  and r.radacctid=NEW.radacctid

                               ) ON DUPLICATE KEY UPDATE
stoptime=if(NEW.acctstoptime is null,now(),NEW.acctstoptime) ;

 

                END$$

 

 

But now I'm facing that sems that radius rows from the past are beeign used
on the present

 

I mean, my radacctid is now arround 37.000.000

 

And I can see a user autheticated and updating a really old row:
accstoptime=09-2018 and beeing update today with accstarttime=04-2019

 



 

 

How is that possible ?

 

Is it correct ?

 

 

Thanks,